Date: Tue, 26 Jul 2022 10:53:20 GMT From: Fukang Chen <loader@FreeBSD.org> To: ports-committers@FreeBSD.org, dev-commits-ports-all@FreeBSD.org, dev-commits-ports-main@FreeBSD.org Subject: git: 8b3b5be996ab - main - databases/py-sqlite-utils: Python CLI utility and library for manipulating SQLite databases Message-ID: <202207261053.26QArKim025840@gitrepo.freebsd.org>
next in thread | raw e-mail | index | archive | help
The branch main has been updated by loader: URL: https://cgit.FreeBSD.org/ports/commit/?id=8b3b5be996ab726510d4506a9c4d26051407b309 commit 8b3b5be996ab726510d4506a9c4d26051407b309 Author: Fukang Chen <loader@FreeBSD.org> AuthorDate: 2022-07-26 08:07:53 +0000 Commit: Fukang Chen <loader@FreeBSD.org> 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 <bsd.port.mk> 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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?202207261053.26QArKim025840>