commits

Table actions

7 rows where "author_date" is on date 2020-10-24

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: committer, author_date (date), committer_date (date)

sha ▼ message author_date committer_date raw_author raw_committer repo author committer
10c35bd371faaa0f3c98067c08f26334c9f5ea52 urls.static_plugins() method, closes #1033 Also documented how to package static assets and templates in plugins, closes #575 2020-10-24T20:03:40Z 2020-10-24T20:03:40Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
29a977a74e19f8f03c3620786ef007430a3d112b New app_client_base_url_prefix fixture 2020-10-24T19:03:24Z 2020-10-24T19:03:24Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
5a1519796037105bc20bcf2f91a76e022926c204 /db/table/-/blob/pk/column.blob download URL, refs #1036 2020-10-24T23:09:18Z 2020-10-24T23:09:18Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447
7f728d4a37be632ead59e3d09bc2f3a332f298f1 Extra tests for datasette.urls, refs #1025 2020-10-24T19:21:23Z 2020-10-24T19:21:23Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
8148c9e265ab22f4b67ed0e67244b338cd8517ae Document render_template(templates) list, closes #1045 2020-10-24T00:22:00Z 2020-10-24T00:22:00Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
a96ad967e4b2adf3d0e056a6f785eefbb1a13620 Cleaned up some rogue full-stops 2020-10-24T20:05:19Z 2020-10-24T23:11:14Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
d3e9b0aecb6f8e9b2befd9c654ccb7ce852db3e7 Document render_template() can take a Template, refs #1045 2020-10-24T00:26:15Z 2020-10-24T00:26:15Z 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]);