- Update to 1.4.54:

* Fixed regression from 1.3 where the column key used for a hybrid property
    might be populated with that of the underlying column that it returns.
  * The pin for ``setuptools<69.3`` in ``pyproject.toml`` has been removed.
  * Set up full Python 3.13 support to the extent currently possible, repairing
    issues within internal language helpers as well as the serializer extension
    module.
  * Adjustments to the C extensions, which are specific to the SQLAlchemy 1.x
    series, to work under Python 3.13.
  * Fixed regression going back to 1.4 where accessing a collection using the
    "dynamic" strategy on a transient object and attempting to query would
    raise an internal error. 
  * Fixed bug where ORM :func:`_orm.with_loader_criteria` would not apply
    itself to a :meth:`_sql.Select.join` where the ON clause were given as a
    plain SQL comparison, rather than as a relationship target or similar.
  * Fixed regression introduced by the fix when using pool pre-ping with
    PyMySQL version older than 1.0.
  * Fixed critical issue in asyncio version of the connection pool where
    calling :meth:`_asyncio.AsyncEngine.dispose` would produce a new connection
    pool that did not fully re-establish the use of asyncio-compatible mutexes
  * Fixed fundamental issue which prevented some forms of ORM "annotations"
    from taking place for subqueries which made use of :meth:`_sql.Select.join`
    against a relationship target
  * Repaired a new incompatibility in the MySQL "pre-ping" routine where the
    ``False`` argument passed to ``connection.ping()``, which is intended to
    disable an unwanted "automatic reconnect" feature
- Switch to pyproject macros.

OBS-URL: https://build.opensuse.org/package/show/devel:languages:python/python-SQLAlchemy1?expand=0&rev=18

.gitattributes

@@ -0,0 +1,23 @@
+## Default LFS
+*.7z filter=lfs diff=lfs merge=lfs -text
+*.bsp filter=lfs diff=lfs merge=lfs -text
+*.bz2 filter=lfs diff=lfs merge=lfs -text
+*.gem filter=lfs diff=lfs merge=lfs -text
+*.gz filter=lfs diff=lfs merge=lfs -text
+*.jar filter=lfs diff=lfs merge=lfs -text
+*.lz filter=lfs diff=lfs merge=lfs -text
+*.lzma filter=lfs diff=lfs merge=lfs -text
+*.obscpio filter=lfs diff=lfs merge=lfs -text
+*.oxt filter=lfs diff=lfs merge=lfs -text
+*.pdf filter=lfs diff=lfs merge=lfs -text
+*.png filter=lfs diff=lfs merge=lfs -text
+*.rpm filter=lfs diff=lfs merge=lfs -text
+*.tbz filter=lfs diff=lfs merge=lfs -text
+*.tbz2 filter=lfs diff=lfs merge=lfs -text
+*.tgz filter=lfs diff=lfs merge=lfs -text
+*.ttf filter=lfs diff=lfs merge=lfs -text
+*.txz filter=lfs diff=lfs merge=lfs -text
+*.whl filter=lfs diff=lfs merge=lfs -text
+*.xz filter=lfs diff=lfs merge=lfs -text
+*.zip filter=lfs diff=lfs merge=lfs -text
+*.zst filter=lfs diff=lfs merge=lfs -text

.gitignore

@@ -0,0 +1 @@
+.osc

SQLAlchemy.keyring

@@ -0,0 +1,37 @@
+-----BEGIN PGP PUBLIC KEY BLOCK-----
+
+mQENBE7aWmgBCADVSqbsWrHav9zZQ37fqMACJqj3H5FU4aw2zvVqzsyvNA2/PuX6
+chPN+b63tK2dX3n+EPOl2LanVRU31dc/D8DqXl7HzTlfoIfTq+NWJkVFBKHELm5E
+rsh7NZjGFkLtKXT1rifuhE/64A7Fay0IbXwdW6oNiDO5XWz6NQMgw8fbvssc6ZJx
+YUxKzEJwaj9nZJwObi40yuM6wNFDKBnvIzKmRnd2WHJO0EvqD1bMtgFuBN6vZCa2
+6W2qXb2Vqz99z7EfKfVZoLQ5+FfiuqSKVHxJBp5uFf3regbkxhsZyXp1/czvL6Qu
+pKhahQNxYC8PB0A+6DPmsS6dPb4Xxt9kUW2zABEBAAG0KE1pY2hhZWwgQmF5ZXIg
+PGNsYXNzaWNAenp6Y29tcHV0aW5nLmNvbT6JATgEEwECACIFAk7aXAwCGwMGCwkI
+BwMCBhUIAgkKCwQWAgMBAh4BAheAAAoJEDMCOcHE2v7hfhsH/0jaDg85TC58t7l2
+jyLVn87ubdFQnTUYerRv1xVTiawbx3UqpJaws5zov+B1aBzcaljRRPOn53iH/uw2
+9AgSCvvUfifD3Xqqj7aMOZpjqhwmrUFmzf3qoX+jz6U4imxnURbMWEuNPEVeprMX
+fHKBKcc1liH961JbL/Z0SBc7hLjeI8FjwWOmT8rJ9eFYmKNkRn1xl/z670P+owWs
+Zq+a1KFljbIW49WZkM24cpQKYqhvpYTXb0wnhNAiC4nuKVGklDOtYvDpb6FjgkYb
+Pj687SYWeXbdgwOOV3Hds0pqLng5xJZpONR2qpnQnWoLFRiLdck30LEKrQNBApPv
+oKikyRK0KE1pY2hhZWwgQmF5ZXIgPG1pa2VfbXBAenp6Y29tcHV0aW5nLmNvbT6J
+ATgEEwECACIFAk7aWmgCGwMGCwkIBwMCBhUIAgkKCwQWAgMBAh4BAheAAAoJEDMC
+OcHE2v7hC4QH/jAaKH8Q9BGEROzBQvQpcs/8aymXJROia8qU9wYl39W8Dspmb2B8
+DDcnA7WB2+2tUL951U+cNywv0ztzdLxdFf3xQxtfiywv07AS2kxMWPBPnwMWBfFj
+GQDJGQGacad4WB0hLME0e61i8lQPD70KdLN4wVz2UFbZ4yQFe0RFkfGRCTWbvw7Q
+yOiObo2atN0g61JC0YYFIU95z+epMo+bcBpBsK1LpVe5EnaOFaOccnbXJnJRN7DR
+7mD+MjS58LgxITfxQgPmLadPe7HugUs5k0wPyqGPIAtZUIEUBSgNbJY5Nd1On+2M
+hbnDELlJWLEY/6ItGi9IZvOom5NE1M37ata5AQ0ETtpaaAEIANpKU0jegv+w7o2k
+9MsE6PDzZz2NyPpmSZcBK2QM7vz3TCbndegZj58Rj8Cz3sMMJd4WD2sdKlIMBG9g
+JasRe/EGrR5lhhRL7Z9N6v/dlZ2SzXpMN+wnLM3KA+Hs4OMI/D6zS0FYsDPe+Rhw
+Z44pNT3WpmnRRnBfoyBscWFicSBrtcEQCPfAmSVfL8zhSh4Jp+RIi9XIAuFSCXHZ
+KTothJUcqlpvDEERJ3bVpSPypQqfd9sg3hXrrK44lDnMfgf4FeB6ewg2BllCxaUw
+G8kjO/gY0zBBqThY8q7ejnBOWF/mqzj/x16qnv09uN+4Fb20dJk5XHFDGPDsCpTm
+ouqApa0AEQEAAYkBHwQYAQIACQUCTtpaaAIbDAAKCRAzAjnBxNr+4VHvCACQL5+e
+H+ZOgawuJBcQRXLLBHSQvdu+jk+ZaJGTjihIIerKHkMXGl3Yjhv+wIbmhQLeCLzf
+6vAN7WsDjwnQaHXQtgkzffllSLMcz8uTbFj31XvVJb/gqj1i3Z+scA1nv3sZljKt
+BwNVDbe5Xk8SVxw4QFQa8pV14pe9AylMa1bovhkJDQO/4m6O8EyZIpRx2c7yFZdU
+i26clzlbR6LYONNIbiPmwIO4ati5P5pexK7RBwD6A7flucjO8RwObCC0aHUqrbyi
+KHuAEYqBQfnTxT7C1R/6GKZZ6uqGOvm3tMkZf3UKtaKlaLtzC7960P8A8IP7hFtv
+5qf+DkoAGJ5NzOVT
+=lWzK
+-----END PGP PUBLIC KEY BLOCK-----

python-SQLAlchemy1.spec

@@ -0,0 +1,100 @@
+#
+# spec file for package python-SQLAlchemy1
+#
+# Copyright (c) 2024 SUSE LLC
+#
+# All modifications and additions to the file contributed by third parties
+# remain the property of their copyright owners, unless otherwise agreed
+# upon. The license for this file, and modifications and additions to the
+# file, is the same license as for the pristine package itself (unless the
+# license for the pristine package is not an Open Source License, in which
+# case the license is the MIT License). An "Open Source License" is a
+# license that conforms to the Open Source Definition (Version 1.9)
+# published by the Open Source Initiative.
+
+# Please submit bugfixes or comments via https://bugs.opensuse.org/
+#
+
+
+%define skip_python2 1
+%define oldpython python
+%{?sle15_python_module_pythons}
+Name:           python-SQLAlchemy1
+Version:        1.4.54
+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
+Source1:        SQLAlchemy.keyring
+# devel is needed for optional C extensions cprocessors.so, cresultproxy.so and cutils.so
+BuildRequires:  %{python_module devel}
+BuildRequires:  %{python_module pip}
+BuildRequires:  %{python_module setuptools}
+BuildRequires:  %{python_module wheel}
+BuildRequires:  %{pythons}
+BuildRequires:  fdupes
+BuildRequires:  python-rpm-macros
+Requires:       python
+Requires:       python-greenlet
+Provides:       python-SQLAlchemy = %{version}
+Provides:       python-sqlalchemy = %{version}
+Conflicts:      python-SQLAlchemy
+%if %{python_version_nodots} < 38
+Requires:       python-importlib-metadata
+%endif
+# SECTION test requirements
+BuildRequires:  %{python_module greenlet}
+BuildRequires:  %{python_module importlib-metadata}
+BuildRequires:  %{python_module pytest >= 4.4.0}
+# /SECTION
+%python_subpackages
+
+%description
+SQLAlchemy is an Object Relational Mappper (ORM) that provides a flexible,
+high-level interface to SQL databases.  Database and domain concepts are
+decoupled, allowing both sides maximum flexibility and power. SQLAlchemy
+provides a powerful mapping layer that can work as automatically or as manually
+as you choose, determining relationships based on foreign keys or letting you
+define the join conditions explicitly, to bridge the gap between database and
+domain.
+
+%package -n %{name}-doc
+Summary:        Documentation for python-SQLAlchemy
+Provides:       %{python_module SQLAlchemy-doc = %{version}}
+BuildArch:      noarch
+
+%description -n %{name}-doc
+This package contains HTML documentation, including tutorials and API
+reference for python-SQLAlchemy.
+
+%prep
+%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
+
+%build
+export CFLAGS="%{optflags} -fno-strict-aliasing"
+%pyproject_wheel
+
+%install
+%pyproject_install
+%python_expand %fdupes %{buildroot}%{$python_sitearch}
+
+%check
+# One test fails on Python 3.6
+# packaging.version.InvalidVersion: Invalid version: 'SQLAlchemy'
+%pytest_arch -k 'not (test_parseconnect and CreateEngineTest and test_bad_args)'
+
+%files %{python_files}
+%license LICENSE
+%doc CHANGES README.rst README.dialects.rst README.unittests.rst
+%{python_sitearch}/sqlalchemy/
+%{python_sitearch}/SQLAlchemy-%{version}.dist-info
+
+%files -n %{name}-doc
+%doc doc/
+%doc examples/
+
+%changelog