dev-python/sqlalchemy: Bump to 2.0.47

Signed-off-by: Michał Górny <mgorny@gentoo.org>

2 files changed, 118 insertions, 0 deletions

diff --git a/dev-python/sqlalchemy/Manifest b/dev-python/sqlalchemy/Manifest
index 3b96d75f2692..4653402a83e1 100644
--- a/dev-python/sqlalchemy/Manifest
+++ b/dev-python/sqlalchemy/Manifest
@@ -1,4 +1,5 @@
 DIST sqlalchemy-1.4.54.tar.gz 8470350 BLAKE2B 0d97beb4edde38455c03dfc1238655d1cb63aa6e042b941913ec68dca3654de07087ab967f208fda495f048a5068ced70d642c4b8b80ab32e5346fcefa3bf9bc SHA512 e7ea4920d81914d362134a3c6fd4a2dd4fdb75f6ce17358528d568e2b2ac0ee711a71f6beb894e61d6d1e4e5833034ebde651d73a13f873c682f780e1831b427
 DIST sqlalchemy-2.0.45.tar.gz 9869912 BLAKE2B 8d58d90067736d9c4d5cc6167a24cc3193620c3735873713406bcc500b7918aeb59ccc7101c3ed669f81ad6d9af633c40fdc56a0924cfba132d897f561dd9cdb SHA512 f7e603a893273c6bbd4f266bf186a1a043e329a695333a17147a68dadec54bf6b2fad7b11e3534bf6ce4c0e7bed3ad5ebe7a3bae01102258458a6ec33944c4a2
 DIST sqlalchemy-2.0.46.tar.gz 9865393 BLAKE2B c8b88889b0b4a4d5dff467b1e4c3820a8b7aea058e87991a661cf87113205b0c9a117f030bc7801d88a562e4f98a678cb54c3185ea64b4e8951d0b7fa781d767 SHA512 bc1fb1983207384e109c27c09eddbbfd96c80324349d93f084c922f5d1fc82c8f3ec63d9e9f10bdccc3a8ee902aa517adc1cc2db0d05302a52b0425ebbbc3aa7
+DIST sqlalchemy-2.0.47.tar.gz 9886323 BLAKE2B 62d6813b0144fed83c12eb3a7bcf197276e7cbdf2ea23a08688751d3ae8264c3c4f1f76b332486f4ef948d652b05b86be4757e45e540477f849a66f1d67d1cfe SHA512 aa2030e769e2010a475cb1572df5b38cddf17f4cc1a8b268254682d1844089154b7cc3c548ff2d609aa4473c384c1f69409318bb5b81c13a55d1c08a2e592e96
 DIST sqlalchemy-2.1.0b1.tar.gz 10135160 BLAKE2B 03f682f3d8476816784c35f0a5547608dcbece3c8d5fd1b750cf92f82c28f9041e35e02484714fd5680708515c14a2f99731586801a74d7b791d4174e45ba943 SHA512 3aa2b0967a56869e9582691aa7d6279a3a3801f4c5310d68f4ae3bc194d90a686c4667f119db7643bc08436d5982598e04646df1fe640a4bfda448af8791564d
diff --git a/dev-python/sqlalchemy/sqlalchemy-2.0.47.ebuild b/dev-python/sqlalchemy/sqlalchemy-2.0.47.ebuild
new file mode 100644
index 000000000000..c59b2b73dbd1
--- /dev/null
+++ b/dev-python/sqlalchemy/sqlalchemy-2.0.47.ebuild
@@ -0,0 +1,117 @@
+# Copyright 1999-2026 Gentoo Authors
+# Distributed under the terms of the GNU General Public License v2
+
+EAPI=8
+
+DISTUTILS_EXT=1
+DISTUTILS_USE_PEP517=setuptools
+PYPI_PN=SQLAlchemy
+PYTHON_COMPAT=( pypy3_11 python3_{11..14} )
+PYTHON_REQ_USE="sqlite?"
+
+inherit distutils-r1 optfeature pypi
+
+DESCRIPTION="Python SQL toolkit and Object Relational Mapper"
+HOMEPAGE="
+	https://www.sqlalchemy.org/
+	https://pypi.org/project/SQLAlchemy/
+	https://github.com/sqlalchemy/sqlalchemy/
+"
+
+LICENSE="MIT"
+SLOT="0"
+KEYWORDS="~alpha ~amd64 ~arm ~arm64 ~hppa ~loong ~m68k ~mips ~ppc ~ppc64 ~riscv ~s390 ~sparc ~x86 ~x64-macos ~x64-solaris"
+IUSE="examples +sqlite test"
+
+RDEPEND="
+	>=dev-python/typing-extensions-4.6.0[${PYTHON_USEDEP}]
+"
+BDEPEND="
+	dev-python/cython[${PYTHON_USEDEP}]
+	test? (
+		$(python_gen_impl_dep sqlite)
+	)
+"
+
+EPYTEST_PLUGINS=()
+EPYTEST_RERUNS=5
+EPYTEST_XDIST=1
+distutils_enable_tests pytest
+
+src_prepare() {
+	sed -i -e '/greenlet/d' setup.cfg || die
+	distutils-r1_src_prepare
+}
+
+python_test() {
+	local EPYTEST_IGNORE=(
+		test/ext/mypy/test_mypy_plugin_py3k.py
+		test/typing/test_mypy.py
+		# hardcode call counts specific to Python versions
+		test/aaa_profiling
+	)
+	local EPYTEST_DESELECT=(
+		# warning tests are unreliable
+		test/base/test_warnings.py
+		# TODO: flaky? xdist?
+		test/base/test_concurrency_py3k.py::TestAsyncioCompat::test_await_fallback_no_greenlet
+	)
+	local sqlite_version=$(sqlite3 --version | cut -d' ' -f1)
+	case ${EPYTHON} in
+		pypy3.11)
+			EPYTEST_DESELECT+=(
+				# TODO: looks like cursor cleanup failure
+				"test/dialect/test_suite.py::ReturningGuardsTest_sqlite+pysqlite_${sqlite_version//./_}"
+				# mismatched exception messages
+				"test/dialect/sqlite/test_types.py::TestTypes_sqlite+pysqlite_${sqlite_version//./_}::test_cant_parse_datetime_message"
+				test/ext/test_associationproxy.py::DictOfTupleUpdateTest::test_update_multi_elem_varg
+				test/ext/test_associationproxy.py::DictOfTupleUpdateTest::test_update_one_elem_varg
+				test/ext/test_associationproxy.py::ProxyHybridTest::test_msg_fails_on_cls_access
+				test/engine/test_processors.py::PyDateProcessorTest::test_time_invalid_string
+				# TODO
+				test/orm/test_utils.py::ContextualWarningsTest::test_autoflush_implicit
+				test/orm/test_utils.py::ContextualWarningsTest::test_configure_mappers_explicit
+				"test/sql/test_resultset.py::CursorResultTest_sqlite+pysqlite_${sqlite_version//./_}::test_new_row_no_dict_behaviors"
+				"test/sql/test_compare.py::HasCacheKeySubclass::test_init_args_in_traversal[_MemoizedSelectEntities]"
+				test/sql/test_lambdas.py::LambdaElementTest::test_bindparam_not_cached
+				test/sql/test_compare.py::CompareAndCopyTest::test_all_present
+				"test/dialect/sqlite/test_on_conflict.py::OnConflictTest_sqlite+pysqlite_${sqlite_version//./_}::test_on_conflict_do_update_bindparam"
+			)
+			;;
+	esac
+	if ! has_version "dev-python/greenlet[${PYTHON_USEDEP}]"; then
+		EPYTEST_DESELECT+=(
+			test/ext/asyncio/test_engine_py3k.py::TextSyncDBAPI::test_sync_driver_execution
+			test/ext/asyncio/test_engine_py3k.py::TextSyncDBAPI::test_sync_driver_run_sync
+			"test/engine/test_pool.py::PoolEventsTest::test_checkin_event_gc[False-True]"
+			"test/engine/test_pool.py::PoolEventsTest::test_checkin_event_gc[True-True]"
+			"test/engine/test_pool.py::PoolEventsTest::test_checkin_event_gc[has_terminate-is_asyncio]"
+			"test/engine/test_pool.py::PoolEventsTest::test_checkin_event_gc[not_has_terminate-is_asyncio]"
+			"test/engine/test_pool.py::QueuePoolTest::test_userspace_disconnectionerror_weakref_finalizer[True-_exclusions0]"
+			"test/engine/test_pool.py::QueuePoolTest::test_userspace_disconnectionerror_weakref_finalizer[True]"
+		)
+	fi
+
+	# upstream's test suite is horribly hacky; it relies on disabling
+	# the warnings plugin and turning warnings into errors;  this also
+	# means that any DeprecationWarnings from third-party plugins cause
+	# everything to explode
+	epytest --reruns-delay=2 -m "not gc_intensive and not timing_intensive and not mypy"
+}
+
+python_install_all() {
+	if use examples; then
+		docompress -x "/usr/share/doc/${PF}/examples"
+		dodoc -r examples
+	fi
+
+	distutils-r1_python_install_all
+}
+
+pkg_postinst() {
+	optfeature "asyncio support" dev-python/greenlet
+	optfeature "MySQL support" \
+		dev-python/mysqlclient \
+		dev-python/pymysql
+	optfeature "postgresql support" dev-python/psycopg:2
+}