git: 9eb654981e81 - main - databases/py-aiosql: Add new port

From: Nicola Vitale <nivit_at_FreeBSD.org>
Date: Thu, 08 Aug 2024 15:32:15 UTC
The branch main has been updated by nivit:

URL: https://cgit.FreeBSD.org/ports/commit/?id=9eb654981e811e75b0d120acbbce5f8a892ddb62

commit 9eb654981e811e75b0d120acbbce5f8a892ddb62
Author:     Nicola Vitale <nivit@FreeBSD.org>
AuthorDate: 2024-08-08 15:30:52 +0000
Commit:     Nicola Vitale <nivit@FreeBSD.org>
CommitDate: 2024-08-08 15:31:51 +0000

    databases/py-aiosql: Add new port
    
    SQL is code. Write it, version control it, comment it, and run it using files.
    Writing your SQL code in Python programs as strings doesn't allow you to easily
    reuse them in SQL GUIs or CLI tools like psql. With aiosql you can organize
    your SQL statements in .sql files, load them into your python application as
    methods to call without losing the ability to use them as you would any other
    SQL file.
    
    https://pypi.org/project/aiosql/
---
 databases/Makefile            |  1 +
 databases/py-aiosql/Makefile  | 21 +++++++++++++++++++++
 databases/py-aiosql/distinfo  |  3 +++
 databases/py-aiosql/pkg-descr |  6 ++++++
 4 files changed, 31 insertions(+)

diff --git a/databases/Makefile b/databases/Makefile
index 998cc9f0de97..0e1e3f72e7c7 100644
--- a/databases/Makefile
+++ b/databases/Makefile
@@ -749,6 +749,7 @@
     SUBDIR += py-aiomysql
     SUBDIR += py-aiopg
     SUBDIR += py-aioredis
+    SUBDIR += py-aiosql
     SUBDIR += py-aiosqlite
     SUBDIR += py-alembic
     SUBDIR += py-apache-arrow
diff --git a/databases/py-aiosql/Makefile b/databases/py-aiosql/Makefile
new file mode 100644
index 000000000000..7a024b47a7f7
--- /dev/null
+++ b/databases/py-aiosql/Makefile
@@ -0,0 +1,21 @@
+PORTNAME=	aiosql
+DISTVERSION=	10.4
+CATEGORIES=	databases python
+MASTER_SITES=	PYPI
+PKGNAMEPREFIX=	${PYTHON_PKGNAMEPREFIX}
+
+MAINTAINER=	nivit@FreeBSD.org
+COMMENT=	Simple SQL in Python
+WWW=		https://pypi.org/project/aiosql/
+
+LICENSE=	BSD2CLAUSE
+LICENSE_FILE=	${WRKSRC}/LICENSE
+
+BUILD_DEPENDS=	${PYTHON_PKGNAMEPREFIX}setuptools-scm>=6.4:devel/py-setuptools-scm@${PY_FLAVOR} \
+		${PYTHON_PKGNAMEPREFIX}setuptools>=42:devel/py-setuptools@${PY_FLAVOR} \
+		${PYTHON_PKGNAMEPREFIX}wheel>=0.44.0:devel/py-wheel@${PY_FLAVOR}
+
+USES=		python
+USE_PYTHON=	autoplist pep517
+
+.include <bsd.port.mk>
diff --git a/databases/py-aiosql/distinfo b/databases/py-aiosql/distinfo
new file mode 100644
index 000000000000..dd0a61ebd59f
--- /dev/null
+++ b/databases/py-aiosql/distinfo
@@ -0,0 +1,3 @@
+TIMESTAMP = 1723123592
+SHA256 (aiosql-10.4.tar.gz) = e75e9e95587de0332f232c160752aaaf1e937047d05a65760d878e0fabae38aa
+SIZE (aiosql-10.4.tar.gz) = 65703
diff --git a/databases/py-aiosql/pkg-descr b/databases/py-aiosql/pkg-descr
new file mode 100644
index 000000000000..c6e3cf10999b
--- /dev/null
+++ b/databases/py-aiosql/pkg-descr
@@ -0,0 +1,6 @@
+SQL is code. Write it, version control it, comment it, and run it using files.
+Writing your SQL code in Python programs as strings doesn't allow you to easily
+reuse them in SQL GUIs or CLI tools like psql. With aiosql you can organize
+your SQL statements in .sql files, load them into your python application as
+methods to call without losing the ability to use them as you would any other
+SQL file.