gentoo auto-resync : 29:09:2023 - 11:37:12

22 files changed, 451 insertions, 116 deletions

diff --git a/dev-python/Manifest.gz b/dev-python/Manifest.gz
index ab09c46cbc76..8114e92ae93e 100644
--- a/dev-python/Manifest.gz
+++ b/dev-python/Manifest.gz
diff --git a/dev-python/aiostream/Manifest b/dev-python/aiostream/Manifest
index ea77722421f3..1c4c8f85a4b0 100644
--- a/dev-python/aiostream/Manifest
+++ b/dev-python/aiostream/Manifest
@@ -1,5 +1,7 @@
 DIST aiostream-0.4.5.gh.tar.gz 39797 BLAKE2B 5aeb4da46158d949190af22133f1798831e14f8d8da231d3dc098caaace303061bfa49dfef1d52c533ce20201937bf5da33f36806634b2e73ccbc48c00962486 SHA512 ac1a67a6d27e18e290c5ae5b069de2e7f7205120bc747885261e23155019d5630c1f7b643df3a4fef12844d52cdfc0f1fcdcf5cb35a0061000d426c62dcffb1d
 DIST aiostream-0.5.0.gh.tar.gz 42508 BLAKE2B 44acb97c42aa7fbe56981e5d237fd28eb531e38255a3beca98f0c7fd33a019e1fa525938b6ff21d1c49df5424d1093417003bb280f6d9ee8609a0f475a347a25 SHA512 bcab27272cde42b8a09a41f9b818d8094514eeeab4b1c0304c6d2b908bcf1142d029882d51ab427b34db215dbaedf519c772be2e67a1d7f9ca5a3def0d04b7ae
+DIST aiostream-0.5.1.gh.tar.gz 42439 BLAKE2B fff62e73d0da156a18ec935051e46b2ec17b36b7541db4791083bd1873f53a1ce0576a11e8ca0071bb6194312f184c4eb3cf9c5fdbd37f86768b1111edc867b5 SHA512 a93f2969a19f5e9d0ce334a54be935092b26e2b621ef3fe27bb101fa812360349c77fc9c7dc41b56491b314c236622ab812e2ee0fd9c6c136e431781b3733a75
 EBUILD aiostream-0.4.5.ebuild 741 BLAKE2B 07ab48ad0e2e64bddf75ea0810785bb4eb1ff40531e406028cab6fffe3fa7a53f3685159d53ba99fb840287e0edaa7ec722569408e1f690b6e01726478cb6fa5 SHA512 7fe83fd332cb167fce20dde2f2acdfb314ebcce5f8cca1cd3010f6c66f12508176e10bdfa8eaa4036f073d5785acda64f9631902166ffeff4d400997de3df702
 EBUILD aiostream-0.5.0.ebuild 802 BLAKE2B 4dc4f164e40d1923ca6514f77132af0f1ce64a6090335331fdfa6eb2d3b5acc026666d2de8eefa41a074b838bd52cb95488b77f033ef54c3bb218247237aa74c SHA512 6dc9c5d73fe95474526fbdb0390ae80fc1bbf3a19686582e1393bc437a3365a2acdcc59ae947f42f412bb5aa12aefe4fa01dad04aff0e834a5d66bee39fa28e4
+EBUILD aiostream-0.5.1.ebuild 802 BLAKE2B 4dc4f164e40d1923ca6514f77132af0f1ce64a6090335331fdfa6eb2d3b5acc026666d2de8eefa41a074b838bd52cb95488b77f033ef54c3bb218247237aa74c SHA512 6dc9c5d73fe95474526fbdb0390ae80fc1bbf3a19686582e1393bc437a3365a2acdcc59ae947f42f412bb5aa12aefe4fa01dad04aff0e834a5d66bee39fa28e4
 MISC metadata.xml 396 BLAKE2B bc8d636bd40d6291341e397900882cd9791c17a3f6511740f05cd67c8fa117a1b04d5ff90ddfada0ed66dd10e72a06c4cae01ce9f5d0c005ea83509bbce264c3 SHA512 fcb085c0707495790bb7b2862b1a41e9cacdde2b06a382209f7e1e451796da4acef27761d3f32be9f9aedb95690ee26e52e93b00b963ae3fcf87441df2e90e69
diff --git a/dev-python/aiostream/aiostream-0.5.1.ebuild b/dev-python/aiostream/aiostream-0.5.1.ebuild
new file mode 100644
index 000000000000..d07884312d93
--- /dev/null
+++ b/dev-python/aiostream/aiostream-0.5.1.ebuild
@@ -0,0 +1,40 @@
+# Copyright 2022-2023 Gentoo Authors
+# Distributed under the terms of the GNU General Public License v2
+
+EAPI=8
+
+DISTUTILS_USE_PEP517=setuptools
+PYTHON_COMPAT=( pypy3 python3_{10..12} )
+
+inherit distutils-r1
+
+DESCRIPTION="Generator-based operators for asynchronous iteration"
+HOMEPAGE="
+	https://pypi.org/project/aiostream/
+	https://github.com/vxgmichel/aiostream/
+"
+SRC_URI="
+	https://github.com/vxgmichel/aiostream/archive/v${PV}.tar.gz
+		-> ${P}.gh.tar.gz
+"
+
+LICENSE="GPL-3"
+SLOT="0"
+KEYWORDS="~amd64"
+
+RDEPEND="
+	dev-python/typing-extensions[${PYTHON_USEDEP}]
+"
+BDEPEND="
+	test? (
+		dev-python/pytest-asyncio[${PYTHON_USEDEP}]
+	)
+"
+
+distutils_enable_tests pytest
+
+src_prepare() {
+	sed -i -e 's:--cov aiostream --cov-report html --cov-report term::' \
+		setup.cfg || die
+	distutils-r1_src_prepare
+}
diff --git a/dev-python/aws-sam-translator/Manifest b/dev-python/aws-sam-translator/Manifest
index 09e00d3649fd..4c5ca4e6677d 100644
--- a/dev-python/aws-sam-translator/Manifest
+++ b/dev-python/aws-sam-translator/Manifest
@@ -1,7 +1,9 @@
 DIST serverless-application-model-1.73.0.gh.tar.gz 5079379 BLAKE2B e7220e4d0e25a725d3dc0828297bcab9c174e067f927b6aab7f6bdd0c9c8de8333464d7783f0ae9965b00a1323ace8f63a51aed92e459f578a2d2e15a34bed52 SHA512 1487b3815f62dc4a5081316b09d469359126fa76d4b4f3ee397b581e5491cea20ebafeeb96d261652eb552e501666de3d90f6bd5a52517474e170420abaeea92
 DIST serverless-application-model-1.74.0.gh.tar.gz 5082475 BLAKE2B 4eea6df8caefd8face0115300739d74dee96f5b303cd2f86e7ffd58535c36567c830c9a0b55f59c712b166376b66ae23d7cc5e9c79445a1a9e4f3e23f0c4b94d SHA512 f34af17d0d2ec540c9ef65c1419812e0ec24da331b527e843f3da88149721a4dbec7130f1ac452c19b8462461ed09e3e6b607a80756aaa5f01fc3abc04740938
 DIST serverless-application-model-1.75.0.gh.tar.gz 5111472 BLAKE2B c6a1ce33e9f6a51988acc72d9b2a12c8cabfa16ccbb44dcb214bedcfd5c9cf61947f0d83a32149a1dc3ceee6e0acdb4ffe3437f4605febd0e2b07d48989c9d81 SHA512 b64c2529d1a9cbb3d97163d4dd3062d19319e0b1ff98c8330fb12af8c33a2768dc6619d97dc9234b051eafef9770d35970fa631c9830a9ad94d7ac0a4eb0e800
+DIST serverless-application-model-1.76.0.gh.tar.gz 5114195 BLAKE2B 2d9eb5ea740c02ad3b6ca4024c6a5f6f87fe0a2703535eab5e69488fb30e2172ab3edd67ab4a668a9790040a0edc698c2ac4fc4c244c0b2f8037a5ce6e1175fb SHA512 97bc81cc41ecc5e1b5bc253e9ba0839598a09a49e564bfe06bd3460867412ce2551e1ad79640cf40641bdc9d09261bdd8bdb87d78c860f6c3d2b316fcee9c027
 EBUILD aws-sam-translator-1.73.0.ebuild 1544 BLAKE2B 9572110682a5bfaeee90d69c6026a0130cacda3efb2d2da2952d675f5764745fb8fa7e7b1e586b2b029f5d8b955d9934228210734b060af23abdde9b2e18c487 SHA512 48956aabc1cd71db9d3cddb180c37387c8e5e4e314411a41f3ad791bbe6b2435208c9e045dead45d6e10944271b7f9954e2d1ae9290a3078d1e35391c0f52512
 EBUILD aws-sam-translator-1.74.0.ebuild 1546 BLAKE2B ad6e5889df4bcddb45b7c19b46a2d29b4e58be32c5e2e7642713309a6962b870af65dad07437b2b5167481b4cbde6638c235a1928b930a8a50c1943e33364ccb SHA512 5b80e19e8592c98a0121af922addf5c0904d21164d1411459a5a96cf2ce54c3b728f6a7eaeb3a3629f24eac9f805d34548f9aeddb8d552d8a185599b23f0e124
 EBUILD aws-sam-translator-1.75.0.ebuild 1546 BLAKE2B 149e59b254acf3de851a46b9a7c11d1ba15cc469c8fcd3c7571eb3e45788abb0e5db72ac54754ba65804872f895e54b2a0a39155e1ce77f7fc1f4533594fdd86 SHA512 f9304b86eaae63cf411562af33cac40848502d2e50cef5a718299b75103cb5ab2541b7ea86f41af0d511679f11ea74c2572faab81fbde4ed4547d0ec7d4e6cf9
+EBUILD aws-sam-translator-1.76.0.ebuild 1546 BLAKE2B 149e59b254acf3de851a46b9a7c11d1ba15cc469c8fcd3c7571eb3e45788abb0e5db72ac54754ba65804872f895e54b2a0a39155e1ce77f7fc1f4533594fdd86 SHA512 f9304b86eaae63cf411562af33cac40848502d2e50cef5a718299b75103cb5ab2541b7ea86f41af0d511679f11ea74c2572faab81fbde4ed4547d0ec7d4e6cf9
 MISC metadata.xml 603 BLAKE2B 89556267393186cf69a585c58efeb6fa599bfb42ef221bea955ea807a28edee89036a2ee0d0ca81ae55d96702a01b171b837754dabf38047ecc2789157bb7116 SHA512 106b6d241eadf7807dadf03329073703f8b51e7443eddc4db8752878b6dd84cc4357689cd4b796b3a083192e9d98eacbe9e7b8af0273160c7b89846e78230a88
diff --git a/dev-python/aws-sam-translator/aws-sam-translator-1.76.0.ebuild b/dev-python/aws-sam-translator/aws-sam-translator-1.76.0.ebuild
new file mode 100644
index 000000000000..d6a4188a21e6
--- /dev/null
+++ b/dev-python/aws-sam-translator/aws-sam-translator-1.76.0.ebuild
@@ -0,0 +1,60 @@
+# Copyright 1999-2023 Gentoo Authors
+# Distributed under the terms of the GNU General Public License v2
+
+EAPI=8
+
+DISTUTILS_USE_PEP517=setuptools
+PYTHON_COMPAT=( python3_{10..11} )
+
+inherit distutils-r1
+
+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}]
+	)
+"
+
+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=
+}
diff --git a/dev-python/boto3/Manifest b/dev-python/boto3/Manifest
index 79345f0fe5ce..b2b76ba440a4 100644
--- a/dev-python/boto3/Manifest
+++ b/dev-python/boto3/Manifest
@@ -3,10 +3,12 @@ DIST boto3-1.28.53.gh.tar.gz 702652 BLAKE2B 6a64fa2c018000a6b89f47a49eaf0270a2f6
 DIST boto3-1.28.54.gh.tar.gz 703165 BLAKE2B f18666ece9f7b722915fb082c6e45280dedac4dc10e89d453c895515af623ea9658195e3e65bb17a9cfcd637a711e5f323c0d8dbd5fe00c16b7c560ef303a8e1 SHA512 e6d5a06aff033badf5fd3cc37a7324731fc15aeea7d5257223e46473958dfcbda96b67279e2c22354f705b5538a100c852a0561af2cb429a321245dc5d814e99
 DIST boto3-1.28.55.gh.tar.gz 704202 BLAKE2B 800105abff50a0cd728308458d84b6d8eab4be3f5d816d996443af82d93f4f97b9e686af7a96170a6036bfff54be8b11b8fb6ba69b8c53fad681b96a4ae2fb87 SHA512 cc0c2668926db54f8d2d071f125386def5a38f02efa4eb70814ba11a3d922e275a1ab92551d0c7546a692028bfe6f877830c739879548ea996d127ea62821b77
 DIST boto3-1.28.56.gh.tar.gz 704679 BLAKE2B b7413df6f6cfe9b0b604ac44888b4141b67d6fe275b7ae0a47676d8002dc189a93f2db8a92d2d53582f6918819841a1aa8d9a10149d2c8a19fc7c94b10d10b85 SHA512 ac7d274fbbc8e4e492eaedac61bb8c351a414c27ebebe3fa78a8ade293120a75e2cea37fc02289d15b012836da4b260296d2694428249cead270a30cbcd8a74f
+DIST boto3-1.28.57.gh.tar.gz 705839 BLAKE2B 5d536c8465de64b7a0dfff909325d719d6d36f0bf531b14211dd45f4539170e8b0c78ae1ba111028d6273d6453f4087b2de7a7b62ad6b1da115281b87d99b248 SHA512 b5277a0c03a57147e9d0cf05800b1f30059151dc019045dbaa91a36f6cd0c08b21bd4dad25d4359d594379f84b8f862e1dde306382a3cdd6070eaa300dcfd23b
 EBUILD boto3-1.28.49.ebuild 1581 BLAKE2B 0bd744caa1591cf114c8ce87e14d9af4afd13782c7e012c6701b9a13b66d913798bffa5a79753d1bd9c5928893c6b92478d9d3c8a764d59982bc864bcbd0619f SHA512 e3985f59bcdc4548dc51ca23290b3ac4d9d0b5e6f214e3e7a73dde99232ba7fde47983aa8fdd6679d148f4ab56c0b01906e431c33c3f9b8eebc7cb75f99b74dc
 EBUILD boto3-1.28.53.ebuild 1588 BLAKE2B 7868e2dbbe0ec485326e70c75cd785d0d369de83650d28b6501faaa4d21a8c1952c68c1e06659d1c4f70baf420b70edfb714e82d60dc9dfac2f494cc42066317 SHA512 a16a292694a5fd614ab03939fa6131614b287c8e475a83f40f463f0051f6404aa85413713038de60089b6489fc5fa9688bedd1d66ce578ed3fb0cd1b3c237d72
 EBUILD boto3-1.28.54.ebuild 1588 BLAKE2B 7868e2dbbe0ec485326e70c75cd785d0d369de83650d28b6501faaa4d21a8c1952c68c1e06659d1c4f70baf420b70edfb714e82d60dc9dfac2f494cc42066317 SHA512 a16a292694a5fd614ab03939fa6131614b287c8e475a83f40f463f0051f6404aa85413713038de60089b6489fc5fa9688bedd1d66ce578ed3fb0cd1b3c237d72
 EBUILD boto3-1.28.55.ebuild 1588 BLAKE2B bfcf68e1a1dffa36c71f030ad8743b59c9170c34a425a7982ee81d1fb0df1c29fdecefa7b55f373557b735d60ab51d510ca398edd4045def5fffb6d4d4d9d579 SHA512 1bca684f585a51d8b58a594c71974b36b145912550f051d6d4c84ba28bce949ec10c112a6f7bfa8f60fa362d9126d9a830243ab36595754bef02f19e02161bb8
 EBUILD boto3-1.28.56.ebuild 1588 BLAKE2B bfcf68e1a1dffa36c71f030ad8743b59c9170c34a425a7982ee81d1fb0df1c29fdecefa7b55f373557b735d60ab51d510ca398edd4045def5fffb6d4d4d9d579 SHA512 1bca684f585a51d8b58a594c71974b36b145912550f051d6d4c84ba28bce949ec10c112a6f7bfa8f60fa362d9126d9a830243ab36595754bef02f19e02161bb8
+EBUILD boto3-1.28.57.ebuild 1588 BLAKE2B bfcf68e1a1dffa36c71f030ad8743b59c9170c34a425a7982ee81d1fb0df1c29fdecefa7b55f373557b735d60ab51d510ca398edd4045def5fffb6d4d4d9d579 SHA512 1bca684f585a51d8b58a594c71974b36b145912550f051d6d4c84ba28bce949ec10c112a6f7bfa8f60fa362d9126d9a830243ab36595754bef02f19e02161bb8
 EBUILD boto3-9999.ebuild 1588 BLAKE2B bfcf68e1a1dffa36c71f030ad8743b59c9170c34a425a7982ee81d1fb0df1c29fdecefa7b55f373557b735d60ab51d510ca398edd4045def5fffb6d4d4d9d579 SHA512 1bca684f585a51d8b58a594c71974b36b145912550f051d6d4c84ba28bce949ec10c112a6f7bfa8f60fa362d9126d9a830243ab36595754bef02f19e02161bb8
 MISC metadata.xml 493 BLAKE2B 7d6324fc877ffe1d20c5369c2af0b09a7028f94d28f1841188913d0d8be7ea699c9d3f92c624992c4c96bd69615d3a1211a2483c76c56b7d3082492e43512523 SHA512 44420d8c03d5986f990b76369edfa8dfd7659b4952db3ad946fd05392ec594628a28745ad888d055d4f074d5214f61fcffafe6c04c4ab54109d45ac0371582bd
diff --git a/dev-python/boto3/boto3-1.28.57.ebuild b/dev-python/boto3/boto3-1.28.57.ebuild
new file mode 100644
index 000000000000..a37cc38af2f3
--- /dev/null
+++ b/dev-python/boto3/boto3-1.28.57.ebuild
@@ -0,0 +1,68 @@
+# Copyright 1999-2023 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
+
+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"
+
+	# botocore is x.(y+3).z
+	BOTOCORE_PV="$(ver_cut 1).$(( $(ver_cut 2) + 3)).$(ver_cut 3-)"
+fi
+
+RDEPEND="
+	>=dev-python/botocore-${BOTOCORE_PV}[${PYTHON_USEDEP}]
+	>=dev-python/jmespath-0.7.1[${PYTHON_USEDEP}]
+	>=dev-python/s3transfer-0.7.0[${PYTHON_USEDEP}]
+"
+BDEPEND="
+	test? (
+		dev-python/mock[${PYTHON_USEDEP}]
+		dev-python/pytest-xdist[${PYTHON_USEDEP}]
+	)
+"
+
+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} \
+		-p xdist -n "$(makeopts_jobs)" --dist=worksteal
+}
diff --git a/dev-python/botocore/Manifest b/dev-python/botocore/Manifest
index 9dc5c31a5132..d8e5d18f09ff 100644
--- a/dev-python/botocore/Manifest
+++ b/dev-python/botocore/Manifest
@@ -3,10 +3,12 @@ DIST botocore-1.31.53.gh.tar.gz 11950545 BLAKE2B 2fef49b98179046203470c6dc145b13
 DIST botocore-1.31.54.gh.tar.gz 11879790 BLAKE2B 8feaab92edaada974af275c81a41d6b36d6444ee1d46718b6c765aacad0450a52bf47fbcccd923f2c442400bea6cc1fb0f2fb8f6a73e3835fd16da38dc609ec4 SHA512 3dfa2212edbc9ed4bc435ec1d4f7aa8b9b9c656cd76feab6c898f57303897ee018120a069bc477fb8700111908ecaf6465229d67e6b6c5c777369b224d00c01d
 DIST botocore-1.31.55.gh.tar.gz 11883762 BLAKE2B eac01a2c463754306f2846ed914453114044b8ef0e94848d2bf0f59e01324bf8c7c366976722de7a791f482e891f005dc2f6ac4a1f3adfad92100d452b6bb3db SHA512 14bc1a6b12fd2bf08fa881f2265d1b0057c16b5001991278f07590f8f09b3237cf182a583f93a657d74c420179f0eee689debd192c254787aa8cb3fc17c79348
 DIST botocore-1.31.56.gh.tar.gz 11885802 BLAKE2B 4fd386fcc987672df88ffec5265c1fd9f18a75b3557643ad27dae67dddc485a3f787722942bca0daf277eb4d03dfe7164ede63b4f85e44182db2e248b507f9a7 SHA512 d1a1757e4c4d68122ab963bddc57304609e0b4c225f8e81c38a4a3b116312884757f36f07cf7f324d059037ff81d5b6ab2e225893c18e9ed5ce2203bc0c47aa0
+DIST botocore-1.31.57.gh.tar.gz 11899280 BLAKE2B 047cba5850b024dd4070346eb2c635696f9684a38ea458357c934295e86d33b65e3b9f8e98e5fa96d2f0ba18c68bfc970c1fe7ad13bbfc0e83ede4ae4b6dbb88 SHA512 512bfd31a3534213977f6d05cf8603222e9517cc0d95cdf0fa3c9f9565f0f08cb7e646830a5d5093df7ca5b84c82db2887648e7b7cf47411486c664c730963d9
 EBUILD botocore-1.31.49.ebuild 1592 BLAKE2B c5a131514206b9f7ef98aaed462ec767d932eeea538773e42ca99947021c1041dbffcd6e2f46d892031cc069e60a9a0ca607d9550ac1c5aeed89d1054e00a1b2 SHA512 056d3df23d41a7a44604241a9cad27b7052f065f5e4cf9fc335cc0228ff6e27cdc744cc9e1a33f5b77414dc598467ac436588e6f1e1375464b8ea5961dbec73f
 EBUILD botocore-1.31.53.ebuild 1599 BLAKE2B 8325845842cef976827216365bd3f88b7865bb4ce82764b121a42bb99d98952042223281fa66e6e31ec83e39c4fc585672fbab6426a7df79aa945df720d42a1b SHA512 ade15b4567ae00f08a0f5895d967ad3f37af15c24b3169e9319fd7d3c3a3316f34d989b225a928c8c72c2656e4c8f79d61e8b7ddd17e179adf7ff67bcbac6efb
 EBUILD botocore-1.31.54.ebuild 1599 BLAKE2B 8325845842cef976827216365bd3f88b7865bb4ce82764b121a42bb99d98952042223281fa66e6e31ec83e39c4fc585672fbab6426a7df79aa945df720d42a1b SHA512 ade15b4567ae00f08a0f5895d967ad3f37af15c24b3169e9319fd7d3c3a3316f34d989b225a928c8c72c2656e4c8f79d61e8b7ddd17e179adf7ff67bcbac6efb
 EBUILD botocore-1.31.55.ebuild 1599 BLAKE2B 8325845842cef976827216365bd3f88b7865bb4ce82764b121a42bb99d98952042223281fa66e6e31ec83e39c4fc585672fbab6426a7df79aa945df720d42a1b SHA512 ade15b4567ae00f08a0f5895d967ad3f37af15c24b3169e9319fd7d3c3a3316f34d989b225a928c8c72c2656e4c8f79d61e8b7ddd17e179adf7ff67bcbac6efb
 EBUILD botocore-1.31.56.ebuild 1599 BLAKE2B 8325845842cef976827216365bd3f88b7865bb4ce82764b121a42bb99d98952042223281fa66e6e31ec83e39c4fc585672fbab6426a7df79aa945df720d42a1b SHA512 ade15b4567ae00f08a0f5895d967ad3f37af15c24b3169e9319fd7d3c3a3316f34d989b225a928c8c72c2656e4c8f79d61e8b7ddd17e179adf7ff67bcbac6efb
+EBUILD botocore-1.31.57.ebuild 1599 BLAKE2B 8325845842cef976827216365bd3f88b7865bb4ce82764b121a42bb99d98952042223281fa66e6e31ec83e39c4fc585672fbab6426a7df79aa945df720d42a1b SHA512 ade15b4567ae00f08a0f5895d967ad3f37af15c24b3169e9319fd7d3c3a3316f34d989b225a928c8c72c2656e4c8f79d61e8b7ddd17e179adf7ff67bcbac6efb
 EBUILD botocore-9999.ebuild 1599 BLAKE2B 8325845842cef976827216365bd3f88b7865bb4ce82764b121a42bb99d98952042223281fa66e6e31ec83e39c4fc585672fbab6426a7df79aa945df720d42a1b SHA512 ade15b4567ae00f08a0f5895d967ad3f37af15c24b3169e9319fd7d3c3a3316f34d989b225a928c8c72c2656e4c8f79d61e8b7ddd17e179adf7ff67bcbac6efb
 MISC metadata.xml 499 BLAKE2B e5aaa7da26f200c09adfdf38b68f656bbccbec627cb5d966b280ac2165334e7eec659c89075bcace748f58e2ec3e7d2998e54a688d56ecea2d30653c67dfd35a SHA512 103c554d5dbd967bf9b6e418b3913d9235e7e910d012160909ce0715134ed2e37b06e6a345395f9d16ce08d1cf51f3ce458bce93c6a978fd3dca6610f2acdbd0
diff --git a/dev-python/botocore/botocore-1.31.57.ebuild b/dev-python/botocore/botocore-1.31.57.ebuild
new file mode 100644
index 000000000000..7cacb5c3f634
--- /dev/null
+++ b/dev-python/botocore/botocore-1.31.57.ebuild
@@ -0,0 +1,68 @@
+# Copyright 1999-2023 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
+
+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}]
+		dev-python/pytest-xdist[${PYTHON_USEDEP}]
+	)
+"
+
+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} -p xdist -n "$(makeopts_jobs)"
+}
diff --git a/dev-python/cffi/Manifest b/dev-python/cffi/Manifest
index 7c6ab969369a..51a4630fac0d 100644
--- a/dev-python/cffi/Manifest
+++ b/dev-python/cffi/Manifest
@@ -4,7 +4,9 @@ AUX cffi-1.15.1-py312.patch 9546 BLAKE2B 877a82b69ff99a523ff1b392b52d1d115643a32
 AUX cffi-1.15.1-python3.11-tests.patch 3023 BLAKE2B e25bd9d22b81187b0eab65073930980a2975eec3086462396cfc4796fd5273edab9af2324884c2e55880825ddd046b7ebc5054adfe57574ee691f0fa2145dcd2 SHA512 4d202f8c943bf33ea359f47aa3e53e007bc3dbeb3320a6efa302b1b1ec309b2dde72f6cfe1a591c594f3321ed5c65d61e9f79a03ba3107cd7008699686719497
 DIST cffi-1.15.1-drop-deprecated-py.patch.xz 31244 BLAKE2B 7c8a6ca1166335fbd385de35ebb636f21049a4dd9c52171ec58da08a61dc64c271b4afa2d69bf8b877a8c9747dfae6a8529615bbed69f5a8ab30ba5fc99c61f4 SHA512 9aba4b172b070a1a1719de2c35667abe4c7b27208b8ca3ecbf90bf168ed694f4524154e69fada5ff6f141a94b8a438db16239ba353fa9914b318b77e41dfd920
 DIST cffi-1.15.1.tar.gz 508501 BLAKE2B accc317385d9af7dbed3397afde63fbab63bfc935376d951802055c63796863ed102a940f192789924480b9b16751c8cf3d21caf9b262c479c61ffc977aac83c SHA512 e99cafcb029076abc29e435b490fa0573ee2856f4051b7ca8a5b38cd125d56dd9dae8b189f59ceb3d728a675da8ee83239e09e19f8b0feeddea4b186ab5173a5
+DIST cffi-1.16.0.tar.gz 512873 BLAKE2B 9e8d107b3124a072e559c4a536b54a172e90f9fe51d8184dacc2914a8ffa84f2682eee9c90401325dfb0f36f3f8ea0456afc93e2b85a4fef5f07ae4475e0a76b SHA512 fd2588115092202aa9289c9d4e0a0b3e264b5e9ec1dc192950f31aeb412fd9f9d4e5c96a3f9c6762987b58ccc1e229f2012ddda89211797104df672d8ed51152
 DIST cffi-1.16.0rc2.tar.gz 512927 BLAKE2B 5bb3f9728971a113d0c939bf4127bf541eaed3730486e9b4ba57432fa8c626d7688166f431db090a1248c2d3ddeaeee18fdf940dc08d7a4d3b7fda18d2d99861 SHA512 39d0a13a1f05b8f7f2d697e2324396f34588eabf226f6de5bf50a4931671827148ed25cb2f8003d0d3f4882580d71e6e1f485a63b964dd85e17c9e8b268213e6
 EBUILD cffi-1.15.1-r3.ebuild 2132 BLAKE2B 702a49e286d5d7ff6f2dc8a7791482ec3adad7b28018c33b4194521ee9f755dff5a152c9d8b8d03dc7bc6e7df86a9146af21c13cb01efeb101bb6239ab61ba79 SHA512 591922229d5babcd4710cd7f7a97d6788e6000a6b7be51a347dec4ea807f58b70f5c4ae5a934e41b7d35684e63d21853c0663195ce85dc6104f8ea7f647c4b56
+EBUILD cffi-1.16.0.ebuild 1746 BLAKE2B 2bbca063c022adcddd61da7ed5f654c15092a2d0b28c84711d2fa93a08ebb127911dc8701ba8766eed189b59341881525640e03d81ba8c00aee327ae4f82f8a6 SHA512 84773c8764bec9b3fef2a6ac0f41576e00f07e2491be762904d16219a20c92ab09121682c2d1a97fcb650abf9b18d5e95cdccc98e9858ccc4d388fa0883ee356
 EBUILD cffi-1.16.0_rc2.ebuild 1746 BLAKE2B 2bbca063c022adcddd61da7ed5f654c15092a2d0b28c84711d2fa93a08ebb127911dc8701ba8766eed189b59341881525640e03d81ba8c00aee327ae4f82f8a6 SHA512 84773c8764bec9b3fef2a6ac0f41576e00f07e2491be762904d16219a20c92ab09121682c2d1a97fcb650abf9b18d5e95cdccc98e9858ccc4d388fa0883ee356
 MISC metadata.xml 376 BLAKE2B 869698c9756447929b5607d37c334442d76fef960c109ebe3b807de5019339de4ce19009d70b2eba506ee2608db9454c277cfb07ea025a39be6ea65b2ed93f74 SHA512 84c109a295e6f272c03107b69431f213dff9042a7e5c784dc725728aeb3a60dbf9c860551aae6260e5fc2dadeaa6eb27488186abe1d108bb21145d736de7e5b6
diff --git a/dev-python/cffi/cffi-1.16.0.ebuild b/dev-python/cffi/cffi-1.16.0.ebuild
new file mode 100644
index 000000000000..8269ab390919
--- /dev/null
+++ b/dev-python/cffi/cffi-1.16.0.ebuild
@@ -0,0 +1,72 @@
+# Copyright 1999-2023 Gentoo Authors
+# Distributed under the terms of the GNU General Public License v2
+
+# please keep this ebuild at EAPI 8 -- sys-apps/portage dep
+EAPI=8
+
+# py3.12 support is experimental, expect problems in revdeps
+DISTUTILS_EXT=1
+DISTUTILS_USE_PEP517=setuptools
+# DO NOT ADD pypy to PYTHON_COMPAT
+# pypy bundles a modified version of cffi. Use python_gen_cond_dep instead.
+PYTHON_COMPAT=( python3_{10..12} )
+
+inherit distutils-r1 toolchain-funcs pypi
+
+DESCRIPTION="Foreign Function Interface for Python calling C code"
+HOMEPAGE="
+	https://cffi.readthedocs.io/
+	https://pypi.org/project/cffi/
+"
+
+LICENSE="MIT"
+SLOT="0/${PV}"
+KEYWORDS="~alpha ~amd64 ~arm ~arm64 ~hppa ~ia64 ~loong ~m68k ~mips ~ppc ~ppc64 ~riscv ~s390 ~sparc ~x86 ~amd64-linux ~x86-linux ~arm64-macos ~ppc-macos ~x64-macos ~x64-solaris"
+
+# Needs recent libffi for HPPA fixes
+DEPEND="
+	>=dev-libs/libffi-3.4.4-r1:=
+"
+# setuptools as a modern distutils provider
+RDEPEND="
+	${DEPEND}
+	dev-python/pycparser[${PYTHON_USEDEP}]
+	dev-python/setuptools[${PYTHON_USEDEP}]
+"
+BDEPEND="
+	${RDEPEND}
+	virtual/pkgconfig
+	test? (
+		dev-python/py[${PYTHON_USEDEP}]
+	)
+"
+
+distutils_enable_sphinx doc/source
+distutils_enable_tests pytest
+
+PATCHES=(
+	"${FILESDIR}"/cffi-1.14.0-darwin-no-brew.patch
+)
+
+src_prepare() {
+	if [[ ${CHOST} == *darwin* ]] ; then
+		# Don't obsessively try to find libffi
+		sed -i -e "s/.*\-iwithsysroot\/usr\/include\/ffi.*/\tpass/" setup.py || die
+	fi
+	distutils-r1_src_prepare
+}
+
+src_configure() {
+	tc-export PKG_CONFIG
+}
+
+python_test() {
+	local EPYTEST_IGNORE=(
+		# these tests call pip
+		testing/cffi0/test_zintegration.py
+	)
+
+	"${EPYTHON}" -c "import _cffi_backend as backend" || die
+	local -x PYTEST_DISABLE_PLUGIN_AUTOLOAD=1
+	epytest src/c testing
+}
diff --git a/dev-python/cycler/Manifest b/dev-python/cycler/Manifest
index d5a6a7148f70..3a42427907da 100644
--- a/dev-python/cycler/Manifest
+++ b/dev-python/cycler/Manifest
@@ -1,3 +1,5 @@
 DIST cycler-0.11.0.gh.tar.gz 19028 BLAKE2B 7726067db988e40b833ebcef4a9122fd91753925af829a0023c08081ea7f315b84fd3a5d13731dba72d2820159da45698200ca8649b65b854d48e1a114e31d81 SHA512 cdf91b861d20710b3d77ad105e54668fafa4be69e566d6a09683c638a35aa423b542a141ca0bbffd7a6cd30c8e2a629d578be88648ab9f38a0c43405f2f39613
+DIST cycler-0.12.0.gh.tar.gz 23308 BLAKE2B 7ef27c75314c860081a76004d720f66f20654d255fcc193f4c0a6473f61fcafc78b44a03631cd5d45c6ad205264d93c352bd11c25de845c537d3dd2279b69e01 SHA512 dcbaf8c8d66ae0a302f9dc7507d7064ded133ef5349f2d08cfb52beb3d7a81aa7cd0bebd5da357934431d39b6141e0e2ce344ab7f6e12b6ec6f61649bef3e5c3
 EBUILD cycler-0.11.0-r1.ebuild 662 BLAKE2B a2debdab31c06bd6aab34a92c5cb5b73fc43a97055dd0884c0a24a4893e6f6f49663000d5d66537db52229e7227eb7b775957068bf6607faef451669fca6e5b2 SHA512 4486eba632f61cb6f8b046b69a733310602073adea83efb48ede9ae8dd2cda0f9be18374d9764d118fe245981c455f760bd8922f29023f62acd80b9522fb6a7a
+EBUILD cycler-0.12.0.ebuild 670 BLAKE2B 0668012731a74033ab28fc65faed58eb44329bb8f2d4477d7bc1d004de1cd2da961e329e9df8f80a81d1cd60d341467b53a48bfeb261b02566134a52e3a969d8 SHA512 fc938eb10536c8cdffb678c9066d163dadc429c8db1deec5c647aa66a59388d3269ef47ab4ebf517f771a3f4f3e0553df0078c719f6941e13838bf7bb30386dc
 MISC metadata.xml 391 BLAKE2B 087752331eded830e84cb7448a9cd8f76a2ddce5e2be49901fca0b9de609af343bf2d6387a49a5b8344f0d5ce79077e0ec4f5bfd5283a550a43f715abdb114da SHA512 8b0f74d46825b7ade0f76faf9539ef13cfff9e946e973c1371ed5ae4404563ca1339657804acdaad5bfbf3d6c5041f0e6bd95893f8d6d9e1b1db67431bc07a0b
diff --git a/dev-python/cycler/cycler-0.12.0.ebuild b/dev-python/cycler/cycler-0.12.0.ebuild
new file mode 100644
index 000000000000..b4df8f7d8831
--- /dev/null
+++ b/dev-python/cycler/cycler-0.12.0.ebuild
@@ -0,0 +1,26 @@
+# Copyright 1999-2023 Gentoo Authors
+# Distributed under the terms of the GNU General Public License v2
+
+EAPI=8
+
+DISTUTILS_USE_PEP517=setuptools
+PYTHON_COMPAT=( python3_{10..12} pypy3 )
+
+inherit distutils-r1
+
+DESCRIPTION="Composable style cycles"
+HOMEPAGE="
+	https://matplotlib.org/cycler/
+	https://pypi.org/project/cycler/
+	https://github.com/matplotlib/cycler/
+"
+SRC_URI="
+	https://github.com/matplotlib/cycler/archive/v${PV}.tar.gz
+		-> ${P}.gh.tar.gz
+"
+
+SLOT="0"
+LICENSE="BSD"
+KEYWORDS="~alpha ~amd64 ~arm ~arm64 ~hppa ~ia64 ~loong ~m68k ~ppc ~ppc64 ~riscv ~s390 ~sparc ~x86 ~amd64-linux ~x86-linux ~arm64-macos ~ppc-macos ~x64-macos"
+
+distutils_enable_tests pytest
diff --git a/dev-python/google-auth/Manifest b/dev-python/google-auth/Manifest
index e40018f9775b..a70c53c8be1a 100644
--- a/dev-python/google-auth/Manifest
+++ b/dev-python/google-auth/Manifest
@@ -2,7 +2,9 @@ AUX google-auth-2.20.0-urllib3-2.patch 2525 BLAKE2B fec791fcbe884b0d5a1da9603798
 DIST google-auth-2.22.0.tar.gz 231433 BLAKE2B 07b813209ce3f5ff429c4f9417141fa85029ff3eedb116664d6effdf508497ce6b6552fa4c3b6f9f1e7f1ffe9b9ae8ce72c8c727d277662bb9f8214ccd152b66 SHA512 c2c04e9ad367dd96bf00af7b19c7d897dd9fe3f8e9318b7436ec85a5c146b29c273cc718932956e97b2e4a1e2f12d0d10e835b6cf0f4e46ee19f6aaeed492b5e
 DIST google-auth-2.23.0.tar.gz 231512 BLAKE2B fd7594fb28114d07773e2f0bf2da475cb1d771ef27f67765e9235883cd312b88cda092c5bcbb7a1468ded44da4e5cd121c58850058b023232725a9829969b8c3 SHA512 d5c4967478c2a2846f2297b8449cd1a9de9796f3e1a5075ac7a3c2c35a30468fe93bf5c37b7bb4305925fe5097a57fddbddc482be4446e4364a78709eec1d8cd
 DIST google-auth-2.23.1.tar.gz 232191 BLAKE2B ce828a3f04993cfd4746c096b70b5813e60acd8ed56ffc87f608f4a33a465eba4cc52a58906a7d5aeed787bf4b26b8f77fb02294181e61ed69f9036fce34dcb3 SHA512 2d8677cff7c3c6de70a4e6934a78585c098c2f2a8ca3007acb8eb4612b32ffd1ce9c841aa57f9ce043fab071dddf3bef153684541a82a80a5a914d7c377acb9b
+DIST google-auth-2.23.2.tar.gz 232207 BLAKE2B 0de53f79bd908d7194253525de07075779ffc0ed33ef71e50004773ba85aee8e7392cd5cc87ad88b5f9ce90bc3eb19c0c094d0e76311d2cd93fb0bdb62ab2450 SHA512 d443b769e6ee7de6da14e31f8beb938aaf63edecafcbedda46b253bf0380dbd78a4508a0214f7a708a09c39d1d262cc93a290ec44e89fa05da7796828f33c1fd
 EBUILD google-auth-2.22.0.ebuild 1636 BLAKE2B 184cd9afe0432f664ed53d96cbfd68277ab063c9f7ad7e2bce10840d80cfdb61fcc0475f677e2b94f1f1a6c8ed22967d3fda7537c7b1669042e1a9663332a2c4 SHA512 51c5edead6407ae45f7ca92efba32a0799b23201d2c9a475b9e4ab07ca84a6f77669aab892790481b9234721db62df6c2b39c3e74b2cd2121fb3ef4d0dc29d18
 EBUILD google-auth-2.23.0.ebuild 1656 BLAKE2B e416ecf4a60bdf1a14b556a15f0655b771ac08357210341dcb307fa0dd9f3834d86d5bf2fdc57cd1c886a9d13dcb31338ee36796078541ee6013a1d7dacfdfd4 SHA512 0cf2306868c09b083735d28e5122038dce41eb8e8f3403e17baa2997dc31832fa3f676f646ba96925303381790ca4a2a84a7674cb852c97017925cce7728b241
 EBUILD google-auth-2.23.1.ebuild 1526 BLAKE2B ea5c968ab2fb0479143155141d70d7ec6f4eeb6bf2a115f18ff6ec03b4cc64db91b658ed4101ca75db756c3af5cb74ca3a5fe115043a34d345ce8d41f42c6f0e SHA512 2e7111b48c64eddf73ea67916aa883e1f9d126a5daab969227fd36577e3c3394c0c720933bedafa0b6c34242220d647f5aaa386cfdcc57a8a3c6c89ee75e9b1a
+EBUILD google-auth-2.23.2.ebuild 1480 BLAKE2B 79680b9d542cdafceb202bf0e1f49d7c654957aa7f186e8bd61ad53dd11ce2ab0b431d7e66ae012485ebe334161d4d3a8513f1237356500aa338d580c42bfcd2 SHA512 e7a800bf2b76574ee015da9753edcd18f4a9a7cb2953ee43f2712a7ee0d1a8164d900a790a5787af106d057fa6c9e0b8686a7077b956f31e0a71386e162476d6
 MISC metadata.xml 521 BLAKE2B 784282f6a173e7746a408556d77e1277f65a41eae545b6b26054c1e506642e683c1c7d91798f3b7b690bc4f9d2f642a51c1395593177eebf1770d2a0c0ba589e SHA512 c2624ebca3dc42961e61531db4724b2b354a722f71cd7f2c194680fee50125d2251f4b94cc7e31b008a2792e74b0f55f407a1230d3f59572df9cf32ee49d2fb7
diff --git a/dev-python/google-auth/google-auth-2.23.2.ebuild b/dev-python/google-auth/google-auth-2.23.2.ebuild
new file mode 100644
index 000000000000..3136de42f585
--- /dev/null
+++ b/dev-python/google-auth/google-auth-2.23.2.ebuild
@@ -0,0 +1,60 @@
+# Copyright 1999-2023 Gentoo Authors
+# Distributed under the terms of the GNU General Public License v2
+
+EAPI=8
+
+DISTUTILS_USE_PEP517=setuptools
+PYPI_NO_NORMALIZE=1
+PYTHON_COMPAT=( python3_{10..11} )
+
+inherit distutils-r1 pypi
+
+DESCRIPTION="Google Authentication Library"
+HOMEPAGE="
+	https://github.com/googleapis/google-auth-library-python/
+	https://pypi.org/project/google-auth/
+"
+
+LICENSE="Apache-2.0"
+SLOT="0"
+KEYWORDS="~amd64 ~arm ~arm64 ~x86"
+
+RDEPEND="
+	<dev-python/cachetools-6.0.0[${PYTHON_USEDEP}]
+	>=dev-python/pyasn1-0.1.7[${PYTHON_USEDEP}]
+	>=dev-python/pyasn1-modules-0.2.1[${PYTHON_USEDEP}]
+	>=dev-python/rsa-3.1.4[${PYTHON_USEDEP}]
+"
+BDEPEND="
+	test? (
+		dev-python/cryptography[${PYTHON_USEDEP}]
+		dev-python/flask[${PYTHON_USEDEP}]
+		dev-python/freezegun[${PYTHON_USEDEP}]
+		dev-python/grpcio[${PYTHON_USEDEP}]
+		dev-python/mock[${PYTHON_USEDEP}]
+		dev-python/moto[${PYTHON_USEDEP}]
+		dev-python/pyopenssl[${PYTHON_USEDEP}]
+		dev-python/pytest-localserver[${PYTHON_USEDEP}]
+		dev-python/pyu2f[${PYTHON_USEDEP}]
+		dev-python/requests[${PYTHON_USEDEP}]
+		dev-python/responses[${PYTHON_USEDEP}]
+	)
+"
+
+distutils_enable_tests pytest
+
+python_test() {
+	local EPYTEST_IGNORE=(
+		# these are compatibility tests with oauth2client
+		# disable them to unblock removal of that package
+		tests/test__oauth2client.py
+	)
+
+	local -x PYTEST_DISABLE_PLUGIN_AUTOLOAD=1
+	epytest
+}
+
+python_compile() {
+	distutils-r1_python_compile
+	find "${BUILD_DIR}" -name '*.pth' -delete || die
+}
diff --git a/dev-python/sqlglot/Manifest b/dev-python/sqlglot/Manifest
index 087d199c1768..22c86375e1ce 100644
--- a/dev-python/sqlglot/Manifest
+++ b/dev-python/sqlglot/Manifest
@@ -1,11 +1,5 @@
-DIST sqlglot-18.5.0.tar.gz 8634825 BLAKE2B aaf1854e87fea1ba598c45b12ef142bd825fcdfed4b247d4c0ee83e360154cb8a14ff3386e1635cd735f029b357d978dc3b39295cb1a733c653ade8efeabf0f7 SHA512 d75d45da61f0cc70a845776a4bb6aefc414b42cce81be3f8b26d305476e495f08cb017930af07bbe2296e049f65ea40137256b995233069ebfc076fce0bcab78
-DIST sqlglot-18.5.1.tar.gz 8636732 BLAKE2B a1cb6e9d5cf91178996681e527f211c31c9a0f0d6bf5036ed7d824d13475f4efbd109df9eb34bc35f0e9f7e443d3ebb2634cf041bdf0e716c9d73d78f679dcbf SHA512 8bf57c14ae374c3367aecc91b239d39df3d4fbd8a6b29837cf48eae0f5116ca5c181c71ded134a771a9512430c97c9dc6f45ae9578a9110eb5729721628178c5
-DIST sqlglot-18.6.0.tar.gz 8655209 BLAKE2B cd7ba46e06cb2b537db7912d674f3d43026d111e49ba190ea2f62c9340ade1983b754437473d1d66bf2eebb18060aa8bf79082e6ffcf8144ab8c87aac36deaf4 SHA512 70a6c2d1fcaa18197d15e096690bf6beb16fbe13ea0db45a2224ab7aaf05ab8a4efae8be68fb1463c12741dc13e8e57a8ea2e75e2065c7ea3ab52a2cb6ea7d7e
-DIST sqlglot-18.7.0.tar.gz 8757398 BLAKE2B aeb6c671c00968654ef9b772df05c2277cd1a789251e13832bd63faf966bea5ec1395a65dc7db9695533f90438b86b8487119caa4f94e3a72a54978af4379dab SHA512 4f233696b595115ff2cb173533342b2bfbfb9f291f3a69f70d3c60a049b91d1d24e7365e42e096d8bc9cfdce595a006302a450c65cfb1296d052b8d59b27cc98
 DIST sqlglot-18.8.0.tar.gz 8764753 BLAKE2B f1a01a1dc939a53476d396c66e74b1ec0550f557ef2eac1bec5001229964e2838655d361612b20527fae0f8112ccc940295cd0d92e83d5ba1f272f4d9372374b SHA512 3e98ff8ad4e6061c41d90b33c7982b46b8e06680d14e989923077d61ac93d390df64df6ff182a1c87911979dd84ac493275bbc091bcdcc9a1dfce2a4091c7fa7
-EBUILD sqlglot-18.5.0.ebuild 919 BLAKE2B d6c7bf029e48f9b11c305adbc89473b9bcb7277299a869569aeefe69dd63e4ac19c9a7e3c23ba8981e6d7f46b7e4611cbfcc18b871876e949e0912c3ded446bc SHA512 5f42256d970f291e0a0eed073a1060a1e5dc15b872b1ecca6b9aeceb380c48e1bb1f1b61719a582d8bd56e01eaf8b3578fd374ee7fff761ac6a95e746b07c2f9
-EBUILD sqlglot-18.5.1.ebuild 919 BLAKE2B d6c7bf029e48f9b11c305adbc89473b9bcb7277299a869569aeefe69dd63e4ac19c9a7e3c23ba8981e6d7f46b7e4611cbfcc18b871876e949e0912c3ded446bc SHA512 5f42256d970f291e0a0eed073a1060a1e5dc15b872b1ecca6b9aeceb380c48e1bb1f1b61719a582d8bd56e01eaf8b3578fd374ee7fff761ac6a95e746b07c2f9
-EBUILD sqlglot-18.6.0.ebuild 919 BLAKE2B d6c7bf029e48f9b11c305adbc89473b9bcb7277299a869569aeefe69dd63e4ac19c9a7e3c23ba8981e6d7f46b7e4611cbfcc18b871876e949e0912c3ded446bc SHA512 5f42256d970f291e0a0eed073a1060a1e5dc15b872b1ecca6b9aeceb380c48e1bb1f1b61719a582d8bd56e01eaf8b3578fd374ee7fff761ac6a95e746b07c2f9
-EBUILD sqlglot-18.7.0.ebuild 919 BLAKE2B d6c7bf029e48f9b11c305adbc89473b9bcb7277299a869569aeefe69dd63e4ac19c9a7e3c23ba8981e6d7f46b7e4611cbfcc18b871876e949e0912c3ded446bc SHA512 5f42256d970f291e0a0eed073a1060a1e5dc15b872b1ecca6b9aeceb380c48e1bb1f1b61719a582d8bd56e01eaf8b3578fd374ee7fff761ac6a95e746b07c2f9
+DIST sqlglot-18.9.0.tar.gz 8790638 BLAKE2B c951ee964b888dadaa3fd974bad89a689e9be9e5d17f42e5387c8c97152604205df7871294cb249ce9a0f6ed6a66fb41aba0f6596851e96252444c06908b91f1 SHA512 1e24d7936e94ced97ccc290634392434c064732017fa012b270632336663faa2315658e3dfc9d3bbd94648220f412c91cb9d0d4b97b3f26a21fa2129f4fce84a
 EBUILD sqlglot-18.8.0.ebuild 919 BLAKE2B d6c7bf029e48f9b11c305adbc89473b9bcb7277299a869569aeefe69dd63e4ac19c9a7e3c23ba8981e6d7f46b7e4611cbfcc18b871876e949e0912c3ded446bc SHA512 5f42256d970f291e0a0eed073a1060a1e5dc15b872b1ecca6b9aeceb380c48e1bb1f1b61719a582d8bd56e01eaf8b3578fd374ee7fff761ac6a95e746b07c2f9
+EBUILD sqlglot-18.9.0.ebuild 919 BLAKE2B d6c7bf029e48f9b11c305adbc89473b9bcb7277299a869569aeefe69dd63e4ac19c9a7e3c23ba8981e6d7f46b7e4611cbfcc18b871876e949e0912c3ded446bc SHA512 5f42256d970f291e0a0eed073a1060a1e5dc15b872b1ecca6b9aeceb380c48e1bb1f1b61719a582d8bd56e01eaf8b3578fd374ee7fff761ac6a95e746b07c2f9
 MISC metadata.xml 635 BLAKE2B fb154da2feeea6d590b4f3edb8d8d90d316feee1b8faababc022db026254bd24674d8419b74074b089d4d8930bab642cdc5fa7694bfa9e033cb5ef4ad4988562 SHA512 dd5ed7212dc2eac6a4d84bb2e3639db1ffe163598d911073d7100a8ebfeceb85842ea2e6a597d1036d5b1388d18954b95a782af7b3a84479bf3b59ef9e9b6bf8
diff --git a/dev-python/sqlglot/sqlglot-18.5.1.ebuild b/dev-python/sqlglot/sqlglot-18.5.1.ebuild
deleted file mode 100644
index 368b77416b42..000000000000
--- a/dev-python/sqlglot/sqlglot-18.5.1.ebuild
+++ /dev/null
@@ -1,36 +0,0 @@
-# Copyright 2023 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 pypi optfeature
-
-DESCRIPTION="An easily customizable SQL parser and transpiler"
-HOMEPAGE="
-	https://sqlglot.com/
-	https://github.com/tobymao/sqlglot/
-	https://pypi.org/project/sqlglot/
-"
-
-LICENSE="MIT"
-SLOT="0"
-KEYWORDS="~amd64 ~arm64 ~x86"
-
-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"
-)
-
-distutils_enable_tests pytest
-
-pkg_postinst() {
-	optfeature "simplifying timedelta expressions" dev-python/python-dateutil
-}
diff --git a/dev-python/sqlglot/sqlglot-18.6.0.ebuild b/dev-python/sqlglot/sqlglot-18.6.0.ebuild
deleted file mode 100644
index 368b77416b42..000000000000
--- a/dev-python/sqlglot/sqlglot-18.6.0.ebuild
+++ /dev/null
@@ -1,36 +0,0 @@
-# Copyright 2023 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 pypi optfeature
-
-DESCRIPTION="An easily customizable SQL parser and transpiler"
-HOMEPAGE="
-	https://sqlglot.com/
-	https://github.com/tobymao/sqlglot/
-	https://pypi.org/project/sqlglot/
-"
-
-LICENSE="MIT"
-SLOT="0"
-KEYWORDS="~amd64 ~arm64 ~x86"
-
-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"
-)
-
-distutils_enable_tests pytest
-
-pkg_postinst() {
-	optfeature "simplifying timedelta expressions" dev-python/python-dateutil
-}
diff --git a/dev-python/sqlglot/sqlglot-18.7.0.ebuild b/dev-python/sqlglot/sqlglot-18.7.0.ebuild
deleted file mode 100644
index 368b77416b42..000000000000
--- a/dev-python/sqlglot/sqlglot-18.7.0.ebuild
+++ /dev/null
@@ -1,36 +0,0 @@
-# Copyright 2023 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 pypi optfeature
-
-DESCRIPTION="An easily customizable SQL parser and transpiler"
-HOMEPAGE="
-	https://sqlglot.com/
-	https://github.com/tobymao/sqlglot/
-	https://pypi.org/project/sqlglot/
-"
-
-LICENSE="MIT"
-SLOT="0"
-KEYWORDS="~amd64 ~arm64 ~x86"
-
-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"
-)
-
-distutils_enable_tests pytest
-
-pkg_postinst() {
-	optfeature "simplifying timedelta expressions" dev-python/python-dateutil
-}
diff --git a/dev-python/sqlglot/sqlglot-18.5.0.ebuild b/dev-python/sqlglot/sqlglot-18.9.0.ebuild
index 368b77416b42..368b77416b42 100644
--- a/dev-python/sqlglot/sqlglot-18.5.0.ebuild
+++ b/dev-python/sqlglot/sqlglot-18.9.0.ebuild
diff --git a/dev-python/wcwidth/Manifest b/dev-python/wcwidth/Manifest
index 8f477241f7fc..0363dabdb4f8 100644
--- a/dev-python/wcwidth/Manifest
+++ b/dev-python/wcwidth/Manifest
@@ -1,3 +1,5 @@
 DIST wcwidth-0.2.6.gh.tar.gz 51990 BLAKE2B 8561e06aaf92f48246bacfb4012358067d81d4d9eeb33a0406eb012b5c22841ac66ff5760df2d5ea6a5d48a1880b4b9cbbcddf7a5eba5f663f6a559005f657ad SHA512 1f97cb6ef6a804da1d062b8dafb146a3e21261e63a644bad88bed74101be1371c753c2645db5ad25868fe9641fce9b13bd5dc920496b00e1d73d406f69631ac9
+DIST wcwidth-0.2.7.gh.tar.gz 54601 BLAKE2B 5ffd919e38c1e6f160e4c5ac007c42635d93fb9300338f51928db8bf19c25fc4ac6624e8633d2166435878090a130ea2cd2a0b854db10519983f0fe4d0307a6d SHA512 3044d66bd97b05904766fa29fe3c66599767bf79361081a55f4e605f2015c990b0f1934ae875f853f4f6e8acbef1f6a56492ba63eda5b5a14dd83d0cc34588d2
 EBUILD wcwidth-0.2.6.ebuild 907 BLAKE2B 0ded135617ee71016cc0d517cb335ad8e6a8d317a9610acc88d2a21b2348013d95e8bca15eee65e01c23ba5351e88f8c2381954c5cf72ec7a227224ece0903f9 SHA512 af7404999efa015f7855be37939cfb8a1d21d3fbf31dc682f65d397c7a8d189ee8e0697e9eabe4e5963a8cd8fd16aac84531ace1d17182fcf3040237da7528cf
+EBUILD wcwidth-0.2.7.ebuild 915 BLAKE2B c8c07ab575c66360a703df3bdb507286be84cfd60509ffffe01148c646e8cfc0698e751964b36ffae726a5305bf50e298fdf2b56d3ba07d003394f561b4eeb10 SHA512 2fac44cbe22051fff219f7786b1a3aa8926a833bd3c1ddd54373063ff5bc3233099e5bd521cf4133fd4c64f03dcef96babf46ce42e27f07f7fdd577e33787848
 MISC metadata.xml 402 BLAKE2B 86714d496f80fe46cb313bed026135b2712ddfb47fea5994d0021516aa6ad28eb5fc52d37b37a7a224ec0613681b27ee039f4ac734430d94aafe4ec8946cecc7 SHA512 85c0e684f66a5582ca63d6f72c4e69101e8ec30f8e03c52e972fa36a2e6b6d2a8f019fb33a1e39e73fb37de25c82b906b18ac626afdd0a93d97db2ddcf485063
diff --git a/dev-python/wcwidth/wcwidth-0.2.7.ebuild b/dev-python/wcwidth/wcwidth-0.2.7.ebuild
new file mode 100644
index 000000000000..13a48660e0ef
--- /dev/null
+++ b/dev-python/wcwidth/wcwidth-0.2.7.ebuild
@@ -0,0 +1,39 @@
+# Copyright 1999-2023 Gentoo Authors
+# Distributed under the terms of the GNU General Public License v2
+
+EAPI=8
+
+DISTUTILS_USE_PEP517=setuptools
+PYTHON_COMPAT=( python3_{10..12} pypy3 )
+
+inherit distutils-r1
+
+DESCRIPTION="Measures number of Terminal column cells of wide-character codes"
+HOMEPAGE="
+	https://pypi.org/project/wcwidth/
+	https://github.com/jquast/wcwidth/
+"
+SRC_URI="
+	https://github.com/jquast/wcwidth/archive/${PV}.tar.gz
+		-> ${P}.gh.tar.gz
+"
+
+SLOT="0"
+LICENSE="MIT"
+KEYWORDS="~alpha ~amd64 ~arm ~arm64 ~hppa ~ia64 ~loong ~m68k ~mips ~ppc ~ppc64 ~riscv ~s390 ~sparc ~x86 ~amd64-linux ~x86-linux ~arm64-macos ~x64-macos"
+
+distutils_enable_tests pytest
+
+src_prepare() {
+	sed -e 's:--cov-append::' \
+		-e 's:--cov-report=html::' \
+		-e 's:--cov=wcwidth::' \
+		-i tox.ini || die
+	distutils-r1_src_prepare
+}
+
+python_install_all() {
+	docinto docs
+	dodoc docs/intro.rst
+	distutils-r1_python_install_all
+}