commits

Table actions

10 rows where "author_date" is on date 2022-03-19

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: raw_committer, committer, committer_date (date)

author_date (date) 1 ✖

  • 2022-03-19 · 10 ✖
sha ▼ message author_date committer_date raw_author raw_committer repo author committer
32963018e7edfab1233de7c7076c428d0e5c7813 Updated documentation to remove hash_urls, refs #1661 2022-03-19T00:33:06Z 2022-03-19T00:33:06Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
4e47a2d894b96854348343374c8e97c9d7055cf6 Fixed bug where tables with a column called n caused 500 errors Closes #1228 2022-03-19T01:37:54Z 2022-03-19T01:37:54Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
61419388c134001118aaf7dfb913562d467d7913 Rename route match groups for consistency, refs #1667, #1660 2022-03-19T16:52:08Z 2022-03-19T16:52:08Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
711767bcd3c1e76a0861fe7f24069ff1c8efc97a Refactored URL routing to add tests, closes #1666 Refs #1660 2022-03-19T04:03:08Z 2022-03-19T04:03:08Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
764738dfcb16cd98b0987d443f59d5baa9d3c332 test_routes also now asserts matches, refs #1666 2022-03-19T16:30:22Z 2022-03-19T16:30:22Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
798f075ef9b98819fdb564f9f79c78975a0f71e8 Read format from route captures, closes #1667 Refs #1660 2022-03-19T20:32:29Z 2022-03-19T20:32:29Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
8658c66438ec71edc7e9adc495f4692b937a0f57 Show error if --setting hash_urls 1 used, refs #1661 2022-03-19T00:19:31Z 2022-03-19T00:19:31Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
9979dcd07f9921ac30c4c0b5ea60d09cd1e10556 Also remove default_cache_ttl_hashed setting, refs #1661 2022-03-19T00:25:14Z 2022-03-19T00:25:14Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
b9c2b1cfc8692b9700416db98721fa3ec982f6be Consistent treatment of format in route capturing, refs #1667 Also refs #1660 2022-03-19T20:29:10Z 2022-03-19T20:29:10Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
d4f60c2388c01ddce1b16f95c16d310e037c9912 Remove hashed URL mode Also simplified how view class routing works. Refs #1661 2022-03-19T00:12:03Z 2022-03-19T00:12:03Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447

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]);