[PR PATCH] gnucash: update to 5.0, enable SQL support + add libdbi packages

[cinerea0 <cinerea0@users.noreply.github.com>]

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

There is a new pull request by cinerea0 against master on the void-packages repository

https://github.com/cinerea0/void-packages gnucash
https://github.com/void-linux/void-packages/pull/43386

gnucash: update to 5.0, enable SQL support + add libdbi packages
#### Testing the changes
- I tested the changes in this PR: **YES**

#### New package
- These new packages conform to the [package requirements](https://github.com/void-linux/void-packages/blob/master/CONTRIBUTING.md#package-requirements): **YES**

#### Local build testing
- I built this PR locally for my native architecture, x86_64-glibc (crossbuilds disabled for gnucash)

---

**cc: @manfredu**


A patch file from https://github.com/void-linux/void-packages/pull/43386.patch is attached

[-- Warning: decoded text below may be mangled, UTF-8 assumed --]
[-- Attachment #2: github-pr-gnucash-43386.patch --]
[-- Type: text/x-diff, Size: 7409 bytes --]

From 13a8b525b8edbad2e9b0de82c4b453404824ead0 Mon Sep 17 00:00:00 2001
From: cinerea0 <cinerea0@disroot.org>
Date: Mon, 10 Apr 2023 23:39:54 -0400
Subject: [PATCH 1/3] New package: libdbi-0.9.0

---
 common/shlibs           |  1 +
 srcpkgs/libdbi-devel    |  1 +
 srcpkgs/libdbi-doc      |  1 +
 srcpkgs/libdbi/template | 30 ++++++++++++++++++++++++++++++
 4 files changed, 33 insertions(+)
 create mode 120000 srcpkgs/libdbi-devel
 create mode 120000 srcpkgs/libdbi-doc
 create mode 100644 srcpkgs/libdbi/template

diff --git a/common/shlibs b/common/shlibs
index 39fed5ffbcf5..8957268230ac 100644
--- a/common/shlibs
+++ b/common/shlibs
@@ -4243,3 +4243,4 @@ libdate-tz.so.3 chrono-date-3.0.1_1
 libayatana-ido3-0.4.so.0 ayatana-ido-0.9.2_1
 libayatana-indicator3.so.7 libayatana-indicator-0.9.3_1
 libayatana-appindicator3.so.1 libayatana-appindicator-0.5.91_1
+libdbi.so.1 libdbi-0.9.0_1
diff --git a/srcpkgs/libdbi-devel b/srcpkgs/libdbi-devel
new file mode 120000
index 000000000000..461034ca75ea
--- /dev/null
+++ b/srcpkgs/libdbi-devel
@@ -0,0 +1 @@
+libdbi
\ No newline at end of file
diff --git a/srcpkgs/libdbi-doc b/srcpkgs/libdbi-doc
new file mode 120000
index 000000000000..461034ca75ea
--- /dev/null
+++ b/srcpkgs/libdbi-doc
@@ -0,0 +1 @@
+libdbi
\ No newline at end of file
diff --git a/srcpkgs/libdbi/template b/srcpkgs/libdbi/template
new file mode 100644
index 000000000000..8298ad802294
--- /dev/null
+++ b/srcpkgs/libdbi/template
@@ -0,0 +1,30 @@
+# Template file for 'libdbi'
+pkgname=libdbi
+version=0.9.0
+revision=1
+build_style=gnu-configure
+short_desc="Database independent abstraction layer for C"
+maintainer="cinerea0 <cinerea0@protonmail.com>"
+license="LGPL-2.1-only"
+homepage="https://libdbi.sourceforge.net/"
+changelog="https://sourceforge.net/p/libdbi/libdbi/ci/master/tree/NEWS"
+distfiles="${SOURCEFORGE_SITE}/libdbi/libdbi-${version}.tar.gz"
+checksum=dafb6cdca524c628df832b6dd0bf8fabceb103248edb21762c02d3068fca4503
+
+libdbi-devel_package() {
+	short_desc+=" - development files"
+	depends="${sourcepkg}>=${version}_${revision}"
+	pkg_install() {
+		vmove usr/include
+		vmove usr/lib/pkgconfig
+		vmove "usr/lib/*.a"
+	}
+}
+
+libdbi-doc_package() {
+	short_desc+=" - documentation"
+	depends="${sourcepkg}>=${version}_${revision}"
+	pkg_install() {
+		vmove usr/share/doc
+	}
+}

From c2eaa2b260b030e8a2d186d641d1c394e0d1695a Mon Sep 17 00:00:00 2001
From: cinerea0 <cinerea0@disroot.org>
Date: Mon, 10 Apr 2023 23:40:26 -0400
Subject: [PATCH 2/3] New package: libdbi-drivers-0.9.0

---
 srcpkgs/libdbi-drivers-devel    |  1 +
 srcpkgs/libdbi-drivers-doc      |  1 +
 srcpkgs/libdbi-drivers/template | 33 +++++++++++++++++++++++++++++++++
 3 files changed, 35 insertions(+)
 create mode 120000 srcpkgs/libdbi-drivers-devel
 create mode 120000 srcpkgs/libdbi-drivers-doc
 create mode 100644 srcpkgs/libdbi-drivers/template

diff --git a/srcpkgs/libdbi-drivers-devel b/srcpkgs/libdbi-drivers-devel
new file mode 120000
index 000000000000..28d3bc25c5fc
--- /dev/null
+++ b/srcpkgs/libdbi-drivers-devel
@@ -0,0 +1 @@
+libdbi-drivers
\ No newline at end of file
diff --git a/srcpkgs/libdbi-drivers-doc b/srcpkgs/libdbi-drivers-doc
new file mode 120000
index 000000000000..28d3bc25c5fc
--- /dev/null
+++ b/srcpkgs/libdbi-drivers-doc
@@ -0,0 +1 @@
+libdbi-drivers
\ No newline at end of file
diff --git a/srcpkgs/libdbi-drivers/template b/srcpkgs/libdbi-drivers/template
new file mode 100644
index 000000000000..add0f8977175
--- /dev/null
+++ b/srcpkgs/libdbi-drivers/template
@@ -0,0 +1,33 @@
+# Template file for 'libdbi-drivers'
+pkgname=libdbi-drivers
+version=0.9.0
+revision=1
+build_style=gnu-configure
+configure_args="--with-mysql --with-pgsql --with-sqlite3"
+hostmakedepends="docbook docbook-dsssl openjade"
+makedepends="libdbi-devel libmariadbclient-devel postgresql-libs-devel
+ sqlite-devel zlib-devel"
+short_desc="Database drivers for libdbi (MySQL, PostgreSQL, and SQLite)"
+maintainer="cinerea0 <cinerea0@protonmail.com>"
+license="LGPL-2.1-only"
+homepage="https://libdbi-drivers.sourceforge.net/"
+changelog="https://sourceforge.net/p/libdbi-drivers/libdbi-drivers/ci/master/tree/NEWS"
+distfiles="${SOURCEFORGE_SITE}/libdbi-drivers/libdbi-drivers-${version}.tar.gz"
+checksum=43d2eacd573a4faff296fa925dd97fbf2aedbf1ae35c6263478210c61004c854
+make_check=no  # tests require full DB environments and hang
+
+libdbi-drivers-devel_package() {
+	short_desc+=" - development files"
+	depends="${sourcepkg}>=${version}_${revision}"
+	pkg_install() {
+		vmove "usr/lib/dbd/*.a"
+	}
+}
+
+libdbi-drivers-doc_package() {
+	short_desc+=" - documentation"
+	depends="${sourcepkg}>=${version}_${revision}"
+	pkg_install() {
+		vmove usr/share/doc
+	}
+}

From d92b7f3c5827b5f7a83bf758d3cfc245399a1c65 Mon Sep 17 00:00:00 2001
From: cinerea0 <cinerea0@disroot.org>
Date: Mon, 10 Apr 2023 23:42:23 -0400
Subject: [PATCH 3/3] gnucash: update to 5.0, enable SQL support

---
 srcpkgs/gnucash/template | 34 +++++++++++++++++-----------------
 1 file changed, 17 insertions(+), 17 deletions(-)

diff --git a/srcpkgs/gnucash/template b/srcpkgs/gnucash/template
index 3b3d1a4390e2..d0058b35f7d1 100644
--- a/srcpkgs/gnucash/template
+++ b/srcpkgs/gnucash/template
@@ -1,21 +1,23 @@
 # Template file for 'gnucash'
 pkgname=gnucash
-version=4.13
-revision=2
+version=5.0
+revision=1
 build_style=cmake
 make_check_target=check
-configure_args="-DWITH_SQL=0 -DWITH_PYTHON=1"
-hostmakedepends="pkg-config guile python3 libxslt perl gettext swig"
-makedepends="aqbanking-devel icu-devel boost-devel gc-devel glib-devel gtest-devel guile-devel
- gwenhywfar-devel ktoblzcheck-devel libofx-devel libsecret-devel
- libxslt-devel webkit2gtk-devel python3-devel gwenhywfar-gtk3 tzdata"
-depends="dconf guile perl"
+configure_args="-DWITH_PYTHON=1"
+hostmakedepends="gettext guile libxslt perl pkg-config python3 swig"
+makedepends="aqbanking-devel boost-devel gc-devel glib-devel gtest-devel
+ guile-devel gwenhywfar-devel gwenhywfar-gtk3 icu-devel ktoblzcheck-devel
+ libdbi-devel libdbi-drivers-devel libofx-devel libsecret-devel libxslt-devel
+ python3-devel tzdata webkit2gtk-devel"
+depends="dconf guile libdbi-drivers perl"
 short_desc="Financial-accounting software"
 maintainer="ManfredU <mu@usselmann.it>"
 license="GPL-2.0-or-later"
 homepage="http://www.gnucash.org"
-distfiles="${SOURCEFORGE_SITE}/${pkgname}/${pkgname}-${version}.tar.bz2"
-checksum=401a158086635ea17fbb145325558537289aa1d24d022f7c3317e12f3dabd8e7
+changelog="https://raw.githubusercontent.com/Gnucash/gnucash/stable/NEWS"
+distfiles="${SOURCEFORGE_SITE}/gnucash/gnucash-${version}.tar.bz2"
+checksum=cfc13bab31aed8e4962805ef56530f9772889604910b5678cb5c79c283138824
 
 pycompile_dirs="usr/share/gnucash/python"
 conf_files="/etc/gnucash/environment"
@@ -30,13 +32,11 @@ if [ "$XBPS_TARGET_ENDIAN" = "be" ]; then
 fi
 
 post_install() {
-	case "$XBPS_TARGET_MACHINE" in
-		# startup fails in scheme code when the locale is set to anything
-		# else on musl
-		*-musl) sed -i -e 's/Exec=gnucash/Exec=env LANG=C gnucash/' \
-			${DESTDIR}/usr/share/applications/gnucash.desktop
-			;;
-	esac
+	# startup fails in scheme code when the locale is set to anything else on musl
+	if [ "$XBPS_TARGET_LIBC" = "musl" ]; then
+		vsed -i ${DESTDIR}/usr/share/applications/gnucash.desktop \
+			-e 's/Exec=gnucash/Exec=env LANG=C gnucash/'
+	fi
 	rm -f "${DESTDIR}/usr/share/glib-2.0/schemas/gschemas.compiled"
 }