CVS commit: pkgsrc/databases/py-sqlalchemy

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

Module Name:    pkgsrc
Committed By:   adam
Date:           Thu Apr 16 07:29:17 UTC 2026

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

Log Message:
py-sqlalchemy: updated to 2.0.49

2.0.49

orm

[orm] [bug]

Fixed issue where Session.get() would bypass the identity map and emit unnecessary SQL when with_for_update=False was passed, rather than treating it equivalently to the default of None. Pull request 
courtesy of Joshua Swanson.

[orm] [bug]

Fixed issue where chained joinedload() options would not be applied correctly when the final relationship in the chain is declared on a base mapper and accessed through a subclass mapper in a 
with_polymorphic() query. The path registry now correctly computes the natural path when a property declared on a base class is accessed through a path containing a subclass mapper, ensuring the 
loader option can be located during query compilation.

[orm] [bug] [inheritance]

Fixed issue where using Load.options() to apply a chained loader option such as joinedload() or selectinload() with PropComparator.of_type() for a polymorphic relationship would not generate the 
necessary clauses for the polymorphic subclasses. The polymorphic loading strategy is now correctly propagated when using a call such as joinedload(A.b).options(joinedload(B.c.of_type(poly))) to 
match the behavior of direct chaining e.g. joinedload(A.b).joinedload(B.c.of_type(poly)).

[orm] [bug] [inheritance]

Fixed issue where using chained loader options such as selectinload() after joinedload() with PropComparator.of_type() for a polymorphic relationship would not properly apply the chained loader 
option. The loader option is now correctly applied when using a call such as joinedload(A.b.of_type(poly)).selectinload(poly.SubClass.c) to eagerly load related objects.

typing

[typing] [bug]

Fixed a typing issue where the typed members of func would return the appropriate class of the same name, however this creates an issue for typecheckers such as Zuban and pyrefly that assume PEP 749 
style typechecking even if the file states that it’s a PEP 563 file; they see the returned name as indicating the method object and not the class object. These typecheckers are actually following 
along with an upcoming test harness that insists on PEP 749 style name resolution for this case unconditionally. Since PEP 749 is the way of the future regardless, differently-named type aliases have 
been added for these return types.

postgresql

[postgresql] [bug]

Fixed regular expression used when reflecting foreign keys in PostgreSQL to support escaped quotes in table names. Pull request courtesy of Austin Graham

mssql

[mssql] [usecase]

Enhanced the aioodbc dialect to expose the fast_executemany attribute of the pyodbc cursor. This allows the fast_executemany parameter to work with the mssql+aioodbc dialect. Pull request courtesy 
Georg Sieber.

[mssql] [usecase]

Remove warning for SQL Server dialect when a new version is detected. The warning was originally added more than 15 years ago due to an unexpected value returned when using an old version of FreeTDS. 
The assumption is that since then the issue has been resolved, so make the SQL Server dialect behave like the other ones that don’t have an upper bound check on the version number.

[mssql] [bug] [reflection]

Fixed regression from version 2.0.42 caused by 12654 where the updated column reflection query would receive SQL Server “type alias” names for special types such as sysname, whereas previously the 
base name would be received (e.g. nvarchar for sysname), leading to warnings that such types could not be reflected and resulting in NullType, rather than the expected NVARCHAR for a type like 
sysname. The column reflection query now joins sys.types a second time to look up the base type when the user type name is not present in MSDialect.ischema_names, and both names are checked in 
MSDialect.ischema_names for a match. Pull request courtesy Carlos Serrano.

oracle

[oracle] [bug]

Fixed issue in Oracle dialect where the RAW datatype would not reflect the length parameter. Pull request courtesy Daniel Sullivan.


To generate a diff of this commit:
cvs rdiff -u -r1.97 -r1.98 pkgsrc/databases/py-sqlalchemy/Makefile
cvs rdiff -u -r1.84 -r1.85 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.97 pkgsrc/databases/py-sqlalchemy/Makefile:1.98
--- pkgsrc/databases/py-sqlalchemy/Makefile:1.97        Wed Mar  4 05:46:27 2026
+++ pkgsrc/databases/py-sqlalchemy/Makefile     Thu Apr 16 07:29:17 2026
@@ -1,6 +1,6 @@
-# $NetBSD: Makefile,v 1.97 2026/03/04 05:46:27 adam Exp $
+# $NetBSD: Makefile,v 1.98 2026/04/16 07:29:17 adam Exp $
 
-DISTNAME=      sqlalchemy-2.0.48
+DISTNAME=      sqlalchemy-2.0.49
 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.84 pkgsrc/databases/py-sqlalchemy/distinfo:1.85
--- pkgsrc/databases/py-sqlalchemy/distinfo:1.84        Wed Mar  4 05:46:27 2026
+++ pkgsrc/databases/py-sqlalchemy/distinfo     Thu Apr 16 07:29:17 2026
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.84 2026/03/04 05:46:27 adam Exp $
+$NetBSD: distinfo,v 1.85 2026/04/16 07:29:17 adam Exp $
 
-BLAKE2s (sqlalchemy-2.0.48.tar.gz) = 3656c73166ce7e09842248dead0704d27a34eee56b391d3349c8fbc49b645376
-SHA512 (sqlalchemy-2.0.48.tar.gz) = ec108625627b6f2611d55786e5d4079954fea1ba46e923d19d0f33a98ca6a2a4eac605d3d09746defd6a8eb9defd577097df98eff1b64c7c2d6d5647ac1122fe
-Size (sqlalchemy-2.0.48.tar.gz) = 9886075 bytes
+BLAKE2s (sqlalchemy-2.0.49.tar.gz) = 90913b96c5faaf8fa67958570c1bdce5227cedfc1df22e6c2645fbdbe930c516
+SHA512 (sqlalchemy-2.0.49.tar.gz) = 7c28643c0f220f0c096eab3aff094949144b42fe0c72813f5a9ed27d1531504b2ecef30d9ce0e7294110519588ba687a30f414a6ba961e99bf37d4fb867da47e
+Size (sqlalchemy-2.0.49.tar.gz) = 9898221 bytes