commits

Table actions

2 rows where "author_date" is on date 2018-06-29 sorted by committer_date

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: committer_date (date)

author_date (date) 1 ✖

  • 2018-06-29 · 2 ✖
sha message author_date committer_date ▼ raw_author raw_committer repo author committer
24af1004a42029f5a2f1a50541780814e9e2578a Added datasette-vega to news section 2018-06-29T14:53:36Z 2018-06-29T14:53:36Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447
d08faa89872d9ec8d3c8e76d85164ccd84596811 Fix for weird nested exception in RequestTimeout I saw this error: sanic.exceptions.RequestTimeout: Request Timeout During handling of the above exception, another exception occurred: Traceback (most recent call last): File "/Users/simonw/Dropbox/Development/datasette/venv/lib/python3.6/site-packages/sanic/handlers.py", line 82, in response response = handler(request=request, exception=exception) File "/Users/simonw/Dropbox/Development/datasette/datasette/app.py", line 512, in on_exception if request.path.split("?")[0].endswith(".json"): AttributeError: 'NoneType' object has no attribute 'path' Strangely "if request and request.path..." did not work here, because the Sanic Request class extends builtins.dict and hence evaluates to False if it has no headers. 2018-06-29T12:52:51Z 2018-07-08T02:58:11Z 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]);