commits

Table actions

2 rows where "author_date" is on date 2019-05-04 sorted by committer

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: committer_date (date)

author_date (date) 1 ✖

  • 2019-05-04 · 2 ✖
sha message author_date committer_date raw_author raw_committer repo author committer ▼
55643430f7ac8d27e99b00e7cf79db741003e811 Added Code style: black badge 2019-05-04T02:21:21Z 2019-05-04T02:21:21Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447
35d6ee2790e41e96f243c1ff58be0c9c0519a8ce Apply black to everything, enforce via unit tests (#449) I've run the black code formatting tool against everything: black tests datasette setup.py I also added a new unit test, in tests/test_black.py, which will fail if the code does not conform to black's exacting standards. This unit test only runs on Python 3.6 or higher, because black itself doesn't run on 3.5. 2019-05-04T02:15:14Z 2019-05-04T02:15:14Z 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]);