Hello community, here is the log from the commit of package python-apsw for openSUSE:Factory checked in at 2020-03-04 09:39:46 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Comparing /work/SRC/openSUSE:Factory/python-apsw (Old) and /work/SRC/openSUSE:Factory/.python-apsw.new.26092 (New) ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Package is "python-apsw" Wed Mar 4 09:39:46 2020 rev:7 rq:781138 version:3.31.1_r1 Changes: -------- --- /work/SRC/openSUSE:Factory/python-apsw/python-apsw.changes 2020-02-05 19:42:03.679277962 +0100 +++ /work/SRC/openSUSE:Factory/.python-apsw.new.26092/python-apsw.changes 2020-03-04 09:40:25.633928567 +0100 @@ -1,0 +2,8 @@ +Tue Mar 3 09:44:34 UTC 2020 - Tomáš Chvátal <[email protected]> + +- Update the sqlite dependency +- Update to 3.31.1: + * Fix deprecated universal newline use in shell (#283) + * Shell now uses pragma function_list to get list of functions for tab completion + +------------------------------------------------------------------- @@ -9 +16,0 @@ - Old: ---- 3.30.1-r1.tar.gz New: ---- 3.31.1-r1.tar.gz ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Other differences: ------------------ ++++++ python-apsw.spec ++++++ --- /var/tmp/diff_new_pack.iGXe6P/_old 2020-03-04 09:40:36.665935179 +0100 +++ /var/tmp/diff_new_pack.iGXe6P/_new 2020-03-04 09:40:36.689935194 +0100 @@ -17,9 +17,9 @@ %{?!python_module:%define python_module() python-%{**} python3-%{**}} -%define tarver 3.30.1-r1 +%define tarver 3.31.1-r1 Name: python-apsw -Version: 3.30.1_r1 +Version: 3.31.1_r1 Release: 0 Summary: Another Python SQLite Wrapper License: Zlib @@ -30,7 +30,7 @@ BuildRequires: %{python_module setuptools} BuildRequires: pkgconfig BuildRequires: python-rpm-macros -BuildRequires: sqlite3-devel +BuildRequires: sqlite3-devel >= 3.30 %python_subpackages %description ++++++ 3.30.1-r1.tar.gz -> 3.31.1-r1.tar.gz ++++++ diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/apsw-3.30.1-r1/LICENSE new/apsw-3.31.1-r1/LICENSE --- old/apsw-3.30.1-r1/LICENSE 2019-11-05 19:55:05.000000000 +0100 +++ new/apsw-3.31.1-r1/LICENSE 2020-02-27 01:55:35.000000000 +0100 @@ -1,4 +1,4 @@ -Copyright (c) 2004-2019 Roger Binns <[email protected]> +Copyright (c) 2004-2020 Roger Binns <[email protected]> See src/traceback.c for code by Greg Ewing. All code and documentation is provided under this license: diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/apsw-3.30.1-r1/Makefile new/apsw-3.31.1-r1/Makefile --- old/apsw-3.30.1-r1/Makefile 2019-11-05 19:55:05.000000000 +0100 +++ new/apsw-3.31.1-r1/Makefile 2020-02-27 01:55:35.000000000 +0100 @@ -1,8 +1,8 @@ -SQLITEVERSION=3.30.1 +SQLITEVERSION=3.31.1 APSWSUFFIX=-r1 -RELEASEDATE="5 November 2019" +RELEASEDATE="24 February 2020" VERSION=$(SQLITEVERSION)$(APSWSUFFIX) VERDIR=apsw-$(VERSION) diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/apsw-3.30.1-r1/checksums new/apsw-3.31.1-r1/checksums --- old/apsw-3.30.1-r1/checksums 2019-11-05 19:55:05.000000000 +0100 +++ new/apsw-3.31.1-r1/checksums 2020-02-27 01:55:35.000000000 +0100 @@ -10,27 +10,6 @@ # more peace of mind because the SQLite releases are not signed in any # way. -https://sqlite.org/2018/sqlite-amalgamation-3220000.zip 2152750 cc91d8907ebfafae6752ac9694ddd566cfa5db5d 490d167d91d58d3dc5a03a99a5dcef7c -https://sqlite.org/2018/sqlite-autoconf-3220000.tar.gz 2644649 2fb24ec12001926d5209d2da90d252b9825366ac 96b5648d542e8afa6ab7ffb8db8ddc3d - -https://sqlite.org/2018/sqlite-amalgamation-3230100.zip 2183147 98729f2c2d57d166e3d6d9862744c1d66388e286 c3a8512bec4ba0de2a19af5c0e678d15 -https://sqlite.org/2018/sqlite-autoconf-3230100.tar.gz 2675362 0edbfd75ececb95e8e6448d6ff33df82774c9646 99a51b40a66872872a91c92f6d0134fa -https://sqlite.org/2018/sqlite-amalgamation-3230000.zip 2181652 2dc974087041cf1cf3a4682a4485403f2d0910d6 7e6e17c7af5595bf9d40233ca8c20dce -https://sqlite.org/2018/sqlite-autoconf-3230000.tar.gz 2674030 ef55baa06f46808b9798f8447ba6a0115b23c5d2 6a26a122a18bcd1a6a1c18b4bad64498 - -https://sqlite.org/2018/sqlite-amalgamation-3240000.zip 2206612 fed8b1c04c63ce200773586422c9976b54f408cc 4ea1e0c6e7e82cb0490d4753d6878698 -https://sqlite.org/2018/sqlite-autoconf-3240000.tar.gz 2699252 da68915e3563b5244cbcdb6c7e20fb35559bcfc6 dcd96fb9bbb603d29f6b0ad9554932ee - -https://sqlite.org/2018/sqlite-amalgamation-3250200.zip 2270787 c9ff08b91a0faacabe2acb240e5dba3cf81071f3 1f77a23c13abca1cc89cd5f06c55f6e2 -https://sqlite.org/2018/sqlite-autoconf-3250200.tar.gz 2763876 aedfbdc14eb700099434d6a743135743cff47393 bfade31d59f58badc51aeaa6ae26a5de -https://sqlite.org/2018/sqlite-amalgamation-3250100.zip 2270677 c6a44ad5cc67ed8824d1346d4d7e488527754667 e250c9a06858c1018896ef56a13c1d08 -https://sqlite.org/2018/sqlite-autoconf-3250100.tar.gz 2763831 1d494ca2355ffe8ddbeea7cf615ef61122fe421e d73c42c86012ef5c88d0877fa22b9f99 -https://sqlite.org/2018/sqlite-amalgamation-3250000.zip 2270614 6a40382ffe6c4c4e53a82a6732761d41a9be4462 3e747bff1655150b7c3f1b2fda51ab36 -https://sqlite.org/2018/sqlite-autoconf-3250000.tar.gz 2763727 9188a22f358823aaec649921fb3e21c07f8b6076 323e65542efab5a549baa7362b888246 - -https://sqlite.org/2018/sqlite-amalgamation-3260000.zip 2286469 a7405b6a3e59287db589fc0efcc72ccf46ae7ed0 fd498355dc921c6ed179a59e5755e8cd -https://sqlite.org/2018/sqlite-autoconf-3260000.tar.gz 2779667 9af2df1a6da5db6e2ecf3f463625f16740e036e9 ac2b3b8cd3a97600e36fb8e756e8dda1 - https://sqlite.org/2019/sqlite-amalgamation-3270200.zip 2302620 0bafa4f52c19b8a917ad31048d22787d2e25be68 d995b90650f3ac11f847e0e81be8bf93 https://sqlite.org/2019/sqlite-autoconf-3270200.tar.gz 2797531 5f5750e3f39b7b60394a2fb6ddb2371f848670e6 1f72631ce6e8efa5b4a6e55a43b3bdc0 https://sqlite.org/2019/sqlite-amalgamation-3270100.zip 2302866 3c76f6eb644d95f8bb8bc15f728b5936e138a0c1 16717b26358ba81f0bfdac07addc77da @@ -48,3 +27,8 @@ https://sqlite.org/2019/sqlite-autoconf-3300000.tar.gz 2848866 785c0f6f00fe1871cb1dd97893267cb50db03b9b 84230638d5b80b61843e43b5efcb9e53 https://sqlite.org/2019/sqlite-amalgamation-3300100.zip 2352477 ff9b4e140fe0764bc7bc802facf5ac164443f517 679e8d5f73e26c6b85dd1f1de24355b6 https://sqlite.org/2019/sqlite-autoconf-3300100.tar.gz 2848951 8383f29d53fa1d4383e4c8eb3e087f2ed940a9e0 51252dc6bc9094ba11ab151ba650ff3c + +https://sqlite.org/2020/sqlite-amalgamation-3310100.zip 2389909 a58e91a39b7b4ab720dbc843c201fb6a18eaf32b 2b7bfcdd97dc281903a9aee966213fe4 +https://sqlite.org/2020/sqlite-autoconf-3310100.tar.gz 2887243 0c30f5b22152a8166aa3bebb0f4bc1f3e9cc508b 2d0a553534c521504e3ac3ad3b90f125 +https://sqlite.org/2020/sqlite-amalgamation-3310000.zip 2389710 d31831b4ac9f31e9c77aa52156dc4ff48a48a966 94373c4a03332d97bdd7ffb47abed395 +https://sqlite.org/2020/sqlite-autoconf-3310000.tar.gz 2887038 8488afaa1cb452a1ac7ee4db1505eaef60341ab2 192fa6d1b1bed70c1d0c7fa571ae6c9f \ No newline at end of file diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/apsw-3.30.1-r1/doc/changes.rst new/apsw-3.31.1-r1/doc/changes.rst --- old/apsw-3.30.1-r1/doc/changes.rst 2019-11-05 19:55:05.000000000 +0100 +++ new/apsw-3.31.1-r1/doc/changes.rst 2020-02-27 01:55:35.000000000 +0100 @@ -2,6 +2,22 @@ ************** .. currentmodule:: apsw +3.31.1-r1 +========= + +Various updates due to year change + +Fix deprecated universal newline use in shell (:issue:`283`) + +Shell now uses `pragma function_list` to get list of functions for tab completion + +Added constants: + +* SQLITE_DBCONFIG_TRUSTED_SCHEMA, SQLITE_DBCONFIG_LEGACY_FILE_FORMAT, + SQLITE_CONSTRAINT_PINNED, SQLITE_OK_SYMLINK, SQLITE_CANTOPEN_SYMLINK, + SQLITE_FCNTL_CKPT_DONE, SQLITE_OPEN_NOFOLLOW, SQLITE_VTAB_DIRECTONLY, + + 3.30.1-r1 ========= diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/apsw-3.30.1-r1/doc/conf.py new/apsw-3.31.1-r1/doc/conf.py --- old/apsw-3.30.1-r1/doc/conf.py 2019-11-05 19:55:05.000000000 +0100 +++ new/apsw-3.31.1-r1/doc/conf.py 2020-02-27 01:55:35.000000000 +0100 @@ -48,7 +48,7 @@ # General substitutions. project = u'APSW' -copyright = u'2004-2019, Roger Binns <[email protected]>' +copyright = u'2004-2020, Roger Binns <[email protected]>' # The default replacements for |version| and |release|, also used in various # other places throughout the built documents. diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/apsw-3.30.1-r1/doc/copyright.rst new/apsw-3.31.1-r1/doc/copyright.rst --- old/apsw-3.30.1-r1/doc/copyright.rst 2019-11-05 19:55:05.000000000 +0100 +++ new/apsw-3.31.1-r1/doc/copyright.rst 2020-02-27 01:55:35.000000000 +0100 @@ -1,7 +1,7 @@ Copyright and License ===================== -Copyright (C) 2004-2019 `Roger Binns <mailto:[email protected]>`_ +Copyright (C) 2004-2020 `Roger Binns <mailto:[email protected]>`_ See src/traceback.c for code by Greg Ewing. This software is provided 'as-is', without any express or implied diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/apsw-3.30.1-r1/doc/download.rst new/apsw-3.31.1-r1/doc/download.rst --- old/apsw-3.30.1-r1/doc/download.rst 2019-11-05 19:55:05.000000000 +0100 +++ new/apsw-3.31.1-r1/doc/download.rst 2020-02-27 01:55:35.000000000 +0100 @@ -24,71 +24,71 @@ .. downloads-begin -* `apsw-3.30.1-r1.zip - <https://github.com/rogerbinns/apsw/releases/download/3.30.1-r1/apsw-3.30.1-r1.zip>`__ +* `apsw-3.31.1-r1.zip + <https://github.com/rogerbinns/apsw/releases/download/3.31.1-r1/apsw-3.31.1-r1.zip>`__ (Source, includes this HTML Help) * Windows Python 2.3 `32bit - <https://github.com/rogerbinns/apsw/releases/download/3.30.1-r1/apsw-3.30.1-r1.win32-py2.3.exe>`__ + <https://github.com/rogerbinns/apsw/releases/download/3.31.1-r1/apsw-3.31.1-r1.win32-py2.3.exe>`__ * Windows Python 2.4 `32bit - <https://github.com/rogerbinns/apsw/releases/download/3.30.1-r1/apsw-3.30.1-r1.win32-py2.4.exe>`__ + <https://github.com/rogerbinns/apsw/releases/download/3.31.1-r1/apsw-3.31.1-r1.win32-py2.4.exe>`__ * Windows Python 2.5 `32bit - <https://github.com/rogerbinns/apsw/releases/download/3.30.1-r1/apsw-3.30.1-r1.win32-py2.5.exe>`__ + <https://github.com/rogerbinns/apsw/releases/download/3.31.1-r1/apsw-3.31.1-r1.win32-py2.5.exe>`__ * Windows Python 2.6 `32bit - <https://github.com/rogerbinns/apsw/releases/download/3.30.1-r1/apsw-3.30.1-r1.win32-py2.6.exe>`__ + <https://github.com/rogerbinns/apsw/releases/download/3.31.1-r1/apsw-3.31.1-r1.win32-py2.6.exe>`__ `64bit - <https://github.com/rogerbinns/apsw/releases/download/3.30.1-r1/apsw-3.30.1-r1.win-amd64-py2.6.exe>`__ + <https://github.com/rogerbinns/apsw/releases/download/3.31.1-r1/apsw-3.31.1-r1.win-amd64-py2.6.exe>`__ * Windows Python 2.7 `32bit - <https://github.com/rogerbinns/apsw/releases/download/3.30.1-r1/apsw-3.30.1-r1.win32-py2.7.exe>`__ + <https://github.com/rogerbinns/apsw/releases/download/3.31.1-r1/apsw-3.31.1-r1.win32-py2.7.exe>`__ `64bit - <https://github.com/rogerbinns/apsw/releases/download/3.30.1-r1/apsw-3.30.1-r1.win-amd64-py2.7.exe>`__ + <https://github.com/rogerbinns/apsw/releases/download/3.31.1-r1/apsw-3.31.1-r1.win-amd64-py2.7.exe>`__ * Windows Python 3.1 `32bit - <https://github.com/rogerbinns/apsw/releases/download/3.30.1-r1/apsw-3.30.1-r1.win32-py3.1.exe>`__ + <https://github.com/rogerbinns/apsw/releases/download/3.31.1-r1/apsw-3.31.1-r1.win32-py3.1.exe>`__ `64bit - <https://github.com/rogerbinns/apsw/releases/download/3.30.1-r1/apsw-3.30.1-r1.win-amd64-py3.1.exe>`__ + <https://github.com/rogerbinns/apsw/releases/download/3.31.1-r1/apsw-3.31.1-r1.win-amd64-py3.1.exe>`__ * Windows Python 3.2 `32bit - <https://github.com/rogerbinns/apsw/releases/download/3.30.1-r1/apsw-3.30.1-r1.win32-py3.2.exe>`__ + <https://github.com/rogerbinns/apsw/releases/download/3.31.1-r1/apsw-3.31.1-r1.win32-py3.2.exe>`__ `64bit - <https://github.com/rogerbinns/apsw/releases/download/3.30.1-r1/apsw-3.30.1-r1.win-amd64-py3.2.exe>`__ + <https://github.com/rogerbinns/apsw/releases/download/3.31.1-r1/apsw-3.31.1-r1.win-amd64-py3.2.exe>`__ * Windows Python 3.3 `32bit - <https://github.com/rogerbinns/apsw/releases/download/3.30.1-r1/apsw-3.30.1-r1.win32-py3.3.exe>`__ + <https://github.com/rogerbinns/apsw/releases/download/3.31.1-r1/apsw-3.31.1-r1.win32-py3.3.exe>`__ `64bit - <https://github.com/rogerbinns/apsw/releases/download/3.30.1-r1/apsw-3.30.1-r1.win-amd64-py3.3.exe>`__ + <https://github.com/rogerbinns/apsw/releases/download/3.31.1-r1/apsw-3.31.1-r1.win-amd64-py3.3.exe>`__ * Windows Python 3.4 `32bit - <https://github.com/rogerbinns/apsw/releases/download/3.30.1-r1/apsw-3.30.1-r1.win32-py3.4.exe>`__ + <https://github.com/rogerbinns/apsw/releases/download/3.31.1-r1/apsw-3.31.1-r1.win32-py3.4.exe>`__ `64bit - <https://github.com/rogerbinns/apsw/releases/download/3.30.1-r1/apsw-3.30.1-r1.win-amd64-py3.4.exe>`__ + <https://github.com/rogerbinns/apsw/releases/download/3.31.1-r1/apsw-3.31.1-r1.win-amd64-py3.4.exe>`__ * Windows Python 3.5 `32bit - <https://github.com/rogerbinns/apsw/releases/download/3.30.1-r1/apsw-3.30.1-r1.win32-py3.5.exe>`__ + <https://github.com/rogerbinns/apsw/releases/download/3.31.1-r1/apsw-3.31.1-r1.win32-py3.5.exe>`__ `64bit - <https://github.com/rogerbinns/apsw/releases/download/3.30.1-r1/apsw-3.30.1-r1.win-amd64-py3.5.exe>`__ + <https://github.com/rogerbinns/apsw/releases/download/3.31.1-r1/apsw-3.31.1-r1.win-amd64-py3.5.exe>`__ * Windows Python 3.6 `32bit - <https://github.com/rogerbinns/apsw/releases/download/3.30.1-r1/apsw-3.30.1-r1.win32-py3.6.exe>`__ + <https://github.com/rogerbinns/apsw/releases/download/3.31.1-r1/apsw-3.31.1-r1.win32-py3.6.exe>`__ `64bit - <https://github.com/rogerbinns/apsw/releases/download/3.30.1-r1/apsw-3.30.1-r1.win-amd64-py3.6.exe>`__ + <https://github.com/rogerbinns/apsw/releases/download/3.31.1-r1/apsw-3.31.1-r1.win-amd64-py3.6.exe>`__ * Windows Python 3.7 `32bit - <https://github.com/rogerbinns/apsw/releases/download/3.30.1-r1/apsw-3.30.1-r1.win32-py3.7.exe>`__ + <https://github.com/rogerbinns/apsw/releases/download/3.31.1-r1/apsw-3.31.1-r1.win32-py3.7.exe>`__ `64bit - <https://github.com/rogerbinns/apsw/releases/download/3.30.1-r1/apsw-3.30.1-r1.win-amd64-py3.7.exe>`__ + <https://github.com/rogerbinns/apsw/releases/download/3.31.1-r1/apsw-3.31.1-r1.win-amd64-py3.7.exe>`__ * Windows Python 3.8 `32bit - <https://github.com/rogerbinns/apsw/releases/download/3.30.1-r1/apsw-3.30.1-r1.win32-py3.8.exe>`__ + <https://github.com/rogerbinns/apsw/releases/download/3.31.1-r1/apsw-3.31.1-r1.win32-py3.8.exe>`__ `64bit - <https://github.com/rogerbinns/apsw/releases/download/3.30.1-r1/apsw-3.30.1-r1.win-amd64-py3.8.exe>`__ + <https://github.com/rogerbinns/apsw/releases/download/3.31.1-r1/apsw-3.31.1-r1.win-amd64-py3.8.exe>`__ -* `apsw-3.30.1-r1-sigs.zip - <https://github.com/rogerbinns/apsw/releases/download/3.30.1-r1/apsw-3.30.1-r1-sigs.zip>`__ +* `apsw-3.31.1-r1-sigs.zip + <https://github.com/rogerbinns/apsw/releases/download/3.31.1-r1/apsw-3.31.1-r1-sigs.zip>`__ GPG signatures for all files .. downloads-end @@ -127,7 +127,7 @@ To verify a file just use --verify specifying the corresponding ``.asc`` filename. This example verifies the source:: - $ gpg --verify apsw-3.30.1-r1.zip.asc + $ gpg --verify apsw-3.31.1-r1.zip.asc gpg: Signature made ... date ... using DSA key ID 0DFBD904 gpg: Good signature from "Roger Binns <[email protected]>" @@ -187,8 +187,8 @@ Use this (all one command):: - pip install --user https://github.com/rogerbinns/apsw/releases/download/3.30.1-r1/apsw-3.30.1-r1.zip \ - --global-option=fetch --global-option=--version --global-option=3.30.1 --global-option=--all \ + pip install --user https://github.com/rogerbinns/apsw/releases/download/3.31.1-r1/apsw-3.31.1-r1.zip \ + --global-option=fetch --global-option=--version --global-option=3.31.1 --global-option=--all \ --global-option=build --global-option=--enable-all-extensions .. pip-end \ No newline at end of file diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/apsw-3.30.1-r1/doc/index.rst new/apsw-3.31.1-r1/doc/index.rst --- old/apsw-3.30.1-r1/doc/index.rst 2019-11-05 19:55:05.000000000 +0100 +++ new/apsw-3.31.1-r1/doc/index.rst 2020-02-27 01:55:35.000000000 +0100 @@ -3,7 +3,7 @@ .. centered:: APSW |version| released |today| -Use with SQLite 3.28 or later, CPython 2.3 or later, and CPython +Use with SQLite 3.31 or later, CPython 2.3 or later, and CPython 3.1 or later. APSW provides an SQLite 3 wrapper that provides the thinnest layer diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/apsw-3.30.1-r1/setup.py new/apsw-3.31.1-r1/setup.py --- old/apsw-3.30.1-r1/setup.py 2019-11-05 19:55:05.000000000 +0100 +++ new/apsw-3.31.1-r1/setup.py 2020-02-27 01:55:35.000000000 +0100 @@ -76,7 +76,9 @@ if ver: ver=int(ver.group(0)) if ver>=3071600: - if ver>=3270000: + if ver>=3310000: + year="2020" + elif ver>=3270000: year="2019" elif ver>=3220000: year="2018" @@ -356,7 +358,7 @@ write(" Running configure to work out SQLite compilation flags") res=os.system("./configure >/dev/null") defline=None - for line in read_whole_file("Makefile", "rtU").split("\n"): + for line in read_whole_file("Makefile", "rt").split("\n"): if line.startswith("DEFS = "): defline=line break diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/apsw-3.30.1-r1/src/apsw.c new/apsw-3.31.1-r1/src/apsw.c --- old/apsw-3.30.1-r1/src/apsw.c 2019-11-05 19:55:05.000000000 +0100 +++ new/apsw-3.31.1-r1/src/apsw.c 2020-02-27 01:55:35.000000000 +0100 @@ -59,8 +59,8 @@ #include "sqlite3.h" #endif -#if SQLITE_VERSION_NUMBER < 3030000 -#error Your SQLite version is too old. It must be at least 3.30 +#if SQLITE_VERSION_NUMBER < 3031000 +#error Your SQLite version is too old. It must be at least 3.31 #endif /* system headers */ @@ -1532,6 +1532,9 @@ ADDINT(SQLITE_CORRUPT_SEQUENCE), ADDINT(SQLITE_CANTOPEN_DIRTYWAL), ADDINT(SQLITE_ERROR_SNAPSHOT), + ADDINT(SQLITE_CONSTRAINT_PINNED), + ADDINT(SQLITE_OK_SYMLINK), + ADDINT(SQLITE_CANTOPEN_SYMLINK), END, /* error codes */ @@ -1592,6 +1595,7 @@ ADDINT(SQLITE_OPEN_WAL), ADDINT(SQLITE_OPEN_URI), ADDINT(SQLITE_OPEN_MEMORY), + ADDINT(SQLITE_OPEN_NOFOLLOW), END, /* limits */ @@ -1663,6 +1667,8 @@ ADDINT(SQLITE_DBCONFIG_DQS_DDL), ADDINT(SQLITE_DBCONFIG_LEGACY_ALTER_TABLE), ADDINT(SQLITE_DBCONFIG_ENABLE_VIEW), + ADDINT(SQLITE_DBCONFIG_TRUSTED_SCHEMA), + ADDINT(SQLITE_DBCONFIG_LEGACY_FILE_FORMAT), END, DICT("mapping_status"), @@ -1776,6 +1782,7 @@ ADDINT(SQLITE_FCNTL_LOCK_TIMEOUT), ADDINT(SQLITE_FCNTL_DATA_VERSION), ADDINT(SQLITE_FCNTL_SIZE_LIMIT), + ADDINT(SQLITE_FCNTL_CKPT_DONE), END, DICT("mapping_conflict_resolution_modes"), @@ -1788,6 +1795,8 @@ DICT("mapping_virtual_table_configuration_options"), ADDINT(SQLITE_VTAB_CONSTRAINT_SUPPORT), + ADDINT(SQLITE_VTAB_DIRECTONLY), + ADDINT(SQLITE_VTAB_INNOCUOUS), END, DICT("mapping_xshmlock_flags"), diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/apsw-3.30.1-r1/src/apswversion.h new/apsw-3.31.1-r1/src/apswversion.h --- old/apsw-3.30.1-r1/src/apswversion.h 2019-11-05 19:55:05.000000000 +0100 +++ new/apsw-3.31.1-r1/src/apswversion.h 2020-02-27 01:55:35.000000000 +0100 @@ -1 +1 @@ -#define APSW_VERSION "3.30.1-r1" +#define APSW_VERSION "3.31.1-r1" diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/apsw-3.30.1-r1/tests.py new/apsw-3.31.1-r1/tests.py --- old/apsw-3.30.1-r1/tests.py 2019-11-05 19:55:05.000000000 +0100 +++ new/apsw-3.31.1-r1/tests.py 2020-02-27 01:55:35.000000000 +0100 @@ -1048,7 +1048,7 @@ self.assertRaises(ZeroDivisionError, c.execute, "insert into one values(1,2,3)") c.setexectrace(None) self.assertEqual(count, next(c.execute("select count(*) from one"))[0]) - # test across executemany and multiple statments + # test across executemany and multiple statements counter = [0] def tracefunc(cursor, cmd, bindings): diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/apsw-3.30.1-r1/tools/checksums.py new/apsw-3.31.1-r1/tools/checksums.py --- old/apsw-3.30.1-r1/tools/checksums.py 2019-11-05 19:55:05.000000000 +0100 +++ new/apsw-3.31.1-r1/tools/checksums.py 2020-02-27 01:55:35.000000000 +0100 @@ -7,6 +7,8 @@ import re sqlitevers = ( + '3310100', + '3310000', '3300100', '3300000', '3290000', @@ -59,7 +61,9 @@ if ver: ver=int(ver.group(0)) if ver>=3071600: - if ver>=3270000: + if ver>=3310000: + year="2020" + elif ver>=3270000: year="2019" elif ver>=3220000: year="2018" diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/apsw-3.30.1-r1/tools/megatest.py new/apsw-3.31.1-r1/tools/megatest.py --- old/apsw-3.30.1-r1/tools/megatest.py 2019-11-05 19:55:05.000000000 +0100 +++ new/apsw-3.31.1-r1/tools/megatest.py 2020-02-27 01:55:35.000000000 +0100 @@ -222,10 +222,10 @@ # Default versions we support PYVERS = ( - '3.8.0', - '3.7.5', - '3.6.8', - '3.5.6', + '3.8.1', + '3.7.6', + '3.6.10', + '3.5.8', '3.4.9', '3.3.7', '3.2.6', @@ -238,7 +238,7 @@ 'system', ) -SQLITEVERS = ('3.30.0', '3.30.1') +SQLITEVERS = ('3.31.0', '3.31.1') if __name__ == '__main__': nprocs = 0 @@ -255,8 +255,8 @@ nprocs = 1 concurrency = nprocs * 2 - if concurrency > 8: - concurrency = 8 + if concurrency > 24: + concurrency = 24 parser = optparse.OptionParser() parser.add_option("--pyvers", diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/apsw-3.30.1-r1/tools/shell.py new/apsw-3.31.1-r1/tools/shell.py --- old/apsw-3.30.1-r1/tools/shell.py 2019-11-05 19:55:05.000000000 +0100 +++ new/apsw-3.31.1-r1/tools/shell.py 2020-02-27 01:55:35.000000000 +0100 @@ -2136,7 +2136,7 @@ # compile step is needed to associate name with code exec(compile(open(cmd[0]).read(), cmd[0], 'exec'), g, g) else: - f=codecs.open(cmd[0], "rU", self.encoding[0]) + f=codecs.open(cmd[0], "r", self.encoding[0]) try: try: self.push_input() @@ -2764,8 +2764,18 @@ except apsw.SQLError: # See https://github.com/rogerbinns/apsw/issues/86 pass + functions={} + for row in cur.execute("pragma function_list"): + name=row[0] + narg=row[4] + functions[name]=max(narg, functions.get(name, -1)) + def fmtfunc(name, nargs): + if nargs==0: + return name+"()" + return name+"(" + func_list=[fmtfunc(name, narg) for name, narg in functions.items()] - self._completion_cache=[self._sqlite_keywords, self._sqlite_functions, self._sqlite_special_names, collations, databases, other] + self._completion_cache=[self._sqlite_keywords, func_list, self._sqlite_special_names, collations, databases, other] for i in range(len(self._completion_cache)): self._completion_cache[i].sort() diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/apsw-3.30.1-r1/tools/spellcheck.sh new/apsw-3.31.1-r1/tools/spellcheck.sh --- old/apsw-3.30.1-r1/tools/spellcheck.sh 2019-11-05 19:55:05.000000000 +0100 +++ new/apsw-3.31.1-r1/tools/spellcheck.sh 2020-02-27 01:55:35.000000000 +0100 @@ -2,8 +2,8 @@ # https://github.com/rogerbinns/apsw/pull/229 -git grep --color -Eniw '(paramaters|paramater|partifular|seperately|desribes|seperate|seperated|begining|targetted|libary|interpretter|entireity|publically|noone|commiting|statment|simulataneous|exection|wierd|valueable)' | grep -v tools/spellcheck.sh +git grep --color -Eniw '(paramaters|paramater|partifular|seperately|desribes|seperate|seperated|begining|targetted|libary|interpretter|entireity|publically|noone|commiting|statment|statments|simulataneous|exection|wierd|valueable)' | grep -v tools/spellcheck.sh -n=`git grep --color -Eniw '(paramaters|paramater|partifular|seperately|desribes|seperate|seperated|begining|targetted|libary|interpretter|entireity|publically|noone|commiting|statment|simulataneous|exection|wierd|valueable)' | grep -v tools/spellcheck.sh | wc -l` +n=`git grep --color -Eniw '(paramaters|paramater|partifular|seperately|desribes|seperate|seperated|begining|targetted|libary|interpretter|entireity|publically|noone|commiting|statment|statments|simulataneous|exection|wierd|valueable)' | grep -v tools/spellcheck.sh | wc -l` if [ $n -gt 0 ] ; then exit 1 ; else exit 0 ; fi
