commits

Table actions

6 rows where "author_date" is on date 2018-05-28 sorted by committer_date

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: committer_date (date)

author_date (date) 1 ✖

  • 2018-05-28 · 6 ✖
sha message author_date committer_date ▼ raw_author raw_committer repo author committer
76d11eb768e2f05f593c4d37a25280c0fcdf8fd6 New ?_json=colname argument for returning unescaped JSON Also extracted docs for special JSON arguments into a new section. Closes #31 2018-05-28T18:08:39Z 2018-05-28T18:08:39Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
a4d6acc23943759b46fa90ec68e500016b933410 Use scope='session' for all fixtures This means they will only be executed once which makes sense since the database they create is immutable. 2018-05-28T20:41:06Z 2018-05-28T20:41:06Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
fefb0db8ae15199d0204af859ba1edc6ae98f84b Unit test for 02870e57, closes #291 2018-05-28T20:41:53Z 2018-05-28T20:41:53Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
27c10f6482858f9654e31c800884d75304d50ed5 Missing half of last commit fefb0db8ae15 2018-05-28T20:42:48Z 2018-05-28T20:42:48Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
98c8f0e7285fb58b7cbb38304e2ed4576774ad91 Moved plugin HTML tests from test_html to test_plugins 2018-05-28T21:23:48Z 2018-05-28T21:23:48Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
b0a95da96386ddf99816911e08df86178ffa9a89 Show more useful error message for SQL interrupted, closes #142 2018-05-28T21:24:19Z 2018-05-28T21:24:19Z 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]);