CVS commit: pkgsrc/databases/py-sqlalchemy

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

Module Name:    pkgsrc
Committed By:   adam
Date:           Mon May 25 07:06:23 UTC 2026

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

Log Message:
py-sqlalchemy: updated to 2.0.50

2.0.50

orm

[orm] [bug]

Fixed issue where using joinedload() with PropComparator.of_type() targeting a joined-table subclass combined with PropComparator.and_() referencing a column on that subclass would generate invalid 
SQL, where the subclass column was not adapted to the subquery alias. Pull request courtesy Joaquin Hui Gomez.

[orm] [bug]

Fixed issue where the presence of a SessionEvents.do_orm_execute() event hook would cause internal execution options such as yield_per and loader-specific state from the first orm_pre_session_exec 
pass to leak into the second pass, leading to errors when using relationship loaders such as selectinload() and immediateload(). The execution options passed to the second compilation pass are now 
based on the original options plus only the explicit updates made via ORMExecuteState.update_execution_options() within the event hook.

[orm] [bug]

Fixed issue where using with_polymorphic() on a leaf class (a subclass with no further descendants) or a non-inherited class would fail with an AttributeError when used in an ORM statement, due to 
configure_mappers() not being triggered implicitly. The fix ensures that AliasedInsp participates in the _post_inspect hook, triggering mapper configuration during ORM statement compilation.

sql

[sql] [bug]

Fixed issue where floor division (//) between a Float or Numeric numerator and an Integer denominator would omit the FLOOR() SQL wrapper on dialects where Dialect.div_is_floordiv is True (the 
default, including PostgreSQL and SQLite). FLOOR() is now applied if either the denominator or the numerator is a non-integer, so that expressions such as float_col // int_col render as 
FLOOR(float_col / int_col) instead of the incorrect float_col / int_col. Pull request courtesy r266-tech.

postgresql

[postgresql] [bug]

Improve handling of two phase transaction identifiers for PostgreSQL when the identifier is provided by the user. As part of this change the psycopg dialect was updated to use the DBAPI two phase 
transaction API instead of executing the SQL directly.

[postgresql] [bug]

Fixed issue where the asyncpg driver could throw an insufficiently-handled exception InternalClientError under some circumstances, leading to connections not being properly marked as invalidated.

[postgresql] [bug]

Fixed issue where the ExcludeConstraint construct did not correctly forward the ExcludeConstraint.info parameter to the superclass, causing user-defined metadata to be lost. Pull request courtesy 
Wiktor Byrka.

mysql

[mysql] [bug] [reflection]

Narrowed the scope of the internal workaround for MySQL bugs 88718 and 96365 so that it is only applied where needed: MySQL 8.0.1 through 8.0.13 (where bug 88718 is present), and on systems with 
lower_case_table_names=2 (where bug 96365 applies, typically macOS). Previously the workaround was applied unconditionally for all MySQL 8.0+ versions, which caused a KeyError during foreign key 
reflection when the database user lacked SELECT privileges on referred tables.

[mysql] [bug]

Fixed issue in aiomysql and asyncmy dialects that appears as of using pymysql 1.2.0; the dialects were not properly taking into account logic that detects the argument signature of pymysql’s ping() 
method which was added as part of 10492.

sqlite

[sqlite] [bug]

Escape key and pragma values when utilizing the pysqlcipher dialect.


To generate a diff of this commit:
cvs rdiff -u -r1.98 -r1.99 pkgsrc/databases/py-sqlalchemy/Makefile
cvs rdiff -u -r1.85 -r1.86 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.98 pkgsrc/databases/py-sqlalchemy/Makefile:1.99
--- pkgsrc/databases/py-sqlalchemy/Makefile:1.98        Thu Apr 16 07:29:17 2026
+++ pkgsrc/databases/py-sqlalchemy/Makefile     Mon May 25 07:06:23 2026
@@ -1,6 +1,6 @@
-# $NetBSD: Makefile,v 1.98 2026/04/16 07:29:17 adam Exp $
+# $NetBSD: Makefile,v 1.99 2026/05/25 07:06:23 adam Exp $
 
-DISTNAME=      sqlalchemy-2.0.49
+DISTNAME=      sqlalchemy-2.0.50
 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.85 pkgsrc/databases/py-sqlalchemy/distinfo:1.86
--- pkgsrc/databases/py-sqlalchemy/distinfo:1.85        Thu Apr 16 07:29:17 2026
+++ pkgsrc/databases/py-sqlalchemy/distinfo     Mon May 25 07:06:23 2026
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.85 2026/04/16 07:29:17 adam Exp $
+$NetBSD: distinfo,v 1.86 2026/05/25 07:06:23 adam Exp $
 
-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
+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