1f7a2e3996
Accepting request 1254384 from home:glaubitz:branches:devel:languages:python
Matej Cepl2025-03-19 12:39:24 +00:00
00732d0568
Accepting request 1138236 from devel:languages:python
Ana Guerrero2024-01-12 22:45:48 +00:00
40d6d1e1a3
- update to 3.36: * Support for creating tables in SQLite STRICT mode. Thanks, Taj Khattra. (:issue:344) CLI commands create-table, insert and upsert all now accept a --strict option. Python methods that can create a table - table.create() and insert/upsert/insert_all/upsert_all all now accept an optional strict=True parameter. The transform command and table.transform() method preserve strict mode when transforming a table. * CLI commands create-table, insert and upsert all now accept a --strict option. * Python methods that can create a table - table.create() and insert/upsert/insert_all/upsert_all all now accept an optional strict=True parameter. * The transform command and table.transform() method preserve strict mode when transforming a table. * The sqlite-utils create-table command now accepts str, int and bytes as aliases for text, integer and blob respectively. (:issue:606)
Dirk Mueller2024-01-12 08:20:58 +00:00
8797724858
Accepting request 1132122 from devel:languages:python
Ana Guerrero2023-12-08 21:33:40 +00:00
fbddf8da01
- update to 3.35.2: * The `--load-extension=spatialite option and :ref:find_spatialite() <python_api_gis_find_spatialite> utility function now both work correctly on arm64 Linux. * Fix for bug where sqlite-utils insert could cause your terminal cursor to disappear. Thanks, Luke Plant * `datetime.timedelta values are now stored as TEXT columns. Thanks, Harald Nezbeda * Test suite is now also run against Python 3.12. * Fixed a bug where :ref:table.transform() <python_api_transform> would sometimes re-assign the `rowid values for a table rather than keeping them consistent across the operation. (:issue:592) * Adding foreign keys to a table no longer uses PRAGMA writable_schema = 1 to directly manipulate the sqlite_master table. This was resulting in errors in some Python installations where the SQLite library was compiled in a way that prevented this from working, in particular on macOS. Foreign keys are now added using the :ref:table transformation <python_api_transform> mechanism instead. * This new mechanism creates a full copy of the table, so it is likely to be significantly slower for large tables, but will no longer trigger table sqlite_master may not be modified errors on platforms that do not support PRAGMA writable_schema = 1. * A new plugin, sqlite-utils-fast-fks <https://github.com/simonw/sqlite-utils-fast-fks>__, is now available for developers who still want to use that faster but riskier implementation. * The :ref:table.transform() method <python_api_transform>`
Dirk Mueller2023-12-08 14:28:52 +00:00
6bef1d9c0f
- update to 3.24: * SpatiaLite helpers for the `sqlite-utils command-line tool * All commands now include example usage in their --help - see :ref:cli_reference. (:issue:384) * Python library documentation has a new :ref:python_api_getting_started section. (:issue:387) * Documentation now uses Plausible analytics <https://plausible.io/>__. (:issue:389) * CLI and Python library improvements to help run ANALYZE inserting rows, to gain better performance from the SQLite query planner when it runs against indexes. * Three new CLI commands: `create-database, analyze and bulk. * More details and examples can be found in the annotated release notes <https://simonwillison.net/2022/Jan/11/sqlite-utils/>__. * Fixed bug where sqlite-utils upsert ... --detect-types ignored the --detect-types` option.
Dirk Mueller2022-02-16 20:42:31 +00:00
Dominique Leuenberger
Steve Kowalik
Ana Guerrero
Matej Cepl
Dirk Mueller
Markéta Machová
Tomáš Chvátal