Add pyXX-agate-sql package

[Aleksey Cheusov <vle%gmx.net@localhost>]

Module Name:	pkgsrc-wip
Committed By:	Aleksey Cheusov <vle%gmx.net@localhost>
Pushed By:	cheusov
Date:		Wed May 8 00:47:15 2024 +0400
Changeset:	a57a42c090d66bd5ea96f3961a4e86de4e371e04

Modified Files:
	Makefile
Added Files:
	py-agate-sql/DESCR
	py-agate-sql/Makefile
	py-agate-sql/PLIST
	py-agate-sql/distinfo
	py-agate-sql/patches/patch-tests_test__agatesql.py

Log Message:
Add pyXX-agate-sql package

To see a diff of this commit:
https://wip.pkgsrc.org/cgi-bin/gitweb.cgi?p=pkgsrc-wip.git;a=commitdiff;h=a57a42c090d66bd5ea96f3961a4e86de4e371e04

Please note that diffs are not public domain; they are subject to the
copyright notices on the relevant files.

diffstat:
 Makefile                                           |  1 +
 py-agate-sql/DESCR                                 |  7 +++++++
 py-agate-sql/Makefile                              | 22 ++++++++++++++++++++++
 py-agate-sql/PLIST                                 | 13 +++++++++++++
 py-agate-sql/distinfo                              |  6 ++++++
 py-agate-sql/patches/patch-tests_test__agatesql.py | 13 +++++++++++++
 6 files changed, 62 insertions(+)

diffs:
diff --git a/Makefile b/Makefile
index ed85cb8509..8a4a529496 100644
--- a/Makefile
+++ b/Makefile
@@ -3205,6 +3205,7 @@ SUBDIR+=	py-affine
 SUBDIR+=	py-agaro
 SUBDIR+=	py-agate
 SUBDIR+=	py-agate-excel
+SUBDIR+=	py-agate-sql
 SUBDIR+=	py-ahoy
 SUBDIR+=	py-aikif
 SUBDIR+=	py-aioconsole
diff --git a/py-agate-sql/DESCR b/py-agate-sql/DESCR
new file mode 100644
index 0000000000..71a26ffec4
--- /dev/null
+++ b/py-agate-sql/DESCR
@@ -0,0 +1,7 @@
+agate-sql adds SQL read/write support to agate.
+
+Important links:
+    agate https://agate.rtfd.org
+    Documentation: https://agate-sql.rtfd.org
+    Repository: https://github.com/wireservice/agate-sql
+    Issues: https://github.com/wireservice/agate-sql/issues
diff --git a/py-agate-sql/Makefile b/py-agate-sql/Makefile
new file mode 100644
index 0000000000..a83c77fa7e
--- /dev/null
+++ b/py-agate-sql/Makefile
@@ -0,0 +1,22 @@
+# $NetBSD$
+
+DISTNAME=	agate-sql-0.7.2
+PKGNAME=	${PYPKGPREFIX}-${DISTNAME}
+CATEGORIES=	databases python
+MASTER_SITES=	${MASTER_SITE_PYPI:=a/agate-sql/}
+
+MAINTAINER=	pkgsrc-users%NetBSD.org@localhost
+HOMEPAGE=	https://agate-sql.readthedocs.io/
+COMMENT=	SQL read/write support to agate
+LICENSE=	mit
+
+DEPENDS+=	${PYPKGPREFIX}-agate-[0-9]*:../../wip/py-agate
+DEPENDS+=	${PYPKGPREFIX}-sqlalchemy-[0-9]*:../../databases/py-sqlalchemy
+DEPENDS+=	${PYPKGPREFIX}-sqlalchemy-utils-[0-9]*:../../databases/py-sqlalchemy-utils
+
+USE_LANGUAGES=	# none
+
+#PYTHON_VERSIONS_INCOMPATIBLE=	27
+
+.include "../../lang/python/wheel.mk"
+.include "../../mk/bsd.pkg.mk"
diff --git a/py-agate-sql/PLIST b/py-agate-sql/PLIST
new file mode 100644
index 0000000000..8a14de420f
--- /dev/null
+++ b/py-agate-sql/PLIST
@@ -0,0 +1,13 @@
+@comment $NetBSD$
+${PYSITELIB}/${WHEEL_INFODIR}/AUTHORS.rst
+${PYSITELIB}/${WHEEL_INFODIR}/COPYING
+${PYSITELIB}/${WHEEL_INFODIR}/METADATA
+${PYSITELIB}/${WHEEL_INFODIR}/RECORD
+${PYSITELIB}/${WHEEL_INFODIR}/WHEEL
+${PYSITELIB}/${WHEEL_INFODIR}/top_level.txt
+${PYSITELIB}/agatesql/__init__.py
+${PYSITELIB}/agatesql/__init__.pyc
+${PYSITELIB}/agatesql/__init__.pyo
+${PYSITELIB}/agatesql/table.py
+${PYSITELIB}/agatesql/table.pyc
+${PYSITELIB}/agatesql/table.pyo
diff --git a/py-agate-sql/distinfo b/py-agate-sql/distinfo
new file mode 100644
index 0000000000..71f88a4be1
--- /dev/null
+++ b/py-agate-sql/distinfo
@@ -0,0 +1,6 @@
+$NetBSD$
+
+BLAKE2s (agate-sql-0.7.2.tar.gz) = 7f50452ab2cdf45de78336d54e4fe969fba9e8f5f39ffeda2fcea25e8b28213d
+SHA512 (agate-sql-0.7.2.tar.gz) = c24026d93479003672efaa04654719183eb69bd86d24916f2618ed88ebbe8b51f2dac3c6fcbfd3c18643fbab0a2564670909350e1379eca621ccd42ab411251e
+Size (agate-sql-0.7.2.tar.gz) = 13695 bytes
+SHA1 (patch-tests_test__agatesql.py) = 03253c35050f9442bb7b11f12dca2f68844e31eb
diff --git a/py-agate-sql/patches/patch-tests_test__agatesql.py b/py-agate-sql/patches/patch-tests_test__agatesql.py
new file mode 100644
index 0000000000..ee8da557dc
--- /dev/null
+++ b/py-agate-sql/patches/patch-tests_test__agatesql.py
@@ -0,0 +1,13 @@
+$NetBSD$
+
+--- tests/test_agatesql.py.orig	2024-01-09 23:17:02.000000000 +0000
++++ tests/test_agatesql.py
+@@ -166,7 +166,7 @@ class TestSQL(agate.AgateTestCase):
+         self.assertEqual(statement.replace('\t', '  '), dedent(expected))
+ 
+     def test_to_sql_create_statement_with_dialects(self):
+-        for dialect in ['crate', 'mssql', 'mysql', 'postgresql', 'sqlite']:
++        for dialect in ['mssql', 'mysql', 'postgresql', 'sqlite']:
+             self.table.to_sql_create_statement('test_table', dialect=dialect)
+ 
+     def test_to_sql_create_statement_zero_width(self):