Revisions of python-sqlite-utils
Ana Guerrero (anag+factory)
accepted
request 1138236
from
Dirk Mueller (dirkmueller)
(revision 6)
- 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`)
Ana Guerrero (anag+factory)
accepted
request 1132122
from
Dirk Mueller (dirkmueller)
(revision 5)
- 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>`
Dominique Leuenberger (dimstar_suse)
accepted
request 955487
from
Dirk Mueller (dirkmueller)
(revision 4)
- 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.
Dominique Leuenberger (dimstar_suse)
accepted
request 873668
from
Markéta Machová (mcalabkova)
(revision 2)
Dominique Leuenberger (dimstar_suse)
accepted
request 829095
from
Tomáš Chvátal (scarabeus_iv)
(revision 1)
Displaying all 6 revisions