./databases/py-sqlalchemy, Python SQL toolkit and Object Relational Mapper

[ CVSweb ] [ Homepage ] [ RSS ] [ Required by ] [ Add to tracker ]

Branch: CURRENT, Version: 1.2.3, Package name: py27-sqlalchemy-1.2.3, Maintainer: pkgsrc-users

SQLAlchemy is the Python SQL toolkit and Object Relational Mapper that
gives application developers the full power and flexibility of SQL.

It provides a full suite of well known enterprise-level persistence
patterns, designed for efficient and high-performing database access,
adapted into a simple and Pythonic domain language.

Required to run:
[devel/py-setuptools] [lang/python27]

Required to build:
[devel/py-mock] [devel/py-test] [pkgtools/cwrappers] [devel/py-test-xdist]

Master sites:

SHA1: 07a3e4af6a0c077d1f135c91ca24f3b125460c1a
RMD160: 661ab1d9ab4834ca16431b379f0abb4faf4708ff
Filesize: 5420.703 KB

Version history: (Expand)

CVS history: (Expand)

   2018-02-22 10:53:07 by Adam Ciarcinski | Files touched by this commit (2) | Package updated
Log message:
py-sqlalchemy: updated to 1.2.3

Release 1.2.3 includes fixes for a variety of ORM, Core, and dialect-specific issues.
   2018-01-29 14:44:32 by Adam Ciarcinski | Files touched by this commit (2) | Package updated
Log message:
py-sqlalchemy: updated to 1.2.2

[orm] [bug] Fixed 1.2 regression regarding new bulk_replace event where a \ 
backref would fail to remove an object from the previous owner when a \ 
bulk-assignment assigned the object to a new owner.

[mysql] [bug] Added more MySQL 8.0 reserved words to the MySQL dialect for \ 
quoting purposes. Pull request courtesy Riccardo Magliocchetti.

[mssql] [bug] Added ODBC error code 10054 to the list of error codes that count \ 
as a disconnect for ODBC / MSSQL server.

[oracle] [bug] The cx_Oracle dialect now calls setinputsizes() with \ 
cx_Oracle.NCHAR unconditionally when the NVARCHAR2 datatype, in SQLAlchemy \ 
corresponding to sqltypes.Unicode(), is in use. Per cx_Oracle’s author this \ 
allows the correct conversions to occur within the Oracle client regardless of \ 
   2018-01-18 10:12:17 by Adam Ciarcinski | Files touched by this commit (3) | Package updated
Log message:
py-sqlalchemy: updated to 1.2.1


[orm] [bug] Fixed bug where an object that is expunged during a rollback of a \ 
nested or subtransaction which also had its primary key mutated would not be \ 
correctly removed from the session, causing subsequent issues in using the \ 
[orm] [bug] Fixed regression where pickle format of a Load / _UnboundLoad object \ 
(e.g. loader options) changed and __setstate__() was raising an \ 
UnboundLocalError for an object received from the legacy format, even though an \ 
attempt was made to do so. tests are now added to ensure this works.
[orm] [bug] Fixed regression caused by new lazyload caching scheme in 3954 where \ 
a query that makes use of loader options with of_type would cause lazy loads of \ 
unrelated paths to fail with a TypeError.
[orm] [bug] Fixed bug in new “selectin” relationship loader where the loader \ 
could try to load a non-existent relationship when loading a collection of \ 
polymorphic objects, where only some of the mappers include that relationship, \ 
typically when PropComparator.of_type() is being used.

[sql] [bug] Fixed bug in Insert.values() where using the “multi-values” \ 
format in combination with Column objects as keys rather than strings would \ 
fail. Pull request courtesy Aubrey Stark-Toller.

[mssql] [bug] Fixed regression in 1.2 where newly repaired quoting of collation \ 
names in 3785 breaks SQL Server, which explicitly does not understand a quoted \ 
collation name. Whether or not mixed-case collation names are quoted or not is \ 
now deferred down to a dialect-level decision so that each dialect can prepare \ 
these identifiers directly.

[oracle] [bug] Fixed regression where the removal of most setinputsizes rules \ 
from cx_Oracle dialect impacted the TIMESTAMP datatype’s ability to retrieve \ 
fractional seconds.
[oracle] [bug] Fixed regression in Oracle imports where a missing comma caused \ 
an undefined symbol to be present. Pull request courtesy Miroslav Shubernetskiy.

[bug] [ext] Fixed regression in association proxy due to 3769 (allow for chained \ 
any() / has()) where contains() against an association proxy chained in the form \ 
(o2m relationship, associationproxy(m2o relationship, m2o relationship)) would \ 
raise an error regarding the re-application of contains() on the final link of \ 
the chain.
[bug] [tests] Removed an oracle-specific requirements rule from the public test \ 
suite that was interfering with third party dialect suites.
[bug] [tests] Added a new exclusion rule group_by_complex_expression which \ 
disables tests that use “GROUP BY <expr>”, which seems to be not \ 
viable for at least two third party dialects.
   2017-09-13 19:29:06 by Min Sik Kim | Files touched by this commit (2) | Package updated
Log message:
py-sqlalchemy: Update to 1.1.14

Bug fixes only.

- Fixed bug in Session.merge() where an internal check for a target
  object in the identity map could lead to an error.
- Fixed bug where an undefer_group() option would not be recognized.
- Fixed race condition in ORM identity map.
- Fixed bug in Session.merge() where objects in a collection that had
  the primary key attribute set to None for a key that is typically
  autoincrementing would be considered to be a database-persisted key
  for part of the internal deduplication process.
- An InvalidRequestError is raised when a synonym() is used against an
  attribute that is not against a MapperProperty.
- Altered the range specification for window functions to allow for
  two of the same PRECEDING or FOLLOWING keywords in a range by
  allowing for the left side of the range to be positive and for the
  right to be negative.
   2017-08-03 20:21:51 by Adam Ciarcinski | Files touched by this commit (2)
Log message:
SQLAlchemy release 1.1.13:
This release modifies the just-released fix for Oracle "WITH_UNICODE" \ 
mode based on feedback from cx_Oracle developers, to resolve a performance \ 
regression caused by this change.
   2017-07-25 12:28:08 by Adam Ciarcinski | Files touched by this commit (2)
Log message:
SQLAlchemy release 1.1.12 is now available.

This release repairs an issue in the test suite that would prevent the suite \ 
from passing on Python version 3.6.2. The release is made at the same time as \ 
that of release 1.0.18 and 1.2.0b2. Also included are fixes related to ORM use \ 
of JSON NULL values, subquery eager loading, and a stability enhancement \ 
involving the identity map when used under high concurrency.
   2017-06-20 09:32:19 by Adam Ciarcinski | Files touched by this commit (2)
Log message:


[orm] [bug] Fixed issue with subquery eagerloading which continues on from the \ 
series of issues fixed in 2699, 3106, 3893 involving that the \ 
“subquery” contains the correct FROM clause when beginning from a \ 
joined inheritance subclass and then subquery eager loading onto a relationship \ 
from the base class, while the query also includes criteria against the \ 
subclass. The fix in the previous tickets did not accommodate for additional \ 
subqueryload operations loading more deeply from the first level, so the fix has \ 
been further generalized.


[sql] [bug] Fixed AttributeError which would occur in WithinGroup construct \ 
during an iteration of the structure.


[postgresql] [bug] Continuing with the fix that correctly handles Postgresql \ 
version string “10devel” released in 1.1.8, an additional regexp bump \ 
to handle version strings of the form “10beta1”. While Postgresql now \ 
offers better ways to get this information, we are sticking w/ the regexp at \ 
least through 1.1.x for the least amount of risk to compatibility w/ older or \ 
alternate Postgresql databases.

[postgresql] [bug] Fixed bug where using ARRAY with a string type that features \ 
a collation would fail to produce the correct syntax within CREATE TABLE.


[mysql] [bug] MySQL 5.7 has introduced permission limiting for the “SHOW \ 
VARIABLES” command; the MySQL dialect will now handle when SHOW returns no \ 
row, in particular for the initial fetch of SQL_MODE, and will emit a warning \ 
that user permissions should be modified to allow the row to be present.


[mssql] [bug] Fixed bug where SQL Server transaction isolation must be fetched \ 
from a different view when using Azure data warehouse, the query is now \ 
attempted against both views and then a NotImplemented is raised unconditionally \ 
if failure continues to provide the best resiliency against future arbitrary API \ 
changes in new SQL Server versions.

[mssql] [bug] Added a placeholder type mssql.XML to the SQL Server dialect, so \ 
that a reflected table which includes this type can be re-rendered as a CREATE \ 
TABLE. The type has no special round-trip behavior nor does it currently support \ 
additional qualifying arguments.


[oracle] [bug] Support for two-phase transactions has been removed entirely for \ 
cx_Oracle when version 6.0b1 or later of the DBAPI is in use. The two- phase \ 
feature historically has never been usable under cx_Oracle 5.x in any case, and \ 
cx_Oracle 6.x has removed the connection-level “twophase” flag upon \ 
which this feature relied.
   2017-06-01 11:58:42 by Adam Ciarcinski | Files touched by this commit (2)
Log message:
Release 1.1.10 contains a short series of fixes to specific behaviors, primarily \ 
in Core, as well as one issue with "delete orphan" cascade when using \ 
inheriting mappers. No regressions were encountered since 1.1.9. Release 1.1.10 \ 
is recommended for users who are impacted by the specific issues listed.