Adding metadata

19 files changed, 267 insertions, 231 deletions

diff --git a/dev-python/asgiref/asgiref-3.8.1.ebuild b/dev-python/asgiref/asgiref-3.8.1.ebuild
index 5029f848bf31..14c6aac5cf6e 100644
--- a/dev-python/asgiref/asgiref-3.8.1.ebuild
+++ b/dev-python/asgiref/asgiref-3.8.1.ebuild
@@ -19,10 +19,5 @@ LICENSE="BSD"
 SLOT="0"
 KEYWORDS="~alpha amd64 arm arm64 hppa ~loong ~mips ppc ppc64 ~riscv ~s390 sparc x86"
 
-BDEPEND="
-	test? (
-		dev-python/pytest-asyncio[${PYTHON_USEDEP}]
-	)
-"
-
+EPYTEST_PLUGINS=( pytest-asyncio )
 distutils_enable_tests pytest
diff --git a/dev-python/bitarray/Manifest b/dev-python/bitarray/Manifest
index 3b5235ae3643..a2572c65c912 100644
--- a/dev-python/bitarray/Manifest
+++ b/dev-python/bitarray/Manifest
@@ -1 +1,2 @@
 DIST bitarray-3.4.2.tar.gz 143756 BLAKE2B a3b6f54d05b5bb9e77d1384202c6ecc869553064bdcbe18d8c135dfc2d5e7ba55abb2f075238ef85a3a2a11da6308eea2bce5d519a94a9de517bd809d4a8facc SHA512 28dc796f1a25833bfc54035bb9e33d923f8e6ea85b5977cbdf0febd5a189cbd561e3295e6dd06a3f2f5df7b55c5bc3a5b8197d8c47af27e6478cbe2f0d8bc876
+DIST bitarray-3.4.3.tar.gz 143930 BLAKE2B 6a41725fa551429dfd1715fde7543520362dbbe193bc8fe60a44508bc88e4d24eb74e28d65f7a32c1129713d2ae11fcac8562d23e5d5ecfb06e3355ffdb46f01 SHA512 4129ccd84ffc698a05f1625307b9becbdc46d9adacff73ea8b82d250da9a2a7071c132a2491b63b5018b3d444038311c35274b33a5a70178bb9bd62c770ed845
diff --git a/dev-python/bitarray/bitarray-3.4.3.ebuild b/dev-python/bitarray/bitarray-3.4.3.ebuild
new file mode 100644
index 000000000000..a510687dc8fd
--- /dev/null
+++ b/dev-python/bitarray/bitarray-3.4.3.ebuild
@@ -0,0 +1,24 @@
+# Copyright 1999-2025 Gentoo Authors
+# Distributed under the terms of the GNU General Public License v2
+
+EAPI=8
+
+DISTUTILS_EXT=1
+DISTUTILS_USE_PEP517=setuptools
+PYTHON_COMPAT=( python3_{11..14} )
+
+inherit distutils-r1 pypi
+
+DESCRIPTION="Efficient arrays of booleans -- C extension"
+HOMEPAGE="
+	https://github.com/ilanschnell/bitarray/
+	https://pypi.org/project/bitarray/
+"
+
+LICENSE="PSF-2"
+SLOT="0"
+KEYWORDS="~amd64 ~arm ~arm64 ~x86 ~amd64-linux ~x86-linux"
+
+python_test() {
+	"${EPYTHON}" bitarray/test_bitarray.py -v || die "Tests fail with ${EPYTHON}"
+}
diff --git a/dev-python/boto3/Manifest b/dev-python/boto3/Manifest
index 3767e2f65f77..f6c7a5086244 100644
--- a/dev-python/boto3/Manifest
+++ b/dev-python/boto3/Manifest
@@ -6,3 +6,4 @@ DIST boto3-1.38.38.gh.tar.gz 956172 BLAKE2B 806880f39b8ef3a92859340beb1d31a3e2ce
 DIST boto3-1.38.39.gh.tar.gz 958398 BLAKE2B dbbfc1635cc30103daa1dd7de197176bda4d35d9a27d12bfff33202fdf94dc8118b6a3dc8e250ef951bb0b047f0c28eb6c04ea1bde876c445621a9258d30a409 SHA512 d84ebcd930e233645400b49ca0fdf48c391d85aa33cc25fad8c970bc5add77b49365ed61041fdb58ea66cda4f2118c1edd606209120986544fc796d5f0d6dca3
 DIST boto3-1.38.40.gh.tar.gz 958953 BLAKE2B 08c9f5406fecb3251b0c0f7bf6b67a80a1fbf4572f92d8b78f7bc0e56376064d47497b7e70377efcf9afe53e785eabc1f2b12ce74dd3fca47d56e1f717b9a56c SHA512 a503d55219797a34014b5378d4b58dbc6c134790222b34c3155fd80356395eafa2ca5ab3e75e7a3e717726a661223f9ef18c984b4004d0589daf123332df813f
 DIST boto3-1.38.41.gh.tar.gz 959656 BLAKE2B cf74e27c26735b9a02be41df7e077aed5e3df61fec3cef38fbf08e6b24bb23030579a92f28a717056a86d67251ce69aae82820c4d8af0d34f4d77076ebc45f1b SHA512 dc3110929ac801348f960c419d555160e315e3724101fc3ec551cb60520703fa77a4dd69744e99b8062402b0d53941aa5a7a006bece5a064de7491fbf2050a37
+DIST boto3-1.38.42.gh.tar.gz 959917 BLAKE2B e53b807906bf367b91e4826b6ef1ad7446bde55b4f0b73bb62d7d88a74037c05ec13150a2bbe8c3b4f372452f730bf9d3e36dcef411df8ea87b0c0185aed4201 SHA512 f4eb6aa1c9d8e2062a1e5825b9e2c8ae988f904c30ed0efe1e937ff90e223dc488c3340c0462433da217dce3106c9746577f4add8a8a7e160de63bf0e3cbad93
diff --git a/dev-python/boto3/boto3-1.38.42.ebuild b/dev-python/boto3/boto3-1.38.42.ebuild
new file mode 100644
index 000000000000..0e521ede0704
--- /dev/null
+++ b/dev-python/boto3/boto3-1.38.42.ebuild
@@ -0,0 +1,53 @@
+# Copyright 1999-2025 Gentoo Authors
+# Distributed under the terms of the GNU General Public License v2
+
+EAPI=8
+
+DISTUTILS_USE_PEP517=setuptools
+PYTHON_COMPAT=( python3_{11..14} )
+
+inherit distutils-r1
+
+DESCRIPTION="The AWS SDK for Python"
+HOMEPAGE="
+	https://github.com/boto/boto3/
+	https://pypi.org/project/boto3/
+"
+SRC_URI="
+	https://github.com/boto/boto3/archive/${PV}.tar.gz
+		-> ${P}.gh.tar.gz
+"
+
+LICENSE="Apache-2.0"
+SLOT="0"
+KEYWORDS="~amd64 ~arm ~arm64 ~loong ~ppc ~ppc64 ~riscv ~sparc ~x86 ~amd64-linux ~x86-linux"
+
+RDEPEND="
+	>=dev-python/botocore-${PV}[${PYTHON_USEDEP}]
+	>=dev-python/jmespath-0.7.1[${PYTHON_USEDEP}]
+	>=dev-python/s3transfer-0.13.0[${PYTHON_USEDEP}]
+"
+
+EPYTEST_XDIST=1
+distutils_enable_tests pytest
+
+python_prepare_all() {
+	# don't lock versions to narrow ranges
+	sed -e '/botocore/ d' \
+		-e '/jmespath/ d' \
+		-e '/s3transfer/ d' \
+		-i setup.py || die
+
+	# do not rely on bundled deps in botocore (sic!)
+	find -name '*.py' -exec sed -i \
+		-e 's:from botocore[.]vendored import:import:' \
+		-e 's:from botocore[.]vendored[.]:from :' \
+		{} + || die
+
+	distutils-r1_python_prepare_all
+}
+
+python_test() {
+	local -x PYTEST_DISABLE_PLUGIN_AUTOLOAD=1
+	epytest tests/{functional,unit}
+}
diff --git a/dev-python/botocore/Manifest b/dev-python/botocore/Manifest
index ef993cae5a17..c1634498753c 100644
--- a/dev-python/botocore/Manifest
+++ b/dev-python/botocore/Manifest
@@ -6,3 +6,4 @@ DIST botocore-1.38.38.gh.tar.gz 14762089 BLAKE2B 07dcd8001267c9a6ff962a9a1c10fe8
 DIST botocore-1.38.39.gh.tar.gz 14778742 BLAKE2B 3d8533688317d05707e0cab26faebab522e24ffc84c189f0b1f7887c83c8f88aebe00fecdf6a660fded37e2edb2089127b4edcee89927f0e76e296f9dc14c368 SHA512 257350cbf5eb9ae5aac601847dcc5c09f74d7e4e73316c2a9bc35980d2300ae43884ffc3ed9aa06184fdef2bfa1ae6901cd0923fbc039d7949a904de1f710f78
 DIST botocore-1.38.40.gh.tar.gz 14783063 BLAKE2B 2c5eeb4ea827b21409fe9b21e837e12245cebc0063246e8e89b9574dc722b52410202a0ff8043cd05401eff2f0132c9e25dc0bcb8bd293902e5c44b957eef1f5 SHA512 4bd2cbb6f9907e33bab222f7da725b8790dcb53e69a2da4552d5bd1cde637d5467ac607a2df946edb2de561c1c81c294ad7933d621ad182e6906192407a4fb3b
 DIST botocore-1.38.41.gh.tar.gz 14788068 BLAKE2B 3bc2cfb9e45235b076266a96fd3568753c267ab8a1ff438e21159c3d31cfa9f0c6b057ffda665006adacb69d75282c34f31d14095388ee120274dd60cc4e0f2d SHA512 de75b9799754cfa55fd54716ab088719f96403d2fc9b357751263f8382bb513f0526d9815cbff7c317fbd66508354e6024d622bd09d0bef035939f03f172a575
+DIST botocore-1.38.42.gh.tar.gz 14799205 BLAKE2B 9def6b5bda7f2c16610e6b2b3925cb4d6e22940e6b4f11c82969749af81532977a62549b4f480e792d09322695efd6688a819b55d10e6560716eb56bb41915eb SHA512 c7ca063f9edf984b02e93afb8ee569c723d13c8ec70f77a8cc376abd9665260cfd990d6e52f13cb34059aff4e572892d0fd4ab3a3819030d08deaebf986717f2
diff --git a/dev-python/botocore/botocore-1.38.42.ebuild b/dev-python/botocore/botocore-1.38.42.ebuild
new file mode 100644
index 000000000000..be6df9120cc8
--- /dev/null
+++ b/dev-python/botocore/botocore-1.38.42.ebuild
@@ -0,0 +1,67 @@
+# Copyright 1999-2025 Gentoo Authors
+# Distributed under the terms of the GNU General Public License v2
+
+EAPI=8
+
+DISTUTILS_USE_PEP517=setuptools
+PYTHON_COMPAT=( python3_{11..14} )
+
+inherit distutils-r1
+
+DESCRIPTION="Low-level, data-driven core of boto 3"
+HOMEPAGE="
+	https://github.com/boto/botocore/
+	https://pypi.org/project/botocore/
+"
+SRC_URI="
+	https://github.com/boto/botocore/archive/${PV}.tar.gz
+		-> ${P}.gh.tar.gz
+"
+
+LICENSE="Apache-2.0"
+SLOT="0"
+KEYWORDS="~amd64 ~arm ~arm64 ~loong ~ppc ~ppc64 ~riscv ~sparc ~x86 ~amd64-linux ~x86-linux"
+
+RDEPEND="
+	<dev-python/jmespath-2[${PYTHON_USEDEP}]
+	dev-python/python-dateutil[${PYTHON_USEDEP}]
+	>=dev-python/urllib3-1.25.4[${PYTHON_USEDEP}]
+"
+# unbundled packages
+RDEPEND+="
+	dev-python/requests[${PYTHON_USEDEP}]
+	dev-python/six[${PYTHON_USEDEP}]
+"
+BDEPEND="
+	test? (
+		dev-python/jsonschema[${PYTHON_USEDEP}]
+	)
+"
+
+EPYTEST_XDIST=1
+distutils_enable_tests pytest
+
+src_prepare() {
+	# unpin deps
+	sed -i -e "s:>=.*':':" setup.py || die
+
+	# unbundle deps
+	rm -r botocore/vendored || die
+	find -name '*.py' -exec sed -i \
+		-e 's:from botocore[.]vendored import:import:' \
+		-e 's:from botocore[.]vendored[.]:from :' \
+		{} + || die
+
+	distutils-r1_src_prepare
+}
+
+python_test() {
+	local EPYTEST_DESELECT=(
+		# rely on bundled six
+		tests/functional/test_six_imports.py::test_no_bare_six_imports
+		tests/functional/test_six_threading.py::test_six_thread_safety
+	)
+
+	local -x PYTEST_DISABLE_PLUGIN_AUTOLOAD=1
+	epytest tests/{functional,unit}
+}
diff --git a/dev-python/caldav/Manifest b/dev-python/caldav/Manifest
index b90c21469f0f..dcad70a9f3da 100644
--- a/dev-python/caldav/Manifest
+++ b/dev-python/caldav/Manifest
@@ -1,2 +1 @@
-DIST caldav-1.5.0.tar.gz 157644 BLAKE2B 731f6eea65d17b4a15d0c22f7fdc3dbfaab0e6ba69f81365b99caad8ad44189493606d7a025c692959d88d65d7b43e6f90f0af71979b467b4eb1ae922fcd9582 SHA512 2c61f5e1ca85b20035e8e033025fbfa782faa7eff3e0ce504a77480a87a62237aeb57b36c2f8821553acf472a9bcda5c5b82a6f6e004aa7c5f961c53a736aa2f
 DIST caldav-1.6.0.tar.gz 156248 BLAKE2B 270a66f07e8c2374f42e5fc225f00c19f64f6fe4ad72a140f06da5931b910fbdddd028de0a44a5cfd65890374ebdd288d6056bfe592ac86e799d559531e55bc7 SHA512 966735f4de1a5759a64dacdc692f69d07bb86d07dfcb3da6988bfb18cc5bbc2430ebaaf0bda8fa2dd0100fb7a7dda75b1bdfa24475d0c4c2b5c1f9267de9367c
diff --git a/dev-python/caldav/caldav-1.5.0.ebuild b/dev-python/caldav/caldav-1.5.0.ebuild
deleted file mode 100644
index f92f9dfa20be..000000000000
--- a/dev-python/caldav/caldav-1.5.0.ebuild
+++ /dev/null
@@ -1,34 +0,0 @@
-# Copyright 1999-2025 Gentoo Authors
-# Distributed under the terms of the GNU General Public License v2
-
-EAPI=8
-
-DISTUTILS_USE_PEP517=setuptools
-PYTHON_COMPAT=( python3_{11..14} )
-
-inherit distutils-r1 pypi
-
-DESCRIPTION="CalDAV (RFC4791) client library for Python"
-HOMEPAGE="
-	https://github.com/python-caldav/caldav/
-	https://pypi.org/project/caldav/
-"
-
-LICENSE="|| ( GPL-3 Apache-2.0 )"
-SLOT="0"
-KEYWORDS="~amd64 ~arm64 ~x86"
-
-RDEPEND="
-	dev-python/icalendar[${PYTHON_USEDEP}]
-	dev-python/lxml[${PYTHON_USEDEP}]
-	>=dev-python/recurring-ical-events-2.0.0[${PYTHON_USEDEP}]
-	dev-python/requests[${PYTHON_USEDEP}]
-	dev-python/vobject[${PYTHON_USEDEP}]
-"
-BDEPEND="
-	test? (
-		dev-python/tzlocal[${PYTHON_USEDEP}]
-	)
-"
-
-distutils_enable_tests pytest
diff --git a/dev-python/langdetect/Manifest b/dev-python/langdetect/Manifest
index d12ab8aeaca8..a11d7c268c91 100644
--- a/dev-python/langdetect/Manifest
+++ b/dev-python/langdetect/Manifest
@@ -1,3 +1 @@
 DIST langdetect-1.0.9.tar.gz 981474 BLAKE2B ea8a9c3f16a2987c080742473bff4f2c1503f53fb3c2b40b0b1d6212bb6133ea22dce7864ffcfb8968c3a46b157d45cb3e2cf6f84bdbed0266cc716a853b032c SHA512 7558d674c47b080c79e43a00a25d2c7f77188cf60bea2cecb3bebb803d75e1aa42b43c74bd26ea1b541f4cb927421908882cbec01a91f0913984217e71ccc8db
-EBUILD langdetect-1.0.9.ebuild 494 BLAKE2B 9cd8a2a93a8d45bf51fe2324402b175d641762ea591fcb99459427f977a95eccffa6ca4777ca4df39814eea6eac62711567faa654456d32f79023a4685804504 SHA512 d973b85ba1a44389a4275f02a779a93a005f7c2e096467b94b072862e4984d5b42cf33f9821ac68aa5b85b12c98983a90b96049989d8c84497969174b6bb838e
-MISC metadata.xml 457 BLAKE2B 630128a3e982b6d60cc7b9f74c79fcb5ee47a71a02c73a50af9da8cedb6fad8e20a7f74b881e5b25c6483b92c9edbd56552cd38b2d9cbfa8b3eb4530facea969 SHA512 674f4f5cd809c6c77bc14e0f5687fa972bef14bdfa0b3343c5d66b7163eef1906eb87d060c8288732f825de71dce291ad0b841a5f2f0dd230f957b5687e45d45
diff --git a/dev-python/langdetect/files/langdetect-1.0.9-explicit-config.patch b/dev-python/langdetect/files/langdetect-1.0.9-explicit-config.patch
new file mode 100644
index 000000000000..637368d2f237
--- /dev/null
+++ b/dev-python/langdetect/files/langdetect-1.0.9-explicit-config.patch
@@ -0,0 +1,13 @@
+Fix "Package 'langdetect.profiles' is absent from the `packages` configuration."
+
+--- a/setup.py
++++ b/setup.py
+@@ -18,7 +18,7 @@ setup(
+     author_email='michal.danilak@gmail.com',
+     url='https://github.com/Mimino666/langdetect',
+     keywords='language detection library',
+-    packages=['langdetect', 'langdetect.utils', 'langdetect.tests'],
++    packages=['langdetect', 'langdetect.utils', 'langdetect.tests', 'langdetect.profiles'],
+     include_package_data=True,
+     install_requires=['six'],
+     license='MIT',
diff --git a/dev-python/langdetect/langdetect-1.0.9.ebuild b/dev-python/langdetect/langdetect-1.0.9.ebuild
index 56733bbffc48..99577c43fc3e 100644
--- a/dev-python/langdetect/langdetect-1.0.9.ebuild
+++ b/dev-python/langdetect/langdetect-1.0.9.ebuild
@@ -1,9 +1,9 @@
-# Copyright 2022 Gentoo Authors
+# Copyright 2022-2024 Gentoo Authors
 # Distributed under the terms of the GNU General Public License v2
 
 EAPI=8
 
-PYTHON_COMPAT=( python3_{9,10,11,12,13} pypy3 )
+PYTHON_COMPAT=( python3_{9,10,11,12,13} )
 DISTUTILS_USE_PEP517=setuptools
 inherit distutils-r1 pypi
 
@@ -19,4 +19,6 @@ KEYWORDS="~amd64"
 
 RDEPEND="dev-python/six[${PYTHON_USEDEP}]"
 
+PATCHES=( "${FILESDIR}/${P}-explicit-config.patch" )
+
 distutils_enable_tests unittest
diff --git a/dev-python/langdetect/metadata.xml b/dev-python/langdetect/metadata.xml
index 020e07f2a3dd..c0f74ac187e2 100644
--- a/dev-python/langdetect/metadata.xml
+++ b/dev-python/langdetect/metadata.xml
@@ -2,11 +2,9 @@
 <!DOCTYPE pkgmetadata SYSTEM "https://liguros.gitlab.io/dtd/metadata.dtd">
 <pkgmetadata>
  <maintainer type="person">
-  <email>marcin.deranek@slonko.net</email>
-  <name>Marcin Deranek</name>
+  <email>pastalian46@gmail.com</email>
+  <name>Takuya Wakazono</name>
  </maintainer>
- <upstream>
-  <bugs-to>https://github.com/Mimino666/langdetect/issues</bugs-to>
- </upstream>
- <origin>slonko-overlay</origin>
+ 
+ <origin>gentoo-guru-overlay</origin>
 </pkgmetadata>
\ No newline at end of file
diff --git a/dev-python/narwhals/Manifest b/dev-python/narwhals/Manifest
index e69acfc30c67..6e9452334ee4 100644
--- a/dev-python/narwhals/Manifest
+++ b/dev-python/narwhals/Manifest
@@ -1,2 +1,3 @@
 DIST narwhals-1.43.0.tar.gz 496455 BLAKE2B c9c22ce77f202711eebfb2628a2828bc0498bad786b7080955860b3e08f2ee344368ab13a32d0c517ce0a826e36ac2b2a2749feedc815f694f241253ea0ae80b SHA512 3a1f85261f11b37b7da16c56fa3ad0edca05ef944a832c540fee8ebc52c2f1bef90525a9bc398cde255f6b4f9f4e6ff63eee09ca9d42b82453192a845b0711c9
 DIST narwhals-1.43.1.tar.gz 496655 BLAKE2B 380ff403907fc2c1fda0fcbd0bb1ef034ae7fa866c9e187f78321ffff1bae52389088a04a6b1559113f58df2660dfcd40928509b58e312747fbd584d202340c6 SHA512 f845ba70b7f11a10dc4b4daee19ab907c9658ea2b4e2711c0cde973325d081de36e89d7d2c068706d43384769cc6063c5ca21cdf0510f8723cf1421f42e04ec2
+DIST narwhals-1.44.0.tar.gz 499250 BLAKE2B 24f45150f4d3f58778d4ccfc6bae8973de7352299e11ec12516e1ccd22079199b9bcfb51c5213223906e4afa2e58a09c59166a8fddaeb4f2bd526038b58d8b5b SHA512 6c9d6eefebdec18a18953caf2733c28cd2b5e4c93f5c391fe830787a0fdd309a5a534851cb000835b59ba84563842904cfb4f49fc67f30d2d8f21f3a6fb029c6
diff --git a/dev-python/narwhals/narwhals-1.44.0.ebuild b/dev-python/narwhals/narwhals-1.44.0.ebuild
new file mode 100644
index 000000000000..573156bed277
--- /dev/null
+++ b/dev-python/narwhals/narwhals-1.44.0.ebuild
@@ -0,0 +1,38 @@
+# Copyright 2025 Gentoo Authors
+# Distributed under the terms of the GNU General Public License v2
+
+EAPI=8
+
+DISTUTILS_USE_PEP517=hatchling
+PYTHON_COMPAT=( python3_{9,10,11,12,13} )
+
+inherit distutils-r1 pypi
+
+DESCRIPTION="Extremely lightweight compatibility layer between dataframe libraries"
+HOMEPAGE="
+	https://github.com/narwhals-dev/narwhals/
+	https://pypi.org/project/narwhals/
+"
+
+LICENSE="MIT"
+SLOT="0"
+KEYWORDS="~amd64 ~arm64"
+
+BDEPEND="
+	test? (
+		dev-python/hypothesis[${PYTHON_USEDEP}]
+		>=dev-python/pandas-1.1.3[${PYTHON_USEDEP}]
+		dev-python/pyarrow[${PYTHON_USEDEP}]
+		dev-python/pytest-env[${PYTHON_USEDEP}]
+	)
+"
+
+EPYTEST_XDIST=1
+distutils_enable_tests pytest
+
+python_test() {
+	local -x PYTEST_DISABLE_PLUGIN_AUTOLOAD=1
+	# make hypothesis more forgiving
+	local -x CI=1
+	epytest --runslow --constructors="pandas,pandas[nullable],pandas[pyarrow],pyarrow"
+}
diff --git a/dev-python/pyfakefs/Manifest b/dev-python/pyfakefs/Manifest
index 3f7c2e86cfa1..55419ecbea82 100644
--- a/dev-python/pyfakefs/Manifest
+++ b/dev-python/pyfakefs/Manifest
@@ -1,2 +1,3 @@
 DIST pyfakefs-5.7.4.gh.tar.gz 248270 BLAKE2B 3690b07f2030dc2428936fa34264c6e43b8145f1cfddade3c95bcebb337e483e9cff3e048f0a9d2d1bd6d542d9dc99a3b489a6fedf44c4ef84f2aaeb42200864 SHA512 305e794a66f3e490a60d1e256133edeef8266739fba73b99314a8e2c71990b9a8d774c5b8575709c0cfff7180ff2c4fcf41736d4f8207998053f87ba45d908be
 DIST pyfakefs-5.9.0.gh.tar.gz 255473 BLAKE2B bfdf023a19092ca621c37494b68d4c9a2f2ee72e093b9f04e9af33fe0a5040597c0863f40b922811044d9413fc8838204db8fcf2ec5c6d73c632cd79fe2150d4 SHA512 98d3ad5793602d2e9faacc1ae2252d984b5bcf0610f3e3304d35d98b0357d01a8d00a4f6a22a0929ec21de5eead8af335bf036e6f927b4e976ed2045e1f044fd
+DIST pyfakefs-5.9.1.gh.tar.gz 255569 BLAKE2B 510e04d23eba15fe3b74c973ef8856851a2cc5b9411273456f631b086af6fa72a4444c1cf4fcd0bb1f59ccc3e551144883181897a8d74736f7e1ed9f16efa303 SHA512 4d869897b98c73e73397032513304116ec1f3740f35831df053e9e80a6d50a5b063034c44269b6c8488119845246f7a4201af6d06ea7611ed988a11564fa0c5a
diff --git a/dev-python/pyfakefs/pyfakefs-5.9.1.ebuild b/dev-python/pyfakefs/pyfakefs-5.9.1.ebuild
new file mode 100644
index 000000000000..855efcd936f0
--- /dev/null
+++ b/dev-python/pyfakefs/pyfakefs-5.9.1.ebuild
@@ -0,0 +1,58 @@
+# Copyright 1999-2025 Gentoo Authors
+# Distributed under the terms of the GNU General Public License v2
+
+EAPI=8
+
+DISTUTILS_USE_PEP517=setuptools
+PYTHON_COMPAT=( python3_{9,10,11,12,13} pypy3 )
+
+inherit distutils-r1
+
+DESCRIPTION="A fake file system that mocks the Python file system modules"
+HOMEPAGE="
+	https://github.com/pytest-dev/pyfakefs/
+	https://pypi.org/project/pyfakefs/
+"
+SRC_URI="
+	https://github.com/pytest-dev/pyfakefs/archive/v${PV}.tar.gz
+		-> ${P}.gh.tar.gz
+"
+
+LICENSE="Apache-2.0"
+SLOT="0"
+KEYWORDS="~alpha ~amd64 ~arm ~arm64 ~hppa ~loong ~m68k ~mips ~ppc ~ppc64 ~riscv ~s390 ~sparc ~x86 ~x64-macos"
+
+distutils_enable_tests pytest
+
+python_test() {
+	local EPYTEST_DESELECT=(
+		# requires *.dist-info/RECORD file that we're stripping
+		pyfakefs/tests/fake_filesystem_test.py::RealFileSystemAccessTest::test_add_package_metadata
+	)
+	local EPYTEST_IGNORE=(
+		# test for regression with opentimelineio package
+		pyfakefs/pytest_tests/segfault_test.py
+		# test for regression with undefined package
+		pyfakefs/pytest_tests/pytest_fixture_test.py
+	)
+
+	if ! has_version "dev-python/pandas[${PYTHON_USEDEP}]"; then
+		EPYTEST_IGNORE+=(
+			pyfakefs/pytest_tests/pytest_reload_pandas_test.py
+		)
+	fi
+
+	case ${EPYTHON} in
+		pypy3.11)
+			EPYTEST_DESELECT+=(
+				# TODO: this test messes up everything
+				pyfakefs/tests/fake_filesystem_unittest_test.py::TestDeprecationSuppression::test_no_deprecation_warning
+				# TODO
+				pyfakefs/tests/fake_pathlib_test.py::SkipPathlibTest::test_exists
+			)
+			;;
+	esac
+
+	local -x PYTEST_DISABLE_PLUGIN_AUTOLOAD=1
+	epytest -p pyfakefs.pytest_plugin
+}
diff --git a/dev-python/sqlglot/Manifest b/dev-python/sqlglot/Manifest
index 923b3e585e59..d31813ba1e56 100644
--- a/dev-python/sqlglot/Manifest
+++ b/dev-python/sqlglot/Manifest
@@ -1,4 +1,2 @@
-DIST sqlglot-26.29.0-crates.tar.xz 8859792 BLAKE2B abb2051b392c53dc3caa705ddd8df7076819a26dcdaa89fa3760559a79578db01e86943c2d0ffb8006263c2dca3aa50d20023eae9d772f8ebd12a8a2d3266cdd SHA512 7cca439a06433a62bcd4a2af33d240f46e9b5240cc158edbc654efb37a464aa0f1ebbe9749b2fc6352127b4809b63af2341fac6240050c414e578ae99444ba5d
-DIST sqlglot-26.29.0.tar.gz 5335487 BLAKE2B 0d0475d3beb1df5d414cb627f6d37cc0ee116ca83262c3157c3e0608667f28a807e3d615c53aec392416f75eaed6ed679d570fb38e58aa7e354aefc1384d36f4 SHA512 f56f945b5dff7cf631eb3e26685d132e3dfd77ea4ea897ef75a6df1c0b23830f84cce0b85d780c86fedee54529f9ee04af0362a94c6a7b6b2d11a8ceb94abfd2
 DIST sqlglot-26.30.0-crates.tar.xz 8859792 BLAKE2B abb2051b392c53dc3caa705ddd8df7076819a26dcdaa89fa3760559a79578db01e86943c2d0ffb8006263c2dca3aa50d20023eae9d772f8ebd12a8a2d3266cdd SHA512 7cca439a06433a62bcd4a2af33d240f46e9b5240cc158edbc654efb37a464aa0f1ebbe9749b2fc6352127b4809b63af2341fac6240050c414e578ae99444ba5d
 DIST sqlglot-26.30.0.tar.gz 5339339 BLAKE2B 7b65105318653e2cbed6c7fea8ffa0112776e1919d22ae48f0e11daadb45f8aa5e9ff62c3333ef95a16fb7e6d01dea0f5e4a06e50a4435c85d06a006b893d324 SHA512 204cb4a0019e6b60c3a0bc04725311a8f02de38ca25a1aa3e2f9cbdeada3839cf5cde5b21db515c7ecb8630f3b771d7ef8a86c7e12ab024370e486363e4fb8c1
diff --git a/dev-python/sqlglot/sqlglot-26.29.0.ebuild b/dev-python/sqlglot/sqlglot-26.29.0.ebuild
deleted file mode 100644
index 84a615136142..000000000000
--- a/dev-python/sqlglot/sqlglot-26.29.0.ebuild
+++ /dev/null
@@ -1,178 +0,0 @@
-# Copyright 2023-2025 Gentoo Authors
-# Distributed under the terms of the GNU General Public License v2
-
-EAPI=8
-
-CRATES="
-	aho-corasick@1.1.3
-	anes@0.1.6
-	anstyle@1.0.10
-	autocfg@1.1.0
-	bumpalo@3.16.0
-	cast@0.3.0
-	cfg-if@1.0.0
-	ciborium-io@0.2.2
-	ciborium-ll@0.2.2
-	ciborium@0.2.2
-	clap@4.5.23
-	clap_builder@4.5.23
-	clap_lex@0.7.4
-	criterion-plot@0.5.0
-	criterion@0.5.1
-	crossbeam-deque@0.8.6
-	crossbeam-epoch@0.9.18
-	crossbeam-utils@0.8.21
-	crunchy@0.2.2
-	either@1.13.0
-	half@2.4.1
-	heck@0.5.0
-	hermit-abi@0.4.0
-	indoc@2.0.4
-	is-terminal@0.4.13
-	itertools@0.10.5
-	itoa@1.0.14
-	js-sys@0.3.76
-	libc@0.2.169
-	log@0.4.22
-	memchr@2.7.4
-	memoffset@0.9.0
-	num-traits@0.2.19
-	once_cell@1.19.0
-	oorandom@11.1.4
-	plotters-backend@0.3.7
-	plotters-svg@0.3.7
-	plotters@0.3.7
-	portable-atomic@1.9.0
-	proc-macro2@1.0.89
-	pyo3-build-config@0.25.0
-	pyo3-ffi@0.25.0
-	pyo3-macros-backend@0.25.0
-	pyo3-macros@0.25.0
-	pyo3@0.25.0
-	quote@1.0.37
-	rayon-core@1.12.1
-	rayon@1.10.0
-	regex-automata@0.4.9
-	regex-syntax@0.8.5
-	regex@1.11.1
-	rustc-hash@2.1.0
-	ryu@1.0.18
-	same-file@1.0.6
-	serde@1.0.216
-	serde_derive@1.0.216
-	serde_json@1.0.133
-	syn@2.0.87
-	target-lexicon@0.13.2
-	tinytemplate@1.2.1
-	unicode-ident@1.0.12
-	unindent@0.2.3
-	walkdir@2.5.0
-	wasm-bindgen-backend@0.2.99
-	wasm-bindgen-macro-support@0.2.99
-	wasm-bindgen-macro@0.2.99
-	wasm-bindgen-shared@0.2.99
-	wasm-bindgen@0.2.99
-	web-sys@0.3.76
-	winapi-util@0.1.9
-	windows-sys@0.52.0
-	windows-sys@0.59.0
-	windows-targets@0.52.6
-	windows_aarch64_gnullvm@0.52.6
-	windows_aarch64_msvc@0.52.6
-	windows_i686_gnu@0.52.6
-	windows_i686_gnullvm@0.52.6
-	windows_i686_msvc@0.52.6
-	windows_x86_64_gnu@0.52.6
-	windows_x86_64_gnullvm@0.52.6
-	windows_x86_64_msvc@0.52.6
-"
-
-CARGO_OPTIONAL=1
-DISTUTILS_EXT=1
-DISTUTILS_USE_PEP517=setuptools
-PYTHON_COMPAT=( python3_{9,10,11,12,13} )
-
-inherit cargo distutils-r1 pypi optfeature
-
-DESCRIPTION="An easily customizable SQL parser and transpiler"
-HOMEPAGE="
-	https://sqlglot.com/
-	https://github.com/tobymao/sqlglot/
-	https://pypi.org/project/sqlglot/
-"
-SRC_URI+="
-	native-extensions? (
-		https://github.com/gentoo-crate-dist/sqlglot/releases/download/v${PV}/${P}-crates.tar.xz
-	)
-"
-
-LICENSE="MIT"
-LICENSE+=" native-extensions? ("
-# Dependent crate licenses
-LICENSE+="
-	Apache-2.0 Apache-2.0-with-LLVM-exceptions MIT Unicode-DFS-2016
-"
-LICENSE+=" )"
-SLOT="0"
-KEYWORDS="~amd64 ~arm64 ~x86"
-IUSE="+native-extensions"
-
-BDEPEND="
-	native-extensions? (
-		${RUST_DEPEND}
-		dev-util/maturin[${PYTHON_USEDEP}]
-	)
-	test? (
-		dev-python/pytz[${PYTHON_USEDEP}]
-	)
-"
-
-distutils_enable_tests pytest
-
-QA_FLAGS_IGNORED="usr/lib.*/py.*/site-packages/sqlglotrs/sqlglotrs.*.so"
-
-pkg_setup() {
-	use native-extensions && rust_pkg_setup
-}
-
-src_unpack() {
-	cargo_src_unpack
-}
-
-python_compile() {
-	distutils-r1_python_compile
-
-	if use native-extensions; then
-		local DISTUTILS_USE_PEP517=maturin
-		local DISTUTILS_UPSTREAM_PEP517=maturin
-		cd sqlglotrs || die
-		distutils-r1_python_compile
-		cd - >/dev/null || die
-	fi
-}
-
-python_test() {
-	local EPYTEST_DESELECT=(
-		# timing, sigh
-		# https://github.com/tobymao/sqlglot/issues/3961
-		tests/test_generator.py::TestGenerator::test_generate_nested_binary
-	)
-	local EPYTEST_IGNORE=(
-		# Tests require pyspark or duckdb which aren't in the tree.
-		# Pandas would be a requirement normally, but it gets ignored by proxy.
-		"tests/dataframe/integration/test_dataframe.py"
-		"tests/dataframe/integration/test_grouped_data.py"
-		"tests/dataframe/integration/test_session.py"
-		"tests/test_executor.py"
-		"tests/test_optimizer.py"
-	)
-
-	# make sure not to use an earlier installed version
-	local -x SQLGLOTRS_TOKENIZER=$(usex native-extensions 1 0)
-	rm -rf sqlglotrs || die
-	epytest
-}
-
-pkg_postinst() {
-	optfeature "simplifying timedelta expressions" dev-python/python-dateutil
-}