From nobody Sun Sep 04 03:52:13 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 4MKyQQ1pT5z4bFr7; Sun, 4 Sep 2022 03:52:14 +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 4MKyQP6Ltbz3R3Y; Sun, 4 Sep 2022 03:52:13 +0000 (UTC) (envelope-from git@FreeBSD.org) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=freebsd.org; s=dkim; t=1662263533; 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=M1BIaLiOFsRZW7+QCYQlKR0lApjeIe9J02l6ZrC2zdY=; b=TSu7cLDLhpM0qvde2fTqgLxwGQAFe2oyQr8+kiA6FYppG4/FxE5EqlILUw8R1IZPa2rMdM tjR8fVWvaZgzUkr/5PFP2SQXY+jHb/y5u0pQLlbIUqBIIXq82IenI16ogjJgufqM0ecDp+ 39u27OspzgyjNsqbTQL3jt0iechf+d+FLxrXi8P7x/LYl3iQt4nLLSwuSokcFo33ByNsGi EPWb2OtBD1DZmES79IVcvQ7MpRXJEhDG2YWtwd3kA3dNWpmkTme2UCwrPEdC+gGvIzPfUh JaDK4JG7yqnvqG7D/Uf4QtWmy50rWZThJmHL25XE7S+gEJlpPabfw7pGhLBeZg== 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 4MKyQP5D3XzMs8; Sun, 4 Sep 2022 03:52:13 +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 2843qDTB083366; Sun, 4 Sep 2022 03:52:13 GMT (envelope-from git@gitrepo.freebsd.org) Received: (from git@localhost) by gitrepo.freebsd.org (8.16.1/8.16.1/Submit) id 2843qDk9083365; Sun, 4 Sep 2022 03:52:13 GMT (envelope-from git) Date: Sun, 4 Sep 2022 03:52:13 GMT Message-Id: <202209040352.2843qDk9083365@gitrepo.freebsd.org> To: ports-committers@FreeBSD.org, dev-commits-ports-all@FreeBSD.org, dev-commits-ports-main@FreeBSD.org From: Po-Chuan Hsieh Subject: git: 757662b297a6 - main - databases/py-sqlglot: Add py-sqlglot 5.3.1 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: sunpoet X-Git-Repository: ports X-Git-Refname: refs/heads/main X-Git-Reftype: branch X-Git-Commit: 757662b297a6a0e64b3d823e83484df6af8ffc13 Auto-Submitted: auto-generated ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=freebsd.org; s=dkim; t=1662263533; 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=M1BIaLiOFsRZW7+QCYQlKR0lApjeIe9J02l6ZrC2zdY=; b=No7EbNc2oJ2fPRVc9a9s8RzKWFNxgROdjEFFeB1RNPTlG2MbeUFBzbIju+odC+J6bdBqC0 w8ECxIFWAiTwQAG4L+jL7PhPAkhujRqqsySTeX/zCn+6WN13ng+gGru5dokVNDWFaUZq9b yCxmZIueX2b1NT7qOvI33RbMpxSu2PX32347pRFKO1iltKFCVQ0R0AlkS8TFxcLaTWWeDD cjlNFIJDZWzKS0t9JBbKO0vnprpgngOCa4L5zsZU4/oe+UijszcfI+vclIbmveFHmEamXQ PoiZHnWSjRGXbltr4q4zDxc6a8G8sMU90hvDYxuhYuv+kdDdwVm73vXIfbtaWw== ARC-Seal: i=1; s=dkim; d=freebsd.org; t=1662263533; a=rsa-sha256; cv=none; b=MkXugCK8Diz338K1SWghwczVgkGSLaikRMEyqmfiOLDkHGi8Hm8+5tAlpBcHInUYn+d+W8 c8YaxNwzNkuHxICumrbViRrhZBi0MvSzZfBrf6VuOiVFDZABAPRuob5fUkjussQ0zL2m3K QbUbO7/nOLub/tf2eZXgUYpCvu4sDna5+MOUC2Q6mdPjlb+Drc1y/TBzsl6rNybKM4/roa FfvrIHD83d5mKcw0ii4Z3dUqkFas82jD1DueCgR5XVtur5GheKEc3GKJCBYb3supSSHZ9/ cyPtn3EmKbegcMVHPPStgREyiP27OF2410diCwpSh5z5abrxXsBNgeBvEpOfNQ== ARC-Authentication-Results: i=1; mx1.freebsd.org; none X-ThisMailContainsUnwantedMimeParts: N The branch main has been updated by sunpoet: URL: https://cgit.FreeBSD.org/ports/commit/?id=757662b297a6a0e64b3d823e83484df6af8ffc13 commit 757662b297a6a0e64b3d823e83484df6af8ffc13 Author: Po-Chuan Hsieh AuthorDate: 2022-09-04 03:41:28 +0000 Commit: Po-Chuan Hsieh CommitDate: 2022-09-04 03:41:28 +0000 databases/py-sqlglot: Add py-sqlglot 5.3.1 SQLGlot is a no dependency Python SQL parser, transpiler, and optimizer. It can be used to format SQL or translate between different dialects like DuckDB, Presto, Spark, and BigQuery. It aims to read a wide variety of SQL inputs and output syntactically correct SQL in the targeted dialects. It is a very comprehensive generic SQL parser with a robust test suite. It is also quite performant while being written purely in Python. You can easily customize the parser, analyze queries, traverse expression trees, and programmatically build SQL. Syntax errors are highlighted and dialect incompatibilities can warn or raise depending on configurations. WWW: https://github.com/tobymao/sqlglot --- databases/Makefile | 1 + databases/py-sqlglot/Makefile | 18 ++++++++++++++++++ databases/py-sqlglot/distinfo | 3 +++ databases/py-sqlglot/pkg-descr | 15 +++++++++++++++ 4 files changed, 37 insertions(+) diff --git a/databases/Makefile b/databases/Makefile index c484f02fa6d0..949033aedadd 100644 --- a/databases/Makefile +++ b/databases/Makefile @@ -833,6 +833,7 @@ SUBDIR += py-sqlalchemy12 SUBDIR += py-sqlalchemy13 SUBDIR += py-sqlalchemy14 + SUBDIR += py-sqlglot SUBDIR += py-sqlite-fts4 SUBDIR += py-sqlite-utils SUBDIR += py-sqlite3 diff --git a/databases/py-sqlglot/Makefile b/databases/py-sqlglot/Makefile new file mode 100644 index 000000000000..76fdfe3e57bd --- /dev/null +++ b/databases/py-sqlglot/Makefile @@ -0,0 +1,18 @@ +PORTNAME= sqlglot +PORTVERSION= 5.3.1 +CATEGORIES= databases python +MASTER_SITES= CHEESESHOP +PKGNAMEPREFIX= ${PYTHON_PKGNAMEPREFIX} + +MAINTAINER= sunpoet@FreeBSD.org +COMMENT= Easily customizable SQL parser and transpiler + +LICENSE= MIT +LICENSE_FILE= ${WRKSRC}/LICENSE + +USES= python:3.7+ +USE_PYTHON= autoplist concurrent distutils + +NO_ARCH= yes + +.include diff --git a/databases/py-sqlglot/distinfo b/databases/py-sqlglot/distinfo new file mode 100644 index 000000000000..e34306292a1a --- /dev/null +++ b/databases/py-sqlglot/distinfo @@ -0,0 +1,3 @@ +TIMESTAMP = 1662212102 +SHA256 (sqlglot-5.3.1.tar.gz) = 615d7bf589ed167972d98edc74657e2063254ebea0812eb6e06245dd928193fb +SIZE (sqlglot-5.3.1.tar.gz) = 90651 diff --git a/databases/py-sqlglot/pkg-descr b/databases/py-sqlglot/pkg-descr new file mode 100644 index 000000000000..3539cee7bb27 --- /dev/null +++ b/databases/py-sqlglot/pkg-descr @@ -0,0 +1,15 @@ +SQLGlot is a no dependency Python SQL parser, transpiler, and optimizer. It can +be used to format SQL or translate between different dialects like DuckDB, +Presto, Spark, and BigQuery. It aims to read a wide variety of SQL inputs and +output syntactically correct SQL in the targeted dialects. + +It is a very comprehensive generic SQL parser with a robust test suite. It is +also quite performant while being written purely in Python. + +You can easily customize the parser, analyze queries, traverse expression trees, +and programmatically build SQL. + +Syntax errors are highlighted and dialect incompatibilities can warn or raise +depending on configurations. + +WWW: https://github.com/tobymao/sqlglot