From patchwork Thu May 29 12:08:41 2025 Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 8bit X-Patchwork-Submitter: Philippe SWARTVAGHER X-Patchwork-Id: 42950 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 F360D27BC4B; Thu, 29 May 2025 13:11:20 +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=-6.4 required=5.0 tests=BAYES_00,DKIM_INVALID, DKIM_SIGNED,FREEMAIL_FROM,MAILING_LIST_MULTI,RCVD_IN_DNSWL_BLOCKED, RCVD_IN_VALIDITY_CERTIFIED,RCVD_IN_VALIDITY_RPBL,RCVD_IN_VALIDITY_SAFE, 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 EA4CB27BC49 for ; Thu, 29 May 2025 13:11:16 +0100 (BST) Received: from localhost ([::1] helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1uKc6D-0003L0-2K; Thu, 29 May 2025 08:11:05 -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 1uKc6A-0003Kg-Gz for guix-patches@gnu.org; Thu, 29 May 2025 08:11:02 -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 1uKc6A-000596-6m for guix-patches@gnu.org; Thu, 29 May 2025 08:11: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:In-Reply-To:References:Subject; bh=KuzvEoZuqNUbNevxzH8KVbcjl/nH7QruAE5b8YKlz5c=; b=c5JdGmyCI2zOgfGCYsOuNSzUL4y4rr9Lz2PfGWy05J3pmp796jvERomWC1buQukDKxM6lfq3j6/mZHbEwaOCsR/d2DD1/HEen6ej6QPyEmLY4WZJ9K6MIjdkd+X2mRvTVWmv6TcgKdNCmsd658/GUL+KjQjIA2KtEDHM7Qmw2/QaUXHZAXjQUdS7wC/eDFokBWRPgeaqs9KbluM6V6uOtQByPzMTAjClZlUq6BME4tz92JJmV+Yrfqqy/wdxcrt4KtpCq4iFsrPOsWyEstnIG1C4leblvoiVrlgqxYUxD8+qDet4x/1FCJip1yBNgvrfmhetz/y+PDbolCJMtHhLWw==; Received: from Debian-debbugs by debbugs.gnu.org with local (Exim 4.84_2) (envelope-from ) id 1uKc69-0002fx-Vs; Thu, 29 May 2025 08:11:02 -0400 X-Loop: help-debbugs@gnu.org Subject: [bug#78496] [PATCH v2] gnu: Add sqlitestudio. References: <67d6bdbefc3671abf25f9509524f4de3f7382799.1747682121.git.phil.swart@gmx.fr> In-Reply-To: <67d6bdbefc3671abf25f9509524f4de3f7382799.1747682121.git.phil.swart@gmx.fr> Resent-From: Philippe SWARTVAGHER Original-Sender: "Debbugs-submit" Resent-CC: sharlatanus@gmail.com, guix-patches@gnu.org Resent-Date: Thu, 29 May 2025 12:11:01 +0000 Resent-Message-ID: Resent-Sender: help-debbugs@gnu.org X-GNU-PR-Message: followup 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-Xcc: Sharlatan Hellseher Received: via spool by 78496-submit@debbugs.gnu.org id=B78496.174852064110200 (code B ref 78496); Thu, 29 May 2025 12:11:01 +0000 Received: (at 78496) by debbugs.gnu.org; 29 May 2025 12:10:41 +0000 Received: from localhost ([127.0.0.1]:34936 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1uKc5p-0002eS-0G for submit@debbugs.gnu.org; Thu, 29 May 2025 08:10:41 -0400 Received: from mout.gmx.net ([212.227.17.20]:45205) by debbugs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1uKc5k-0002dx-3v for 78496@debbugs.gnu.org; Thu, 29 May 2025 08:10:38 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmx.fr; s=s31663417; t=1748520629; x=1749125429; i=phil.swart@gmx.fr; bh=KuzvEoZuqNUbNevxzH8KVbcjl/nH7QruAE5b8YKlz5c=; 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=XxfAIwTIGZxo1iMQ0EZ/Pt2LEx2HktpvQHDBmmYFQge1XNMMeFxZ175n+w/sAtLD QJIXpSYCf2q98xcYi6P+3ZZP6Qx6MObGyTClZWf7wMLhJH7CTZ/rxHhFZQ+mQr8ur ZJgYGaQJeUHCwPy+pech5j+G77CjZOSxapRccobn93lgRnzRGgyRpj9Rmy6eHBX79 VbjCu5Ssdi89AisG2xZSiLcKBSdlkQnOI5kF2nRiWw6aJXmitBIYrc2LaUIbpmVbe 7RdLAqkTx1fJFjebxqayrtD5hXJTcJbL15hC0zAFPRivOQHF5GJcsqclmCeWv1iJl KsiQsj08l9B2tfgOrQ== X-UI-Sender-Class: 724b4f7f-cbec-4199-ad4e-598c01a50d3a Received: from localhost.localdomain ([83.192.201.168]) by mail.gmx.net (mrgmx105 [212.227.17.174]) with ESMTPSA (Nemesis) id 1MVN6t-1uVIXa0ytb-00LsA9; Thu, 29 May 2025 14:10:29 +0200 Date: Thu, 29 May 2025 14:08:41 +0200 Message-ID: <9314d741bd37d054bbca8bbfc5e35d8f9e9353d3.1748520521.git.phil.swart@gmx.fr> X-Mailer: git-send-email 2.49.0 MIME-Version: 1.0 X-Provags-ID: V03:K1:27KJaVziy3a6xFvL19sQ2BDQoIuR+IFtMXF/ZOBs/LHR3Vn+FbN OqKedjKsENP7WRuqLlr+H3LB4CoumkNQpt9p1dykyeJpTxfZNyARdNmb2s5ss0Ux4ojam1I U4xZ4gs2Y1cLTOV1hJRo27uAzm9WDP9On4wQCVFEbA1sdMV2F/J3GEFxN4tCyQB1vM5ll3G CpOL+S0T4MXdh30y8BLdg== UI-OutboundReport: notjunk:1;M01:P0:QHza1igU9Xo=;6UmmqBMYs10zOeK1bDSCeyWndpG RGV5229KExGVPKeMwVau/RI5QGlGz7z3Rd/J/Ka427gyvnEP3Q1Fh8Pb0pejeCBZ9/AYw3kNw vQKa3Gst+rzNJUE3z4Jm/Q6MMrLcWw94hjoD8by1Wuey/gs7S3rlYVjcqmgJXLQxYxZRBjuZB bbaUgFYoCQRi3+P+WTWKflkWAXSIRt+iQiJ+fe+vfqqhyEWgE9YAjc7INPbWya9mZXHr/BOsY 9ApLEw3hVmO6KUyLCoZiW1XkoOFscUxDFP7SmOTse0geKDIbVMhBOXIdqkmNNE1PPzjwiFBZ/ dG6DhPHZktT8tpHEmzLE9Bd1QZEKYo/dh62ahjHFjM81DdiPlOlupbOEnoHlJhvD3looQ70+8 2EbfwgjeFOCuaxhILkAU0jLWl6gKuxW5zRVGPNU/TPNa1wSCHtf+Crxe+HAsaEJlNAEgRU9tc bJYVfEz8IBWRh5ZBP0LOgt8xm+h21CwkqAZecPFLtc353e+1TRECtMi8HbGETsO6OjY8Dl8Cd r2voHjngZMrTcxEVDDPH+Yy4UO3SQg4hjraaDhgHTBlGzLqjITZ6b7JVGUW8eTtuRm6+tNXRQ n9/FQBlGJorb1/PBUVo5MzmpIxnFbg6RmhxNPOTi3QpEHL/59rZMTiFD5973T+CYQWd+RSdmw Z2qdumCL+5PrOxR5rStBrgkl8nerv+yPQ9Ou/h5VvvVpmOtB24vxptYc57qJVyAH8JSHt4YpI ftE/Oa3/jJYhwThM2gMZeH1PMY4FVnhBTkNb1Np0FCkyXVLyG97gPaRuKsc6dBeZh8J3OgxRI YaXVQhdzpd6VgFBCSDwNXvOpwE/X4xehPwJAZ0c/f1A60MPggQjVng8bGbUxBOmt1ZgvabTbf VhucfW/ThsN1l+Ng2G1P9oeNMF94iLTMN3JUGWcqHnM/L+to1HEWGA1+ZbrYfvkLTRioT+V/o aJNf0ZMJx4ycGHsj/XigBWvJTEKWFzramRtgHdpaUFEPVAcG+ePkJpddOUEhypVa/xGFwI5RE toEbK1TRI00lJNqcrmUN0rY173WvcXZI95aFqz6eRF0AEMQG2vq/wWzlJjPmF+Rd3XDdU2V+X 7iXlF8x8IDlsWZ5avGPFCjL4UK7xou+lc0m94hSdA/bHXP6qwhOucuMn9LUlriXQygEqEZ/Re DDl+TfwIldFbh5zdcNE8K3lQ0hqd6aJSjZhul48FHQf/llFtNj+kkMXMlwlz4uVJaz4tLcu3l uRRDfWB+ouxJXorQ7mz+aGkS4adBVyqZDhgilopPg7SwEaQmutAlgLtbN4gCuCbX0q5wEPrhY k8Y5R5N88fFG7Dgb06Ur7y9QQ+JZQRI8PNW4jOqxgYmqhrUO8su4t26zdSVkGw9KBb4viirTg 4yEu7XAGYA6w4QsRnBcTV4vhC6MmtsBgzEpXNWKJRwCjIbvc+m2I1/6djP+CF5FOApGwtbvqS svwp33y2zYTpyAA7mYR8n5tq+FzFE5OrZckHdmYJSfCHG5sw+7IH8tPppAouxo6yPcz5PpWR6 2r9ATLew2mAjlUMoQQ74Z55px1Ts3QDHf/6NAJTXhbBfOpLc3Vm0IG0x45ayifIQswPN4ubf+ viCCJSfSqTqpKJaDAJ+tW3C/AVJXg7aqZBHL10k6fQUWUBbDkXRdNR9O6Co5TP8vfJvkDPk0B OhPs+V3s2mKod/aoaSwPu4I4ALPW8sKf26draZzCVUecJIpDCaSJmUgwfcyS2tEPVBHEItBUt SftrpycLoAelPW9TIr/fAuT6ZGcZnycByZt+yJ46ucljcBSJb8o0drzHBCriOiyWyGixfom15 QdY1iPXdrJigSFVXmzU4M6wJhOJ9YFrZdbKrntpXiNmP2uuF2pvO0IGG4Pj+2ItnLbY020L0U lzzvh/T8MIJtEDCNSWvIE3JMZtR2Qcus9nrvqdgpl1XqF34gTnieqJFxJGfTkcYO7hA+5qMN5 ZT6/gu0hup8AC9/AGqh3r0FSN1r1JzMB19cI7YqZChPX2AaCVbekFo/yjjktlZLeZssEn1ZiL VOaZ/NgyzaiczihsqD5G1KlrvufA7xCDtqLU/pC2ZnBIW3Ukaz64j887Qvh+cqgZNQ4VMq8nl jMoX3KJFH7pc2b1gO1SjHQxx5NXemndKTkaSBzV/Vtg5x3NtKPuBcd2cGEfK+kUKsALIjxyjq hnzDIfA1+8nXNRrQf9p+ktkEgsdB9e8h0fVEmjPKVDhnfAYV1iaiRwGJAmJ8u6N9IIk/wF6ly 29QRXeabL1BbzyZMxcXEuQDqvbEg48hVAev5YjWNgET1Kq2Gga07d4gXdRz71fiTbFnccZSWH rNKTWWaUoEm4gt2WcPQm1cKiJIPgMyANGJPSKgtjPYAH0kvvzGx414zXb0O9lAD6G6NFmLZUe LaHtHXxFCI5Nq3bMxRZQpBz6BDE9b+hIA3Nj1fXUlAtNi53YRM9MEOzn4YVEY2An0S1UNIqFC B5X6+C6ZCnflvCdobxOfSeDacBGay2yz6spZIUmYs0iNVTmCe495zcb2Rvj+9zhLKwpTvmVBw IBV7Z5iuZM0XuKo6ePH2AI5SILqNqa1Q9YeRlqoQW+/uSgLFQB16vrsef2+cNdN1sjBjz8owy EoBCIQGBMdhu+i1VnK0SME3OHCe7grxENCJf0Y2Sfg2gWwPKqk8RXFgABAu6x2jTA42wC/pEL vyBX6t1syJteNjR67ZGY3iW6LHEzJ+I5WB597U4iO5iz775A3pRGh7nlMSjQjGLQugaluUjhk g9msDPiUNe8TSumEeF2oP9GtRlSctvAju3XJtTifbYJKidU3ZvsZldATeRYwA5HCS+TxuVCIf SEGCHohaQ0MRDq0tHvzkkh6IzdMuoDBYcSqvsFGF7VkTEZppTvJ7sPbCCrPyZdL52vB3k3z00 E1IUyH1e9Dth8Qnlcvtv4sqY8pvQ81mljLiKEDzVXUDiVELvGTypvMzIuErGqJFL4dr4EsctW tTUOkAAAyXnf4F1hJ9toZKXvpqdlCy9crTPKvG64PqpB0Jtir+vYEXpzjzHRJiyRH4L+QsLJS DLylao+o5JrnhhOdqvlKFYMBjJMYQPQlyfaSJvly5zTtp2gYtF60XqCReu8h7qoN30i+EMzR4 sGDYZplx+qdFzpdt59IVkRu8e3UiEBTTEJCEaMzi2gAcJNUOxTuaYnP/XdYrBr87z6JrQIu86 9xqtIqO0x0clvmQjTDtERUSvfALKBJNxx+cYi6/HZyWtNqA== 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 | 100 +++++++++++++++++++++++++++++++++++++ 1 file changed, 100 insertions(+) base-commit: 799d930bf740a66792240eb27d98823f041b1335 diff --git a/gnu/packages/databases.scm b/gnu/packages/databases.scm index 73c8bebe98..6e296e3324 100644 --- a/gnu/packages/databases.scm +++ b/gnu/packages/databases.scm @@ -65,6 +65,7 @@ ;;; Copyright © 2024 Troy Figiel ;;; Copyright © 2024 gemmaro ;;; Copyright © 2025 Ashvith Shetty +;;; Copyright © 2025 Philippe Swartvagher ;;; ;;; This file is part of GNU Guix. ;;; @@ -5820,6 +5821,105 @@ (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 + (list + #: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") + (with-directory-excursion "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) + "."))))) + (replace 'build + (lambda _ + (invoke "make" "-j" + (number->string (parallel-job-count))) + (with-directory-excursion "Plugins" + (invoke "make")))) ;building plugins in parallel corrupts them + (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)) + (with-directory-excursion "Plugins" + (invoke "make" "-j" + (number->string (parallel-job-count)) "install"))))) + (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 "Graphical user interface to browse and edit SQLite databases") + (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")