commits

Table actions

10 rows where "author_date" is on date 2022-01-09

✎ 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
148e9c7aeea2486b0562814b82f152506bfb0dd5 Use cog to maintain --fmt list, closes #373 2022-01-09T17:48:48Z 2022-01-09T17:48:48Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
1d64cd2e5b402ff957f9be2d9bb490d313c73989 sqlite-utils create-database command, closes #348 2022-01-09T20:33:16Z 2022-01-09T20:33:16Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
22c8d10dd343476e8b7b9af3366fae4c8353dd2c --convert function can now modify row in place, closes #371 2022-01-09T20:06:02Z 2022-01-09T20:06:02Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
2f8879235afc6a06a8ae25ded1b2fe289ad8c3a6 Renamed function to fix lint error, refs #348 2022-01-09T20:39:14Z 2022-01-09T20:39:14Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
49a54ffb2fb6d3b73522c96c2bf9fc722e99d036 Fix for cog error Should help tests pass for #374, #371 2022-01-09T20:08:03Z 2022-01-09T20:08:03Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
539f5ccd90371fa87f946018f8b77d55929e06db Support 'python -m sqlite_utils', closes #368 Refs #364 2022-01-09T02:33:00Z 2022-01-09T02:33:22Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
b8c134059e89f0fa040b84fb7d0bda25b9a52759 --fmt now implies --table, closes #374 2022-01-09T18:07:48Z 2022-01-09T18:07:48Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
c9ecd0d6a32d4518c9b92bcc08183a10268d52d7 stem and suffix columns for insert-files, closes #372 2022-01-09T20:16:52Z 2022-01-09T20:16:52Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
e0c476bc380744680c8b7675c24fb0e9f5ec6dcd Fix test for Python 3.6, refs #368 2022-01-09T02:37:53Z 2022-01-09T02:37:53Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
f08fe6fd4d5df4fe1e638118707c98e1add80caf Fixed error in docs: it's suffix not extension, refs #372 2022-01-09T20:18:31Z 2022-01-09T20:18:31Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 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]);