CVS commit: pkgsrc/databases/py-sqlalchemy

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

Module Name:    pkgsrc
Committed By:   adam
Date:           Tue Aug 12 16:03:55 UTC 2025

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

Log Message:
py-sqlalchemy: updated to 2.0.43

2.0.43

orm

[orm] [bug]

Fixed issue where using the post_update feature would apply incorrect “pre-fetched” values to the ORM objects after a multi-row UPDATE process completed. These “pre-fetched” values would come from 
any column that had an Column.onupdate callable or a version id generator used by Mapper.version_id_generator; for a version id generator that delivered random identifiers like timestamps or UUIDs, 
this incorrect data would lead to a DELETE statement against those same rows to fail in the next step.

[orm] [bug]

Fixed issue where mapped_column.use_existing_column parameter in mapped_column() would not work when the mapped_column() is used inside of an Annotated type alias in polymorphic inheritance 
scenarios. The parameter is now properly recognized and processed during declarative mapping configuration.

[orm] [bug]

Improved the implementation of the selectin_polymorphic() inheritance loader strategy to properly render the IN expressions using chunks of 500 records each, in the same manner as that of the 
selectinload() relationship loader strategy. Previously, the IN expression would be arbitrarily large, leading to failures on databases that have limits on the size of IN expressions including Oracle 
Database.

engine

[engine] [usecase]

Added new parameter create_engine.skip_autocommit_rollback which provides for a per-dialect feature of preventing the DBAPI .rollback() from being called under any circumstances, if the connection is 
detected as being in “autocommit” mode. This improves upon a critical performance issue identified in MySQL dialects where the network overhead of the .rollback() call remains prohibitive even if 
autocommit mode is set.

See also

Fully preventing ROLLBACK calls under autocommit

postgresql

[postgresql] [bug]

Fixed regression in PostgreSQL dialect where JSONB subscription syntax would generate incorrect SQL for JSONB-returning functions, causing syntax errors. The dialect now properly wraps function calls 
and expressions in parentheses when using the [] subscription syntax, generating (function_call)[index] instead of function_call[index] to comply with PostgreSQL syntax requirements.

oracle

[oracle] [usecase]

Extended VECTOR to support sparse vectors. This update introduces VectorStorageType to specify sparse or dense storage and added SparseVector. Pull request courtesy Suraj Shaw.


To generate a diff of this commit:
cvs rdiff -u -r1.90 -r1.91 pkgsrc/databases/py-sqlalchemy/Makefile
cvs rdiff -u -r1.78 -r1.79 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.90 pkgsrc/databases/py-sqlalchemy/Makefile:1.91
--- pkgsrc/databases/py-sqlalchemy/Makefile:1.90        Sat Aug  9 05:42:57 2025
+++ pkgsrc/databases/py-sqlalchemy/Makefile     Tue Aug 12 16:03:55 2025
@@ -1,6 +1,6 @@
-# $NetBSD: Makefile,v 1.90 2025/08/09 05:42:57 adam Exp $
+# $NetBSD: Makefile,v 1.91 2025/08/12 16:03:55 adam Exp $
 
-DISTNAME=      sqlalchemy-2.0.42
+DISTNAME=      sqlalchemy-2.0.43
 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.78 pkgsrc/databases/py-sqlalchemy/distinfo:1.79
--- pkgsrc/databases/py-sqlalchemy/distinfo:1.78        Sat Aug  9 05:42:57 2025
+++ pkgsrc/databases/py-sqlalchemy/distinfo     Tue Aug 12 16:03:55 2025
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.78 2025/08/09 05:42:57 adam Exp $
+$NetBSD: distinfo,v 1.79 2025/08/12 16:03:55 adam Exp $
 
-BLAKE2s (sqlalchemy-2.0.42.tar.gz) = 358dad8685a3fb70cc8f570a193a7567c471856a606edd0e45f359f0d6693344
-SHA512 (sqlalchemy-2.0.42.tar.gz) = 4784c37c3b359ce6de8f23dbbff137e90a60c635c404c125be71f37de4c59661d181114b508ad0171d4c0cab1368a40229f1d4c6725d7a3a066c1fd0e5da4ee7
-Size (sqlalchemy-2.0.42.tar.gz) = 9749972 bytes
+BLAKE2s (sqlalchemy-2.0.43.tar.gz) = 325b9ae27da03e20c22a06d245c1798a41fb29c5e10e70ff4235a17af35781c3
+SHA512 (sqlalchemy-2.0.43.tar.gz) = 8a3c8b9116649ae6c867744b75b9019c5daeaebdcc1b251e8eb526b6ec84168282513b27ca557db3436615b09579864e01173638ccf5bd9a5ecc4537ecf0c695
+Size (sqlalchemy-2.0.43.tar.gz) = 9762949 bytes