From patchwork Mon May 19 19:15:53 2025 Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 8bit X-Patchwork-Submitter: Philippe SWARTVAGHER X-Patchwork-Id: 42753 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 84EDA27BC4A; Mon, 19 May 2025 20:17:44 +0100 (BST) X-Spam-Checker-Version: SpamAssassin 3.4.6 (2021-04-09) on mira.cbaines.net X-Spam-Level: X-Spam-Status: No, score=-7.4 required=5.0 tests=BAYES_00,DKIM_INVALID, DKIM_SIGNED,FREEMAIL_FROM,MAILING_LIST_MULTI,RCVD_IN_DNSWL_BLOCKED, RCVD_IN_MSPIKE_H2,RCVD_IN_VALIDITY_CERTIFIED,RCVD_IN_VALIDITY_RPBL, RCVD_IN_VALIDITY_SAFE,SPF_HELO_PASS,URIBL_BLOCKED autolearn=unavailable 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 65E5F27BC49 for ; Mon, 19 May 2025 20:17:43 +0100 (BST) Received: from localhost ([::1] helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1uH5z1-0000V4-9H; Mon, 19 May 2025 15:17:07 -0400 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 1uH5yx-0000Uj-5F for guix-patches@gnu.org; Mon, 19 May 2025 15:17:03 -0400 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 1uH5yw-00077g-Sv for guix-patches@gnu.org; Mon, 19 May 2025 15:17:02 -0400 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=debbugs.gnu.org; s=debbugs-gnu-org; h=MIME-Version:Date:From:To:Subject; bh=0ubpbMTOp7SkB62EdVrc/Id9GAtRSKVBR/soNofnmvs=; b=b98dP3B9KOjKH/ZZXYJC8Val6ieUFysA6EHqePIP9Ba/ve6LdtgTvig/eYTZw0tMhBe2ZX6N/Aq6z3YuISyhOIJfoW9Mpag2kigBmiulxD/ToIxoy3Umbo2mnA9SUX/LN5NEU7EJ8sdNqvnsCRmdWyZctYawb/Q3/DBhqmEdyCFBbhCtL00Rq4MNpzQV/7IhwRWnnPbiAii7WOD94B3XYsp84kMtge1hFg4+O9DGCNnMjN5HDMqc0LwpD4YdMt2J3UBpceqZs8HN2BzOL6NxKpD/e/TiswbxQWVIDKTcIH6k/7PV9IeozeRRXqkZ0iQZxNRb1JnB5eFxMDNYk/JmFQ==; Received: from Debian-debbugs by debbugs.gnu.org with local (Exim 4.84_2) (envelope-from ) id 1uH5yw-0007Qd-Cy; Mon, 19 May 2025 15:17:02 -0400 X-Loop: help-debbugs@gnu.org Subject: [bug#78496] [PATCH] gnu: Add sqlitestudio. Resent-From: Philippe SWARTVAGHER Original-Sender: "Debbugs-submit" Resent-CC: sharlatanus@gmail.com, guix-patches@gnu.org Resent-Date: Mon, 19 May 2025 19:17:02 +0000 Resent-Message-ID: Resent-Sender: help-debbugs@gnu.org X-GNU-PR-Message: report 78496 X-GNU-PR-Package: guix-patches X-GNU-PR-Keywords: patch To: 78496@debbugs.gnu.org Cc: Philippe SWARTVAGHER , Sharlatan Hellseher X-Debbugs-Original-To: guix-patches@gnu.org X-Debbugs-Original-Xcc: Sharlatan Hellseher Received: via spool by submit@debbugs.gnu.org id=B.174768219528381 (code B ref -1); Mon, 19 May 2025 19:17:02 +0000 Received: (at submit) by debbugs.gnu.org; 19 May 2025 19:16:35 +0000 Received: from localhost ([127.0.0.1]:45017 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1uH5yU-0007Nh-DW for submit@debbugs.gnu.org; Mon, 19 May 2025 15:16:34 -0400 Received: from lists.gnu.org ([2001:470:142::17]:50342) by debbugs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1uH5yS-0007Mw-4I for submit@debbugs.gnu.org; Mon, 19 May 2025 15:16:33 -0400 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 1uH5yK-0000SY-Kn for guix-patches@gnu.org; Mon, 19 May 2025 15:16:25 -0400 Received: from mout.gmx.net ([212.227.15.19]) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1uH5yH-00075N-QS for guix-patches@gnu.org; Mon, 19 May 2025 15:16:24 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmx.fr; s=s31663417; t=1747682178; x=1748286978; i=phil.swart@gmx.fr; bh=0ubpbMTOp7SkB62EdVrc/Id9GAtRSKVBR/soNofnmvs=; h=X-UI-Sender-Class:From:To:Cc:Subject:Date:Message-ID: MIME-Version:Content-Type:Content-Transfer-Encoding:cc: content-transfer-encoding:content-type:date:from:message-id: mime-version:reply-to:subject:to; b=g27L8qtVjFWHiMDbkkBEqGKWIYzawqlF3xDD7zc9N328OK/zjf93fo5ss+TkZ0hS 9YHHPAyWYfa7pqmFh0JB4gDt7u32BVIdOCuBMeDU/o9pVDYmnuv3my/H2ioj+N/g4 ybu50eITck39HWRNI9+whu8n8GZF94RXr3Rb/Gz4Aqad6rz47xhMtjWMjMSt+0eFe 1eiTEDLbiTHPWZ3dmo3MGHCu+pD2bHD6bKW7QhIYKIyYifhLwFUcCSD3t6Sz4fdBz UYYLUFdNECzkDNP5bJz4ts8GcvYAGEqJtXshRfSuMgMgCt5KX8rfeIbjpaCPefLCO 1mQ8F1V03XnwOWHrjw== X-UI-Sender-Class: 724b4f7f-cbec-4199-ad4e-598c01a50d3a Received: from localhost.localdomain ([83.192.201.168]) by mail.gmx.net (mrgmx004 [212.227.17.184]) with ESMTPSA (Nemesis) id 1MXXyP-1uSV490Kbv-00YSQk; Mon, 19 May 2025 21:16:18 +0200 Date: Mon, 19 May 2025 21:15:53 +0200 Message-ID: <67d6bdbefc3671abf25f9509524f4de3f7382799.1747682121.git.phil.swart@gmx.fr> X-Mailer: git-send-email 2.49.0 MIME-Version: 1.0 X-Provags-ID: V03:K1:7rYxp9Ljm87pq0eTusIMvjK5QjJ3FarKUTGqi9QzWKn8QPsds5X 1VTu3xI8bZmIX6DZXolWzzlPg2GjBxpwvJH6FEz1YOh6X4yT4R1gyEPVFQOMSAWfGh6GrXW a5/1KWtZZwHUXTg0DTyznuwEki7vblg4U9s9whNop3GvSBaGjInsL+Lqfc2G1C9BKRxTjfn iYo00bnZ6iHaolwHQTmTw== UI-OutboundReport: notjunk:1;M01:P0:Bi07QEuTM2k=;qfhE68xZJcPleLlW4cPJnMhtI7x G1entSZQ3LDrm5JG8WIbhTsCh97ssQoW/q8DO9WhVSwbpc8wmJoEUOlRKNpxEnfsdjxhjbXqA cqO45HH/yph1YdBLD8Z3TWExJkdkNVHrv1kV9N+BVmcbnblg3zrvCn0J4d5DwLFALZef64WmN xGrrYrHf4ddQr/041cK1a9W4BlGtduNh1DMAtpwD/87/MOfZL0cwg0dGgtK+egqfIi7sxmOL4 ZjI5ZHzzKaI8pWHiNN82HwljYna/bKA6dDSL5svIGnOvOWyYwIZ+nxkdoWA/ePXe+3jpg5Fok eCFf82D988Hw4nZuJX7Z618mftsaa7GphiqnLJJAqKmDY6ixyFphv1doA/4fWaMwLZsnsWuHl 3bV5ypJLgFm6MTH+PvVfTIIl1hc82Rv2DunpA2uaN4tGgfZ81BY/Jis3gcwqHL3teoZ/AZRpc r5dLUuhOTh0rHsUZFcxszE1Lmy6n/378VSnHNgEkv1o/jH7USlzNJoRokQhBO+GWcGQ4pIn7l 1o/ba/DfUsXIaCO9hpB+dgFL9UTovmUt4LOUWVL3iFRnBiuetrM3sqxux5zNnhrrN1TvsS9Uw zQ8wla6A+sB4T7S57zel8oWr+P/ujxGtxoNazylrLrhvBDlFs4y4vKKZb8xD1R3/mCV1kamSG QjcODKNAml0ScmjP0XVHS/72kiWe9U6IgoARfq3LraGCZc2wU/gFU912IDEPQn649hHi7hKDm MDYjEXUPD/50F4BTMYlRjOjlzBvo3jnRqZygnSETyNl6rOQDGQC1bUhHDcj9mcrPooO0VsClq TQRCdb8c8PJ76i6bYJBxPVOOX28zWXmGwHmm+wOQK2QdiFUd3I2RllQ54YakGNcwHAttl91Ss vfN/5ftthdZaNBMmZpAJrgHGq0LI1U/HbE1W7tmYxSncI0woUUabeSIFKsn5qcwSv6moGocfr efy+mPZbj8Yb7IDu7c4uanWoFn2n0tSzuWqQHpH8dEhWjStq1t6HqNRj+9Cb9so+hQ6FoJ6NW 7XvfzWSwAxMxHqMPOXS45uxjKeBzEP6e/RZnovaMzYt3lvsRdHT9Uz2DIyrNMjmAicA0PpTIv eUDxJzz/jrGEKTYJiO1zZxllOcoCmJLNl0CY0EZ9qnVk/Ws1Q6MNsK8DKtVTcGSPFOCkWDpEC ShMdJnFduhtfdC4ODEDwyqLrm/cOn7b2h1EqWgdolYfnIMkrAVPA7Lyk7a3GhfzKIObKHs6re z132zsu90ywp2TdmScIz//Nr8rFX/MYFiH1v0VX2jw6X1opK2MA+aj/79hu5dt7eK9JPTaLcU 5YYquuzyh+KSEC/gm/kxj585CHDmfs262/csEhW20fxh2ouUh3uJ0hJHsQX7SFcfr+wOt5gxu IcWKzEHzss01jy4QxeCTt85DHk+/0tYc3h3N6Oox3y86ceBlxlFylccIriSxVBcxfg51wiL0U KfMb0AyVv5af4cSVostxIiaWr2z4Owf3YWlR+/7/GqpWjwBmUyxWnoRBQ80UQqsnAl8smY6sr LJjQY23u9pn0fuHgwda7QVzibz/a/T7rAhYSqAMMaygse0/QXkMyru37hvM3oClKkuL9ql0i9 gPqZ5H9V6bSJSFMXXBoRqe4ndYOAJnsiu9qIChaAEWSSAUriUTdzQ79SSEZ+IcUXHQJlALA19 bMNPRmR0cPYCkTQYf/kd9dZYR9cvYtYbRVKmezEkC08ZmqfV4upzlecMw4zJ/IMrYg82/Trnh bn0CUGfIMuN+ayn9A8lek5iufcNQhEYBX2aqV/zYdvo8bkSF8DWJShTlDjbdzGhfXch7F2bLm Be8Uk3eeTVgKJ1t2UFC4+MDIfwbkAJN40UMS32VWoyZdfHiSDEoFL2oRUnJUlBaC3Olfp9o2n qDEM7veNeMv4WUBrHWuE1PcaCmhj1oF/tB31vtW47m3DslvBbbXqPlED4ApWHyuYCr7+hfZgf y6nSnQBVFYFPbCBcgbusTpY/irU3MpJMKDqnWlGy4TuJsGsiW9NjYo56bmjgru0DsEkWZ6tYH PJqDu9E48IdWSmRHPmHD74K29clf5SVSuS0vCDAWFGoWeTH1HqqRYNzVRcmnm6TjmG6kkGZM1 1fBejEYQWGq9P9rQkGiCpeH4M6wNvEkfSMrUA7LNrlPdgBi3ElXYX7NySV7/StEVMtDxLv4bm 2MTjQ9BAPqjQtDHneW2kzD1b/j5DmMRaOeRm5JmG8V7TpNYasbhzMqKTmOXChTDudmvLv0ADX quU9kkK1pFzauiq4nSq7O+01XFPZj0dV2aKO5xBJ4S9ZWPF/k1lvRFip6DJWPldyPG0oX3z6z u2uvPX75LURkovOjlGYX+UjIfzWENT0VBwvcr8A9rd2VuSd/3PdZhSw6zYNK7bZZ9aAdsERM3 408+YeSEJnFlhMEHb4wjHVZzdFM2plXQxLbMmb5Mdb1xYDpa3GaBhaVgPCjQsSzAwGUrZJHPA coYjoupnW4jKdbHEFcbEx1tm29qNzN8x64FW0PWcylp5Csvs0hYHkJqjv22J+LsALH9RZbPc3 fUMT6cF4Ib9FRFqN/N1oCaH6n80YR+0PWA4Pt1aDgaOv//WBdQBnsa+vnXj9rV6xsZ53ZqPcL /ZUq4CM2bE3L09tCoz083o+CoFGv0cLNJxi253aEFJCDMfV+OfEsiStwVMfQsWJ91ulry7vxs wD2+QSwhDdA3TNC7Pey1cMIjpGhgE87VcuvJThnnXehYdQbAFXJatONyrlQ+gu5RQy/JxBWoQ iRC3+njiEy/gLJKgbRbDXbhvKhmbbdEk1LJMqVCAgTZJKLc/t6aLm2y22IoRtqJgswy1tz3sV AWUblVHjCac1M8J0qfo6wTfiowfwoH4nT326t114IV5AIDSkXR/6WgUDlbkpBf17w8VtDiMTm Wn/6foBQQ6CCrGMM12hf50gis2sW08kcWhmMfg9cztf515uo6uAYPQBQvczPNFzp8J6cr2KBa NvCgvBrHuCTxLwmqGBxyXiwfkR5wa2OKkRvD4P/JojaAt+fmNt1Ig/yZdFErf+1HVYoUs4yJx 2fb1zjfXrRVXoDnI8lGeUg8w2Pf91zVuOFtglzxmlnn Received-SPF: pass client-ip=212.227.15.19; envelope-from=phil.swart@gmx.fr; helo=mout.gmx.net X-Spam_score_int: -27 X-Spam_score: -2.8 X-Spam_bar: -- X-Spam_report: (-2.8 / 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_LOW=-0.7, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, RCVD_IN_VALIDITY_CERTIFIED_BLOCKED=0.001, RCVD_IN_VALIDITY_RPBL_BLOCKED=0.001, 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: , Reply-to: Philippe SWARTVAGHER X-ACL-Warn: , Philippe SWARTVAGHER via Guix-patches X-Patchwork-Original-From: Philippe SWARTVAGHER via Guix-patches via From: Philippe SWARTVAGHER 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 (sqlitestudio): New variable. Change-Id: I012a189d37661bf70b140048696ae97647bf0a6f --- gnu/packages/databases.scm | 112 +++++++++++++++++++++++++++++++++++++ 1 file changed, 112 insertions(+) base-commit: 450a361532573a02389530a6a80b7821683ed41b diff --git a/gnu/packages/databases.scm b/gnu/packages/databases.scm index c3a10efece..16cca632c9 100644 --- a/gnu/packages/databases.scm +++ b/gnu/packages/databases.scm @@ -64,6 +64,7 @@ ;;; Copyright © 2023 Giacomo Leidi ;;; Copyright © 2024 Troy Figiel ;;; Copyright © 2024 gemmaro +;;; Copyright © 2025 Philippe Swartvagher ;;; ;;; This file is part of GNU Guix. ;;; @@ -5728,6 +5729,117 @@ (define-public sqlitebrowser (list license:gpl3+ license:mpl2.0)))) +(define-public sqlitestudio + (package + (name "sqlitestudio") + (version "3.4.17") + (source + (origin + (method git-fetch) + (uri (git-reference + (url "https://github.com/pawelsalawa/sqlitestudio") + (commit version))) + (file-name (git-file-name name version)) + (sha256 + (base32 "1zb1qr88rwkzmrxc0lm99x8h99hpn5c2wfdpvqzs9f9ph8qvasww")))) + (build-system gnu-build-system) + (arguments + `(#:phases (modify-phases %standard-phases + (replace 'configure + (lambda* (#:key inputs outputs #:allow-other-keys) + (let* ((out (assoc-ref outputs "out")) + (python-version ,(version-major+minor (package-version + python))) + (python-include (string-append (assoc-ref inputs + "python") + "/include/python" + python-version))) + (invoke "qmake" + (string-append + "QMAKE_LFLAGS_RPATH=-Wl,-rpath," out "/lib:") + (string-append "PREFIX=" out) + "./SQLiteStudio3") + (mkdir-p "Plugins") + (chdir "Plugins") + (invoke "qmake" + (string-append + "QMAKE_LFLAGS_RPATH=-Wl,-rpath," out "/lib:") + (string-append "PREFIX=" out) + (string-append "INCLUDEPATH+=" python-include) + (string-append "PYTHON_VERSION=" + python-version) + ".") + (chdir "..")))) + (replace 'build + (lambda _ + (invoke "make" "-j" + (number->string (parallel-job-count))) + (chdir "Plugins") + (invoke "make") ;building plugins in parallel corrupts them + (chdir ".."))) + (replace 'install + (lambda* (#:key outputs #:allow-other-keys) + (let* ((out (assoc-ref outputs "out")) + (icons-dir (string-append out + "/share/icons/hicolor/")) + (src-img-dir (string-append + "SQLiteStudio3/guiSQLiteStudio/img/"))) + (invoke "make" "-j" + (number->string (parallel-job-count)) + "install") + (for-each (lambda (size) + (let ((target-dir (string-append icons-dir + size "x" size "/apps/"))) + (mkdir-p target-dir) + (copy-file (string-append src-img-dir + "sqlitestudio_" size ".png") + (string-append target-dir + "sqlitestudio.png")))) + '("16" "48" "256")) + (let ((target-dir (string-append icons-dir + "scalable/apps/"))) + (mkdir-p target-dir) + (install-file (string-append src-img-dir + "sqlitestudio.svg") + target-dir)) + (chdir "Plugins") + (invoke "make" "-j" + (number->string (parallel-job-count)) + "install") + (chdir "..")))) + (add-after 'install 'install-desktop + (lambda* (#:key outputs #:allow-other-keys) + (let* ((out (assoc-ref outputs "out"))) + (make-desktop-entry-file (string-append out + "/share/applications/" + ,name ".desktop") + #:name "SQLiteStudio" + #:comment ,(package-synopsis + this-package) + #:exec (string-append ,name + " %f") + #:icon ,name + #:categories '("Development" + "Utility" + "Database") + #:mime-type + "application/vnd.sqlite3"))))))) + (inputs (list openssl + python + qtbase-5 + qtsvg-5 + readline + sqlite-next)) + (native-inputs (list python qttools-5 qtdeclarative-5 tcl)) + (home-page "https://sqlitestudio.pl/") + (synopsis + "A free, open source, multi-platform SQLite database manager") + (description + "SQLiteStudio is desktop application for browsing and editing SQLite + database files. It is aimed for people, who know what SQLite is, or what + relational databases are in general.") + (license license:gpl3+))) + (define-public sqls (package (name "sqls")