Script 'mail_helper' called by obssrc
Hello community,
here is the log from the commit of package python-sqlite-utils for
openSUSE:Factory checked in at 2021-02-19 23:45:04
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Comparing /work/SRC/openSUSE:Factory/python-sqlite-utils (Old)
and /work/SRC/openSUSE:Factory/.python-sqlite-utils.new.28504 (New)
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Package is "python-sqlite-utils"
Fri Feb 19 23:45:04 2021 rev:2 rq:873668 version:3.5
Changes:
--------
--- /work/SRC/openSUSE:Factory/python-sqlite-utils/python-sqlite-utils.changes
2020-08-28 21:22:26.172355510 +0200
+++
/work/SRC/openSUSE:Factory/.python-sqlite-utils.new.28504/python-sqlite-utils.changes
2021-02-19 23:45:45.263392161 +0100
@@ -1,0 +2,100 @@
+Thu Feb 18 08:32:36 UTC 2021 - andy great <[email protected]>
+
+- Update to version 3.5.
+ * ``sqlite-utils insert --sniff`` option for detecting the delimiter
+ and quote character used by a CSV file
+ * The ``table.rows_where()``, ``table.search()`` and
+ ``table.search_sql()`` methods all now take optional ``offset=``
+ and ``limit=`` arguments.
+ * New ``--no-headers`` option for ``sqlite-utils insert --csv`` to
+ handle CSV files that are missing the header row.
+ * Fixed bug where inserting data with extra columns in subsequent
+ chunks would throw an error.
+ * Fixed bug importing CSV files with columns containing more than
+ 128KB of data.
+ * Test suite now runs in CI against Ubuntu, macOS and Windows.
+- Updates for 3.4.1
+ * Fixed a code import bug that slipped in to 3.4.
+- Updates for 3.4
+ * ``sqlite-utils insert --csv`` now accepts optional
+ ``--delimiter`` and ``--quotechar`` options.
+- Updates for 3.3
+ * The ``table.m2m()`` method now accepts an optional ``alter=True``
+ argument to specify that any missing columns should be added to
+ the referenced table.
+- Updates for 3.2.1
+ * Fixed a bug where ``.add_missing_columns()`` failed to take case
+ insensitive column names into account.
+- Updates for 3.2
+ * This release introduces a new mechanism for speeding up
+ ``count(*)`` queries using cached table counts, stored in a
+ ``_counts`` table and updated by triggers. This mechanism is
+ described in :ref:`python_api_cached_table_counts`, and can be
+ enabled using Python API methods or the new ``enable-counts``
+ CLI command.
+ * ``table.enable_counts()`` method for enabling these triggers
+ on a specific table.
+ * ``db.enable_counts()`` method for enabling triggers on every
+ table in the database.
+ * New ``sqlite-utils enable-counts my.db`` command for enabling
+ counts on all or specific tables, see :ref:`cli_enable_counts`.
+ * New ``sqlite-utils triggers`` command for listing the triggers
+ defined for a database or specific tables.
+ * New ``db.use_counts_table`` property which, if ``True``, causes
+ ``table.count`` to read from the ``_counts`` table.
+ * ``table.has_counts_triggers`` property revealing if a table has
+ been configured with the new ``_counts`` database triggers.
+ * ``db.reset_counts()`` method and ``sqlite-utils reset-counts``
+ command for resetting the values in the ``_counts`` table.
+ * The previously undocumented ``db.escape()`` method has been
+ renamed to ``db.quote()``.
+ * New ``table.triggers_dict`` and ``db.triggers_dict``
+ introspection properties.
+ * ``sqlite-utils insert`` now shows a more useful error message
+ for invalid JSON.
+- Updates for 3.1.1
+ * Fixed failing test caused by ``optimize`` sometimes creating
+ larger database files.
+ * Documentation now lives on https://sqlite-utils.datasette.io/
+ * README now includes ``brew install sqlite-utils`` installation method.
+- Updates for 3.1
+ * New command: ``sqlite-utils analyze-tables my.db`` outputs useful
+ information about the table columns in the database, such as the
+ number of distinct values and how many rows are null.
+ * New ``table.analyze_column(column)`` Python method used by the
+ ``analyze-tables`` command - see :ref:`python_api_analyze_column`.
+ * The ``table.update()`` method now correctly handles values that
+ should be stored as JSON.
+- Updates for 3.0
+ * This release introduces a new ``sqlite-utils search`` command
+ for searching tables, see :ref:`cli_search`.
+ * The ``table.search()`` method has been redesigned.
+ * The release includes minor backwards-incompatible changes, hence
+ the version bump to 3.0. Those changes, which should not affect
+ most users, are:
+ * The ``-c`` shortcut option for outputting CSV is no longer
+ available. The full ``--csv`` option is required instead.
+ * The ``-f`` shortcut for ``--fmt`` has also been removed - use
+ ``--fmt``.
+ * The ``table.search()`` method now defaults to sorting by
+ relevance, not sorting by ``rowid``.
+ * The ``table.search()`` method now returns a generator over a list
+ of Python dictionaries. It previously returned a list of tuples.
+ * The ``query``, ``tables``, ``rows`` and ``search`` CLI commands
+ now accept a new ``--tsv`` option which outputs the results in TSV.
+ * A new ``table.virtual_table_using`` property reveals if a table
+ is a virtual table, and returns the upper case type of virtual
+ table (e.g. ``FTS4`` or ``FTS5``) if it is. It returns ``None``
+ if the table is not a virtual table.
+ * The new ``table.search_sql()`` method returns the SQL for
+ searching a table, see :ref:`python_api_fts_search_sql`.
+ * ``sqlite-utils rows`` now accepts multiple optional ``-c``
+ parameters specifying the columns to return.
+ * The ``sqlite-utils search`` command now defaults to returning
+ every result, unless you add a ``--limit 20`` option.
+ * The ``sqlite-utils search -c`` and ``table.search(columns=[])``
+ options are now fully respected.
+- Skip python2 because python-sqlite-fts4 don't support it.
+- Skip python36 because python-panda don't support it.
+
+-------------------------------------------------------------------
Old:
----
sqlite-utils-2.16.tar.gz
New:
----
sqlite-utils-3.5.tar.gz
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Other differences:
------------------
++++++ python-sqlite-utils.spec ++++++
--- /var/tmp/diff_new_pack.3FHiqh/_old 2021-02-19 23:45:46.315393193 +0100
+++ /var/tmp/diff_new_pack.3FHiqh/_new 2021-02-19 23:45:46.319393196 +0100
@@ -1,7 +1,7 @@
#
# spec file for package python-sqlite-utils
#
-# Copyright (c) 2020 SUSE LLC
+# Copyright (c) 2021 SUSE LLC
#
# All modifications and additions to the file contributed by third parties
# remain the property of their copyright owners, unless otherwise agreed
@@ -18,32 +18,34 @@
%{?!python_module:%define python_module() python-%{**} python3-%{**}}
%define skip_python2 1
+%define skip_python36 1
Name: python-sqlite-utils
-Version: 2.16
+Version: 3.5
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
+BuildRequires: %{python_module click-default-group}
+BuildRequires: %{python_module click}
+BuildRequires: %{python_module hypothesis}
+BuildRequires: %{python_module pandas}
+BuildRequires: %{python_module pytest-runner}
+BuildRequires: %{python_module pytest}
BuildRequires: %{python_module setuptools}
+BuildRequires: %{python_module sqlite-fts4}
+BuildRequires: %{python_module tabulate}
+BuildRequires: %{pythons}
BuildRequires: fdupes
BuildRequires: python-rpm-macros
Requires: python-click
Requires: python-click-default-group
+Requires: python-sqlite-fts4
Requires: python-tabulate
Requires(post): update-alternatives
Requires(postun): update-alternatives
BuildArch: noarch
-# SECTION test requirements
-BuildRequires: %{python_module click-default-group}
-BuildRequires: %{python_module click}
-BuildRequires: %{python_module numpy}
-BuildRequires: %{python_module pandas}
-BuildRequires: %{python_module pytest}
-BuildRequires: %{python_module tabulate}
-BuildRequires: %pythons
-# /SECTION
%python_subpackages
%description
@@ -51,8 +53,6 @@
%prep
%setup -q -n sqlite-utils-%{version}
-sed -i '/setup_requires=/d;s/"black"//' setup.py
-rm tests/test_black.py
%build
%python_build
++++++ sqlite-utils-2.16.tar.gz -> sqlite-utils-3.5.tar.gz ++++++
++++ 8277 lines of diff (skipped)
