2021-04-02 18:31:35 +00:00
|
|
|
PGSQL_CONTAINER_ID=`cat postgres.container.id`
|
|
|
|
|
|
2022-06-11 04:52:05 +00:00
|
|
|
updatedb: startdb
|
|
|
|
|
./jira_analysis api-sync https://tegra118.atlassian.net jonathan.bernard@fiserv.com mS5cT0YntfQ6KYT0OWgb6A10
|
|
|
|
|
|
2021-04-02 18:31:35 +00:00
|
|
|
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
|
2022-06-11 04:52:05 +00:00
|
|
|
|
|
|
|
|
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
|
