commits

Table actions

5 rows where "author_date" is on date 2021-06-22 sorted by repo

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: committer_date (date)

author_date (date) 1 ✖

  • 2021-06-22 · 5 ✖
sha message author_date committer_date raw_author raw_committer repo ▼ author committer
8d1d8013899e110c03c50c1f66a7b9c0b51f8383 mypy tweaks, refs #289, #266, #37 2021-06-22T18:08:21Z 2021-06-22T18:08:21Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
7b3fdf0fcd553ddf25b8d606b7fc34f9fd7979df mypy annotations for rows_from_file(), run mypy in CI Refs #289, #279 2021-06-22T18:04:32Z 2021-06-22T18:04:32Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
3805d1c9731d5355797271bfb292a1a91758db01 Removed duplicate vacuum() function, thanks mypy 2021-06-22T17:44:12Z 2021-06-22T17:44:12Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
e5d7a2ba3d585303c8e1c861a09e8761ba63678f Tests for db.query() method, refs #290 2021-06-22T17:43:49Z 2021-06-22T17:43:49Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
9faeef230bf84c2f9b2859e5a4544f5ec50adf68 New db.query() method, refs #290 2021-06-22T04:03:59Z 2021-06-22T04:03:59Z 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]);