CVS commit: pkgsrc/databases/py-sqlalchemy

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

Module Name:    pkgsrc
Committed By:   adam
Date:           Mon Apr 14 11:11:05 UTC 2025

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

Log Message:
py-sqlalchemy: updated to 2.0.40

2.0.40

Released: March 27, 2025
orm

[orm] [bug]

Fixed regression which occurred as of 2.0.37 where the checked ArgumentError that’s raised when an inappropriate type or object is used inside of a Mapped annotation would raise TypeError with 
“boolean value of this clause is not defined” if the object resolved into a SQL expression in a boolean context, for programs where future annotations mode was not enabled. This case is now handled 
explicitly and a new error message has also been tailored for this case. In addition, as there are at least half a dozen distinct error scenarios for intepretation of the Mapped construct, these 
scenarios have all been unified under a new subclass of ArgumentError called MappedAnnotationError, to provide some continuity between these different scenarios, even though specific messaging 
remains distinct.

[orm] [bug]

Fixed regression in ORM Annotated Declarative class interpretation caused by typing_extension==4.13.0 that introduced a different implementation for TypeAliasType while SQLAlchemy assumed that it 
would be equivalent to the typing version, leading to pep-695 type annotations not resolving to SQL types as expected.

sql

[sql] [usecase]

Implemented support for the GROUPS frame specification in window functions by adding over.groups option to over() and FunctionElement.over(). Pull request courtesy Kaan Dikmen.

[sql] [bug]

Fixed issue in CTE constructs involving multiple DDL Insert statements with multiple VALUES parameter sets where the bound parameter names generated for these parameter sets would conflict, 
generating a compile time error.

[sql] [bug]

Fixed regression caused by 7471 leading to a SQL compilation issue where name disambiguation for two same-named FROM clauses with table aliasing in use at the same time would produce invalid SQL in 
the FROM clause with two “AS” clauses for the aliased table, due to double aliasing.

asyncio

[asyncio] [bug]

Fixed issue where AsyncSession.get_transaction() and AsyncSession.get_nested_transaction() would fail with NotImplementedError if the “proxy transaction” used by AsyncSession were garbage collected 
and needed regeneration.

postgresql

[postgresql] [usecase]

Added support for specifying a list of columns for SET NULL and SET DEFAULT actions of ON DELETE clause of foreign key definition on PostgreSQL. Pull request courtesy Denis Laxalde.

See also

PostgreSQL Constraint Options

[postgresql] [usecase]

When building a PostgreSQL ARRAY literal using array with an empty clauses argument, the array.type_ parameter is now significant in that it will be used to render the resulting ARRAY[] SQL 
expression with a cast, such as ARRAY[]::INTEGER. Pull request courtesy Denis Laxalde.

mysql

[mysql] [bug]

Support has been re-added for the MySQL-Connector/Python DBAPI using the mysql+mysqlconnector:// URL scheme. The DBAPI now works against modern MySQL versions as well as MariaDB versions (in the 
latter case it’s required to pass charset/collation explicitly). Note however that server side cursor support is disabled due to unresolved issues with this driver.

[mysql] [bug]

Fixed issue in MySQL server default reflection where a default that has spaces would not be correctly reflected. Additionally, expanded the rules for when to apply parenthesis to a server default in 
DDL to suit the general case of a default string that contains non-word characters such as spaces or operators and is not a string literal.

sqlite

[sqlite] [bug]

Expanded the rules for when to apply parenthesis to a server default in DDL to suit the general case of a default string that contains non-word characters such as spaces or operators and is not a 
string literal.


To generate a diff of this commit:
cvs rdiff -u -r1.86 -r1.87 pkgsrc/databases/py-sqlalchemy/Makefile
cvs rdiff -u -r1.24 -r1.25 pkgsrc/databases/py-sqlalchemy/PLIST
cvs rdiff -u -r1.75 -r1.76 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.86 pkgsrc/databases/py-sqlalchemy/Makefile:1.87
--- pkgsrc/databases/py-sqlalchemy/Makefile:1.86        Wed Mar 12 14:32:53 2025
+++ pkgsrc/databases/py-sqlalchemy/Makefile     Mon Apr 14 11:11:05 2025
@@ -1,6 +1,6 @@
-# $NetBSD: Makefile,v 1.86 2025/03/12 14:32:53 adam Exp $
+# $NetBSD: Makefile,v 1.87 2025/04/14 11:11:05 adam Exp $
 
-DISTNAME=      sqlalchemy-2.0.39
+DISTNAME=      sqlalchemy-2.0.40
 PKGNAME=       ${PYPKGPREFIX}-${DISTNAME}
 CATEGORIES=    databases python
 MASTER_SITES=  ${MASTER_SITE_PYPI:=S/SQLAlchemy/}
@@ -11,7 +11,7 @@ COMMENT=      Python SQL toolkit and Object R
 LICENSE=       mit
 
 TOOL_DEPENDS+= ${PYPKGPREFIX}-cython>=0.29.24:../../devel/py-cython
-TOOL_DEPENDS+= ${PYPKGPREFIX}-setuptools>=75.8.2:../../devel/py-setuptools
+TOOL_DEPENDS+= ${PYPKGPREFIX}-setuptools>=78:../../devel/py-setuptools
 DEPENDS+=      ${PYPKGPREFIX}-greenlet>=0.4.18:../../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/PLIST
diff -u pkgsrc/databases/py-sqlalchemy/PLIST:1.24 pkgsrc/databases/py-sqlalchemy/PLIST:1.25
--- pkgsrc/databases/py-sqlalchemy/PLIST:1.24   Wed Jun 19 09:49:58 2024
+++ pkgsrc/databases/py-sqlalchemy/PLIST        Mon Apr 14 11:11:05 2025
@@ -1,8 +1,8 @@
-@comment $NetBSD: PLIST,v 1.24 2024/06/19 09:49:58 adam Exp $
-${PYSITELIB}/${WHEEL_INFODIR}/LICENSE
+@comment $NetBSD: PLIST,v 1.25 2025/04/14 11:11:05 adam Exp $
 ${PYSITELIB}/${WHEEL_INFODIR}/METADATA
 ${PYSITELIB}/${WHEEL_INFODIR}/RECORD
 ${PYSITELIB}/${WHEEL_INFODIR}/WHEEL
+${PYSITELIB}/${WHEEL_INFODIR}/licenses/LICENSE
 ${PYSITELIB}/${WHEEL_INFODIR}/top_level.txt
 ${PYSITELIB}/sqlalchemy/__init__.py
 ${PYSITELIB}/sqlalchemy/__init__.pyc

Index: pkgsrc/databases/py-sqlalchemy/distinfo
diff -u pkgsrc/databases/py-sqlalchemy/distinfo:1.75 pkgsrc/databases/py-sqlalchemy/distinfo:1.76
--- pkgsrc/databases/py-sqlalchemy/distinfo:1.75        Wed Mar 12 14:32:53 2025
+++ pkgsrc/databases/py-sqlalchemy/distinfo     Mon Apr 14 11:11:05 2025
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.75 2025/03/12 14:32:53 adam Exp $
+$NetBSD: distinfo,v 1.76 2025/04/14 11:11:05 adam Exp $
 
-BLAKE2s (sqlalchemy-2.0.39.tar.gz) = 2a26b817a442780e5dafc7aeb644583e9c048a4c8798ff55a5f76e06e0808bbc
-SHA512 (sqlalchemy-2.0.39.tar.gz) = 42d23acb4d98f03dde97d9d1e43387fc6bd331ee54a6503a2b4b047aab38d24ccb905ea6a7026619e36782c631e54287011f6daf360e7f5c69a00c395e15f149
-Size (sqlalchemy-2.0.39.tar.gz) = 9644602 bytes
+BLAKE2s (sqlalchemy-2.0.40.tar.gz) = 60ac1fc43682f5a5423e6a0b2d51ed8aec5577eb4814123e710beef183fd6ecd
+SHA512 (sqlalchemy-2.0.40.tar.gz) = 7a1db1d61cd80283e339ef92b7e27146ea060db8dc7028b2584df9f9f68a4887bbb2a6b4b4af5ca66c7d132659c7a2d0b47ac2d25ce84fad73ee2dae7808e122
+Size (sqlalchemy-2.0.40.tar.gz) = 9664299 bytes