CVS commit: pkgsrc/databases/py-sqlalchemy

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

Module Name:    pkgsrc
Committed By:   adam
Date:           Sat Oct 19 16:14:34 UTC 2024

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

Log Message:
py-sqlalchemy: updated to 2.0.36

2.0.36

orm

[orm] [usecase]

Added new parameter mapped_column.hash to ORM constructs such as sqlalchemy.orm.mapped_column(), sqlalchemy.orm.relationship(), etc., which is interpreted for ORM Native Dataclasses in the same way 
as other dataclass-specific field parameters.

[orm] [bug]

Fixed bug in ORM bulk update/delete where using RETURNING with bulk update/delete in combination with populate_existing would fail to accommodate the populate_existing option.

[orm] [bug]

Continuing from 11912, columns marked with mapped_column.onupdate, mapped_column.server_onupdate, or Computed are now refreshed in ORM instances when running an ORM enabled UPDATE with WHERE 
criteria, even if the statement does not use RETURNING or populate_existing.

[orm] [bug]

Fixed regression caused by fixes to joined eager loading in 11449 released in 2.0.31, where a particular joinedload case could not be asserted correctly. We now have an example of that case so the 
assertion has been repaired to allow for it.

[orm] [bug]

Improved the error message emitted when trying to map as dataclass a class while also manually providing the __table__ attribute. This usage is currently not supported.

[orm] [bug]

Refined the check which the ORM lazy loader uses to detect “this would be loading by primary key and the primary key is NULL, skip loading” to take into account the current setting for the 
Mapper.allow_partial_pks parameter. If this parameter is False, then a composite PK value that has partial NULL elements should also be skipped. This can apply to some composite overlapping foreign 
key configurations.

[orm] [bug]

Fixed bug in ORM “update with WHERE clause” feature where an explicit .returning() would interfere with the “fetch” synchronize strategy due to an assumption that the ORM mapped class featured the 
primary key columns in a specific position within the RETURNING. This has been fixed to use appropriate ORM column targeting.

sql

[sql] [usecase]

Datatypes that are binary based such as VARBINARY will resolve to LargeBinary when the TypeEngine.as_generic() method is called.

[sql] [bug] [regression]

Fixed regression from 1.4 where some datatypes such as those derived from TypeDecorator could not be pickled when they were part of a larger SQL expression composition due to internal supporting 
structures themselves not being pickleable.

schema

[schema] [bug]

Fixed bug where SQL functions passed to Column.server_default would not be rendered with the particular form of parenthesization now required by newer versions of MySQL and MariaDB. Pull request 
courtesy of huuya.

postgresql

[postgresql] [bug] [reflection]

Fixed bug in reflection of table comments where unrelated text would be returned if an entry in the pg_description table happened to share the same oid (objoid) as the table being reflected.

[postgresql] [bug]

The JSON and JSONB datatypes will now render a “bind cast” in all cases for all PostgreSQL backends, including psycopg2, whereas previously it was only enabled for some backends. This allows greater 
accuracy in allowing the database server to recognize when a string value is to be interpreted as JSON.

mysql

[mysql] [performance]

Improved a query used for the MySQL 8 backend when reflecting foreign keys to be better optimized. Previously, for a database that had millions of columns across all tables, the query could be 
prohibitively slow; the query has been reworked to take better advantage of existing indexes.


To generate a diff of this commit:
cvs rdiff -u -r1.80 -r1.81 pkgsrc/databases/py-sqlalchemy/Makefile
cvs rdiff -u -r1.71 -r1.72 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.80 pkgsrc/databases/py-sqlalchemy/Makefile:1.81
--- pkgsrc/databases/py-sqlalchemy/Makefile:1.80        Tue Sep 17 07:22:30 2024
+++ pkgsrc/databases/py-sqlalchemy/Makefile     Sat Oct 19 16:14:34 2024
@@ -1,6 +1,6 @@
-# $NetBSD: Makefile,v 1.80 2024/09/17 07:22:30 adam Exp $
+# $NetBSD: Makefile,v 1.81 2024/10/19 16:14:34 adam Exp $
 
-DISTNAME=      sqlalchemy-2.0.35
+DISTNAME=      sqlalchemy-2.0.36
 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.71 pkgsrc/databases/py-sqlalchemy/distinfo:1.72
--- pkgsrc/databases/py-sqlalchemy/distinfo:1.71        Tue Sep 17 07:22:30 2024
+++ pkgsrc/databases/py-sqlalchemy/distinfo     Sat Oct 19 16:14:34 2024
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.71 2024/09/17 07:22:30 adam Exp $
+$NetBSD: distinfo,v 1.72 2024/10/19 16:14:34 adam Exp $
 
-BLAKE2s (sqlalchemy-2.0.35.tar.gz) = ac594045c50dc04b26b217227c3a2179c77b2b3b2959a77dcc92f2e9476d9985
-SHA512 (sqlalchemy-2.0.35.tar.gz) = 1de85847bf6f391c68c5d2fea7b690fe3deeaa8712ba086cc23244f25528dfdfd9ad6f2642f9981816896b225547ac5ac01c9fb2c707e9f47c1918e13dbcdc19
-Size (sqlalchemy-2.0.35.tar.gz) = 9562798 bytes
+BLAKE2s (sqlalchemy-2.0.36.tar.gz) = dd72c0449babeef1d1d4741d97c4c16d81443c895669ea28105c5910acdf326a
+SHA512 (sqlalchemy-2.0.36.tar.gz) = 480fa9893d20806127f6b060726210e32989af92439ff445066aebfc931453eb8c05b5f8497582fcdb897f8e9e70243f092f46e06d7dfe49301ab71ada4eebda
+Size (sqlalchemy-2.0.36.tar.gz) = 9574485 bytes