commits

Table actions

7 rows where "author_date" is on date 2018-05-05

✎ View and edit SQL

This data as json, CSV (advanced)

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

sha ▼ message author_date committer_date raw_author raw_committer repo author committer
1259b8ac0bb25fc8af61c1948e2cc16860dca7ff Support _search_COLUMN=text searches, closes #237 2018-05-05T22:33:08Z 2018-05-05T22:33:08Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
403211de632cd15f0820cc9399305fc43c187b47 Release Datasette 0.21 2018-05-05T23:15:38Z 2018-05-05T23:15:38Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
4d6a568d6c1c9edabbaa8d58899b3857cd0185a7 Unit tests for _search= feature, refs #237 2018-05-05T22:01:14Z 2018-05-05T22:01:14Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
62c08d0d7197264af678c2f6e0c6403196217184 Revert "Travis should now deploy new tags to PyPI if tests pass" This reverts commit d39b2e357e34469728f300273ab07c3904ea7a2b. It failed with this error: https://travis-ci.org/simonw/datasette/jobs/375398977 Uploading distributions to https://upload.pypi.org/legacy/ Uploading datasette-0.21-py3-none-any.whl 100% 182k/182k [00:00<00:00, 694kB/s] HTTPError: 403 Client Error: Invalid or non-existent authentication information. for url: https://upload.pypi.org/legacy/ 2018-05-05T23:22:21Z 2018-05-05T23:22:21Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
801381b7657dd084c11ac2fb6e3d0194cfaa3455 Default tests to using a longer timelimit Every now and then a test will fail in Travis CI on Python 3.5 because it hit the default 20ms SQL time limit. Test fixtures now default to a 200ms time limit, and we only use the 20ms time limit for the specific test that tests query interruption. This should make our tests on Python 3.5 in Travis much more stable. 2018-05-05T22:41:37Z 2018-05-05T22:44:32Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
8e0f07284789228a98479c082a6dad467b65a35c Added Datasette 0.21 to News 2018-05-05T23:24:55Z 2018-05-05T23:24:55Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447
d39b2e357e34469728f300273ab07c3904ea7a2b Travis should now deploy new tags to PyPI if tests pass 2018-05-05T23:15:05Z 2018-05-05T23:15:05Z 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]);