PGSQL_CONTAINER_ID=`cat postgres.container.id`

updatedb: startdb
	./jira_analysis api-sync https://tegra118.atlassian.net jonathan.bernard@fiserv.com mS5cT0YntfQ6KYT0OWgb6A10

createdb:
	docker run \
		--name postgres-tegra118 \
		-e POSTGRES_PASSWORD=password \
		-p 5500:5432 \
		-d postgres \
		> postgres.container.id
	sleep 5
	PGPASSWORD=password psql -p 5500 -U postgres -h localhost \
		-c 'CREATE DATABASE tegra118;'

startdb:
	docker start $(PGSQL_CONTAINER_ID)

stopdb:
	docker stop $(PGSQL_CONTAINER_ID)

deletedb:
	-docker stop $(PGSQL_CONTAINER_ID)
	docker rm $(PGSQL_CONTAINER_ID)
	rm postgres.container.id

connect:
	PGPASSWORD=password psql -p 5500 -U postgres -h localhost tegra118

update-fields:
	curl -u 'jonathan.bernard@fiserv.com:mS5cT0YntfQ6KYT0OWgb6A10' 'https://tegra118.atlassian.net/rest/api/3/field' | jq . > fields.json

update-sample:
	curl -u 'jonathan.bernard@fiserv.com:mS5cT0YntfQ6KYT0OWgb6A10' 'https://tegra118.atlassian.net/rest/api/3/search?jql=project%20%3D%20"UUP"%20and%20(labels%20is%20empty%20or%20labels%20!%3D%20"Design%26Reqs")%20ORDER%20BY%20key%20ASC&fields=summary,assignee,issuetype,customfield_10014,issuelinks,resolutiondate,status,customfield_10218,resolution,fixVersions,versions,customfield_10001&expand=changelog' | jq . > all-issues-filtered-fields.json