CVS commit: pkgsrc/databases/py-apsw

["Adam Ciarcinski" <adam%netbsd.org@localhost>]

Module Name:    pkgsrc
Committed By:   adam
Date:           Tue Nov 19 22:52:08 UTC 2024

Modified Files:
        pkgsrc/databases/py-apsw: Makefile PLIST distinfo

Log Message:
py-apsw: updated to 3.47.0.0

3.47.0.0

Support for Python 3.8 removed (APSW issue 539).

The readonly database statistics virtual table (dbstat) is enabled by default for PyPI builds, and when --enable-all-extensions is passed to manual builds.

Added recursive triggers and optimize to apsw.bestpractice.

Multiple callbacks can be present for Connection.trace_v2() with APSW ensuring they are all called (APSW issue 502)

Connection.trace_v2() callback information now has trigger, id, and total_changes fields.

Added Connection.data_version for getting a change counter. pragma data_version doesn’t update when changes are made on the same connection, only others.

Added apsw.ext.ShowResourceUsage() for getting resource and SQLite usage in a context block, and also use it for the shell timer command.

Added apsw.ext.Trace() for tracing SQL execution, row and change counting, and timing per statement for use in a context block.

Added FTS5 support including registering and calling tokenizers, and auxiliary functions. The apsw.fts5 module provides many additional classes and methods for working with FTS5, including tokenizers 
for HTML, JSON, regular expressions, support tokenizers for synonyms, stop words, transformers, and a Table class that wraps access to a FTS5 table (including creating one) with search(), 
more_like(), and query_suggest(). apsw.fts5query can parse, modify, and reconstruct queries. The shell gets a ftsq command for issuing queries.

Added apsw.unicode which implements Unicode algorithms for determining codepoint groups making up a user perceived character, word and sentence splitting, and where line breaks can be made. These are 
used to make provided FTS5 tokenizers and auxiliary functions fully Unicode aware. There are many additional methods such as getting categories, stripping diacritics, case folding, width when output 
to a terminal, text wrapping, and more.

apsw.ext.format_query_table() uses apsw.unicode to get widths and line breaks more accurate. As a side effect it loses the word_wrap parameter (breaking change).


To generate a diff of this commit:
cvs rdiff -u -r1.75 -r1.76 pkgsrc/databases/py-apsw/Makefile
cvs rdiff -u -r1.6 -r1.7 pkgsrc/databases/py-apsw/PLIST
cvs rdiff -u -r1.46 -r1.47 pkgsrc/databases/py-apsw/distinfo

Please note that diffs are not public domain; they are subject to the
copyright notices on the relevant files.

Modified files:

Index: pkgsrc/databases/py-apsw/Makefile
diff -u pkgsrc/databases/py-apsw/Makefile:1.75 pkgsrc/databases/py-apsw/Makefile:1.76
--- pkgsrc/databases/py-apsw/Makefile:1.75      Thu Nov 14 22:19:11 2024
+++ pkgsrc/databases/py-apsw/Makefile   Tue Nov 19 22:52:08 2024
@@ -1,8 +1,7 @@
-# $NetBSD: Makefile,v 1.75 2024/11/14 22:19:11 wiz Exp $
+# $NetBSD: Makefile,v 1.76 2024/11/19 22:52:08 adam Exp $
 
-DISTNAME=      apsw-3.46.1.0
+DISTNAME=      apsw-3.47.0.0
 PKGNAME=       ${PYPKGPREFIX}-${DISTNAME:S/-r1//}
-PKGREVISION=   3
 CATEGORIES=    databases python
 MASTER_SITES=  ${MASTER_SITE_GITHUB:=rogerbinns/}
 EXTRACT_SUFX=  .zip
@@ -16,8 +15,6 @@ LICENSE=      zlib
 
 TOOL_DEPENDS+= ${PYPKGPREFIX}-setuptools>=40.0:../../devel/py-setuptools
 
-PYTHON_VERSIONS_INCOMPATIBLE=  27
-
 BUILDLINK_API_DEPENDS.sqlite3+= sqlite3>=${PKGVERSION_NOREV:R}
 .include "../../databases/sqlite3/buildlink3.mk"
 .include "../../lang/python/wheel.mk"

Index: pkgsrc/databases/py-apsw/PLIST
diff -u pkgsrc/databases/py-apsw/PLIST:1.6 pkgsrc/databases/py-apsw/PLIST:1.7
--- pkgsrc/databases/py-apsw/PLIST:1.6  Sun Oct 29 17:11:35 2023
+++ pkgsrc/databases/py-apsw/PLIST      Tue Nov 19 22:52:08 2024
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.6 2023/10/29 17:11:35 adam Exp $
+@comment $NetBSD: PLIST,v 1.7 2024/11/19 22:52:08 adam Exp $
 ${PYSITELIB}/${WHEEL_INFODIR}/LICENSE
 ${PYSITELIB}/${WHEEL_INFODIR}/METADATA
 ${PYSITELIB}/${WHEEL_INFODIR}/RECORD
@@ -9,12 +9,26 @@ ${PYSITELIB}/apsw/__init__.so
 ${PYSITELIB}/apsw/__main__.py
 ${PYSITELIB}/apsw/__main__.pyc
 ${PYSITELIB}/apsw/__main__.pyo
+${PYSITELIB}/apsw/_unicode.so
 ${PYSITELIB}/apsw/bestpractice.py
 ${PYSITELIB}/apsw/bestpractice.pyc
 ${PYSITELIB}/apsw/bestpractice.pyo
 ${PYSITELIB}/apsw/ext.py
 ${PYSITELIB}/apsw/ext.pyc
 ${PYSITELIB}/apsw/ext.pyo
+${PYSITELIB}/apsw/fts5.py
+${PYSITELIB}/apsw/fts5.pyc
+${PYSITELIB}/apsw/fts5.pyo
+${PYSITELIB}/apsw/fts5aux.py
+${PYSITELIB}/apsw/fts5aux.pyc
+${PYSITELIB}/apsw/fts5aux.pyo
+${PYSITELIB}/apsw/fts5query.py
+${PYSITELIB}/apsw/fts5query.pyc
+${PYSITELIB}/apsw/fts5query.pyo
+${PYSITELIB}/apsw/fts_test_strings
+${PYSITELIB}/apsw/ftstests.py
+${PYSITELIB}/apsw/ftstests.pyc
+${PYSITELIB}/apsw/ftstests.pyo
 ${PYSITELIB}/apsw/py.typed
 ${PYSITELIB}/apsw/shell.py
 ${PYSITELIB}/apsw/shell.pyc
@@ -28,3 +42,6 @@ ${PYSITELIB}/apsw/tests.pyo
 ${PYSITELIB}/apsw/trace.py
 ${PYSITELIB}/apsw/trace.pyc
 ${PYSITELIB}/apsw/trace.pyo
+${PYSITELIB}/apsw/unicode.py
+${PYSITELIB}/apsw/unicode.pyc
+${PYSITELIB}/apsw/unicode.pyo

Index: pkgsrc/databases/py-apsw/distinfo
diff -u pkgsrc/databases/py-apsw/distinfo:1.46 pkgsrc/databases/py-apsw/distinfo:1.47
--- pkgsrc/databases/py-apsw/distinfo:1.46      Wed Aug 14 08:49:34 2024
+++ pkgsrc/databases/py-apsw/distinfo   Tue Nov 19 22:52:08 2024
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.46 2024/08/14 08:49:34 adam Exp $
+$NetBSD: distinfo,v 1.47 2024/11/19 22:52:08 adam Exp $
 
-BLAKE2s (apsw-3.46.1.0.zip) = f767ae92d978248892b131a3e8c61bbb5f5aa5283da6c7219faa0a40746fe3da
-SHA512 (apsw-3.46.1.0.zip) = 8d24825c8346b05a99b8959ce1fd45ae5162c95b020ecc63bd3491bfd1579370a0e6b1a962f7f64a7e7e415846007e64d90b28e2065ae047e228d60b12b9cb02
-Size (apsw-3.46.1.0.zip) = 8965832 bytes
+BLAKE2s (apsw-3.47.0.0.zip) = 66210c09b8cc3595490271d7291ba16a916556c343b647f040247e6333c84297
+SHA512 (apsw-3.47.0.0.zip) = cba738419ca6f966352bca9bc237fdba368e9a861e0d3453a271626872a12950d56859b4448c6a9a143ef878a13259a058811c1dad2acccb68671858b9e74c8b
+Size (apsw-3.47.0.0.zip) = 2390472 bytes