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

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

details:   https://anonhg.NetBSD.org/pkgsrc/rev/8d497dd232a0
branches:  trunk
changeset: 432030:8d497dd232a0
user:      adam <adam%pkgsrc.org@localhost>
date:      Mon May 18 10:43:21 2020 +0000

description:
py-sqlalchemy: updated to 1.3.17

1.3.17

orm

[orm] [usecase]
Added an accessor Comparator.expressions which provides access to the group of columns mapped under a multi-column ColumnProperty attribute.

[orm] [usecase]
Introduce relationship.sync_backref flag in a relationship to control if the synchronization events that mutate the in-Python attributes are added. This supersedes the previous change 5149, which 
warned that viewonly=True relationship target of a back_populates or backref configuration would be disallowed.

[orm] [bug]
Fixed bug where using with_polymorphic() as the target of a join via RelationshipComparator.of_type() on a mapper that already has a subquery-based with_polymorphic setting that’s equivalent to the 
one requested would not correctly alias the ON clause in the join.

[orm] [bug]
Fixed issue in the area of where loader options such as selectinload() interact with the baked query system, such that the caching of a query is not supposed to occur if the loader options themselves 
have elements such as with_polymorphic() objects in them that currently are not cache-compatible. The baked loader could sometimes not fully invalidate itself in these some of these scenarios leading 
to missed eager loads.

[orm] [bug]
Modified the internal “identity set” implementation, which is a set that hashes objects on their id() rather than their hash values, to not actually call the __hash__() method of the objects, which 
are typically user-mapped objects. Some methods were calling this method as a side effect of the implementation.

[orm] [bug]
An informative error message is raised when an ORM many-to-one comparison is attempted against an object that is not an actual mapped instance. Comparisons such as those to scalar subqueries aren’t 
supported; generalized comparison with subqueries is better achieved using Comparator.has().

engine

[engine] [bug]
Fixed fairly critical issue where the DBAPI connection could be returned to the connection pool while still in an un-rolled-back state. The reset agent responsible for rolling back the connection 
could be corrupted in the case that the transaction was “closed” without being rolled back or committed, which can occur in some scenarios when using ORM sessions and emitting .close() in a certain 
pattern involving savepoints. The fix ensures that the reset agent is always active.

schema

[schema] [bug]
Fixed issue where an Index that is deferred in being associated with a table, such as as when it contains a Column that is not associated with any Table yet, would fail to attach correctly if it also 
contained a non table-oriented expession.

[schema] [bug]
A warning is emitted when making use of the MetaData.sorted_tables attribute as well as the sort_tables() function, and the given tables cannot be correctly sorted due to a cyclic dependency between 
foreign key constraints. In this case, the functions will no longer sort the involved tables by foreign key, and a warning will be emitted. Other tables that are not part of the cycle will still be 
returned in dependency order. Previously, the sorted_table routines would return a collection that would unconditionally omit all foreign keys when a cycle was detected, and no warning was emitted.

[schema]
Add comment attribute to Column __repr__ method.

postgresql

[postgresql] [usecase]
Added support for columns or type ARRAY of Enum, JSON or JSONB in PostgreSQL. Previously a workaround was required in these use cases.

[postgresql] [usecase]
Raise an explicit CompileError when adding a table with a column of type ARRAY of Enum configured with Enum.native_enum set to False when Enum.create_constraint is not set to False

mssql

[mssql] [bug] [reflection]
Fix a regression introduced by the reflection of computed column in MSSQL when using the legacy TDS version 4.2. The dialect will try to detect the protocol version of first connect and run in 
compatibility mode if it cannot detect it.

[mssql] [bug] [reflection]
Fix a regression introduced by the reflection of computed column in MSSQL when using SQL server versions before 2012, which does not support the concat function.

oracle

[oracle] [bug]
Some modifications to how the cx_oracle dialect sets up per-column outputtype handlers for LOB and numeric datatypes to adjust for potential changes coming in cx_Oracle 8.

[oracle] [bug] [performance]
Changed the implementation of fetching CLOB and BLOB objects to use cx_Oracle’s native implementation which fetches CLOB/BLOB objects inline with other result columns, rather than performing a 
separate fetch. As always, this can be disabled by setting auto_convert_lobs to False.
As part of this change, the behavior of a CLOB that was given a blank string on INSERT now returns None on SELECT, which is now consistent with that of VARCHAR on Oracle.

firebird

[firebird] [change]
Adjusted dialect loading for firebird:// URIs so the external sqlalchemy-firebird dialect will be used if it has been installed, otherwise fall back to the (now deprecated) internal Firebird dialect.

diffstat:

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

diffs (40 lines):

diff -r 6cb93caf4295 -r 8d497dd232a0 databases/py-sqlalchemy/Makefile
--- a/databases/py-sqlalchemy/Makefile  Mon May 18 10:40:11 2020 +0000
+++ b/databases/py-sqlalchemy/Makefile  Mon May 18 10:43:21 2020 +0000
@@ -1,6 +1,6 @@
-# $NetBSD: Makefile,v 1.61 2020/04/10 07:58:16 adam Exp $
+# $NetBSD: Makefile,v 1.62 2020/05/18 10:43:21 adam Exp $
 
-DISTNAME=      SQLAlchemy-1.3.16
+DISTNAME=      SQLAlchemy-1.3.17
 PKGNAME=       ${PYPKGPREFIX}-${DISTNAME:tl}
 CATEGORIES=    databases python
 MASTER_SITES=  ${MASTER_SITE_PYPI:=S/SQLAlchemy/}
@@ -11,9 +11,10 @@
 LICENSE=       mit
 
 TEST_DEPENDS+= ${PYPKGPREFIX}-mock-[0-9]*:../../devel/py-mock
-TEST_DEPENDS+= ${PYPKGPREFIX}-test>=2.5.2:../../devel/py-test
 TEST_DEPENDS+= ${PYPKGPREFIX}-test-xdist-[0-9]*:../../devel/py-test-xdist
 
-.include "../../lang/python/application.mk"
+PYTHON_VERSIONED_DEPENDENCIES= test:test
+
 .include "../../lang/python/egg.mk"
+.include "../../lang/python/versioned_dependencies.mk"
 .include "../../mk/bsd.pkg.mk"
diff -r 6cb93caf4295 -r 8d497dd232a0 databases/py-sqlalchemy/distinfo
--- a/databases/py-sqlalchemy/distinfo  Mon May 18 10:40:11 2020 +0000
+++ b/databases/py-sqlalchemy/distinfo  Mon May 18 10:43:21 2020 +0000
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.55 2020/04/10 07:58:16 adam Exp $
+$NetBSD: distinfo,v 1.56 2020/05/18 10:43:21 adam Exp $
 
-SHA1 (SQLAlchemy-1.3.16.tar.gz) = 2a886143146748467dc72748b59ee42471333a6e
-RMD160 (SQLAlchemy-1.3.16.tar.gz) = d3eacea42bfcc89a2d758b9c6ffe6b7691760584
-SHA512 (SQLAlchemy-1.3.16.tar.gz) = 8eae306fc21f22da7411badd678f31129ecac18f9a4d8526101ecd0fa8c77e30a4b7a8e4361fff3fc08b031d90cd82343321c1ea9175ad187fe28a25ad9ea6d8
-Size (SQLAlchemy-1.3.16.tar.gz) = 6085722 bytes
+SHA1 (SQLAlchemy-1.3.17.tar.gz) = e81a59368a580538b8a5c69840d07f5ae5dd331d
+RMD160 (SQLAlchemy-1.3.17.tar.gz) = 96e05975e76a5c54c45258f08764e7e1335fa20f
+SHA512 (SQLAlchemy-1.3.17.tar.gz) = 6f6d54b9018ece6c289f28a3a41ffb1b2216206edee08c49f387e9f30740969dfe0f8272654ce4efca159a2a6619e76c41b2ad2b10c391cdd64681ac17d0bc79
+Size (SQLAlchemy-1.3.17.tar.gz) = 5979141 bytes