commits

Table actions

8 rows where "author_date" is on date 2021-12-16

✎ View and edit SQL

This data as json, CSV (advanced)

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

sha ▼ message author_date committer_date raw_author raw_committer repo author committer
0663d5525cc41e9260ac7d1f6386d3a6eb5ad2a9 More comments in TableView.data(), refs #1518 2021-12-16T22:00:29Z 2021-12-16T22:00:29Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
0d4145d0f4d8b2a7edc1ba4aac1be56cd536a10a Additional test for #625 2021-12-16T20:30:31Z 2021-12-16T20:30:31Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
20a2ed6bec367d2f6759be4a879364a72780b59d Fixed bug with metadata config of array/date facets, closes #1552 Thanks @davidbgk for spotting the fix for the bug. 2021-12-16T18:47:22Z 2021-12-16T18:47:40Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
2c07327d23d9c5cf939ada9ba4091c1b8b2ba42d Move columns_to_select to TableView class, add lots of comments, refs #1518 2021-12-16T21:43:44Z 2021-12-16T21:43:44Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
40e5b0a5b5cbbe7ec9b1a525d61f58227061597e How to create indexes with sqlite-utils 2021-12-16T18:03:10Z 2021-12-16T18:03:10Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447
95d0dd7a1cf6be6b7da41e1404184217eb93f64a Fix for colliding facet types bug, closes #625 Refs #830 2021-12-16T20:12:04Z 2021-12-16T20:12:04Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
992496f2611a72bd51e94bfd0b17c1d84e732487 ?_nosuggest=1 parameter for table views, closes #1557 2021-12-16T19:24:54Z 2021-12-16T19:24:54Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
f3fd8613113d21d44238a6ec54b375f5aa72c4e0 Removed unneccessary pytest-runner, closes #357 2021-12-16T20:43:12Z 2021-12-16T20:43:12Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f sqlite-utils 140912432 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]);