CVS commit: pkgsrc/databases/py-sqlalchemy

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

Module Name:    pkgsrc
Committed By:   adam
Date:           Tue Apr  2 18:11:22 UTC 2024

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

Log Message:
py-sqlalchemy: updated to 2.0.29

2.0.29

Released: March 23, 2024
orm

[orm] [usecase]

Added support for the PEP 695 TypeAliasType construct as well as the python 3.12 native type keyword to work with ORM Annotated Declarative form when using these constructs to link to a PEP 593 
Annotated container, allowing the resolution of the Annotated to proceed when these constructs are used in a Mapped typing container.

[orm] [bug]

Fixed Declarative issue where typing a relationship using Relationship rather than Mapped would inadvertently pull in the “dynamic” relationship loader strategy for that attribute.

[orm] [bug]

Fixed issue in ORM annotated declarative where using mapped_column() with an mapped_column.index or mapped_column.unique setting of False would be overridden by an incoming Annotated element that 
featured that parameter set to True, even though the immediate mapped_column() element is more specific and should take precedence. The logic to reconcile the booleans has been enhanced to 
accommodate a local value of False as still taking precedence over an incoming True value from the annotated element.

[orm] [bug] [regression]

Fixed regression from version 2.0.28 caused by the fix for 11085 where the newer method of adjusting post-cache bound parameter values would interefere with the implementation for the subqueryload() 
loader option, which has some more legacy patterns in use internally, when the additional loader criteria feature were used with this loader option.

engine

[engine] [bug]

Fixed issue in “Insert Many Values” Behavior for INSERT statements feature where using a primary key column with an “inline execute” default generator such as an explicit Sequence with an explcit 
schema name, while at the same time using the Connection.execution_options.schema_translate_map feature would fail to render the sequence or the parameters properly, leading to errors.

[engine] [bug]

Made a change to the adjustment made in version 2.0.10 for 9618, which added the behavior of reconciling RETURNING rows from a bulk INSERT to the parameters that were passed to it. This behavior 
included a comparison of already-DB-converted bound parameter values against returned row values that was not always “symmetrical” for SQL column types such as UUIDs, depending on specifics of how 
different DBAPIs receive such values versus how they return them, necessitating the need for additional “sentinel value resolver” methods on these column types. Unfortunately this broke third party 
column types such as UUID/GUID types in libraries like SQLModel which did not implement this special method, raising an error “Can’t match sentinel values in result set to parameter sets”. Rather 
than attempt to further explain and document this implementation detail of the “insertmanyvalues” feature including a public version of the new method, the approach is intead revised to 
no longer need this extra conversion step, and the logic that does the comparison now works on the pre-converted bound parameter value compared to the post-result-processed value, which should always 
be of a matching datatype. In the unusual case that a custom SQL column type that also happens to be used in a “sentinel” column for bulk INSERT is not receiving and returning the same value type, 
the “Can’t match” error will be raised, however the mitigation is straightforward in that the same Python datatype should be passed as that returned.

sql

[sql] [bug] [regression]

Fixed regression from the 1.4 series where the refactor of the TypeEngine.with_variant() method introduced at “with_variant()” clones the original TypeEngine rather than changing the type failed to 
accommodate for the .copy() method, which will lose the variant mappings that are set up. This becomes an issue for the very specific case of a “schema” type, which includes types such as Enum and 
ARRAY, when they are then used in the context of an ORM Declarative mapping with mixins where copying of types comes into play. The variant mapping is now copied as well.

typing

[typing] [bug]

Fixed typing issue allowing asyncio run_sync() methods to correctly type the parameters according to the callable that was passed, making use of PEP 612 ParamSpec variables. Pull request courtesy 
Francisco R. Del Roio.

postgresql

[postgresql] [usecase]

The PostgreSQL dialect now returns DOMAIN instances when reflecting a column that has a domain as type. Previously, the domain data type was returned instead. As part of this change, the domain 
reflection was improved to also return the collation of the text types. Pull request courtesy of Thomas Stephenson.

tests

[tests] [bug]

Backported to SQLAlchemy 2.0 an improvement to the test suite with regards to how asyncio related tests are run, now using the newer Python 3.11 asyncio.Runner or a backported equivalent, rather than 
relying on the previous implementation based on asyncio.get_running_loop(). This should hopefully prevent issues with large suite runs on CPU loaded hardware where the event loop seems to become 
corrupted, leading to cascading failures.


To generate a diff of this commit:
cvs rdiff -u -r1.74 -r1.75 pkgsrc/databases/py-sqlalchemy/Makefile
cvs rdiff -u -r1.65 -r1.66 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.74 pkgsrc/databases/py-sqlalchemy/Makefile:1.75
--- pkgsrc/databases/py-sqlalchemy/Makefile:1.74        Sun Mar 31 19:19:12 2024
+++ pkgsrc/databases/py-sqlalchemy/Makefile     Tue Apr  2 18:11:22 2024
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.74 2024/03/31 19:19:12 adam Exp $
+# $NetBSD: Makefile,v 1.75 2024/04/02 18:11:22 adam Exp $
 
-DISTNAME=      SQLAlchemy-2.0.28
-PKGREVISION=   1
+DISTNAME=      SQLAlchemy-2.0.29
 PKGNAME=       ${PYPKGPREFIX}-${DISTNAME:tl}
 CATEGORIES=    databases python
 MASTER_SITES=  ${MASTER_SITE_PYPI:=S/SQLAlchemy/}
@@ -16,6 +15,7 @@ TOOL_DEPENDS+=        ${PYPKGPREFIX}-setuptools
 TOOL_DEPENDS+= ${PYPKGPREFIX}-wheel>=0:../../devel/py-wheel
 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
 
 PYTHON_VERSIONS_INCOMPATIBLE=  27
 

Index: pkgsrc/databases/py-sqlalchemy/distinfo
diff -u pkgsrc/databases/py-sqlalchemy/distinfo:1.65 pkgsrc/databases/py-sqlalchemy/distinfo:1.66
--- pkgsrc/databases/py-sqlalchemy/distinfo:1.65        Wed Mar  6 21:40:57 2024
+++ pkgsrc/databases/py-sqlalchemy/distinfo     Tue Apr  2 18:11:22 2024
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.65 2024/03/06 21:40:57 wiz Exp $
+$NetBSD: distinfo,v 1.66 2024/04/02 18:11:22 adam Exp $
 
-BLAKE2s (SQLAlchemy-2.0.28.tar.gz) = a9b6a96e80ad4c1ebd19ad2164169fb5ac0ef2acc06295cfe31ee186fe8b846d
-SHA512 (SQLAlchemy-2.0.28.tar.gz) = 83745aaf2d0b469dbbb28960eef4a1e23fb8fe8a2f4b8cb055cc06c5bd4ccb2f365a2b55c7ca76be2d809d4127e16ace06f4e50f59f63d946e3225375499f4f0
-Size (SQLAlchemy-2.0.28.tar.gz) = 9531010 bytes
+BLAKE2s (SQLAlchemy-2.0.29.tar.gz) = caeb9d7edc75ae1d90449fa9401e28931d9a319ee658bfda7ec3bc7b135443c7
+SHA512 (SQLAlchemy-2.0.29.tar.gz) = d1143c65fb26335d652083b9a90afaecf78ed312cea5c26f989380204e909c341c1bc3bb1e07274353e1c409d21737fad4d7391f186b2d2373814582d3baaf78
+Size (SQLAlchemy-2.0.29.tar.gz) = 9543967 bytes