2020-repositories.json

{"nameWithOwner": "podhmo/cliauth", "createdAt": "2020-01-08T14:08:56Z"}
{"nameWithOwner": "podhmo/minitask", "createdAt": "2020-01-26T08:09:01Z"}
{"nameWithOwner": "podhmo/snatch", "createdAt": "2020-02-01T06:28:14Z"}
{"nameWithOwner": "podhmo/scoop-buckets", "createdAt": "2020-03-13T14:50:54Z"}
{"nameWithOwner": "podhmo/baku", "createdAt": "2020-03-23T16:19:22Z"}
{"nameWithOwner": "podhmo/egoist", "createdAt": "2020-04-21T20:34:34Z"}
{"nameWithOwner": "podhmo/maperr", "createdAt": "2020-05-03T06:47:54Z"}
{"nameWithOwner": "podhmo/typoless", "createdAt": "2020-05-29T21:48:10Z"}
{"nameWithOwner": "podhmo/sheetconf", "createdAt": "2020-07-04T08:22:49Z"}
{"nameWithOwner": "podhmo/startevent", "createdAt": "2020-09-22T14:11:50Z"}
{"nameWithOwner": "podhmo/tenuki", "createdAt": "2020-09-26T23:12:42Z"}
{"nameWithOwner": "podhmo/reflect-openapi", "createdAt": "2020-10-03T05:50:01Z"}
{"nameWithOwner": "podhmo/starlette-dataframe-response", "createdAt": "2020-10-30T16:17:07Z"}
{"nameWithOwner": "podhmo/inflexible", "createdAt": "2020-11-28T21:09:31Z"}

list-repository.query

query($endCursor: String) {
  viewer {
    repositories(first: 100, after: $endCursor) {
      nodes { nameWithOwner createdAt updatedAt isPrivate isFork }
      pageInfo {
        hasNextPage
        endCursor
      }
    }
  }
}

Makefile

# query
00:
	gh api graphql --paginate -f query='$(shell cat list-repository.query)' | jq . | tee repositories.json

# filtered
01:
	jqfpy --squash -c '[h.pick("nameWithOwner", "createdAt", d=row) for row in get("data/viewer/repositories/nodes") if not row["isFork"] and not row["isPrivate"] and row["createdAt"].startswith("2020-")]' repositories.json | tee 2020-repositories.json

# setup
setup:
	port install gh # or https://github.com/cli/cli
	pip install jqfpy