github

Custom SQL query returning 22 rows (show)

Query parameters

This data as json, CSV

shamessageauthor_datecommitter_dateraw_authorraw_committerrepoauthorcommitter
05317f53411fab3c3d66b88408bc867f2e474a35 Release 0.14 2019-02-24T23:11:51Z 2019-02-24T23:11:51Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 140912432 9599 9599
05a85b358fb907d8fcb72f19390ee2ba5a2261a5 Don't assume -1 for error code 2019-02-24T19:50:56Z 2019-02-24T19:50:56Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 140912432 9599 9599
0bc49e938e1e3444df734f9178a9a317f68f9716 'sqlite-utils add-column name type' command, closes #15 2019-02-24T20:04:33Z 2019-02-24T20:04:33Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 140912432 9599 9599
0c6745b70f95663f8ddf4309c578bd568eca75ec Whitespace fix 2019-02-24T18:42:27Z 2019-02-24T18:42:27Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 140912432 9599 9599
10e3aab4c63bc02cacd64e7aa1e5eaff2b314b3e Fixed typo with last_pk 2019-02-24T06:49:54Z 2019-02-24T06:49:54Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 140912432 9599 9599
1b6025e8ab5cef6a6f2550cc3be1f80b12cc64a1 Release 0.13 2019-02-24T06:54:43Z 2019-02-24T06:54:43Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 140912432 9599 9599
33df260b38e1b0f179cdb849fc4e3e9c76e57f3a Fix for CLI test 2019-02-24T20:12:59Z 2019-02-24T20:12:59Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 140912432 9599 9599
3cab079d3e45aa3468e9f7317680ded6438f3955 add-column col_type now optional, defaults to str 2019-02-24T22:24:00Z 2019-02-24T22:24:00Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 140912432 9599 9599
557dc3f9a7b622c45c73fd791cfe0a786f9a1de0 Improved foreign_keys= argument, closes #17 2019-02-24T22:12:45Z 2019-02-24T22:12:45Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 140912432 9599 9599
6c3f5e647934413dfc46a218f1540a1cab31e52e Added --table and --fmt options for table output using tabulate 2019-02-24T06:45:17Z 2019-02-24T06:45:17Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 140912432 9599 9599
6d25f648ed708b8dd78cbb0af5e356d16859625f add_column now accepts explicit SQLite types, refs #15 2019-02-24T19:49:24Z 2019-02-24T19:49:31Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 140912432 9599 9599
7784b924a179ee213f52693276ab7b68d6549b51 Added create_index(..., if_not_exists=True), refs #14 2019-02-24T18:46:44Z 2019-02-24T18:46:44Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 140912432 9599 9599
8a5d0d80c37008f30953110d58f474aac2728ee3 sqlite-utils create-index command, closes #14 2019-02-24T19:11:21Z 2019-02-24T19:11:21Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 140912432 9599 9599
9756310408c7e5fa1ca257573e46aa13c2041c24 Black 2019-02-24T20:59:46Z 2019-02-24T20:59:46Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 140912432 9599 9599
c5068a0972651b3e359ebc2d6c1486b8b7d2c242 :pencil: Updates my_database.py to my_database.db (#9) 2019-02-24T03:55:04Z 2019-02-24T03:55:04Z 207bb2132044fa5a4fe28a579f7588c2eee6e391 2946d096d0cdefdc017559e6b57e87658736e843 140912432 50527 9599
c5286d2c66b8c187002f9ad8991a6665b2b092f9 Black formatting 2019-02-24T19:40:58Z 2019-02-24T19:40:58Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 140912432 9599 9599
dbf239e3fc8af00ef43ec578fb195dfe604a99fe hash_id= mechanism for setting ID using content hash, closes #13 2019-02-24T04:36:40Z 2019-02-24T04:36:40Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 140912432 9599 9599
dc2560879ed32136d64707a031b62b2870809892 table.add_column(name, type) method, refs #15 2019-02-24T19:40:26Z 2019-02-24T19:40:26Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 140912432 9599 9599
e1ca938aa1c84367fd9d4786b9709c56f3e6e778 table.add_foreign_key(column, other_table, other_column) New mechanism for adding foreign key constraints to an existing SQLite table. SQLite ALTER TABLE does not support this out-of-the-box, so I instead had to write some careful code that uses PRAGMA writable_schema = 1 to directly modify the sqlite_master table. Refs #2 2019-02-24T21:10:51Z 2019-02-24T21:10:51Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 140912432 9599 9599
e615d22c5564ea1f32abb086088b2700110be10a Support for numpy types, closes #11 (#12) 2019-02-24T04:02:19Z 2019-02-24T04:02:19Z 2946d096d0cdefdc017559e6b57e87658736e843 cd792325681cbad9f663f2879d8b69f1edbb678f 140912432 9599 19864447
e7ffbcdb364810213b0697c9bcab064efb1dd469 Ability to create unique indexes, refs #14 2019-02-24T18:41:51Z 2019-02-24T18:41:51Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 140912432 9599 9599
f8d3b7cfe5c1950b0749d40eb2640df50b52f651 sqlite-utils add-foreign-key books.db books author_id authors id Command for adding foreign keys to existing tables. Closes #2 2019-02-24T21:33:45Z 2019-02-24T21:33:45Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 140912432 9599 9599