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

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

details:   https://anonhg.NetBSD.org/pkgsrc/rev/bd0ba8615818
branches:  trunk
changeset: 438769:bd0ba8615818
user:      adam <adam%pkgsrc.org@localhost>
date:      Thu Sep 10 09:19:16 2020 +0000

description:
py-sqlalchemy: updated to 1.3.19

1.3.19

orm

[orm] [usecase]
Adjusted the workings of the Mapper.all_orm_descriptors() accessor to represent the attributes in the order that they are located in a deterministic way, assuming the use of Python 3.6 or higher 
which maintains the sorting order of class attributes based on how they were declared. This sorting is not guaranteed to match the declared order of attributes in all cases however; see the method 
documentation for the exact scheme.

orm declarative

[usecase] [declarative] [orm]
The name of the virtual column used when using the AbstractConcreteBase and ConcreteBase classes can now be customized, to allow for models that have a column that is actually named type. Pull 
request courtesy Jesse-Bakker.

sql

[sql] [bug]
Repaired an issue where the “ORDER BY” clause rendering a label name rather than a complete expression, which is particularly important for SQL Server, would fail to occur if the expression were 
enclosed in a parenthesized grouping in some cases. This case has been added to test support. The change additionally adjusts the “automatically add ORDER BY columns when DISTINCT is present” 
behavior of ORM query, deprecated in 1.4, to more accurately detect column expressions that are already present.

[sql] [bug] [datatypes]
The LookupError message will now provide the user with up to four possible values that a column is constrained to via the Enum. Values longer than 11 characters will be truncated and replaced with 
ellipses. Pull request courtesy Ramon Williams.

[sql] [bug]
Fixed issue where the Connection.execution_options.schema_translate_map feature would not take effect when the Sequence.next_value() function function for a Sequence were used in the 
Column.server_default parameter and the create table DDL were emitted.

postgresql

[postgresql] [bug]
Fixed issue where the return type for the various RANGE comparison operators would itself be the same RANGE type rather than BOOLEAN, which would cause an undesirable result in the case that a 
TypeDecorator that defined result-processing behavior were in use. Pull request courtesy Jim Bosch.

mysql

[mysql] [usecase]
The MySQL dialect will render FROM DUAL for a SELECT statement that has no FROM clause but has a WHERE clause. This allows things like “SELECT 1 WHERE EXISTS (subquery)” kinds of queries to be used 
as well as other use cases.

[mysql] [bug]
Fixed an issue where CREATE TABLE statements were not specifying the COLLATE keyword correctly.

[mysql] [bug]
Added MariaDB code 1927 to the list of “disconnect” codes, as recent MariaDB versions apparently use this code when the database server was stopped.

sqlite

[sqlite] [bug] [mssql] [reflection]
Applied a sweep through all included dialects to ensure names that contain single or double quotes are properly escaped when querying system tables, for all Inspector methods that accept object names 
as an argument (e.g. table names, view names, etc). SQLite and MSSQL contained two quoting issues that were repaired.

mssql

[mssql] [bug] [sql]
Fixed bug where the mssql dialect incorrectly escaped object names that contained ‘]’ character(s).

misc

[usecase] [py3k]
Added a **kw argument to the DeclarativeMeta.__init__() method. This allows a class to support the PEP 487 metaclass hook __init_subclass__.

diffstat:

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

diffs (27 lines):

diff -r 9383eebd37a1 -r bd0ba8615818 databases/py-sqlalchemy/Makefile
--- a/databases/py-sqlalchemy/Makefile  Thu Sep 10 08:51:53 2020 +0000
+++ b/databases/py-sqlalchemy/Makefile  Thu Sep 10 09:19:16 2020 +0000
@@ -1,6 +1,6 @@
-# $NetBSD: Makefile,v 1.63 2020/07/08 14:40:26 adam Exp $
+# $NetBSD: Makefile,v 1.64 2020/09/10 09:19:16 adam Exp $
 
-DISTNAME=      SQLAlchemy-1.3.18
+DISTNAME=      SQLAlchemy-1.3.19
 PKGNAME=       ${PYPKGPREFIX}-${DISTNAME:tl}
 CATEGORIES=    databases python
 MASTER_SITES=  ${MASTER_SITE_PYPI:=S/SQLAlchemy/}
diff -r 9383eebd37a1 -r bd0ba8615818 databases/py-sqlalchemy/distinfo
--- a/databases/py-sqlalchemy/distinfo  Thu Sep 10 08:51:53 2020 +0000
+++ b/databases/py-sqlalchemy/distinfo  Thu Sep 10 09:19:16 2020 +0000
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.57 2020/07/08 14:40:26 adam Exp $
+$NetBSD: distinfo,v 1.58 2020/09/10 09:19:16 adam Exp $
 
-SHA1 (SQLAlchemy-1.3.18.tar.gz) = 29c94cc3e7810548c60bfb296f60de15e6e00145
-RMD160 (SQLAlchemy-1.3.18.tar.gz) = a6b574d1a158f20efe2dbb1f84931fb52ee8fdb4
-SHA512 (SQLAlchemy-1.3.18.tar.gz) = 8a358fa9fea35ecc89a2f566d5873668923dc3999508fb6bf314972b78fd9dd06eca227b992f4388ba0d7e9cad39783166b57184fe69eb5dcec6d9adb828f0ec
-Size (SQLAlchemy-1.3.18.tar.gz) = 6039792 bytes
+SHA1 (SQLAlchemy-1.3.19.tar.gz) = ebbe5bbd118de0358bfb6d3118a688899a856852
+RMD160 (SQLAlchemy-1.3.19.tar.gz) = 1c7c84c15452cdf8ad88ea1f3bf61e76cd8a6a72
+SHA512 (SQLAlchemy-1.3.19.tar.gz) = acd3d7c130970dfcc5792243b3f0f28f72b750bad0a3898358aeee9ac72ba38fd4298734ec481abf0fc5ebe1e1398c16672a6c327bac5b7821d08c67508690c8
+Size (SQLAlchemy-1.3.19.tar.gz) = 6197860 bytes