Script 'mail_helper' called by obssrc
Hello community,
here is the log from the commit of package python-apsw for openSUSE:Factory
checked in at 2024-09-30 15:38:11
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Comparing /work/SRC/openSUSE:Factory/python-apsw (Old)
and /work/SRC/openSUSE:Factory/.python-apsw.new.29891 (New)
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Package is "python-apsw"
Mon Sep 30 15:38:11 2024 rev:27 rq:1204392 version:3.46.1.0
Changes:
--------
--- /work/SRC/openSUSE:Factory/python-apsw/python-apsw.changes 2024-07-01
11:22:45.308265434 +0200
+++ /work/SRC/openSUSE:Factory/.python-apsw.new.29891/python-apsw.changes
2024-09-30 15:38:38.616629278 +0200
@@ -1,0 +2,7 @@
+Sat Sep 28 19:15:48 UTC 2024 - Dirk Müller <dmuel...@suse.com>
+
+- update to 3.46.1.0:
+ * The shell dump command outputs the application_id in addition
+ to the user_version.
+
+-------------------------------------------------------------------
Old:
----
apsw-3.46.0.1.tar.gz
New:
----
apsw-3.46.1.0.tar.gz
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Other differences:
------------------
++++++ python-apsw.spec ++++++
--- /var/tmp/diff_new_pack.NUQWYL/_old 2024-09-30 15:38:39.900682802 +0200
+++ /var/tmp/diff_new_pack.NUQWYL/_new 2024-09-30 15:38:39.904682969 +0200
@@ -18,7 +18,7 @@
%{?sle15_python_module_pythons}
Name: python-apsw
-Version: 3.46.0.1
+Version: 3.46.1.0
Release: 0
Summary: Another Python SQLite Wrapper
License: Zlib
++++++ apsw-3.46.0.1.tar.gz -> apsw-3.46.1.0.tar.gz ++++++
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn'
'--exclude=.svnignore' old/apsw-3.46.0.1/.github/workflows/build-pypi.yml
new/apsw-3.46.1.0/.github/workflows/build-pypi.yml
--- old/apsw-3.46.0.1/.github/workflows/build-pypi.yml 2024-06-16
21:44:24.000000000 +0200
+++ new/apsw-3.46.1.0/.github/workflows/build-pypi.yml 2024-08-13
22:12:10.000000000 +0200
@@ -14,7 +14,7 @@
- uses: actions/checkout@v4
- name: Build wheels
- uses: pypa/cibuildwheel@v2.19
+ uses: pypa/cibuildwheel@v2.20
env:
CIBW_SKIP: pp*
CIBW_BEFORE_BUILD: python -c "import shutil ;
shutil.copyfile('tools/setup-pypi.cfg','setup.apsw')"
@@ -42,11 +42,10 @@
platforms: all
- name: Build wheels
- uses: pypa/cibuildwheel@v2.19
+ uses: pypa/cibuildwheel@v2.20
env:
CIBW_SKIP: pp*
CIBW_ARCHS_LINUX: ${{ matrix.arch }}
- CIBW_PROJECT_REQUIRES_PYTHON: ">= 3.10"
CIBW_BEFORE_BUILD: python -c "import shutil ;
shutil.copyfile('tools/setup-pypi.cfg','setup.apsw')"
CIBW_TEST_COMMAND: python -m apsw.tests -v
APSW_HEAVY_DURATION: 2
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn'
'--exclude=.svnignore' old/apsw-3.46.0.1/.github/workflows/build-testpypi.yml
new/apsw-3.46.1.0/.github/workflows/build-testpypi.yml
--- old/apsw-3.46.0.1/.github/workflows/build-testpypi.yml 2024-06-16
21:44:24.000000000 +0200
+++ new/apsw-3.46.1.0/.github/workflows/build-testpypi.yml 2024-08-13
22:12:10.000000000 +0200
@@ -14,7 +14,7 @@
- uses: actions/checkout@v4
- name: Build wheels
- uses: pypa/cibuildwheel@v2.19
+ uses: pypa/cibuildwheel@v2.20
env:
CIBW_SKIP: pp*
CIBW_BEFORE_BUILD: python -c "import shutil ;
shutil.copyfile('tools/setup-pypi.cfg','setup.apsw')"
@@ -42,11 +42,10 @@
platforms: all
- name: Build wheels
- uses: pypa/cibuildwheel@v2.19
+ uses: pypa/cibuildwheel@v2.20
env:
CIBW_SKIP: pp*
CIBW_ARCHS_LINUX: ${{ matrix.arch }}
- CIBW_PROJECT_REQUIRES_PYTHON: ">= 3.10"
CIBW_BEFORE_BUILD: python -c "import shutil ;
shutil.copyfile('tools/setup-pypi.cfg','setup.apsw')"
CIBW_TEST_COMMAND: python -m apsw.tests -v
APSW_HEAVY_DURATION: 2
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn'
'--exclude=.svnignore' old/apsw-3.46.0.1/Makefile new/apsw-3.46.1.0/Makefile
--- old/apsw-3.46.0.1/Makefile 2024-06-16 21:44:24.000000000 +0200
+++ new/apsw-3.46.1.0/Makefile 2024-08-13 22:12:10.000000000 +0200
@@ -1,8 +1,8 @@
-SQLITEVERSION=3.46.0
-APSWSUFFIX=.1
+SQLITEVERSION=3.46.1
+APSWSUFFIX=.0
-RELEASEDATE="17 June 2024"
+RELEASEDATE="13 August 2024"
VERSION=$(SQLITEVERSION)$(APSWSUFFIX)
VERDIR=apsw-$(VERSION)
@@ -178,6 +178,8 @@
-cmd /c del /s /q build
-cmd /c del /s /q .venv
-cmd /c md dist
+ $(MAKE) compile-win-one PYTHON=c:/python313/python
+ $(MAKE) compile-win-one PYTHON=c:/python313-32/python
$(MAKE) compile-win-one PYTHON=c:/python312/python
$(MAKE) compile-win-one PYTHON=c:/python312-32/python
$(MAKE) compile-win-one PYTHON=c:/python311/python
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn'
'--exclude=.svnignore' old/apsw-3.46.0.1/apsw/shell.py
new/apsw-3.46.1.0/apsw/shell.py
--- old/apsw-3.46.0.1/apsw/shell.py 2024-06-16 21:44:24.000000000 +0200
+++ new/apsw-3.46.1.0/apsw/shell.py 2024-08-13 22:12:10.000000000 +0200
@@ -1477,13 +1477,16 @@
self.write(self.stdout, "ANALYZE " +
self._fmt_sql_identifier(n) + ";\n")
blank()
- # user version pragma
- uv = self.db.pragma("user_version")
- if uv:
- comment(
- "Your database may need this. It is sometimes used to
keep track of the schema version."
- )
- self.write(self.stdout, "pragma user_version=%d;" % (uv, ))
+ # header fields
+ count = 0
+ for name in ("user_version", "application_id"):
+ val = self.db.pragma(name)
+ if val:
+ if count == 0:
+ comment("Database header")
+ self.write(self.stdout, f"pragma {name}={val};\n")
+ count += 1
+ if count:
blank()
# Save it all
@@ -2118,12 +2121,13 @@
def command_mode(self, cmd):
"""mode MODE ?OPTIONS?: Sets output mode to one of"""
if not cmd:
- raise self.Error("Specify an output mode")
+ raise self.Error("Specify an output mode - use .help mode for
detailed list")
w = cmd[0]
if w == "tabs":
w = "list"
if not hasattr(self, "output_" + w):
- raise self.Error("Expected a valid output mode: " + ",
".join(self._output_modes))
+ raise self.Error("Expected a valid output mode: " + ",
".join(self._output_modes) +
+ "\nUse .help mode for a detailed list")
m = getattr(self, "output_" + w)
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn'
'--exclude=.svnignore' old/apsw-3.46.0.1/checksums new/apsw-3.46.1.0/checksums
--- old/apsw-3.46.0.1/checksums 2024-06-16 21:44:24.000000000 +0200
+++ new/apsw-3.46.1.0/checksums 2024-08-13 22:12:10.000000000 +0200
@@ -8,6 +8,7 @@
# more peace of mind because the SQLite releases are not signed in any
# way.
+https://sqlite.org/2024/sqlite-autoconf-3460100.tar.gz 3265571
67d3fe6d268e6eaddcae3727fce58fcc8e9c53869bdd07a0c61e38ddf2965071
923f68143dcd9fc0c38778dee253fd6540a91f578173a04ca5adff885d8a8fbb
https://sqlite.org/2024/sqlite-autoconf-3460000.tar.gz 3265248
6f8e6a7b335273748816f9b3b62bbdc372a889de8782d7f048c653a447417a7d
83d2acf79453deb7d6520338b1f4585f12e39b27cd370fb08593afa198f471fc
https://sqlite.org/2024/sqlite-autoconf-3450300.tar.gz 3235957
b2809ca53124c19c60f42bf627736eae011afdcc205bb48270a5ee9a38191531
cc1050780e0266de4d91b31c8deaf4638336908c12c21898e9f1fcae1e2ac303
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn'
'--exclude=.svnignore' old/apsw-3.46.0.1/doc/changes.rst
new/apsw-3.46.1.0/doc/changes.rst
--- old/apsw-3.46.0.1/doc/changes.rst 2024-06-16 21:44:24.000000000 +0200
+++ new/apsw-3.46.1.0/doc/changes.rst 2024-08-13 22:12:10.000000000 +0200
@@ -10,6 +10,21 @@
APSW changes by version
-----------------------
+3.46.1.0
+========
+
+The shell :ref:`dump <shell-cmd-dump>` command outputs the
+`application_id
+<https://www.sqlite.org/pragma.html#pragma_application_id>`__ in
+addition to the `user_version
+<https://www.sqlite.org/pragma.html#pragma_user_version>`__.
+
+`PyPI <https://pypi.org/project/apsw/>`__ binary builds for `Python
+3.13 now available
+<https://github.com/pypa/cibuildwheel/releases/tag/v2.20.0>`__, as
+well as `older Python ARM64
+<https://github.com/rogerbinns/apsw/pull/530>`__ are available.
+
3.46.0.1
========
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn'
'--exclude=.svnignore' old/apsw-3.46.0.1/doc/install.rst
new/apsw-3.46.1.0/doc/install.rst
--- old/apsw-3.46.0.1/doc/install.rst 2024-06-16 21:44:24.000000000 +0200
+++ new/apsw-3.46.1.0/doc/install.rst 2024-08-13 22:12:10.000000000 +0200
@@ -35,6 +35,12 @@
pip will download the source release and automatically compile with the same
settings. It will
require a C compiler and the Python development header files.
+Encryption
+^^^^^^^^^^
+
+APSW compiled against SQLite with `SQLite3MultipleCiphers
+<https://utelle.github.io/SQLite3MultipleCiphers/>`__ is available via
+its author at https://pypi.org/project/apsw-sqlite3mc/
Linux/BSD provided
------------------
@@ -74,12 +80,12 @@
.. downloads-begin
-* `apsw-3.46.0.1.zip
-
<https://github.com/rogerbinns/apsw/releases/download/3.46.0.1/apsw-3.46.0.1.zip>`__
+* `apsw-3.46.1.0.zip
+
<https://github.com/rogerbinns/apsw/releases/download/3.46.1.0/apsw-3.46.1.0.zip>`__
(Source, includes this HTML Help)
-* `apsw-3.46.0.1.cosign-bundle
-
<https://github.com/rogerbinns/apsw/releases/download/3.46.0.1/apsw-3.46.0.1.cosign-bundle>`__
+* `apsw-3.46.1.0.cosign-bundle
+
<https://github.com/rogerbinns/apsw/releases/download/3.46.1.0/apsw-3.46.1.0.cosign-bundle>`__
cosign signature
.. downloads-end
@@ -114,8 +120,8 @@
.. code-block:: console
- $ cosign verify-blob apsw-3.46.0.1.zip \
- --bundle apsw-3.46.0.1.cosign-bundle \
+ $ cosign verify-blob apsw-3.46.1.0.zip \
+ --bundle apsw-3.46.1.0.cosign-bundle \
--certificate-identity=rog...@rogerbinns.com \
--certificate-oidc-issuer=https://github.com/login/oauth
Verified OK
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn'
'--exclude=.svnignore' old/apsw-3.46.0.1/doc/pysqlite.rst
new/apsw-3.46.1.0/doc/pysqlite.rst
--- old/apsw-3.46.0.1/doc/pysqlite.rst 2024-06-16 21:44:24.000000000 +0200
+++ new/apsw-3.46.1.0/doc/pysqlite.rst 2024-08-13 22:12:10.000000000 +0200
@@ -98,9 +98,17 @@
data being returned (it silently ignores any returned data).
* APSW has better :ref:`execution and row tracing <tracing>`.
- :doc:`ext` provides accessing rows by column name, adapting and
- converting types going into and coming out of SQLite, getting query
- details etc.
+
+* :doc:`ext` includes:
+
+ - Pretty printing query results
+ - Forwarding SQLite log messages to the Python logger
+ - Helper for implementing the complex xBestIndex method on your own
+ virtual tables
+ - A wrapper to turn Python functions into virtual tables, including
+ taking positional and keyword arguments
+ - Converting data types going into and out of SQlite
+ - Detailed query information
* sqlite3 swallows exceptions in your callbacks making it far harder
to debug problems. That also prevents you from raising exceptions in
@@ -176,11 +184,20 @@
example try returning an unsupported type from a registered scalar
function.
-* APSW is faster than sqlite3 in my testing. Try the
- :ref:`speedtest` benchmark.
+* APSW includes a :doc:`full featured shell <shell>`. sqlite3 has a
+ `simple one
+ <https://docs.python.org/3/library/sqlite3.html#command-line-interface>`__
+ available since Python 3.12.`
+
+* APSW is faster than sqlite3 in my testing. Try the :ref:`speedtest`
+ benchmark. All C code in APSW called by Python implements the
+ fastcall mechanism, as does most of sqlite3. All code called from C
+ in APSW also uses fastcall, while sqlite3 uses the older mechanism
+ that is `significantly slower
+ <https://github.com/rogerbinns/python-fastcall>`__.
What sqlite3 does better
========================
* sqlite3 is part of the standard library, and is widely supported by
- libraries that abstract away the database layer
\ No newline at end of file
+ libraries that abstract away the database layer.
\ No newline at end of file
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn'
'--exclude=.svnignore' old/apsw-3.46.0.1/src/apswversion.h
new/apsw-3.46.1.0/src/apswversion.h
--- old/apsw-3.46.0.1/src/apswversion.h 2024-06-16 21:44:24.000000000 +0200
+++ new/apsw-3.46.1.0/src/apswversion.h 2024-08-13 22:12:10.000000000 +0200
@@ -1 +1 @@
-#define APSW_VERSION "3.46.0.1"
+#define APSW_VERSION "3.46.1.0"
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn'
'--exclude=.svnignore' old/apsw-3.46.0.1/tools/checksums.py
new/apsw-3.46.1.0/tools/checksums.py
--- old/apsw-3.46.0.1/tools/checksums.py 2024-06-16 21:44:24.000000000
+0200
+++ new/apsw-3.46.1.0/tools/checksums.py 2024-08-13 22:12:10.000000000
+0200
@@ -11,6 +11,7 @@
import setup
sqlitevers = (
+ '3460100',
'3460000',
'3450300',
'3450200',
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn'
'--exclude=.svnignore' old/apsw-3.46.0.1/tools/megatest.py
new/apsw-3.46.1.0/tools/megatest.py
--- old/apsw-3.46.0.1/tools/megatest.py 2024-06-16 21:44:24.000000000 +0200
+++ new/apsw-3.46.1.0/tools/megatest.py 2024-08-13 22:12:10.000000000 +0200
@@ -205,12 +205,13 @@
# Default versions we support
PYVERS = (
- '3.13.0b2',
- '3.12.4',
+ '3.14.0a0',
+ '3.13.0rc1',
+ '3.12.5',
'3.11.9',
- '3.10.13',
- '3.9.18',
- '3.8.18',
+ '3.10.14',
+ '3.9.19',
+ '3.8.19',
'system',
)
