CVS commit: pkgsrc/databases/py-sqlalchemy

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

Module Name:    pkgsrc
Committed By:   adam
Date:           Wed Jun 19 09:49:58 UTC 2024

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

Log Message:
py-sqlalchemy: updated to 2.0.31

2.0.31

Released: June 18, 2024
general

[general] [bug]

Set up full Python 3.13 support to the extent currently possible, repairing issues within internal language helpers as well as the serializer extension module.

orm

[orm] [usecase]

Added missing parameter with_polymorphic.name that allows specifying the name of returned AliasedClass.

[orm] [bug]

Fixed issue where a MetaData collection would not be serializable, if an Enum or Boolean datatype were present which had been adapted. This specific scenario in turn could occur when using the Enum 
or Boolean within ORM Annotated Declarative form where type objects frequently get copied.

[orm] [bug]

Fixed issue where the selectinload() and subqueryload() loader options would fail to take effect when made against an inherited subclass that itself included a subclass-specific 
Mapper.with_polymorphic setting.

[orm] [bug]

Fixed very old issue involving the joinedload.innerjoin parameter where making use of this parameter mixed into a query that also included joined eager loads along a self-referential or other 
cyclical relationship, along with complicating factors like inner joins added for secondary tables and such, would have the chance of splicing a particular inner join to the wrong part of the query. 
Additional state has been added to the internal method that does this splice to make a better decision as to where splicing should proceed.

[orm] [bug] [regression]

Fixed bug in ORM Declarative where the __table__ directive could not be declared as a class function with declared_attr() on a superclass, including an __abstract__ class as well as coming from the 
declarative base itself. This was a regression since 1.4 where this was working, and there were apparently no tests for this particular use case.

sql

[sql] [bug]

Fixed issue when serializing an over() clause with unbounded range or rows.

[sql] [bug]

Added missing methods FunctionFilter.within_group() and WithinGroup.filter()

[sql] [bug]

Fixed bug in FunctionFilter.filter() that would mutate the existing function in-place. It now behaves like the rest of the SQLAlchemy API, returning a new instance instead of mutating the original 
one.

schema

[schema] [usecase]

Added Column.insert_default as an alias of Column.default for compatibility with mapped_column().

mysql

[mysql] [usecase] [reflection]

Added missing foreign key reflection option SET DEFAULT in the MySQL and MariaDB dialects. Pull request courtesy of Quentin Roche.


To generate a diff of this commit:
cvs rdiff -u -r1.76 -r1.77 pkgsrc/databases/py-sqlalchemy/Makefile
cvs rdiff -u -r1.23 -r1.24 pkgsrc/databases/py-sqlalchemy/PLIST
cvs rdiff -u -r1.67 -r1.68 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.76 pkgsrc/databases/py-sqlalchemy/Makefile:1.77
--- pkgsrc/databases/py-sqlalchemy/Makefile:1.76        Wed May  8 15:15:47 2024
+++ pkgsrc/databases/py-sqlalchemy/Makefile     Wed Jun 19 09:49:58 2024
@@ -1,6 +1,6 @@
-# $NetBSD: Makefile,v 1.76 2024/05/08 15:15:47 adam Exp $
+# $NetBSD: Makefile,v 1.77 2024/06/19 09:49:58 adam Exp $
 
-DISTNAME=      SQLAlchemy-2.0.30
+DISTNAME=      SQLAlchemy-2.0.31
 PKGNAME=       ${PYPKGPREFIX}-${DISTNAME:tl}
 CATEGORIES=    databases python
 MASTER_SITES=  ${MASTER_SITE_PYPI:=S/SQLAlchemy/}
@@ -19,8 +19,5 @@ TEST_DEPENDS+=        ${PYPKGPREFIX}-test-xdist
 
 PYTHON_VERSIONS_INCOMPATIBLE=  27
 
-# test status as of 2.0.28
-# 2 failed, 20790 passed, 10754 skipped, 107 errors
-
 .include "../../lang/python/wheel.mk"
 .include "../../mk/bsd.pkg.mk"

Index: pkgsrc/databases/py-sqlalchemy/PLIST
diff -u pkgsrc/databases/py-sqlalchemy/PLIST:1.23 pkgsrc/databases/py-sqlalchemy/PLIST:1.24
--- pkgsrc/databases/py-sqlalchemy/PLIST:1.23   Sun Mar 31 19:19:12 2024
+++ pkgsrc/databases/py-sqlalchemy/PLIST        Wed Jun 19 09:49:58 2024
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.23 2024/03/31 19:19:12 adam Exp $
+@comment $NetBSD: PLIST,v 1.24 2024/06/19 09:49:58 adam Exp $
 ${PYSITELIB}/${WHEEL_INFODIR}/LICENSE
 ${PYSITELIB}/${WHEEL_INFODIR}/METADATA
 ${PYSITELIB}/${WHEEL_INFODIR}/RECORD
@@ -19,7 +19,6 @@ ${PYSITELIB}/sqlalchemy/connectors/async
 ${PYSITELIB}/sqlalchemy/connectors/pyodbc.py
 ${PYSITELIB}/sqlalchemy/connectors/pyodbc.pyc
 ${PYSITELIB}/sqlalchemy/connectors/pyodbc.pyo
-${PYSITELIB}/sqlalchemy/cyextension/.gitignore
 ${PYSITELIB}/sqlalchemy/cyextension/__init__.py
 ${PYSITELIB}/sqlalchemy/cyextension/__init__.pyc
 ${PYSITELIB}/sqlalchemy/cyextension/__init__.pyo

Index: pkgsrc/databases/py-sqlalchemy/distinfo
diff -u pkgsrc/databases/py-sqlalchemy/distinfo:1.67 pkgsrc/databases/py-sqlalchemy/distinfo:1.68
--- pkgsrc/databases/py-sqlalchemy/distinfo:1.67        Wed May  8 15:15:47 2024
+++ pkgsrc/databases/py-sqlalchemy/distinfo     Wed Jun 19 09:49:58 2024
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.67 2024/05/08 15:15:47 adam Exp $
+$NetBSD: distinfo,v 1.68 2024/06/19 09:49:58 adam Exp $
 
-BLAKE2s (SQLAlchemy-2.0.30.tar.gz) = 56941d75400d5adc2cd02659775a04af4ee28930e7e038d90a9c8b93a7a8da94
-SHA512 (SQLAlchemy-2.0.30.tar.gz) = b39275a7312609fd0a78ac5bb4fb0f29f2948d7fc81007587c01f38849ff28bff273182a06c8ec830b7e1ba4cd30aea2cd7214bbf971a61125c9b56c6ddbbe52
-Size (SQLAlchemy-2.0.30.tar.gz) = 9579500 bytes
+BLAKE2s (SQLAlchemy-2.0.31.tar.gz) = e80970ee9df6871511e558a97d5704e4809225f4da87bde64013f2049b4ad4f2
+SHA512 (SQLAlchemy-2.0.31.tar.gz) = 2e5f559ee2d1f28003a7436a6cb1997f22348447765422f4847adb3c5fc20b759d8c5c99ad4dae1c1f7863f3bc72f699e19b48d7797917a9a64ff4050e61d3d1
+Size (SQLAlchemy-2.0.31.tar.gz) = 9524110 bytes