commits

Table actions

9 rows where "author_date" is on date 2019-07-22

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: repo, committer_date (date)

author_date (date) 1 ✖

  • 2019-07-22 · 9 ✖
sha ▼ message author_date committer_date raw_author raw_committer repo author committer
127a836054fb784dc02ea40dadb55b3741dcd603 Documented new table configuration options via .table() 2019-07-22T23:59:17Z 2019-07-22T23:59:17Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
152eb2afaf35cde5d44e50369f4cb32a72e72fdb Use pysqlite3 if available 2019-07-22T22:39:35Z 2019-07-22T22:39:35Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
57e43baece0936d75c74711f5f6835a5c1c1ac42 Table options can now be passed to constructor OR to insert_all() If you want to set default options for a table, you can do this: table = db.table("dogs", pk="id", column_order=["name", "age"]) If you pass those keyword arguments to the .insert/.update/etc methods they will over-ride the defaults you set on the table. table = db["dogs"] # This still works too 2019-07-22T23:30:54Z 2019-07-22T23:30:54Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
5d7e14d40d5a4cfd133ca5faa442312f607784c5 Release 0.3 2019-07-22T03:31:54Z 2019-07-22T03:31:54Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 healthkit-to-sqlite 197882382 simonw 9599 simonw 9599
5fa404135a2704fe94dd976bf197472acffded28 Added progress bar, --xml and --silent options --xml lets you pass path to an XML file - I used this to add some unit tests for the CLI itself. --silent means "don't show a progress bar" Closes #5 2019-07-22T02:47:56Z 2019-07-22T02:47:56Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 healthkit-to-sqlite 197882382 simonw 9599 simonw 9599
604d423f92732c7f6d2b4402cc80734ac3bd7c21 Documentation for progress bar / --silent 2019-07-22T03:31:02Z 2019-07-22T03:31:02Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 healthkit-to-sqlite 197882382 simonw 9599 simonw 9599
b63bab25de0d6db72d5e410789fbc9bfa1eace93 Better progress bar label, refs #5 2019-07-22T03:17:20Z 2019-07-22T03:17:20Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 healthkit-to-sqlite 197882382 simonw 9599 simonw 9599
be655827b4a4ff88eb4813075339b0b01e018145 use_table_factory is a better name than use_class_constructor 2019-07-22T23:33:37Z 2019-07-22T23:33:37Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
f518d8c7099a9f8826920ab9634a159036094cf7 Break records out into separate tables, closes #6 2019-07-22T03:28:43Z 2019-07-22T03:28:43Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 healthkit-to-sqlite 197882382 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]);