madchap/graphql_github_pr_query.sh

## graphql_github_pr_query.sh
#!/usr/bin/env bash
set -e
set -o pipefail

OUTPUT=$(curl -s --location --request POST 'https://api.github.com/graphql' \
--header "Authorization: Bearer $GH_TOKEN" \
--header 'Content-Type: application/json' \
--data-raw '{"query":"{\n  search(first: 50, query: \"repo:DefectDojo/django-DefectDojo is:pr is:merged created:2020-03-12..2020-04-11\", type: ISSUE) {\n    nodes {\n      ... on PullRequest {\n        number\n        title\n        url\n        author { login }\n      }\n    }\n  }\n}","variables":{}}')

echo "$OUTPUT" | jq -r '.data.search.nodes[] | [.number, .author.login, .title, .url] |@csv' | tr -d \" | awk -v FS="," 'BEGIN{OFS="\n";}{printf "- %s @%s [#%i](%s)\n",$3,$2,$1,$4}'
	#!/usr/bin/env bash
	set -e
	set -o pipefail

	OUTPUT=$(curl -s --location --request POST 'https://api.github.com/graphql' \
	--header "Authorization: Bearer $GH_TOKEN" \
	--header 'Content-Type: application/json' \
	--data-raw '{"query":"{\n search(first: 50, query: \"repo:DefectDojo/django-DefectDojo is:pr is:merged created:2020-03-12..2020-04-11\", type: ISSUE) {\n nodes {\n ... on PullRequest {\n number\n title\n url\n author { login }\n }\n }\n }\n}","variables":{}}')

	echo "$OUTPUT" \| jq -r '.data.search.nodes[] \| [.number, .author.login, .title, .url] \|@csv' \| tr -d \" \| awk -v FS="," 'BEGIN{OFS="\n";}{printf "- %s @%s [#%i](%s)\n",$3,$2,$1,$4}'