commits

Table actions

5 rows where "author_date" is on date 2021-01-18

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: repo, committer_date (date)

author_date (date) 1 ✖

  • 2021-01-18 · 5 ✖
sha ▼ message author_date committer_date raw_author raw_committer repo author committer
0be971c2801ab6369f5b887dc2a578f78fb6b3ef alter=True in a bunch more places, refs #11 2021-01-18T04:13:28Z 2021-01-18T04:13:28Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 swarm-to-sqlite 205429375 simonw 9599 simonw 9599
36dc7e3909a44878681c266b90f9be76ac749f2d Release 3.3 Refs #222 2021-01-18T04:28:24Z 2021-01-18T04:28:24Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
719b6e96a016d0ca8b316d3bed9c2a7a0cb499ee Release 0.3.3 Refs #11 2021-01-18T04:34:56Z 2021-01-18T04:34:56Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 swarm-to-sqlite 205429375 simonw 9599 simonw 9599
9648b0bce0c2198cfb0c084e0b3c472fc3699fde Depend on sqlite-utils 3.3 for .m2m(alter=True), refs #11 2021-01-18T04:33:56Z 2021-01-18T04:33:56Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 swarm-to-sqlite 205429375 simonw 9599 simonw 9599
d4e00f8d0121cf5e1f1ad822dda68919d47cc5e1 table.m2m(..., alter=True) option, closes #222 2021-01-18T04:26:02Z 2021-01-18T04:26:02Z 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]);