CVS commit: pkgsrc/databases/py-sqlalchemy

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

Module Name:    pkgsrc
Committed By:   adam
Date:           Mon Jun 29 05:25:20 UTC 2026

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

Log Message:
py-sqlalchemy: updated to 2.0.51

2.0.51

orm

[orm] [bug]

Fixed issue where subqueryload() combined with PropComparator.of_type() and PropComparator.and_() would silently drop the additional filter criteria, causing all related objects to be loaded instead 
of only those matching the filter. The LoaderCriteriaOption was being constructed against the base entity rather than the effective entity indicated by PropComparator.of_type(). Pull request courtesy 
Arya Rizky.

[orm] [bug]

Fixed bug where a failure during tpc_prepare() within Session.commit() for a two-phase session would raise IllegalStateChangeError instead of the original database exception. The internal 
_prepare_impl() method’s error handler was unable to invoke SessionTransaction.rollback() due to a state-change guard, preventing proper cleanup and masking the underlying error.

engine

[engine] [bug]

Fixed issue where Result.freeze() would lose track of ambiguous column names present in the original CursorResult, causing key-based access on the thawed result to silently return a value instead of 
raising InvalidRequestError. The SimpleResultMetaData now accepts and propagates ambiguous key information so that frozen, thawed, and pickled results raise consistently for duplicate column names. 
Pull request courtesy Saurabh Kohli.

sql

[sql] [bug]

Fixed issue where StatementLambdaElement would proxy attribute access through the cached “expected” expression rather than the resolved expression, causing stale closure-bound parameter values to be 
used when a lambda statement was extended with non-lambda criteria such as an additional .where() clause. Courtesy cjc0013.

postgresql

[postgresql] [bug]

Repaired bug introduced in 13229 where a two-phase transaction recovery would not return the correct transaction identifier when generating the identifiers using the xid() method of the psycopg 
connection.

[postgresql] [bug]

Fixed regular expression in the pure Python hstore result processor, used when use_native_hstore=False is set, which could hang on malformed hstore text containing unterminated quoted segments with 
backslashes. Pull request courtesy dxbjavid.


To generate a diff of this commit:
cvs rdiff -u -r1.100 -r1.101 pkgsrc/databases/py-sqlalchemy/Makefile
cvs rdiff -u -r1.86 -r1.87 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.100 pkgsrc/databases/py-sqlalchemy/Makefile:1.101
--- pkgsrc/databases/py-sqlalchemy/Makefile:1.100       Sun Jun 28 15:41:11 2026
+++ pkgsrc/databases/py-sqlalchemy/Makefile     Mon Jun 29 05:25:20 2026
@@ -1,6 +1,6 @@
-# $NetBSD: Makefile,v 1.100 2026/06/28 15:41:11 wiz Exp $
+# $NetBSD: Makefile,v 1.101 2026/06/29 05:25:20 adam Exp $
 
-DISTNAME=      sqlalchemy-2.0.50
+DISTNAME=      sqlalchemy-2.0.51
 PKGNAME=       ${PYPKGPREFIX}-${DISTNAME}
 CATEGORIES=    databases python
 MASTER_SITES=  ${MASTER_SITE_PYPI:=S/SQLAlchemy/}
@@ -12,7 +12,7 @@ LICENSE=      mit
 
 TOOL_DEPENDS+= ${PYPKGPREFIX}-cython>=0.29.24:../../devel/py-cython
 TOOL_DEPENDS+= ${PYPKGPREFIX}-setuptools>=78:../../devel/py-setuptools
-DEPENDS+=      ${PYPKGPREFIX}-greenlet>=0.4.18:../../devel/py-greenlet
+DEPENDS+=      ${PYPKGPREFIX}-greenlet>=1:../../devel/py-greenlet
 DEPENDS+=      ${PYPKGPREFIX}-typing-extensions>=4.6.0:../../devel/py-typing-extensions
 TEST_DEPENDS+= ${PYPKGPREFIX}-test-xdist>=0:../../devel/py-test-xdist
 

Index: pkgsrc/databases/py-sqlalchemy/distinfo
diff -u pkgsrc/databases/py-sqlalchemy/distinfo:1.86 pkgsrc/databases/py-sqlalchemy/distinfo:1.87
--- pkgsrc/databases/py-sqlalchemy/distinfo:1.86        Mon May 25 07:06:23 2026
+++ pkgsrc/databases/py-sqlalchemy/distinfo     Mon Jun 29 05:25:20 2026
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.86 2026/05/25 07:06:23 adam Exp $
+$NetBSD: distinfo,v 1.87 2026/06/29 05:25:20 adam Exp $
 
-BLAKE2s (sqlalchemy-2.0.50.tar.gz) = efbeb2cd077d9c458d7ddc1fe47f56895db2b9cdc67462f4309bd7abbd4ea2c4
-SHA512 (sqlalchemy-2.0.50.tar.gz) = 3cb9872cb9adc7ca52d5a28c581e2be21f6e6853405a8fc15ef34c2e2b8a52cad066b46dbac264193b323d85ab9f5a06a7f98867c66f048e5ee836ec5ef6b4df
-Size (sqlalchemy-2.0.50.tar.gz) = 9907424 bytes
+BLAKE2s (sqlalchemy-2.0.51.tar.gz) = 45df53bab9389e22e6b73d007e4bbe413fbf52a1ca76211809955c84e5a709c7
+SHA512 (sqlalchemy-2.0.51.tar.gz) = af3965c5c43921b8e4330348b7d1a46357fa5d6a9a0acde66b4c3e65aedbd27afabc257cde113d38f3be3f3a91d524230fb17efc5515b826442d4fb4d6b7bc1d
+Size (sqlalchemy-2.0.51.tar.gz) = 9912201 bytes