Adding metadata

35 files changed, 787 insertions, 1 deletions

diff --git a/dev-python/argh/Manifest b/dev-python/argh/Manifest
index 620921cd65db..6418fc11876c 100644
--- a/dev-python/argh/Manifest
+++ b/dev-python/argh/Manifest
@@ -1,2 +1,3 @@
 DIST argh-0.28.1.tar.gz 62511 BLAKE2B fb06ad73c5d8e8508103007a2213285f52f4d245ade288504616d42847c982a27ca94f0850f87052737c17740de705a9f8557fcafbea6f656e30ca1ed99efffb SHA512 c5d4515f5ba94a60dbcc6fa81812c192b51539ceee349129028a3d736ba1b0eac23135b31fa6d350e9fff778250365848e6c2077553849aeebbb9b67be6774dc
 DIST argh-0.29.3.tar.gz 52641 BLAKE2B c9cdfbf9a958ce6386984c422717cf9dbcdf6bf69a909e34fcc34a3b6cc3e8f9ee831898fb1fbe39cef68927a949d172b553fb51c16a7ae80382c03be0a26d57 SHA512 ec5c090399e824d0e6dc51b199859e40707d5a7f3b651ef72b186d8b3bf402096e9522b6eaf90bbaeb3ad58aae24c25f043749698c47e3fabbb6259e9b9dbffc
+DIST argh-0.29.4.tar.gz 52694 BLAKE2B 6d2b75200ea7b570ac199139ba7bc92b5bfa41fa4e21d19eff17d8506c4a28c6043413a25679cab52f9d81b8bb9a1f35b77ffee3beaa98c43660ad9e5c6b8dfc SHA512 017346afb237429de1228f604a763f919528fd359edfabb7b5a5c3a48c5e5be5a5a385672d54299cd15e5bc82257d8c33816fbc463873ffb9b3c3a54b40fccfc
diff --git a/dev-python/argh/argh-0.29.4.ebuild b/dev-python/argh/argh-0.29.4.ebuild
new file mode 100644
index 000000000000..93c4e05017d2
--- /dev/null
+++ b/dev-python/argh/argh-0.29.4.ebuild
@@ -0,0 +1,28 @@
+# Copyright 1999-2023 Gentoo Authors
+# Distributed under the terms of the GNU General Public License v2
+
+EAPI=8
+
+DISTUTILS_USE_PEP517=flit
+PYTHON_COMPAT=( python3_{8,9,10,11} pypy3 )
+
+inherit distutils-r1 pypi
+
+DESCRIPTION="A simple argparse wrapper"
+HOMEPAGE="
+	https://pythonhosted.org/argh/
+	https://github.com/neithere/argh/
+	https://pypi.org/project/argh/
+"
+
+SLOT="0"
+KEYWORDS="~alpha ~amd64 ~arm ~arm64 ~hppa ~ia64 ~m68k ~ppc ~ppc64 ~riscv ~s390 ~sparc ~x86"
+LICENSE="LGPL-3"
+
+BDEPEND="
+	test? (
+		dev-python/iocapture[${PYTHON_USEDEP}]
+	)
+"
+
+distutils_enable_tests pytest
diff --git a/dev-python/argparse-manpage/Manifest b/dev-python/argparse-manpage/Manifest
index c4c4627c897b..13ed6c96deff 100644
--- a/dev-python/argparse-manpage/Manifest
+++ b/dev-python/argparse-manpage/Manifest
@@ -1,2 +1,3 @@
 DIST argparse-manpage-4.3.gh.tar.gz 54479 BLAKE2B de6b6a5c449eebbd4aae207cfeadc6b16baf33e4ed0b6cc886921ee2e2dcdb48ae25f160dd6679da26fc6566fa483a864bc6dd4a0af800b853452405007f58c0 SHA512 9541ddcbddbd12c2fd0d72cc229d453d5d1d25eb915123c26b9040c6a97db6a72bb4002ada5a86620e9caff7c9bc588f1ee7d0c8241b6369cfb28b0271afdbc3
 DIST argparse-manpage-4.4.gh.tar.gz 54603 BLAKE2B 2068e5eb8cf6eecdc4128e0cbb47927577f636178a38ae9ed18cb6aa42baa1dc814b95cb67b3299bd62fc1a63bc25db53cf844b24261b1e2bef9b3dd649cad11 SHA512 d2e1978fec14b6e13d1004a1ae779829c4a584f6fc4e10bd3f5651f72095a1fe010856fec26f6a504c8ce47c95b0124a427f2853c4936987c347ecfb42d28ac1
+DIST argparse-manpage-4.5.gh.tar.gz 54783 BLAKE2B a348ad06990126965b48c64db209f13c91d68329fba57e4287b1a2ac7c246a25aedc25b70bfc01fd19b72c5700a67193da4ef47106a5b8ea863edf859ea07ecd SHA512 b9b166d2469d0fc6c9f6d1112bef553c1de32d1f558be4ef4f9b739b94d83acba2712eb9d324d9f3437bf421b833336c0eab34061ccd7b3cf810591705078bf2
diff --git a/dev-python/argparse-manpage/argparse-manpage-4.5.ebuild b/dev-python/argparse-manpage/argparse-manpage-4.5.ebuild
new file mode 100644
index 000000000000..f32e24346ad0
--- /dev/null
+++ b/dev-python/argparse-manpage/argparse-manpage-4.5.ebuild
@@ -0,0 +1,41 @@
+# Copyright 2022-2023 Gentoo Authors
+# Distributed under the terms of the GNU General Public License v2
+
+EAPI=8
+
+DISTUTILS_USE_PEP517=setuptools
+PYTHON_COMPAT=( python3_{8,9,10,11} pypy3 )
+
+inherit distutils-r1
+
+DESCRIPTION="Automatically build man-pages for your Python project"
+HOMEPAGE="
+	https://github.com/praiskup/argparse-manpage/
+	https://pypi.org/project/argparse-manpage/
+"
+SRC_URI="
+	https://github.com/praiskup/${PN}/archive/v${PV}.tar.gz
+		-> ${P}.gh.tar.gz
+"
+
+LICENSE="Apache-2.0"
+SLOT="0"
+KEYWORDS="~amd64 ~arm64 ~ppc ~sparc ~x86"
+
+RDEPEND="
+	$(python_gen_cond_dep '
+		dev-python/tomli[${PYTHON_USEDEP}]
+	' 3.10)
+"
+BDEPEND="
+	test? (
+		dev-python/pip[${PYTHON_USEDEP}]
+	)
+"
+
+distutils_enable_tests pytest
+
+python_test() {
+	local -x COLUMNS=80
+	epytest
+}
diff --git a/dev-python/astroid/Manifest b/dev-python/astroid/Manifest
index 75a449ba13c4..abe3e6d51e53 100644
--- a/dev-python/astroid/Manifest
+++ b/dev-python/astroid/Manifest
@@ -1 +1,2 @@
 DIST astroid-2.15.6.gh.tar.gz 462156 BLAKE2B f5df204a0b635d29165da1566afd9259ff26102fef3b56685ad9e10fe1cdae35aa90b1e1f81293e591c03122e980936dfd91b521dfe7a4c8cfacb8b40bcac9d6 SHA512 20c4d316176b84d61b5f44823026926e84c7de3c3a6febaa23cf9c8c5a9507ce65168804a61cb2db0ffcc7ec0ecb687282e6c794485135203cc25d30064e0047
+DIST astroid-2.15.7.gh.tar.gz 462906 BLAKE2B 7a984f9f7c67c2956958b23ee2ca94c1f86284d8a50aaedbe10b9dca887802189cba21f19ee66b394f347f415d61946aaff52e4d0448271edba77b6bd958fa0e SHA512 716665744915d8a635ac124f03ffe6f7aee6bde6d98c238551ea1c6468595d6c327bb2d5605f66e7ba6294ec1b79c85b861034acba8a4584095ba38e24f82ae9
diff --git a/dev-python/astroid/astroid-2.15.7.ebuild b/dev-python/astroid/astroid-2.15.7.ebuild
new file mode 100644
index 000000000000..721c1d26b2c4
--- /dev/null
+++ b/dev-python/astroid/astroid-2.15.7.ebuild
@@ -0,0 +1,67 @@
+# 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_{8,9,10,11} )
+
+inherit distutils-r1
+
+DESCRIPTION="Abstract Syntax Tree for logilab packages"
+HOMEPAGE="
+	https://github.com/pylint-dev/astroid/
+	https://pypi.org/project/astroid/
+"
+SRC_URI="
+	https://github.com/pylint-dev/astroid/archive/v${PV}.tar.gz
+		-> ${P}.gh.tar.gz
+"
+
+LICENSE="LGPL-2.1+"
+SLOT="0"
+KEYWORDS="~alpha ~amd64 ~arm ~arm64 ~hppa ~ia64 ~loong ~m68k ~mips ~ppc ~ppc64 ~riscv ~s390 ~sparc ~x86"
+
+# Version specified in pyproject.toml
+RDEPEND="
+	>=dev-python/lazy-object-proxy-1.4.0[${PYTHON_USEDEP}]
+	dev-python/setuptools[${PYTHON_USEDEP}]
+	<dev-python/wrapt-2[${PYTHON_USEDEP}]
+	$(python_gen_cond_dep '
+		>=dev-python/typing-extensions-4.0.0[${PYTHON_USEDEP}]
+	' 3.9 3.10)
+"
+BDEPEND="
+	dev-python/setuptools-scm[${PYTHON_USEDEP}]
+	test? (
+		dev-python/numpy[${PYTHON_USEDEP}]
+		dev-python/python-dateutil[${PYTHON_USEDEP}]
+	)
+"
+
+distutils_enable_tests pytest
+
+export SETUPTOOLS_SCM_PRETEND_VERSION=${PV}
+
+python_test() {
+	local EPYTEST_DESELECT=(
+		# no clue why they're broken
+		tests/test_modutils.py::GetModulePartTest::test_known_values_get_builtin_module_part
+		tests/test_regrtest.py::NonRegressionTests::test_numpy_distutils
+		tests/brain/test_regex.py::TestRegexBrain::test_regex_pattern_and_match_subscriptable
+		# some problem with warnings (our options?)
+		tests/test_decorators.py::TestDeprecationDecorators::test_deprecated_default_argument_values_one_arg
+		tests/test_decorators.py::TestDeprecationDecorators::test_deprecated_default_argument_values_two_args
+		tests/test_scoped_nodes.py::test_deprecation_of_doc_attribute
+		# requires six bundled in urllib3, sigh
+		tests/test_modutils.py::test_file_info_from_modpath__SixMetaPathImporter
+		# requires pip, and looks suspicious anyway
+		tests/test_manager.py::IsolatedAstroidManagerTest::test_no_user_warning
+		# pydantic-2?
+		tests/brain/test_dataclasses.py::test_pydantic_field
+	)
+
+	# Faker causes sys.path_importer_cache keys to be overwritten
+	# with PosixPaths
+	epytest -p no:faker
+}
diff --git a/dev-python/beartype/Manifest b/dev-python/beartype/Manifest
index aa309f4d8d96..cc58e84e8005 100644
--- a/dev-python/beartype/Manifest
+++ b/dev-python/beartype/Manifest
@@ -1,2 +1,3 @@
 DIST beartype-0.15.0.tar.gz 1002709 BLAKE2B 96aa96135c4e361790856bea3e905afe6cc04b9f4de1e51c9287fcc72917fc7e60e5201cbb147b163499034669e219adf88f727fcb32801eff57a76779186a66 SHA512 3736891230aa8e46145a458d9cca1c62ecb8772b0ed82c56d97fd8e6c86d19dd091d74b1ee0ab5fa5d28218a87d378e514242c53488d56ef8363b054db268de2
 DIST beartype-0.16.1.tar.gz 1039772 BLAKE2B ba3fb71f72c2b332ace7c653d61a8e60546af4f4385dab0676b48759783df33c352edab813c888dc20289044089f7a650c3d56789fc218a044519d0f6982892d SHA512 71ecfaed4113ff1e05a5ba4eef5321da3af7c19bfc53d92906ae2d1c45e5eb8aa4602a3bbd296b242b2a000e03198267ece9c5e963e5216517ad170661e98198
+DIST beartype-0.16.2.tar.gz 1043099 BLAKE2B 9d71ec55db5429036b9ff8aba7b4c4b8332fb21100e746040ddf92689e55566a8bdb6bbff08eace7a3782b41e75f1e5c7a3d23304dacfd9332b327fd0623533c SHA512 a6c374f96084f0da29733b5fdc145f37de73214a9905e501a9bd30e0ab503165875cb876b2e8d9735971718696a5f3f50d9ee7c8aa12c34df29f6ed7e729c02c
diff --git a/dev-python/beartype/beartype-0.16.2.ebuild b/dev-python/beartype/beartype-0.16.2.ebuild
new file mode 100644
index 000000000000..7590019d5f42
--- /dev/null
+++ b/dev-python/beartype/beartype-0.16.2.ebuild
@@ -0,0 +1,35 @@
+# Copyright 2022-2023 Gentoo Authors
+# Distributed under the terms of the GNU General Public License v2
+
+EAPI=8
+
+DISTUTILS_USE_PEP517=setuptools
+PYTHON_COMPAT=( python3_{8,9,10,11} )
+
+inherit distutils-r1 pypi
+
+DESCRIPTION="Unbearably fast runtime type checking in pure Python"
+HOMEPAGE="
+	https://pypi.org/project/beartype/
+	https://github.com/beartype/beartype/
+"
+
+LICENSE="MIT"
+SLOT="0"
+KEYWORDS="~amd64"
+
+BDEPEND="
+	test? (
+		dev-python/mypy[${PYTHON_USEDEP}]
+		dev-python/numpy[${PYTHON_USEDEP}]
+	)
+"
+
+distutils_enable_tests pytest
+
+EPYTEST_DESELECT=(
+	# fragile performance test
+	beartype_test/a00_unit/a90_decor/test_decorwrapper.py::test_wrapper_fail_obj_large
+	# test for building docs, apparently broken too
+	beartype_test/a90_func/z90_lib/a00_sphinx
+)
diff --git a/dev-python/boto3/Manifest b/dev-python/boto3/Manifest
index 80c1dd65ad87..5179cdde982c 100644
--- a/dev-python/boto3/Manifest
+++ b/dev-python/boto3/Manifest
@@ -15,3 +15,4 @@ DIST boto3-1.28.49.gh.tar.gz 700443 BLAKE2B 7c76e0ee6d6de1f7a67534a49e54092a564d
 DIST boto3-1.28.50.gh.tar.gz 700837 BLAKE2B 57dd760ef175b16a9aebfa86d39a6529809f22101a1cab3334f239d23ef6f865fa573dcf38e5aab66aee5ea3c448c91c21bff78835a3d07de8508397c5e809fa SHA512 8b31a6012b398c067b927ac4c428fa61f881a88afb865d88a407d9c06fc69a402778198afa7f39ee158f61e952956f18f6f32edbf076098eda5431e92c06f5cc
 DIST boto3-1.28.51.gh.tar.gz 701097 BLAKE2B a9e4fd188bae4a6969d68bc089c350326fc50832442d4962e8168c56bb466c4583f3be9db18828c4e55a15859f8a1f864d2f1f1db4819141edc193dbcb28eb6e SHA512 e982b7c9a2fdcc562b866313c95ac558e42735addf512b9ec21793811c1bec1f8647cea41fb61fe06ed12c7b9390da3a5e281128857d150b5693046d277faf11
 DIST boto3-1.28.52.gh.tar.gz 701947 BLAKE2B 49a7585e53601bd57a63ec11ececa2bbda79975bbf4b40afe956799de4a8f795c049b3a98d211817ccb25c6cb23689e2a6028d341e3d047b7df7bff10e4ea482 SHA512 da32914e1bda4b624ffd6a0b4ca4d1bfee4d10d38b09bc4c5035a28bd948d4dffc2ef529e667e768b260988ab32a477d1b3668cf4a67ac33fb52bd4816779395
+DIST boto3-1.28.53.gh.tar.gz 702652 BLAKE2B 6a64fa2c018000a6b89f47a49eaf0270a2f694f02720c0e0527b5ce671bf3ad195f40fa592829bbe9a3b30ede56fd335a81bb30f862bfc6992883dd86d6b9a75 SHA512 750d4905625b207d05842950349eeadaef9bbb413adfc8096998292edeec8985c5488c565f3b5b6f5a00354e69f3071ad1491428b1f894be2b40b23db767be36
diff --git a/dev-python/boto3/boto3-1.28.53.ebuild b/dev-python/boto3/boto3-1.28.53.ebuild
new file mode 100644
index 000000000000..e654679ffe12
--- /dev/null
+++ b/dev-python/boto3/boto3-1.28.53.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_{8,9,10,11} )
+
+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.6.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 e8280f82f712..0f4aeb3ec4b2 100644
--- a/dev-python/botocore/Manifest
+++ b/dev-python/botocore/Manifest
@@ -15,3 +15,4 @@ DIST botocore-1.31.49.gh.tar.gz 11946203 BLAKE2B 3b3026f0861705cc3467391c673d2e2
 DIST botocore-1.31.50.gh.tar.gz 11946516 BLAKE2B 84f9eadc8c2867286d098e9f429c097bcd58b02898779ff3b4ee390af91c3949675b43ea954e2c393b897f97941326fbf0a9d477df015f2406e00f77629e79ed SHA512 53157bb104f10e711b409a31ede6ccce6be7ae013474ca42248db0afd7dcaae0f9f5ec0637a9c337c2691de79a0df743fc3bde69c16ef746b6274d4bd252bbff
 DIST botocore-1.31.51.gh.tar.gz 11946778 BLAKE2B 59dddb63a9d6d4944498d34af28bc6325a4867986fd7240bc4c1937572574eccc8563ddcb768f2053c85b4d9b6fc73e670f453b588519dae4a526b0ee54db17c SHA512 a7ba6922fc1cb14da7611a316a6ad7c846b4521829b55b6896365f0f2a6563bf3bcf456699d9d94febc4917ce9d23105542190eff6c97dc7a1d027d95057c655
 DIST botocore-1.31.52.gh.tar.gz 11951798 BLAKE2B cdb703fac2244c64ebaaf2b869a48121c6145f54ab9804d172b3ea03f2cffc23b5db72ea0728a0c27c8116d939a5f8413124c2c4026e68c27427f0c214b15ea1 SHA512 775616106aa1013f884c7513b2b445c9e138c21a30e9b7f3b5a17a364d8d7abee4248ef0962e8617641de4e7e0f924c61bbb98c6498ef2096aae2d0cdaff0996
+DIST botocore-1.31.53.gh.tar.gz 11950545 BLAKE2B 2fef49b98179046203470c6dc145b13a1ff4ddec4eb3ac0bc8f9668b4d7ef9dfdee096f91abb8ede1e1abfffe55f72c9c38c63587b79082a2de7de84e4c9f273 SHA512 2c4d9761ee3cc8b73e60de3388475c64cbd562efd8265a098ba49731751d2c501167d84b010984a0dd738bb1e71a85db6f86aea68c86e9db5ed8613304570529
diff --git a/dev-python/botocore/botocore-1.31.53.ebuild b/dev-python/botocore/botocore-1.31.53.ebuild
new file mode 100644
index 000000000000..10b7950a4ee2
--- /dev/null
+++ b/dev-python/botocore/botocore-1.31.53.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_{8,9,10,11} )
+
+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/cfn-lint/Manifest b/dev-python/cfn-lint/Manifest
index f108f2cdb2fb..ba80eb95b8b2 100644
--- a/dev-python/cfn-lint/Manifest
+++ b/dev-python/cfn-lint/Manifest
@@ -1,3 +1,4 @@
 DIST cfn-lint-0.79.11.tar.gz 3701364 BLAKE2B 434b342a638a241accacd3686b52642737b8b5cce53f4561b3c25029ae3f9a39169cf179591538658658e0d4f39e2b5e61a632b6ef1a00d7e66127ada82e9ada SHA512 757d4fdf0786c312e44204e53b0788edb56a3f7848f858dcc2995943d200c7af0149dad073fa6daee7e109e83e07b4b34f81352c2ec851128a02d012e66e92c8
 DIST cfn-lint-0.79.9.tar.gz 3699097 BLAKE2B d85d520b2bbba0c61766716bbc3222ce5cfd6cb467f215c7914a3996682ac86c5feb11ff01f946641cba0cafb7c1a7cf1a081a76f37dd3daa0e03a4a59b35d7c SHA512 ad11ad76cf48a4c1661ef2b627fcf3c9eed08183a6c4401df826c75818f77d7878332ad2915ebc6dcf833eb15f886124fb15d83b46e9e1add88f911edf30db11
 DIST cfn-lint-0.80.2.tar.gz 3738744 BLAKE2B 2de27228f303b37c005a6d947e5d4b9cfc940a2a7c7686956f8e7ac2e17d9a94104af7f43731c8defee643c5ed6cba8c24044af55db8462dd734442ae0637532 SHA512 c4ab580498a6de918fbac12786db461897068cccbb87d04d90f91e10befcf8e9190a8c165ee13ff137575d6a1e7b0999506c4fe9caa45c5e1123a23bb24fea24
+DIST cfn-lint-0.80.3.tar.gz 3685775 BLAKE2B 3b8d233e64d2060b124eb560aa963c3ae06a53a68f0e2ad1e7824a4b136ba0bb3ab2c7a3b5bcd72e3350531672cd1da4b98ad8bd1348b6efc80a8adce7e276a8 SHA512 d5afd13db145200d4ca9679a41436b48e92e391db2c5a9f60feffbe735a3ef013b11f2d2bdee4fa04da862b99cabf5a4aa62648418ce68eeddc9dff0f95235c1
diff --git a/dev-python/cfn-lint/cfn-lint-0.80.3.ebuild b/dev-python/cfn-lint/cfn-lint-0.80.3.ebuild
new file mode 100644
index 000000000000..e6c7715a4279
--- /dev/null
+++ b/dev-python/cfn-lint/cfn-lint-0.80.3.ebuild
@@ -0,0 +1,65 @@
+# 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_{8,9,10,11} )
+
+inherit distutils-r1 pypi
+
+DESCRIPTION="CloudFormation Linter"
+HOMEPAGE="
+	https://github.com/aws-cloudformation/cfn-lint/
+	https://pypi.org/project/cfn-lint/
+"
+
+LICENSE="MIT"
+SLOT="0"
+KEYWORDS="~amd64 ~arm ~arm64 ~riscv ~x86"
+
+RDEPEND="
+	>=dev-python/aws-sam-translator-1.73.0[${PYTHON_USEDEP}]
+	dev-python/jsonpatch[${PYTHON_USEDEP}]
+	>=dev-python/jschema_to_python-1.2.3[${PYTHON_USEDEP}]
+	<dev-python/jsonschema-5[${PYTHON_USEDEP}]
+	>=dev-python/jsonschema-3.0[${PYTHON_USEDEP}]
+	dev-python/junit-xml[${PYTHON_USEDEP}]
+	<dev-python/networkx-4[${PYTHON_USEDEP}]
+	>dev-python/pyyaml-5.4[${PYTHON_USEDEP}]
+	>=dev-python/requests-2.15.0[${PYTHON_USEDEP}]
+	>=dev-python/regex-2021.7.1[${PYTHON_USEDEP}]
+	>=dev-python/sarif_om-1.0.4[${PYTHON_USEDEP}]
+	>=dev-python/sympy-1.0.0[${PYTHON_USEDEP}]
+"
+
+distutils_enable_tests pytest
+
+src_prepare() {
+	# unpin the deps
+	sed -e 's:~=[0-9.]*::' -i setup.py || die
+	distutils-r1_src_prepare
+}
+
+python_test() {
+	local EPYTEST_DESELECT=(
+		# TODO
+		test/unit/module/test_template.py::TestTemplate::test_build_graph
+		# requires git repo
+		test/unit/module/maintenance/test_update_documentation.py::TestUpdateDocumentation::test_update_docs
+		# Internet
+		test/unit/module/formatters/test_formatters.py::TestFormatters::test_sarif_formatter
+		test/unit/module/maintenance/test_update_resource_specs.py::TestUpdateResourceSpecs::test_update_resource_specs_python_3
+		# TODO: it looks as if AWS_DEFAULT_REGION didn't work
+		test/unit/module/core/test_run_cli.py::TestCli::test_bad_config
+		test/unit/module/core/test_run_cli.py::TestCli::test_override_parameters
+		test/unit/module/core/test_run_cli.py::TestCli::test_positional_template_parameters
+		test/unit/module/core/test_run_cli.py::TestCli::test_template_config
+	)
+
+	# from tox.ini
+	local -x AWS_DEFAULT_REGION=us-east-1
+	local -x PYTEST_DISABLE_PLUGIN_AUTOLOAD=1
+	epytest
+}
diff --git a/dev-python/fsspec/Manifest b/dev-python/fsspec/Manifest
index 6196359d4d16..4d51e796e883 100644
--- a/dev-python/fsspec/Manifest
+++ b/dev-python/fsspec/Manifest
@@ -1,3 +1,4 @@
 DIST filesystem_spec-2023.6.0.gh.tar.gz 386708 BLAKE2B e47825893073d969eff8c7936068c26bed270d3b65fb4407f64b5032ce8e71b7794ae6b3ae16fb08ec3e1e2f830b2fce7fa238fd8189354e8a16c618e2af7398 SHA512 ede711d22dede2deee1b36f2ca591bc96a8f1b66d6cb16cc2ad6e1776ea441a1c73382b7622262872a3f5fff92b15ba6bdabaca80fd0ed898b7ddcac02792cf7
 DIST filesystem_spec-2023.9.0.gh.tar.gz 399288 BLAKE2B 47317bf4c50dc2e4dd541100d67989c16fcd9a0d21f2b871386cf2c379389487f51af5b81420b9b455ec083e250e2bb1b0da8243b25512f6ad227b1c16357741 SHA512 4a19f24fa3e41da0aa6f7b22b1720ee093260c5b3ff9547f678ea00887f8d12cb048dad6b2a27ea3743d3cca7837a19b061a63c5d96e10227139ebdefcaec3d0
 DIST filesystem_spec-2023.9.1.gh.tar.gz 400280 BLAKE2B e964891cd2af1d3789e39e59481316ecc0e16046e262e5c8783d734ea97ee8d39ee94514af4cfd62a4f78c03973e83c630232dfda19ff045670874229704ef45 SHA512 b7f7df1c73fb6c0ce4537d99e04e8775bb3dde37a1821976d2b44015e0b3d1a85633eef73822c74871ede1032672b2b021f6944b7ecca12f9d6baed2f6c20d6a
+DIST filesystem_spec-2023.9.2.gh.tar.gz 400298 BLAKE2B ef7c7c2eac91b190277331aac30b2b03605d3e2758536f6f0d3b894b5e236aa77f3c94a05105180ba44aa438204ef636dcfae8c35c307b40f6e7b2ce8a6e1e2c SHA512 bc61ec65af387f9f11d8f48f57fc50fed657ff6f078f619dd2c6bef20e50576533e34da8452ec13af1e30be336674f2d38032b027c8e9354144b7ed7023b50fe
diff --git a/dev-python/fsspec/fsspec-2023.9.2.ebuild b/dev-python/fsspec/fsspec-2023.9.2.ebuild
new file mode 100644
index 000000000000..77903b17db10
--- /dev/null
+++ b/dev-python/fsspec/fsspec-2023.9.2.ebuild
@@ -0,0 +1,64 @@
+# Copyright 2020-2023 Gentoo Authors
+# Distributed under the terms of the GNU General Public License v2
+
+EAPI=8
+
+DISTUTILS_USE_PEP517=setuptools
+PYTHON_COMPAT=( python3_{8,9,10,11} )
+
+inherit distutils-r1
+
+MY_P=filesystem_spec-${PV}
+DESCRIPTION="A specification that python filesystems should adhere to"
+HOMEPAGE="
+	https://github.com/fsspec/filesystem_spec/
+	https://pypi.org/project/fsspec/
+"
+SRC_URI="
+	https://github.com/fsspec/filesystem_spec/archive/${PV}.tar.gz
+		-> ${MY_P}.gh.tar.gz
+"
+S=${WORKDIR}/${MY_P}
+
+LICENSE="BSD"
+SLOT="0"
+KEYWORDS="~amd64 ~arm ~arm64 ~ppc64 ~riscv ~x86"
+
+BDEPEND="
+	test? (
+		dev-python/aiohttp[${PYTHON_USEDEP}]
+		dev-python/numpy[${PYTHON_USEDEP}]
+		dev-python/pytest-asyncio[${PYTHON_USEDEP}]
+		dev-python/pytest-mock[${PYTHON_USEDEP}]
+		dev-python/requests[${PYTHON_USEDEP}]
+		dev-python/tqdm[${PYTHON_USEDEP}]
+		dev-vcs/git
+	)
+"
+
+distutils_enable_tests pytest
+
+src_test() {
+	git config --global user.email "you@example.com" || die
+	git config --global user.name "Your Name" || die
+	distutils-r1_src_test
+}
+
+EPYTEST_DESELECT=(
+	fsspec/tests/test_spec.py::test_find
+	# requires s3fs
+	fsspec/implementations/tests/test_local.py::test_urlpath_inference_errors
+	fsspec/tests/test_core.py::test_mismatch
+	# requires pyarrow, fastparquet
+	fsspec/implementations/tests/test_reference.py::test_df_single
+	fsspec/implementations/tests/test_reference.py::test_df_multi
+)
+
+EPYTEST_IGNORE=(
+	# sftp and smb require server started via docker
+	fsspec/implementations/tests/test_dbfs.py
+	fsspec/implementations/tests/test_sftp.py
+	fsspec/implementations/tests/test_smb.py
+	# unhappy about dev-python/fuse-python (?)
+	fsspec/tests/test_fuse.py
+)
diff --git a/dev-python/psycopg/Manifest b/dev-python/psycopg/Manifest
index d58e5972e327..7eb1c8b70222 100644
--- a/dev-python/psycopg/Manifest
+++ b/dev-python/psycopg/Manifest
@@ -1,4 +1,5 @@
 DIST psycopg-3.1.10.gh.tar.gz 490875 BLAKE2B 26b82aa34f0eecc3e15943390b74d82e838415564f96d6d11c65d2d705045f78231d7a0275bc74b6a1e095210d249aaaa2e2e59debd4c19cdcfbe348fe598b95 SHA512 37d1d2cbe3956862d3dbecd50505267f89a837e42e188e7ff7295c4e5e0d480efd86019ce5a88cd9b682075e2e99ec9037f83de42cb1f5dbcc370a8d3c90a474
+DIST psycopg-3.1.11.gh.tar.gz 494278 BLAKE2B 64aa508e8b53e6f6ff37c23a654c53eb1796030cefa6dadf8dbeed54999a8c45c5e6729ffa53c833aeb91d2dee08cb3bc3a74688af1c0fd34e24ed33f6b98de3 SHA512 c7b06ee1501c71a7fa125bef894d444e7987ac400b7ac4908e13ac7c60f31b93b7327664280e82bb5e4e39b4be474e31d8b154b01fa34660d8c5ddafe75d1ed4
 DIST psycopg-3.1.8.gh.tar.gz 483283 BLAKE2B 29141637c359b5ff8988753ee4e492b0aaf82bfc6445e0c5e1d9ef18f59f09ab071ce9a6183f2d864b62e85a109b24afbdd96248c00c8bb5c01357b06648ebba SHA512 4424305debc7b055fcd19b27714df46d54f8ae38452d8d5a3276df70a6c27e0094081020fdf2c34c73275cb058054414ac80843bb3e6a841bb3556ce39c76287
 DIST psycopg-3.1.9.gh.tar.gz 487052 BLAKE2B 0422742d21b872c927d8df5f85e8e64fbfc912d08db85dbb1675fa64ccec4bd849b05b1f4773898b791edf0fbcd1aa0fe2c8bc210fd1672f70fba24df10b3624 SHA512 84e48b8fa7c8f677e193585e69e31dd43b8b55379f2370753e2af99351be25c2eba0bc66f19cb1ed65b8762123cc7a8d10023810815c53a8c963c6b743822766
 DIST psycopg2-2.9.4.tar.gz 384017 BLAKE2B 4bc0afcc890c8a257c1ccd5c6e4e5301857a80f8b1428aa46c1473c9e18f5d2914a2e592c13336b06106217bb334d9b0321835bdd123f1627cbeb29dedf97bf7 SHA512 259088e42e0ab0d8a1a0ccf04f5e560f32c6179b4a0a0059e91bcf269baa8f4b0f1f949c332c640a2438c927a29b2c144078a861f8e18ba9c764da7c93c73b8d
diff --git a/dev-python/psycopg/psycopg-3.1.11.ebuild b/dev-python/psycopg/psycopg-3.1.11.ebuild
new file mode 100644
index 000000000000..86375a4b0aef
--- /dev/null
+++ b/dev-python/psycopg/psycopg-3.1.11.ebuild
@@ -0,0 +1,78 @@
+# 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_{8,9,10,11} )
+
+inherit distutils-r1
+
+DESCRIPTION="PostgreSQL database adapter for Python"
+HOMEPAGE="
+	https://www.psycopg.org/psycopg3/
+	https://github.com/psycopg/psycopg/
+	https://pypi.org/project/psycopg/
+"
+SRC_URI="
+	https://github.com/psycopg/psycopg/archive/${PV}.tar.gz
+		-> ${P}.gh.tar.gz
+"
+S=${WORKDIR}/${P}/psycopg
+
+LICENSE="LGPL-3+"
+SLOT="0"
+KEYWORDS="~alpha ~amd64 ~arm ~arm64 ~hppa ~ia64 ~ppc ~ppc64 ~riscv ~s390 ~sparc ~x86 ~amd64-linux ~x86-linux ~ppc-macos ~x64-macos"
+
+DEPEND="
+	>=dev-db/postgresql-8.1:*
+"
+RDEPEND="
+	${DEPEND}
+	>=dev-python/typing-extensions-4.1[${PYTHON_USEDEP}]
+"
+BDEPEND="
+	test? (
+		>=dev-db/postgresql-8.1[server]
+		<dev-python/anyio-4[${PYTHON_USEDEP}]
+		dev-python/dnspython[${PYTHON_USEDEP}]
+	)
+"
+
+distutils_enable_tests pytest
+
+src_test() {
+	# tests are lurking in top-level directory
+	cd .. || die
+
+	initdb -D "${T}"/pgsql || die
+	# TODO: random port
+	pg_ctl -w -D "${T}"/pgsql start \
+		-o "-h '' -k '${T}'" || die
+	createdb -h "${T}" test || die
+
+	local -x PSYCOPG_TEST_DSN="host=${T} dbname=test"
+	distutils-r1_src_test
+
+	pg_ctl -w -D "${T}"/pgsql stop || die
+}
+
+python_test() {
+	local EPYTEST_DESELECT=(
+		# tests for the psycopg_pool package
+		tests/pool
+		# some broken mypy magic
+		tests/test_module.py::test_version
+		tests/test_module.py::test_version_c
+		tests/test_typing.py
+		tests/crdb/test_typing.py
+		# TODO, relying on undefined ordering in Python?
+		tests/test_dns_srv.py::test_srv
+		# timing test, fragile to load
+		tests/test_concurrency_async.py::test_ctrl_c
+	)
+
+	# leak tests seem to be brittle
+	local -x PYTEST_DISABLE_PLUGIN_AUTOLOAD=1
+	epytest -p anyio -k "not leak"
+}
diff --git a/dev-python/pytest-xprocess/Manifest b/dev-python/pytest-xprocess/Manifest
index d80b8e72a08a..f9c2c41abdd7 100644
--- a/dev-python/pytest-xprocess/Manifest
+++ b/dev-python/pytest-xprocess/Manifest
@@ -1 +1,2 @@
 DIST pytest-xprocess-0.22.2.tar.gz 31346 BLAKE2B 07b9fdfea2ecd3d3aaf4115c2f7ecd41c864b4490694cedc54460d0f16397ebdda0ac88fd9bd1613dcaec1cb9c36571b8ab2febc8d151f8f6c4e19fe3abd0821 SHA512 2051be110dfda8063c31bb9555bff569f5d7a1332a62f8ce57fd799dfc7d8551ba1227df12f44fccc1ec62d9fcc0face104a77c9c5cc1abb583b74cd1d8a9ff7
+DIST pytest-xprocess-0.23.0.tar.gz 31350 BLAKE2B 71492aa1bbc438221c6ac2825bf2bd678a75c12e8b5a8654d333c1ba2ad5c66b21f85e572998f0e5f1835097483a4895942d664ef7d8f078cad7923a9ee2e962 SHA512 97aa2a8ba0bcca62d53c0a0523696f6ae5fec5eae29e3e2cfe1a3ec8f14622c2c31f0802b2e65b55aa16778dd6ea82951e15af768c9d84cfd13aa2d427f94c9e
diff --git a/dev-python/pytest-xprocess/pytest-xprocess-0.23.0.ebuild b/dev-python/pytest-xprocess/pytest-xprocess-0.23.0.ebuild
new file mode 100644
index 000000000000..80491ad165f1
--- /dev/null
+++ b/dev-python/pytest-xprocess/pytest-xprocess-0.23.0.ebuild
@@ -0,0 +1,27 @@
+# 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_{8,9,10,11} pypy3 )
+
+inherit distutils-r1 pypi
+
+DESCRIPTION="Manage external processes across test runs"
+HOMEPAGE="
+	https://pypi.org/project/pytest-xprocess/
+	https://github.com/pytest-dev/pytest-xprocess/
+"
+
+SLOT="0"
+LICENSE="MIT"
+KEYWORDS="~alpha ~amd64 ~arm ~arm64 ~hppa ~ia64 ~loong ~m68k ~mips ~ppc ~ppc64 ~riscv ~s390 ~sparc ~x86 ~amd64-linux ~x86-linux"
+
+RDEPEND="
+	dev-python/pytest[${PYTHON_USEDEP}]
+	dev-python/psutil[${PYTHON_USEDEP}]
+"
+
+distutils_enable_tests pytest
diff --git a/dev-python/python-lsp-jsonrpc/Manifest b/dev-python/python-lsp-jsonrpc/Manifest
index 9a28c89cd283..7bff30b697e7 100644
--- a/dev-python/python-lsp-jsonrpc/Manifest
+++ b/dev-python/python-lsp-jsonrpc/Manifest
@@ -1,3 +1,4 @@
 DIST python-lsp-jsonrpc-1.0.0.tar.gz 10011 BLAKE2B 671490d439f10eebf2d05f221adad25be6f881f4a0f4fa975d4574937a951d4d0bc51264a9ec67d3ef5d112b6e025b551685d3e3c2b959c4a6bcef92d46c5ff3 SHA512 447835fc6c3810f486d80f85295089c021b792843bdf88d461c021b8b04407d8f7e6a99c07351a23658a5dff46eb475bc64e51bdec029787cd33330b54d4dfec
 DIST python-lsp-jsonrpc-1.1.0.tar.gz 14950 BLAKE2B 061a7c2028d909dcef5a1b1235263fb6909ec6b78c71c210e26403a1c6af351138428e4d3c8360d77d7f0420d27ae9c0f1c0d8aa6bdb645aedd1ca1e85d236d7 SHA512 f62ee2177939a154251bd67f28dd9ce6fdebd39aa1d5e8993676becf7ace074a0397ff1f86c1e91b38bf5f7d06c1d9df5ab7aed00d952534c40999086c4878fe
 DIST python-lsp-jsonrpc-1.1.1.tar.gz 15151 BLAKE2B c9e5a516318e85dbd2f9da61b17507a256b7e09a657b2bf4246bfa9020de753fcb8d89082b92cf741fc7bef1b5f9d2559016cd1001d69e5b582d46eedde77e5a SHA512 2722aa038f6d2aebab4980ece7f67685d7285fa81e67ddf541478dd338dabb1279106233ec9124c40a15d4f1801c57cc3fbb9bebd5d5651355f36aae77b104d6
+DIST python-lsp-jsonrpc-1.1.2.tar.gz 15298 BLAKE2B 04c4616e63cbdee199747e87e6b21cede9b3b6d3001cf43f3d2640ab727e3c3466f914a7b870311cd08d01161d5cb8bd8a7c9ce35e24ea2a2a7b2821957a79e5 SHA512 7f8de21ca9616b725617b9aed2b2f3d991477e16065ac239559e45723713fe29fb16194145ed191df57d621d49a04e0258e9573fdabce34409fc779cae45ea82
diff --git a/dev-python/python-lsp-jsonrpc/python-lsp-jsonrpc-1.1.2.ebuild b/dev-python/python-lsp-jsonrpc/python-lsp-jsonrpc-1.1.2.ebuild
new file mode 100644
index 000000000000..1ebc23efda9b
--- /dev/null
+++ b/dev-python/python-lsp-jsonrpc/python-lsp-jsonrpc-1.1.2.ebuild
@@ -0,0 +1,38 @@
+# 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_{8,9,10,11} )
+
+inherit distutils-r1 pypi
+
+DESCRIPTION="JSON RPC 2.0 server library"
+HOMEPAGE="
+	https://github.com/python-lsp/python-lsp-jsonrpc/
+	https://pypi.org/project/python-lsp-jsonrpc/
+"
+
+LICENSE="MIT"
+SLOT="0"
+KEYWORDS="~amd64 ~arm64 ~ppc64 ~x86"
+
+RDEPEND="
+	>=dev-python/ujson-3[${PYTHON_USEDEP}]
+"
+BDEPEND="
+	test? (
+		dev-python/pycodestyle[${PYTHON_USEDEP}]
+		dev-python/pyflakes[${PYTHON_USEDEP}]
+	)
+"
+
+distutils_enable_tests pytest
+
+python_test() {
+	local -x TZ=UTC
+	local -x PYTEST_DISABLE_PLUGIN_AUTOLOAD=1
+	epytest -o addopts=
+}
diff --git a/dev-python/pyupgrade/Manifest b/dev-python/pyupgrade/Manifest
index a8f81c668414..bc38d551258f 100644
--- a/dev-python/pyupgrade/Manifest
+++ b/dev-python/pyupgrade/Manifest
@@ -1 +1,2 @@
 DIST pyupgrade-3.12.0.gh.tar.gz 63321 BLAKE2B 8b8e5f637c4cd59d5c208bd3d5a620c9462ba1998dd88ead150240fb4b2eece78d97b611b91ecc6fe800f22f19705fb97eaf38c3e3a6fa8efcf2c9cf88435849 SHA512 1d585491fb1da8ec0ac269fe3cd068f515dfea5fd54454906d91ef316bb740443e6140669a4bbc1fe762feea9e637a2f553e606695d7bfc352280b52b663e33d
+DIST pyupgrade-3.13.0.gh.tar.gz 63800 BLAKE2B b1e5c1288b36f7193aae03476ceb0009bd193d0c2801e425501580bb0c8800d7bb101587999133673f15a874956763d55cb8b920e267f135b5d5743de0666769 SHA512 9cd1392bc9522ebffc30e9f9344cbf753f930b684c7022f19d50de69463dea35ec5ea60bba4e6f5ebc74936c784beff57b44d0e7c1c83d03d21f3b57c537e243
diff --git a/dev-python/pyupgrade/pyupgrade-3.13.0.ebuild b/dev-python/pyupgrade/pyupgrade-3.13.0.ebuild
new file mode 100644
index 000000000000..7e7de8e896c4
--- /dev/null
+++ b/dev-python/pyupgrade/pyupgrade-3.13.0.ebuild
@@ -0,0 +1,30 @@
+# Copyright 2022-2023 Gentoo Authors
+# Distributed under the terms of the GNU General Public License v2
+
+EAPI=8
+
+DISTUTILS_USE_PEP517=setuptools
+PYTHON_COMPAT=( python3_{8,9,10,11} )
+
+inherit distutils-r1
+
+DESCRIPTION="Tool + pre-commit hook to automatically upgrade syntax for newer Pythons"
+HOMEPAGE="
+	https://github.com/asottile/pyupgrade/
+	https://pypi.org/project/pyupgrade/
+"
+# no tests in sdist, as of 3.3.2
+SRC_URI="
+	https://github.com/asottile/pyupgrade/archive/v${PV}.tar.gz
+		-> ${P}.gh.tar.gz
+"
+
+LICENSE="MIT"
+SLOT="0"
+KEYWORDS="~amd64 ~arm64"
+
+RDEPEND="
+	>=dev-python/tokenize-rt-5.2.0[${PYTHON_USEDEP}]
+"
+
+distutils_enable_tests pytest
diff --git a/dev-python/sqlglot/Manifest b/dev-python/sqlglot/Manifest
index 0915ba14fd09..9ea294667cd2 100644
--- a/dev-python/sqlglot/Manifest
+++ b/dev-python/sqlglot/Manifest
@@ -1,3 +1,4 @@
 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
diff --git a/dev-python/sqlglot/sqlglot-18.7.0.ebuild b/dev-python/sqlglot/sqlglot-18.7.0.ebuild
new file mode 100644
index 000000000000..19b5d607c4f4
--- /dev/null
+++ b/dev-python/sqlglot/sqlglot-18.7.0.ebuild
@@ -0,0 +1,36 @@
+# Copyright 2023 Gentoo Authors
+# Distributed under the terms of the GNU General Public License v2
+
+EAPI=8
+
+DISTUTILS_USE_PEP517=setuptools
+PYTHON_COMPAT=( python3_{8,9,10,11} )
+
+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/types-protobuf/Manifest b/dev-python/types-protobuf/Manifest
index 9eec4c7b9cd0..fcb159d18b94 100644
--- a/dev-python/types-protobuf/Manifest
+++ b/dev-python/types-protobuf/Manifest
@@ -1 +1,2 @@
 DIST types-protobuf-4.24.0.1.tar.gz 47648 BLAKE2B bed5e77f06ab0f051f8c93c212911727e7e94ba5142389fcdaaab051c5d955edc421760c7a6a9c144df74704fcab8f1a0648e4b9ab1e6f1c6aa3d7090d4d62d9 SHA512 af2324044890d6fa67102fd8d20335f2d39194c50667a19b15e936cdb9807e346e80cd16de311bc3b0f97e6a74d0f361987206f98e19d8c387af4bd57a66c6e7
+DIST types-protobuf-4.24.0.2.tar.gz 47831 BLAKE2B 9c18bbf2950bc57a46c8fbdaca05f6d0c66f55b3b11b78ffb78139135ad80e666a1db5fdba79b0f9ebdd5349812107e69ff40255737bda27651256c51b521b94 SHA512 2740c72811db1b75b5aca8bb61be54a88d724c51349f4beeaec2dd56180d929972a189ddcf88eee06c2da7085696d45c7573103797e887ded60a5c314e4885f0
diff --git a/dev-python/types-protobuf/types-protobuf-4.24.0.2.ebuild b/dev-python/types-protobuf/types-protobuf-4.24.0.2.ebuild
new file mode 100644
index 000000000000..69c1076b9806
--- /dev/null
+++ b/dev-python/types-protobuf/types-protobuf-4.24.0.2.ebuild
@@ -0,0 +1,18 @@
+# Copyright 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_{8,9,10,11} )
+inherit distutils-r1 pypi
+
+DESCRIPTION="Typing stubs for protobuf"
+HOMEPAGE="
+	https://pypi.org/project/types-protobuf/
+	https://github.com/python/typeshed/tree/master/stubs/protobuf/
+"
+LICENSE="Apache-2.0"
+SLOT="0"
+KEYWORDS="~amd64"
diff --git a/dev-python/types-requests/Manifest b/dev-python/types-requests/Manifest
index bc4d3190e4d4..fb2bdec6eb3a 100644
--- a/dev-python/types-requests/Manifest
+++ b/dev-python/types-requests/Manifest
@@ -1 +1,2 @@
 DIST types-requests-2.31.0.2.tar.gz 15293 BLAKE2B 84028b7732acd481b1898a492a1bbcb08f7fe5fe17e44d37e7b2b439275e7e38e660f07b0d28e80e741448d6e5c1fab1c99dd1cc6c52badd332e9a3f2568037e SHA512 848def44e7f43c23c3db80069c29186ca21446da2854652014bd3717af16544b4e05234310d0c2b8889d629e7aad949738f3cbbf2c44824e13a09e1c0d4689f4
+DIST types-requests-2.31.0.3.tar.gz 15346 BLAKE2B 611bcda5d380e91386a9cbf3d29f02b35769434b392b59276123d00ff37b2c56eeb2f467521c08502098d87edb1c741271187e4f6bd6065a34934016af87c7f3 SHA512 5a140b5dad8e96a82e9793aee56d16eee12a88908bf18512b275a36a3cfa7a2aa8cb4817d16552f595e5e22ddbf4a4bf4d19f7081495082d124b14d196dda875
diff --git a/dev-python/types-requests/types-requests-2.31.0.3.ebuild b/dev-python/types-requests/types-requests-2.31.0.3.ebuild
new file mode 100644
index 000000000000..fdbb24fa1e13
--- /dev/null
+++ b/dev-python/types-requests/types-requests-2.31.0.3.ebuild
@@ -0,0 +1,22 @@
+# 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_{8,9,10,11} pypy3 )
+
+inherit distutils-r1 pypi
+
+DESCRIPTION="Typing stubs for requests"
+HOMEPAGE="
+	https://pypi.org/project/types-requests/
+	https://github.com/python/typeshed/tree/master/stubs/requests
+"
+
+SLOT="0"
+LICENSE="Apache-2.0"
+KEYWORDS="~amd64"
+
+RDEPEND="dev-python/types-urllib3"
diff --git a/dev-python/versioningit/Manifest b/dev-python/versioningit/Manifest
index ef9f41e922cf..fb7650d8fb03 100644
--- a/dev-python/versioningit/Manifest
+++ b/dev-python/versioningit/Manifest
@@ -1 +1,2 @@
 DIST versioningit-2.2.0.tar.gz 742936 BLAKE2B 05bfebce378947a9196b4bd90495dc8f89fa9b79b99e5a4423ff39df77f0353125ba5f2deec1e685feacb6fbb8ee896fd1f18155b985f803be4d21e885689128 SHA512 9169bd04c29937a5d913dfa4951affe9d01f21f513fb6f704bdd65f44c91dd47c366169fd50aecc938992cb32b6cac835359b1dc9a6b431b8b5371125564791e
+DIST versioningit-2.2.1.tar.gz 743942 BLAKE2B f0f84b2323cdeac79144d842bbebfc196aecb35752da4dc0e343a709fc539eba50f33079dc652e95dc06bda8ddb761b5a68179b50f533434aafd7d4b1263af63 SHA512 9ec8d4cf26392fd3bfd29d5c3e573a6af8e6a42c6aff1d0f9dbf68a17b667c55859d64d91d5715bf232f4eea22a6f300cbfc6da2be8364186c23b5023fa0e6ad
diff --git a/dev-python/versioningit/versioningit-2.2.1.ebuild b/dev-python/versioningit/versioningit-2.2.1.ebuild
new file mode 100644
index 000000000000..183b112c3aa4
--- /dev/null
+++ b/dev-python/versioningit/versioningit-2.2.1.ebuild
@@ -0,0 +1,48 @@
+# 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_{8,9,10,11} )
+
+inherit distutils-r1 pypi
+
+DESCRIPTION="A setuptools plugin for versioning based on git tags"
+HOMEPAGE="
+	https://github.com/jwodder/versioningit/
+	https://pypi.org/project/versioningit/
+"
+
+LICENSE="MIT"
+SLOT="0"
+KEYWORDS="~amd64 ~arm ~arm64 ~riscv ~x86"
+
+RDEPEND="
+	>=dev-python/packaging-17.1[${PYTHON_USEDEP}]
+	$(python_gen_cond_dep '
+		<dev-python/tomli-3[${PYTHON_USEDEP}]
+	' 3.10)
+"
+BDEPEND="
+	test? (
+		dev-python/pydantic[${PYTHON_USEDEP}]
+		dev-python/pytest-mock[${PYTHON_USEDEP}]
+	)
+"
+
+EPYTEST_IGNORE=(
+	# Tries to do wheel/pip installs
+	test/test_end2end.py
+)
+
+distutils_enable_tests pytest
+
+python_prepare_all() {
+	sed -i -e '/-cov/d' tox.ini || die
+	distutils-r1_python_prepare_all
+}
+
+python_test() {
+	epytest -p no:pytest-describe
+}
diff --git a/dev-python/werkzeug/werkzeug-2.3.6.ebuild b/dev-python/werkzeug/werkzeug-2.3.6.ebuild
index 9ccfe91e639f..912ecea40ccc 100644
--- a/dev-python/werkzeug/werkzeug-2.3.6.ebuild
+++ b/dev-python/werkzeug/werkzeug-2.3.6.ebuild
@@ -21,7 +21,7 @@ SRC_URI="
 
 LICENSE="BSD"
 SLOT="0"
-KEYWORDS="~alpha amd64 arm arm64 hppa ~ia64 ~loong ~m68k ~mips ppc ppc64 ~riscv ~s390 ~sparc x86"
+KEYWORDS="~alpha amd64 arm arm64 hppa ~ia64 ~loong ~m68k ~mips ppc ppc64 ~riscv ~s390 sparc x86"
 IUSE="test-rust"
 
 RDEPEND="
diff --git a/dev-python/yapf/Manifest b/dev-python/yapf/Manifest
index cb8bc0303e2a..82d2860fe7c1 100644
--- a/dev-python/yapf/Manifest
+++ b/dev-python/yapf/Manifest
@@ -1 +1,2 @@
 DIST yapf-0.40.1.gh.tar.gz 226063 BLAKE2B 57dd62e32d06312a5a8964fb7822cd87321ae1548be67a1824f5d6efd90e86c629452faf71722a1dfc8f70052f63020ab88d55501c140f33660368c56cce2ea4 SHA512 7d44ea8976c93db850f0a139535962e166b4e488e47761720747686061ad7d7d3bbb2771f2e1519b7db8af630f64b7bcf71143faa56d448c9d098c2d151bffeb
+DIST yapf-0.40.2.gh.tar.gz 229593 BLAKE2B a3e614eb10577af5a627f7ddd916eee5792c02cdda3dfab7008cfec91a4ad8588be8ee6cbdb82fb5967dba21ed2760dcf2d4d99783749ec5df025bd189111fd5 SHA512 be71b622efde162d64e5143c2a27de254a3791c229046309a083fa0df00afb4170cf0427c4402d3c621ca2120210ba15aa6d124ef7b8790c4b72705f5c5342e3
diff --git a/dev-python/yapf/yapf-0.40.2.ebuild b/dev-python/yapf/yapf-0.40.2.ebuild
new file mode 100644
index 000000000000..859499b79be1
--- /dev/null
+++ b/dev-python/yapf/yapf-0.40.2.ebuild
@@ -0,0 +1,36 @@
+# Copyright 2018-2023 Gentoo Authors
+# Distributed under the terms of the GNU General Public License v2
+
+EAPI=8
+
+DISTUTILS_USE_PEP517=setuptools
+PYTHON_COMPAT=( python3_{8,9,10,11} )
+
+inherit distutils-r1
+
+DESCRIPTION="A formatter for Python files"
+HOMEPAGE="
+	https://github.com/google/yapf/
+	https://pypi.org/project/yapf/
+"
+SRC_URI="
+	https://github.com/google/yapf/archive/v${PV}.tar.gz
+		-> ${P}.gh.tar.gz
+"
+
+LICENSE="Apache-2.0"
+SLOT="0"
+KEYWORDS="~amd64 ~arm64 ~ppc64 ~x86"
+IUSE="test"
+RESTRICT="!test? ( test )"
+
+RDEPEND="
+	>=dev-python/importlib-metadata-6.6.0[${PYTHON_USEDEP}]
+	>=dev-python/platformdirs-3.5.1[${PYTHON_USEDEP}]
+	>=dev-python/tomli-2.0.1[${PYTHON_USEDEP}]
+"
+
+python_test() {
+	"${EPYTHON}" -m unittest discover -v -p '*_test.py' ||
+		die "Tests failed with ${EPYTHON}"
+}