home / github

Menu
  • GraphQL API

commits

Table actions
  • GraphQL API for commits

6 rows where "author_date" is on date 2020-02-22

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: raw_author, raw_committer, author, committer_date (date)

committer 2 ✖

  • simonw 5
  • web-flow 1

author_date (date) 1 ✖

  • 2020-02-22 · 6 ✖
sha ▼ message author_date committer_date raw_author raw_committer repo author committer
6303ea50483e432bbef193d1c54c2bf54e53f157 prepare_connection() now takes datasette and database args, refs #678 2020-02-22T01:32:40Z 2020-02-22T01:32:40Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
7c6a9c35299f251f9abfb03fd8e85143e4361709 Better tests for prepare_connection() plugin hook, refs #678 2020-02-22T02:27:07Z 2020-02-22T02:27:07Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
962a7e16e5e73c000d87815194b8261428e0938e Release notes for 0.36, refs #679 2020-02-22T03:01:57Z 2020-02-22T03:01:57Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
b031fe97636b80b05fec409ee1dffb7d044fd4e9 Updated README news for 0.36 2020-02-22T03:04:46Z 2020-02-22T03:04:46Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
be2265b0e811d0ac2875c2f748125c17b0f9289e Fix db-to-sqlite command in ecosystem doc page (#669) Thanks, @adipasquale 2020-02-22T02:32:17Z 2020-02-22T02:32:17Z Adrien Di Pasquale bd53542d6923dd8fcfd93cd43a925e6e8acd6e80 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 adipasquale 883348 web-flow 19864447
d6335f1f3184683b05131dd12a73ff1115aefba3 Added shapefile-to-sqlite, datasette-mask-columns, datasette-auth-existing-cookies, datasette-auth-existing-cookies Refs #679 2020-02-22T02:53:35Z 2020-02-22T02:53:35Z 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 119.454ms · About: simonw/datasette-graphql