Adding metadata

34 files changed, 504 insertions, 8 deletions

diff --git a/dev-python/aws-sam-translator/Manifest b/dev-python/aws-sam-translator/Manifest
index 3f99e6c137c3..6953cf47aaec 100644
--- a/dev-python/aws-sam-translator/Manifest
+++ b/dev-python/aws-sam-translator/Manifest
@@ -1 +1,2 @@
 DIST serverless-application-model-1.71.0.gh.tar.gz 6001064 BLAKE2B af30dcfe8fb38360021685a4e80e9ecd8db7cc02b9f6ddcec2ea9ceb612f633c376200026324a201b03bbf89d3cd1b5ad213b9302538527a1ba4a0003bf4b16b SHA512 ba8b0c10a3c4c65e342d63c7676b7edea8079d2dc1fe0b092a46dc2b3b6fb11a57268f92e79c95bce4e347c80876d3a82d72208725d955b9a31cd2f0a13e33db
+DIST serverless-application-model-1.72.0.gh.tar.gz 5074171 BLAKE2B b69fd51e59a223b7003b82f4a27c1724a6be0c16958664ce567b4c5ce57084aca2259c0d92f4f019f0b44fa6a7c8fe06622109c5447b7905029652c548fd20d4 SHA512 e267fc255923c2ab469f1d95723927392453e84ac95d04bddc202e895824410a80eff40bb6900aa2cdfbe6f5ab06d89a24003848e19f9f16423c98a1df951d64
diff --git a/dev-python/aws-sam-translator/aws-sam-translator-1.72.0.ebuild b/dev-python/aws-sam-translator/aws-sam-translator-1.72.0.ebuild
new file mode 100644
index 000000000000..8d58efa50f75
--- /dev/null
+++ b/dev-python/aws-sam-translator/aws-sam-translator-1.72.0.ebuild
@@ -0,0 +1,60 @@
+# Copyright 1999-2023 Gentoo Authors
+# Distributed under the terms of the GNU General Public License v2
+
+EAPI=8
+
+DISTUTILS_USE_PEP517=setuptools
+PYTHON_COMPAT=( python3_{7,8,9,10,11} )
+
+inherit distutils-r1
+
+MY_P=serverless-application-model-${PV}
+DESCRIPTION="A library that transform SAM templates into AWS CloudFormation templates"
+HOMEPAGE="
+	https://github.com/aws/serverless-application-model/
+	https://pypi.org/project/aws-sam-translator/
+"
+SRC_URI="
+	https://github.com/aws/serverless-application-model/archive/v${PV}.tar.gz
+		-> ${MY_P}.gh.tar.gz
+"
+S=${WORKDIR}/${MY_P}
+
+LICENSE="Apache-2.0"
+SLOT="0"
+KEYWORDS="~amd64 ~arm ~arm64 ~ppc64 ~riscv ~x86 ~amd64-linux ~x86-linux"
+
+RDEPEND="
+	<dev-python/boto3-2[${PYTHON_USEDEP}]
+	>=dev-python/boto3-1.19.5[${PYTHON_USEDEP}]
+	>=dev-python/jsonschema-3.2[${PYTHON_USEDEP}]
+	<dev-python/pydantic-2[${PYTHON_USEDEP}]
+	>=dev-python/pydantic-1.8[${PYTHON_USEDEP}]
+	<dev-python/typing-extensions-5[${PYTHON_USEDEP}]
+	>=dev-python/typing-extensions-4.4[${PYTHON_USEDEP}]
+	dev-python/pyyaml[${PYTHON_USEDEP}]
+"
+BDEPEND="
+	test? (
+		dev-python/mock[${PYTHON_USEDEP}]
+		dev-python/parameterized[${PYTHON_USEDEP}]
+	)
+"
+
+distutils_enable_tests pytest
+
+python_prepare_all() {
+	# so much noise...
+	sed -i -e '/log_cli/d' pytest.ini || die
+
+	# deps are installed by ebuild, don't try to reinstall them via pip
+	truncate --size=0 requirements/*.txt || die
+
+	distutils-r1_python_prepare_all
+}
+
+python_test() {
+	local -x PYTEST_DISABLE_PLUGIN_AUTOLOAD=1
+	local -x AWS_DEFAULT_REGION=us-east-1
+	epytest -o addopts=
+}
diff --git a/dev-python/boto3/Manifest b/dev-python/boto3/Manifest
index 2d9e1a1ca0cd..ba7d12b89d23 100644
--- a/dev-python/boto3/Manifest
+++ b/dev-python/boto3/Manifest
@@ -2,5 +2,6 @@ DIST boto3-1.28.10.gh.tar.gz 678958 BLAKE2B 55356d6234a12a09cb03bc8907d5c8c3810a
 DIST boto3-1.28.11.gh.tar.gz 679904 BLAKE2B 06fb7e0759c2b51f9af8c69a7aeca4610ee39dd6e230450695337833dd4295508ed7e505fbb9d72e8d5015ee741c7080627848f2c77b18cfed7b5afee0d923f8 SHA512 0ca9dbd174d6d7cb8ac4dac913a9abe3f03188d231cc8b11cbd51ad6bb4189b69d590fc5b18c001b18ff4d8db3f4fe19476fa5616d0bbf7125ed5b4eb848413a
 DIST boto3-1.28.12.gh.tar.gz 680624 BLAKE2B 0403c4ab78a03b678faa3cdde05a30fb8cf48d5781d23016efd1415fabadd9eee39cbde7b447f771c2129270caa0ceed98040e4051d2046918e20a63dfe40508 SHA512 28b6b314532919bba137bf02927d28db7167e50d5c31ed2b367dd76eeec33590bf518074bd0f3aeb122bd1028c856f7fff8c76e688f154a0d358ee0a24a4e405
 DIST boto3-1.28.14.gh.tar.gz 681140 BLAKE2B 602890b59b20901e43b4093dcf2decceee17bd472bcc07393552dd11b03303cfaa0d30c1ec9676d93de193bd3a0b9c7bbace5c41c4d3eff612aab0ae253f168f SHA512 b65eb310831f1157a91eb6b48c3afe7b9c825d05d0d43a5c5f67b7546554b0e0f4e47caae1952ff75431930a15d331cc9adddd9bdd77182a5ed7a2d89b4ad820
+DIST boto3-1.28.15.gh.tar.gz 681894 BLAKE2B b2fbe18f000d76e2c5be2ec0038756768608364a983c7e10acf197afc5fd610c3bcbab77aa23caae2ca52f92062823b4f0cc32383161cfcd7934060c8a091634 SHA512 a55db28e91bdf4b8b84e52b4329640b68e88661b0c659e6b77ffb677c4fd3b0c948136b90e73aa34fc5f424f01735a0d4d3a09a057a15f68fa6c84e6e6eb5001
 DIST boto3-1.28.3.gh.tar.gz 675019 BLAKE2B 93b29307fbfec4e61dc60d28e4f20392ae2a730f048a0b2e8cb99fd515a036fc4ca889ddd564e09b1f3eab4cb9499c5918b4e7430d63148dd2854d126719a468 SHA512 514d0f373f25bb691abf5f1f8b0209a07097191b2ad8fb6339739e7a0bd2b8e6d5a88f1250e928ca89b1f1aa5e27a44bf2cab38a57680c01214d370d11944ded
 DIST boto3-1.28.9.gh.tar.gz 677993 BLAKE2B a800de94cfb0d317b41091fb1d2bb0fd6449df85da434879c0689bf36998b2a52331ba077c65cae9967fcce998a15d2a6f6a758931fa12a00b95487adaf81dfa SHA512 6e1e5e74d20d2e67f29597ddcda70475cbea863978ca93ec77a0f478690477c9782111701771d5b8354f4402c21496e7f5627b1398cbd6fd87627fd978f5e360
diff --git a/dev-python/boto3/boto3-1.28.15.ebuild b/dev-python/boto3/boto3-1.28.15.ebuild
new file mode 100644
index 000000000000..03c610b184f7
--- /dev/null
+++ b/dev-python/boto3/boto3-1.28.15.ebuild
@@ -0,0 +1,66 @@
+# 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_{7,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() {
+	epytest tests/{functional,unit} -n "$(makeopts_jobs)"
+}
diff --git a/dev-python/botocore/Manifest b/dev-python/botocore/Manifest
index 9e1f76692dde..7dd5d0c34e81 100644
--- a/dev-python/botocore/Manifest
+++ b/dev-python/botocore/Manifest
@@ -2,5 +2,6 @@ DIST botocore-1.31.10.gh.tar.gz 11793022 BLAKE2B 8c9f2a0439916ecb4af94b7e55347e4
 DIST botocore-1.31.11.gh.tar.gz 11799687 BLAKE2B d2a7bad627c6e5272b8d9b1f7ebf95937a89e1f51d1e9465bebcd819ba7bebde56a23ca9b42ab4b4a2a3114da1829435da5d49441c6931a46a15e31258c66ab1 SHA512 5aa5cd98176d53a66355d06a32497a2662b655ed68b69ba577330f0f506a465188117711f6ea78d2c65d654318515139585997d22735723c35613fdb94d2a646
 DIST botocore-1.31.12.gh.tar.gz 11814932 BLAKE2B 3d5813b4dcfbb379f3f78dbc9a92c1cac2692b169560bcbe4146c71ac7e9c65a3343e460fe26df797f17bd481f9710f708ea13bcb494b2c621fede7b579e9efb SHA512 c3f85f6d87c148ca097b59e57966af5985714cf0fc2eaad6fb54823706e36c2fe64d44c726107a5898794d1635ccb49bcbbc12bf64df1dbd5e2304ea7520ffc7
 DIST botocore-1.31.14.gh.tar.gz 11817940 BLAKE2B a73e9e79b5e07851b1bedcc4e32f5eadc1d968ff83ee0fd0eec2787b6d1eae72e5c0ba5e2b44d766cdeef2d5d73f4658adedc7e4b75cb11837103ea07d3118c1 SHA512 e35ea3edbcdd7963c61cd41d5945cb478a928bb6cc3bc0db4f481df73cf0f44e91ba9b93ad0c456497ccb72b68b6fbb73cb9d22779a8bfe0dc9cec40f18ada65
+DIST botocore-1.31.15.gh.tar.gz 11823446 BLAKE2B 13a7eace7e9dcff6fa54c8e725b8221bb5304f97e3b4d422ebf5dd9a0bc905bebe83c67033a11360a00ed51a63742c9b990511681a147b9880a096760d022a9c SHA512 42dd123576407da8b4b3281aed72441d1f57a03b5fa444154096253052ddd88d297f54f497d7ae0af03831b1dac50399a412cd2fee5358a0984053c4de39bd20
 DIST botocore-1.31.3.gh.tar.gz 11769948 BLAKE2B 452c494faa430b6782685b9960cc9ea15ce3dedfe1b5343ee7bdbd7544e108bbfc7bb58d527419b5dc5f4077dd806752eec927196b82ac286903992fef339e52 SHA512 0f2853c14d7695ea4eeacea6fed93e77436df143bd0b9bec967490eb88e3d6531c916dca91c1a3bde4b57253d77acabe2413acde4d1473d01e15ef69b45621e0
 DIST botocore-1.31.9.gh.tar.gz 11785638 BLAKE2B 23f2c010f98b5ca8414c9a031524b1cb7d75366bf84d34df980ef4085a73bc62643cca5255519f891f7a9468abbf0d97adddf6684c3c0a751b0f9f390122c19d SHA512 b2bf0089a81c5389d86c9f7b2545358f23a1219d7e5bf152285f58293a171210b46c22c814ab3f8da460a2acbdd5127193fa7a2e19a021db511f9d08931037bf
diff --git a/dev-python/botocore/botocore-1.31.15.ebuild b/dev-python/botocore/botocore-1.31.15.ebuild
new file mode 100644
index 000000000000..509d06dedf97
--- /dev/null
+++ b/dev-python/botocore/botocore-1.31.15.ebuild
@@ -0,0 +1,79 @@
+# 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_{7,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
+		# fails on unrelated warnings
+		tests/unit/test_client.py::TestAutoGeneratedClient::test_BOTO_DISABLE_COMMONNAME
+		tests/unit/test_client.py::TestClientErrors::test_BOTO_DISABLE_COMMONNAME
+		# TODO
+		tests/functional/test_credentials.py::SSOSessionTest::test_token_chosen_from_provider
+		# urllib3-2 compatibility, mock relies on implementation details
+		tests/unit/test_awsrequest.py::TestAWSHTTPConnection::test_expect_100_continue_no_response_from_server
+		tests/unit/test_awsrequest.py::TestAWSHTTPConnection::test_expect_100_continue_returned
+		tests/unit/test_awsrequest.py::TestAWSHTTPConnection::test_expect_100_continue_sends_307
+		tests/unit/test_awsrequest.py::TestAWSHTTPConnection::test_expect_100_sends_connection_header
+		tests/unit/test_awsrequest.py::TestAWSHTTPConnection::test_handles_expect_100_with_different_reason_phrase
+		tests/unit/test_awsrequest.py::TestAWSHTTPConnection::test_state_reset_on_connection_close
+	)
+
+	epytest tests/{functional,unit} -n "$(makeopts_jobs)"
+}
diff --git a/dev-python/cfn-lint/Manifest b/dev-python/cfn-lint/Manifest
index 1bb5f028d718..3e03eda29e81 100644
--- a/dev-python/cfn-lint/Manifest
+++ b/dev-python/cfn-lint/Manifest
@@ -4,3 +4,4 @@ DIST cfn-lint-0.78.2.tar.gz 3533168 BLAKE2B 043991f54cd6d793fc91af8d911184d6a98b
 DIST cfn-lint-0.79.1.tar.gz 3539730 BLAKE2B b970f8c2f45d7895b89794661649188fb731e319c2a674526656e1ecc7572c72b143814c63b9de1998f4589228eb7df06199f4db52782384a424ced63ead9b52 SHA512 5407973f8fa6fc243112232c1028d5a19fa72855c5c569a23199ddccb1d9ac95399e88907cdc9ea1d7a2df608c3f255ad17a4b21967936817b503c159c70fc0e
 DIST cfn-lint-0.79.3.tar.gz 3541518 BLAKE2B 7d534f51bb848fe5fdb1f5a04b56483b5f5ae899fa652278ebe88898018fe03422cfe352a1606474d5622c806a07d1ce491e75c28398e871f5277e4cc310b530 SHA512 89e540977b9e3a4945ba8baba676270616e509eab75c450213b2d13d7adf5cf949bd56aa806710afe5065b8704b42a2b8a5ecf469f65190a897698d30d689a47
 DIST cfn-lint-0.79.4.tar.gz 3541700 BLAKE2B 5aa50fcf991fadc464dd2f11e57cf5fe0dc76e9715ae853997b23ef083d9d14cb1fdc943250e85d5263990671740f1499b4157d2eb41eb545685106581d71bda SHA512 8b3f655fd13df6a0e0ca9ce5e8612a6e73ca15facd12abdcd459262a712d0e4ddec5b95d50d0edd80952170bdad0e07c9089ac1b2577c78fa9d1bef18940e3bb
+DIST cfn-lint-0.79.5.tar.gz 3609256 BLAKE2B 609fe79d03a11f7b3282e0726e2c6a0ee1f76291ba55923b36d5dc979edd9e422ed3032b47ace0334bcbd18f161bfb38c3280d886d3c36c8dbfd64aa8a651658 SHA512 1a87fe83288af5f96500edd298805a77f7ba1016aeb3f9d3db2973787879548dd2b97e0470555b46d3bd78217dfe79fa2822581c091f5db5c62a211f0e949189
diff --git a/dev-python/cfn-lint/cfn-lint-0.79.5.ebuild b/dev-python/cfn-lint/cfn-lint-0.79.5.ebuild
new file mode 100644
index 000000000000..15a3078b7cf3
--- /dev/null
+++ b/dev-python/cfn-lint/cfn-lint-0.79.5.ebuild
@@ -0,0 +1,64 @@
+# 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_{7,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.71.0[${PYTHON_USEDEP}]
+	dev-python/jsonpatch[${PYTHON_USEDEP}]
+	>=dev-python/jschema_to_python-1.2.3[${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[${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.]*::' -e '/jsonschema/s:,<4.18::' -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/dkimpy/Manifest b/dev-python/dkimpy/Manifest
index bfe2e4626afb..3035072265b4 100644
--- a/dev-python/dkimpy/Manifest
+++ b/dev-python/dkimpy/Manifest
@@ -1 +1,2 @@
 DIST dkimpy-1.1.4.tar.gz 66966 BLAKE2B f07d1d704d08f5d812c3937622c4ab8a2359f9ffbb9188a5c66cdf96fc050427a9fcd58696e6f592b53026034038fe71d3f2ea2708705fe0289b26ccf36a521b SHA512 230808753228c0c3823bf7ef69f19e349dc03e734b534d3f941b1e3183a52b2b370dbbb7568f663095d003dcdbd649f2230d1548e0d140605f243350570b8830
+DIST dkimpy-1.1.5.tar.gz 67064 BLAKE2B d4b192a08469be678b5f08cdf2a582ec5cbd4ada56a02de011c372518a3c863e2fea1976af507a1d202f6a36f9ccef8621ba882f542e26ba22acc2f64daaf735 SHA512 650476a54cb39d72fefe05a6fdd8167694cd6f1cf521efb7807713ccfa868dd5458732ee8501c4edea203f9726689c9632a92473698ee31889208d19891b7a13
diff --git a/dev-python/dkimpy/dkimpy-1.1.5.ebuild b/dev-python/dkimpy/dkimpy-1.1.5.ebuild
new file mode 100644
index 000000000000..e958bf69de4f
--- /dev/null
+++ b/dev-python/dkimpy/dkimpy-1.1.5.ebuild
@@ -0,0 +1,37 @@
+# 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_{7,8,9,10,11} )
+
+inherit distutils-r1 optfeature pypi
+
+DESCRIPTION="DKIM and ARC email signing and verification library"
+HOMEPAGE="
+	https://launchpad.net/dkimpy/
+	https://pypi.org/project/dkimpy/
+"
+
+LICENSE="BSD"
+SLOT="0"
+KEYWORDS="~amd64 ~arm64 ~x86"
+
+RDEPEND="
+	>=dev-python/dnspython-2.0.0[${PYTHON_USEDEP}]
+"
+BDEPEND="
+	test? (
+		dev-python/authres[${PYTHON_USEDEP}]
+		dev-python/pynacl[${PYTHON_USEDEP}]
+	)
+"
+
+distutils_enable_tests unittest
+
+pkg_postinst() {
+	optfeature "ARC support" dev-python/authres
+	optfeature "ed25519 capability" dev-python/pynacl
+	optfeature "asyncio support" dev-python/aiodns
+}
diff --git a/dev-python/gsd/Manifest b/dev-python/gsd/Manifest
index 4c24c391f4d6..a3d5b5d8bc1c 100644
--- a/dev-python/gsd/Manifest
+++ b/dev-python/gsd/Manifest
@@ -1 +1,2 @@
 DIST gsd-3.0.1.tar.gz 106692 BLAKE2B d65b4bda7ffbba315f83a4cda8188181616a1a351d6848b91984ac97b404e5f134be567c3c616c7ff31a1402f828d76658c59b6fedeb6bcd32667ce6c7135518 SHA512 011f640aaf14e685edabd4438c93c2821cd056ba98bf2b29d3f207bf0384ccb0745580c07e1dea98790667d81d69f74b7a9a6efb019def236b515f76895a84fe
+DIST gsd-3.1.0.tar.gz 106081 BLAKE2B a3c1a13c4c733aa0f46b4f0ecd92c7055036ecee0b63d755b84f6b62d04401295cb403151bb1460a95b94d7f46abf9d8bc5b33d627cc7b15444a3478eee35651 SHA512 68a096e44584683eeff0ac13037388ffe9c8c680e371a7a1bfeff84df937a3b4860cad15a42c4766c338da59e6a9393f92a83f2546f00e0c0d013648fac50273
diff --git a/dev-python/gsd/gsd-3.1.0.ebuild b/dev-python/gsd/gsd-3.1.0.ebuild
new file mode 100644
index 000000000000..a6cedd541dcf
--- /dev/null
+++ b/dev-python/gsd/gsd-3.1.0.ebuild
@@ -0,0 +1,40 @@
+# 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_{7,8,9,10,11} )
+
+inherit distutils-r1
+
+DESCRIPTION="GSD - file format specification and a library to read and write it"
+HOMEPAGE="
+	https://github.com/glotzerlab/gsd/
+	https://pypi.org/project/gsd/
+"
+SRC_URI="
+	https://github.com/glotzerlab/gsd/releases/download/v${PV}/${P}.tar.gz
+"
+
+LICENSE="Apache-2.0"
+SLOT="0"
+KEYWORDS="~amd64 ~x86"
+
+DEPEND="
+	>=dev-python/numpy-1.24.2[${PYTHON_USEDEP}]
+"
+RDEPEND="
+	${DEPEND}
+"
+BDEPEND="
+	dev-python/cython[${PYTHON_USEDEP}]
+"
+
+distutils_enable_tests pytest
+
+python_test() {
+	cd "${T}" || die
+	epytest --pyargs gsd
+}
diff --git a/dev-python/ipykernel/ipykernel-6.24.0.ebuild b/dev-python/ipykernel/ipykernel-6.24.0.ebuild
index 2fa5f5e4d57f..b0cff0fe7b19 100644
--- a/dev-python/ipykernel/ipykernel-6.24.0.ebuild
+++ b/dev-python/ipykernel/ipykernel-6.24.0.ebuild
@@ -26,7 +26,7 @@ RDEPEND="
 	>=dev-python/jupyter-client-8[${PYTHON_USEDEP}]
 	>=dev-python/jupyter-core-4.12[${PYTHON_USEDEP}]
 	>=dev-python/matplotlib-inline-0.1[${PYTHON_USEDEP}]
-	dev-python/nest_asyncio[${PYTHON_USEDEP}]
+	dev-python/nest-asyncio[${PYTHON_USEDEP}]
 	dev-python/packaging[${PYTHON_USEDEP}]
 	dev-python/psutil[${PYTHON_USEDEP}]
 	>=dev-python/pyzmq-20[${PYTHON_USEDEP}]
diff --git a/dev-python/ipykernel/ipykernel-6.25.0.ebuild b/dev-python/ipykernel/ipykernel-6.25.0.ebuild
index 5c4918cb4970..006cd4f2efe4 100644
--- a/dev-python/ipykernel/ipykernel-6.25.0.ebuild
+++ b/dev-python/ipykernel/ipykernel-6.25.0.ebuild
@@ -26,7 +26,7 @@ RDEPEND="
 	>=dev-python/jupyter-client-8[${PYTHON_USEDEP}]
 	>=dev-python/jupyter-core-4.12[${PYTHON_USEDEP}]
 	>=dev-python/matplotlib-inline-0.1[${PYTHON_USEDEP}]
-	dev-python/nest_asyncio[${PYTHON_USEDEP}]
+	dev-python/nest-asyncio[${PYTHON_USEDEP}]
 	dev-python/packaging[${PYTHON_USEDEP}]
 	dev-python/psutil[${PYTHON_USEDEP}]
 	>=dev-python/pyzmq-20[${PYTHON_USEDEP}]
diff --git a/dev-python/mdx-gh-links/Manifest b/dev-python/mdx-gh-links/Manifest
new file mode 100644
index 000000000000..e42625fd0912
--- /dev/null
+++ b/dev-python/mdx-gh-links/Manifest
@@ -0,0 +1,2 @@
+DIST github-links-0.3.1.gh.tar.gz 7004 BLAKE2B fbb84d75ee1976f7a160e7b561413d0e2721158b812d395c5b78c8b2dfc7600561a082f9caa32fd2a1d0fec86674555258f71abaede0e539f519f1656f416e0d SHA512 3d201b00fcef7185c616534bbd16c0ce54aacf368a76c6e44328579b270ff4f34803b8c69dec958266407608b2bc3f6e8d141f803961ca65b48257d5c460c403
+DIST github-links-0.3.gh.tar.gz 6756 BLAKE2B 6b9f7e86d2ec96a6b1b9fd21f20f1964e5fbf4b3ebb33bcd6dccd2e8b811acff7e39606acbf8f48a602afb21733dbd6375e2d1ef30a2a551547fbf9582b525c6 SHA512 8f738298d8a1512e2757a3a7fed091e3a90d59b20b3d03f1a75e087b30b9f9d4876d46ced04994f98a4454a9bf4ebabc305ebf28b4441eb93e5df87822c35459
diff --git a/dev-python/mdx-gh-links/mdx-gh-links-0.3.1.ebuild b/dev-python/mdx-gh-links/mdx-gh-links-0.3.1.ebuild
new file mode 100644
index 000000000000..62425eecbef5
--- /dev/null
+++ b/dev-python/mdx-gh-links/mdx-gh-links-0.3.1.ebuild
@@ -0,0 +1,31 @@
+# Copyright 1999-2023 Gentoo Authors
+# Distributed under the terms of the GNU General Public License v2
+
+EAPI=8
+
+PYTHON_COMPAT=( python3_{7,8,9,10,11} )
+DISTUTILS_USE_PEP517=setuptools
+
+inherit distutils-r1
+
+MY_P=github-links-${PV}
+DESCRIPTION="An extension which adds links to GitHub users, repositories, issues and commits"
+HOMEPAGE="
+	https://github.com/Python-Markdown/github-links/
+	https://pypi.org/project/mdx-gh-links/
+"
+SRC_URI="
+	https://github.com/Python-Markdown/github-links/archive/${PV}.tar.gz
+		-> ${MY_P}.gh.tar.gz
+"
+S=${WORKDIR}/${MY_P}
+
+LICENSE="BSD"
+SLOT="0"
+KEYWORDS="~amd64 ~riscv ~x86"
+
+RDEPEND="
+	>=dev-python/markdown-3.0.0[${PYTHON_USEDEP}]
+"
+
+distutils_enable_tests unittest
diff --git a/dev-python/mdx_gh_links/mdx_gh_links-0.3.ebuild b/dev-python/mdx-gh-links/mdx-gh-links-0.3.ebuild
index 7ab76da882ea..7ab76da882ea 100644
--- a/dev-python/mdx_gh_links/mdx_gh_links-0.3.ebuild
+++ b/dev-python/mdx-gh-links/mdx-gh-links-0.3.ebuild
diff --git a/dev-python/mdx_gh_links/metadata.xml b/dev-python/mdx-gh-links/metadata.xml
index e4777ed2671e..e4777ed2671e 100644
--- a/dev-python/mdx_gh_links/metadata.xml
+++ b/dev-python/mdx-gh-links/metadata.xml
diff --git a/dev-python/mdx_gh_links/Manifest b/dev-python/mdx_gh_links/Manifest
deleted file mode 100644
index b6cd9505d8f5..000000000000
--- a/dev-python/mdx_gh_links/Manifest
+++ /dev/null
@@ -1 +0,0 @@
-DIST github-links-0.3.gh.tar.gz 6756 BLAKE2B 6b9f7e86d2ec96a6b1b9fd21f20f1964e5fbf4b3ebb33bcd6dccd2e8b811acff7e39606acbf8f48a602afb21733dbd6375e2d1ef30a2a551547fbf9582b525c6 SHA512 8f738298d8a1512e2757a3a7fed091e3a90d59b20b3d03f1a75e087b30b9f9d4876d46ced04994f98a4454a9bf4ebabc305ebf28b4441eb93e5df87822c35459
diff --git a/dev-python/mkdocs/mkdocs-1.4.3-r1.ebuild b/dev-python/mkdocs/mkdocs-1.4.3-r1.ebuild
index e66bcacabd7b..2be4cc575493 100644
--- a/dev-python/mkdocs/mkdocs-1.4.3-r1.ebuild
+++ b/dev-python/mkdocs/mkdocs-1.4.3-r1.ebuild
@@ -31,7 +31,7 @@ KEYWORDS="amd64 ~arm ~arm64 ~ppc ~ppc64 ~riscv x86"
 # BDEPEND="
 # 	doc? (
 # 		$(python_gen_any_dep '
-# 			dev-python/mdx_gh_links[${PYTHON_USEDEP}]
+# 			dev-python/mdx-gh-links[${PYTHON_USEDEP}]
 # 			dev-python/mkdocs-redirects[${PYTHON_USEDEP}]
 # 		')
 # 	)
diff --git a/dev-python/mkdocs/mkdocs-1.5.0.ebuild b/dev-python/mkdocs/mkdocs-1.5.0.ebuild
index 72955130b94f..dd81a8cbb706 100644
--- a/dev-python/mkdocs/mkdocs-1.5.0.ebuild
+++ b/dev-python/mkdocs/mkdocs-1.5.0.ebuild
@@ -31,7 +31,7 @@ KEYWORDS="~amd64 ~arm ~arm64 ~ppc ~ppc64 ~riscv ~x86"
 # BDEPEND="
 # 	doc? (
 # 		$(python_gen_any_dep '
-# 			dev-python/mdx_gh_links[${PYTHON_USEDEP}]
+# 			dev-python/mdx-gh-links[${PYTHON_USEDEP}]
 # 			dev-python/mkdocs-redirects[${PYTHON_USEDEP}]
 # 		')
 # 	)
diff --git a/dev-python/mkdocs/mkdocs-1.5.1.ebuild b/dev-python/mkdocs/mkdocs-1.5.1.ebuild
index 72955130b94f..dd81a8cbb706 100644
--- a/dev-python/mkdocs/mkdocs-1.5.1.ebuild
+++ b/dev-python/mkdocs/mkdocs-1.5.1.ebuild
@@ -31,7 +31,7 @@ KEYWORDS="~amd64 ~arm ~arm64 ~ppc ~ppc64 ~riscv ~x86"
 # BDEPEND="
 # 	doc? (
 # 		$(python_gen_any_dep '
-# 			dev-python/mdx_gh_links[${PYTHON_USEDEP}]
+# 			dev-python/mdx-gh-links[${PYTHON_USEDEP}]
 # 			dev-python/mkdocs-redirects[${PYTHON_USEDEP}]
 # 		')
 # 	)
diff --git a/dev-python/nbclassic/nbclassic-1.0.0.ebuild b/dev-python/nbclassic/nbclassic-1.0.0.ebuild
index b8e91cfa6bce..2bf9230d4aa2 100644
--- a/dev-python/nbclassic/nbclassic-1.0.0.ebuild
+++ b/dev-python/nbclassic/nbclassic-1.0.0.ebuild
@@ -28,7 +28,7 @@ RDEPEND="
 	>=dev-python/jupyter-core-4.6.1[${PYTHON_USEDEP}]
 	>=dev-python/nbconvert-5[${PYTHON_USEDEP}]
 	dev-python/nbformat[${PYTHON_USEDEP}]
-	>=dev-python/nest_asyncio-1.5[${PYTHON_USEDEP}]
+	>=dev-python/nest-asyncio-1.5[${PYTHON_USEDEP}]
 	>=dev-python/notebook-shim-0.2.3[${PYTHON_USEDEP}]
 	dev-python/prometheus-client[${PYTHON_USEDEP}]
 	>=dev-python/send2trash-1.8.0[${PYTHON_USEDEP}]
diff --git a/dev-python/nest_asyncio/Manifest b/dev-python/nest-asyncio/Manifest
index 092e8aa8389f..58eab65d12a4 100644
--- a/dev-python/nest_asyncio/Manifest
+++ b/dev-python/nest-asyncio/Manifest
@@ -1 +1,2 @@
 DIST nest_asyncio-1.5.6.tar.gz 7444 BLAKE2B 04b5808b3187c1155c440c903f0e1d5593f49204e6ffea2a37dc2b6112a365b94ab80823ce512a4cdf6c0799ef1c18d55fc0a841030a2cb93e0913fdf770f247 SHA512 9672cdd72b2bad7c968fa23c94e8bf8014aabf0aefd79b260503e7fe640cb7649f5c266133a4eb87aedcd99cea644fa51f8cd09d789777aca11eb64e84cf4ca5
+DIST nest_asyncio-1.5.7.tar.gz 7456 BLAKE2B 1ff61ec62a7cc90bbf293fe2190f70dd914fed673e669bf3425116435b69329f4411dc4a37df3b5be825ab8ce3d0be3cebbb3cdc6558f2771aaeef2023c8e036 SHA512 52d0a014487b4addcdc41024ddde41ed32c4b239a4bc19169b81c7553fc2e931c7a3a6848bd11b8937c721282ef2f8c0d2d352ac7852e661a48f046fb2dee2e6
diff --git a/dev-python/nest_asyncio/metadata.xml b/dev-python/nest-asyncio/metadata.xml
index a0d4c5913ba0..a0d4c5913ba0 100644
--- a/dev-python/nest_asyncio/metadata.xml
+++ b/dev-python/nest-asyncio/metadata.xml
diff --git a/dev-python/nest_asyncio/nest_asyncio-1.5.6.ebuild b/dev-python/nest-asyncio/nest-asyncio-1.5.6.ebuild
index 2ed2b37f2f8e..2ed2b37f2f8e 100644
--- a/dev-python/nest_asyncio/nest_asyncio-1.5.6.ebuild
+++ b/dev-python/nest-asyncio/nest-asyncio-1.5.6.ebuild
diff --git a/dev-python/nest-asyncio/nest-asyncio-1.5.7.ebuild b/dev-python/nest-asyncio/nest-asyncio-1.5.7.ebuild
new file mode 100644
index 000000000000..f8c03ec14c7b
--- /dev/null
+++ b/dev-python/nest-asyncio/nest-asyncio-1.5.7.ebuild
@@ -0,0 +1,21 @@
+# 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_{7,8,9,10,11} )
+
+inherit distutils-r1 pypi
+
+DESCRIPTION="Patch asyncio to allow nested event loops"
+HOMEPAGE="
+	https://github.com/erdewit/nest_asyncio/
+	https://pypi.org/project/nest-asyncio/
+"
+
+LICENSE="BSD-2"
+SLOT="0"
+KEYWORDS="~alpha ~amd64 ~arm ~arm64 ~hppa ~ia64 ~loong ~m68k ~mips ~ppc ~ppc64 ~riscv ~s390 ~sparc ~x86"
+
+distutils_enable_tests pytest
diff --git a/dev-python/notebook/notebook-6.5.4.ebuild b/dev-python/notebook/notebook-6.5.4.ebuild
index 86e9798c78e1..b5a7bfbf3af6 100644
--- a/dev-python/notebook/notebook-6.5.4.ebuild
+++ b/dev-python/notebook/notebook-6.5.4.ebuild
@@ -26,7 +26,7 @@ RDEPEND="
 	>=dev-python/jupyter-client-5.3.4[${PYTHON_USEDEP}]
 	>=dev-python/nbclassic-0.4.7[${PYTHON_USEDEP}]
 	dev-python/nbformat[${PYTHON_USEDEP}]
-	>=dev-python/nest_asyncio-1.5[${PYTHON_USEDEP}]
+	>=dev-python/nest-asyncio-1.5[${PYTHON_USEDEP}]
 	dev-python/prometheus-client[${PYTHON_USEDEP}]
 	>=dev-python/pyzmq-17[${PYTHON_USEDEP}]
 	>=dev-python/send2trash-1.8.0[${PYTHON_USEDEP}]
diff --git a/dev-python/pathspec/Manifest b/dev-python/pathspec/Manifest
index 28d3810f23a0..e72a0eba06be 100644
--- a/dev-python/pathspec/Manifest
+++ b/dev-python/pathspec/Manifest
@@ -1 +1,2 @@
 DIST pathspec-0.11.1.tar.gz 45697 BLAKE2B a97d838584959b5be5bb055773b2b8c6992d0b1f9ab2d8116adf251762c534fe9af976cf9cc9b9aae9f12de519ee3d609315ed608e543d0028c6ccc87cffbd8c SHA512 8d9d080a796c13da1bd203aa8ce8b2fae5d7d46c7fdd7706c04567eb9c7b06f643ef310119252b5ef13ebd6368b30dca0e75e96e1471aeca8d6131bc0948b04a
+DIST pathspec-0.11.2.tar.gz 47032 BLAKE2B 4a84b8d5850b226713abff743df4a7ffbef0155454337c20aad78f0fd2dd2ad802d3d0f1e557aaffbb550e85e2e051dc9829090b7a43426795dac802b8da3b7a SHA512 bb1a178db145fee8011f579fb3a87564245e94b22adfac42bda921d8e2b95cab32617379e22d8ec2bd6aa7e6f9d96c10df4503e638aabfe6b358050912ab98a8
diff --git a/dev-python/pathspec/pathspec-0.11.2.ebuild b/dev-python/pathspec/pathspec-0.11.2.ebuild
new file mode 100644
index 000000000000..7e2b66323307
--- /dev/null
+++ b/dev-python/pathspec/pathspec-0.11.2.ebuild
@@ -0,0 +1,21 @@
+# 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_{7,8,9,10,11} pypy3 )
+
+inherit distutils-r1 pypi
+
+DESCRIPTION="Utility library for gitignore style pattern matching of file paths"
+HOMEPAGE="
+	https://github.com/cpburnz/python-pathspec/
+	https://pypi.org/project/pathspec/
+"
+
+LICENSE="MPL-2.0"
+SLOT="0"
+KEYWORDS="~alpha ~amd64 ~arm ~arm64 ~hppa ~ia64 ~loong ~m68k ~ppc ~ppc64 ~riscv ~s390 ~sparc ~x86 ~amd64-linux ~x86-linux ~arm64-macos ~ppc-macos ~x64-macos ~x64-solaris"
+
+distutils_enable_tests unittest
diff --git a/dev-python/pytest-param-files/Manifest b/dev-python/pytest-param-files/Manifest
index fa3e608d14cd..de95dc54aaee 100644
--- a/dev-python/pytest-param-files/Manifest
+++ b/dev-python/pytest-param-files/Manifest
@@ -1 +1,2 @@
 DIST pytest-param-files-0.3.5.gh.tar.gz 7245 BLAKE2B 2a67c5ee30d6efb6b7ca7e3272c19c05dda460167cb1709693560ffe06b0ae39ae1b93fc5d6375f4e9cda21e3e02051424789afee55d201cfe070be8a05642ec SHA512 e80eddba2934fe5a6b68645cae243afa936ea3362a29d0b8a8ae4e11229ffb877f1ace9f41ac96d182d5787740fa76af8b106069feb95a7cab1ecc6f8d1088f9
+DIST pytest-param-files-0.5.0.gh.tar.gz 8563 BLAKE2B fa3907f3da7607caa3ab4933052ce70bc87bdf1b55983ef9660dbf0d6ae8a838d185be7f03f8ee5a1beb5771bb9f19f46fc012eea1eb7ca6331ba3c9626c72ca SHA512 cfff7ef20d453cf50a72e78d546a948d49c415c212ffba8e0ac4abe1da2decd9097930777b5aa182fb97c9c5c01e4b00bee25bd27f34c6f35a14ba7177d17a16
diff --git a/dev-python/pytest-param-files/pytest-param-files-0.5.0.ebuild b/dev-python/pytest-param-files/pytest-param-files-0.5.0.ebuild
new file mode 100644
index 000000000000..716af5014713
--- /dev/null
+++ b/dev-python/pytest-param-files/pytest-param-files-0.5.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=flit
+PYTHON_COMPAT=( python3_{7,8,9,10,11} pypy3 )
+
+inherit distutils-r1
+
+DESCRIPTION="Pytest parametrize decorators from external files."
+HOMEPAGE="
+	https://github.com/chrisjsewell/pytest-param-files/
+	https://pypi.org/project/pytest_param_files/
+"
+SRC_URI="
+	https://github.com/chrisjsewell/pytest-param-files/archive/v${PV}.tar.gz
+		-> ${P}.gh.tar.gz
+"
+
+LICENSE="MIT"
+SLOT="0"
+KEYWORDS="~alpha ~amd64 ~arm ~arm64 ~hppa ~ia64 ~m68k ~mips ~ppc ~ppc64 ~riscv ~s390 ~sparc ~x86"
+
+RDEPEND="
+	dev-python/pytest[${PYTHON_USEDEP}]
+	dev-python/pyyaml[${PYTHON_USEDEP}]
+"
+
+distutils_enable_tests pytest
diff --git a/dev-python/sqlglot/Manifest b/dev-python/sqlglot/Manifest
index e3b05d47c347..b7dcfdb891a7 100644
--- a/dev-python/sqlglot/Manifest
+++ b/dev-python/sqlglot/Manifest
@@ -1 +1,2 @@
 DIST sqlglot-17.8.4.tar.gz 8373260 BLAKE2B e3b67c940eb608a25705fd280c0165ad7f37db1fcda2f6bc55029af2ad673a789901fbb2e6af72b54d15b75bc84827afadb00cc965efdc3323587278a68f6cf5 SHA512 c1717e7e857ddb9ff700c739b76cd3714e57ae0f7b620593b4fdce53cbf8e37d39882fac1308c3277a236f695292ae1c15541e474d28bdd43d889c2756b172df
+DIST sqlglot-17.8.6.tar.gz 8382262 BLAKE2B 70c14c50cbd673122e0560d41b26076ff2d22c75d611cb751ae3df9e5f98e8392440144edcb38bde272f5a95ac85a48cb85358a75dd9b53a1b72e8133964c15c SHA512 839d10ef3d589dd258a5297dc21846e0aafd145892e4c2650aa12ea16064da1dceacd9e1f9cbd6f804b8590435db61066cb01a92b3a1d88a69b1aa8dffaeb15b
diff --git a/dev-python/sqlglot/sqlglot-17.8.6.ebuild b/dev-python/sqlglot/sqlglot-17.8.6.ebuild
new file mode 100644
index 000000000000..8a025502a820
--- /dev/null
+++ b/dev-python/sqlglot/sqlglot-17.8.6.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_{7,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 ~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/dateutil
+}