commits

Table actions

5 rows where "author_date" is on date 2018-04-26

✎ View and edit SQL

This data as json, CSV (advanced)

committer_date (date) 1 ✖

author_date (date) 1 ✖

  • 2018-04-26 · 5 ✖
sha ▼ message author_date committer_date raw_author raw_committer repo author committer
02ee31c8b45b872fff91e2059c15a20532e2d035 New hidden: True option for table metadat, closes #239 2018-04-26T03:42:57Z 2018-04-26T03:42:57Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
4504d5160b2d86d4dae17b7c2f72bc3b02509c2c If max_returned_rows==page_size, increment max_returned_rows Fixes #230, where if the two were equal pagination didn't work correctly. 2018-04-26T04:04:12Z 2018-04-26T04:04:12Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
d3a0069c54aeaeffd197740120e0dca64bd0eeff Hide idx_* tables if spatialite detected, closes #228 2018-04-26T03:25:21Z 2018-04-26T03:25:21Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
db7a57a9a62d1d32e204d8acd9ab4341a1436ef9 Added class=rows-and-columns to custom query results table 2018-04-26T03:24:22Z 2018-04-26T03:24:22Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
f188ceaa2a3a5b2eab83425ad0f00cb0d364e24a New ?_size=XXX querystring parameter for table view, closes #229 Also added documentation for all of the _special arguments. Plus deleted some duplicate logic implementing _group_count. 2018-04-26T04:47:12Z 2018-04-26T04:47:12Z 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]);