8d020427ed
- Update to 3.38 * Plugins can now reuse the implementation of the `sqlite-utils memory CLI command with the new return_db=True parameter. (:issue:643) * table.transform() now recreates indexes after transforming a table. A new sqlite_utils.db.TransformError exception is raised if these indexes cannot be recreated due to conflicting changes to the table such as a column rename. Thanks, Mat Miller. (:issue:633) * table.search() now accepts a include_rank=True parameter, causing the resulting rows to have a rank column showing the calculated relevance score. Thanks, liunux4odoo <https://github.com/liunux4odoo>__. (#628) * Fixed an error that occurred when creating a strict table with at least one floating point column. These FLOAT columns are now correctly created as REAL as well, but only for strict tables. (:issue:644) - from version 3.37 * The create-table and insert-files commands all now accept multiple --pk options for compound primary keys. (:issue:620) * Now tested against Python 3.13 pre-release. (#619) * Fixed a crash that can occur in environments with a broken numpy installation, producing a module 'numpy' has no attribute 'int8'. (:issue:632`) - Adjust upstream source name in spec file - Use Python 3.11 on SLE-15 by default - Limit Python files matched in %files section - Switch build system from setuptools to pyproject.toml * Add python-pip and python-wheel to BuildRequires * Replace %python_build with %pyproject_wheel * Replace %python_install with %pyproject_install
Matej Cepl2025-03-19 12:39:24 +00:00
e5f9523f53
Accepting request 1138236 from devel:languages:python
Ana Guerrero2024-01-12 22:45:48 +00:00
b116d57a3f
- 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
65a8b285e9
Accepting request 1132122 from devel:languages:python
Ana Guerrero2023-12-08 21:33:40 +00:00
567b7d89ad
- 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
5cfdd8c4ae
- 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