Accepting request 1221783 from home:glaubitz:branches:devel:languages:python

- Update to 2.0.36
  * Fixed bug where SQL functions passed to
    :paramref:`_schema.Column.server_default` would not be rendered with the
    particular form of parenthesization now required by newer versions of MySQL
    and MariaDB. Pull request courtesy of huuya.
  * Fixed bug in ORM bulk update/delete where using RETURNING with bulk
    update/delete in combination with ``populate_existing`` would fail to
    accommodate the ``populate_existing`` option.
  * Continuing from 🎫`11912`, columns marked with
    :paramref:`.mapped_column.onupdate`,
    :paramref:`.mapped_column.server_onupdate`, or :class:`.Computed` are now
    refreshed in ORM instances when running an ORM enabled UPDATE with WHERE
    criteria, even if the statement does not use RETURNING or
    ``populate_existing``.
  * Added new parameter :paramref:`_orm.mapped_column.hash` to ORM constructs
    such as :meth:`_orm.mapped_column`, :meth:`_orm.relationship`, etc.,
    which is interpreted for ORM Native Dataclasses in the same way as other
    dataclass-specific field parameters.
  * Fixed bug in reflection of table comments where unrelated text would be
    returned if an entry in the ``pg_description`` table happened to share the
    same oid (objoid) as the table being reflected.
  * Fixed regression caused by fixes to joined eager loading in 🎫`11449`
    released in 2.0.31, where a particular joinedload case could not be
    asserted correctly.   We now have an example of that case so the assertion
    has been repaired to allow for it.
  * Improved the error message emitted when trying to map as dataclass a class
    while also manually providing the ``__table__`` attribute.
    This usage is currently not supported.
  * Improved a query used for the MySQL 8 backend when reflecting foreign keys
    to be better optimized.   Previously, for a database that had millions of

OBS-URL: https://build.opensuse.org/request/show/1221783
OBS-URL: https://build.opensuse.org/package/show/devel:languages:python/python-SQLAlchemy?expand=0&rev=262

python-SQLAlchemy.changes

@@ -1,3 +1,66 @@
+-------------------------------------------------------------------
+Wed Nov  6 14:43:11 UTC 2024 - John Paul Adrian Glaubitz <adrian.glaubitz@suse.com>
+
+- Update to 2.0.36
+  * Fixed bug where SQL functions passed to
+    :paramref:`_schema.Column.server_default` would not be rendered with the
+    particular form of parenthesization now required by newer versions of MySQL
+    and MariaDB. Pull request courtesy of huuya.
+  * Fixed bug in ORM bulk update/delete where using RETURNING with bulk
+    update/delete in combination with ``populate_existing`` would fail to
+    accommodate the ``populate_existing`` option.
+  * Continuing from :ticket:`11912`, columns marked with
+    :paramref:`.mapped_column.onupdate`,
+    :paramref:`.mapped_column.server_onupdate`, or :class:`.Computed` are now
+    refreshed in ORM instances when running an ORM enabled UPDATE with WHERE
+    criteria, even if the statement does not use RETURNING or
+    ``populate_existing``.
+  * Added new parameter :paramref:`_orm.mapped_column.hash` to ORM constructs
+    such as :meth:`_orm.mapped_column`, :meth:`_orm.relationship`, etc.,
+    which is interpreted for ORM Native Dataclasses in the same way as other
+    dataclass-specific field parameters.
+  * Fixed bug in reflection of table comments where unrelated text would be
+    returned if an entry in the ``pg_description`` table happened to share the
+    same oid (objoid) as the table being reflected.
+  * Fixed regression caused by fixes to joined eager loading in :ticket:`11449`
+    released in 2.0.31, where a particular joinedload case could not be
+    asserted correctly.   We now have an example of that case so the assertion
+    has been repaired to allow for it.
+  * Improved the error message emitted when trying to map as dataclass a class
+    while also manually providing the ``__table__`` attribute.
+    This usage is currently not supported.
+  * Improved a query used for the MySQL 8 backend when reflecting foreign keys
+    to be better optimized.   Previously, for a database that had millions of
+    columns across all tables, the query could be prohibitively slow; the query
+    has been reworked to take better advantage of existing indexes.
+  * Datatypes that are binary based such as :class:`.VARBINARY` will resolve to
+    :class:`.LargeBinary` when the :meth:`.TypeEngine.as_generic()` method is
+    called.
+  * The :class:`.postgresql.JSON` and :class:`.postgresql.JSONB` datatypes will
+    now render a "bind cast" in all cases for all PostgreSQL backends,
+    including psycopg2, whereas previously it was only enabled for some
+    backends.   This allows greater accuracy in allowing the database server to
+    recognize when a string value is to be interpreted as JSON.
+  * Refined the check which the ORM lazy loader uses to detect "this would be
+    loading by primary key and the primary key is NULL, skip loading" to take
+    into account the current setting for the
+    :paramref:`.orm.Mapper.allow_partial_pks` parameter. If this parameter is
+    ``False``, then a composite PK value that has partial NULL elements should
+    also be skipped.   This can apply to some composite overlapping foreign key
+    configurations.
+  * Fixed bug in ORM "update with WHERE clause" feature where an explicit
+    ``.returning()`` would interfere with the "fetch" synchronize strategy due
+    to an assumption that the ORM mapped class featured the primary key columns
+    in a specific position within the RETURNING.  This has been fixed to use
+    appropriate ORM column targeting.
+  * Fixed regression from 1.4 where some datatypes such as those derived from
+    :class:`.TypeDecorator` could not be pickled when they were part of a
+    larger SQL expression composition due to internal supporting structures
+    themselves not being pickleable.
+- Adjust upstream source name in spec file
+- For changes between 2.0.33 through 2.0.34 see the upstream changelog
+  * https://docs.sqlalchemy.org/en/20/changelog
+
 -------------------------------------------------------------------
 Mon Aug 19 07:10:55 UTC 2024 - Dirk Müller <dmueller@suse.com>
 

python-SQLAlchemy.spec

@@ -18,12 +18,12 @@
 
 %{?sle15_python_module_pythons}
 Name:           python-SQLAlchemy
-Version:        2.0.32
+Version:        2.0.36
 Release:        0
 Summary:        Database Abstraction Library
 License:        MIT
 URL:            https://www.sqlalchemy.org
-Source:         https://files.pythonhosted.org/packages/source/S/SQLAlchemy/SQLAlchemy-%{version}.tar.gz
+Source:         https://files.pythonhosted.org/packages/source/s/sqlalchemy/sqlalchemy-%{version}.tar.gz
 Source1:        SQLAlchemy.keyring
 # devel is needed for optional C extensions cprocessors.so, cresultproxy.so and cutils.so
 BuildRequires:  %{python_module Cython >= 3}
@@ -71,7 +71,7 @@ This package contains HTML documentation, including tutorials and API
 reference for python-SQLAlchemy.
 
 %prep
-%autosetup -p1 -n SQLAlchemy-%{version}
+%autosetup -p1 -n sqlalchemy-%{version}
 
 rm -rf doc/build # Remove unnecessary scripts for building documentation
 sed -i 's/\r$//' examples/dynamic_dict/dynamic_dict.py

sqlalchemy-2.0.36.tar.gz

@@ -0,0 +1,3 @@
+version https://git-lfs.github.com/spec/v1
+oid sha256:7f2767680b6d2398aea7082e45a774b2b0767b5c8d8ffb9c8b683088ea9b29c5
+size 9574485