gentoo auto-resync : 05:01:2024 - 08:03:20

13 files changed, 388 insertions, 4 deletions

diff --git a/dev-python/Manifest.gz b/dev-python/Manifest.gz
index aeaed37450ce..aaf013aa7c54 100644
--- a/dev-python/Manifest.gz
+++ b/dev-python/Manifest.gz
diff --git a/dev-python/aws-sam-translator/Manifest b/dev-python/aws-sam-translator/Manifest
index cae11106ad8b..ba20c00698d5 100644
--- a/dev-python/aws-sam-translator/Manifest
+++ b/dev-python/aws-sam-translator/Manifest
@@ -1,3 +1,5 @@
 DIST serverless-application-model-1.82.0.gh.tar.gz 5135310 BLAKE2B f49bdbbc009f5d41d03c0a1b82ca5a6b1ed03e14989c364eb0047cc7e90ba948a52f41237b06a35d3a48bcf2f4eac0570903e6a3a95801ffad8b9756a1f62f0e SHA512 cd757b1b99a515bed5f1cb521a23e70bc7b2e05c5566eb86198fcc77e6dfbbf74237ed7ef05e20f1a9021d57b097bf21bed1219f54a0696f6a081bc5c2321826
+DIST serverless-application-model-1.83.0.gh.tar.gz 5423374 BLAKE2B faa11adf7b6ec9df3eb625a77c2f6242b4c9fe170be8926f90da1cab94dc2c018e2ba7fc53dffec63756e68deebe7bdb22853d9e67e84e8e696399b81ed4b648 SHA512 f2bd8ce766894118107dd6cac245ae47b9fd819f9cb04a0c7d176ab3ec4f56bebbfc9c4e371f2b1db372c594a15d3c6871195b5aba06712a9f2408a51284cba1
 EBUILD aws-sam-translator-1.82.0.ebuild 1674 BLAKE2B 86a59eaf54671847bca02cd04f75efbcc4c028b7105bb21abdc1f7e54298ccc6ef3053ca568c51879d6f40b8479669cf6c270b0cd4d3a2a0417929ac9bc934a2 SHA512 44fa23761c404f2d446cb21287c282e5ff67f6fcb84b57941171238a2107a26d39403e511e0f3f915bb735892b6145dc07974c721508a2e630eb171901e1ef0c
+EBUILD aws-sam-translator-1.83.0.ebuild 1677 BLAKE2B b8d7ec7611f4ff1841b312269c528d21dbd9d48c87746f03031569931d9e0118701417533638e237b923eecd315187c2e4c23c254e0c8702544b31cf6319b4dc SHA512 67a57cf37ae68a6e578446382ba24eeac23c853719b6e5ef4d35070fa34dd33b045d1c8a49865b2e88f24b9979a03852ecda3720036d2d2bca794d9665a62561
 MISC metadata.xml 603 BLAKE2B 89556267393186cf69a585c58efeb6fa599bfb42ef221bea955ea807a28edee89036a2ee0d0ca81ae55d96702a01b171b837754dabf38047ecc2789157bb7116 SHA512 106b6d241eadf7807dadf03329073703f8b51e7443eddc4db8752878b6dd84cc4357689cd4b796b3a083192e9d98eacbe9e7b8af0273160c7b89846e78230a88
diff --git a/dev-python/aws-sam-translator/aws-sam-translator-1.83.0.ebuild b/dev-python/aws-sam-translator/aws-sam-translator-1.83.0.ebuild
new file mode 100644
index 000000000000..166699d76ae6
--- /dev/null
+++ b/dev-python/aws-sam-translator/aws-sam-translator-1.83.0.ebuild
@@ -0,0 +1,62 @@
+# Copyright 1999-2024 Gentoo Authors
+# Distributed under the terms of the GNU General Public License v2
+
+EAPI=8
+
+DISTUTILS_USE_PEP517=setuptools
+PYTHON_COMPAT=( python3_{10..12} )
+
+inherit distutils-r1 multiprocessing
+
+MY_P=serverless-application-model-${PV}
+DESCRIPTION="A library that transform SAM templates into AWS CloudFormation templates"
+HOMEPAGE="
+	https://github.com/aws/serverless-application-model/
+	https://pypi.org/project/aws-sam-translator/
+"
+SRC_URI="
+	https://github.com/aws/serverless-application-model/archive/v${PV}.tar.gz
+		-> ${MY_P}.gh.tar.gz
+"
+S=${WORKDIR}/${MY_P}
+
+LICENSE="Apache-2.0"
+SLOT="0"
+KEYWORDS="~amd64 ~arm ~arm64 ~ppc64 ~riscv ~x86 ~amd64-linux ~x86-linux"
+
+RDEPEND="
+	<dev-python/boto3-2[${PYTHON_USEDEP}]
+	>=dev-python/boto3-1.19.5[${PYTHON_USEDEP}]
+	>=dev-python/jsonschema-3.2[${PYTHON_USEDEP}]
+	<dev-python/pydantic-3[${PYTHON_USEDEP}]
+	>=dev-python/pydantic-1.8[${PYTHON_USEDEP}]
+	<dev-python/typing-extensions-5[${PYTHON_USEDEP}]
+	>=dev-python/typing-extensions-4.4[${PYTHON_USEDEP}]
+	dev-python/pyyaml[${PYTHON_USEDEP}]
+"
+BDEPEND="
+	test? (
+		dev-python/mock[${PYTHON_USEDEP}]
+		dev-python/parameterized[${PYTHON_USEDEP}]
+		dev-python/pytest-xdist[${PYTHON_USEDEP}]
+	)
+"
+
+distutils_enable_tests pytest
+
+python_prepare_all() {
+	# so much noise...
+	sed -i -e '/log_cli/d' pytest.ini || die
+
+	# deps are installed by ebuild, don't try to reinstall them via pip
+	truncate --size=0 requirements/*.txt || die
+
+	distutils-r1_python_prepare_all
+}
+
+python_test() {
+	local -x PYTEST_DISABLE_PLUGIN_AUTOLOAD=1
+	local -x AWS_DEFAULT_REGION=us-east-1
+	epytest -o addopts= -o filterwarnings= \
+		-p xdist -n "$(makeopts_jobs)" --dist=worksteal
+}
diff --git a/dev-python/boto3/Manifest b/dev-python/boto3/Manifest
index 74aa58ca6429..90d7ee14af28 100644
--- a/dev-python/boto3/Manifest
+++ b/dev-python/boto3/Manifest
@@ -1,9 +1,11 @@
 DIST boto3-1.34.11.gh.tar.gz 760539 BLAKE2B 8ce756d33b604aed9d42bcccf60be467bd519f4c7a890592d9652fe3cd2851425f7a16afc7a194ccbda43a9859d0b9b683562ce1672eda9383119bc9de0dc0c9 SHA512 82b1920f1a5ad0e23364815a6b0552efceb7f49e17e585370917f63c1b74ea746eddc4f3d8c055d1eac7ca1cdbe5ac2bd304ce66e2ee12edf75ea2e261e88c56
 DIST boto3-1.34.12.gh.tar.gz 760869 BLAKE2B 3b4661df5ecc22aa9b025b1d3e38c9da9583a1fabd6ab4730c66b194086e74dc95602005850aaace272f7dce72103530797c058a0c4c6ed34afe2fbcea1bb4b9 SHA512 46e10ce9cc44711ecc2a79f7a5b2e4a5053538c51b92ee717358264c65361da036a0e76d91cb49afc79109e197a37c1471e70d5b24e54e6719bb8cccf3eda01f
+DIST boto3-1.34.13.gh.tar.gz 761598 BLAKE2B f2d71d234282cdb311af7bc4350ed4ab20c1300d510b8eeccbd47b49c057bc97771fd202426f6e441acdea2ea337fa729a73e1baf96f3a381ddd108b353e0d79 SHA512 cf4fffecc4291fe1f793ea9d19ff9d78f594b56a0f4b8ffe4af8d1dbd049e4e63ca89f054fe9deda99884210b5cd7edc1d5556d27d1a324f65cc6ead41746ebd
 DIST boto3-1.34.2.gh.tar.gz 756227 BLAKE2B 7253c533bac45b3848ab573d4781cf68b6bea8d504f851b58366dd3e6ac05b35fb2a85cb7aaff0e426a6bd2f9fe2933dd240e4d0283e4491e095fa93b4061971 SHA512 06eaf9b6725d312d91a4a8ba3ab85dde5f579e6d2fa42211189a6f30584b7d2a5c0cca46264bda52a076c8bd1acac9ec0476eb5d986a8e29972f69b7007de3c2
 DIST boto3-1.34.7.gh.tar.gz 759909 BLAKE2B 059228d7bd57ac34274437f77b3510dff6dca7d1293ffd6f7672b0fcc0acefffeeda2c5c2b4e19ef49bbffd4746dc226edfba52d57f5f8629516c9e830dbdd90 SHA512 43395937977ad3c860ede35d2adbb9575312ddab4972b8d258e41a7d6e86f3e6a74037dadb0f0e0f4f3d5ed715a66390041ac9c980bc8a3cfb727a44e252113e
 EBUILD boto3-1.34.11.ebuild 1393 BLAKE2B e6e26eacfc0623a93e310b3e33f75520f912d0c3139a8a6f1dbf657664058bce520d90fb6bcffb601c58bf171a05b48abd0ecb5e64bf5d6953c00f1206691bef SHA512 ebdcc8800a6552fa25d586cf586040e2b3da9fd670ae8e346e558fff4941b68dc90c8cfa5ffd6dcbdbc956878793835b950d2dc2198a3ae619c3fed58b5d785a
 EBUILD boto3-1.34.12.ebuild 1393 BLAKE2B fff93f537ee096dbf0b37ef3ed8ea98b68aebf9c593af34a76e0052903350931a328d07cebb9c2bec5d3f3b024a7d847890c5d7948f4bcd02819b4082bb9a854 SHA512 19dc82ff92fee67f70a85745728ebc96f6f7945bdc37af823f50ccd5db7184f1179adea84304d1a6311307a4e96be3d554f562f0eefc0042743f722b53af5215
+EBUILD boto3-1.34.13.ebuild 1393 BLAKE2B fff93f537ee096dbf0b37ef3ed8ea98b68aebf9c593af34a76e0052903350931a328d07cebb9c2bec5d3f3b024a7d847890c5d7948f4bcd02819b4082bb9a854 SHA512 19dc82ff92fee67f70a85745728ebc96f6f7945bdc37af823f50ccd5db7184f1179adea84304d1a6311307a4e96be3d554f562f0eefc0042743f722b53af5215
 EBUILD boto3-1.34.2.ebuild 1385 BLAKE2B 0c92f4ec12f0b6dbb8a20e418a34c866267605a1fc9af3b85fae540efbfe694204e4f156b048d4943927d527c12573cb9f723a8fb1f00a4a6d259a273778caf5 SHA512 36d91ec638d1c643e40cac0f53b169f24fcc6e5acbddf3037646547daaaf0e5734e76914d4f16e46822e0106456a95e5588477812e81067c090872f11c7f183a
 EBUILD boto3-1.34.7.ebuild 1393 BLAKE2B e6e26eacfc0623a93e310b3e33f75520f912d0c3139a8a6f1dbf657664058bce520d90fb6bcffb601c58bf171a05b48abd0ecb5e64bf5d6953c00f1206691bef SHA512 ebdcc8800a6552fa25d586cf586040e2b3da9fd670ae8e346e558fff4941b68dc90c8cfa5ffd6dcbdbc956878793835b950d2dc2198a3ae619c3fed58b5d785a
 EBUILD boto3-9999.ebuild 1588 BLAKE2B bfcf68e1a1dffa36c71f030ad8743b59c9170c34a425a7982ee81d1fb0df1c29fdecefa7b55f373557b735d60ab51d510ca398edd4045def5fffb6d4d4d9d579 SHA512 1bca684f585a51d8b58a594c71974b36b145912550f051d6d4c84ba28bce949ec10c112a6f7bfa8f60fa362d9126d9a830243ab36595754bef02f19e02161bb8
diff --git a/dev-python/boto3/boto3-1.34.13.ebuild b/dev-python/boto3/boto3-1.34.13.ebuild
new file mode 100644
index 000000000000..037a85ad96ee
--- /dev/null
+++ b/dev-python/boto3/boto3-1.34.13.ebuild
@@ -0,0 +1,64 @@
+# Copyright 1999-2024 Gentoo Authors
+# Distributed under the terms of the GNU General Public License v2
+
+EAPI=8
+
+DISTUTILS_USE_PEP517=setuptools
+PYTHON_COMPAT=( python3_{10..12} )
+
+inherit distutils-r1
+
+DESCRIPTION="The AWS SDK for Python"
+HOMEPAGE="
+	https://github.com/boto/boto3/
+	https://pypi.org/project/boto3/
+"
+LICENSE="Apache-2.0"
+SLOT="0"
+
+if [[ "${PV}" == "9999" ]]; then
+	EGIT_REPO_URI="https://github.com/boto/boto3"
+	inherit git-r3
+	BOTOCORE_PV=${PV}
+else
+	SRC_URI="
+		https://github.com/boto/boto3/archive/${PV}.tar.gz
+			-> ${P}.gh.tar.gz
+	"
+	KEYWORDS="~amd64 ~arm ~arm64 ~ppc ~ppc64 ~riscv ~sparc ~x86 ~amd64-linux ~x86-linux"
+fi
+
+RDEPEND="
+	>=dev-python/botocore-${PV}[${PYTHON_USEDEP}]
+	>=dev-python/jmespath-0.7.1[${PYTHON_USEDEP}]
+	>=dev-python/s3transfer-0.10.0[${PYTHON_USEDEP}]
+"
+BDEPEND="
+	test? (
+		dev-python/mock[${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 c9bb3e95fa30..6d140f9cf5d2 100644
--- a/dev-python/botocore/Manifest
+++ b/dev-python/botocore/Manifest
@@ -1,9 +1,11 @@
 DIST botocore-1.34.11.gh.tar.gz 12612317 BLAKE2B 8a8648dfb27fad0d0a52df37ce9d988ef3349b773d88bc752dd9d22866f3adb8dc6346128767df5523fb335a602d666be8a5758fdfbe27c221779a0c4ec23590 SHA512 4159f2794d98532dc5e94a91061165b1aa2f43c5a493604c6d3dec426b51d582359577fc62d0ac20044a8b94e196efacbbcfd436cc38390db9bbaf7b4eb3d16c
 DIST botocore-1.34.12.gh.tar.gz 12612056 BLAKE2B a323c654ad6e6fe8d5e3290ee87fd6e2aa897d4e9696f6132e911306b50aa38624f197b15d52d3ed8e1850189b833126a75ed9767824f95b9b002bea4924d825 SHA512 62c7ebac7fdb563ac596ccc9fd88392c8c0584475e0e6bcbb87ba569b65888597738a2281c4f5a2ffc46ad2ac776ea0e2e3cd3f35e265e565f91c8c0a6cecf52
+DIST botocore-1.34.13.gh.tar.gz 12616661 BLAKE2B 189825c2ab84ad26b9917b03101eedec95cd34f0cad2c202d3207df9c39941e35c6573a808280f67318c0bf611fd9fc364fe5fb6d20e4e39db77a85572b604e6 SHA512 54516e9e2694e8c9e66ee50d6b6feff5139eb04532018e9f70c5fa15a6fbaf00a796c028d096acb80037a12ef0462029d8b9066a461544500c6cc2f253b45e38
 DIST botocore-1.34.2.gh.tar.gz 12564834 BLAKE2B b22a3d3bd35b769a28ccb1a5116428e1904d0c9fc3452829237704dbec37a31a539f044a728b0785d09406d299d522dd601da39801249747d54e6741b46cafe2 SHA512 a3f3718bf584a871abbb3edc803de9d5329da257c050d56bdbf8a6a6c4067477812582fbd8d1d789ce18ea1f416d0ddb2be9cc3c45172292d061a94a12f3977b
 DIST botocore-1.34.7.gh.tar.gz 12606475 BLAKE2B 387ee7dfab43c44c39c7b0566b6ddcb2b666024b5b7bee2c996194988781c169e1e9462b36d09861d1c3ca899d263392f3d79129e7a2f2fc4bbfed402f5c7dd6 SHA512 3f162d4d028dd81da552e0117671971aa891bf8fab513730f40083660fa83c1f82bf1b52875cf9f7f11089ecdd79f084f3c8e76227aa826c1aac7e5735032450
 EBUILD botocore-1.34.11.ebuild 1524 BLAKE2B 8a2471391e1a0e596e0b8d72ee09df50c3763a3d03db51169f45b1b571ba3df97eef93a43374b196ced5e1dc978bc2f3de52099675a6b19c1d5fe933922466b3 SHA512 bdde6ff5fcea64cad2e42bf6b2e8cb49f096ed5b17c321246651936878ff07347f4fea7805bb7083053aab2014c3e4a50fefcb727e89ccee3aa6a5860d71b249
 EBUILD botocore-1.34.12.ebuild 1524 BLAKE2B 67dfe51e2af3b1cad0cfd2cffb979c3b5aa76f826bb002612f9a78142c9e8d3dd593b5c929aa1d1de1cd55d44dab3d839ef8a270948cda57738358c9fab07018 SHA512 a6f32a7367818ada29a39fd5fd4461cb7b859c8746ca4225f15a627ef7579bb4333de93a6e1854c2901fc8ba8d1ecb4f017d84cbe148be72bb242e63f25fb84f
+EBUILD botocore-1.34.13.ebuild 1524 BLAKE2B 67dfe51e2af3b1cad0cfd2cffb979c3b5aa76f826bb002612f9a78142c9e8d3dd593b5c929aa1d1de1cd55d44dab3d839ef8a270948cda57738358c9fab07018 SHA512 a6f32a7367818ada29a39fd5fd4461cb7b859c8746ca4225f15a627ef7579bb4333de93a6e1854c2901fc8ba8d1ecb4f017d84cbe148be72bb242e63f25fb84f
 EBUILD botocore-1.34.2.ebuild 1517 BLAKE2B e056da584f834fcb5026f593a9187a613e82f1a6cb8df7b6fff6a997b971905e62ee8cfe8c99a0dbf1a6c514499860d8cb0a0d27e9155715ec07de46a8d8b325 SHA512 f5fd3af7a1209b7ecd8e7b8ac4aad92ae0db0477678d02c88394aeb7b9d1984e6c0975cbc4d006cc2df480f7fbec625ad8dd660edabf148dd44c2785085b9366
 EBUILD botocore-1.34.7.ebuild 1524 BLAKE2B 8a2471391e1a0e596e0b8d72ee09df50c3763a3d03db51169f45b1b571ba3df97eef93a43374b196ced5e1dc978bc2f3de52099675a6b19c1d5fe933922466b3 SHA512 bdde6ff5fcea64cad2e42bf6b2e8cb49f096ed5b17c321246651936878ff07347f4fea7805bb7083053aab2014c3e4a50fefcb727e89ccee3aa6a5860d71b249
 EBUILD botocore-9999.ebuild 1599 BLAKE2B 8325845842cef976827216365bd3f88b7865bb4ce82764b121a42bb99d98952042223281fa66e6e31ec83e39c4fc585672fbab6426a7df79aa945df720d42a1b SHA512 ade15b4567ae00f08a0f5895d967ad3f37af15c24b3169e9319fd7d3c3a3316f34d989b225a928c8c72c2656e4c8f79d61e8b7ddd17e179adf7ff67bcbac6efb
diff --git a/dev-python/botocore/botocore-1.34.13.ebuild b/dev-python/botocore/botocore-1.34.13.ebuild
new file mode 100644
index 000000000000..dcd34e4e67de
--- /dev/null
+++ b/dev-python/botocore/botocore-1.34.13.ebuild
@@ -0,0 +1,68 @@
+# Copyright 1999-2024 Gentoo Authors
+# Distributed under the terms of the GNU General Public License v2
+
+EAPI=8
+
+DISTUTILS_USE_PEP517=setuptools
+PYTHON_COMPAT=( python3_{10..12} )
+
+inherit distutils-r1
+
+DESCRIPTION="Low-level, data-driven core of boto 3"
+HOMEPAGE="
+	https://github.com/boto/botocore/
+	https://pypi.org/project/botocore/
+"
+LICENSE="Apache-2.0"
+SLOT="0"
+
+if [[ "${PV}" == "9999" ]]; then
+	EGIT_REPO_URI="https://github.com/boto/botocore"
+	inherit git-r3
+else
+	SRC_URI="
+		https://github.com/boto/botocore/archive/${PV}.tar.gz
+			-> ${P}.gh.tar.gz
+	"
+	KEYWORDS="~amd64 ~arm ~arm64 ~ppc ~ppc64 ~riscv ~sparc ~x86 ~amd64-linux ~x86-linux"
+fi
+
+RDEPEND="
+	dev-python/six[${PYTHON_USEDEP}]
+	<dev-python/jmespath-2[${PYTHON_USEDEP}]
+	dev-python/python-dateutil[${PYTHON_USEDEP}]
+	>=dev-python/urllib3-1.25.4[${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 EPYTEST_DISABLE_PLUGIN_AUTOLOAD=1
+	epytest tests/{functional,unit}
+}
diff --git a/dev-python/sqlglot/Manifest b/dev-python/sqlglot/Manifest
index 10f192294033..3d89aec641ec 100644
--- a/dev-python/sqlglot/Manifest
+++ b/dev-python/sqlglot/Manifest
@@ -20,6 +20,7 @@ DIST redox_syscall-0.4.1.crate 24858 BLAKE2B c3301137a0b84e03b09d28dfa377ab3bea7
 DIST scopeguard-1.2.0.crate 11619 BLAKE2B 8b7e9ed6cefef9ee55407fb9690d57a2a98bb93e5105aeebdb475a52485e9e185255249e1dce8f83cd80534e7402d485aac3efa7e8493b13135de27550cd4bc4 SHA512 6247719a15fe1e4e2d179127b9a934bd2f99367724f41175ed9522f58824b6bc69b35002eae66b35880375ff61d77ac43ddaa78cbde7160a35183a1da32d3fbb
 DIST smallvec-1.11.2.crate 34801 BLAKE2B 58645e99db8f02db64d02c75860c7ea41836c427c03ee3b0b23365e73a406e4fd6ac312bf13fc5faef8bb6111c10fcfd5f839d5b3686e9b34d1626f8469fc327 SHA512 5cfb427c3b99b0dbd71f6154ed899abcde9d7d2992977ac7b2ef3a4c3ff51e4efafd133071a69609b4ed6cb269bdc26b79eb72e1988f10dfcaef8185d950cd1d
 DIST sqlglot-20.5.0.tar.gz 9066011 BLAKE2B a2062e4bbb74abe84d14fa1bdde57374185a7487c42c90b13d4fdee5d0793f0cbe54c8da21d33ec0aef398fd4e2015547bc34dd0d444391079c33aa90d612f77 SHA512 4ccc3bf40fe778e8911008a6a51ef84a2c46e430ad15b7ac93e64d68c13705d9811f72691e96f35ab7ce2c45835776afb50815807ab585b52489b1971bb7ddaa
+DIST sqlglot-20.7.1.tar.gz 9293277 BLAKE2B 8a7d894033122a5541f1e6bf3bc9066805fc8a43e700186dde49c007e042baecfb59742918607b8779f11d0215f0f107cd45ed793683256fdcd2e1b11a4ab058 SHA512 ffc4d539752e9357cb93669ab936666b7c11d37ccca1358059ce19322a9ba65b05b8492ecc3c39b5905564b3aae2fe13d4ae87c80b51b5cf5a43bbb074cc2c88
 DIST syn-2.0.41.crate 246016 BLAKE2B 9d389f2e2a0acb4c84c309456e8ffcc88c5d4d541535ed136832d7a6054dde45a598bb68e8a6f3062ca2a96e1ceae947d54b3aec9bad65b0c51d6733aa6c80db SHA512 6bbaf69ca783025dfb81ac3612ac60bfbed31b2d87792909b35c12892dadebdaff2ddf9463105e536b671dce5870610ab90fe29471284bbd3014dca8d6993f1a
 DIST target-lexicon-0.12.12.crate 25156 BLAKE2B f3803596c75f6c89438592a1176c3748fc2c0524d7d50a20056de1cd26d40c572b05bafcdf6dd702752864bea37c8b4f28f96dadc12a5b3bb1d279b25e489f85 SHA512 6147295c43ba1b7b087a3c5ab51534b2985e4e77e5e15687978cfb9d07e21c4fd9bc7191576d6cabd268d08a44dc733c4a957e59dba8b948c2055d8bb433aeca
 DIST unicode-ident-1.0.12.crate 42168 BLAKE2B 4cede03c08758ccd6bf53a0d0057d7542dfdd0c93d342e89f3b90460be85518a9fd24958d8b1da2b5a09b5ddbee8a4263982194158e171c2bba3e394d88d6dac SHA512 bc1824e1e4452a40732fc69874d7e1a66f7803717a314790dcf48867eba34bc9441331ef031e386912e52c385645c25b6ed39d4f149973b5b97371b1b96b1920
@@ -33,4 +34,5 @@ DIST windows_x86_64_gnu-0.48.5.crate 801619 BLAKE2B aa7e7e6a6ff9f9553ada3a0a39a9
 DIST windows_x86_64_gnullvm-0.48.5.crate 418486 BLAKE2B 12a2199d434617c1df1a839e9f435620ad64b40c579f6d0c3677553ad7a48e5765d12c266b04946402e15c92cff2e4ac4979ce2130750ef426e2672119680284 SHA512 c016d5b5e73832b61ff67929d92fa8c16e154656294357266ad29ce1f44db4ca2d2935dba31a6b571187dc838b1d22f1e3b41fefffd1d719a338439adf1646aa
 DIST windows_x86_64_msvc-0.48.5.crate 798412 BLAKE2B 8abc0721e2fb337fe17c91d278947d36122d9045b839ba0cf3e690202d242265b676f23cc301da5f9d98c56ca4ecb76f7d6f072ee71bf986a1deca87020b90e5 SHA512 fa1c5cd14ca2ff0082e2504cf59d317dc4dc6f7138d35c12f95d4476a9c13d8b7f5537d0ee251eee7c99411ad31b22263171b7fbd391daa5d3ea3488ceaa61a0
 EBUILD sqlglot-20.5.0.ebuild 2597 BLAKE2B 9d4a8e89e951277d07707ef3e24dcab448356263cbc77f469459708a681ba11d5c4d05180783540450324e73d3fc844b2e1fd79319cbb37ce9badde866ef3b50 SHA512 3a105e63d8f426d9104d8531445eb127fcece04a101dfedb10cca76536dd4396fe0b1b993766741975ad8d56cb6f60d28a8bd1d9e5fa40b900e950fbf427e324
+EBUILD sqlglot-20.7.1.ebuild 2602 BLAKE2B 3bfbd91a9bd26b48f14f4ca2d1143e55e37da4f8c0d893b1a3d4d5853b7959d325669fc46e8f79e5e817b139ccf0684e663456d3b45785195b4e06942522ff08 SHA512 f8c1aa7ea03ed2e0044b6550a13f1e2e40999a16a247cd7206db725c14d3ba06a92cd1909a0126d51ac583ecd8a4825f4da678aab079eb94a7e7cbad16ecafa2
 MISC metadata.xml 611 BLAKE2B 10bf684677182565c9932d51ed9b3b9c80d376d6db945bd7b0dd0d9a19a85dc0d10cb169ff2048ae5f7f73d0f438d259b6231c13c525b5374ec99377f4ffdd10 SHA512 2b26d0f77962807052b94ad78addcfdce9859042af3be34df267dc6e70b6231dd779563935fd21955cd8646fd0cce3fee8c939387ac8056194a0b777743dd2ae
diff --git a/dev-python/sqlglot/sqlglot-20.7.1.ebuild b/dev-python/sqlglot/sqlglot-20.7.1.ebuild
new file mode 100644
index 000000000000..058fa81df816
--- /dev/null
+++ b/dev-python/sqlglot/sqlglot-20.7.1.ebuild
@@ -0,0 +1,121 @@
+# Copyright 2023-2024 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_{10..12} )
+
+CARGO_OPTIONAL=1
+CRATES="
+	autocfg@1.1.0
+	bitflags@1.3.2
+	cfg-if@1.0.0
+	heck@0.4.1
+	indoc@2.0.4
+	libc@0.2.150
+	lock_api@0.4.11
+	memoffset@0.9.0
+	once_cell@1.19.0
+	parking_lot@0.12.1
+	parking_lot_core@0.9.9
+	proc-macro2@1.0.70
+	pyo3-build-config@0.20.0
+	pyo3-ffi@0.20.0
+	pyo3-macros-backend@0.20.0
+	pyo3-macros@0.20.0
+	pyo3@0.20.0
+	quote@1.0.33
+	redox_syscall@0.4.1
+	scopeguard@1.2.0
+	smallvec@1.11.2
+	syn@2.0.41
+	target-lexicon@0.12.12
+	unicode-ident@1.0.12
+	unindent@0.2.3
+	windows-targets@0.48.5
+	windows_aarch64_gnullvm@0.48.5
+	windows_aarch64_msvc@0.48.5
+	windows_i686_gnu@0.48.5
+	windows_i686_msvc@0.48.5
+	windows_x86_64_gnu@0.48.5
+	windows_x86_64_gnullvm@0.48.5
+	windows_x86_64_msvc@0.48.5
+"
+
+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? (
+		${CARGO_CRATE_URIS}
+	)
+"
+
+LICENSE="MIT"
+LICENSE+=" native-extensions? ("
+# Dependent crate licenses
+LICENSE+=" 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}]
+	)
+"
+
+distutils_enable_tests pytest
+
+QA_FLAGS_IGNORED="usr/lib.*/py.*/site-packages/sqlglotrs/sqlglotrs.*.so"
+
+src_unpack() {
+	cargo_src_unpack
+}
+
+src_prepare() {
+	# remove fragile timing check
+	sed -i -e '/assertLessEqual(time\.time/d' tests/test_parser.py || die
+	distutils-r1_src_prepare
+}
+
+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_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/xmlsec/Manifest b/dev-python/xmlsec/Manifest
index a92d02d1cfd8..50529e62deb1 100644
--- a/dev-python/xmlsec/Manifest
+++ b/dev-python/xmlsec/Manifest
@@ -1,4 +1,5 @@
 AUX xmlsec-1.3.11-fix-xml-testfail.patch 879 BLAKE2B 3d655b40a67b44a4abd65188c6d719e12063e857942fdb112b47da38977864252e3d250e0bbaf5c86f4688bb7701aae89df444c4fef0e3f0eaffc98fe5b6b856 SHA512 8c8f9af415dc9207e5c0599ee958dff6558618f94a9cb3c583b1c9eb6d1de251d714edf1afdee581cb33c7543f88c54d36af9b6f903fe31994a86f1b602e4c75
 DIST python-xmlsec-1.3.12.gh.tar.gz 77722 BLAKE2B b5ecece8063b823cdbe4d58967d10026bdc6f3774954021a3739d579ba3c5a08130af1792921c7892e6bc3d00f88ac83ab30e862775e419e0dad40b990b10cbe SHA512 19c5e3bf58b4b0f8a1cca3e60c08348b02ae298620f8c02b8cfb325aecf0313cb2bd1af89507b754ebe4c35af3b031e232d15ddcd42deae0821c9c0d7571aa7c
 EBUILD xmlsec-1.3.12-r2.ebuild 1334 BLAKE2B eca3a3bff75e170a4b06b849506524d4d7203feba48cf95b35315f9eb496a0fa04027501de9294254a510bcd914276ed27d995ced9a445a62a242194cb1753bd SHA512 9bcde471fdbfcc323f1e696907c20ede30305768f1f0e8ffcea494e45189d2e422275e39950cc2ed569dc4b9de76ddab15c60f034d034e723ffabe003ccbd2d5
+EBUILD xmlsec-1.3.12-r3.ebuild 1421 BLAKE2B a84976426fbcd6324aa3cf1faacdc42a4a38409fc6b5f331af0fc587744dd2282a87bb435cc6d2b3f10c75bbb0a0d403f2fde50b62e897c614c9fb16121adf99 SHA512 5e4189ed5a39f803b7d32f1988baa38ddb0ba48d8eed5be0cd49f27849fe7f37c166f7a22bdb6da4146608a2da56bcdcfb60b99bfba4d63378376a1dcf8ed5e0
 MISC metadata.xml 480 BLAKE2B 17abd324963ad808438f7c04a5785ab72e280a5ba8b132737d89c06fd17fc20e96478b4684ae84864bd03690bda6e865200a8eacf3bd0c23ceca4f0230bef1a5 SHA512 82d2b54886ba9d2eeba17aa04e2946c9dda8d30a5bea9a9ba7a5041b559971466c33ceb67ed35c9f865c052df09fb9fd057b46efd4d3d4314f456c8b1c0aaac7
diff --git a/dev-python/xmlsec/xmlsec-1.3.12-r3.ebuild b/dev-python/xmlsec/xmlsec-1.3.12-r3.ebuild
new file mode 100644
index 000000000000..dcaa3235598a
--- /dev/null
+++ b/dev-python/xmlsec/xmlsec-1.3.12-r3.ebuild
@@ -0,0 +1,59 @@
+# Copyright 2021-2024 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_{10..12} )
+
+inherit distutils-r1
+
+MY_P=python-xmlsec-${PV}
+DESCRIPTION="Python bindings for the XML Security Library"
+HOMEPAGE="
+	https://github.com/xmlsec/python-xmlsec/
+	https://pypi.org/project/xmlsec/
+"
+SRC_URI="
+	https://github.com/xmlsec/python-xmlsec/archive/${PV}.tar.gz
+		-> ${MY_P}.gh.tar.gz
+"
+S=${WORKDIR}/${MY_P}
+
+LICENSE="MIT"
+SLOT="0"
+KEYWORDS="~amd64 ~arm64 ~ppc64 ~x86"
+
+# Doesn't yet support xmlsec-1.3.0: https://github.com/xmlsec/python-xmlsec/issues/252
+# Doesn't yet support lxml-5: https://github.com/xmlsec/python-xmlsec/issues/277
+RDEPEND="
+	<dev-libs/xmlsec-1.3.0:=[openssl]
+	<dev-python/lxml-5[${PYTHON_USEDEP}]
+"
+DEPEND="${RDEPEND}"
+BDEPEND="
+	dev-python/pkgconfig[${PYTHON_USEDEP}]
+	dev-python/setuptools-scm[${PYTHON_USEDEP}]
+	dev-python/wheel[${PYTHON_USEDEP}]
+	test? (
+		dev-python/hypothesis[${PYTHON_USEDEP}]
+	)
+"
+
+PATCHES=(
+	"${FILESDIR}/${PN}-1.3.11-fix-xml-testfail.patch"
+)
+
+EPYTEST_DESELECT=(
+	# Fragile based on black version?
+	tests/test_type_stubs.py::test_xmlsec_constants_stub
+
+	# Broken with xmlsec-1.2.36+.
+	# https://github.com/xmlsec/python-xmlsec/issues/244
+	tests/test_ds.py::TestSignContext::test_sign_case5
+)
+
+distutils_enable_tests pytest
+
+export SETUPTOOLS_SCM_PRETEND_VERSION=${PV}
diff --git a/dev-python/ytmusicapi/Manifest b/dev-python/ytmusicapi/Manifest
index 5956532a910f..a2ca215d54ab 100644
--- a/dev-python/ytmusicapi/Manifest
+++ b/dev-python/ytmusicapi/Manifest
@@ -1,5 +1,5 @@
 DIST ytmusicapi-1.3.2.tar.gz 71732 BLAKE2B 957c2b88ea2c9e59c81401762e4dfd4a52a2f5d3ba59653d2556c3d29225ab4bd92155070e75812f302430b453a5c32a2f44fb508b24905a8f0d16c6fe51299b SHA512 c9ccf7999d668502549e4b5393682192d1db2851660444b6255d5bfb2c0c994ab4715800b669bf57d60866aef7c5529ece374c1eda8d945c7008477438dd0fdd
-DIST ytmusicapi-1.4.0.tar.gz 94975 BLAKE2B c83170695e6f248d88cfa394c114f3931e98dfffa7770551c521163530c04ae56ed988ae4b06e124f788758274be8eb909e833a2b9bd3d282b6e16563829d44e SHA512 d3c73ae4171c20aab7982e377e0b949e7428010e41c7ac76ed0a7727c2e66fd8f814bb8914e4c016c76e8c72a2e08db2e3be736b298926e5fe3365288db95e09
+DIST ytmusicapi-1.4.1.tar.gz 97107 BLAKE2B 9c1c405840e75048d3fc6a963e708ee1cac10b6f7ef0ff4179b47cecc14419455104784fce7da4b6c660c5f18ef17a24cb4694a2f57cf81d04aa865cbdc100c7 SHA512 f6acf693ae59396b50c58459b7ea664f6b7828df24d808a1f52065f03969f74e989a4142ef10328030262eb1fb01f9902520eca01f5870c6778b3c55f7619f76
 EBUILD ytmusicapi-1.3.2.ebuild 504 BLAKE2B e94d0beaec9ff24ed842ea5d39bac5e426739752d84b2cc77ae3ab7733061f86d7cd225ce1f89f333447e0b2a474813c3d198c69e90bdf4a7e4d506d94fe0cbf SHA512 9150df9687f787c6f5dfbe2c81bacaeb9c1e57d98bef17963462f339b260a59e02c84b83d275341bc24400570ce9fd0ba4bb6a33ad054236f74e8df4bf5b158c
-EBUILD ytmusicapi-1.4.0.ebuild 505 BLAKE2B 98fcddc6143ce2e5a82d6de349af6cd91c11e2105956767fb902fb003e8f6bd94f2991b36a62a460d5d5a4a5db06568e6bcc10190e328b1034c2e328760cdc27 SHA512 f2401d8ddb526ca4c9e5f1f90917ffc3483d5761aebba4b9fca26f80414ccce8057f0ff240f4db5d049ee6d2a969691360d9e64ec04372e351250243cbcbb1c2
+EBUILD ytmusicapi-1.4.1.ebuild 521 BLAKE2B 6de42dfb36c4020602998b6c399bdce29071ca6117d137e528ca7a419bf403e40a5f97ed7fd7ba11e4ea0db396dc865fdc529726083690f68376e157ea725792 SHA512 4eb82c225a52fc44a77085c99373872b77ac6494d7dcb54ec513cde19f1c7d16ce2c9823d5e5dab9e5bc5ac50e733c670de8ba2963964fcbe9b3729fcaceafcb
 MISC metadata.xml 589 BLAKE2B bf51d5de92082a99ffb69839a9cadcea1d740f05d83194b951383713bcfbc4c95021ef27382cc6020298c3b8817553549ba150876c1398094dcc9a7de38bc04c SHA512 d34382f0041b2f74892661880ee7a318d7571254b18bf41d1152560e06f8d1b2da7432b4e9eb8a0d8b6cba645da9a3bf9c6a7c33002471a17d8c516c0aee8f70
diff --git a/dev-python/ytmusicapi/ytmusicapi-1.4.0.ebuild b/dev-python/ytmusicapi/ytmusicapi-1.4.1.ebuild
index 52eef4b410a8..1537ab0e5d66 100644
--- a/dev-python/ytmusicapi/ytmusicapi-1.4.0.ebuild
+++ b/dev-python/ytmusicapi/ytmusicapi-1.4.1.ebuild
@@ -4,7 +4,7 @@
 EAPI=8
 
 DISTUTILS_USE_PEP517=setuptools
-PYTHON_COMPAT=( python3_{10..11} )
+PYTHON_COMPAT=( python3_{10..12} )
 
 inherit distutils-r1 pypi
 
@@ -13,8 +13,9 @@ HOMEPAGE="https://ytmusicapi.readthedocs.io/
 	https://github.com/sigma67/ytmusicapi/"
 
 LICENSE="MIT"
-KEYWORDS="~amd64 ~x86"
 SLOT="0"
+KEYWORDS="~amd64 ~x86"
+RESTRICT="test"
 
 RDEPEND="dev-python/requests[${PYTHON_USEDEP}]"