home / github

Menu
  • GraphQL API

commits

Table actions
  • GraphQL API for commits

3 rows where "author_date" is on date 2020-04-27

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: raw_committer, committer_date (date)

committer 2 ✖

  • simonw 2
  • web-flow 1

author_date (date) 1 ✖

  • 2020-04-27 · 3 ✖
sha ▼ message author_date committer_date raw_author raw_committer repo author committer
25014ca25eb70b4c1217558ebd14db2845973bfb Configuration directory mode, closes #731 2020-04-27T16:30:24Z 2020-04-27T16:30:24Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447
89c4ddd4828623888e91a1d2cb396cba12d4e7b4 403 for static directory listing, closes #740 2020-04-27T18:29:04Z 2020-04-27T18:29:04Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
e37f4077c0f1cd09d4102213d4e2a512af471b8d Remove 'Serve!' line from serve CLI output It wasn't adding anything, and it was confusing when run in conjunction with the new config directory mode from #731 2020-04-27T22:02:02Z 2020-04-27T22:02:28Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE [commits] (
   [sha] TEXT PRIMARY KEY,
   [message] TEXT,
   [author_date] TEXT,
   [committer_date] TEXT,
   [raw_author] TEXT REFERENCES [raw_authors]([id]),
   [raw_committer] TEXT REFERENCES [raw_authors]([id]),
   [repo] INTEGER REFERENCES [repos]([id]),
   [author] INTEGER REFERENCES [users]([id]),
   [committer] INTEGER REFERENCES [users]([id])
);
CREATE INDEX [idx_commits_committer]
                ON [commits] ([committer]);
CREATE INDEX [idx_commits_author]
                ON [commits] ([author]);
CREATE INDEX [idx_commits_repo]
                ON [commits] ([repo]);
CREATE INDEX [idx_commits_raw_committer]
                ON [commits] ([raw_committer]);
CREATE INDEX [idx_commits_raw_author]
                ON [commits] ([raw_author]);
Powered by Datasette · Queries took 112.721ms · About: simonw/datasette-graphql