commits

Table actions

7 rows where "author_date" is on date 2019-05-02

✎ View and edit SQL

This data as json, CSV (advanced)

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

sha ▼ message author_date committer_date raw_author raw_committer repo author committer
033cf0bcbbcadd0256d0c43fb7b9d3053727b4fe DatabaseView no longer uses .inspect(), closes #420 2019-05-02T01:12:58Z 2019-05-02T01:13:26Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
3651eedf20b86ad30f510bf762fb25790bb3560c Show 'many rows' if count times out, refs #420 2019-05-02T05:20:24Z 2019-05-02T05:20:24Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
50d2d1aac985f440b36e6847e3ddacb4a6bf4d4b Fixed bug where metadata.json hidden tables were ignored 2019-05-02T00:54:48Z 2019-05-02T00:54:48Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
ad9de774f75ba41f2a627a9d2cecd61050bac901 Added missing file, refs #438 2019-05-02T05:10:23Z 2019-05-02T05:10:23Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
e7151ccccf4a0d10e1fcf3832e18c5199c16dea0 Index page no longer uses inspect data - refs #420 Also introduced a mechanism whereby table counts are calculated against a time limit but immutable databases have their table counts calculated on server startup. 2019-05-02T00:39:39Z 2019-05-02T00:39:39Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
efc93b8ab5a21e3802f75f08d5e41409f5684b5d Entirely removed table_rows_count table property We were not displaying this anywhere, and it is now expensive to calculate. Refs #419, #420 2019-05-02T05:29:47Z 2019-05-02T05:29:47Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
f553a670216960043ec7e62ff35d42db78903ff0 Don't load setuptools plugins during test runs Uses pattern from https://docs.pytest.org/en/latest/example/simple.html#detect-if-running-from-within-a-pytest-run Closes #438 2019-05-02T05:09:03Z 2019-05-02T05:09:03Z 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]);