Adding metadata

32 files changed, 792 insertions, 16 deletions

diff --git a/dev-python/boto3/Manifest b/dev-python/boto3/Manifest
index 6c2eaa8a6228..c068edd7d4c0 100644
--- a/dev-python/boto3/Manifest
+++ b/dev-python/boto3/Manifest
@@ -3,4 +3,5 @@ DIST boto3-1.37.18.gh.tar.gz 916523 BLAKE2B ddce395151b08982cd62156dcb994a496691
 DIST boto3-1.37.19.gh.tar.gz 917195 BLAKE2B e927a0742f4b73a35749f2fc6e7eb4e96b61da20660000c6e83bf30fe1f47a417934ee0c3ff3bb3b90cf4f2d93cbc0dc56fb0258162f205b13b024e7d4aa1507 SHA512 acefcda7093d30aedf6b58d2091fb82f4c67f0f229d2242627c7c853457e6639e1be568d3858e06d0e5167a042052307c79940f3a9b25b07d0466f1ec96c49c0
 DIST boto3-1.37.20.gh.tar.gz 917858 BLAKE2B 3325088a4689fe764bc7dd4eb68afccf7e05a1b29152c5dc28224ad132e2eadfbd5af2545fb9e456e26e5396aff40ec9ee00e35382618b3fdf14da5fa91f2273 SHA512 4b271e2caa15effe0e3f17161b601fdfa0e29e89d219c21fe3116c35ef485344eff4a944374d4aed2ee557ca3e5d55e0317c2a013205cfa095fb46b19adfc976
 DIST boto3-1.37.21.gh.tar.gz 918526 BLAKE2B eb7ed9411680d46c02050a6dda80dff932023a23d56207527e5de1063c1d76bebd11f559b8ba34ce5d490799024f827a2bf4041a2629eab9780b18f6e7dbd882 SHA512 7de17ab58434a07f2ab43c29876fd34a2d413aaedc03369dcaff98ec436e460881e0405285516a77b113ae437698c3d4971c9b129ba5801e5636abd26a2db05b
+DIST boto3-1.37.22.gh.tar.gz 919362 BLAKE2B f36e850e4b7089325f32c41ef1d60373fbdfbf35d1d56b9236f8eae10e665474d5612c3567e58a28ef5f9164c31286b5cd86ecb9b545e34e63dd4a7119203f0e SHA512 829f7b6446746efc688828e5c6264b380f5e550b9bad85c4a572c56b4030766a049ace67f0d979f0afe1dca01cbbb9174d1e60fe9d24e8179a1c699d0ab42936
 DIST boto3-1.37.9.gh.tar.gz 911836 BLAKE2B d190525b9c5e39b445042aba6d8e57da5e49165775901ceebe44b76fd2780ec85a2f5a8a08d3a9a5e451d42bbae19b679e565a7a9acc663258ea0b7909a9a798 SHA512 12cba48d5f2c158b372eaf4e44903e22ca963e5712c3c463fbfd20626a771efe30530852b6c9ab70132a26472ff1b4656095675a5de37524f6b489c25175f8fe
diff --git a/dev-python/boto3/boto3-1.37.22.ebuild b/dev-python/boto3/boto3-1.37.22.ebuild
new file mode 100644
index 000000000000..dfe05b3d9a81
--- /dev/null
+++ b/dev-python/boto3/boto3-1.37.22.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_{9,10,11,12,13} )
+
+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.11.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 cc31db59aec9..ef437758c8eb 100644
--- a/dev-python/botocore/Manifest
+++ b/dev-python/botocore/Manifest
@@ -3,4 +3,5 @@ DIST botocore-1.37.18.gh.tar.gz 14386605 BLAKE2B 541cfccf5251a7534751a48de2e1c4d
 DIST botocore-1.37.19.gh.tar.gz 14389031 BLAKE2B 6ba7ae5ad3effdb74b08d7fdf6b25b12f8bf93fd2aa61aa6f1b1bd45aa102018e53b8e45681282e04c00d22165e48358d4dee7d91d7eebba2b5b48590abc3015 SHA512 34a74dfc0df915416d045a659b54f4f1d67f1164aea86e62170606e07de2febf447b4d9ff605c9eb14dcd31af4e7cf9dbc88b4fd931ba7bbee8c530785cb6aa9
 DIST botocore-1.37.20.gh.tar.gz 14391159 BLAKE2B 918d42d3809d64d0d428334b2a6bd5d66ec710c3f03d67d453112fb961d2097cc7066c1f9a26bb0123af753db180693708ea04872694b37e2ce11314beb3845f SHA512 b6503a276881c86c17653130b4183c2baeeb0861e74d5621e8f3d0b6faa240e2e7c33e7b3209141d8fb4b6666fded16c09e233935983a12bf3f86619cebb6574
 DIST botocore-1.37.21.gh.tar.gz 14395519 BLAKE2B 7c90142d0441b366c43c63816bfbc688d0de833b3d85ce90c3939c75169626334f7c22bb7901e89175a65d5b837265f8c96025075be53ea2eb16517f455abbca SHA512 4db89d6e0c78736936391c7a94e6424664742b812719533dd402faa02dd58ba9b7ae9fd1e53629e631fb3b60640d4ddef9cbb3aeb90392afa5f79d18b1c0f33a
+DIST botocore-1.37.22.gh.tar.gz 14402437 BLAKE2B 4519e3f3ca1c42b2e0445d98d7afd669a02009cdc34b4e3a83e801b508a1c8b6afb6b739bc168d543260e24468436395f0dc469d2e1e687f8821ed12f916e04e SHA512 15b8adbe57f73179df7cb19cb8940d6ca9510c3b4716899a3fb448271e7d15b1640b64e51d5db62d4ab0a194d4900acb9f99e40f6980e3918531c350b6bfa244
 DIST botocore-1.37.9.gh.tar.gz 14346488 BLAKE2B 29ac550ad462ab7c83bad7989588ec62fb57959586a8ec91be9756d90712ad86e3dfd813a347e619b7cac3fd7afb56affcd81926e15d91b8d0ceae2cd4436a8d SHA512 e191c9485e95188049c02020fcb32c4429de6cfd78f237a2026200b7240890d5759f5cdd96166cd2aec035dac82d32db155fe00d9ec6be482c655cfdb44265f9
diff --git a/dev-python/botocore/botocore-1.37.22.ebuild b/dev-python/botocore/botocore-1.37.22.ebuild
new file mode 100644
index 000000000000..df85ee0d220c
--- /dev/null
+++ b/dev-python/botocore/botocore-1.37.22.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_{9,10,11,12,13} )
+
+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/colored-traceback/colored-traceback-0.4.2.ebuild b/dev-python/colored-traceback/colored-traceback-0.4.2.ebuild
index 796c9d5baaa4..7950547b8956 100644
--- a/dev-python/colored-traceback/colored-traceback-0.4.2.ebuild
+++ b/dev-python/colored-traceback/colored-traceback-0.4.2.ebuild
@@ -1,4 +1,4 @@
-# Copyright 1999-2024 Gentoo Authors
+# Copyright 1999-2025 Gentoo Authors
 # Distributed under the terms of the GNU General Public License v2
 
 EAPI=8
@@ -17,7 +17,7 @@ HOMEPAGE="
 
 LICENSE="ISC"
 SLOT="0"
-KEYWORDS="amd64 ~arm64 ~riscv x86"
+KEYWORDS="amd64 arm64 ~riscv x86"
 
 RDEPEND="
 	dev-python/pygments[${PYTHON_USEDEP}]
diff --git a/dev-python/griffe/Manifest b/dev-python/griffe/Manifest
index 431af65a02ed..bdd20940f2ba 100644
--- a/dev-python/griffe/Manifest
+++ b/dev-python/griffe/Manifest
@@ -1,2 +1,2 @@
-DIST griffe-1.6.2.gh.tar.gz 394448 BLAKE2B 4a3b6d8bb2443fd9a03589167eb6fd1db7ecb0a52b8e3fa3003aebaddfbf402a65cc3111a1b975606da1984044029a46df7c9eb0105eea998534c5bb7fce3efb SHA512 a8afd98d309a2cdbb12e6e83e00fc0a151ab287a15b69a16c86ed16020f66c60e249a5860960365f6605c3a284b69b9b8aba56b53376d1a097ab61006ed1402e
 DIST griffe-1.6.3.gh.tar.gz 395341 BLAKE2B c2beca0377d6d4a43a9a833142d1750d10fb4584c451cc7c9758275bfb58e6078634e79a204794b3b360d7afff0b37d68fb12d2f845ae846a6aa97ccb696538d SHA512 7b9197854ea8262bbcfa14fcd18dfb10e6bde253b92b7e88fc199f49f73d76f3641a6d3df8e383b4b1e2736a35f204eafe520347f00fd0f3c4f7bfd9a56d1e3e
+DIST griffe-1.7.0.gh.tar.gz 397619 BLAKE2B ecd2b490ec4fa37e5ac4bc0ac509145093245345af81a933d9b1e763c94e3fe0e6fdcd8a8d73f276c6740a1dd5397eedaa647efee6c01bab7e55b914cc43e1fd SHA512 c69d7ddbd5641f8cc1c0b920349488dcf1f61109d3437a4658ae1379ee80cabf02073c0c25a41ba1ef5a627a8c27fd42bd6339931af043ce866ab096d064ffb2
diff --git a/dev-python/griffe/griffe-1.6.2.ebuild b/dev-python/griffe/griffe-1.7.0.ebuild
index 6f7090dd3f3d..6f7090dd3f3d 100644
--- a/dev-python/griffe/griffe-1.6.2.ebuild
+++ b/dev-python/griffe/griffe-1.7.0.ebuild
diff --git a/dev-python/icalendar/Manifest b/dev-python/icalendar/Manifest
index 8473695d82d2..58bcfb1a6d4f 100644
--- a/dev-python/icalendar/Manifest
+++ b/dev-python/icalendar/Manifest
@@ -1,2 +1,3 @@
 DIST icalendar-6.1.1.tar.gz 145256 BLAKE2B cf3cf5a79f25f6c2820e4a04fc02a1546949e99c4e3fa9e6a204b0e4eb13e475b0c5a1f3179009b77437a33ab360b561cdff59453bcd77b771fc223ad14a2494 SHA512 3afb10dcfd07d0348bb404e2bfef3b790e312764bed1147999a3322255d7c881a1513077b49b3ed6cfc03a22afa81a3211823d94a2414b00bc2c4503bed73264
 DIST icalendar-6.1.2.tar.gz 151266 BLAKE2B 3f6fd1074f48f9e7fbd6b91b1fc73c592752fe8d6885c460ac9278e715a7812022a606f89d32eaf67f214ae35641677330e8ee9b0f7106946c6c3872a875343a SHA512 6dfb0480894f107abe6d676c8addf437c114088491e55d253334bdda9b37c758c4d7943e98a16196b2f8811e67aef81f527d57b78fe86a279b76b7f5c8c91e6f
+DIST icalendar-6.1.3.tar.gz 152131 BLAKE2B f1315537dee85282073d4b67b06fbb823ba6642247449e950243d44fc8c8e3147c703095b1370bec9458a1fa0d01b5e1bb0f4cdc04ffb4b721100a8d68eb5ba1 SHA512 aa0e92c0fcf6a394cca608391defd67616752b12984b5848eb56b89337537e3761fdbfc731838db2c565603ddcc845b034c4592b3be736d68c6f435726ed2977
diff --git a/dev-python/icalendar/icalendar-6.1.3.ebuild b/dev-python/icalendar/icalendar-6.1.3.ebuild
new file mode 100644
index 000000000000..80bc32b6783b
--- /dev/null
+++ b/dev-python/icalendar/icalendar-6.1.3.ebuild
@@ -0,0 +1,48 @@
+# Copyright 1999-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="Package used for parsing and generating iCalendar files (RFC 2445)"
+HOMEPAGE="
+	https://github.com/collective/icalendar/
+	https://pypi.org/project/icalendar/
+"
+
+LICENSE="BSD-2"
+SLOT="0"
+KEYWORDS="~amd64 ~arm ~arm64 ~riscv ~x86"
+
+RDEPEND="
+	dev-python/python-dateutil[${PYTHON_USEDEP}]
+	dev-python/tzdata[${PYTHON_USEDEP}]
+"
+BDEPEND="
+	dev-python/hatch-vcs[${PYTHON_USEDEP}]
+	test? (
+		dev-python/hypothesis[${PYTHON_USEDEP}]
+		dev-python/pytz[${PYTHON_USEDEP}]
+	)
+"
+
+distutils_enable_sphinx docs \
+	dev-python/sphinx-copybutton \
+	dev-python/sphinx-rtd-theme
+distutils_enable_tests pytest
+
+python_prepare_all() {
+	# reset conf.py to not read version from an installed instance
+	sed -e "s:pkg_resources.get_distribution('icalendar').version:'${PV}':" \
+		-i docs/conf.py || die
+	distutils-r1_python_prepare_all
+}
+
+python_test() {
+	local -x PYTEST_DISABLE_PLUGIN_AUTOLOAD=1
+	epytest
+}
diff --git a/dev-python/langdetect/Manifest b/dev-python/langdetect/Manifest
index 37a64204a00a..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 9b3521c5721afa49a58e0c35267f7d82bb56bd7e1d6d3152be0d36cd220180a526cb20b90b1113fbf0fff4a512137570f0b3bcf864498b7b7cc00403cb61ca27 SHA512 16d311400bf84a5f04e15f3da4b68b2810e4b005009f4d03dc8a487176dfc294403c976c412c83dcfa8084a49ef7b7d5389b43fb2ba446ce107ce4595e3558c6
-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..eb2586280d80 100644
--- a/dev-python/langdetect/langdetect-1.0.9.ebuild
+++ b/dev-python/langdetect/langdetect-1.0.9.ebuild
@@ -1,4 +1,4 @@
-# Copyright 2022 Gentoo Authors
+# Copyright 2022-2024 Gentoo Authors
 # Distributed under the terms of the GNU General Public License v2
 
 EAPI=8
@@ -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/nanobind/Manifest b/dev-python/nanobind/Manifest
index 924b72796b53..0cd74d787a5a 100644
--- a/dev-python/nanobind/Manifest
+++ b/dev-python/nanobind/Manifest
@@ -1 +1,2 @@
 DIST nanobind-2.5.0.gh.tar.gz 900479 BLAKE2B 9711cde535b6e6717477229f25e2f8abc5d1973ccd307ad1d55613ac0b288815960ece8b279a4dded47dc90e86ad4d44b216e27012120fcc7ffc26ef7711e800 SHA512 885668ee4ea9c551ccd60d2e056a90021badfeb7b358aeace184a23f9c2d34cb31a81ebe84db33fd6f15b7983dbb455d9c11f9367de091cb9b56c99d7634f9a0
+DIST nanobind-2.6.0.gh.tar.gz 905010 BLAKE2B 0d763035653fb3375a5424d875153ffd5ed33c839fe800f639866d9aeee8459a79f1472e7c724271b724bda5ce73fbd5d0327d7331110968abf5e9de030ad6ed SHA512 f8429a5f3e6e84a6ab1890086078e2f313bbf0c77c35ade3aab5d14f9d65dba36cf8ccca16c9add0d12894d085ce445bfda519a28e23bdbc359c977b185efdd5
diff --git a/dev-python/nanobind/nanobind-2.6.0.ebuild b/dev-python/nanobind/nanobind-2.6.0.ebuild
new file mode 100644
index 000000000000..0f7ceddc919f
--- /dev/null
+++ b/dev-python/nanobind/nanobind-2.6.0.ebuild
@@ -0,0 +1,70 @@
+# Copyright 1999-2025 Gentoo Authors
+# Distributed under the terms of the GNU General Public License v2
+
+EAPI=8
+
+DISTUTILS_USE_PEP517=scikit-build-core
+PYTHON_COMPAT=( python3_{9,10,11,12,13} )
+
+inherit cmake distutils-r1
+
+DESCRIPTION="Tiny and efficient C++/Python bindings"
+HOMEPAGE="
+	https://github.com/wjakob/nanobind/
+	https://pypi.org/project/nanobind/
+"
+SRC_URI="
+	https://github.com/wjakob/nanobind/archive/refs/tags/v${PV}.tar.gz
+		-> ${P}.gh.tar.gz
+"
+
+LICENSE="BSD"
+SLOT="0"
+KEYWORDS="~amd64 ~ppc64 ~riscv"
+
+DEPEND="
+	>=dev-cpp/robin-map-1.3.0
+"
+RDEPEND="
+	${DEPEND}
+"
+BDEPEND="
+	$(python_gen_cond_dep '
+		dev-python/typing-extensions[${PYTHON_USEDEP}]
+	' 3.10)
+"
+
+EPYTEST_XDIST=1
+distutils_enable_tests pytest
+
+src_prepare() {
+	# https://github.com/scikit-build/scikit-build-core/issues/912
+	sed -i -e '/scikit-build-core/s:0\.10:0.8:' pyproject.toml || die
+	cmake_src_prepare
+	distutils-r1_src_prepare
+}
+
+src_configure() {
+	# XXX: nanobind installs a CMake config file which by default passes -Os
+	# We currently patch around it in dev-python/pyopencl. In future, we
+	# may want to add some override with Gentoo specific environment vars.
+	DISTUTILS_ARGS=(
+		-DNB_CREATE_INSTALL_RULES=ON
+		-DNB_USE_SUBMODULE_DEPS=OFF
+		-DNB_TEST=OFF
+	)
+}
+
+python_test() {
+	local mycmakeargs=(
+		-DNB_CREATE_INSTALL_RULES=OFF
+		-DNB_USE_SUBMODULE_DEPS=OFF
+		-DNB_TEST=ON
+	)
+	cmake_src_configure
+	cmake_src_compile
+
+	local -x PYTEST_DISABLE_PLUGIN_AUTOLOAD=1
+	cd "${BUILD_DIR}/tests" || die
+	epytest
+}
diff --git a/dev-python/pyasn1-modules/Manifest b/dev-python/pyasn1-modules/Manifest
index 916ea58dc608..f14d5ce73b59 100644
--- a/dev-python/pyasn1-modules/Manifest
+++ b/dev-python/pyasn1-modules/Manifest
@@ -1 +1,2 @@
 DIST pyasn1_modules-0.4.1.tar.gz 310028 BLAKE2B dcffd13196982fb9f4808a789252b9c9910bff3c3eb3e852d13cf1e1285bac4f2900dc62698d9929da4ff882e5d823f2e5290fecd1488e5b61d04c62fe24e2ec SHA512 d3716cafbfe940c5415cb59073897cd15d69b9723064ba581b7d573fe9a0fad9872d88517fe03b0db5b4fa93f8cd3254372e71d60ff5975013c97409b6c22d1d
+DIST pyasn1_modules-0.4.2.tar.gz 307892 BLAKE2B 93f980bc8c894526568fa3898a60d496669d71aa4a1d857287ed49fa418ff6c7932464b346b44feaf61f8e750132bcbee47159a9ec559a1c2328b5453c84ed33 SHA512 2128b6c45132a639894dc69413613bd0ab20ba7f929f1a0b190686a607c254315d320782c1527b7c3cc1f6cb30a18dd1bc864a29576d2fd7c6bf348966321dd5
diff --git a/dev-python/pyasn1-modules/pyasn1-modules-0.4.2.ebuild b/dev-python/pyasn1-modules/pyasn1-modules-0.4.2.ebuild
new file mode 100644
index 000000000000..2bbf8da69585
--- /dev/null
+++ b/dev-python/pyasn1-modules/pyasn1-modules-0.4.2.ebuild
@@ -0,0 +1,32 @@
+# 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 pypi
+
+DESCRIPTION="pyasn1 modules"
+HOMEPAGE="
+	https://pypi.org/project/pyasn1-modules/
+	https://github.com/pyasn1/pyasn1-modules/
+"
+
+LICENSE="BSD-2"
+SLOT="0"
+KEYWORDS="~alpha ~amd64 ~arm ~arm64 ~hppa ~loong ~m68k ~mips ~ppc ~ppc64 ~riscv ~s390 ~sparc ~x86 ~amd64-linux ~x86-linux ~x64-macos"
+
+RDEPEND="
+	<dev-python/pyasn1-0.7.0[${PYTHON_USEDEP}]
+	>=dev-python/pyasn1-0.6.1[${PYTHON_USEDEP}]
+"
+
+distutils_enable_tests unittest
+
+python_install_all() {
+	distutils-r1_python_install_all
+	insinto /usr/share/${P}
+	doins -r tools
+}
diff --git a/dev-python/pydantic/Manifest b/dev-python/pydantic/Manifest
index efe626fbaebf..b5f90e3602d2 100644
--- a/dev-python/pydantic/Manifest
+++ b/dev-python/pydantic/Manifest
@@ -1,2 +1,3 @@
 DIST pydantic-2.10.6.tar.gz 761681 BLAKE2B 1ddb057cd40f50d09dc870aae937bc4d5d41529601c26b84bbd5223d75adca43e14e779ef40ef88dbeab3dc66ae960b662a3244ffa38bf8718d6f9d50b966aed SHA512 69c5cdfb9047875497cf2ac0107f0aaa8d1d91a354d514277e913cc13081e1a76f72a154b50339c95240c82d2a262f4b8dcf71c1e5762449bd344054dba449ce
+DIST pydantic-2.11.0.tar.gz 782184 BLAKE2B 44c0e4ee4ef99ffaa285b38c3876d4e36a587b527df988013e0390150d3e9e667ffcb35fe6a56db13cdb7518416ecf99371f653630481020f94ca0edb8b8e110 SHA512 9447508502a5530c28701af47b17f074e068ee69496b3f4b63e3e3d224a1cb22220429077c225ba6e5ffe3b8e0373c9a390182ac786f724013545a823f4abc74
 DIST pydantic-2.11.0b2.tar.gz 776762 BLAKE2B 6632a96d46b71519527bacffe99e07c0a548b03bfda1980dbab005bf7bc2169b89140ba894eb1fab1216b5ad9155ade13ded32606ed5a781549c59da949db6ea SHA512 8bcdf95a1a90a4b7b7c42e338f16ee3268e2bdf5d7c1c72df6ab81db82a79a273c858103068cfc13a3728b1f3c720faf4118e6ae2a4fd762f12eb7dea36b7d5f
diff --git a/dev-python/pydantic/pydantic-2.11.0.ebuild b/dev-python/pydantic/pydantic-2.11.0.ebuild
new file mode 100644
index 000000000000..81a134dde895
--- /dev/null
+++ b/dev-python/pydantic/pydantic-2.11.0.ebuild
@@ -0,0 +1,71 @@
+# Copyright 1999-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} pypy3 )
+
+inherit distutils-r1 pypi
+
+DESCRIPTION="Data parsing and validation using Python type hints"
+HOMEPAGE="
+	https://github.com/pydantic/pydantic/
+	https://pypi.org/project/pydantic/
+"
+
+LICENSE="MIT"
+SLOT="0"
+KEYWORDS="~amd64 ~arm ~arm64 ~loong ~ppc ~ppc64 ~riscv ~s390 ~sparc ~x86"
+
+RDEPEND="
+	>=dev-python/annotated-types-0.6.0[${PYTHON_USEDEP}]
+	~dev-python/pydantic-core-2.33.0[${PYTHON_USEDEP}]
+	>=dev-python/typing-extensions-4.12.2[${PYTHON_USEDEP}]
+	>=dev-python/typing-inspection-0.4.0[${PYTHON_USEDEP}]
+	dev-python/tzdata[${PYTHON_USEDEP}]
+"
+BDEPEND="
+	>=dev-python/hatch-fancy-pypi-readme-22.5.0[${PYTHON_USEDEP}]
+	test? (
+		$(python_gen_cond_dep '
+			dev-python/cloudpickle[${PYTHON_USEDEP}]
+		' 'python3*' pypy3)
+		dev-python/dirty-equals[${PYTHON_USEDEP}]
+		>=dev-python/email-validator-2.0.0[${PYTHON_USEDEP}]
+		>=dev-python/faker-18.13.0[${PYTHON_USEDEP}]
+		>=dev-python/jsonschema-4.23.0[${PYTHON_USEDEP}]
+		dev-python/pytest-mock[${PYTHON_USEDEP}]
+		dev-python/pytz[${PYTHON_USEDEP}]
+		dev-python/rich[${PYTHON_USEDEP}]
+	)
+"
+
+distutils_enable_tests pytest
+
+src_prepare() {
+	sed -i -e '/benchmark/d' pyproject.toml || die
+	distutils-r1_src_prepare
+}
+
+python_test() {
+	local EPYTEST_DESELECT=(
+		# -Werror, sigh
+		tests/test_types_typeddict.py::test_readonly_qualifier_warning
+	)
+	local EPYTEST_IGNORE=(
+		# require pytest-examples
+		tests/test_docs.py
+		# benchmarks
+		tests/benchmarks
+	)
+
+	if ! has_version "dev-python/cloudpickle[${PYTHON_USEDEP}]"; then
+		EPYTEST_IGNORE+=(
+			tests/test_pickle.py
+		)
+	fi
+
+	local -x PYTEST_DISABLE_PLUGIN_AUTOLOAD=1
+	epytest -p pytest_mock
+}
diff --git a/dev-python/pydub/pydub-0.25.1.ebuild b/dev-python/pydub/pydub-0.25.1.ebuild
index 3e492b36a634..1c339d268ebc 100644
--- a/dev-python/pydub/pydub-0.25.1.ebuild
+++ b/dev-python/pydub/pydub-0.25.1.ebuild
@@ -1,4 +1,4 @@
-# Copyright 2022 Gentoo Authors
+# Copyright 2022-2025 Gentoo Authors
 # Distributed under the terms of the GNU General Public License v2
 
 EAPI=8
@@ -18,7 +18,7 @@ KEYWORDS="~amd64"
 
 BDEPEND="
 	test? (
-		media-video/ffmpeg[mp3,vorbis]
+		media-video/ffmpeg[lame,vorbis]
 	)
 	"
 
diff --git a/dev-python/pytools/Manifest b/dev-python/pytools/Manifest
index e0d613c41a37..bbb6e5db7b60 100644
--- a/dev-python/pytools/Manifest
+++ b/dev-python/pytools/Manifest
@@ -1,2 +1,3 @@
 DIST pytools-2024.1.6.tar.gz 81344 BLAKE2B ff68e2606170bf54e3f609ee7f4cfe58e063f43dcfb2706d5ed7659ea2fde863e6315d0d81dff2e62a3378f195413561a927b0c1e7bedc06388cf4893c07b873 SHA512 a9e934f1cbaf0ace32420f9b74224a06ce8421ee291b837292133969c6788c4cc8bea01446cd4d1505aca9fa81e8ae0d3eacf60d3285186e66d67d5abe10ce3e
 DIST pytools-2025.1.1.tar.gz 80186 BLAKE2B c5886b1bb3d3c18ff14bd6ccb298a73e1c84d5149e3644eee5fb7d0aa9a19608397686b444544639814a1d64e9b86d64ca56db9b1fa93911b2ebc03b630e50a3 SHA512 6c04a6a11e2797f0506963a3d2a71970af44863517ff237c68c705e94e4efe059ee08548fe9dfed6d3eab9b9fdb6b68596b8d26c943b0c5fe95543270f3e82ca
+DIST pytools-2025.1.2.tar.gz 80400 BLAKE2B e07379f1c954ece6d9b2e5c7db5a84758d5d85a5955990cf730a135bc961321132c36c7e1402c4684d50957069f839bb732bda849f3d46513ddb5533b9a88b88 SHA512 74fc858aed5043cab9aa2210f071aa3aaf60008ec60b63133dac870ff257981284f66b40ccbedfdcf68969b1e1476cb012dbf83fa9397bb1b857ae5db09f99f6
diff --git a/dev-python/pytools/pytools-2025.1.2.ebuild b/dev-python/pytools/pytools-2025.1.2.ebuild
new file mode 100644
index 000000000000..b65b2ff280d5
--- /dev/null
+++ b/dev-python/pytools/pytools-2025.1.2.ebuild
@@ -0,0 +1,31 @@
+# Copyright 1999-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} )
+PYTHON_REQ_USE='sqlite'
+
+inherit distutils-r1 pypi
+
+DESCRIPTION="Collection of tools missing from the Python standard library"
+HOMEPAGE="
+	https://mathema.tician.de/software/pytools/
+	https://github.com/inducer/pytools/
+	https://pypi.org/project/pytools/
+"
+
+LICENSE="MIT"
+SLOT="0"
+KEYWORDS="~amd64 ~arm64 ~riscv"
+
+# NB: numpy & siphash24 are an "extra" (optional) deps
+RDEPEND="
+	>=dev-python/numpy-1.6[${PYTHON_USEDEP}]
+	>=dev-python/platformdirs-2.2[${PYTHON_USEDEP}]
+	>=dev-python/siphash24-1.6[${PYTHON_USEDEP}]
+	>=dev-python/typing-extensions-4.5[${PYTHON_USEDEP}]
+"
+
+distutils_enable_tests pytest
diff --git a/dev-python/sqlalchemy/Manifest b/dev-python/sqlalchemy/Manifest
index a2244df12ee7..be55fe031926 100644
--- a/dev-python/sqlalchemy/Manifest
+++ b/dev-python/sqlalchemy/Manifest
@@ -1,3 +1,4 @@
 DIST sqlalchemy-1.4.54.tar.gz 8470350 BLAKE2B 0d97beb4edde38455c03dfc1238655d1cb63aa6e042b941913ec68dca3654de07087ab967f208fda495f048a5068ced70d642c4b8b80ab32e5346fcefa3bf9bc SHA512 e7ea4920d81914d362134a3c6fd4a2dd4fdb75f6ce17358528d568e2b2ac0ee711a71f6beb894e61d6d1e4e5833034ebde651d73a13f873c682f780e1831b427
 DIST sqlalchemy-2.0.38.tar.gz 9634782 BLAKE2B c1fa85895e3c39cf3abd28ebddec9cd6e764eeafa35b1e86a11836504552b9602d7d3582d0eb0f10ed3481501e56a068e6d563c399b22bf756465a6d5255ab23 SHA512 244df15b30a2d585aa9cb1d89b7460b1e75871a5e41579a23743bbfe40ece9c5c24308e317ccb7686ba7599a2e02a61f61077da6e1ab8567e4e31d61d4d77380
 DIST sqlalchemy-2.0.39.tar.gz 9644602 BLAKE2B 42dcad5ca88fd1f4b1194759aa98dc4a3ac28f6cf9d8edb21ce6a77051c45c6579b3184d0832f6a33b40157483a72f67c92feab6f2fa1b7087e7fc950a6233a2 SHA512 42d23acb4d98f03dde97d9d1e43387fc6bd331ee54a6503a2b4b047aab38d24ccb905ea6a7026619e36782c631e54287011f6daf360e7f5c69a00c395e15f149
+DIST sqlalchemy-2.0.40.tar.gz 9664299 BLAKE2B b053b502532d31470e0ceaf1ebe7494d988eb8d74b433d45f9037d2b982355bda4aba9defe681d219cc03ba8e040c6641a749d7a291f03ceb64edb2dc4a02e63 SHA512 7a1db1d61cd80283e339ef92b7e27146ea060db8dc7028b2584df9f9f68a4887bbb2a6b4b4af5ca66c7d132659c7a2d0b47ac2d25ce84fad73ee2dae7808e122
diff --git a/dev-python/sqlalchemy/sqlalchemy-2.0.40.ebuild b/dev-python/sqlalchemy/sqlalchemy-2.0.40.ebuild
new file mode 100644
index 000000000000..f08809a40288
--- /dev/null
+++ b/dev-python/sqlalchemy/sqlalchemy-2.0.40.ebuild
@@ -0,0 +1,117 @@
+# 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
+PYPI_PN=SQLAlchemy
+PYTHON_COMPAT=( python3_{9,10,11,12,13} pypy3 )
+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 ~amd64-linux ~x86-linux ~ppc-macos ~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)
+		dev-python/pytest-rerunfailures[${PYTHON_USEDEP}]
+	)
+"
+
+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
+	)
+	local sqlite_version=$(sqlite3 --version | cut -d' ' -f1)
+	case ${EPYTHON} in
+		pypy3.11)
+			EPYTEST_DESELECT+=(
+				# 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"
+			)
+			;&
+		pypy3)
+			EPYTEST_DESELECT+=(
+				test/ext/test_associationproxy.py::ProxyHybridTest::test_msg_fails_on_cls_access
+				test/ext/test_associationproxy.py::DictOfTupleUpdateTest::test_update_multi_elem_varg
+				test/ext/test_associationproxy.py::DictOfTupleUpdateTest::test_update_one_elem_varg
+				test/engine/test_processors.py::PyDateProcessorTest::test_date_invalid_string
+				test/engine/test_processors.py::PyDateProcessorTest::test_datetime_invalid_string
+				test/engine/test_processors.py::PyDateProcessorTest::test_time_invalid_string
+				"test/dialect/test_sqlite.py::TestTypes_sqlite+pysqlite_${sqlite_version//./_}::test_cant_parse_datetime_message"
+				"test/dialect/test_suite.py::ReturningGuardsTest_sqlite+pysqlite_${sqlite_version//./_}"::test_{delete,insert,update}_single
+				test/base/test_utils.py::ImmutableDictTest::test_pep584
+				'test/sql/test_compare.py::HasCacheKeySubclass::test_init_args_in_traversal[_MemoizedSelectEntities]'
+			)
+			;;
+	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
+	local -x PYTEST_DISABLE_PLUGIN_AUTOLOAD=1
+	epytest -p rerunfailures --reruns=10 --reruns-delay=2
+}
+
+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
+}
diff --git a/dev-python/sqlglot/Manifest b/dev-python/sqlglot/Manifest
index fdbccdb23c5b..75683d056088 100644
--- a/dev-python/sqlglot/Manifest
+++ b/dev-python/sqlglot/Manifest
@@ -2,3 +2,5 @@ DIST sqlglot-26.10.1-crates.tar.xz 8327388 BLAKE2B 69213d11940f9d4e743b169ef831b
 DIST sqlglot-26.10.1.tar.gz 5334132 BLAKE2B 09050744362cd6096b761f97d67230e9908b88f074958b23c3c5eeae10adc5319a69134d68f41d5d181fea0e7d16aaaed224a6c786426da36a60fba5b6bbda16 SHA512 cee6ff027bbeb21d1a325f90f2d64f9d87bd221e2e5a1c0a9f11ddb3f11a898dc570b278be157ebd1050cb810338057bd6595fec322c97a98937c2c9ee008a09
 DIST sqlglot-26.11.1-crates.tar.xz 8327388 BLAKE2B 69213d11940f9d4e743b169ef831b8b52a771f012e247570cf0703580a14af435d4d033b4b3ddfca6f4022b741261a24f3b47e5137de644d863714006520f857 SHA512 5de0781c54265b369e5e46b7cfbcc04a3118aa8d1323bff14f2841c95d471f545c923eedb88dbbb81a910801c5a505ff37a25701af936c06cf55a1659cd8822e
 DIST sqlglot-26.11.1.tar.gz 5335079 BLAKE2B fad8c5cf7f9e4b092bdcb73d3ed476b9e9d8260db3fff6679d8b325529b2164cdc0ca6368f45f7e351ebd31062037e1c78c9070b84a8347caaa5968d1108a2be SHA512 b7db28026c5f28b6e23e3f517daed08158315acb5965975ecf8ce43cb3cdaeeda8799ca60606037197d09c23338d9f6a10c95a33212c1106576860b1b17974f7
+DIST sqlglot-26.12.0-crates.tar.xz 8327388 BLAKE2B 69213d11940f9d4e743b169ef831b8b52a771f012e247570cf0703580a14af435d4d033b4b3ddfca6f4022b741261a24f3b47e5137de644d863714006520f857 SHA512 5de0781c54265b369e5e46b7cfbcc04a3118aa8d1323bff14f2841c95d471f545c923eedb88dbbb81a910801c5a505ff37a25701af936c06cf55a1659cd8822e
+DIST sqlglot-26.12.0.tar.gz 5339903 BLAKE2B e09691ae560db4a078a60fe3bb5fa7ef98b9f186dc487ba9c3ad1dc5467a197a600f407f7aef5da8e1d04a0e196d63c3e3d48e4ca88b1c0d7188e8234804f816 SHA512 e5e7736ebf205393f4616906fe81e8e664e6364d6f5f1645ce5140b71170e46d184572b686433f5ee1882ddb410a0075f9022681881c10727f0e1dc212571a50
diff --git a/dev-python/sqlglot/sqlglot-26.12.0.ebuild b/dev-python/sqlglot/sqlglot-26.12.0.ebuild
new file mode 100644
index 000000000000..e6d6333f80ba
--- /dev/null
+++ b/dev-python/sqlglot/sqlglot-26.12.0.ebuild
@@ -0,0 +1,96 @@
+# Copyright 2023-2025 Gentoo Authors
+# Distributed under the terms of the GNU General Public License v2
+
+EAPI=8
+
+CRATES=" "
+
+DISTUTILS_EXT=1
+DISTUTILS_USE_PEP517=setuptools
+PYTHON_COMPAT=( python3_{9,10,11,12,13} )
+
+CARGO_OPTIONAL=1
+
+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
+		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
+}
diff --git a/dev-python/sshtunnel/files/sshtunnel-0.4.0-dont-deadlock-tests.patch b/dev-python/sshtunnel/files/sshtunnel-0.4.0-dont-deadlock-tests.patch
new file mode 100644
index 000000000000..1e5b06ac49b6
--- /dev/null
+++ b/dev-python/sshtunnel/files/sshtunnel-0.4.0-dont-deadlock-tests.patch
@@ -0,0 +1,38 @@
+From 96a056fb37684496c0495a831f8fd11b48ef01a9 Mon Sep 17 00:00:00 2001
+From: Alfred Wingate <parona@protonmail.com>
+Date: Sat, 22 Feb 2025 12:40:58 +0200
+Subject: [PATCH] Try to remove defunct threads from running_threads just in
+ case
+
+On Gentoo it was decided to remove server functionality from
+paramiko leading to the ssh-server to be dead before it could be
+properly removed from running_threads. This would lead to a hang where
+memory footprint of the process would grow with repeated "thread
+ssh-server now stopped" messages inevitably leading to an OOM condition.
+
+So try to remove defunct threads from running_threads after the fact to
+stop this problem from coming back and let it fail normally.
+
+Bug: https://github.com/pahaz/sshtunnel/issues/153
+Bug: https://bugs.gentoo.org/666619
+Bug: https://bugs.gentoo.org/683774
+Signed-off-by: Alfred Wingate <parona@protonmail.com>
+--- a/tests/test_forwarder.py
++++ b/tests/test_forwarder.py
+@@ -251,6 +251,13 @@ class SSHClientTest(unittest.TestCase):
+                                      who='tearDown')
+                 if not x.is_alive():
+                     self.log.info('thread {0} now stopped'.format(thread))
++                    # Try to remove thread running_threads just in case
++                    # the thread is dead but hasn't been properly removed.
++                    # https://github.com/pahaz/sshtunnel/issues/153
++                    try:
++                        self.running_threads.remove(thread)
++                    except ValueError:
++                        pass
+ 
+         for attr in ['server', 'tc', 'ts', 'socks', 'ssockl', 'esockl']:
+             if hasattr(self, attr):
+-- 
+2.49.0
+
diff --git a/dev-python/sshtunnel/sshtunnel-0.4.0.ebuild b/dev-python/sshtunnel/sshtunnel-0.4.0.ebuild
index da7e904151a1..3710ee8b88db 100644
--- a/dev-python/sshtunnel/sshtunnel-0.4.0.ebuild
+++ b/dev-python/sshtunnel/sshtunnel-0.4.0.ebuild
@@ -4,6 +4,7 @@
 EAPI=8
 
 DISTUTILS_USE_PEP517=setuptools
+EPYTEST_XDIST=1
 PYTHON_COMPAT=( python3_{9,10,11,12,13} )
 inherit distutils-r1 pypi
 
@@ -14,6 +15,21 @@ LICENSE="MIT"
 SLOT="0"
 KEYWORDS="amd64 ~arm ~arm64 x86"
 
-RESTRICT="test"
-
 RDEPEND="dev-python/paramiko[${PYTHON_USEDEP}]"
+BDEPEND="
+	test? (
+		dev-python/paramiko[server(+),${PYTHON_USEDEP}]
+		dev-python/mock[${PYTHON_USEDEP}]
+	)
+"
+
+PATCHES=(
+	"${FILESDIR}"/sshtunnel-0.4.0-dont-deadlock-tests.patch
+)
+
+distutils_enable_tests pytest
+
+EPYTEST_DESELECT=(
+	# network-sandbox
+	tests/test_forwarder.py::SSHClientTest::test_gateway_ip_unresolvable_raises_exception
+)
diff --git a/dev-python/tox/Manifest b/dev-python/tox/Manifest
index 37a29664dec4..66aca35297eb 100644
--- a/dev-python/tox/Manifest
+++ b/dev-python/tox/Manifest
@@ -1 +1,2 @@
 DIST tox-4.24.2.tar.gz 195354 BLAKE2B b4f1c49e719e169116888a3120a0690cb0208b257c15c4a0c6aa5d3340b4ee787e6af43f9c00c71358e3818732d99f40b8eb36afef369407040c82d1265d1b19 SHA512 864189ae85bb7bd8545de0b0e6e39b1a62248f51888ab829ac6bb5674646ac7c4a07a2500aa86ebc0f55ecd48c8e1d6811eae7dd4827bc9fee71d88e7d0df885
+DIST tox-4.25.0.tar.gz 196255 BLAKE2B 16d9e85270cad1e9909de8c51c906c8245201fc10c0dd48a37b202c3f4d381be183751e9aeac452c5f2bef8773bf8ad102be2b069e8ff545a1248f423664a863 SHA512 3560b667af03ca41c1bd8fa9eaa90f8c988b7f946498f3bc2d0a4dfa3a481d8ada27acb6201bde284a2bcfe14b86ee409a3ce8e875531423862d1af88e6248fb
diff --git a/dev-python/tox/tox-4.25.0.ebuild b/dev-python/tox/tox-4.25.0.ebuild
new file mode 100644
index 000000000000..e5b14a410c51
--- /dev/null
+++ b/dev-python/tox/tox-4.25.0.ebuild
@@ -0,0 +1,98 @@
+# Copyright 1999-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} pypy3 )
+
+inherit distutils-r1 pypi
+
+DESCRIPTION="virtualenv-based automation of test activities"
+HOMEPAGE="
+	https://tox.readthedocs.io/
+	https://github.com/tox-dev/tox/
+	https://pypi.org/project/tox/
+"
+
+LICENSE="MIT"
+SLOT="0"
+KEYWORDS="~alpha ~amd64 ~arm ~arm64 ~hppa ~loong ~mips ~ppc ~ppc64 ~riscv ~s390 ~sparc ~x86"
+
+RDEPEND="
+	dev-python/cachetools[${PYTHON_USEDEP}]
+	dev-python/chardet[${PYTHON_USEDEP}]
+	dev-python/colorama[${PYTHON_USEDEP}]
+	dev-python/filelock[${PYTHON_USEDEP}]
+	dev-python/packaging[${PYTHON_USEDEP}]
+	dev-python/platformdirs[${PYTHON_USEDEP}]
+	dev-python/pluggy[${PYTHON_USEDEP}]
+	dev-python/pyproject-api[${PYTHON_USEDEP}]
+	$(python_gen_cond_dep '
+		dev-python/tomli[${PYTHON_USEDEP}]
+		dev-python/typing-extensions[${PYTHON_USEDEP}]
+	' 3.10)
+	dev-python/virtualenv[${PYTHON_USEDEP}]
+"
+BDEPEND="
+	dev-python/hatch-vcs[${PYTHON_USEDEP}]
+	test? (
+		dev-python/build[${PYTHON_USEDEP}]
+		dev-python/distlib[${PYTHON_USEDEP}]
+		dev-python/flaky[${PYTHON_USEDEP}]
+		dev-python/psutil[${PYTHON_USEDEP}]
+		dev-python/pytest-mock[${PYTHON_USEDEP}]
+		dev-python/pytest-xdist[${PYTHON_USEDEP}]
+		dev-python/re-assert[${PYTHON_USEDEP}]
+		$(python_gen_cond_dep '
+			dev-python/time-machine[${PYTHON_USEDEP}]
+		' 'python*')
+	)
+"
+
+distutils_enable_tests pytest
+
+src_prepare() {
+	# upstream lower bounds are meaningless
+	sed -i -e 's:>=[0-9.]*::' pyproject.toml || die
+	distutils-r1_src_prepare
+}
+
+python_test() {
+	# devpi_process is not packaged, and has lots of dependencies
+	cat > "${T}"/devpi_process.py <<-EOF || die
+		def IndexServer(*args, **kwargs): raise NotImplementedError()
+	EOF
+
+	local -x PYTHONPATH=${T}:${PYTHONPATH}
+	local EPYTEST_DESELECT=(
+		# Internet
+		tests/tox_env/python/virtual_env/package/test_package_cmd_builder.py::test_build_wheel_external
+		tests/tox_env/python/virtual_env/package/test_package_cmd_builder.py::test_run_installpkg_targz
+	)
+	local EPYTEST_IGNORE=(
+		# requires devpi*
+		tests/test_provision.py
+	)
+
+	case ${EPYTHON} in
+		pypy3*)
+			EPYTEST_DESELECT+=(
+				'tests/tox_env/python/pip/test_pip_install.py::test_constrain_package_deps[explicit-True-True]'
+				'tests/tox_env/python/pip/test_pip_install.py::test_constrain_package_deps[requirements-True-True]'
+				'tests/tox_env/python/pip/test_pip_install.py::test_constrain_package_deps[constraints-True-True]'
+				'tests/tox_env/python/pip/test_pip_install.py::test_constrain_package_deps[explicit+requirements-True-True]'
+				'tests/tox_env/python/pip/test_pip_install.py::test_constrain_package_deps[requirements_indirect-True-True]'
+				'tests/tox_env/python/pip/test_pip_install.py::test_constrain_package_deps[requirements_constraints_indirect-True-True]'
+			)
+			;;
+		python3.13)
+			EPYTEST_DESELECT+=(
+				# https://github.com/tox-dev/tox/issues/3290
+				'tests/config/loader/test_str_convert.py::test_str_convert_ok_py39[1,2-value1-Optional]'
+			)
+			;;
+	esac
+
+	epytest
+}
diff --git a/dev-python/types-setuptools/Manifest b/dev-python/types-setuptools/Manifest
index 39751f13005c..03bbd45aa09f 100644
--- a/dev-python/types-setuptools/Manifest
+++ b/dev-python/types-setuptools/Manifest
@@ -1,2 +1,3 @@
 DIST types_setuptools-75.8.2.20250305.tar.gz 42609 BLAKE2B b54727f3dfd7ee554c35052b9edd2b598cd13b78de6fbf30fc2e95d3c01557e4e612869dd81828f52e982b4ac17a188bfd1c5c49f44e3ce00db019a3624bda40 SHA512 610b26a0dce431815858a2ed89a1be32127916d6b6aa9e4fa38aee45d5f416780a7ef38dcba5dd97f7e3958b580950dc2cbb75378d69cf1e6d611fbc7d00a526
 DIST types_setuptools-76.0.0.20250313.tar.gz 43627 BLAKE2B 49a7f30037b7a8a43a53d257b6af29270e965138bb020673fc8d33b609a10354371d750adf65de1fb3de8c622d51e7d7d0cd7ee222f368f76282a994eac7d179 SHA512 7aeb6d5db438a0c5f30aa410717a0cd8a78e7d7540aec03fbc1962618e47495b25e7d17fd5eb59d263b4913862838b7d698dc3d8ee63dc1268f41782c40fa349
+DIST types_setuptools-77.0.2.20250328.tar.gz 43990 BLAKE2B 8384864df9ca9993c3e5df5c70588a65f8c515fd9f32cc34ee654d1fb404a2c456c017f5136936b23ec60f5dc2e425dff4318bce17708dbded5c50d2e6121cdc SHA512 84b97c0f89391bb51d81b6faedac8a70e2387b1933db853aede22554e5a277ada5256d945533608c293df0680d1bf936db5cff38575967189554c3d6f97bbf96
diff --git a/dev-python/types-setuptools/types-setuptools-77.0.2.20250328.ebuild b/dev-python/types-setuptools/types-setuptools-77.0.2.20250328.ebuild
new file mode 100644
index 000000000000..4d6bfa0439df
--- /dev/null
+++ b/dev-python/types-setuptools/types-setuptools-77.0.2.20250328.ebuild
@@ -0,0 +1,16 @@
+# Copyright 2023-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} )
+
+inherit distutils-r1 pypi
+
+DESCRIPTION="Typing stubs for setuptools"
+HOMEPAGE="https://pypi.org/project/types-setuptools/"
+
+LICENSE="Apache-2.0"
+SLOT="0"
+KEYWORDS="~alpha ~amd64 ~arm ~arm64 ~hppa ~loong ~mips ~ppc ~ppc64 ~riscv ~s390 ~sparc ~x86"