From nobody Thu Aug 08 15:32:15 2024 X-Original-To: dev-commits-ports-main@mlmmj.nyi.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mlmmj.nyi.freebsd.org (Postfix) with ESMTP id 4WfrdC6rpQz5T4KN; Thu, 08 Aug 2024 15:32:15 +0000 (UTC) (envelope-from git@FreeBSD.org) Received: from mxrelay.nyi.freebsd.org (mxrelay.nyi.freebsd.org [IPv6:2610:1c1:1:606c::19:3]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256 client-signature RSA-PSS (4096 bits) client-digest SHA256) (Client CN "mxrelay.nyi.freebsd.org", Issuer "R11" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 4WfrdC6PNPz4GqR; Thu, 8 Aug 2024 15:32:15 +0000 (UTC) (envelope-from git@FreeBSD.org) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=freebsd.org; s=dkim; t=1723131135; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding; bh=ra0w8GuRzeRlVe493/mq3fPolnTKiIcIhUkpeSEgLZg=; b=L6OnrYlknJ/fYkAQiTkPhD/i8+eF5ZIQV7HBQ6Zmx/hRDZn9mOc9HIhsx2Mw+A85EltXTS +VmgOenGjhOQSKrngUYMVghZBZ5OygmuZkMxkfwnoEhzhCVKuGSmx5ofErTkqq5Yu8mBrZ TNAHMI2/FSWLMQsKOb7YCdyWGVGJTW4LSLb+4c9+v2AJda7nBRMH6oAj05B0JjZ4um1i+e LpZXo6bkRyTzSNshPUi483ja1giX+4Y+Hio16SXy9CLVxdr+NstMswdMAY87NHsCJ9s8p4 KBIXe6nh2LhXuxDsuLDshl5zZI6dPBvC47iwCur1r7nxunbWDn69r1o5F3P+lw== ARC-Seal: i=1; s=dkim; d=freebsd.org; t=1723131135; a=rsa-sha256; cv=none; b=sz+m4+VngG4/UhOsASHE102anvX1x00zbJoIjadHOA7tTfdjejRFEiPM1PFSFB/aoi3rOK mWVP42xMeMkZ0xmo+kPUCPidzoAmceKZdaeF4RiU3KWeA7Hh0PJz6sDwiBRkPqECRja/pr Ef2Ruqo5bjFaftmDiuiN31MvcnY/7BY3HxqpOAvWLbz+9Yz2zRVZ42nUSi8RCzlenuDPiA YvtUeO0Y5jx39dCVWXz0EtFLlht9cgLQQYr3fo3J3WLjGRrINeuiaUayVnUboPNiCcMASy ZGsKSQWGbkA2MIQ8/YSJUKlJo9z6x3QLeqQd/FkVFm4elQJfcO/YqxlSr0DITQ== ARC-Authentication-Results: i=1; mx1.freebsd.org; none ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=freebsd.org; s=dkim; t=1723131135; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding; bh=ra0w8GuRzeRlVe493/mq3fPolnTKiIcIhUkpeSEgLZg=; b=wILypAxJ6tToybbyVzJIJM7hyC9LP7CMRYUORLWed23gX7U23JfsaNRtKpGGJTe7Pr9AUN QCcEUIb64/b1v0U9tvN3eUuDl4rHwtmzCGjqnOJVDa1BZsaRL61w8eLWD+p/RYwDrxKP3l t0EFXJN1Boq6eFEfatg6UFTQBWshObtVXrHdmsM/M3saNJhKhXYqVR3Sdln/+BrbJysMum Ac/ruxvCGJ12SrP+WxA9hwuBfLvv4JJ+KodaiU5Qm5JHEDDFrfxSXhxZVBTQS9l7FKVH7R JGbmwahP2czWoM0O9MQZD5lFdp64uFbjgpYYaCMrqmEWEfoUW+QH1Az98kAx0A== Received: from gitrepo.freebsd.org (gitrepo.freebsd.org [IPv6:2610:1c1:1:6068::e6a:5]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256) (Client did not present a certificate) by mxrelay.nyi.freebsd.org (Postfix) with ESMTPS id 4WfrdC5hS1zfPP; Thu, 8 Aug 2024 15:32:15 +0000 (UTC) (envelope-from git@FreeBSD.org) Received: from gitrepo.freebsd.org ([127.0.1.44]) by gitrepo.freebsd.org (8.18.1/8.18.1) with ESMTP id 478FWFEk056477; Thu, 8 Aug 2024 15:32:15 GMT (envelope-from git@gitrepo.freebsd.org) Received: (from git@localhost) by gitrepo.freebsd.org (8.18.1/8.18.1/Submit) id 478FWFl3056474; Thu, 8 Aug 2024 15:32:15 GMT (envelope-from git) Date: Thu, 8 Aug 2024 15:32:15 GMT Message-Id: <202408081532.478FWFl3056474@gitrepo.freebsd.org> To: ports-committers@FreeBSD.org, dev-commits-ports-all@FreeBSD.org, dev-commits-ports-main@FreeBSD.org From: Nicola Vitale Subject: git: 9eb654981e81 - main - databases/py-aiosql: Add new port List-Id: Commits to the main branch of the FreeBSD ports repository List-Archive: https://lists.freebsd.org/archives/dev-commits-ports-main List-Help: List-Post: List-Subscribe: List-Unsubscribe: X-BeenThere: dev-commits-ports-main@freebsd.org Sender: owner-dev-commits-ports-main@FreeBSD.org MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit X-Git-Committer: nivit X-Git-Repository: ports X-Git-Refname: refs/heads/main X-Git-Reftype: branch X-Git-Commit: 9eb654981e811e75b0d120acbbce5f8a892ddb62 Auto-Submitted: auto-generated The branch main has been updated by nivit: URL: https://cgit.FreeBSD.org/ports/commit/?id=9eb654981e811e75b0d120acbbce5f8a892ddb62 commit 9eb654981e811e75b0d120acbbce5f8a892ddb62 Author: Nicola Vitale AuthorDate: 2024-08-08 15:30:52 +0000 Commit: Nicola Vitale 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 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.