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

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

details:   https://anonhg.NetBSD.org/pkgsrc/rev/a5e7945ad240
branches:  trunk
changeset: 435497:a5e7945ad240
user:      adam <adam%pkgsrc.org@localhost>
date:      Wed Jul 08 14:40:26 2020 +0000

description:
py-sqlalchemy: updated to 1.3.18

1.3.18

orm

[orm] [usecase]
Improve error message when using Query.filter_by() in a query where the first entity is not a mapped class.

[orm] [usecase]
Added a new parameter query_expression.default_expr to the query_expression() construct, which will be appled to queries automatically if the with_expression() option is not used. Pull request 
courtesy Haoyu Sun.

engine

[engine] [bug]
Further refinements to the fixes to the “reset” agent fixed in 5326, which now emits a warning when it is not being correctly invoked and corrects for the behavior. Additional scenarios have been 
identified and fixed where this warning was being emitted.

[engine] [bug]
Fixed issue in URL object where stringifying the object would not URL encode special characters, preventing the URL from being re-consumable as a real URL. Pull request courtesy Miguel Grinberg.

sql

[sql] [usecase]
Added a “.schema” parameter to the table() construct, allowing ad-hoc table expressions to also include a schema name. Pull request courtesy Dylan Modesitt.

[sql] [bug]
Correctly apply self_group in type_coerce element.
The type coerce element did not correctly apply grouping rules when using in an expression

[sql] [bug]
Added Select.with_hint() output to the generic SQL string that is produced when calling str() on a statement. Previously, this clause would be omitted under the assumption that it was dialect 
specific. The hint text is presented within brackets to indicate the rendering of such hints varies among backends.

[sql] [schema]
Introduce IdentityOptions to store common parameters for sequences and identity columns.

[sql] [change] [sybase]
Added .offset support to sybase dialect. Pull request courtesy Alan D. Snow.

schema

[schema] [bug]
Fixed issue where dialect_options were omitted when a database object (e.g., Table) was copied using tometadata().

mysql

[mysql] [usecase]
Implemented row-level locking support for mysql. Pull request courtesy Quentin Somerville.

sqlite

[sqlite] [usecase]
SQLite 3.31 added support for computed column. This change enables their support in SQLAlchemy when targeting SQLite.

[sqlite] [bug]
Added “exists” to the list of reserved words for SQLite so that this word will be quoted when used as a label or column name. Pull request courtesy Thodoris Sotiropoulos.

mssql

[mssql] [bug]
Refined the logic used by the SQL Server dialect to interpret multi-part schema names that contain many dots, to not actually lose any dots if the name does not have bracking or quoting used, and 
additionally to support a “dbname” token that has many parts including that it may have multiple, independently-bracketed sections.

[mssql] [bug] [pyodbc]
Fixed an issue in the pyodbc connector such that a warning about pyodbc “drivername” would be emitted when using a totally empty URL. Empty URLs are normal when producing a non-connected dialect 
object or when using the “creator” argument to create_engine(). The warning now only emits if the driver name is missing but other parameters are still present.

[mssql] [bug]
Fixed issue with assembling the ODBC connection string for the pyodbc DBAPI. Tokens containing semicolons and/or braces “{}” were not being correctly escaped, causing the ODBC driver to misinterpret 
the connection string attributes.

[mssql] [bug]
Fixed issue where datetime.time parameters were being converted to datetime.datetime, making them incompatible with comparisons like >= against an actual TIME column.

[mssql] [bug]
Fixed an issue where the is_disconnect function in the SQL Server pyodbc dialect was incorrectly reporting the disconnect state when the exception messsage had a substring that matched a SQL Server 
ODBC error code.

[mssql] [change]
Moved the supports_sane_rowcount_returning = False requirement from the PyODBCConnector level to the MSDialect_pyodbc since pyodbc does work properly in some circumstances.

oracle

[oracle] [bug] [reflection]
Fixed bug in Oracle dialect where indexes that contain the full set of primary key columns would be mistaken as the primary key index itself, which is omitted, even if there were multiples. The check 
has been refined to compare the name of the primary key constraint against the index name itself, rather than trying to guess based on the columns present in the index.

misc

[change] [examples]
Added new option --raw to the examples.performance suite which will dump the raw profile test for consumption by any number of profiling visualizer tools. Removed the “runsnake” option as runsnake is 
very hard to build at this point;

diffstat:

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

diffs (27 lines):

diff -r c9854165e48d -r a5e7945ad240 databases/py-sqlalchemy/Makefile
--- a/databases/py-sqlalchemy/Makefile  Wed Jul 08 14:26:11 2020 +0000
+++ b/databases/py-sqlalchemy/Makefile  Wed Jul 08 14:40:26 2020 +0000
@@ -1,6 +1,6 @@
-# $NetBSD: Makefile,v 1.62 2020/05/18 10:43:21 adam Exp $
+# $NetBSD: Makefile,v 1.63 2020/07/08 14:40:26 adam Exp $
 
-DISTNAME=      SQLAlchemy-1.3.17
+DISTNAME=      SQLAlchemy-1.3.18
 PKGNAME=       ${PYPKGPREFIX}-${DISTNAME:tl}
 CATEGORIES=    databases python
 MASTER_SITES=  ${MASTER_SITE_PYPI:=S/SQLAlchemy/}
diff -r c9854165e48d -r a5e7945ad240 databases/py-sqlalchemy/distinfo
--- a/databases/py-sqlalchemy/distinfo  Wed Jul 08 14:26:11 2020 +0000
+++ b/databases/py-sqlalchemy/distinfo  Wed Jul 08 14:40:26 2020 +0000
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.56 2020/05/18 10:43:21 adam Exp $
+$NetBSD: distinfo,v 1.57 2020/07/08 14:40:26 adam Exp $
 
-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
+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