gentoo auto-resync : 21:11:2023 - 11:12:11

23 files changed, 449 insertions, 2 deletions

diff --git a/dev-python/Manifest.gz b/dev-python/Manifest.gz
index 68cbd2db8e3c..0e5fa59ec983 100644
--- a/dev-python/Manifest.gz
+++ b/dev-python/Manifest.gz
diff --git a/dev-python/agate-excel/Manifest b/dev-python/agate-excel/Manifest
index 7460226fbad7..53f4aceaa89c 100644
--- a/dev-python/agate-excel/Manifest
+++ b/dev-python/agate-excel/Manifest
@@ -1,7 +1,9 @@
 DIST agate-excel-0.2.5.tar.gz 161131 BLAKE2B ed7306dabf8b5da722aec9005da9bdba74a9cc585ea72b429eecc4b1fcbdfed698af8e582c464081867c0d4a285b9bc892efc339f0a08c657d87e61fd1174496 SHA512 5686c3faf8b817589a62d9fac558bebe7f47124685be9f8146d74c206023530d0cec2ad88fa4ba7ac049516f5bec6783ce8f0ff47f8eb8b2ed8aad7316f1771b
 DIST agate-excel-0.3.0.tar.gz 164113 BLAKE2B f5d9d3c2225bd5df38b0f3028fdcaa61000f5bd6de05d5e490beb1f4b3184e82e76aa8a1d46845ff9795792a8dd58de075da74c27df3a4d4f7a3b6f8ffb7b501 SHA512 7d795f1086d38e736d594d9514dd154da31bb9c5de321ecaea0ce66525f2cb9bc2c1dc8bd51480fa8f4e506626560b1865de6db4c17f67148fa9269085ca53f0
 DIST agate-excel-0.4.0.tar.gz 164270 BLAKE2B a45edd9b705ab6673ee4283fc4af7337f6d0ae4a8961b96f4917a4fe74709f5c8d94193e351a996b2d08c548ac9c232f0b1f352a7bd4d22b3f8281840900f75d SHA512 ecacba1ea75a91220e2462c44b1690d4d7ef1db3bee117ef1f4993614392137197f9fd2e4aaddf27a607179c529558fde3d4faa8d2c3fbbac86926ce860ed12c
+DIST agate-excel-0.4.1.tar.gz 271433 BLAKE2B 855f60c42726d73e76cd233c607b23b2c227404dc393afa38f6bf9dc4a65708f2644a252faede3d105c440a96e51181e30f7fcf5e80f57434d47d42ca17f9ca7 SHA512 934e8c0416df2e57b617095454aca14e202df1301779814841934452faf672e27a65628efee344df2873bece3731435fa40a6831321ed59a606810bd472d23b8
 EBUILD agate-excel-0.2.5-r2.ebuild 773 BLAKE2B e2f1b7288855e0407e9ddc098134cf00195b94744a6f9ea047e276fc7489530e66f7e2ac08c01fd936d67acca44f61a28fa3b7faddbc802979f57cc49cef0364 SHA512 bad7f4a524b0770d67df4d125236f4cfaa1579fef87a98b344d950be814ccea24e8ffe9c45953cc686fa0983a5ebbdb4764b0232084cb10e768d931d57c97f85
 EBUILD agate-excel-0.3.0.ebuild 739 BLAKE2B 99deb567f272c9bcf6702d203247c6ecb55bb31d73a6acc13be5fc7557b9ed30723a1d3e922aeabd2bc6f8b6665c42fd59e2f088aa560eabf46ca6606a8696da SHA512 c507877ec642de5d16df3a83babca8d074bf9fa9da00718b22a4da1a904ffb3c08669b588d25dae53caf41bdea36af3da9f8ee5c75a5b90bb2daa7cc858db783
 EBUILD agate-excel-0.4.0.ebuild 739 BLAKE2B 99deb567f272c9bcf6702d203247c6ecb55bb31d73a6acc13be5fc7557b9ed30723a1d3e922aeabd2bc6f8b6665c42fd59e2f088aa560eabf46ca6606a8696da SHA512 c507877ec642de5d16df3a83babca8d074bf9fa9da00718b22a4da1a904ffb3c08669b588d25dae53caf41bdea36af3da9f8ee5c75a5b90bb2daa7cc858db783
+EBUILD agate-excel-0.4.1.ebuild 739 BLAKE2B 99deb567f272c9bcf6702d203247c6ecb55bb31d73a6acc13be5fc7557b9ed30723a1d3e922aeabd2bc6f8b6665c42fd59e2f088aa560eabf46ca6606a8696da SHA512 c507877ec642de5d16df3a83babca8d074bf9fa9da00718b22a4da1a904ffb3c08669b588d25dae53caf41bdea36af3da9f8ee5c75a5b90bb2daa7cc858db783
 MISC metadata.xml 646 BLAKE2B 5e94a191f3b80b83282d7f46fb79ec3f49d24aff665775387d60bd100c997ce2384598e497a836c93682133a3df5b6ea84d1a4706bc069760f1e8fb95200a49d SHA512 61f116294b6bfe310e98c6bfa4d9cdd87fc127b77954db4d7145f00a82e7779cdff4f52d3544e9e0deab1b493d70e7f498aed44e5d6486601885b218575da1b1
diff --git a/dev-python/agate-excel/agate-excel-0.4.1.ebuild b/dev-python/agate-excel/agate-excel-0.4.1.ebuild
new file mode 100644
index 000000000000..2b80eb5db7e5
--- /dev/null
+++ b/dev-python/agate-excel/agate-excel-0.4.1.ebuild
@@ -0,0 +1,34 @@
+# Copyright 2021-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..12} )
+
+inherit distutils-r1 pypi
+
+DESCRIPTION="Adds read support for Excel files (xls and xlsx) to agate"
+HOMEPAGE="
+	https://github.com/wireservice/agate-excel/
+	https://pypi.org/project/agate-excel/
+"
+
+LICENSE="MIT"
+SLOT="0"
+KEYWORDS="~amd64 ~arm64-macos ~x64-macos"
+
+RDEPEND="
+	>=dev-python/agate-1.5.0[${PYTHON_USEDEP}]
+	dev-python/olefile[${PYTHON_USEDEP}]
+	>=dev-python/openpyxl-2.3.0[${PYTHON_USEDEP}]
+	>=dev-python/xlrd-0.9.4[${PYTHON_USEDEP}]
+"
+BDEPEND="
+	test? (
+		dev-python/lxml[${PYTHON_USEDEP}]
+	)
+"
+
+distutils_enable_tests pytest
diff --git a/dev-python/boto3/Manifest b/dev-python/boto3/Manifest
index 314d22f1644a..a4c7af33017e 100644
--- a/dev-python/boto3/Manifest
+++ b/dev-python/boto3/Manifest
@@ -5,6 +5,7 @@ DIST boto3-1.29.0.gh.tar.gz 730038 BLAKE2B 3f6f853eaa18d66ffef1e159fb641e6e3d069
 DIST boto3-1.29.1.gh.tar.gz 731491 BLAKE2B 15d7aa771369afac957d1c0fac1c0cca9fb4322a7643d9dc2cb688908ab80c9f3815b92e9645266be0547d45959b6f2f20891ced2da0ab33df2de966dcfa510b SHA512 c07fb0bc3daab7aa6c21cec278b246b4df20f9e665b379f8005d2239a1d0bb637304d7308f1479b772ee314b99559bdb7f5c37503d6a9ef6801999270637cf87
 DIST boto3-1.29.2.gh.tar.gz 734398 BLAKE2B bc2816fd37130d4957873964b4020ec90f106fef5d034c4b47e9485610d577cdcac3106b66dcf20175335fcc49773dadcdabab9de65fb85caeddf5bea0845184 SHA512 dc5faf76f2949506db24888780cc07c792903707e54853258182a016b4b1b4f91ae79467e5f140ba0ce822d99e4fc570a16168211b10296bd9820eb245d9cbc5
 DIST boto3-1.29.3.gh.tar.gz 737012 BLAKE2B 4282de0bbe03b61cf6884b08cf0a16e93c1e27a0323d2eee93277f8ac62f5ef440612292ebc245f13de0bbac9c156cae0cd5c76e8ae5b7d018a125cd49a682df SHA512 e42064e2c825376dfe2a5aa0c92715d06d6d29c3cf8b194d8742c688a4743e216ba32111bba080d88505907e48ff26086106eaef62fa5048f34fcbf08355ab60
+DIST boto3-1.29.4.gh.tar.gz 737422 BLAKE2B afc98796b95bc82ca80e6fc20be8d3dd1ee786a23647628ff20822cb676bb520facd370828df1340d7515771fe879acbfde2d381109d0bb76c8fd430b1af9085 SHA512 a6b3d1aebc2594e0389acf090602276bea8ef1590f2beea285bb4dd9a8f5a81cf141a6f566c64fce5ab474830b84721f7d2833b80f06f0a531d6f64ac8c905c4
 EBUILD boto3-1.28.78.ebuild 1581 BLAKE2B 3321baf451888ad370e81162c39222de8ad2ea4217f54a1a4f3cd9818c7b612305ef84c795eff5e7f6d53991c0fee83de67b5a2edf1be8c084f69882920acac8 SHA512 c76202b2ee7ffc4810d03a1702a15829cf66816e372fd0d1acfe3cdc0415d26431a03e4e252549d6e546ab21a161af8740d915a87a2ae328814194af97f8ad8a
 EBUILD boto3-1.28.84.ebuild 1492 BLAKE2B b917bb04deee77e6b65688e46eb6a2a0bf4c4550311821f0e1ec4fe1031430d56c7052b322ad1ed8bda21caf84d18770ed0aa44357870687af79fc8795ca999b SHA512 d72328e959f9a4567bc5aab853ed06f353d5248cb4158f02fbc49684f6065c9108101d7cc3a541e6d292014c2ffd142b00b3a729a0c82ed8fb9d28b1f5d68ba0
 EBUILD boto3-1.28.85.ebuild 1492 BLAKE2B b917bb04deee77e6b65688e46eb6a2a0bf4c4550311821f0e1ec4fe1031430d56c7052b322ad1ed8bda21caf84d18770ed0aa44357870687af79fc8795ca999b SHA512 d72328e959f9a4567bc5aab853ed06f353d5248cb4158f02fbc49684f6065c9108101d7cc3a541e6d292014c2ffd142b00b3a729a0c82ed8fb9d28b1f5d68ba0
@@ -12,5 +13,6 @@ EBUILD boto3-1.29.0.ebuild 1492 BLAKE2B b917bb04deee77e6b65688e46eb6a2a0bf4c4550
 EBUILD boto3-1.29.1.ebuild 1492 BLAKE2B b917bb04deee77e6b65688e46eb6a2a0bf4c4550311821f0e1ec4fe1031430d56c7052b322ad1ed8bda21caf84d18770ed0aa44357870687af79fc8795ca999b SHA512 d72328e959f9a4567bc5aab853ed06f353d5248cb4158f02fbc49684f6065c9108101d7cc3a541e6d292014c2ffd142b00b3a729a0c82ed8fb9d28b1f5d68ba0
 EBUILD boto3-1.29.2.ebuild 1492 BLAKE2B b917bb04deee77e6b65688e46eb6a2a0bf4c4550311821f0e1ec4fe1031430d56c7052b322ad1ed8bda21caf84d18770ed0aa44357870687af79fc8795ca999b SHA512 d72328e959f9a4567bc5aab853ed06f353d5248cb4158f02fbc49684f6065c9108101d7cc3a541e6d292014c2ffd142b00b3a729a0c82ed8fb9d28b1f5d68ba0
 EBUILD boto3-1.29.3.ebuild 1492 BLAKE2B b917bb04deee77e6b65688e46eb6a2a0bf4c4550311821f0e1ec4fe1031430d56c7052b322ad1ed8bda21caf84d18770ed0aa44357870687af79fc8795ca999b SHA512 d72328e959f9a4567bc5aab853ed06f353d5248cb4158f02fbc49684f6065c9108101d7cc3a541e6d292014c2ffd142b00b3a729a0c82ed8fb9d28b1f5d68ba0
+EBUILD boto3-1.29.4.ebuild 1492 BLAKE2B b917bb04deee77e6b65688e46eb6a2a0bf4c4550311821f0e1ec4fe1031430d56c7052b322ad1ed8bda21caf84d18770ed0aa44357870687af79fc8795ca999b SHA512 d72328e959f9a4567bc5aab853ed06f353d5248cb4158f02fbc49684f6065c9108101d7cc3a541e6d292014c2ffd142b00b3a729a0c82ed8fb9d28b1f5d68ba0
 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.29.4.ebuild b/dev-python/boto3/boto3-1.29.4.ebuild
new file mode 100644
index 000000000000..0604e0996a82
--- /dev/null
+++ b/dev-python/boto3/boto3-1.29.4.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_{10..12} )
+
+inherit distutils-r1
+
+DESCRIPTION="The AWS SDK for Python"
+HOMEPAGE="
+	https://github.com/boto/boto3/
+	https://pypi.org/project/boto3/
+"
+LICENSE="Apache-2.0"
+SLOT="0"
+
+if [[ "${PV}" == "9999" ]]; then
+	EGIT_REPO_URI="https://github.com/boto/boto3"
+	inherit git-r3
+	BOTOCORE_PV=${PV}
+else
+	SRC_URI="
+		https://github.com/boto/boto3/archive/${PV}.tar.gz
+			-> ${P}.gh.tar.gz
+	"
+	KEYWORDS="~amd64 ~arm ~arm64 ~ppc ~ppc64 ~riscv ~sparc ~x86 ~amd64-linux ~x86-linux"
+
+	# 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}]
+	)
+"
+
+EPYTEST_XDIST=1
+distutils_enable_tests pytest
+
+python_prepare_all() {
+	# don't lock versions to narrow ranges
+	sed -e '/botocore/ d' \
+		-e '/jmespath/ d' \
+		-e '/s3transfer/ d' \
+		-i setup.py || die
+
+	# do not rely on bundled deps in botocore (sic!)
+	find -name '*.py' -exec sed -i \
+		-e 's:from botocore[.]vendored import:import:' \
+		-e 's:from botocore[.]vendored[.]:from :' \
+		{} + || die
+
+	distutils-r1_python_prepare_all
+}
+
+python_test() {
+	local -x PYTEST_DISABLE_PLUGIN_AUTOLOAD=1
+	epytest tests/{functional,unit}
+}
diff --git a/dev-python/botocore/Manifest b/dev-python/botocore/Manifest
index 805f36c4adad..c4bf110903e9 100644
--- a/dev-python/botocore/Manifest
+++ b/dev-python/botocore/Manifest
@@ -5,6 +5,7 @@ DIST botocore-1.32.0.gh.tar.gz 12086167 BLAKE2B 54e580c4d034b437d1e2e7748f1dd478
 DIST botocore-1.32.1.gh.tar.gz 12098630 BLAKE2B 3a2501da4bd2ec8d29f032a2df4d7946840682df426b4496f60bab487b0eb47580314b4c3029dded6a589463a8636c362c560fd4c2da02c113647ee10ebf079d SHA512 4ec58dcf896ef46f27f3c4af7c6e58efad62e5c2e3fb9aa8de9a90ee390d65b036116d9d8ba7c766b95b03e6e85e909cc620b838511152004dbcfb67968525b4
 DIST botocore-1.32.2.gh.tar.gz 12148168 BLAKE2B 29a70ed37526b8b5e3439a183b194d350505dd4ad0ac1e5d2ff729be29813b4b99b2b0806ca2f20a776efdcefc2b46295432af281e026ecf014fe45d5317c528 SHA512 775c5076e691605d6efe392e5565b84314ed7c93300ea394e5598ee34f4bb9e708a2c8479fbd646fdb619d36e0122fd4f6854e9ed40430c069677345bd76e335
 DIST botocore-1.32.3.gh.tar.gz 12176739 BLAKE2B b119a54fb4770757c8f2c75b7404e009be1c7b35598d8a97e892aa644bbcc301b5f6bb44fa0f37bc8f4523af5ca9771daeda877937e640dd557038c8283967e1 SHA512 398127e140edc33750553f33a14cdc140048f5ee03c162705c6681b9bf08d871c9ba29f824ba2b6f1b11592260c6f0614ab4c06464cdda98172e8ca81bce73e9
+DIST botocore-1.32.4.gh.tar.gz 12176332 BLAKE2B 0b0c2b1b481f88b23dad830f22dee4a79e947705a7b975cfda8f33e0154554eda930bf6e9f2d8e96b639706ae62c7b3b880e210d61e480afcd66f24375a4e754 SHA512 b3f8202a9144be2b7fa3d4030816d87a88959cb0d8340d100038e2d5c115071d272337d1570f1ff19d372bdd70a8d2643fb2e86f286e9a1d466cf0c8d84f9a1f
 EBUILD botocore-1.31.78.ebuild 1592 BLAKE2B c5a131514206b9f7ef98aaed462ec767d932eeea538773e42ca99947021c1041dbffcd6e2f46d892031cc069e60a9a0ca607d9550ac1c5aeed89d1054e00a1b2 SHA512 056d3df23d41a7a44604241a9cad27b7052f065f5e4cf9fc335cc0228ff6e27cdc744cc9e1a33f5b77414dc598467ac436588e6f1e1375464b8ea5961dbec73f
 EBUILD botocore-1.31.84.ebuild 1524 BLAKE2B 8a2471391e1a0e596e0b8d72ee09df50c3763a3d03db51169f45b1b571ba3df97eef93a43374b196ced5e1dc978bc2f3de52099675a6b19c1d5fe933922466b3 SHA512 bdde6ff5fcea64cad2e42bf6b2e8cb49f096ed5b17c321246651936878ff07347f4fea7805bb7083053aab2014c3e4a50fefcb727e89ccee3aa6a5860d71b249
 EBUILD botocore-1.31.85.ebuild 1524 BLAKE2B 8a2471391e1a0e596e0b8d72ee09df50c3763a3d03db51169f45b1b571ba3df97eef93a43374b196ced5e1dc978bc2f3de52099675a6b19c1d5fe933922466b3 SHA512 bdde6ff5fcea64cad2e42bf6b2e8cb49f096ed5b17c321246651936878ff07347f4fea7805bb7083053aab2014c3e4a50fefcb727e89ccee3aa6a5860d71b249
@@ -12,5 +13,6 @@ EBUILD botocore-1.32.0.ebuild 1524 BLAKE2B 8a2471391e1a0e596e0b8d72ee09df50c3763
 EBUILD botocore-1.32.1.ebuild 1524 BLAKE2B 8a2471391e1a0e596e0b8d72ee09df50c3763a3d03db51169f45b1b571ba3df97eef93a43374b196ced5e1dc978bc2f3de52099675a6b19c1d5fe933922466b3 SHA512 bdde6ff5fcea64cad2e42bf6b2e8cb49f096ed5b17c321246651936878ff07347f4fea7805bb7083053aab2014c3e4a50fefcb727e89ccee3aa6a5860d71b249
 EBUILD botocore-1.32.2.ebuild 1524 BLAKE2B 8a2471391e1a0e596e0b8d72ee09df50c3763a3d03db51169f45b1b571ba3df97eef93a43374b196ced5e1dc978bc2f3de52099675a6b19c1d5fe933922466b3 SHA512 bdde6ff5fcea64cad2e42bf6b2e8cb49f096ed5b17c321246651936878ff07347f4fea7805bb7083053aab2014c3e4a50fefcb727e89ccee3aa6a5860d71b249
 EBUILD botocore-1.32.3.ebuild 1524 BLAKE2B 8a2471391e1a0e596e0b8d72ee09df50c3763a3d03db51169f45b1b571ba3df97eef93a43374b196ced5e1dc978bc2f3de52099675a6b19c1d5fe933922466b3 SHA512 bdde6ff5fcea64cad2e42bf6b2e8cb49f096ed5b17c321246651936878ff07347f4fea7805bb7083053aab2014c3e4a50fefcb727e89ccee3aa6a5860d71b249
+EBUILD botocore-1.32.4.ebuild 1524 BLAKE2B 8a2471391e1a0e596e0b8d72ee09df50c3763a3d03db51169f45b1b571ba3df97eef93a43374b196ced5e1dc978bc2f3de52099675a6b19c1d5fe933922466b3 SHA512 bdde6ff5fcea64cad2e42bf6b2e8cb49f096ed5b17c321246651936878ff07347f4fea7805bb7083053aab2014c3e4a50fefcb727e89ccee3aa6a5860d71b249
 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.32.4.ebuild b/dev-python/botocore/botocore-1.32.4.ebuild
new file mode 100644
index 000000000000..05766e84276c
--- /dev/null
+++ b/dev-python/botocore/botocore-1.32.4.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
+
+DESCRIPTION="Low-level, data-driven core of boto 3"
+HOMEPAGE="
+	https://github.com/boto/botocore/
+	https://pypi.org/project/botocore/
+"
+LICENSE="Apache-2.0"
+SLOT="0"
+
+if [[ "${PV}" == "9999" ]]; then
+	EGIT_REPO_URI="https://github.com/boto/botocore"
+	inherit git-r3
+else
+	SRC_URI="
+		https://github.com/boto/botocore/archive/${PV}.tar.gz
+			-> ${P}.gh.tar.gz
+	"
+	KEYWORDS="~amd64 ~arm ~arm64 ~ppc ~ppc64 ~riscv ~sparc ~x86 ~amd64-linux ~x86-linux"
+fi
+
+RDEPEND="
+	dev-python/six[${PYTHON_USEDEP}]
+	<dev-python/jmespath-2[${PYTHON_USEDEP}]
+	dev-python/python-dateutil[${PYTHON_USEDEP}]
+	>=dev-python/urllib3-1.25.4[${PYTHON_USEDEP}]
+"
+BDEPEND="
+	test? (
+		dev-python/jsonschema[${PYTHON_USEDEP}]
+	)
+"
+
+EPYTEST_XDIST=1
+distutils_enable_tests pytest
+
+src_prepare() {
+	# unpin deps
+	sed -i -e "s:>=.*':':" setup.py || die
+
+	# unbundle deps
+	rm -r botocore/vendored || die
+	find -name '*.py' -exec sed -i \
+		-e 's:from botocore[.]vendored import:import:' \
+		-e 's:from botocore[.]vendored[.]:from :' \
+		{} + || die
+
+	distutils-r1_src_prepare
+}
+
+python_test() {
+	local EPYTEST_DESELECT=(
+		# rely on bundled six
+		tests/functional/test_six_imports.py::test_no_bare_six_imports
+		tests/functional/test_six_threading.py::test_six_thread_safety
+	)
+
+	local -x EPYTEST_DISABLE_PLUGIN_AUTOLOAD=1
+	epytest tests/{functional,unit}
+}
diff --git a/dev-python/django-filter/Manifest b/dev-python/django-filter/Manifest
index ab337ae3d989..4271ef04b45f 100644
--- a/dev-python/django-filter/Manifest
+++ b/dev-python/django-filter/Manifest
@@ -1,3 +1,5 @@
 DIST django-filter-23.3.gh.tar.gz 137495 BLAKE2B 70049e744ec87a1dab9680144093684d3d23dd338a9b2d697de302b45e65bcd6f93c03c55ad5386ba1a7187e7ff5d1c43904f19cb17652ef6644b47a0f23101c SHA512 1da3f9bb1988d0b89d25f4101c26f4102d38e4717cdbd8d0cd4ae03a97658bfcc050afd3468ef6d0e33dc6533c7679f1906ddaccba8e7096a4bd570282a93c0a
+DIST django-filter-23.4.gh.tar.gz 137524 BLAKE2B 2ba4697e72f2a211860cd5571e76e4cb2c74a588112ea1570ea53cbb57358b178f9f64f651df471fbc06034ab6713e21e61ad83576adb29e3d758bbba965fa1f SHA512 ee564b3b67e355e6598adcc7b9046e4a3855a0dfd99cf551793c3a5c9797b0d87805b2b78b29f1e20de7e68337e6e1472205908f3b5cf26e36f554345b99cce9
 EBUILD django-filter-23.3.ebuild 891 BLAKE2B 93b427180ada5db9597dbed36a66240e6162e9919b7f457807d8d32860617bdd035bfd6c029306f180abd0d81f4a608b2bee0a7c1b19bef497f9a9faa03a0af4 SHA512 1c7fdcaa19cbca3806d741a6af79f2bb73586cdbe6bb8d6fb073c96097c03f63c6de584d569b545ba9cd71e3d65cb3f76d8b3f1ff896591469acd39099d44e7f
+EBUILD django-filter-23.4.ebuild 891 BLAKE2B 93b427180ada5db9597dbed36a66240e6162e9919b7f457807d8d32860617bdd035bfd6c029306f180abd0d81f4a608b2bee0a7c1b19bef497f9a9faa03a0af4 SHA512 1c7fdcaa19cbca3806d741a6af79f2bb73586cdbe6bb8d6fb073c96097c03f63c6de584d569b545ba9cd71e3d65cb3f76d8b3f1ff896591469acd39099d44e7f
 MISC metadata.xml 408 BLAKE2B 65a69b978d067aa59567504b378b931dddab24cfa11723a8fb1b317cf1ed906120835fe9bdb19d5457e57ab735e114bc3fb021a7defa4d895c2a80825430a818 SHA512 1e04d4fb02d1818913f7b5ee2e81be3df339c1b0a942ad0c0ae867e168350b8dc0aeac8fd6c31b701b4f6e743a90dccc70ea9b0a47e8add1a675435b4997506e
diff --git a/dev-python/django-filter/django-filter-23.4.ebuild b/dev-python/django-filter/django-filter-23.4.ebuild
new file mode 100644
index 000000000000..0769ae71ed93
--- /dev/null
+++ b/dev-python/django-filter/django-filter-23.4.ebuild
@@ -0,0 +1,42 @@
+# 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_{10..12} )
+
+inherit distutils-r1
+
+DESCRIPTION="Django app allowing declarative dynamic QuerySet filtering from URL parameters"
+HOMEPAGE="
+	https://github.com/carltongibson/django-filter/
+	https://pypi.org/project/django-filter/
+"
+SRC_URI="
+	https://github.com/carltongibson/django-filter/archive/${PV}.tar.gz
+		-> ${P}.gh.tar.gz
+"
+
+LICENSE="BSD"
+SLOT="0"
+KEYWORDS="~amd64 ~x86"
+IUSE="test"
+RESTRICT="!test? ( test )"
+
+RDEPEND="
+	>=dev-python/django-3.2[${PYTHON_USEDEP}]
+"
+BDEPEND="
+	test? (
+		${RDEPEND}
+		dev-python/djangorestframework[${PYTHON_USEDEP}]
+		dev-python/pytz[${PYTHON_USEDEP}]
+		!!dev-python/coreapi
+	)
+"
+
+python_test() {
+	local -x DJANGO_SETTINGS_MODULE=tests.settings
+	"${EPYTHON}" -m django test -v 2 || die
+}
diff --git a/dev-python/pocketlint/Manifest b/dev-python/pocketlint/Manifest
index a77900731c5e..2222f72cd109 100644
--- a/dev-python/pocketlint/Manifest
+++ b/dev-python/pocketlint/Manifest
@@ -1,3 +1,3 @@
 DIST pocketlint-0.25.gh.tar.gz 23931 BLAKE2B e8254477223ea0e631129778cc760ef57d34adb78f783258c8c097f7eac1acfe4cb00d21bc9aff576fbfab2bb3f7b687de33b3bc1f02c8d083d690a2e392bbac SHA512 dcb21ee147839a606520370f948594fc695c779a03d9edfb054dd6c07f4dd1c4ad0b64ccaad504da01e3b6c572ce27db8813ac8b61468d43e3745b5053a4edb7
-EBUILD pocketlint-0.25.ebuild 755 BLAKE2B 8bd44bfd459bb11363b63fdc4e143458d0277c2cfa4ee129c68ac7b960f68bfc367f32e9951155f418633220280a3a646cec84e32328c5e3aa3576e9575e9271 SHA512 a06fadf6a63da14e7ed5f7f7464cf744e31d70bd769393076a04c91ff4229917c24b2c6dba1339a7ea7b6667bdfa04bc89886b93b4c5662d7211f769c7c6b27f
+EBUILD pocketlint-0.25.ebuild 755 BLAKE2B ef17d75833f9876007f817d4e1c62a09cef26267ba599b1a3a7ffdfacb74e12eb182f20b14bdae5125aa971b009197e8af3c5a9b39989954f9a95583b3d27e3a SHA512 34aec54cdd9a713385ba5e1ac7532eccceeffb0d3b837aff1cb8468cb0cf628cd9cf3336a2729373c3e6f0d4312df04102c85d5704ce3ce1fde451431ab6059a
 MISC metadata.xml 303 BLAKE2B fd0ac0ccb8faa5f3e9b7074f238915f2b7babb9dc3af3b1574dd3f98e2970182d4cc0e579f59388601e43bd8991fa7cbca570c499f48060a25bdf8279a5c0751 SHA512 9f916df92044f8b6c2351e094e0ffdee2cf039e4d2d2d101ecc5a5e10af58dd4bafa19dc6cba47af87aaf73ad22abd64b50803c5e77cb283ae12c1f9e1653f43
diff --git a/dev-python/pocketlint/pocketlint-0.25.ebuild b/dev-python/pocketlint/pocketlint-0.25.ebuild
index 1f886f540dee..821ce664b4cc 100644
--- a/dev-python/pocketlint/pocketlint-0.25.ebuild
+++ b/dev-python/pocketlint/pocketlint-0.25.ebuild
@@ -4,7 +4,7 @@
 EAPI=8
 
 DISTUTILS_USE_PEP517=setuptools
-PYTHON_COMPAT=( python3_{10..11} )
+PYTHON_COMPAT=( python3_{10..12} )
 
 inherit distutils-r1
 
diff --git a/dev-python/prometheus-client/Manifest b/dev-python/prometheus-client/Manifest
index 0aa60ef287fa..7702415ac712 100644
--- a/dev-python/prometheus-client/Manifest
+++ b/dev-python/prometheus-client/Manifest
@@ -1,5 +1,7 @@
 DIST prometheus_client-0.17.1.tar.gz 90360 BLAKE2B 3927d5b6829a04cd72a99ac3b0b6a12726865b41d17f165a53f83a6a3791f18e25e03995088152ac7eae016eab7c6e29bef1e605f4c444f9963be04483ca2f02 SHA512 c8c776d646ea4a18a85fd26c858158b67979173dcf52d0a337cdb87fe907ff4081d8e0771176ba8be0ea6e244ee9b9097396c9aeb6f6db170a2c0f5a4898c771
 DIST prometheus_client-0.18.0.tar.gz 92365 BLAKE2B 2443fda2ae6f23cc817d4adbb63799501d7e688c2f10b876ed7dbb0f5efdd31d5ca7300fefc059a65533205155682e567c31eebe3e10b173bde4c018a17c65c9 SHA512 97ae14d549b3559f8e8136f56cde593ed2ef6303577e98e6f20367589d5df0e9630e9c13accf57609dfbb364527632c665e21f0778b0fd14cea5446495432ffb
+DIST prometheus_client-0.19.0.tar.gz 77791 BLAKE2B 494895efc0b08dc0494f82db3c3f23ff07669579b65ad150b7c2ca64d1807c6da8cd0889244c6294f3b7eb5fb07058a260da03f30ae5fd4c47e3d8b118d1bc8a SHA512 8d0f14130916d79fe43380d3eb38ed16e9883c83528131067f147f1651a4509557b32243e7cfa92242de1e31a2bfd7784f77cc0e4e6723bdccb841fd0fe139d7
 EBUILD prometheus-client-0.17.1.ebuild 580 BLAKE2B 211d05274d1f01dc404e7fd5bf0953d86a8f59782af389f08a039f98ca4c6b6037caaf04054e47cd7d0168a9b3f34de4dac369b215897537d137e8ab984df630 SHA512 6312d5601966258a5155179674ecfc09cfefb9c3d5b7f63b14883dc7f3a8f52668be8e39b9559baee670c6cf5a839d8fdd4e9cf50c3f30efc0c413ad06998310
 EBUILD prometheus-client-0.18.0.ebuild 594 BLAKE2B c5c7656838b242530c786eec073bad0ad6d57404c4eebff9303ded5d63b4acf1f63e49cb1ae37f48834c82ee18a8b3ab12f2a9869369ece49a20bba2e996a9f4 SHA512 28ed0733aabd83096d64ba2f7a0781f48c83040d2de6d9e120bf4942ee4d468bd9ceed5b44098f43204a207582b24c7aaf4d309e2903ab65a35b8815b2214fb2
+EBUILD prometheus-client-0.19.0.ebuild 594 BLAKE2B c5c7656838b242530c786eec073bad0ad6d57404c4eebff9303ded5d63b4acf1f63e49cb1ae37f48834c82ee18a8b3ab12f2a9869369ece49a20bba2e996a9f4 SHA512 28ed0733aabd83096d64ba2f7a0781f48c83040d2de6d9e120bf4942ee4d468bd9ceed5b44098f43204a207582b24c7aaf4d309e2903ab65a35b8815b2214fb2
 MISC metadata.xml 409 BLAKE2B 900f1046ec87679dabe88792bfea55cdf6dbbc1f332260e5487628530a1e5b2e07a1b5776313c484ed2355c205dea165547628297da3fd3e0d9e7c352f4f7a54 SHA512 beee1bb3823aa235e8c2667b18157254335777dbf1169beaee54190d41819dd0e82c58a8ea09c4981740370d7e5463ce11d327e02bf411093dfb653a557077ff
diff --git a/dev-python/prometheus-client/prometheus-client-0.19.0.ebuild b/dev-python/prometheus-client/prometheus-client-0.19.0.ebuild
new file mode 100644
index 000000000000..3c42dc5e89f4
--- /dev/null
+++ b/dev-python/prometheus-client/prometheus-client-0.19.0.ebuild
@@ -0,0 +1,25 @@
+# Copyright 1999-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 pypi
+
+DESCRIPTION="Python client for the Prometheus monitoring system"
+HOMEPAGE="
+	https://github.com/prometheus/client_python/
+	https://pypi.org/project/prometheus-client/
+"
+
+LICENSE="Apache-2.0"
+SLOT="0"
+KEYWORDS="~amd64 ~arm ~arm64 ~hppa ~ia64 ~loong ~m68k ~mips ~ppc ~ppc64 ~riscv ~s390 ~sparc ~x86"
+
+RDEPEND="
+	dev-python/twisted[${PYTHON_USEDEP}]
+"
+
+distutils_enable_tests pytest
diff --git a/dev-python/pyasn1/Manifest b/dev-python/pyasn1/Manifest
index 2447d17bf107..49b20dd1f231 100644
--- a/dev-python/pyasn1/Manifest
+++ b/dev-python/pyasn1/Manifest
@@ -1,3 +1,5 @@
 DIST pyasn1-0.5.0.tar.gz 145117 BLAKE2B dbbec0bebcfe11b8de983716fedf1bf28e6bcf7d5f89e3dcba929884347cc7cd3a8ef8b5ec44bbc799a7bae3de39c90cf5e48111384de571dc2034a79c3bb52b SHA512 763690184ce891555564d76902042791865815e59e1325100fca692140110e5e182ef3da84ffdf96b1876edeb2757bbb09c06d26e752a8110760dafbf9e3ca00
+DIST pyasn1-0.5.1.tar.gz 147134 BLAKE2B 3f209b845af307cf17d701ff6c6a1674978ed6a14b5132cfe1171d2560f0932c7f940364b247e5e2162b27bb807c44720a08af1b490d2ff665cea86fdfb66b6b SHA512 19478d810d000fb4435f6a1776f290b1618a693539ff8ffad8c41f9ac316938f1c0ae988db8571a838443407d312b5566887e20284a779ccf427888739f13833
 EBUILD pyasn1-0.5.0.ebuild 565 BLAKE2B b77ec421e9fb45a068f1435f5192aace73b91290dc8ea5379f952c67d55f42d3648daaf6346b608723744ae4a4d859220de8dba1983e574b407617c6ac9b31b2 SHA512 5cf948539326cf9abec24543b443d1c78b31d9eac6561cb80dfe5e2754aa8d30445d6141a2cca3230f2adcdfb1d3c48a385eabd3b6df01c4e21e7a01a928315e
+EBUILD pyasn1-0.5.1.ebuild 573 BLAKE2B 51fd348e5de8effa23d57ec632ad6cb1d0f7fee190ac9b6b0b4abe595a40ede7d93cd691cf86ec88baa1186115df1c039205a6be3d6e2e40c49c88cc7d2b5e54 SHA512 3e558299ef5417e148f845bc8c3941c9d4a8ed71908563e877d6ea59b7ba20119c2c4af6a609f769e2d57f81d2e63f9f4681989c1a39b99e011fba98d021560c
 MISC metadata.xml 401 BLAKE2B 28d1b58f4b16507dd595524f0eb3fafa93a68222bc56f0040b33e7458b2ac471409c798af1014ccc50207fd0ac66a566aba36e1f0c04a22499396620f3477945 SHA512 a25c0976b4d0ff8a6ede6b84b6933b3405f8cdbf74416f01e91508f0c72d2dda4b4ff63c011846052b683bc7a3f7e5e0ea068d3b506d256bb15fd8dffafc94e0
diff --git a/dev-python/pyasn1/pyasn1-0.5.1.ebuild b/dev-python/pyasn1/pyasn1-0.5.1.ebuild
new file mode 100644
index 000000000000..21d0e2d6abd9
--- /dev/null
+++ b/dev-python/pyasn1/pyasn1-0.5.1.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
+PYTHON_COMPAT=( python3_{10..12} pypy3 )
+
+inherit distutils-r1 pypi
+
+DESCRIPTION="ASN.1 library for Python"
+HOMEPAGE="
+	https://pypi.org/project/pyasn1/
+	https://github.com/etingof/pyasn1/
+"
+
+LICENSE="BSD-2"
+SLOT="0"
+KEYWORDS="~alpha ~amd64 ~arm ~arm64 ~hppa ~ia64 ~loong ~m68k ~mips ~ppc ~ppc64 ~riscv ~s390 ~sparc ~x86 ~amd64-linux ~x86-linux ~x64-macos"
+
+distutils_enable_tests unittest
+distutils_enable_sphinx "docs/source"
diff --git a/dev-python/pygal/Manifest b/dev-python/pygal/Manifest
index 323ad501acb3..1ae9a00d420f 100644
--- a/dev-python/pygal/Manifest
+++ b/dev-python/pygal/Manifest
@@ -1,3 +1,5 @@
 DIST pygal-3.0.0.gh.tar.gz 3575455 BLAKE2B 9b64cf441aeb25b0a0b9834f07e5892fe163f28a5da796d37083f8f3a10d8737a69bad39e503d722e6a36f2de4367b4fd2bdc3a06c5bc30bce66a370690d9c88 SHA512 71ac9f197d711c8cf5bb47caef128754f81b1cb0ba98c4cc67de78b68fca5d40baae9fbb5c978f6abaed4c73b8edfea2de07de2fda1aa7c15e0d81387518cc49
+DIST pygal-3.0.3.gh.tar.gz 3575707 BLAKE2B 32dfb09f7dc5f97c758ff516a131da7ab82afb58028d710017af01220dbee57579cadc56e4b9ae207d71ad7d71d05dd14bd876c563f61f18263a0c2a839c0183 SHA512 052852552e0f07194acc832a953cc69131f2640216c22d5f7e5860b98ad80f24a5532a58b52903fedfcdb6e48331e4c8c02be54e90468476ca3f720be8845985
 EBUILD pygal-3.0.0-r4.ebuild 1126 BLAKE2B 38e85c4e9573de789e0f7bbe95987f1d93c22342b51f8dbbd9e473974f1927ad0dd6e398225ac86f8db00c3ecb8aecfa7246fc6ac12c1800b163c0aa3d6237ce SHA512 c03e2b253c3c26d07c6c3c0d02eb84db39282dde74c9e13c3a7e4319e7cf5de1e135fada37fb2d4876e5ba954dc38c7446f4c077a19562d06beeb3a2539b711e
+EBUILD pygal-3.0.3.ebuild 1144 BLAKE2B 2bb4dc8a0508a0a0aa794a1583b7f89fe052927e2640abcffb81f5caab9d792c8976d8968cbbdb45c77277727998a45100d4c95ace34f700e44a5b45d99b5513 SHA512 440f56611cbbd7079d5ec885e5f10bbcbd880be37a2c1abd7f873287153351d96ff4ee55e8a1f5d124b8e5204bd13892a0c247f32d6c23abe2cca86e92463bf5
 MISC metadata.xml 458 BLAKE2B 70473091a8343d255501ff6d306cbf376b57c42ba842e36a3948649f30ffa3f29ff502254cf265512b024878b8faa7d77b4164b5cf70ae6f851a5d2d51a3997c SHA512 3bcd119c30b25e2f821c10d1b2c58efc109d8049a446acb4960b47ddef18d3c1ed4efc6bb4dc551abbb42f17828c4898acdad3172523b7576a6a548e43a8e8b9
diff --git a/dev-python/pygal/pygal-3.0.3.ebuild b/dev-python/pygal/pygal-3.0.3.ebuild
new file mode 100644
index 000000000000..620264aeebbf
--- /dev/null
+++ b/dev-python/pygal/pygal-3.0.3.ebuild
@@ -0,0 +1,51 @@
+# 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} )
+PYTHON_REQ_USE="xml(+)"
+
+inherit distutils-r1 optfeature
+
+DESCRIPTION="A python SVG charts generator"
+HOMEPAGE="
+	https://github.com/Kozea/pygal/
+	https://pypi.org/project/pygal/
+"
+SRC_URI="
+	https://github.com/Kozea/pygal/archive/${PV}.tar.gz
+		-> ${P}.gh.tar.gz
+"
+
+LICENSE="LGPL-3+"
+SLOT="0"
+KEYWORDS="~amd64 ~riscv ~x86"
+
+BDEPEND="
+	test? (
+		dev-python/lxml[${PYTHON_USEDEP}]
+		dev-python/pyquery[${PYTHON_USEDEP}]
+		media-gfx/cairosvg[${PYTHON_USEDEP}]
+	)
+"
+
+# CHANGELOG is a symlink to docs/changelog.rst
+DOCS=( docs/changelog.rst README.md )
+
+distutils_enable_sphinx docs
+EPYTEST_XDIST=1
+distutils_enable_tests pytest
+
+python_prepare_all() {
+	# Not actually required unless we want to do setup.py test
+	# https://github.com/Kozea/pygal/issues/430
+	sed -i -e "/setup_requires/d" setup.py || die
+	distutils-r1_python_prepare_all
+}
+
+pkg_postinst() {
+	optfeature "improving rendering speed" "dev-python/lxml"
+	optfeature "png rendering" "dev-python/cairosvg"
+}
diff --git a/dev-python/sphinx-gallery/Manifest b/dev-python/sphinx-gallery/Manifest
index 4d312e10e654..ae6792f1bf1c 100644
--- a/dev-python/sphinx-gallery/Manifest
+++ b/dev-python/sphinx-gallery/Manifest
@@ -1,3 +1,5 @@
 DIST sphinx-gallery-0.14.0.tar.gz 408734 BLAKE2B f527eb58b565353722d669edf81a667b7c3e784480500ff03b5567b9214c27951438052db3f2dcba92b24e7224d5cd0017bfbe770132dc96ce3427ca463329a8 SHA512 c8a69af9dec9adf042214de0cb48d510ebb41d7bc4bb1e5767f3982b0e83d9dfa1a26028d939a1785d3894894d396840e437dc5c196bfc5318152d06240d84b9
+DIST sphinx-gallery-0.15.0.tar.gz 422363 BLAKE2B cbca8ec252e03e9cacc0df27da43ebc9bbed8531d5df65bf9cb7f54f7ae8b127582f353cb245bcc459d6fa86240207346a05d777504163d49be0fabb029a172b SHA512 b6b0d5022da9de27417f8cc72ba24f0d51e57f83c68b17a296269b074888a711d61fcf933fbbfaf4d6977702b3f020d4b0eaa89e78e51185ee2dd26e911fe8be
 EBUILD sphinx-gallery-0.14.0.ebuild 1434 BLAKE2B b6f1a91a59a0b84727f2bddedc3f942a3881f841d5975acc967e66eefdf64830f2ad9679ee8e8b788d0455cdd1ab1becae239244221b0bd7e8321ce3a8aa8985 SHA512 caee116f254bfe3a6fea32d7c71ffa9ef022a8884876f86a2b843dc2659115727b62d4ffae13c309c08fe8462cea69f48ff5634b9f789aded3e6a331b5c7e8aa
+EBUILD sphinx-gallery-0.15.0.ebuild 1437 BLAKE2B 65a87ad767edc64579cc98aa22409419bdfae2baa7257f655270b849f88a331b5e2747a5d9a0fc3c0377a288a1cd92b62b0c139e275133bc5ce50902b6311581 SHA512 94e20b681da9a8f21b322a2fa842dce672fbb560ae033bc31d93642d09d4558b7323983f47fdae2b67b8dc8b43c403e0cef68527c7e1cbc56b51cb3a61081bf6
 MISC metadata.xml 424 BLAKE2B 4e5cd1e912fd5934c7221d3e5cc60b2894eca6b994384f6ceb8397ce9c5312be1e9869b57f9dd7f3ac66501b20e6fd6abd2f33b5d19b93d3a12f7158ba08e7c6 SHA512 17acc19bf43dbbf1a377949576252f77fd334ddd8a3bec593d2339db5a44e4fde831f9ce47be97318bf72e30a062608f883e48cf572904b3476fde0df33adb09
diff --git a/dev-python/sphinx-gallery/sphinx-gallery-0.15.0.ebuild b/dev-python/sphinx-gallery/sphinx-gallery-0.15.0.ebuild
new file mode 100644
index 000000000000..e4a9b5f96a09
--- /dev/null
+++ b/dev-python/sphinx-gallery/sphinx-gallery-0.15.0.ebuild
@@ -0,0 +1,51 @@
+# 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..12} )
+
+inherit distutils-r1 pypi
+
+DESCRIPTION="Sphinx extension to automatically generate an examples gallery"
+HOMEPAGE="
+	https://github.com/sphinx-gallery/sphinx-gallery/
+	https://sphinx-gallery.github.io/
+	https://pypi.org/project/sphinx-gallery/
+"
+
+LICENSE="BSD"
+SLOT="0"
+KEYWORDS="~amd64 ~arm ~arm64 ~ppc ~ppc64 ~x86 ~amd64-linux ~x86-linux"
+
+RDEPEND="
+	dev-python/matplotlib[${PYTHON_USEDEP}]
+	dev-python/pillow[${PYTHON_USEDEP}]
+	dev-python/sphinx[${PYTHON_USEDEP}]
+"
+BDEPEND="
+	test? (
+		dev-python/joblib[${PYTHON_USEDEP}]
+	)
+"
+
+distutils_enable_tests pytest
+
+python_test() {
+	local EPYTEST_DESELECT=(
+		# Internet
+		sphinx_gallery/tests/test_docs_resolv.py::test_embed_code_links_get_data
+		sphinx_gallery/tests/test_full.py::test_run_sphinx
+		sphinx_gallery/tests/test_full.py::test_embed_links_and_styles
+		# require jupyterlite_sphinx
+		sphinx_gallery/tests/test_full.py
+		sphinx_gallery/tests/test_full_noexec.py
+		sphinx_gallery/tests/test_gen_gallery.py::test_create_jupyterlite_contents
+		sphinx_gallery/tests/test_gen_gallery.py::test_create_jupyterlite_contents_non_default_contents
+		sphinx_gallery/tests/test_gen_gallery.py::test_create_jupyterlite_contents_with_jupyterlite_disabled_via_config
+	)
+
+	epytest -o addopts=
+}
diff --git a/dev-python/sqlglot/Manifest b/dev-python/sqlglot/Manifest
index 6ee9be98ce95..c19a28c7cf25 100644
--- a/dev-python/sqlglot/Manifest
+++ b/dev-python/sqlglot/Manifest
@@ -1,7 +1,9 @@
 DIST sqlglot-19.4.0.tar.gz 9056050 BLAKE2B 23d5a9bdd7bfa27128e624406f52488e90ec475c355fde6e5e7ac77bee5ae84dd1abeb2c87896f3fbc418dbe0b818e66f1d76b7e24514315e194b6bd58677203 SHA512 f0f6f4d4eca3d97ac9cd200e6a5e8df5a2c2b9e6d84dd87f19ab29b1af0c6cb55c62e28c9c7faa34425a6cfb0583b02d387b7cd744fec40419927016cd05d51e
 DIST sqlglot-19.5.0.tar.gz 9060496 BLAKE2B 190c4b507e3c630a46a493f72698f48749fc4f0e6444a2ee61499d35a5f56563b402e8947531b20c100df8ffc3af86cc45b8e1e11e7b467ec3bcd6261b880619 SHA512 3e3cbf7c9bac33b9dc0ad26021a78d534cb6ac61aae6d96c5f652938fd4efb5eca52854ca7ef02fa9ec6a989a6c80eaab31b210c932cb286b2ea8e4aace7fcf9
 DIST sqlglot-19.5.1.tar.gz 9062537 BLAKE2B dece9479e8333cf90481e7f72bfd58c0d36506b4e1bc1282b4e2c677ccfd24da7e04a6eddf1ecca16ccc83e8079b61eef8cabe3a6ef6a2b96df56c1a5b3e89a7 SHA512 eaf6090a001c162612503714d47225f1fdb5f0d19974e93bb76f87aa4e101fec5ed0045c4f74f2e55b58368170b449eabbd87569f16fc3ea73a14df909b007c4
+DIST sqlglot-19.6.0.tar.gz 9063326 BLAKE2B ad2d12f511d8bf713fc51b67364133b648186b91351137f339dbb97500a50450db5cc39f016f03260d4c79f4341338dd4fee88fe6f5491bf556d93a4806ac411 SHA512 9f5d2fd6364fbeacca328f9fdcb84204ef65906fd024059464ecac9cc7c7865cf4736cc17a3661af1fda5ca0e52fb24f3939a263349c75a962216af8bd6841f4
 EBUILD sqlglot-19.4.0.ebuild 919 BLAKE2B d6c7bf029e48f9b11c305adbc89473b9bcb7277299a869569aeefe69dd63e4ac19c9a7e3c23ba8981e6d7f46b7e4611cbfcc18b871876e949e0912c3ded446bc SHA512 5f42256d970f291e0a0eed073a1060a1e5dc15b872b1ecca6b9aeceb380c48e1bb1f1b61719a582d8bd56e01eaf8b3578fd374ee7fff761ac6a95e746b07c2f9
 EBUILD sqlglot-19.5.0.ebuild 919 BLAKE2B d6c7bf029e48f9b11c305adbc89473b9bcb7277299a869569aeefe69dd63e4ac19c9a7e3c23ba8981e6d7f46b7e4611cbfcc18b871876e949e0912c3ded446bc SHA512 5f42256d970f291e0a0eed073a1060a1e5dc15b872b1ecca6b9aeceb380c48e1bb1f1b61719a582d8bd56e01eaf8b3578fd374ee7fff761ac6a95e746b07c2f9
 EBUILD sqlglot-19.5.1.ebuild 919 BLAKE2B d6c7bf029e48f9b11c305adbc89473b9bcb7277299a869569aeefe69dd63e4ac19c9a7e3c23ba8981e6d7f46b7e4611cbfcc18b871876e949e0912c3ded446bc SHA512 5f42256d970f291e0a0eed073a1060a1e5dc15b872b1ecca6b9aeceb380c48e1bb1f1b61719a582d8bd56e01eaf8b3578fd374ee7fff761ac6a95e746b07c2f9
+EBUILD sqlglot-19.6.0.ebuild 919 BLAKE2B d6c7bf029e48f9b11c305adbc89473b9bcb7277299a869569aeefe69dd63e4ac19c9a7e3c23ba8981e6d7f46b7e4611cbfcc18b871876e949e0912c3ded446bc SHA512 5f42256d970f291e0a0eed073a1060a1e5dc15b872b1ecca6b9aeceb380c48e1bb1f1b61719a582d8bd56e01eaf8b3578fd374ee7fff761ac6a95e746b07c2f9
 MISC metadata.xml 635 BLAKE2B fb154da2feeea6d590b4f3edb8d8d90d316feee1b8faababc022db026254bd24674d8419b74074b089d4d8930bab642cdc5fa7694bfa9e033cb5ef4ad4988562 SHA512 dd5ed7212dc2eac6a4d84bb2e3639db1ffe163598d911073d7100a8ebfeceb85842ea2e6a597d1036d5b1388d18954b95a782af7b3a84479bf3b59ef9e9b6bf8
diff --git a/dev-python/sqlglot/sqlglot-19.6.0.ebuild b/dev-python/sqlglot/sqlglot-19.6.0.ebuild
new file mode 100644
index 000000000000..368b77416b42
--- /dev/null
+++ b/dev-python/sqlglot/sqlglot-19.6.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_{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/wcwidth/Manifest b/dev-python/wcwidth/Manifest
index 3a744688fe08..5ed64e068fbe 100644
--- a/dev-python/wcwidth/Manifest
+++ b/dev-python/wcwidth/Manifest
@@ -1,7 +1,9 @@
 DIST wcwidth-0.2.10.gh.tar.gz 92276 BLAKE2B 69347446b6571feb68871a6195bfe6718f23d8a21332cda839bb41f2a540d222265065a1194e26d22a166d1d90fb4d5237703af96a8f1737c2f09d126ec2d623 SHA512 207e0086080e33f1e42728eb81c4543ebb21f08e2a743fbd29d64f3f5ee21a1f12c9b298fcc64df6eae646900c7858ba4a845a9b510d525f2582359b7c6a50aa
+DIST wcwidth-0.2.11.tar.gz 99709 BLAKE2B 543eb98d7b49958a04a298705eacddf4bca954a0a5f2da25e49da1d2bc7226b1fe5b58079bbf372e6ddc27d66302527cc6440fc034748a1a035458fd658349be SHA512 798a5f062fb3825ac6a4942e50dbff270962715e05e2ed40e465040264cfb4096aa6c857b4338fa2dc14918365e9e73cf9b722ee140bc257d79b00941ed1b705
 DIST wcwidth-0.2.8.tar.gz 61713 BLAKE2B ca3d0c58e2ccab0fbb5493aacc8df81e9dc1faf7572543b7aa277875d617e0d4dc0c5ff6032f5f0f3846f52f26c407ddc5dd941780411572bce8ddc467a33dd7 SHA512 4a9ac4a3068c8ac25a7073d6c5e5782c3915184929ee191a2169eca510668e6e0b15856e71bd8b8d4c580767542d695b25a370329e95da317295104b962737f1
 DIST wcwidth-0.2.9.tar.gz 66133 BLAKE2B 7df656c139c228324427e6be9cefe3496b7b5e55d7353f062ae4cb3d7d5988f1e5e03e11122c0e045b7a93abd95139fc2ac8a81a4d079518cc8c6fa747d2ff00 SHA512 8aff2ce67d8f331c4c75907f14ec602f4829d39e3f89af640d598e075165a011e41a5451a333bc2f6c95f33a4b9ca8ae1a5d02efe4f79acc988d60b85bf5929b
 EBUILD wcwidth-0.2.10.ebuild 836 BLAKE2B c35a51fafbcf43ed5d713430464997792ce14d1e15cca0fda673b5a2b63dd82f861904ab6a09f335df527a568e16c8e80e7ede7c06fc65e0b4c7d2d857449881 SHA512 24b387c0516aa04bedf363d1d534890058fdb35f77e443ee7a51bffaa2f706983a0d3404e83f28f2fda303a089690b5fb34da3316e30dcc4c75263f30b18ba6e
+EBUILD wcwidth-0.2.11.ebuild 720 BLAKE2B d64c6cddb5f0d3f34b8c1bcb8a88ba48f0054b0fbff9c7ef665ced29c2e9ae09656867566c560c5868d2b39d29a1301a25cc983fed7ac2be2eb474c82627522c SHA512 b962651b2604fd971811429df23228c678f6fad4e029780fa134eba936f5f6a366ff40209f572f238abf83adbc2d7e2874eb54f78af8e6cfabf3dd6e8906f880
 EBUILD wcwidth-0.2.8.ebuild 824 BLAKE2B bd2c0d918a9b211827aa023eeab8dff2528267800b7ec94d340ad9ec98fdf8a1dd34201793b0975fc733d903225ec26b12af8e87fd4043cf3cead2b21d7bc18f SHA512 1b7411cd6d6ead9fdc816baa8595407ce3d00ef5036723dd9a925aa58fa8581ceaf5f2b8a42f5b2f946505abf6f0959b79b14f02a68fd92cf94cd6da190faed6
 EBUILD wcwidth-0.2.9.ebuild 832 BLAKE2B c704bad3cd86b5d7afdc2ba5bf4cb6996baed90e0352e5e1e29ce2b0558fb192a38205b74ebff1599bcdbd07519b8a840833d16bd6b171f49140fc85038ece83 SHA512 e22e16fdb4895a78ed70321c585f46807cab04200a23968c36f04799dcafa7fcbb6416cc16551824a1e64c3e085ce901d2766efb13a6a5f933c739336fd12b76
 MISC metadata.xml 402 BLAKE2B 86714d496f80fe46cb313bed026135b2712ddfb47fea5994d0021516aa6ad28eb5fc52d37b37a7a224ec0613681b27ee039f4ac734430d94aafe4ec8946cecc7 SHA512 85c0e684f66a5582ca63d6f72c4e69101e8ec30f8e03c52e972fa36a2e6b6d2a8f019fb33a1e39e73fb37de25c82b906b18ac626afdd0a93d97db2ddcf485063
diff --git a/dev-python/wcwidth/wcwidth-0.2.11.ebuild b/dev-python/wcwidth/wcwidth-0.2.11.ebuild
new file mode 100644
index 000000000000..d1b459745990
--- /dev/null
+++ b/dev-python/wcwidth/wcwidth-0.2.11.ebuild
@@ -0,0 +1,31 @@
+# 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 pypi
+
+DESCRIPTION="Measures number of Terminal column cells of wide-character codes"
+HOMEPAGE="
+	https://pypi.org/project/wcwidth/
+	https://github.com/jquast/wcwidth/
+"
+
+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
+
+python_test() {
+	epytest -o addopts=
+}
+
+python_install_all() {
+	docinto docs
+	dodoc docs/intro.rst
+	distutils-r1_python_install_all
+}