commits

Table actions

6 rows where "author_date" is on date 2021-02-25 sorted by raw_author

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: committer_date (date)

author_date (date) 1 ✖

  • 2021-02-25 · 6 ✖
sha message author_date committer_date raw_author ▼ raw_committer repo author committer
09c3386f55f766b135b6a1c00295646c4ae29bec Applied Black, refs #237 2021-02-25T17:13:00Z 2021-02-25T17:13:00Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
bba6e241be0e4aa596da0d5d4ae787d9d4cde92e --ignore for sqlite-utils drop-table and drop-view, closes #237 2021-02-25T17:11:37Z 2021-02-25T17:11:37Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
c236894caa976d4ea5c7503e9331a3e9d2fbb1c4 table.drop(ignore=True) option, refs #237 2021-02-25T17:05:08Z 2021-02-25T17:05:08Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
a76e3b33ac983355e78169b11f2b27cacb54b551 Fixed bug with add_foreign_key against columns with spaces, closes #238 2021-02-25T16:53:53Z 2021-02-25T16:53:53Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
16987bd56ef04ed1f1629b58272d8592c3a13249 Removed rogue assert False, refs #240 2021-02-25T16:35:24Z 2021-02-25T16:35:24Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
38e688fb8bcb58ae888b676fe3f7dd0529b4eecc table.pks_and_rows_where() method, closes #240 2021-02-25T16:28:17Z 2021-02-25T16:28:17Z 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]);