CVS commit: pkgsrc/databases/py-sqlalchemy

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

Module Name:    pkgsrc
Committed By:   adam
Date:           Wed Mar 12 14:32:54 UTC 2025

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

Log Message:
py-sqlalchemy: updated to 2.0.39

2.0.39

orm

[orm] [bug]

Fixed bug where using DML returning such as Insert.returning() with an ORM model that has column_property() constructs that contain subqueries would fail with an internal error.

[orm] [bug]

Fixed bug in ORM enabled UPDATE (and theoretically DELETE) where using a multi-table DML statement would not allow ORM mapped columns from mappers other than the primary UPDATE mapper to be named in 
the RETURNING clause; they would be omitted instead and cause a column not found exception.

[orm] [bug]

Fixed issue where the “is ORM” flag of a select() or other ORM statement would not be propagated to the ORM Session based on a multi-part operator expression alone, e.g. such as Cls.attr + Cls.attr + 
Cls.attr or similar, leading to ORM behaviors not taking place for such statements.

[orm] [bug]

Fixed issue where using aliased() around a CTE construct could cause inappropriate “duplicate CTE” errors in cases where that aliased construct appeared multiple times in a single statement.

sql

[sql] [bug]

Added new parameters AddConstraint.isolate_from_table and DropConstraint.isolate_from_table, defaulting to True, which both document and allow to be controllable the long-standing behavior of these 
two constructs blocking the given constraint from being included inline within the “CREATE TABLE” sequence, under the assumption that separate add/drop directives were to be used.

typing

[typing] [usecase]

Support generic types for compound selects (union(), union_all(), Select.union(), Select.union_all(), etc) returning the type of the first select. Pull request courtesy of Mingyu Park.

asyncio

[asyncio] [bug]

Fixed bug where AsyncResult.scalar(), AsyncResult.scalar_one_or_none(), and AsyncResult.scalar_one() would raise an AttributeError due to a missing internal attribute. Pull request courtesy Allen Ho.

postgresql

[postgresql] [bug]

Add SQL typing to reflection query used to retrieve a the structure of IDENTITY columns, adding explicit JSON typing to the query to suit unusual PostgreSQL driver configurations that don’t support 
JSON natively.

[postgresql] [bug]

Fixed issue affecting PostgreSQL 17.3 and greater where reflection of domains with “NOT NULL” as part of their definition would include an invalid constraint entry in the data returned by 
PGInspector.get_domains() corresponding to an additional “NOT NULL” constraint that isn’t a CHECK constraint; the existing "nullable" entry in the dictionary already indicates if the domain includes 
a “not null” constraint. Note that such domains also cannot be reflected on PostgreSQL 17.0 through 17.2 due to a bug on the PostgreSQL side; if encountering errors in reflection of domains which 
include NOT NULL, upgrade to PostgreSQL server 17.3 or greater.

[postgresql] [bug]

Fixed issue in PostgreSQL network types INET, CIDR, MACADDR, MACADDR8 where sending string values to compare to these types would render an explicit CAST to VARCHAR, causing some SQL / driver 
combinations to fail. Pull request courtesy Denis Laxalde.

[postgresql] [bug]

Fixed compiler issue in the PostgreSQL dialect where incorrect keywords would be passed when using “FOR UPDATE OF” inside of a subquery.

sqlite

[sqlite] [bug]

Fixed issue that omitted the comma between multiple SQLite table extension clauses, currently WITH ROWID and STRICT, when both options Table.sqlite_with_rowid and Table.sqlite_strict were configured 
at their non-default settings at the same time. Pull request courtesy david-fed.


To generate a diff of this commit:
cvs rdiff -u -r1.85 -r1.86 pkgsrc/databases/py-sqlalchemy/Makefile
cvs rdiff -u -r1.74 -r1.75 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.85 pkgsrc/databases/py-sqlalchemy/Makefile:1.86
--- pkgsrc/databases/py-sqlalchemy/Makefile:1.85        Tue Mar  4 09:31:34 2025
+++ pkgsrc/databases/py-sqlalchemy/Makefile     Wed Mar 12 14:32:53 2025
@@ -1,8 +1,7 @@
-# $NetBSD: Makefile,v 1.85 2025/03/04 09:31:34 wiz Exp $
+# $NetBSD: Makefile,v 1.86 2025/03/12 14:32:53 adam Exp $
 
-DISTNAME=      sqlalchemy-2.0.38
+DISTNAME=      sqlalchemy-2.0.39
 PKGNAME=       ${PYPKGPREFIX}-${DISTNAME}
-PKGREVISION=   1
 CATEGORIES=    databases python
 MASTER_SITES=  ${MASTER_SITE_PYPI:=S/SQLAlchemy/}
 

Index: pkgsrc/databases/py-sqlalchemy/distinfo
diff -u pkgsrc/databases/py-sqlalchemy/distinfo:1.74 pkgsrc/databases/py-sqlalchemy/distinfo:1.75
--- pkgsrc/databases/py-sqlalchemy/distinfo:1.74        Fri Feb  7 07:14:34 2025
+++ pkgsrc/databases/py-sqlalchemy/distinfo     Wed Mar 12 14:32:53 2025
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.74 2025/02/07 07:14:34 adam Exp $
+$NetBSD: distinfo,v 1.75 2025/03/12 14:32:53 adam Exp $
 
-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
+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