commits

Table actions

15 rows where "committer_date" is on date 2019-07-28

✎ 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
0747dabb24b608e8524de4858ce50c60ba7e471b table.update() method * Also now set .last_pk to lastrowid for rowid tables * table.pks introspection now returns ["rowid"] for rowid tables Closes #35 2019-07-28T15:43:50Z 2019-07-28T15:43:50Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f sqlite-utils 140912432 simonw 9599 web-flow 19864447
0c1b8b7f96be874bb63801f69323960f277aa49a Use assertion to enforce <=999 columns 2019-07-28T11:41:57Z 2019-07-28T11:41:57Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
15368c5f59066fc9c6b8ce5d0578132b1b68b75d First working version of .update(), refs #35 2019-07-14T17:03:18Z 2019-07-28T12:15:50Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
16d7008002b43cf47a973791da93e5cdd5913fc3 Applied black 2019-07-28T15:37:27Z 2019-07-28T15:37:27Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
455071f3c5e76141926eb1e77656cb131a826707 Unit tests for .update() Also now set .last_pk to lastrowid for rowid tables. 2019-07-28T12:30:28Z 2019-07-28T12:30:28Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
4ab8d46b03a92c68e9694ea7c285d3852ef58530 Added table.update(pk, ..., alter=True) 2019-07-28T14:51:49Z 2019-07-28T14:51:49Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
5225dbb89c08a73b1af536105f7fcff64aef5638 Unit tests for invalid .update() pks 2019-07-28T14:46:49Z 2019-07-28T14:46:49Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
535a5ea476fb41738c839ac609b43d2f019cea96 Documentation and tests for table.drop() method 2019-07-28T11:22:12Z 2019-07-28T11:57:02Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
598608374625cbfa0799f5b7a210ca6e192f9c0b Documentation for table.update() method 2019-07-28T15:03:44Z 2019-07-28T15:03:44Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
62d292252804aa0a0c1d6fdc9ea1722b5ffb20a8 Fix for too many SQL variables, closes #50 2019-07-28T11:10:56Z 2019-07-28T11:10:56Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
9cb045284ede8009c12abdb1755b5b20f6ccff5f Fix for too many SQL variables on bulk insert SQLite has a max of 999 variables per query, so bulk inserts of e.g. 100 records with 11 columns each were failing with an error. We now dynamically adjust the batch_size to ensure this doesn't happen. Closes #50 2019-07-28T11:59:32Z 2019-07-28T11:59:32Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f sqlite-utils 140912432 simonw 9599 web-flow 19864447
a6749cdf43229c4f7864c946496e9ac0141627d9 Release 1.7.1 2019-07-28T12:00:51Z 2019-07-28T12:00:51Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
bc9c4db34b815f5385abbf4bb491bab0e10779db .update(...) with no update argument sets last_pk 2019-07-28T14:59:52Z 2019-07-28T14:59:52Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
e1021030dd2d8d4705ad0e7bae389eeaea7fa17b Release 1.8 2019-07-28T15:41:42Z 2019-07-28T15:41:42Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
e4a11b181580605b1711acee4828039137e2fcd9 Refactor .update() to use .get() .pks introspection now returns [rowid] for rowid tables. 2019-07-28T12:44:33Z 2019-07-28T12:44:33Z 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]);