* [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).