remote/sqlite-utils
1
0
Fork 0
mirror of https://github.com/simonw/sqlite-utils.git synced 2026-09-16 13:34:10 +02:00
Code Issues Projects Releases Packages Wiki Activity

Commit graph

  • 405e092d59 Option to add triggers when enabling FTS (#57) Amjith Ramanujam 2019-09-02 16:42:28 -07:00
  • e01943271b Add tests for escaping table names. Amjith Ramanujam 2019-09-02 10:21:26 -07:00
  • 3dfcb28ffc Change the escaping to square brackets. Amjith Ramanujam 2019-09-02 09:13:36 -07:00
  • d0658fda27 Rename the option to create-triggers for FTS. Amjith Ramanujam 2019-09-02 08:54:49 -07:00
  • 3816556782 Add tests for the create-update-trigger option. Amjith Ramanujam 2019-09-01 21:18:47 -07:00
  • aef825c140 Add cli option for the create-update-trigger. Amjith Ramanujam 2019-09-01 21:18:32 -07:00
  • 68e63ad07f Add an option to create triggers for fts table. Amjith Ramanujam 2019-09-01 20:09:02 -07:00
  • 83ca4c802f Escape the table name in populate_fts and search. Amjith Ramanujam 2019-08-31 23:20:15 -07:00
  • cb70f7d109
         Corrected .views_names() -> .view_names() Simon Willison 2019-08-26 07:04:14 +02:00
  • 68a5cb1b8e
         Corrected .table_views() -> .view_names() Simon Willison 2019-08-26 07:03:22 +02:00
  • 53124bc02f Release 1.10 1.10 Simon Willison 2019-08-23 15:24:04 +03:00
  • 9faa982226
         Ability to introspect and run queries against views (#55) Simon Willison 2019-08-23 15:19:41 +03:00
  • 4441d6d838 Separate View and Table classes views Simon Willison 2019-08-21 13:12:12 +03:00
  • 0f1f37db4d .views_names() and .views methods, refs #54 Simon Willison 2019-08-17 16:37:05 +03:00
  • 0e7b461eb3
         Fixed typo Simon Willison 2019-08-04 07:13:31 +03:00
  • 6ac0a5df5d Release 1.9 1.9 Simon Willison 2019-08-04 06:35:30 +03:00
  • 4c0912dbf2
         table.m2m() method for creating many-to-many records Simon Willison 2019-08-04 06:37:32 +03:00
  • 243bcaa1ac Documentation for .m2m() table method Simon Willison 2019-08-04 05:29:19 +03:00
  • 5516175ca6 Allow table objects to be passed to .m2m() Simon Willison 2019-08-04 05:09:17 +03:00
  • d96a8f149e Use existing m2m table if one exists Simon Willison 2019-08-03 21:15:16 +03:00
  • b9256413d2 db.m2m_table_candidates(table, other_table) Simon Willison 2019-08-03 21:07:06 +03:00
  • b6b92980c0 table.m2m(..., m2m_table=x) argument Simon Willison 2019-08-03 20:51:22 +03:00
  • ba1211d445 Implemented .m2m(table, lookup=...) Simon Willison 2019-08-03 17:28:03 +03:00
  • ff2348e71a Added failing tests Simon Willison 2019-07-31 09:16:46 +03:00
  • 35eeafaaa3 table.m2m(...) method, with tests Simon Willison 2019-07-31 08:31:27 +03:00
  • e1021030dd Release 1.8 1.8 Simon Willison 2019-07-28 18:41:42 +03:00
  • 0747dabb24
         table.update() method Simon Willison 2019-07-28 18:43:50 +03:00
  • 16d7008002 Applied black update Simon Willison 2019-07-28 18:37:27 +03:00
  • 5986083746 Documentation for table.update() method Simon Willison 2019-07-28 18:03:44 +03:00
  • bc9c4db34b .update(...) with no update argument sets last_pk Simon Willison 2019-07-28 17:59:52 +03:00
  • 4ab8d46b03 Added table.update(pk, ..., alter=True) Simon Willison 2019-07-28 17:51:49 +03:00
  • 5225dbb89c Unit tests for invalid .update() pks Simon Willison 2019-07-28 17:46:49 +03:00
  • e4a11b1815 Refactor .update() to use .get() Simon Willison 2019-07-28 15:44:33 +03:00
  • 455071f3c5 Unit tests for .update() Simon Willison 2019-07-28 15:30:28 +03:00
  • 15368c5f59 First working version of .update(), refs #35 Simon Willison 2019-07-14 10:03:18 -07:00
  • a6749cdf43 Release 1.7.1 1.7.1 Simon Willison 2019-07-28 15:00:51 +03:00
  • 535a5ea476 Documentation and tests for table.drop() method Simon Willison 2019-07-28 14:22:12 +03:00
  • 9cb045284e
         Fix for too many SQL variables on bulk insert Simon Willison 2019-07-28 14:59:32 +03:00
  • 0c1b8b7f96 Use assertion to enforce <=999 columns too-many-sql Simon Willison 2019-07-28 14:41:57 +03:00
  • 62d2922528 Fix for too many SQL variables, closes #50 Simon Willison 2019-07-28 14:10:56 +03:00
  • 9b7be79c86 Release 1.7 - with lookup table support 1.7 Simon Willison 2019-07-24 08:50:41 +02:00
  • 941d281aee
         extracts= table parameter, closes #46 Simon Willison 2019-07-23 10:00:42 -07:00
  • 1c9d08f75a Docs for extracts= table-extracts Simon Willison 2019-07-23 18:53:52 +02:00
  • afad1f70d0 extracts= accepts tuple as well as list Simon Willison 2019-07-23 18:53:39 +02:00
  • ec3d3b2978 extracts= table parameter, refs #46 Simon Willison 2019-07-23 18:26:53 +02:00
  • e22cfcd953 Removed a TODO which is now done Simon Willison 2019-07-23 15:05:04 +02:00
  • 5805024316
         Implemented table.lookup(...), closes #44 Simon Willison 2019-07-23 06:06:59 -07:00
  • c0852ce018 Implemented table.lookup(...), closes #44 lookup Simon Willison 2019-07-23 14:59:47 +02:00
  • e9d983e561 Add pk column if missing from insert Simon Willison 2019-07-23 13:12:48 +02:00
  • f3a4c3d3ee db.create_table() now remembers configs Simon Willison 2019-07-23 09:47:19 +02:00
  • 535a731b93 Fixed lint error Simon Willison 2019-07-23 09:41:34 +02:00
  • 034d498b31 Support Database(memory=True) for in-memory databases Simon Willison 2019-07-22 17:12:54 -07:00
  • 58db40d67c Better __repr__ for tables Simon Willison 2019-07-22 17:05:51 -07:00
  • 127a836054 Documented new table configuration options via .table() Simon Willison 2019-07-22 16:59:17 -07:00
  • be655827b4 use_table_factory is a better name than use_class_constructor Simon Willison 2019-07-22 16:33:37 -07:00
  • 57e43baece Table options can now be passed to constructor OR to insert_all() Simon Willison 2019-07-22 16:30:54 -07:00
  • 152eb2afaf Use pysqlite3 if available Simon Willison 2019-07-22 15:39:35 -07:00
  • c88f0a4d46 Release 1.6 1.6 Simon Willison 2019-07-18 21:51:21 -07:00
  • 09316835e6 Implemented --tsv option, closes #41 Simon Willison 2019-07-18 21:50:38 -07:00
  • ef112ffc94 Release 1.5 1.5 Simon Willison 2019-07-14 21:34:49 -07:00
  • 3f1e6cf12e Release 1.5 get Simon Willison 2019-07-14 21:34:49 -07:00
  • c65b67ca46
         .get() method plus support for compound primary keys (#40) Simon Willison 2019-07-14 21:28:51 -07:00
  • b5a5df6d0e Documentation for .get() Simon Willison 2019-07-14 21:24:42 -07:00
  • 1445a8ecb5 Tests for .get() NotFoundError Simon Willison 2019-07-14 21:21:26 -07:00
  • 71a3bc26c9 Applied Black Simon Willison 2019-07-14 21:04:43 -07:00
  • e51bd09a35 Python library docs for compound primary keys Simon Willison 2019-07-14 21:03:57 -07:00
  • be9ff64940 Docs for compound primary keys with CLI Simon Willison 2019-07-14 21:00:12 -07:00
  • f47b5a9e19 CLI now accepts multiple --pk for compound primary keys Simon Willison 2019-07-14 20:57:57 -07:00
  • d5dc92876e create_table now handles compound primary keys, closes #36 Simon Willison 2019-07-14 20:42:16 -07:00
  • 90edd0d817 Show version in docs Simon Willison 2019-07-14 12:45:00 -07:00
  • 0fcb1e4839 Sphinx docs now pull version info from git tag Based on http://dreamiurg.net/2011/10/03/using-git-to-get-version-information/ Simon Willison 2019-07-14 12:24:45 -07:00
  • 9ff905937f Use pip install -e .[docs] for documentation dependencies Simon Willison 2019-07-14 12:23:31 -07:00
  • 65b2156d9c Show version in docs Simon Willison 2019-07-14 12:45:00 -07:00
  • 91311bb0db Sphinx docs now pull version info from git tag Based on http://dreamiurg.net/2011/10/03/using-git-to-get-version-information/ Simon Willison 2019-07-14 12:24:45 -07:00
  • a8ecf95f11 Use pip install -e .[docs] for documentation dependencies Simon Willison 2019-07-14 12:23:31 -07:00
  • a9fd1e785f Initial implementation of table.get(...) Simon Willison 2019-07-14 12:22:43 -07:00
  • f70e35c9bb Added table.rows_where(where, args) method Simon Willison 2019-07-14 11:58:40 -07:00
  • 72a6f430df Update PyPI classifiers Simon Willison 2019-07-14 10:16:36 -07:00
  • 41d1751aec Release 1.4.1 1.4.1 Simon Willison 2019-07-14 10:08:34 -07:00
  • ba6bd47f15 Typo fix Simon Willison 2019-07-14 09:25:57 -07:00
  • e6cb34e348 Applied black mypy Simon Willison 2019-07-09 08:17:30 -07:00
  • 893e30e903 WIP type annotation Simon Willison 2019-07-09 07:55:04 -07:00
  • d18c694fc2 Example from running monkeytype apply sqlite_utils.db monkeytype Simon Willison 2019-07-09 08:06:38 -07:00
  • facec8df62 WIP tests update-get Simon Willison 2019-07-09 07:44:47 -07:00
  • 2cfc29931d WIP Simon Willison 2019-07-09 07:36:37 -07:00
  • fef96163d9
         Minor markup cleanup Simon Willison 2019-07-09 04:55:04 -07:00
  • 5be66529a3
         Fixed RST and Typo Simon Willison 2019-07-09 04:49:32 -07:00
  • b0a2f897f4
         Typo fix Simon Willison 2019-07-09 04:42:40 -07:00
  • 1a053d9438
         Added Python library example to README Simon Willison 2019-07-03 11:04:03 -07:00
  • fad14ab943 Release 1.4 1.4 Simon Willison 2019-06-30 16:51:17 -07:00
  • e8f887ef4a
         sqlite-utils index-foreign-keys / db.index_foreign_keys() Simon Willison 2019-06-30 16:50:54 -07:00
  • d82b000e3d 'Adding indexes for all foreign keys' docs index-foreign-keys Simon Willison 2019-06-30 16:44:52 -07:00
  • 1e917efe31 Test for index-foreign-keys command Simon Willison 2019-06-30 16:41:38 -07:00
  • 61164d98cf Added db.index_foreign_keys() method plus test Simon Willison 2019-06-30 16:38:14 -07:00
  • 093c3e66db Black Simon Willison 2019-06-30 10:17:05 -07:00
  • f35e4e6662 Initial sketch for index-foreign-keys, refs #33 Simon Willison 2019-06-30 09:42:20 -07:00
  • 0fe3b38290
         Added db-to-sqlite to "Related projects" Simon Willison 2019-06-29 14:34:24 -07:00
  • b4e36546b0 Release 1.3 1.3 Simon Willison 2019-06-28 23:31:18 -07:00
  • b3b94fb023 Release 1.3 add-foreign-keys Simon Willison 2019-06-28 23:31:18 -07:00
  • 997d8758fc
         db.add_foreign_keys() method Simon Willison 2019-06-28 23:27:38 -07:00