Accepting request 1254406 from devel:languages:python

- Clean up the SPEC file.
- 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

OBS-URL: https://build.opensuse.org/request/show/1254406
OBS-URL: https://build.opensuse.org/package/show/openSUSE:Factory/python-sqlite-utils?expand=0&rev=7

python-sqlite-utils.changes

@@ -1,3 +1,39 @@
+-------------------------------------------------------------------
+Wed Mar 19 12:47:42 UTC 2025 - Matej Cepl <mcepl@cepl.eu>
+
+- Clean up the SPEC file.
+
+-------------------------------------------------------------------
+Wed Mar 19 11:12:57 UTC 2025 - John Paul Adrian Glaubitz <adrian.glaubitz@suse.com>
+
+- 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
+
 -------------------------------------------------------------------
 Fri Jan 12 08:20:52 UTC 2024 - Dirk Müller <dmueller@suse.com>
 

python-sqlite-utils.spec

@@ -1,7 +1,7 @@
 #
 # spec file for package python-sqlite-utils
 #
-# Copyright (c) 2024 SUSE LLC
+# Copyright (c) 2025 SUSE LLC
 #
 # All modifications and additions to the file contributed by third parties
 # remain the property of their copyright owners, unless otherwise agreed
@@ -16,31 +16,36 @@
 #
 
 
+%{?sle15_python_module_pythons}
 Name:           python-sqlite-utils
-Version:        3.36
+Version:        3.38
 Release:        0
 Summary:        Python CLI tool and library for manipulating SQLite databases
 License:        Apache-2.0
 Group:          Development/Languages/Python
 URL:            https://github.com/simonw/sqlite-utils
-Source:         https://files.pythonhosted.org/packages/source/s/sqlite-utils/sqlite-utils-%{version}.tar.gz
+Source:         https://files.pythonhosted.org/packages/source/s/sqlite_utils/sqlite_utils-%{version}.tar.gz
 BuildRequires:  %{python_module click-default-group}
 BuildRequires:  %{python_module click}
 BuildRequires:  %{python_module hypothesis}
 BuildRequires:  %{python_module pandas}
+BuildRequires:  %{python_module pip}
 BuildRequires:  %{python_module pytest}
 BuildRequires:  %{python_module setuptools}
 BuildRequires:  %{python_module sqlite-fts4}
 BuildRequires:  %{python_module tabulate}
+BuildRequires:  %{python_module wheel}
 BuildRequires:  %{pythons}
 BuildRequires:  fdupes
 BuildRequires:  python-rpm-macros
 Requires:       python-click
 Requires:       python-click-default-group
+Requires:       python-dateutil
+Requires:       python-pluggy
 Requires:       python-sqlite-fts4
 Requires:       python-tabulate
 Requires(post): update-alternatives
-Requires(postun):update-alternatives
+Requires(postun): update-alternatives
 BuildArch:      noarch
 %python_subpackages
 
@@ -48,15 +53,15 @@ BuildArch:      noarch
 CLI tool and Python utility functions for manipulating SQLite databases.
 
 %prep
-%setup -q -n sqlite-utils-%{version}
+%setup -q -n sqlite_utils-%{version}
 # https://github.com/simonw/sqlite-utils/issues/357
 sed -i 's:pytest-runner:pytest:' setup.py
 
 %build
-%python_build
+%pyproject_wheel
 
 %install
-%python_install
+%pyproject_install
 %python_clone -a %{buildroot}%{_bindir}/sqlite-utils
 %python_expand %fdupes %{buildroot}%{$python_sitelib}
 
@@ -74,6 +79,7 @@ export LANG=en_US.UTF-8
 %doc README.md docs
 %license LICENSE
 %python_alternative %{_bindir}/sqlite-utils
-%{python_sitelib}/*
+%{python_sitelib}/sqlite_utils
+%{python_sitelib}/sqlite_utils-%{version}*-info
 
 %changelog

sqlite-utils-3.36.tar.gz

@@ -1,3 +0,0 @@
-version https://git-lfs.github.com/spec/v1
-oid sha256:dcc311394fe86dc16f65037b0075e238efcfd2e12e65d53ed196954502996f3c
-size 211586

sqlite_utils-3.38.tar.gz

@@ -0,0 +1,3 @@
+version https://git-lfs.github.com/spec/v1
+oid sha256:1ae77b931384052205a15478d429464f6c67a3ac3b4eafd3c674ac900f623aab
+size 214449