CVS commit: pkgsrc/databases/py-sqlalchemy

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

Module Name:    pkgsrc
Committed By:   adam
Date:           Fri Feb  7 07:14:34 UTC 2025

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

Log Message:
py-sqlalchemy: updated to 2.0.38

2.0.38

engine

[engine] [bug]

Fixed event-related issue where invoking Engine.execution_options() on a Engine multiple times while making use of event-registering parameters such as isolation_level would lead to internal errors 
involving event registration.

sql

[sql] [bug]

Reorganized the internals by which the .c collection on a FromClause gets generated so that it is resilient against the collection being accessed in concurrent fashion. An example is creating a Alias 
or Subquery and accessing it as a module level variable. This impacts the Oracle dialect which uses such module-level global alias objects but is of general use as well.

[sql] [bug]

Fixed SQL composition bug which impacted caching where using a None value inside of an in_() expression would bypass the usual “expanded bind parameter” logic used by the IN construct, which allows 
proper caching to take place.

postgresql

[postgresql] [usecase] [asyncio]

Added an additional asyncio.shield() call within the connection terminate process of the asyncpg driver, to mitigate an issue where terminate would be prevented from completing under the anyio 
concurrency library.

[postgresql] [bug]

Adjusted the asyncpg connection wrapper so that the connection.transaction() call sent to asyncpg sends None for isolation_level if not otherwise set in the SQLAlchemy dialect/wrapper, thereby 
allowing asyncpg to make use of the server level setting for isolation_level in the absense of a client-level setting. Previously, this behavior of asyncpg was blocked by a hardcoded read_committed.

mariadb

[mariadb] [bug] [dml] [mysql]

Fixed a bug where the MySQL statement compiler would not properly compile statements where Insert.on_duplicate_key_update() was passed values that included ORM-mapped attributes (e.g. 
InstrumentedAttribute objects) as keys. Pull request courtesy of mingyu.

sqlite

[sqlite] [bug] [aiosqlite] [asyncio] [pool]

Changed default connection pool used by the aiosqlite dialect from NullPool to AsyncAdaptedQueuePool; this change should have been made when 2.0 was first released as the pysqlite dialect was 
similarly changed to use QueuePool as detailed in The SQLite dialect uses QueuePool for file-based databases.


To generate a diff of this commit:
cvs rdiff -u -r1.83 -r1.84 pkgsrc/databases/py-sqlalchemy/Makefile
cvs rdiff -u -r1.73 -r1.74 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.83 pkgsrc/databases/py-sqlalchemy/Makefile:1.84
--- pkgsrc/databases/py-sqlalchemy/Makefile:1.83        Wed Jan 22 08:19:30 2025
+++ pkgsrc/databases/py-sqlalchemy/Makefile     Fri Feb  7 07:14:34 2025
@@ -1,6 +1,6 @@
-# $NetBSD: Makefile,v 1.83 2025/01/22 08:19:30 adam Exp $
+# $NetBSD: Makefile,v 1.84 2025/02/07 07:14:34 adam Exp $
 
-DISTNAME=      sqlalchemy-2.0.37
+DISTNAME=      sqlalchemy-2.0.38
 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.73 pkgsrc/databases/py-sqlalchemy/distinfo:1.74
--- pkgsrc/databases/py-sqlalchemy/distinfo:1.73        Wed Jan 22 08:19:30 2025
+++ pkgsrc/databases/py-sqlalchemy/distinfo     Fri Feb  7 07:14:34 2025
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.73 2025/01/22 08:19:30 adam Exp $
+$NetBSD: distinfo,v 1.74 2025/02/07 07:14:34 adam Exp $
 
-BLAKE2s (sqlalchemy-2.0.37.tar.gz) = 11279eb993e85e20cedff3c8c8657f91ad47c781a254958b4e12a38cadef2ed3
-SHA512 (sqlalchemy-2.0.37.tar.gz) = ea83a9cc1bcd69424d8f0b6c0f2195ac2c7c77ad92187d9f83e1c0d02fbd0bc8b75973c1849757283434041f073994ed235dc9d520c24f21bd72b4cd20a51a5c
-Size (sqlalchemy-2.0.37.tar.gz) = 9626249 bytes
+BLAKE2s (sqlalchemy-2.0.38.tar.gz) = d6d9ba5df4f81b69e5134338089827fa33624cf2e1d6be0105f8dfed44da6f21
+SHA512 (sqlalchemy-2.0.38.tar.gz) = 244df15b30a2d585aa9cb1d89b7460b1e75871a5e41579a23743bbfe40ece9c5c24308e317ccb7686ba7599a2e02a61f61077da6e1ab8567e4e31d61d4d77380
+Size (sqlalchemy-2.0.38.tar.gz) = 9634782 bytes