CVS commit: pkgsrc/databases/py-sqlalchemy

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

Module Name:    pkgsrc
Committed By:   adam
Date:           Tue Sep 17 07:22:30 UTC 2024

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

Log Message:
py-sqlalchemy: updated to 2.0.35

2.0.35

orm

[orm] [bug] [typing]

Fixed issue where it was not possible to use typing.Literal with Mapped[] on Python 3.8 and 3.9. Pull request courtesy Frazer McLean.

[orm] [bug]

Fixed issue in ORM evaluator where two datatypes being evaluated with the SQL concatenator operator would not be checked for UnevaluatableError based on their datatype; this missed the case of JSONB 
values being used in a concatenate operation which is supported by PostgreSQL as well as how SQLAlchemy renders the SQL for this operation, but does not work at the Python level. By implementing 
UnevaluatableError for this combination, ORM update statements will now fall back to “expire” when a concatenated JSON value used in a SET clause is to be synchronized to a Python object.

[orm] [bug]

An warning is emitted if joinedload() or subqueryload() are used as a top level option against a statement that is not a SELECT statement, such as with an insert().returning(). There are no JOINs in 
INSERT statements nor is there a “subquery” that can be repurposed for subquery eager loading, and for UPDATE/DELETE joinedload does not support these either, so it is never appropriate for this use 
to pass silently.

[orm] [bug]

Fixed issue where using loader options such as selectinload() with additional criteria in combination with ORM DML such as insert() with RETURNING would not correctly set up internal contexts 
required for caching to work correctly, leading to incorrect results.

mysql

[mysql] [bug]

Fixed issue in mariadbconnector dialect where query string arguments that weren’t checked integer or boolean arguments would be ignored, such as string arguments like unix_socket, etc. As part of 
this change, the argument parsing for particular elements such as client_flags, compress, local_infile has been made more consistent across all MySQL / MariaDB dialect which accept each argument. 
Pull request courtesy Tobias Alex-Petersen.

sqlite

[sqlite] [bug] [regression]

The changes made for SQLite CHECK constraint reflection in versions 2.0.33 and 2.0.34, 11832 and 11677, have now been fully reverted, as users continued to identify existing use cases that stopped 
working after this change. For the moment, because SQLite does not provide any consistent way of delivering information about CHECK constraints, SQLAlchemy is limited in what CHECK constraint 
syntaxes can be reflected, including that a CHECK constraint must be stated all on a single, independent line (or inline on a column definition) without newlines, tabs in the constraint definition or 
unusual characters in the constraint name. Overall, reflection for SQLite is tailored towards being able to reflect CREATE TABLE statements that were originally created by SQLAlchemy DDL constructs. 
Long term work on a DDL parser that does not rely upon regular expressions may eventually improve upon this situation. A wide range of additional cross-dialect CHECK constraint reflection tests have 
bee
n added as it was also a bug that these changes did not trip any existing tests.


To generate a diff of this commit:
cvs rdiff -u -r1.79 -r1.80 pkgsrc/databases/py-sqlalchemy/Makefile
cvs rdiff -u -r1.70 -r1.71 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.79 pkgsrc/databases/py-sqlalchemy/Makefile:1.80
--- pkgsrc/databases/py-sqlalchemy/Makefile:1.79        Sat Sep  7 05:22:04 2024
+++ pkgsrc/databases/py-sqlalchemy/Makefile     Tue Sep 17 07:22:30 2024
@@ -1,6 +1,6 @@
-# $NetBSD: Makefile,v 1.79 2024/09/07 05:22:04 adam Exp $
+# $NetBSD: Makefile,v 1.80 2024/09/17 07:22:30 adam Exp $
 
-DISTNAME=      sqlalchemy-2.0.34
+DISTNAME=      sqlalchemy-2.0.35
 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.70 pkgsrc/databases/py-sqlalchemy/distinfo:1.71
--- pkgsrc/databases/py-sqlalchemy/distinfo:1.70        Sat Sep  7 05:22:04 2024
+++ pkgsrc/databases/py-sqlalchemy/distinfo     Tue Sep 17 07:22:30 2024
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.70 2024/09/07 05:22:04 adam Exp $
+$NetBSD: distinfo,v 1.71 2024/09/17 07:22:30 adam Exp $
 
-BLAKE2s (sqlalchemy-2.0.34.tar.gz) = 1474bf4c2b6fb9b8e36fd1995691e89d01e49a002ce18d901bcd38925cbd1c2e
-SHA512 (sqlalchemy-2.0.34.tar.gz) = fd585ed9a78a86deaab1f84b5ff29f37120c08f3c8c93566786b73d74ce67f1f71097e43d42b0999be1aca493ae1c55d5a0c2d49386b65dcca566c036401232b
-Size (sqlalchemy-2.0.34.tar.gz) = 9556527 bytes
+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