commits

Table actions

15 rows where "author_date" is on date 2022-12-15

✎ View and edit SQL

This data as json, CSV (advanced)

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

sha ▼ message author_date committer_date raw_author raw_committer repo author committer
073ae9b4c7cbd80355777b50eacee03828e0655e Drop Python 3.6, add 3.10 and 3.100 2022-12-15T17:41:50Z 2022-12-15T17:41:50Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f github-to-sqlite 207052882 simonw 9599 web-flow 19864447
0b68996cc511b3a801f0cd0157bd66332d75f46f Revert "Replace AsgiLifespan with AsgiRunOnFirstRequest, refs #1955" This reverts commit dc18f62089e5672d03176f217d7840cdafa5c447. 2022-12-15T21:06:45Z 2022-12-15T21:06:45Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
3001eec66a7ec2ba91f5c0acd7cf3c0b79ab2c00 ds_client for test_csv.py and test_canned_queries.py, refs #1959 2022-12-15T22:24:39Z 2022-12-17T21:47:55Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
38d28dd958c41e5e7fde3788ba3fdaf2e09eff70 Revert "Try running every test at once, refs #1955" This reverts commit 51ee8caa4a697fa3f4120e93b1c205b714a6cdc7. 2022-12-15T21:05:33Z 2022-12-15T21:05:33Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
425ac4357ffb722a6ca86d08faba02ee38ad8689 Ported app_client to ds_client where possible in test_auth.py, refs #1959 2022-12-15T22:18:40Z 2022-12-17T21:47:55Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
51ee8caa4a697fa3f4120e93b1c205b714a6cdc7 Try running every test at once, refs #1955 2022-12-15T20:51:18Z 2022-12-15T20:51:18Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
626dd61f6070f95f7652104cb9f4100e9b88862f setup-gcloud fix 2022-12-15T06:57:31Z 2022-12-15T06:57:31Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f github-to-sqlite 207052882 simonw 9599 web-flow 19864447
63fb750f39cac6f49b451387fdff659ecd9edc5c Replace AsgiLifespan with AsgiRunOnFirstRequest, refs #1955 2022-12-15T17:34:07Z 2022-12-17T22:14:34Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
6e1e815c7881abe836d573b18ed2c5bb3e5b699e It's an update-or-insert 2022-12-15T02:41:30Z 2022-12-15T02:41:30Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447
8b9d7fdbd8de7e74414cc29e3005382669a812dc Fixed typo in release notes, refs #1953 2022-12-15T02:02:42Z 2022-12-15T02:02:42Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
8cac6ff3017b86ea1e9dd3b06962302a6ce74f4d Release 1.0a2 Refs #1636, #1855, #1878, #1927, #1937, #1940, #1947, #1951 Closes #1953 2022-12-15T02:01:02Z 2022-12-15T02:01:02Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
95900b9d02c01de46dc510693ab3b316988bf64c Port app_client to ds_client for most of test_html.py, refs #1959 2022-12-15T22:44:30Z 2022-12-17T21:47:55Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
b077e63dc6255d154ede16df1a507b09ba6075b1 Ported test_api.py app_client test to ds_client, refs #1959 2022-12-15T21:44:48Z 2022-12-17T21:47:55Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
dc18f62089e5672d03176f217d7840cdafa5c447 Replace AsgiLifespan with AsgiRunOnFirstRequest, refs #1955 2022-12-15T17:34:07Z 2022-12-15T17:34:07Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
e054704fb64d1f23154ec43b81b6c9481ff8202f Added missing rST label 2022-12-15T05:38:20Z 2022-12-15T05:38:28Z 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]);