gentoo auto-resync : 14:10:2023 - 11:10:46

19 files changed, 252 insertions, 232 deletions

diff --git a/dev-python/Manifest.gz b/dev-python/Manifest.gz
index 4f1ad778558a..82cb385d4317 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 0b68b2e8cf9a..7a6d75f67a7b 100644
--- a/dev-python/aws-sam-translator/Manifest
+++ b/dev-python/aws-sam-translator/Manifest
@@ -1,5 +1,7 @@
 DIST serverless-application-model-1.76.0.gh.tar.gz 5114195 BLAKE2B 2d9eb5ea740c02ad3b6ca4024c6a5f6f87fe0a2703535eab5e69488fb30e2172ab3edd67ab4a668a9790040a0edc698c2ac4fc4c244c0b2f8037a5ce6e1175fb SHA512 97bc81cc41ecc5e1b5bc253e9ba0839598a09a49e564bfe06bd3460867412ce2551e1ad79640cf40641bdc9d09261bdd8bdb87d78c860f6c3d2b316fcee9c027
 DIST serverless-application-model-1.77.0.gh.tar.gz 5114799 BLAKE2B a5299e6a3dacca20304e3f93d84a96aa8013d435ecd62621e7fcc302c709ad86185cfa509925bebf379597186ed9fe82ac384f6314ecdc66826d8cd7df3f30c6 SHA512 961a1dcd1117b6d2c9b08c1e9b945d02ac19c9b41b91415264aadc9461fd62ece294a7da6e99ec128be685f6df605e8febf91469a1161bc94b12ae3976901f9e
+DIST serverless-application-model-1.78.0.gh.tar.gz 5115381 BLAKE2B bdb4c26a65b6740bed49ba2f830dce983f396e919b25450aa331208f63e69eb78001ce60284a6e70272c1ae1b68d110a1b865d990d100614c51e4235fbbbbb06 SHA512 36dd8e13f464d7f1502d49af2222e0716f13334f66c2f20d0423067696f2872386ae72859ac149e35a0c26df213c1bdbef8f727505a0f1a96527f7ee0e80939b
 EBUILD aws-sam-translator-1.76.0.ebuild 1544 BLAKE2B 49f4c2c4f93cad6f7a4b07beb33695a2e1c2e827d11b2cb9b12191edf9a5384602e4621bf3d3e2a01ae17d39dd1835df08b032aa7dd8eeffa008c0c87916227d SHA512 03b8539cc059818b664f4a3a04fe768b2f2ccf3f8891a5124010732588006a357ed6eeb81738dc9c52ce6cb4500bd05c1f17f4eec6cab9bc8977fb4db5d4b639
 EBUILD aws-sam-translator-1.77.0.ebuild 1546 BLAKE2B 149e59b254acf3de851a46b9a7c11d1ba15cc469c8fcd3c7571eb3e45788abb0e5db72ac54754ba65804872f895e54b2a0a39155e1ce77f7fc1f4533594fdd86 SHA512 f9304b86eaae63cf411562af33cac40848502d2e50cef5a718299b75103cb5ab2541b7ea86f41af0d511679f11ea74c2572faab81fbde4ed4547d0ec7d4e6cf9
+EBUILD aws-sam-translator-1.78.0.ebuild 1654 BLAKE2B 2d970a3617ecf601f08ccc8c24dfe666b197a7b41b0071e3a78df111566cbb4e6b18dc0b3d09a251d3584f78eeffd8a9912605ae909856032d18d3f312136133 SHA512 1518a3bdde3d0b3158cd306aaf24de14b7df6c2c920164a5311595a39353dad73777d9e1d6b40f83c13bb30dfbbbfe50f9f9dfe06929cfcf50797ec9a19d6f37
 MISC metadata.xml 603 BLAKE2B 89556267393186cf69a585c58efeb6fa599bfb42ef221bea955ea807a28edee89036a2ee0d0ca81ae55d96702a01b171b837754dabf38047ecc2789157bb7116 SHA512 106b6d241eadf7807dadf03329073703f8b51e7443eddc4db8752878b6dd84cc4357689cd4b796b3a083192e9d98eacbe9e7b8af0273160c7b89846e78230a88
diff --git a/dev-python/aws-sam-translator/aws-sam-translator-1.78.0.ebuild b/dev-python/aws-sam-translator/aws-sam-translator-1.78.0.ebuild
new file mode 100644
index 000000000000..08f492fdb3b0
--- /dev/null
+++ b/dev-python/aws-sam-translator/aws-sam-translator-1.78.0.ebuild
@@ -0,0 +1,61 @@
+# 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 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= -p xdist -n "$(makeopts_jobs)" --dist=worksteal
+}
diff --git a/dev-python/beartype/Manifest b/dev-python/beartype/Manifest
index d5b4eae9b5da..836fc8fd61b7 100644
--- a/dev-python/beartype/Manifest
+++ b/dev-python/beartype/Manifest
@@ -1,7 +1,9 @@
 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
+DIST beartype-0.16.3.tar.gz 1061171 BLAKE2B 8f8a3f8408585e3c17d3c760b137a7c9e1e8f674c369b7e749652cdc812ed3224c0f9e33b0b7c29c22140a01c0ca012e9f063f3449afd26e65fce7c6a09253aa SHA512 0274859e7722affe115637adbad031a5794d2d9e0fb49480a356c44dcf1cc54a71216faf02c3a5160e7ebee7bfbe99fa64e05a8cd47ed43f81beb5babe7acc19
 EBUILD beartype-0.15.0.ebuild 760 BLAKE2B a345abe3cef7e841b29dc99985ea96b26b5ec5c1e7c54828ef85860bc524b3fab7c5cc1b0b564cf70e8a2aa0059fc56c6db29d7c48c3c12bfc06569f67b8744d SHA512 cb692762b450a4fdb3e34fdef01cdad2dc40ba22e3f2fbfbec22efee807a0f1e661fa2d4011beb658f8fc594edd73901a5d719258a057c69d4f105ab76ac106c
 EBUILD beartype-0.16.1.ebuild 760 BLAKE2B a345abe3cef7e841b29dc99985ea96b26b5ec5c1e7c54828ef85860bc524b3fab7c5cc1b0b564cf70e8a2aa0059fc56c6db29d7c48c3c12bfc06569f67b8744d SHA512 cb692762b450a4fdb3e34fdef01cdad2dc40ba22e3f2fbfbec22efee807a0f1e661fa2d4011beb658f8fc594edd73901a5d719258a057c69d4f105ab76ac106c
 EBUILD beartype-0.16.2.ebuild 760 BLAKE2B a345abe3cef7e841b29dc99985ea96b26b5ec5c1e7c54828ef85860bc524b3fab7c5cc1b0b564cf70e8a2aa0059fc56c6db29d7c48c3c12bfc06569f67b8744d SHA512 cb692762b450a4fdb3e34fdef01cdad2dc40ba22e3f2fbfbec22efee807a0f1e661fa2d4011beb658f8fc594edd73901a5d719258a057c69d4f105ab76ac106c
+EBUILD beartype-0.16.3.ebuild 760 BLAKE2B a345abe3cef7e841b29dc99985ea96b26b5ec5c1e7c54828ef85860bc524b3fab7c5cc1b0b564cf70e8a2aa0059fc56c6db29d7c48c3c12bfc06569f67b8744d SHA512 cb692762b450a4fdb3e34fdef01cdad2dc40ba22e3f2fbfbec22efee807a0f1e661fa2d4011beb658f8fc594edd73901a5d719258a057c69d4f105ab76ac106c
 MISC metadata.xml 393 BLAKE2B f22040a947a67160c9b4c2d41db713ea69ae7a272aba75c04b1620e3f813d62718425acbc8c18716981e4176ebeabc5b60e9376d9927552ea5a36b51b7baccdd SHA512 dea8caeb6e9091672994cee213be075819d593d1034cbc7e2b076f3fc32bd2afde13b6af094956885c9ddaa72f272c6a198f4f92e7b095606fdf900a4cec47ec
diff --git a/dev-python/beartype/beartype-0.16.3.ebuild b/dev-python/beartype/beartype-0.16.3.ebuild
new file mode 100644
index 000000000000..1600c2778175
--- /dev/null
+++ b/dev-python/beartype/beartype-0.16.3.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_{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/dask/Manifest b/dev-python/dask/Manifest
index 2ce7449c8cc1..4f7b0280d4df 100644
--- a/dev-python/dask/Manifest
+++ b/dev-python/dask/Manifest
@@ -1,6 +1,8 @@
+DIST dask-2023.10.0.gh.tar.gz 8552850 BLAKE2B 407293d4f9eb385fc244d851c71fadfe3225af7953d59f5c9a2b7f3be6ee690557c6dad828fb64f444daa14c7a7db76b3a251169c01fa0b244784c1f5177bfdc SHA512 b4006414bd8e62c443729c49c1160fe002b93703b8f2f39708e6256d0013df02a72250edd5e038abd3760a704cce5349fb8cbcd76528c6b3f24b22161be20430
 DIST dask-2023.9.1.gh.tar.gz 8544717 BLAKE2B 786ca3bda6b356acdeb56070964aa25e136f9976322ae5dbaf5895eb181fc1b7582ae4731de12e7881287433d4f502dbbc5002840ebc443403a9fa76df438693 SHA512 1bf0a028059dfba70a131648f4884a6c9a091cd2d550dc7968cb2a8728ce5ef405c351f100001ab2ce48470634577104924fdf4b6dadda32308b4b5a62b3200e
 DIST dask-2023.9.2.gh.tar.gz 8544631 BLAKE2B bd0168d1ea86921235e7bd9ae3e6b9dc2abed3c3e300afea84fb3f2d462970ca5fa4d82f5479bc2c036d4f1a1ec9f63ff98151d8f339db2b14533be765b0f25f SHA512 ae7d289882d7e2e2ef46af3256cf69d8e443f5350f32088e33b46f37377fe8c8328de609d16d0a2abf4df5bc7671d88288968d3d18a535eaec1bfbf0a5adbcba
 DIST dask-2023.9.3.gh.tar.gz 8544054 BLAKE2B 4b1fc7d3b6f91fd6db0836a0fede0304e9c5e04e2aacd573eb06cf96ddf67ecbb198a185076ff94ca34216732673113e7e268482992b781777b3757d43a11773 SHA512 d91840f8a339ff0a21734726b1674c4dbc1332270fb160e01fd342b1ce1ba2fd5cea34c501c7a61e6b34e121da937701932a93ab85dc85618f5b5fc52cd960cd
+EBUILD dask-2023.10.0.ebuild 2840 BLAKE2B d21d219ebb8d6219bbcb9e3257de06b9539b86037410956d58c4fc1e33c3b2e724393ef9d79d660ba58c10ccc0f4cde6648be4620803db75f2e9e0aaa8c1223d SHA512 2e48cf018c518b4403b14009e3a5aa358a627a08e67fe600a20366019df4669628d500212e864f26d88b5f85178e5dfa007fed8e287a4c0e2090fc053196050a
 EBUILD dask-2023.9.1.ebuild 2744 BLAKE2B 884fc6c815bbffac1bb368eb74efee3ecdfb13eb0d99115d41ce52581d44e748855701c3fe3927fe4b087c56cd090c4760e0547a8a93ebf854a11fd93fae6272 SHA512 3313fb9a15aca7b867bf8bc198a6aa963c8f52214a92b89744e582fcc4ca6587213c0d19ea83b3919a3e64c7668ae088eb63c1f56e881047ef5f9b561e3e3878
 EBUILD dask-2023.9.2.ebuild 2745 BLAKE2B 16fc9fa5481e2d5a6578bd1e413a9f2d9325a70bdcb3cf27a67bf04a125b8f25c408caa7c8b03886c6da7df85a472918035caac495ac8a097fa9435bcec07836 SHA512 d41be063c2a4389045d5ae61ae82b43964791ae142232aad716e7938900670afa21a1a425721682e3799a6a308653838777452bedad150c2ce997b7c1217a977
 EBUILD dask-2023.9.3.ebuild 2840 BLAKE2B d21d219ebb8d6219bbcb9e3257de06b9539b86037410956d58c4fc1e33c3b2e724393ef9d79d660ba58c10ccc0f4cde6648be4620803db75f2e9e0aaa8c1223d SHA512 2e48cf018c518b4403b14009e3a5aa358a627a08e67fe600a20366019df4669628d500212e864f26d88b5f85178e5dfa007fed8e287a4c0e2090fc053196050a
diff --git a/dev-python/dask/dask-2023.10.0.ebuild b/dev-python/dask/dask-2023.10.0.ebuild
new file mode 100644
index 000000000000..532c80da9d4b
--- /dev/null
+++ b/dev-python/dask/dask-2023.10.0.ebuild
@@ -0,0 +1,87 @@
+# 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 multiprocessing
+
+DESCRIPTION="Task scheduling and blocked algorithms for parallel processing"
+HOMEPAGE="
+	https://www.dask.org/
+	https://github.com/dask/dask/
+	https://pypi.org/project/dask/
+"
+SRC_URI="
+	https://github.com/dask/dask/archive/${PV}.tar.gz -> ${P}.gh.tar.gz
+"
+
+LICENSE="BSD"
+SLOT="0"
+KEYWORDS="~amd64 ~arm ~arm64 ~riscv ~x86 ~amd64-linux ~x86-linux"
+
+RDEPEND="
+	>=dev-python/click-8.0[${PYTHON_USEDEP}]
+	>=dev-python/cloudpickle-1.5.0[${PYTHON_USEDEP}]
+	>=dev-python/fsspec-2021.9.0[${PYTHON_USEDEP}]
+	>=dev-python/importlib-metadata-4.13.0[${PYTHON_USEDEP}]
+	>=dev-python/numpy-1.21[${PYTHON_USEDEP}]
+	>=dev-python/pandas-1.3[${PYTHON_USEDEP}]
+	>=dev-python/packaging-20.0[${PYTHON_USEDEP}]
+	>=dev-python/partd-1.2.0[${PYTHON_USEDEP}]
+	dev-python/psutil[${PYTHON_USEDEP}]
+	>=dev-python/pyyaml-5.3.1[${PYTHON_USEDEP}]
+	>=dev-python/toolz-0.10.0[${PYTHON_USEDEP}]
+"
+BDEPEND="
+	dev-python/toolz[${PYTHON_USEDEP}]
+	>=dev-python/versioneer-0.28[${PYTHON_USEDEP}]
+	test? (
+		dev-python/moto[${PYTHON_USEDEP}]
+		dev-python/numexpr[${PYTHON_USEDEP}]
+		dev-python/pytest-rerunfailures[${PYTHON_USEDEP}]
+		dev-python/pytest-xdist[${PYTHON_USEDEP}]
+		dev-python/scipy[${PYTHON_USEDEP}]
+	)
+"
+
+distutils_enable_tests pytest
+
+src_prepare() {
+	# fails with sqlalchemy-2.0, even though we don't use it x_x
+	sed -i -e '/RemovedIn20Warning/d' pyproject.toml || die
+	sed -i -e 's:--cov-config=pyproject.toml::' pyproject.toml || die
+	distutils-r1_src_prepare
+}
+
+python_test() {
+	local EPYTEST_DESELECT=(
+		# more tests relying on -Werror
+		"dask/array/tests/test_overlap.py::test_map_overlap_no_depth[None]"
+		dask/array/tests/test_random.py::test_RandomState_only_funcs
+		# TODO
+		dask/array/tests/test_reductions.py::test_mean_func_does_not_warn
+		dask/tests/test_config.py::test__get_paths
+		dask/array/tests/test_linalg.py::test_solve_assume_a
+		"dask/dataframe/tests/test_dataframe.py::test_repartition_npartitions[<lambda>0-float-5-1-True]"
+		"dask/dataframe/tests/test_dataframe.py::test_repartition_npartitions[<lambda>1-float-5-1-True]"
+		dask/array/tests/test_image.py::test_preprocess
+		dask/tests/test_system.py::test_cpu_count_cgroups_v2
+		# require sqlalchemy<2.0
+		dask/dataframe/io/tests/test_sql.py
+	)
+
+	if ! has_version -b "dev-python/pyarrow[parquet,${PYTHON_USEDEP}]"; then
+		EPYTEST_DESELECT+=(
+			# fails if pyarrow is installed without USE=parquet
+			# (optional dep, skipped if it's not installed at all)
+			dask/dataframe/io/tests/test_parquet.py::test_pyarrow_filter_divisions
+		)
+	fi
+
+	local -x PYTEST_DISABLE_PLUGIN_AUTOLOAD=1
+	epytest -p pytest_rerunfailures -m "not network" \
+		-p xdist -n "$(makeopts_jobs)"
+}
diff --git a/dev-python/peewee/Manifest b/dev-python/peewee/Manifest
index d907e827cfc1..ab2868e7ccfe 100644
--- a/dev-python/peewee/Manifest
+++ b/dev-python/peewee/Manifest
@@ -1,3 +1,5 @@
 DIST peewee-3.16.3.gh.tar.gz 913271 BLAKE2B c243eaa0baa1289030f294141a0fa469682272b87aa9cf89cc2ff628c0f35e6824ee6215c11c12dbc992f210afbd2c9e5efebbc9efa402d92cc2de77dd574e5f SHA512 e940c0fc78c736477b2550379912587f2129bf6c11252a04188a70d260410539ef90879dcf4145466c3276130b33c85b53db80afb5503b7b76693155d5f8abbe
+DIST peewee-3.17.0.gh.tar.gz 915412 BLAKE2B 531a021f925f41ce62822fe9a0f28dd9505c1890e02b42b6b9efb9ced15e56f531c564e3412104d5d10f5ef578c728d64e3f57d9c72a03e2c4b7f7d22d639647 SHA512 978a911aa0236246abcc3cc2ef54d418dc8f94bf78ce6eeeeaf43352d92ccb4238c66972b78a904d3ceed47736a2c509fbdde837e7660290faf220e5744b1cfa
 EBUILD peewee-3.16.3.ebuild 1012 BLAKE2B 6f5b1356a757c2de3623a22a172e2ee432269604ac8d3e4a4dc073d8be7c0193f8e68019c404e22524b29228beeb2a0c3e2d6a9aaaf8f17d13703eab87baca82 SHA512 420d773c69a1ae66bfa48c6c6efd0051db67a8456f79c784d2e4578ef34a910b0701300fddeacea7ff742be5e90041b465ac2145f3254aa32004535f842de74b
+EBUILD peewee-3.17.0.ebuild 1045 BLAKE2B e6de1e1bec6f0451016cafd54a21daa149be1ed1cfc113bac0c1d7a46cbcb3e2ccae050ac022af4d0528b9cd901ba046507de7f46621029b8b7d115f5314981f SHA512 21fd06b58ccaa44d4425f97ab02c163263f3641bbb86bb415514ee3398a1c793a5c49a42357e2179d8f7870dd662a53d52628b0c85a2b432a5c5aefd10fbb848
 MISC metadata.xml 493 BLAKE2B 60dbc97d8a2acf239b6ae84ae48153ec7985399ef588de5fd3d5e06db137353ba8440eeb811fe90edb66aef70550c514c23f53cf8ee2c5e8146504dae71cef19 SHA512 28227e81ad41534f8dc80dc478cb72e116aa3d5259bb91dd20121fcadd803a04715a986e21d4302a0c8129a4fcafbd71645636b0e5b3384a661f3ee93d41fde2
diff --git a/dev-python/peewee/peewee-3.17.0.ebuild b/dev-python/peewee/peewee-3.17.0.ebuild
new file mode 100644
index 000000000000..a604cf4242f7
--- /dev/null
+++ b/dev-python/peewee/peewee-3.17.0.ebuild
@@ -0,0 +1,57 @@
+# Copyright 1999-2023 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} )
+PYTHON_REQ_USE="sqlite"
+
+inherit distutils-r1
+
+DESCRIPTION="Small Python ORM"
+HOMEPAGE="
+	https://github.com/coleifer/peewee/
+	https://pypi.org/project/peewee/
+"
+SRC_URI="
+	https://github.com/coleifer/peewee/archive/${PV}.tar.gz
+		-> ${P}.gh.tar.gz
+"
+
+LICENSE="BSD"
+SLOT="0"
+KEYWORDS="~amd64 ~riscv ~x86"
+IUSE="examples +native-extensions test"
+RESTRICT="!test? ( test )"
+
+DEPEND="
+	native-extensions? ( dev-db/sqlite:3= )
+"
+RDEPEND="
+	${DEPEND}
+"
+BDEPEND="
+	dev-python/cython[${PYTHON_USEDEP}]
+"
+
+distutils_enable_sphinx docs \
+	dev-python/sphinx-rtd-theme
+
+src_compile() {
+	if ! use native-extensions; then
+		local -x NO_SQLITE=1
+	fi
+
+	distutils-r1_src_compile
+}
+
+python_test() {
+	"${EPYTHON}" runtests.py -v 2 || die "tests failed under ${EPYTHON}"
+}
+
+python_install_all() {
+	use examples && DOCS=( examples/ )
+	distutils-r1_python_install_all
+}
diff --git a/dev-python/pika/Manifest b/dev-python/pika/Manifest
index 74ab607a89b8..653fdd51bb4f 100644
--- a/dev-python/pika/Manifest
+++ b/dev-python/pika/Manifest
@@ -1,3 +1,3 @@
-DIST pika-1.3.1.gh.tar.gz 321628 BLAKE2B c473ec22dc20d0bdf87848b37dbca6d7c1a0581e23e89dbd6b7de382575133ae0c7db6ae505585297fd3253d948df35c74b801ff2a72c8e8cc5a53ddbfabcc48 SHA512 5b3b785f74cd11433198dfb9b423daae9f3acac6cee158638ac793d1bd575296d0d6425165f3f00338a65f89f48e1c2795725e7a4f791e815a5837b25c69ba46
-EBUILD pika-1.3.1.ebuild 1526 BLAKE2B 09da436cf92825d79be2d14a29337a33e09d134a182499b85f597e2d862eae76d26cc3cb9a58991bed2a8c07d92efdbb3876c8e6e52dd47cb219e8a49da81621 SHA512 ef4f7e9db7274f2f69bba6c56225e859fd3209573316a421bd6bbc581e3863894162df0411c92bc45b9d56254c91d70ff811feab3c3efbaa4d8db8a794f322e0
+DIST pika-1.3.2.gh.tar.gz 323647 BLAKE2B 30cd1154bd35708a29a924d6f0f646ebdd3737745ba588e5d56fd2ae6b2a138005352475b346738b5eea66adadedb0c50fa9411f659c4f6c6b81bc9bf048c7fb SHA512 86c1c33db808274052cbe18af68bef685fafa260f692d16dcd3ce6259107c343ebdd3482713a7948583566581defa6037f3344d03b11c50458432d044d8b2057
+EBUILD pika-1.3.2.ebuild 1526 BLAKE2B 09da436cf92825d79be2d14a29337a33e09d134a182499b85f597e2d862eae76d26cc3cb9a58991bed2a8c07d92efdbb3876c8e6e52dd47cb219e8a49da81621 SHA512 ef4f7e9db7274f2f69bba6c56225e859fd3209573316a421bd6bbc581e3863894162df0411c92bc45b9d56254c91d70ff811feab3c3efbaa4d8db8a794f322e0
 MISC metadata.xml 679 BLAKE2B 1db50c96bdf43def09d0e2fbd0a9ca50eeee10dca95cadb0ed942fe3d6d376e55131fdcff03195ecd3531afe6f7580aab345939f11f0c98166b2d779b46572be SHA512 3b72153d645da660448e2b9a36d0f5eec9052529a6209c8740cd418cc57743033fcef3f9db12cd0158d601c1bdfa15ff125396aca9dfc5635a1557f99af6fa70
diff --git a/dev-python/pika/pika-1.3.1.ebuild b/dev-python/pika/pika-1.3.2.ebuild
index 75b80c3792f5..75b80c3792f5 100644
--- a/dev-python/pika/pika-1.3.1.ebuild
+++ b/dev-python/pika/pika-1.3.2.ebuild
diff --git a/dev-python/sqlglot/Manifest b/dev-python/sqlglot/Manifest
index 34ae5edfa212..5fff0221bfd4 100644
--- a/dev-python/sqlglot/Manifest
+++ b/dev-python/sqlglot/Manifest
@@ -1,17 +1,5 @@
-DIST sqlglot-18.10.1.tar.gz 8803525 BLAKE2B 4e500eb9239fc5a3169a8f00aa022ff579f750c5c4c13e0906a4a6749216051a8b1f69d83b1d5f1ab118abb20f79b83f7881c5cef74d8d8a1066be1fcc1e588f SHA512 09ae7bb28cedd6d9c267694dbc38dcea75a860fb54e60d412f78a36629abba70e1be42683b220eec918f9f59782ce014625e1e7b15d17bc57dcf3658d49b95b7
-DIST sqlglot-18.11.2.tar.gz 8833005 BLAKE2B eee98c392bd40cc552cdb09a6d4e60ff21d0f75c59d2961994409de7ac44d702c28aa01472e4406dbb6c8ac4d3496e71fc4ac2bea5e82c48d47cdd98111d5e79 SHA512 855686bd8bdaba68f564dbff0005c0362c83b146fd5d6da3a3d948657384201d2fe825a758f960650f540dcaef5c073197fdfb34fe788331d20bcaf44f03a10a
-DIST sqlglot-18.11.3.tar.gz 8835268 BLAKE2B 040cd5cc449ff57e6107cf23a4973df622754300e4a8010f43e85de0394dc79c4d5c12c80304f9ac3519515702d8c753e59449fd2f96d9cab9e10d926b9f9980 SHA512 948bea3055e05e843aa9b8c9ea83c8435256bd645e02ae3fc0a3de987852c6e96fadf0e5b914ddac10d12ece3b7dc982ef9467564666eac14b07baf53838339a
-DIST sqlglot-18.11.4.tar.gz 8842825 BLAKE2B ce41cc8b15af33b2af18d91b55d778503d4534959a82c6af00402e39e71585578c60a967e217f1e3dbb8ede0bc650c4afdeced6aacf77699a963441716a85f60 SHA512 a6b8674573421852966751b07da847e68e20310c0ca90d6f5a0d31a74927a68b9b6381a47924080915330aa0e08afe3515263ea552c5c338b5369d7a17b87ece
-DIST sqlglot-18.11.6.tar.gz 8851597 BLAKE2B 1d24c900dbe688a6aa94e714030af21e8ba91122078b1402d09c9a513ba59a2d4ff6afa5e239c6c6f00195bdada51a0970343bc2c1cb34c597df734323be2ca0 SHA512 64cd95dedb2ed53526a6b51f9a323fbe38e33f85fd828e1a5dd81c09771ede35b34c83103fe3563331cb6134b393a64fce7acca969a603942642724673222e47
 DIST sqlglot-18.12.0.tar.gz 8854252 BLAKE2B 30bd8a7a8d4dd2337c61b4bddcce74a35a7594ed6ac16e0c68f3103c54c1eb9499246d2ec340ae3ebb137a09a2fb29c4a9e0a82eacef959c9cac1204fa68da0d SHA512 0ac80e9f51f68121f5cf7ac7db08832ac48e706dcdb966ab1c432d4d81dc808221e3b45fd6bf31f570ff7add1a49de2f82a8671b8c81d27efb402776c20d6fd3
-DIST sqlglot-18.8.0.tar.gz 8764753 BLAKE2B f1a01a1dc939a53476d396c66e74b1ec0550f557ef2eac1bec5001229964e2838655d361612b20527fae0f8112ccc940295cd0d92e83d5ba1f272f4d9372374b SHA512 3e98ff8ad4e6061c41d90b33c7982b46b8e06680d14e989923077d61ac93d390df64df6ff182a1c87911979dd84ac493275bbc091bcdcc9a1dfce2a4091c7fa7
-DIST sqlglot-18.9.0.tar.gz 8790638 BLAKE2B c951ee964b888dadaa3fd974bad89a689e9be9e5d17f42e5387c8c97152604205df7871294cb249ce9a0f6ed6a66fb41aba0f6596851e96252444c06908b91f1 SHA512 1e24d7936e94ced97ccc290634392434c064732017fa012b270632336663faa2315658e3dfc9d3bbd94648220f412c91cb9d0d4b97b3f26a21fa2129f4fce84a
-EBUILD sqlglot-18.10.1.ebuild 919 BLAKE2B d6c7bf029e48f9b11c305adbc89473b9bcb7277299a869569aeefe69dd63e4ac19c9a7e3c23ba8981e6d7f46b7e4611cbfcc18b871876e949e0912c3ded446bc SHA512 5f42256d970f291e0a0eed073a1060a1e5dc15b872b1ecca6b9aeceb380c48e1bb1f1b61719a582d8bd56e01eaf8b3578fd374ee7fff761ac6a95e746b07c2f9
-EBUILD sqlglot-18.11.2.ebuild 919 BLAKE2B d6c7bf029e48f9b11c305adbc89473b9bcb7277299a869569aeefe69dd63e4ac19c9a7e3c23ba8981e6d7f46b7e4611cbfcc18b871876e949e0912c3ded446bc SHA512 5f42256d970f291e0a0eed073a1060a1e5dc15b872b1ecca6b9aeceb380c48e1bb1f1b61719a582d8bd56e01eaf8b3578fd374ee7fff761ac6a95e746b07c2f9
-EBUILD sqlglot-18.11.3.ebuild 919 BLAKE2B d6c7bf029e48f9b11c305adbc89473b9bcb7277299a869569aeefe69dd63e4ac19c9a7e3c23ba8981e6d7f46b7e4611cbfcc18b871876e949e0912c3ded446bc SHA512 5f42256d970f291e0a0eed073a1060a1e5dc15b872b1ecca6b9aeceb380c48e1bb1f1b61719a582d8bd56e01eaf8b3578fd374ee7fff761ac6a95e746b07c2f9
-EBUILD sqlglot-18.11.4.ebuild 919 BLAKE2B d6c7bf029e48f9b11c305adbc89473b9bcb7277299a869569aeefe69dd63e4ac19c9a7e3c23ba8981e6d7f46b7e4611cbfcc18b871876e949e0912c3ded446bc SHA512 5f42256d970f291e0a0eed073a1060a1e5dc15b872b1ecca6b9aeceb380c48e1bb1f1b61719a582d8bd56e01eaf8b3578fd374ee7fff761ac6a95e746b07c2f9
-EBUILD sqlglot-18.11.6.ebuild 919 BLAKE2B d6c7bf029e48f9b11c305adbc89473b9bcb7277299a869569aeefe69dd63e4ac19c9a7e3c23ba8981e6d7f46b7e4611cbfcc18b871876e949e0912c3ded446bc SHA512 5f42256d970f291e0a0eed073a1060a1e5dc15b872b1ecca6b9aeceb380c48e1bb1f1b61719a582d8bd56e01eaf8b3578fd374ee7fff761ac6a95e746b07c2f9
+DIST sqlglot-18.13.0.tar.gz 8873766 BLAKE2B 4dfe6d3d6332bedf13229d2820a12ead44ffcaad0f3f68bb1578d62c325173fddd73f9033277cb0ed8cdfa8e919464ce0efa51ba7dc2a946e725c1698f2afdf8 SHA512 6ed3d4eca1496b800c677b45df5499f96266e09b3c0909b8af9c4512a1bab7b7cfabaf89dad6353af2f579211364597b1ffb0f55975ffcd8c3f520802621e9aa
 EBUILD sqlglot-18.12.0.ebuild 919 BLAKE2B d6c7bf029e48f9b11c305adbc89473b9bcb7277299a869569aeefe69dd63e4ac19c9a7e3c23ba8981e6d7f46b7e4611cbfcc18b871876e949e0912c3ded446bc SHA512 5f42256d970f291e0a0eed073a1060a1e5dc15b872b1ecca6b9aeceb380c48e1bb1f1b61719a582d8bd56e01eaf8b3578fd374ee7fff761ac6a95e746b07c2f9
-EBUILD sqlglot-18.8.0.ebuild 919 BLAKE2B d6c7bf029e48f9b11c305adbc89473b9bcb7277299a869569aeefe69dd63e4ac19c9a7e3c23ba8981e6d7f46b7e4611cbfcc18b871876e949e0912c3ded446bc SHA512 5f42256d970f291e0a0eed073a1060a1e5dc15b872b1ecca6b9aeceb380c48e1bb1f1b61719a582d8bd56e01eaf8b3578fd374ee7fff761ac6a95e746b07c2f9
-EBUILD sqlglot-18.9.0.ebuild 919 BLAKE2B d6c7bf029e48f9b11c305adbc89473b9bcb7277299a869569aeefe69dd63e4ac19c9a7e3c23ba8981e6d7f46b7e4611cbfcc18b871876e949e0912c3ded446bc SHA512 5f42256d970f291e0a0eed073a1060a1e5dc15b872b1ecca6b9aeceb380c48e1bb1f1b61719a582d8bd56e01eaf8b3578fd374ee7fff761ac6a95e746b07c2f9
+EBUILD sqlglot-18.13.0.ebuild 919 BLAKE2B d6c7bf029e48f9b11c305adbc89473b9bcb7277299a869569aeefe69dd63e4ac19c9a7e3c23ba8981e6d7f46b7e4611cbfcc18b871876e949e0912c3ded446bc SHA512 5f42256d970f291e0a0eed073a1060a1e5dc15b872b1ecca6b9aeceb380c48e1bb1f1b61719a582d8bd56e01eaf8b3578fd374ee7fff761ac6a95e746b07c2f9
 MISC metadata.xml 635 BLAKE2B fb154da2feeea6d590b4f3edb8d8d90d316feee1b8faababc022db026254bd24674d8419b74074b089d4d8930bab642cdc5fa7694bfa9e033cb5ef4ad4988562 SHA512 dd5ed7212dc2eac6a4d84bb2e3639db1ffe163598d911073d7100a8ebfeceb85842ea2e6a597d1036d5b1388d18954b95a782af7b3a84479bf3b59ef9e9b6bf8
diff --git a/dev-python/sqlglot/sqlglot-18.11.2.ebuild b/dev-python/sqlglot/sqlglot-18.11.2.ebuild
deleted file mode 100644
index 368b77416b42..000000000000
--- a/dev-python/sqlglot/sqlglot-18.11.2.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.11.3.ebuild b/dev-python/sqlglot/sqlglot-18.11.3.ebuild
deleted file mode 100644
index 368b77416b42..000000000000
--- a/dev-python/sqlglot/sqlglot-18.11.3.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.11.4.ebuild b/dev-python/sqlglot/sqlglot-18.11.4.ebuild
deleted file mode 100644
index 368b77416b42..000000000000
--- a/dev-python/sqlglot/sqlglot-18.11.4.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.11.6.ebuild b/dev-python/sqlglot/sqlglot-18.11.6.ebuild
deleted file mode 100644
index 368b77416b42..000000000000
--- a/dev-python/sqlglot/sqlglot-18.11.6.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.10.1.ebuild b/dev-python/sqlglot/sqlglot-18.13.0.ebuild
index 368b77416b42..368b77416b42 100644
--- a/dev-python/sqlglot/sqlglot-18.10.1.ebuild
+++ b/dev-python/sqlglot/sqlglot-18.13.0.ebuild
diff --git a/dev-python/sqlglot/sqlglot-18.8.0.ebuild b/dev-python/sqlglot/sqlglot-18.8.0.ebuild
deleted file mode 100644
index 368b77416b42..000000000000
--- a/dev-python/sqlglot/sqlglot-18.8.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.9.0.ebuild b/dev-python/sqlglot/sqlglot-18.9.0.ebuild
deleted file mode 100644
index 368b77416b42..000000000000
--- a/dev-python/sqlglot/sqlglot-18.9.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
-}