commits

Table actions

10 rows where "author_date" is on date 2020-04-16

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: raw_committer, repo, committer, author_date (date), committer_date (date)

sha ▼ message author_date committer_date raw_author raw_committer repo author committer
125c625fbc46244a4b4025732e1526fb13c55843 .rows_where(..., order_by=) argument, closes #76 2020-04-16T03:12:55Z 2020-04-16T03:12:55Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
13528faa817d79bc3900d3af7473300686b145d7 Release 2.6 2020-04-16T03:13:13Z 2020-04-16T03:13:13Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
31d3df0f798db16394fd662e42206cdf768ded12 Typo fix 2020-04-16T22:21:40Z 2020-04-16T22:21:40Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f sqlite-utils 140912432 simonw 9599 web-flow 19864447
3b7ab5685de89fcb6fc92d320c0e24b17be05570 Release 1.0.1 With bug fix for #26 2020-04-16T17:41:47Z 2020-04-16T17:41:47Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
47686c7c3d2eee7f9e5425af8922970967ffb379 Extract organizaion to users table, refs #27 2020-04-16T19:03:44Z 2020-04-16T19:03:44Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
539e8a86ba53decf26cd6bd9e53cffb80396719b Add datasette-pretty-json to demo 2020-04-16T19:03:08Z 2020-04-16T19:03:08Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
85a09a9966ab1aff36c83083243ab6985ec60084 Send topic Accept header in fetch_repo() too, closes #26 2020-04-16T17:40:47Z 2020-04-16T17:41:01Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
c4aaa50e167cfa9021c7c94260bc3e89e10947bf Also pull issue comments, refs #25 2020-04-16T17:31:04Z 2020-04-16T17:31:04Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f github-to-sqlite 207052882 simonw 9599 web-flow 19864447
da5beb2f94eb21454a71fb364aec562ec7c221d7 Updated foreign keys test, refs #27 2020-04-16T19:19:38Z 2020-04-16T19:19:38Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
fc38868bd4c97acfc65b1aefbff80dfdea5e0d54 Refactored tests into new test_rows.py, refs #76 2020-04-16T01:04:51Z 2020-04-16T01:04: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]);