unofficial mirror of guix-patches@gnu.org 
 help / color / mirror / code / Atom feed
* [bug#45996] [PATCH] Final patch which ads pgloader
@ 2021-01-19 22:28 Sharlatan Hellseher
  2021-01-20  9:51 ` bug#45996: " Guillaume Le Vaillant
  0 siblings, 1 reply; 2+ messages in thread
From: Sharlatan Hellseher @ 2021-01-19 22:28 UTC (permalink / raw)
  To: 45996

[-- Attachment #1: Type: text/plain, Size: 6831 bytes --]

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



-- 
… наш разум - превосходная объяснительная машина которая способна
найти смысл почти в чем угодно, истолковать любой феномен, но
совершенно не в состоянии принять мысль о непредсказуемости.

[-- Attachment #2: 0001-Add-pgloader.patch --]
[-- Type: text/x-patch, Size: 5455 bytes --]

From 634265906d74ec6e869d23ce7e1b01631c2a7d70 Mon Sep 17 00:00:00 2001
From: Sharlatan Hellseher <sharlatanus@gmail.com>
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


^ permalink raw reply related	[flat|nested] 2+ messages in thread

* bug#45996: [PATCH] Final patch which ads pgloader
  2021-01-19 22:28 [bug#45996] [PATCH] Final patch which ads pgloader Sharlatan Hellseher
@ 2021-01-20  9:51 ` Guillaume Le Vaillant
  0 siblings, 0 replies; 2+ messages in thread
From: Guillaume Le Vaillant @ 2021-01-20  9:51 UTC (permalink / raw)
  To: Sharlatan Hellseher; +Cc: 45996-done

[-- Attachment #1: Type: text/plain, Size: 243 bytes --]


I removed sbcl-cffi and python from 'native-inputs' as they seemed not
to be used, modified the description a little, changed the license as in
the postgresql package, and pushed the patch as
100a4f84fec03bdf31523232f9f6587bb201ea7c.
Thanks.

[-- Attachment #2: signature.asc --]
[-- Type: application/pgp-signature, Size: 247 bytes --]

^ permalink raw reply	[flat|nested] 2+ messages in thread

end of thread, other threads:[~2021-01-20  9:52 UTC | newest]

Thread overview: 2+ messages (download: mbox.gz follow: Atom feed
-- links below jump to the message on this page --
2021-01-19 22:28 [bug#45996] [PATCH] Final patch which ads pgloader Sharlatan Hellseher
2021-01-20  9:51 ` bug#45996: " Guillaume Le Vaillant

Code repositories for project(s) associated with this public inbox

	https://git.savannah.gnu.org/cgit/guix.git

This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).