From patchwork Tue Jan 19 22:28:55 2021 Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 8bit X-Patchwork-Submitter: Sharlatan Hellseher X-Patchwork-Id: 26512 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 EA9D327BC15; Tue, 19 Jan 2021 22:30:42 +0000 (GMT) X-Spam-Checker-Version: SpamAssassin 3.4.2 (2018-09-13) on mira.cbaines.net X-Spam-Level: X-Spam-Status: No, score=-2.8 required=5.0 tests=BAYES_00,DKIM_ADSP_CUSTOM_MED, DKIM_SIGNED,FREEMAIL_FROM,MAILING_LIST_MULTI,RCVD_IN_MSPIKE_H4, RCVD_IN_MSPIKE_WL,SPF_HELO_PASS,T_DKIM_INVALID,URIBL_BLOCKED autolearn=unavailable autolearn_force=no version=3.4.2 Received: from lists.gnu.org (lists.gnu.org [209.51.188.17]) by mira.cbaines.net (Postfix) with ESMTPS id AF3AC27BC14 for ; Tue, 19 Jan 2021 22:30:41 +0000 (GMT) Received: from localhost ([::1]:41860 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1l1zWK-0004mV-Pm for patchwork@mira.cbaines.net; Tue, 19 Jan 2021 17:30:40 -0500 Received: from eggs.gnu.org ([2001:470:142:3::10]:52950) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1l1zVj-0004m2-0T for guix-patches@gnu.org; Tue, 19 Jan 2021 17:30:03 -0500 Received: from debbugs.gnu.org ([209.51.188.43]:40481) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1l1zVi-00076D-Ov for guix-patches@gnu.org; Tue, 19 Jan 2021 17:30:02 -0500 Received: from Debian-debbugs by debbugs.gnu.org with local (Exim 4.84_2) (envelope-from ) id 1l1zVi-0001Ex-KW for guix-patches@gnu.org; Tue, 19 Jan 2021 17:30:02 -0500 X-Loop: help-debbugs@gnu.org Subject: [bug#45996] [PATCH] Final patch which ads pgloader Resent-From: Sharlatan Hellseher Original-Sender: "Debbugs-submit" Resent-CC: guix-patches@gnu.org Resent-Date: Tue, 19 Jan 2021 22:30:02 +0000 Resent-Message-ID: Resent-Sender: help-debbugs@gnu.org X-GNU-PR-Message: report 45996 X-GNU-PR-Package: guix-patches X-GNU-PR-Keywords: patch To: 45996@debbugs.gnu.org X-Debbugs-Original-To: guix-patches@gnu.org Received: via spool by submit@debbugs.gnu.org id=B.16110953644688 (code B ref -1); Tue, 19 Jan 2021 22:30:02 +0000 Received: (at submit) by debbugs.gnu.org; 19 Jan 2021 22:29:24 +0000 Received: from localhost ([127.0.0.1]:52025 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1l1zUx-0001DO-3p for submit@debbugs.gnu.org; Tue, 19 Jan 2021 17:29:24 -0500 Received: from lists.gnu.org ([209.51.188.17]:35998) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1l1zUu-0001DF-8h for submit@debbugs.gnu.org; Tue, 19 Jan 2021 17:29:13 -0500 Received: from eggs.gnu.org ([2001:470:142:3::10]:52846) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1l1zUu-0004hx-2M for guix-patches@gnu.org; Tue, 19 Jan 2021 17:29:12 -0500 Received: from mail-wm1-x32a.google.com ([2a00:1450:4864:20::32a]:34489) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1l1zUr-0006zm-P0 for guix-patches@gnu.org; Tue, 19 Jan 2021 17:29:11 -0500 Received: by mail-wm1-x32a.google.com with SMTP id o10so2333823wmc.1 for ; Tue, 19 Jan 2021 14:29:07 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:from:date:message-id:subject:to; bh=es9lqkMp4u4zY/T4jqiyam4wi3BmMbyyuIz7XLf+CPY=; b=SHIDizgcM1wUBw5JgPxGC/OBmgB5pthtYXwWsevVYDwt0v9kpIYYeaxlaOqn9IJ9cR GMo3D89ztp6HB1Uy0gYZzoevKrJA3sBeHWY9NytGb6V+D2eUcB/hqnZKec9/RzBE9xy0 /Wrj+biYgW4XBgssDS2r6CXhQ29P8ERff/yRX8Lq/dayNpuSJWGEy7clvju60G6J2tGe MwTFcrLLyAb0NzTA3LdW5D6MeA4lzkID+Wf2BQGZhNbdn86sDhNmyFFqrTMbJJoUDFbN 1AaI1OLjUCX+vOWXvajZ7dZpW2y83veQiv+bg/lieknPp24FXu7NAGdmy0ZuR2BTFlOJ 5txw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=es9lqkMp4u4zY/T4jqiyam4wi3BmMbyyuIz7XLf+CPY=; b=lTIy9GYkk9UXO5iqVB+Gy3saWNZOo0/GWFVXjDHLnf7dBYrk8BBeiW5sXF4nM+eRqf PFF92a4caKidMQiv4OxYlk92doL12FtDQkJIqtwHdxrq3JevT0WdXdWBWPCQsjJ9SKSi iparicGryQUiqHgzHAspbhjMWH+B249yEx9Gqu+hckwqDbzBwiZGf+bB7AuYlRZU4FVY gI5+mhulUrImQgAyJn5SDOfRIVOy4jtC4qFJ2OBvB+Iv0RwE2xFasmJDwsEmbBISnn40 dVJgadFAqnL+/mMJHj7E+YXBXitpWY7DMeJQH3ZL6uWJZBpJctIKwtG9JuXuaArwG3sR PREg== X-Gm-Message-State: AOAM533IxdezWe63h+4NUI8lD9DtHJSoS1VcMYWL0V1PPq3vOyEoG3Qj k9RaqVVPoXsDcWysLjxpJsLVUswkgAIrk42KkrlXp18HBUc= X-Google-Smtp-Source: ABdhPJwiyTth0yI1o22aWDK3J/sFP9P3q0GQ7DA9ITCqUw522xCHNk18NLTY/rqiS5PDPg1Dlznypvhd3Ymt5QvlxzQ= X-Received: by 2002:a1c:9e86:: with SMTP id h128mr1516500wme.171.1611095345878; Tue, 19 Jan 2021 14:29:05 -0800 (PST) MIME-Version: 1.0 From: Sharlatan Hellseher Date: Tue, 19 Jan 2021 22:28:55 +0000 Message-ID: Received-SPF: pass client-ip=2a00:1450:4864:20::32a; envelope-from=sharlatanus@gmail.com; helo=mail-wm1-x32a.google.com X-Spam_score_int: -20 X-Spam_score: -2.1 X-Spam_bar: -- X-Spam_report: (-2.1 / 5.0 requ) BAYES_00=-1.9, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1, FREEMAIL_FROM=0.001, RCVD_IN_DNSWL_NONE=-0.0001, SPF_HELO_NONE=0.001, SPF_PASS=-0.001 autolearn=ham autolearn_force=no X-Spam_action: no action 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: , Errors-To: guix-patches-bounces+patchwork=mira.cbaines.net@gnu.org Sender: "Guix-patches" X-getmail-retrieved-from-mailbox: Patches Hi Guix team! Good news pgloader is packed (but with tests disabled which depends on Quicklisp and curl hacks) * DONE pgloader CLOSED: [2021-01-19 Tue 22:25] - https://issues.guix.gnu.org/44993 - https://issues.guix.gnu.org/45025 - https://issues.guix.gnu.org/45107 - https://issues.guix.gnu.org/45189 - https://issues.guix.gnu.org/45263 - https://issues.guix.gnu.org/45324 - https://issues.guix.gnu.org/45356 - https://issues.guix.gnu.org/45452 - https://issues.guix.gnu.org/45602 - https://issues.guix.gnu.org/45639 - https://issues.guix.gnu.org/45678 - https://issues.guix.gnu.org/45719 - https://issues.guix.gnu.org/45740 - https://issues.guix.gnu.org/45775 - https://issues.guix.gnu.org/45846 - https://issues.guix.gnu.org/45866 - https://issues.guix.gnu.org/45921 - [X] pgloader [35/35] [100%] 1. [X] abnf [100%] - [X] :packed <2020-12-05 Sat> - [X] :patch-sent <2020-12-07 Mon> - [X] :patch-applied-upstream <2020-12-11 Fri> - [X] :depends-on [2/2] + [X] esrap + [X] cl-ppcre 2. [X] alexandria 3. [X] buildapp [100%] - [X] :packed <2021-01-16 Sat> - [X] :patch-sent <2021-01-16 Sat> - [X] :patch-applied-upstream <2021-01-17 Sun> - [X] :depends-on [1/1] + [X] sbcl 4. [X] cl-base64 5. [X] cl-csv 6. [X] cl-fad 7. [X] cl-log [100%] - [X] :packed <2020-12-02 Wed> - [X] :patch-sent <2020-12-02 Wed> - [X] :patch-applied-upstream <2020-12-05 Sat> 8. [X] cl-markdown [100%] - version-0.10.4 - [X] :packed <2021-01-07 Thu> - [X] :patch-sent <2021-01-07 Thu> - [X] :patch-applied-upstream <2021-01-08 Fri> - [X] :depends-on [6/6] + [X] dynamic-classes [100%] - https://github.com/gwkkwg/dynamic-classes - [X] :packed <2021-01-07 Thu> - [X] :patch-sent <2021-01-07 Thu> - [X] :patch-applied-upstream <2021-01-08 Fri> - [X] :depends-on [1/1]Э + [X] metatilities-base + [X] anaphora + [X] cl-containers "0.11.5" + [X] cl-ppcre + [X] metabang-bind + [X] metatilities-base "0.6.0" 9. [X] cl-mustache [100%] - https://github.com/kanru/cl-mustache - WRONG: https://github.com/osa1/cl-mustache - [X] :packed <2020-12-21 Mon> - [X] :patch-sent <2020-12-21 Mon> - [X] :patch-applied-upstream <2020-12-22 Tue> 10. [X] closer-mop 11. [X] cl-postgres [100%] - part of Postmodern - [X] :packed <2021-01-14 Thu> - [X] :patch-sent <2021-01-14 Thu> - [X] :patch-applied-upstream <2021-01-15 Fri> - [X] :depends-on [4/4] - [X] md5 - [X] split-sequence - [X] cl-base64 - [X] uax-15 [100%] + [X] :packed <2020-12-26 Sat> + [X] :patch-sent <2020-12-26 Sat> + [X] :patch-applied-upstream <2020-12-28 Mon> + [X] :depends-on [3/3] - [X] split-sequence - [X] cl-ppcre - [X] uiop - part of ASDF 12. [X] cl-ppcre 13. [X] command-line-arguments [100%] - https://github.com/fare/command-line-arguments - [X] :packed <2020-12-12 Sat> - [X] :patch-sent <2020-12-12 Sat> - [X] :patch-applied-upstream <2020-12-12 Sat> 14. [X] db3 [100%] - [X] :packed <2021-01-03 Sun> - [X] :patch-sent <2021-01-03 Sun> - [X] :patch-applied-upstream <2021-01-04 Mon> 15. [X] drakma 16. [X] esrap 17. [X] flexi-streams 18. [X] ixf [100%] - [X] :packed <2021-01-01 Fri> - [X] :patch-sent <2021-01-01 Fri> - [X] :patch-applied-upstream <2021-01-02 Sat> - [X] :depends-on - [X] split-sequence - [X] md5 - [X] alexandria - [X] babel - [X] local-time - [X] cl-ppcre - [X] ieee-floats 19. [X] local-time 20. [X] lparallel 21. [X] metabang-bind 22. [X] mssql [100%] - [X] :packed <2021-01-13 Wed> - [X] :patch-sent <2021-01-13 Wed> - [X] :patch-applied-upstream <2021-01-14 Thu> - [X] :depends-on [5/5] + [X] libsybdb - https://github.com/FreeTDS/freetds - [X] :packed <2021-01-10 Sun> - [X] :patch-sent <2021-01-10 Sun> - [X] :patch-applied-upstream <2021-01-14 Thu> + [X] cffi + [X] iterate + [X] garbage-pools - https://github.com/archimag/garbage-pools - [X] :packed <2021-01-08 Fri> - [X] :patch-sent <2021-01-09 Sat> - [X] :patch-applied-upstream <2021-01-10 Sun> + [X] parse-number 23. [X] postmodern 24. [X] py-configparser [100%] - [X] :packed <2020-12-24 Thu> - [X] :patch-sent <2021-01-05 Tue> - [X] :patch-applied-upstream <2021-01-06 Wed> - [X] :depends-on [1/1] + [X] parse-number 25. [X] qmynd [100%] - [X] :packed <2020-12-19 Sat> - [X] :patch-sent <2020-12-19 Sat> - [X] :patch-applied-upstream <2020-12-19 Sat> - [X] :depends-on [6/6] - [X] babel - [X] flexi-streams - [X] ironclad - [X] list-of - part of asdf-finalizers - https://gitlab.common-lisp.net/asdf/asdf-finalizers - [X] :packed <2020-12-15 Tue> - [X] :patch-sent <2020-12-15 Tue> - [X] :patch-applied-upstream <2020-12-19 Sat> - [X] :depends-on [1/1] - [X] asdf-finalizers - [X] :packed <2020-12-15 Tue> - [X] :patch-sent <2020-12-15 Tue> - [X] :patch-applied-upstream <2020-12-19 Sat> - [X] trivial-gray-streams - [X] usocket - [X] :weakly-depends-on [3/3] - [X] chipz - [X] cl+ssl - [X] salza2 26. [X] quri 27. [X] simple-date [100%] - part of Postmodern - [X] :packed <2021-01-14 Thu> - [X] :patch-sent <2021-01-14 Thu> - [X] :patch-applied-upstream <2021-01-15 Fri> 28. [X] split-sequence 29. [X] sqlite 30. [X] trivial-backtrace 31. [X] uiop 32. [X] usocket 33. [X] uuid 34. [X] yason 35. [X] zs3 [100%] - [X] :packed <2020-12-03 Thu> - [X] :patch-sent <2020-12-03 Thu> - [X] :patch-applied-upstream <2020-12-05 Sat> - [X] :depends-on [6/6] + [X] drakma + [X] alexandria + [X] cxml + [X] ironclad + [X] puri + [X] cl-base64 From 634265906d74ec6e869d23ce7e1b01631c2a7d70 Mon Sep 17 00:00:00 2001 From: Sharlatan Hellseher Date: Tue, 19 Jan 2021 22:23:21 +0000 Subject: [PATCH] Add pgloader * gnu/packages/databases.scm (pgloader) new variable --- gnu/packages/databases.scm | 95 ++++++++++++++++++++++++++++++++++++-- 1 file changed, 92 insertions(+), 3 deletions(-) diff --git a/gnu/packages/databases.scm b/gnu/packages/databases.scm index 817ccdf6de..0a8b2944bd 100644 --- a/gnu/packages/databases.scm +++ b/gnu/packages/databases.scm @@ -86,15 +86,16 @@ #:use-module (gnu packages gettext) #:use-module (gnu packages glib) #:use-module (gnu packages gnupg) - #:use-module (gnu packages guile) - #:use-module (gnu packages time) #:use-module (gnu packages golang) + #:use-module (gnu packages guile) #:use-module (gnu packages icu4c) #:use-module (gnu packages jemalloc) #:use-module (gnu packages language) #:use-module (gnu packages libedit) #:use-module (gnu packages libevent) #:use-module (gnu packages linux) + #:use-module (gnu packages lisp) + #:use-module (gnu packages lisp-xyz) #:use-module (gnu packages logging) #:use-module (gnu packages man) #:use-module (gnu packages maths) @@ -111,8 +112,8 @@ #:use-module (gnu packages protobuf) #:use-module (gnu packages python) #:use-module (gnu packages python-crypto) - #:use-module (gnu packages python-web) #:use-module (gnu packages python-science) + #:use-module (gnu packages python-web) #:use-module (gnu packages python-xyz) #:use-module (gnu packages rdf) #:use-module (gnu packages readline) @@ -125,6 +126,7 @@ #:use-module (gnu packages tcl) #:use-module (gnu packages terminals) #:use-module (gnu packages textutils) + #:use-module (gnu packages time) #:use-module (gnu packages tls) #:use-module (gnu packages valgrind) #:use-module (gnu packages web) @@ -1246,6 +1248,93 @@ pictures, sounds, or video.") (base32 "1rr2dgv4ams8r2lp13w85c77rkmzpb88fjlc28mvlw6zq2fblv2w")))))) +(define-public pgloader + (package + (name "pgloader") + (version "3.6.2") + (source (origin + (method git-fetch) + (uri (git-reference + (url "https://github.com/dimitri/pgloader") + (commit (string-append "v" version)))) + (sha256 + (base32"06i1jd2za3ih5caj2b4vzlzags5j65vv8dfdbz0ggdrp40wfd5lh")) + (file-name (git-file-name name version)))) + (build-system gnu-build-system) + (arguments + ;; NOTE: (Sharlatan-20210119T211511+0000) Testes are disabled due to be + ;; dependent on Quicklisp, main build target is `pgloader-standalone' which + ;; does not require Quicklisp workarounds. There is no `install' target + ;; configured in Makefile. + `(#:tests? #f + #:strip-binaries? #f + #:make-flags + (list "pgloader-standalone" "BUILDAPP_SBCL=buildapp") + #:phases + (modify-phases %standard-phases + (delete 'configure) + (add-after 'unpack 'set-home + (lambda _ + (setenv "HOME" "/tmp") + #t)) + (add-after 'unpack 'patch-Makefile + (lambda _ + (substitute* "Makefile" + (("--sbcl.*") "--sbcl $(CL) --asdf-path . \\\n")) + #t)) + (replace 'install + (lambda* (#:key outputs #:allow-other-keys) + (let ((bin (string-append (assoc-ref outputs "out") "/bin"))) + (mkdir-p bin) + (install-file "build/bin/pgloader" bin)) + #t))))) + (native-inputs + `(("buildapp" ,buildapp) + ("sbcl" ,sbcl) + ("cffi" ,sbcl-cffi) + ("python" ,python))) + (inputs + `(("alexandria" ,sbcl-alexandria) + ("cl-abnf" ,sbcl-cl-abnf) + ("cl-base64" ,sbcl-cl-base64) + ("cl-csv" ,sbcl-cl-csv) + ("cl-fad" ,sbcl-cl-fad) + ("cl-log" ,sbcl-cl-log) + ("cl-markdown" ,sbcl-cl-markdown) + ("cl-mustache" ,sbcl-cl-mustache) + ("cl-ppcre" ,sbcl-cl-ppcre) + ("cl-sqlite" ,sbcl-cl-sqlite) + ("closer-mop" ,sbcl-closer-mop) + ("command-line-arguments" ,sbcl-command-line-arguments) + ("db3" ,sbcl-db3) + ("drakma" ,sbcl-drakma) + ("esrap" ,sbcl-esrap) + ("flexi-streams" ,sbcl-flexi-streams) + ("ixf" ,sbcl-ixf) + ("local-time" ,sbcl-local-time) + ("lparallel" ,sbcl-lparallel) + ("metabang-bind" ,sbcl-metabang-bind) + ("mssql" ,sbcl-mssql) + ("postmodern" ,sbcl-postmodern) + ("py-configparser" ,sbcl-py-configparser) + ("qmynd" ,sbcl-qmynd) + ("quri" ,sbcl-quri) + ("split-sequence" ,sbcl-split-sequence) + ("trivial-backtrace" ,sbcl-trivial-backtrace) + ("usocket" ,sbcl-usocket) + ("uuid" ,sbcl-uuid) + ("yason" ,sbcl-yason) + ("zs3" ,sbcl-zs3))) + (home-page "https://pgloader.io/") + (synopsis "Migration to PostgreSQL tool") + (description + "It allows to migrate from CSV, DB3, iXF, SQLite, MS-SQL, MySQL to +PostgreSQL.") + ;; NOTE: (Sharlatan-20210119T212023+0000) It is PostgreSQL license + ;; https://www.postgresql.org/about/licence/ a liberal Open Source license, + ;; similar to the BSD or MIT licenses. + (license license:expat))) + (define-public python-pymysql (package (name "python-pymysql") -- 2.30.0