dev-python/pgspecial: Bump to 2.2.1

Signed-off-by: Michał Górny <mgorny@gentoo.org>

2 files changed, 64 insertions, 0 deletions

diff --git a/dev-python/pgspecial/Manifest b/dev-python/pgspecial/Manifest
index a837ed7b1774..c7225f4e0eef 100644
--- a/dev-python/pgspecial/Manifest
+++ b/dev-python/pgspecial/Manifest
@@ -1,2 +1,3 @@
 DIST pgspecial-2.1.3.tar.gz 51204 BLAKE2B 9dec06aba3c1389d0f2a772305dbde4218ecdcc298a325645e3c3869d9f7dc67d55c3b7dc724dbe4dde7b730ea90dd66028f71db3d5361a2618962d20fc97425 SHA512 67f7376cbad896a29e9ae76fd1f78b1e43069dc6a648eb0e68048f22420c606da437ef4b9f1b149a748161e12f061ccff2fd0682e7f2b9d2ac41003bc062b768
 DIST pgspecial-2.2.0.tar.gz 50427 BLAKE2B 762dd15f743925dd86acd7c31ec0416ea59900461ddd9e5157f7bdb3ea96bc0639be4b742a5e661b17210ed54e92375b1364135f018abb3cf91b78c0b43eb540 SHA512 af935faac4710c41beb1521c63bc8b9173a0dc26c63e5c30d6deb011d59d53a6656a12f86ac4bf4a646c83379e62fef0bd39b0ff7272faf7793fc1628bfe1304
+DIST pgspecial-2.2.1.tar.gz 50389 BLAKE2B d5077e235b6db33c2bbe128aaa64dc925b4c7e3c9403de755986f981caeb77de54d12e2ea22a5a794ca3a9c318b714c9cd6cece59bddaa1f9110b890cae35188 SHA512 46d45bb92601493359c07b679b12f79c7a4289140805fa1da92736fd01dd4bfec6699e67bcf6a52d2a22d171585084679804b49fe601d5d6675a28c4273df547
diff --git a/dev-python/pgspecial/pgspecial-2.2.1.ebuild b/dev-python/pgspecial/pgspecial-2.2.1.ebuild
new file mode 100644
index 000000000000..186a5828a413
--- /dev/null
+++ b/dev-python/pgspecial/pgspecial-2.2.1.ebuild
@@ -0,0 +1,63 @@
+# Copyright 1999-2025 Gentoo Authors
+# Distributed under the terms of the GNU General Public License v2
+
+EAPI=8
+
+DISTUTILS_USE_PEP517=setuptools
+PYTHON_COMPAT=( python3_{10..13} )
+
+inherit distutils-r1 pypi
+
+DESCRIPTION="Python implementation of PostgreSQL meta commands"
+HOMEPAGE="
+	https://github.com/dbcli/pgspecial/
+	https://pypi.org/project/pgspecial/
+"
+
+LICENSE="BSD MIT"
+SLOT="0"
+KEYWORDS="~amd64 ~arm64 ~x86"
+
+RDEPEND="
+	>=dev-python/click-4.1[${PYTHON_USEDEP}]
+	>=dev-python/configobj-5.0.6[${PYTHON_USEDEP}]
+	>=dev-python/psycopg-3.0.10:0[${PYTHON_USEDEP}]
+	>=dev-python/sqlparse-0.1.19[${PYTHON_USEDEP}]
+"
+BDEPEND="
+	test? (
+		>=dev-db/postgresql-8.1[server]
+	)
+"
+
+distutils_enable_tests pytest
+
+DOCS=( License.txt README.rst changelog.rst  )
+
+EPYTEST_DESELECT=(
+	# assumes a very specific locale
+	tests/test_specials.py::test_slash_l
+	tests/test_specials.py::test_slash_l_pattern
+	# change in postgres? *shrug*
+	tests/test_specials.py::test_slash_d_view_verbose
+	tests/test_specials.py::test_slash_dn
+	# fails with postgresql:17
+	tests/test_specials.py::test_slash_ddp
+	tests/test_specials.py::test_slash_ddp_pattern
+)
+
+src_test() {
+	local db=${T}/pgsql
+
+	initdb --username=postgres -D "${db}" || die
+	# TODO: random port
+	pg_ctl -w -D "${db}" start \
+		-o "-h '127.0.0.1' -p 5432 -k '${T}'" || die
+	psql -h "${T}" -U postgres -d postgres \
+		-c "ALTER ROLE postgres WITH PASSWORD 'postgres';" || die
+	createdb -h "${T}" -U postgres _test_db || die
+
+	distutils-r1_src_test
+
+	pg_ctl -w -D "${db}" stop || die
+}