[pkgsrc/trunk]: pkgsrc/databases/py-sqlalchemy py-sqlalchemy: updated to 1.3.21

[adam <adam%pkgsrc.org@localhost>]

details:   https://anonhg.NetBSD.org/pkgsrc/rev/a0b840ed2eec
branches:  trunk
changeset: 443615:a0b840ed2eec
user:      adam <adam%pkgsrc.org@localhost>
date:      Fri Dec 18 08:19:28 2020 +0000

description:
py-sqlalchemy: updated to 1.3.21

1.3.21

orm

[orm] [bug]

Added a comprehensive check and an informative error message for the case where a mapped class, or a string mapped class name, is passed to relationship.secondary. This is an extremely common error 
which warrants a clear message.

Additionally, added a new rule to the class registry resolution such that with regards to the relationship.secondary parameter, if a mapped class and its table are of the identical string name, the 
Table will be favored when resolving this parameter. In all other cases, the class continues to be favored if a class and table share the identical name.

[orm] [bug]

Fixed bug in Query.update() where objects in the _ormsession.Session that were already expired would be unnecessarily SELECTed individually when they were refreshed by the “evaluate”synchronize 
strategy.

[orm] [bug]

Fixed bug involving the restore_load_context option of ORM events such as InstanceEvents.load() such that the flag would not be carried along to subclasses which were mapped after the event handler 
were first established.

sql

[sql] [bug]

A warning is emmitted if a returning() method such as Insert.returning() is called multiple times, as this does not yet support additive operation. Version 1.4 will support additive operation for 
this. Additionally, any combination of the Insert.returning() and ValuesBase.return_defaults() methods now raises an error as these methods are mutually exclusive; previously the operation would fail 
silently.

[sql] [bug]

Fixed structural compiler issue where some constructs such as MySQL / PostgreSQL “on conflict / on duplicate key” would rely upon the state of the Compiler object being fixed against their statement 
as the top level statement, which would fail in cases where those statements are branched from a different context, such as a DDL construct linked to a SQL statement.

postgresql

[postgresql] [usecase]

Added new parameter ExcludeConstraint.ops to the ExcludeConstraint object, to support operator class specification with this constraint. Pull request courtesy Alon Menczer.

[postgresql] [bug] [mysql]

Fixed regression introduced in 1.3.2 for the PostgreSQL dialect, also copied out to the MySQL dialect’s feature in 1.3.18, where usage of a non Table construct such as text() as the argument to 
Select.with_for_update.of would fail to be accommodated correctly within the PostgreSQL or MySQL compilers.

mysql

[mysql] [bug] [reflection]

Fixed issue where reflecting a server default on MariaDB only that contained a decimal point in the value would fail to be reflected correctly, leading towards a reflected table that lacked any 
server default.

[mysql] [sql]

Added missing keywords to the RESERVED_WORDS list for the MySQL dialect: action, level, mode, status, text, time. Pull request courtesy Oscar Batori.

sqlite

[sqlite] [usecase]

Added sqlite_with_rowid=False dialect keyword to enable creating tables as CREATE TABLE … WITHOUT ROWID. Patch courtesy Sean Anderson.

mssql

[mssql] [bug]

Fixed bug where a CREATE INDEX statement was rendered incorrectly when both mssql-include and mssql_where were specified. Pull request courtesy @Adiorz.

[mssql] [bug]

Added SQL Server code “01000” to the list of disconnect codes.

[mssql] [reflection] [sqlite]

Fixed issue with composite primary key columns not being reported in the correct order. Patch courtesy @fulpm.

oracle

[oracle] [usecase]

Implemented support for the SERIALIZABLE isolation level for Oracle databases, as well as a real implementation for Connection.get_isolation_level().

diffstat:

 databases/py-sqlalchemy/Makefile |   4 ++--
 databases/py-sqlalchemy/distinfo |  10 +++++-----
 2 files changed, 7 insertions(+), 7 deletions(-)

diffs (27 lines):

diff -r 396020a646c2 -r a0b840ed2eec databases/py-sqlalchemy/Makefile
--- a/databases/py-sqlalchemy/Makefile  Thu Dec 17 22:18:18 2020 +0000
+++ b/databases/py-sqlalchemy/Makefile  Fri Dec 18 08:19:28 2020 +0000
@@ -1,6 +1,6 @@
-# $NetBSD: Makefile,v 1.65 2020/10/21 08:58:38 adam Exp $
+# $NetBSD: Makefile,v 1.66 2020/12/18 08:19:28 adam Exp $
 
-DISTNAME=      SQLAlchemy-1.3.20
+DISTNAME=      SQLAlchemy-1.3.21
 PKGNAME=       ${PYPKGPREFIX}-${DISTNAME:tl}
 CATEGORIES=    databases python
 MASTER_SITES=  ${MASTER_SITE_PYPI:=S/SQLAlchemy/}
diff -r 396020a646c2 -r a0b840ed2eec databases/py-sqlalchemy/distinfo
--- a/databases/py-sqlalchemy/distinfo  Thu Dec 17 22:18:18 2020 +0000
+++ b/databases/py-sqlalchemy/distinfo  Fri Dec 18 08:19:28 2020 +0000
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.59 2020/10/21 08:58:38 adam Exp $
+$NetBSD: distinfo,v 1.60 2020/12/18 08:19:28 adam Exp $
 
-SHA1 (SQLAlchemy-1.3.20.tar.gz) = 880084078adb72592538fb36e259f1415f4ccb35
-RMD160 (SQLAlchemy-1.3.20.tar.gz) = 0a97e75868632ceaf86b7de78d681d88b693e065
-SHA512 (SQLAlchemy-1.3.20.tar.gz) = 29c52ada1a66f906ed2563df2ab093eceb7c09de45749c96031f30a1512d20b1d698e00640c777169ef3db99ab012151770a3daea45a51df934269b554ff4b28
-Size (SQLAlchemy-1.3.20.tar.gz) = 6264898 bytes
+SHA1 (SQLAlchemy-1.3.21.tar.gz) = 24b9ea2c180651190509df0af5562c2e7a6cb6e3
+RMD160 (SQLAlchemy-1.3.21.tar.gz) = 33a3a52c8c948d1228934152d65a88dd8a4dd19f
+SHA512 (SQLAlchemy-1.3.21.tar.gz) = 50ea60b849e6f043507728482dc1a90faea853c3fb16affe1d68197903578cb31f26b3543f4671be6aec2a705343193bfa7579e8d417e74c92ee104af4fba753
+Size (SQLAlchemy-1.3.21.tar.gz) = 6297278 bytes