From patchwork Tue Jan 16 22:13:09 2024 Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit X-Patchwork-Submitter: Felix Lechner X-Patchwork-Id: 58988 Return-Path: X-Original-To: patchwork@mira.cbaines.net Delivered-To: patchwork@mira.cbaines.net Received: by mira.cbaines.net (Postfix, from userid 113) id 45A8127BBE2; Tue, 16 Jan 2024 22:23:01 +0000 (GMT) X-Spam-Checker-Version: SpamAssassin 3.4.6 (2021-04-09) on mira.cbaines.net X-Spam-Level: X-Spam-Status: No, score=-3.7 required=5.0 tests=BAYES_00,DKIM_INVALID, DKIM_SIGNED,MAILING_LIST_MULTI,RCVD_IN_MSPIKE_H5,RCVD_IN_MSPIKE_WL, SPF_HELO_PASS,URIBL_BLOCKED autolearn=ham autolearn_force=no version=3.4.6 Received: from lists.gnu.org (lists.gnu.org [209.51.188.17]) by mira.cbaines.net (Postfix) with ESMTPS id 4342A27BBEA for ; Tue, 16 Jan 2024 22:22:57 +0000 (GMT) Received: from localhost ([::1] helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1rProv-0002v0-4X; Tue, 16 Jan 2024 17:22:11 -0500 Received: from eggs.gnu.org ([2001:470:142:3::10]) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1rPror-0002tn-A6 for guix-patches@gnu.org; Tue, 16 Jan 2024 17:22:06 -0500 Received: from debbugs.gnu.org ([2001:470:142:5::43]) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1rPron-0005b2-JN for guix-patches@gnu.org; Tue, 16 Jan 2024 17:22:03 -0500 Received: from Debian-debbugs by debbugs.gnu.org with local (Exim 4.84_2) (envelope-from ) id 1rProo-0003qQ-5d for guix-patches@gnu.org; Tue, 16 Jan 2024 17:22:02 -0500 X-Loop: help-debbugs@gnu.org Subject: [bug#67963] [PATCH v2 31/37] gnu: Add perl-sql-translator. Resent-From: Felix Lechner Original-Sender: "Debbugs-submit" Resent-CC: guix-patches@gnu.org Resent-Date: Tue, 16 Jan 2024 22:22:02 +0000 Resent-Message-ID: Resent-Sender: help-debbugs@gnu.org X-GNU-PR-Message: followup 67963 X-GNU-PR-Package: guix-patches X-GNU-PR-Keywords: patch To: 67963@debbugs.gnu.org Cc: Felix Lechner Received: via spool by 67963-submit@debbugs.gnu.org id=B67963.170544367014651 (code B ref 67963); Tue, 16 Jan 2024 22:22:02 +0000 Received: (at 67963) by debbugs.gnu.org; 16 Jan 2024 22:21:10 +0000 Received: from localhost ([127.0.0.1]:50035 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1rPrnx-0003o9-Jw for submit@debbugs.gnu.org; Tue, 16 Jan 2024 17:21:10 -0500 Received: from sail-ipv4.us-core.com ([208.82.101.137]:33596) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1rPrhH-0000o2-AR for 67963@debbugs.gnu.org; Tue, 16 Jan 2024 17:14:16 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; s=2017; bh=S96xlLK7D7VEi5X V7cNryWhwhFf1Z3a+Ghb0u0nY+Ws=; h=references:in-reply-to:date:subject: cc:to:from; d=lease-up.com; b=l6zRlrM3+OjZhDAa3xrQdFmE/yaIHvmYVjwYTiT4 Y/VSTgTPaAf7G66ZLlvt8kt5jkP7tAeBqTcwSX/gj6R0Z2bMLsu+m5dy20ZdCfKVAA2QzO 0scixU+SQ3stn5LWcfHdGagRfcJc9LgCOsCoqqd5ap8ptdxVIkBbTfcGi2djk= Received: by sail-ipv4.us-core.com (OpenSMTPD) with ESMTPSA id 246edb8d (TLSv1.3:TLS_CHACHA20_POLY1305_SHA256:256:NO); Tue, 16 Jan 2024 22:14:08 +0000 (UTC) Received: from localhost (localhost [local]) by localhost (OpenSMTPD) with ESMTPA id 64d4767f; Tue, 16 Jan 2024 22:14:08 +0000 (UTC) Date: Tue, 16 Jan 2024 14:13:09 -0800 Message-ID: <0bc6f55d2d028a62389ce59c48a6db021ea3009f.1705443195.git.felix.lechner@lease-up.com> X-Mailer: git-send-email 2.41.0 In-Reply-To: References: MIME-Version: 1.0 X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list X-BeenThere: guix-patches@gnu.org List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Reply-to: Felix Lechner X-ACL-Warn: , Felix Lechner via Guix-patches X-Patchwork-Original-From: Felix Lechner via Guix-patches via From: Felix Lechner Errors-To: guix-patches-bounces+patchwork=mira.cbaines.net@gnu.org Sender: guix-patches-bounces+patchwork=mira.cbaines.net@gnu.org X-getmail-retrieved-from-mailbox: Patches * gnu/packages/databases.scm (perl-sql-translator): New variable. Change-Id: I8a7c45539cf848e03f038b1e8bb9334b5115d1d4 --- gnu/packages/databases.scm | 57 ++++++++++++++++++++++++++++++++++++++ 1 file changed, 57 insertions(+) diff --git a/gnu/packages/databases.scm b/gnu/packages/databases.scm index 1f4e6be631..5ff23ba63d 100644 --- a/gnu/packages/databases.scm +++ b/gnu/packages/databases.scm @@ -101,12 +101,14 @@ (define-module (gnu packages databases) #:use-module (gnu packages freedesktop) #:use-module (gnu packages gawk) #:use-module (gnu packages gcc) + #:use-module (gnu packages gd) #:use-module (gnu packages gettext) #:use-module (gnu packages glib) #:use-module (gnu packages gnome) #:use-module (gnu packages gnupg) #:use-module (gnu packages golang) #:use-module (gnu packages gperf) + #:use-module (gnu packages graphviz) #:use-module (gnu packages gtk) #:use-module (gnu packages guile) #:use-module (gnu packages icu4c) @@ -2322,6 +2324,61 @@ (define-public perl-sql-tokenizer valid SQL query.") (license license:perl-license))) +(define-public perl-sql-translator + (package + (name "perl-sql-translator") + (version "1.64") + (source + (origin + (method url-fetch) + (uri (string-append "mirror://cpan/authors/id/V/VE/VEESH/SQL-Translator-" + version ".tar.gz")) + (sha256 + (base32 "1iykygxlsd98cxkr6np3gvcidrvgal7q59ms1id1vb76z0kd8478")))) + (build-system perl-build-system) + (arguments + (list + #:tests? #f)) + (native-inputs (list perl-file-sharedir-install + perl-json-maybexs + perl-test-differences + perl-test-exception + perl-xml-writer + perl-yaml)) + (propagated-inputs (list perl-carp-clan + perl-dbi + perl-file-sharedir + perl-gd + perl-graph + perl-graphviz + perl-moo + perl-package-variant + perl-parse-recdescent + perl-spreadsheet-parseexcel + perl-sub-quote + perl-template-toolkit + perl-text-recordparser + perl-try-tiny + perl-xml-libxml)) + (home-page "https://metacpan.org/release/SQL-Translator") + (synopsis "SQL DDL transformations and more") + (description "SQL::Translator is a group of Perl modules that converts +vendor-specific SQL table definitions into other formats like a different +SQL dialect, into ER diagrams, into documentation (POD and HTML), into XML, +and into Class::DBI classes. + +The main focus of SQL::Translator is SQL, but parsers exist for other +structured data formats, including Excel spreadsheets and arbitrarily +delimited text files. + +Through the separation of the code into parsers and producers with an +object model in between, it's possible to combine any parser with any +producer, or to plug in custom parsers or producers, or to manipulate +the parsed data via the built-in object model. Presently only the +definition parts of SQL are handled CREATE, ALTER), but not the +manipulation of data (INSERT, UPDATE, DELETE).") + (license license:perl-license))) + (define-public unixodbc (package (name "unixodbc")