CVS commit: pkgsrc/databases/py-sqlalchemy

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

Module Name:    pkgsrc
Committed By:   adam
Date:           Tue Apr  2 08:59:13 UTC 2019

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

Log Message:
py-sqlalchemy: updated to 1.3.1

1.3.1
orm
[orm] [bug] [ext] Fixed regression where an association proxy linked to a synonym would no longer work, both at instance level and at class level.

mssql

[mssql] [bug] A commit() is emitted after an isolation level change to SNAPSHOT, as both pyodbc and pymssql open an implicit transaction which blocks subsequent SQL from being emitted in the current 
transaction.

This change is also backported to: 1.2.19

[mssql] [bug] Fixed regression in SQL Server reflection due to 4393 where the removal of open-ended **kw from the Float datatype caused reflection of this type to fail due to a “scale” argument being 
passed.

1.3.0
orm

[orm] [feature] The Query.get() method can now accept a dictionary of attribute keys and values as a means of indicating the primary key value to load; is particularly useful for composite primary 
keys. Pull request courtesy Sanjana S.

[orm] [feature] A SQL expression can now be assigned to a primary key attribute for an ORM flush in the same manner as ordinary attributes as described in Embedding SQL Insert/Update Expressions into 
a Flush where the expression will be evaulated and then returned to the ORM using RETURNING, or in the case of pysqlite, works using the cursor.lastrowid attribute.Requires either a database that 
supports RETURNING (e.g. Postgresql, Oracle, SQL Server) or pysqlite.

engine

[engine] [feature] Revised the formatting for StatementError when stringified. Each error detail is broken up over multiple newlines instead of spaced out on a single line. Additionally, the SQL 
representation now stringifies the SQL statement rather than using repr(), so that newlines are rendered as is. Pull request courtesy Nate Clark.

See also
Changed StatementError formatting (newlines and %s)

sql
[sql] [bug] The Alias class and related subclasses CTE, Lateral and TableSample have been reworked so that it is not possible for a user to construct the objects directly. These constructs require 
that the standalone construction function or selectable-bound method be used to instantiate new objects.

schema
[schema] [feature] Added new parameters Table.resolve_fks and MetaData.reflect.resolve_fks which when set to False will disable the automatic reflection of related tables encountered in ForeignKey 
objects, which can both reduce SQL overhead for omitted tables as well as avoid tables that can’t be reflected for database-specific reasons. Two Table objects present in the same MetaData collection 
can still refer to each other even if the reflection of the two tables occurred separately


To generate a diff of this commit:
cvs rdiff -u -r1.50 -r1.51 pkgsrc/databases/py-sqlalchemy/Makefile
cvs rdiff -u -r1.17 -r1.18 pkgsrc/databases/py-sqlalchemy/PLIST
cvs rdiff -u -r1.45 -r1.46 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.50 pkgsrc/databases/py-sqlalchemy/Makefile:1.51
--- pkgsrc/databases/py-sqlalchemy/Makefile:1.50        Wed Feb 20 15:56:15 2019
+++ pkgsrc/databases/py-sqlalchemy/Makefile     Tue Apr  2 08:59:13 2019
@@ -1,6 +1,6 @@
-# $NetBSD: Makefile,v 1.50 2019/02/20 15:56:15 adam Exp $
+# $NetBSD: Makefile,v 1.51 2019/04/02 08:59:13 adam Exp $
 
-DISTNAME=      SQLAlchemy-1.2.18
+DISTNAME=      SQLAlchemy-1.3.1
 PKGNAME=       ${PYPKGPREFIX}-${DISTNAME:tl}
 CATEGORIES=    databases python
 MASTER_SITES=  ${MASTER_SITE_PYPI:=S/SQLAlchemy/}

Index: pkgsrc/databases/py-sqlalchemy/PLIST
diff -u pkgsrc/databases/py-sqlalchemy/PLIST:1.17 pkgsrc/databases/py-sqlalchemy/PLIST:1.18
--- pkgsrc/databases/py-sqlalchemy/PLIST:1.17   Tue Jul  3 05:34:20 2018
+++ pkgsrc/databases/py-sqlalchemy/PLIST        Tue Apr  2 08:59:13 2019
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.17 2018/07/03 05:34:20 adam Exp $
+@comment $NetBSD: PLIST,v 1.18 2019/04/02 08:59:13 adam Exp $
 ${PYSITELIB}/${EGG_INFODIR}/PKG-INFO
 ${PYSITELIB}/${EGG_INFODIR}/SOURCES.txt
 ${PYSITELIB}/${EGG_INFODIR}/dependency_links.txt
@@ -169,6 +169,9 @@ ${PYSITELIB}/sqlalchemy/dialects/sqlite/
 ${PYSITELIB}/sqlalchemy/dialects/sqlite/base.py
 ${PYSITELIB}/sqlalchemy/dialects/sqlite/base.pyc
 ${PYSITELIB}/sqlalchemy/dialects/sqlite/base.pyo
+${PYSITELIB}/sqlalchemy/dialects/sqlite/json.py
+${PYSITELIB}/sqlalchemy/dialects/sqlite/json.pyc
+${PYSITELIB}/sqlalchemy/dialects/sqlite/json.pyo
 ${PYSITELIB}/sqlalchemy/dialects/sqlite/pysqlcipher.py
 ${PYSITELIB}/sqlalchemy/dialects/sqlite/pysqlcipher.pyc
 ${PYSITELIB}/sqlalchemy/dialects/sqlite/pysqlcipher.pyo
@@ -388,9 +391,18 @@ ${PYSITELIB}/sqlalchemy/orm/unitofwork.p
 ${PYSITELIB}/sqlalchemy/orm/util.py
 ${PYSITELIB}/sqlalchemy/orm/util.pyc
 ${PYSITELIB}/sqlalchemy/orm/util.pyo
-${PYSITELIB}/sqlalchemy/pool.py
-${PYSITELIB}/sqlalchemy/pool.pyc
-${PYSITELIB}/sqlalchemy/pool.pyo
+${PYSITELIB}/sqlalchemy/pool/__init__.py
+${PYSITELIB}/sqlalchemy/pool/__init__.pyc
+${PYSITELIB}/sqlalchemy/pool/__init__.pyo
+${PYSITELIB}/sqlalchemy/pool/base.py
+${PYSITELIB}/sqlalchemy/pool/base.pyc
+${PYSITELIB}/sqlalchemy/pool/base.pyo
+${PYSITELIB}/sqlalchemy/pool/dbapi_proxy.py
+${PYSITELIB}/sqlalchemy/pool/dbapi_proxy.pyc
+${PYSITELIB}/sqlalchemy/pool/dbapi_proxy.pyo
+${PYSITELIB}/sqlalchemy/pool/impl.py
+${PYSITELIB}/sqlalchemy/pool/impl.pyc
+${PYSITELIB}/sqlalchemy/pool/impl.pyo
 ${PYSITELIB}/sqlalchemy/processors.py
 ${PYSITELIB}/sqlalchemy/processors.pyc
 ${PYSITELIB}/sqlalchemy/processors.pyo
@@ -490,9 +502,6 @@ ${PYSITELIB}/sqlalchemy/testing/plugin/_
 ${PYSITELIB}/sqlalchemy/testing/plugin/bootstrap.py
 ${PYSITELIB}/sqlalchemy/testing/plugin/bootstrap.pyc
 ${PYSITELIB}/sqlalchemy/testing/plugin/bootstrap.pyo
-${PYSITELIB}/sqlalchemy/testing/plugin/noseplugin.py
-${PYSITELIB}/sqlalchemy/testing/plugin/noseplugin.pyc
-${PYSITELIB}/sqlalchemy/testing/plugin/noseplugin.pyo
 ${PYSITELIB}/sqlalchemy/testing/plugin/plugin_base.py
 ${PYSITELIB}/sqlalchemy/testing/plugin/plugin_base.pyc
 ${PYSITELIB}/sqlalchemy/testing/plugin/plugin_base.pyo
@@ -511,9 +520,6 @@ ${PYSITELIB}/sqlalchemy/testing/replay_f
 ${PYSITELIB}/sqlalchemy/testing/requirements.py
 ${PYSITELIB}/sqlalchemy/testing/requirements.pyc
 ${PYSITELIB}/sqlalchemy/testing/requirements.pyo
-${PYSITELIB}/sqlalchemy/testing/runner.py
-${PYSITELIB}/sqlalchemy/testing/runner.pyc
-${PYSITELIB}/sqlalchemy/testing/runner.pyo
 ${PYSITELIB}/sqlalchemy/testing/schema.py
 ${PYSITELIB}/sqlalchemy/testing/schema.pyc
 ${PYSITELIB}/sqlalchemy/testing/schema.pyo

Index: pkgsrc/databases/py-sqlalchemy/distinfo
diff -u pkgsrc/databases/py-sqlalchemy/distinfo:1.45 pkgsrc/databases/py-sqlalchemy/distinfo:1.46
--- pkgsrc/databases/py-sqlalchemy/distinfo:1.45        Wed Feb 20 15:56:15 2019
+++ pkgsrc/databases/py-sqlalchemy/distinfo     Tue Apr  2 08:59:13 2019
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.45 2019/02/20 15:56:15 adam Exp $
+$NetBSD: distinfo,v 1.46 2019/04/02 08:59:13 adam Exp $
 
-SHA1 (SQLAlchemy-1.2.18.tar.gz) = 16e532601a0cbe0070af9207c22302c190cc2690
-RMD160 (SQLAlchemy-1.2.18.tar.gz) = fd43fe4e04b86b101f6b4ef14257d6faa680e852
-SHA512 (SQLAlchemy-1.2.18.tar.gz) = a3074e0f7b9a307937f02ad030811413f3c92b7edcc4f1c6eda7c94c1178708f8c920840385a9b33c7952e224fe46dc73223aee00123e863abf6d1d446aebdb2
-Size (SQLAlchemy-1.2.18.tar.gz) = 5675143 bytes
+SHA1 (SQLAlchemy-1.3.1.tar.gz) = b8475576917e12de1170305c6f9be9b6d3cafe4a
+RMD160 (SQLAlchemy-1.3.1.tar.gz) = 315ee1709bf2215e9fbbccb0174309da07ad4594
+SHA512 (SQLAlchemy-1.3.1.tar.gz) = a5f9506060cce7c688be5d0b25c5a34a904a64e07447e11d9a2e546c1020849038f370f5808d817f192ec36d6df7443ad328145be1af2baaad3913dab6b4cb8d
+Size (SQLAlchemy-1.3.1.tar.gz) = 5864223 bytes