From nobody Tue Jul 26 10:53:20 2022 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 4LsYfn1Rq3z4WfHn; Tue, 26 Jul 2022 10:53:21 +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 "R3" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 4LsYfn0tbZz3q6G; Tue, 26 Jul 2022 10:53:21 +0000 (UTC) (envelope-from git@FreeBSD.org) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=freebsd.org; s=dkim; t=1658832801; 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=C7OaNfnkn9Z2D3fzyNdI7sJbdJ2c5RMsk8pn4w6hB0M=; b=dbpErNN805REvHZRVt2mZ7Eyta0/DSbQYFX4tFVmBRpg4jKmEC+gwaQUtTH/2ypQTQec2w YI5IlS54G0ywY9UV7R3nL/TuAH3Inozf7D2iekGa3RTJEjcafEVK25hv0tuxNVXYjqT9a5 K4YCObipv7+ZjUo/5sjwmoSM5p8DtAmC6H65dhNxGFNGlrYWAoW0U4pZegk808cvyb0oya tl5Lm6ZVfILRnUwstykgCEkN9S/0b4pl+ZrbqMKwm6g4yHO9CTAD1vbru2baO5CirV8CCB RqRjjcw2TVEURX9yPDwE/0TtnwqO8rkvulP4ci1qh4xBNRTh9W+baBUqWIFsfA== 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 4LsYfm71wxzZMC; Tue, 26 Jul 2022 10:53:20 +0000 (UTC) (envelope-from git@FreeBSD.org) Received: from gitrepo.freebsd.org ([127.0.1.44]) by gitrepo.freebsd.org (8.16.1/8.16.1) with ESMTP id 26QArKx6025841; Tue, 26 Jul 2022 10:53:20 GMT (envelope-from git@gitrepo.freebsd.org) Received: (from git@localhost) by gitrepo.freebsd.org (8.16.1/8.16.1/Submit) id 26QArKim025840; Tue, 26 Jul 2022 10:53:20 GMT (envelope-from git) Date: Tue, 26 Jul 2022 10:53:20 GMT Message-Id: <202207261053.26QArKim025840@gitrepo.freebsd.org> To: ports-committers@FreeBSD.org, dev-commits-ports-all@FreeBSD.org, dev-commits-ports-main@FreeBSD.org From: Fukang Chen Subject: git: 8b3b5be996ab - main - databases/py-sqlite-utils: Python CLI utility and library for manipulating SQLite databases 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: Sender: owner-dev-commits-ports-main@freebsd.org X-BeenThere: dev-commits-ports-main@freebsd.org MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit X-Git-Committer: loader X-Git-Repository: ports X-Git-Refname: refs/heads/main X-Git-Reftype: branch X-Git-Commit: 8b3b5be996ab726510d4506a9c4d26051407b309 Auto-Submitted: auto-generated ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=freebsd.org; s=dkim; t=1658832801; 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=C7OaNfnkn9Z2D3fzyNdI7sJbdJ2c5RMsk8pn4w6hB0M=; b=RfeSdUVSmbcH8a8B9nTEZ+Chx/OnXCL/U1+ldam+A8wjJNRZwKnaYbezTeoeUzdEukd1og JTnwE2pnelh4uaNcua1BhpUtRJc096qEJGNKnFyQ5+nv7JLHByE2qoWDsocgE8eamuYluM vhUJFdQtRhPpPU0LQjmDlXwdSg+49txwlkRHfi0zuYb7UCfr1SqR3xrtJgG77Bt0UScksH 2VOb6PPvVHImJp8Y35CX450rsu/xihLlXNZnXFV9lDXCFPMCKUaA/unSQMwGwuJ8YFjv1V WUQoEy4vJPiKowRRsBs07RSFQHuVJQV6L+dZsSHTfaEktfyEcfHbg5fDCYocsA== ARC-Seal: i=1; s=dkim; d=freebsd.org; t=1658832801; a=rsa-sha256; cv=none; b=vH0vpOqcOaoUd/Izm8ICLuuuhKpw+p1KGauAjiz0Mou5zE5rngdUbpZ56SDO4dFDaXUHkq woDw88vGIc+uxmVOsDy/czshuYipQ4ZU1gGQjyYUtEtPP9r+h/VNDno1nxdkMqgmmgzLoc dRoECN560QTvvwWeCv9fxFGTaOrM3bjwbqYkSdZA0pNfeebNKgdQaooQARabmDflDB/ZOZ xQDLrsj+FoAaAXvbsLPDSZ8+Tt8NRmX20dknRUXE/zb6iISdnn3+BsfI9BZiCdw2KcK83J ekfJt/mXnU5G5f0p27cL0NEsLmO9Mhpf+roseeHHreXNsFCqSsjJMRUbf260kw== ARC-Authentication-Results: i=1; mx1.freebsd.org; none X-ThisMailContainsUnwantedMimeParts: N The branch main has been updated by loader: URL: https://cgit.FreeBSD.org/ports/commit/?id=8b3b5be996ab726510d4506a9c4d26051407b309 commit 8b3b5be996ab726510d4506a9c4d26051407b309 Author: Fukang Chen AuthorDate: 2022-07-26 08:07:53 +0000 Commit: Fukang Chen CommitDate: 2022-07-26 10:51:15 +0000 databases/py-sqlite-utils: Python CLI utility and library for manipulating SQLite databases Python CLI utility and library for manipulating SQLite databases. Some feature highlights * Pipe JSON (or CSV or TSV) directly into a new SQLite database file, automatically creating a table with the appropriate schema * Run in-memory SQL queries, including joins, directly against data in CSV, TSV or JSON files and view the results * Configure SQLite full-text search against your database tables and run search queries against them, ordered by relevance * Run transformations against your tables to make schema changes that SQLite ALTER TABLE does not directly support, such as changing the type of a column * Extract columns into separate tables to better normalize your existing data WWW: https://github.com/simonw/sqlite-utils --- databases/Makefile | 1 + databases/py-sqlite-utils/Makefile | 25 +++++++++++++++++++++++++ databases/py-sqlite-utils/distinfo | 3 +++ databases/py-sqlite-utils/pkg-descr | 17 +++++++++++++++++ 4 files changed, 46 insertions(+) diff --git a/databases/Makefile b/databases/Makefile index 0400fab0b390..d3cfbd679fd4 100644 --- a/databases/Makefile +++ b/databases/Makefile @@ -833,6 +833,7 @@ SUBDIR += py-sqlalchemy13 SUBDIR += py-sqlalchemy14 SUBDIR += py-sqlite-fts4 + SUBDIR += py-sqlite-utils SUBDIR += py-sqlite3 SUBDIR += py-sqlobject SUBDIR += py-sqlparse diff --git a/databases/py-sqlite-utils/Makefile b/databases/py-sqlite-utils/Makefile new file mode 100644 index 000000000000..7897e7c7e64d --- /dev/null +++ b/databases/py-sqlite-utils/Makefile @@ -0,0 +1,25 @@ +PORTNAME= sqlite-utils +PORTVERSION= 3.28 +CATEGORIES= databases python +MASTER_SITES= CHEESESHOP +PKGNAMEPREFIX= ${PYTHON_PKGNAMEPREFIX} + +MAINTAINER= loader@FreeBSD.org +COMMENT= Python CLI utility and library for manipulating SQLite databases + +LICENSE= BSD2CLAUSE +LICENSE_FILE= ${WRKSRC}/LICENSE + +RUN_DEPENDS= ${PYTHON_PKGNAMEPREFIX}sqlite-fts4>0:databases/py-sqlite-fts4@${PY_FLAVOR} \ + ${PYTHON_PKGNAMEPREFIX}click>0:devel/py-click@${PY_FLAVOR} \ + ${PYTHON_PKGNAMEPREFIX}click-default-group>0:devel/py-click-default-group@${PY_FLAVOR} \ + ${PYTHON_PKGNAMEPREFIX}tabulate>0:devel/py-tabulate@${PY_FLAVOR} \ + ${PYTHON_PKGNAMEPREFIX}dateutil>0:devel/py-dateutil@${PY_FLAVOR} +TEST_DEPENDS= ${PYTHON_PKGNAMEPREFIX}hypothesis>0:devel/py-hypothesis@${PY_FLAVOR} + +USES= python:3.6+ +USE_PYTHON= autoplist concurrent distutils pytest + +NO_ARCH= yes + +.include diff --git a/databases/py-sqlite-utils/distinfo b/databases/py-sqlite-utils/distinfo new file mode 100644 index 000000000000..7a2d9319ddef --- /dev/null +++ b/databases/py-sqlite-utils/distinfo @@ -0,0 +1,3 @@ +TIMESTAMP = 1658735281 +SHA256 (sqlite-utils-3.28.tar.gz) = 790b01f4be16c32756b9b5eae07b6b7c905b6613ca538d646877c50b05b0a53a +SIZE (sqlite-utils-3.28.tar.gz) = 188238 diff --git a/databases/py-sqlite-utils/pkg-descr b/databases/py-sqlite-utils/pkg-descr new file mode 100644 index 000000000000..7850324bb5ba --- /dev/null +++ b/databases/py-sqlite-utils/pkg-descr @@ -0,0 +1,17 @@ +Python CLI utility and library for manipulating SQLite databases. + +Some feature highlights + +* Pipe JSON (or CSV or TSV) directly into a new SQLite database + file, automatically creating a table with the appropriate schema +* Run in-memory SQL queries, including joins, directly against data + in CSV, TSV or JSON files and view the results +* Configure SQLite full-text search against your database tables + and run search queries against them, ordered by relevance +* Run transformations against your tables to make schema changes + that SQLite ALTER TABLE does not directly support, such as + changing the type of a column +* Extract columns into separate tables to better normalize your + existing data + +WWW: https://github.com/simonw/sqlite-utils