commits

Table actions

13 rows where "author_date" is on date 2021-01-03

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: raw_committer, committer, author_date (date)

sha ▼ message author_date committer_date raw_author raw_committer repo author committer
036ec6d32313487527c66dea613a3e7118b97459 Ignore test .db files 2021-01-03T18:43:21Z 2021-01-03T18:43:21Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
0d2a47eab99f625be7ef4f77c6e9803177d13a2c .reset_counts() method and reset-counts command, closes #219 2021-01-03T20:59:31Z 2021-01-03T20:59:31Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
1e38a16ea8a58ec3eee8e54eee6c024d87f99d86 Nicer error message for invalid JSON insert, closes #206 2021-01-03T18:42:17Z 2021-01-03T18:42:17Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
3d041d34d5ee8234e0b955d2d1697f0756d1ffa5 Renamed db.escape() to db.quote() and documented it Closes #217 2021-01-03T04:15:04Z 2021-01-03T04:15:04Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
4cc82fd0bccc9d2eeb3510beb4e691d7da099f84 Release 3.2 Refs #206, #211, #212, #213, #214, #215, #216, #217, #218, #219 2021-01-03T21:15:26Z 2021-01-03T21:15:26Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
5b246d17a0b1c8b5e122da2f1d9974f53b50978e 'sqlite-utils triggers' command, closes #218 2021-01-03T03:03:15Z 2021-01-03T03:03:15Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
6d1828e40b17a7fa3403de7a3d3e0da9f657aa30 Don't run CodeQL against pull requests It failed with strange errors. https://github.com/simonw/sqlite-utils/pull/203/checks?check_run_id=1549287178 2021-01-03T04:30:10Z 2021-01-03T04:30:10Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f sqlite-utils 140912432 simonw 9599 web-flow 19864447
94b50230666cc6657a7b447e0ef1ddcb74a44473 table.count now uses cached counts if db.use_counts_table Closes #215 2021-01-03T20:19:34Z 2021-01-03T20:19:34Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
b4f09146d342ba72190f9a8543a44ccd6ea06b02 table.has_counts_triggers property, refs #219 2021-01-03T20:41:24Z 2021-01-03T20:41:24Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
c265541384c1e794b167da762c49a078b2195bf8 Shorter help summary for rebuild_fts 2021-01-03T20:22:07Z 2021-01-03T20:22:07Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
ce042ff1f0a398d9ad46532636e438dbe4efc0f1 'sqlite-utils enable-counts' command, closes #214 2021-01-03T04:26:39Z 2021-01-03T04:26:39Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
ce918195a4d72152569999c907937feb9d866ce3 Use $ instead of % in CLI documentation Refs #218 2021-01-03T03:52:15Z 2021-01-03T03:52:15Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
de08096989de1e025f0457e53404477f71a994e4 database.triggers_dict, closes #216 2021-01-03T04:19:55Z 2021-01-03T04:19:55Z 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]);