commits
1 row where "author_date" is on date 2018-04-14 and message = "Fix sqlite error when loading rows with no incoming FKs This fixes `ERROR: conn=<sqlite3.Connection object at 0x10bbb9f10>, sql = 'select ', params = {'id': '1'}` caused by an invalid query when loading incoming FKs. The error was ignored due to async but it still got printed to the console."
This data as json, CSV (advanced)
Suggested facets: author_date (date), committer_date (date)
sha ▼ | author_date | committer_date | raw_author | raw_committer | repo | author | committer |
---|---|---|---|---|---|---|---|
1cc5161089e559c8b16049b20f7a5b3a43290c21 | 2018-04-14T12:06:00Z | 2018-04-14T14:24:24Z | Russ Garrett cd9d55c7c0a7cc0ee69155676fd5e9fc6e1b884b | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | datasette 107914493 | russss 45057 | simonw 9599 |
Advanced export
JSON shape: default, array, newline-delimited, object
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]);