CVS commit: pkgsrc/databases/py-sqlalchemy

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

Module Name:    pkgsrc
Committed By:   adam
Date:           Sun Jan 25 13:16:10 UTC 2026

Modified Files:
        pkgsrc/databases/py-sqlalchemy: Makefile distinfo

Log Message:
py-sqlalchemy: updated to 2.0.46

2.0.46

typing

[typing] [bug]

Fixed typing issues where ORM mapped classes and aliased entities could not be used as keys in result row mappings or as join targets in select statements. Patterns such as row._mapping[User], 
row._mapping[aliased(User)], row._mapping[with_polymorphic(...)] (rejected by both mypy and Pylance), and .join(aliased(User)) (rejected by Pylance) are documented and fully supported at runtime but 
were previously rejected by type checkers. The type definitions for _KeyType and _FromClauseArgument have been updated to accept these ORM entity types.

postgresql

[postgresql] [bug]

Fixed issue where PostgreSQL JSONB operators Comparator.path_match() and Comparator.path_exists() were applying incorrect VARCHAR casts to the right-hand side operand when used with newer PostgreSQL 
drivers such as psycopg. The operators now indicate the right-hand type as JSONPATH, which currently results in no casting taking place, but is also compatible with explicit casts if the 
implementation were require it at a later point.

[postgresql] [bug]

Fixed regression in PostgreSQL dialect where JSONB subscription syntax would generate incorrect SQL for cast() expressions returning JSONB, causing syntax errors. The dialect now properly wraps cast 
expressions in parentheses when using the [] subscription syntax, generating (CAST(...))[index] instead of CAST(...)[index] to comply with PostgreSQL syntax requirements. This extends the fix from 
12778 which addressed the same issue for function calls.

[postgresql] [bug]

Improved the foreign key reflection regular expression pattern used by the PostgreSQL dialect to be more permissive in matching identifier characters, allowing it to correctly handle unicode 
characters in table and column names. This change improves compatibility with PostgreSQL variants such as CockroachDB that may use different quoting patterns in combination with unicode characters in 
their identifiers. Pull request courtesy Gord Thompson.

mariadb

[mariadb] [bug]

Fixed the SQL compilation for the mariadb sequence “NOCYCLE” keyword that is to be emitted when the Sequence.cycle parameter is set to False on a Sequence. Pull request courtesy Diego Dupin.

sqlite

[sqlite] [bug]

Fixed issue in the aiosqlite driver where SQLAlchemy’s setting of aiosqlite’s worker thread to “daemon” stopped working because the aiosqlite architecture moved the location of the worker thread in 
version 0.22.0. This “daemon” flag is necessary so that a program is able to exit if the SQLite connection itself was not explicitly closed, which is particularly likely with SQLAlchemy as it 
maintains SQLite connections in a connection pool. While it’s perfectly fine to call AsyncEngine.dispose() before program exit, this is not historically or technically necessary for any driver of any 
known backend, since a primary feature of relational databases is durability. The change also implements support for “terminate” with aiosqlite when using version version 0.22.1 or greater, which 
implements a sync .stop() method.

mssql

[mssql] [usecase]

Added support for the IF EXISTS clause when dropping indexes on SQL Server 2016 (13.x) and later versions. The DropIndex.if_exists parameter is now honored by the SQL Server dialect, allowing 
conditional index drops that will not raise an error if the index does not exist. Pull request courtesy Edgar Ramírez Mondragón.


To generate a diff of this commit:
cvs rdiff -u -r1.94 -r1.95 pkgsrc/databases/py-sqlalchemy/Makefile
cvs rdiff -u -r1.81 -r1.82 pkgsrc/databases/py-sqlalchemy/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-sqlalchemy/Makefile
diff -u pkgsrc/databases/py-sqlalchemy/Makefile:1.94 pkgsrc/databases/py-sqlalchemy/Makefile:1.95
--- pkgsrc/databases/py-sqlalchemy/Makefile:1.94        Thu Dec 11 15:21:27 2025
+++ pkgsrc/databases/py-sqlalchemy/Makefile     Sun Jan 25 13:16:09 2026
@@ -1,6 +1,6 @@
-# $NetBSD: Makefile,v 1.94 2025/12/11 15:21:27 adam Exp $
+# $NetBSD: Makefile,v 1.95 2026/01/25 13:16:09 adam Exp $
 
-DISTNAME=      sqlalchemy-2.0.45
+DISTNAME=      sqlalchemy-2.0.46
 PKGNAME=       ${PYPKGPREFIX}-${DISTNAME}
 CATEGORIES=    databases python
 MASTER_SITES=  ${MASTER_SITE_PYPI:=S/SQLAlchemy/}

Index: pkgsrc/databases/py-sqlalchemy/distinfo
diff -u pkgsrc/databases/py-sqlalchemy/distinfo:1.81 pkgsrc/databases/py-sqlalchemy/distinfo:1.82
--- pkgsrc/databases/py-sqlalchemy/distinfo:1.81        Thu Dec 11 15:21:27 2025
+++ pkgsrc/databases/py-sqlalchemy/distinfo     Sun Jan 25 13:16:10 2026
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.81 2025/12/11 15:21:27 adam Exp $
+$NetBSD: distinfo,v 1.82 2026/01/25 13:16:10 adam Exp $
 
-BLAKE2s (sqlalchemy-2.0.45.tar.gz) = fdc5e4828f73545101685bb173c15d26b89520bf7bcd15593242c353991ffa81
-SHA512 (sqlalchemy-2.0.45.tar.gz) = f7e603a893273c6bbd4f266bf186a1a043e329a695333a17147a68dadec54bf6b2fad7b11e3534bf6ce4c0e7bed3ad5ebe7a3bae01102258458a6ec33944c4a2
-Size (sqlalchemy-2.0.45.tar.gz) = 9869912 bytes
+BLAKE2s (sqlalchemy-2.0.46.tar.gz) = 01034508817155fe5d9d218f5ffd59f6e1c9f92c232ebfc64b93c8c9ca7fef0a
+SHA512 (sqlalchemy-2.0.46.tar.gz) = bc1fb1983207384e109c27c09eddbbfd96c80324349d93f084c922f5d1fc82c8f3ec63d9e9f10bdccc3a8ee902aa517adc1cc2db0d05302a52b0425ebbbc3aa7
+Size (sqlalchemy-2.0.46.tar.gz) = 9865393 bytes