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

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

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

There is an updated 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: 7396 bytes --]

From 212901801b9e37efdc3054c193fa177feea1c391 Mon Sep 17 00:00:00 2001
From: cinerea0 <cinerea0@disroot.org>
Date: Thu, 13 Apr 2023 22:28:43 -0400
Subject: [PATCH 1/2] 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 605a8249c8e2..963a65824733 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 dd56e9eeb228928ef7a4b62af9811d1f0264e394 Mon Sep 17 00:00:00 2001
From: cinerea0 <cinerea0@disroot.org>
Date: Thu, 13 Apr 2023 22:46:22 -0400
Subject: [PATCH 2/2] New package: libdbi-drivers-0.9.0

---
 srcpkgs/libdbdmysql             |   1 +
 srcpkgs/libdbdpgsql             |   1 +
 srcpkgs/libdbdsqlite            |   1 +
 srcpkgs/libdbi-drivers-devel    |   1 +
 srcpkgs/libdbi-drivers-doc      |   1 +
 srcpkgs/libdbi-drivers/template | 107 ++++++++++++++++++++++++++++++++
 6 files changed, 112 insertions(+)
 create mode 120000 srcpkgs/libdbdmysql
 create mode 120000 srcpkgs/libdbdpgsql
 create mode 120000 srcpkgs/libdbdsqlite
 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/libdbdmysql b/srcpkgs/libdbdmysql
new file mode 120000
index 000000000000..28d3bc25c5fc
--- /dev/null
+++ b/srcpkgs/libdbdmysql
@@ -0,0 +1 @@
+libdbi-drivers
\ No newline at end of file
diff --git a/srcpkgs/libdbdpgsql b/srcpkgs/libdbdpgsql
new file mode 120000
index 000000000000..28d3bc25c5fc
--- /dev/null
+++ b/srcpkgs/libdbdpgsql
@@ -0,0 +1 @@
+libdbi-drivers
\ No newline at end of file
diff --git a/srcpkgs/libdbdsqlite b/srcpkgs/libdbdsqlite
new file mode 120000
index 000000000000..28d3bc25c5fc
--- /dev/null
+++ b/srcpkgs/libdbdsqlite
@@ -0,0 +1 @@
+libdbi-drivers
\ No newline at end of file
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..725c6d1d259c
--- /dev/null
+++ b/srcpkgs/libdbi-drivers/template
@@ -0,0 +1,107 @@
+# Template file for 'libdbi-drivers'
+pkgname=libdbi-drivers
+version=0.9.0
+revision=1
+build_style=meta
+configure_args="--prefix=/usr --with-mysql --with-pgsql --with-sqlite3"
+hostmakedepends="automake docbook docbook-dsssl libtool openjade
+ postgresql-libs-devel"
+makedepends="libdbi-devel libmariadbclient-devel postgresql-libs-devel
+ sqlite-devel zlib-devel"
+depends="libdbdmysql libdbdpgsql libdbdsqlite"
+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
+
+if [ "${CROSS_BUILD}" ]; then
+	configure_args+=" --host=${XBPS_CROSS_TRIPLET}
+	 --with-libdbi-libdir=${XBPS_CROSS_BASE}/usr/lib"
+fi
+
+pre_configure() {
+	autoreconf -fi
+}
+
+# build_style is meta because subpackages move all files out of the main
+# package, so build steps must be directly included. do_configure through
+# do_install are taken directly from common/build-style/gnu-configure.sh.
+do_configure() {
+	: ${configure_script:=./configure}
+
+	export lt_cv_sys_lib_dlsearch_path_spec="/usr/lib64 /usr/lib32 /usr/lib /lib /usr/local/lib"
+	${configure_script} ${configure_args}
+}
+
+do_build() {
+	: ${make_cmd:=make}
+
+	export lt_cv_sys_lib_dlsearch_path_spec="/usr/lib64 /usr/lib32 /usr/lib /lib /usr/local/lib"
+	${make_cmd} ${makejobs} ${make_build_args} ${make_build_target}
+}
+
+do_check() {
+	if [ -z "$make_cmd" ] && [ -z "$make_check_target" ]; then
+		if make -q check 2>/dev/null; then
+			:
+		else
+			if [ $? -eq 2 ]; then
+				msg_warn 'No target to "make check".\n'
+				return 0
+			fi
+		fi
+	fi
+
+	: ${make_cmd:=make}
+	: ${make_check_target:=check}
+
+	${make_check_pre} ${make_cmd} ${makejobs} ${make_check_args} ${make_check_target}
+}
+
+do_install() {
+	: ${make_cmd:=make}
+	: ${make_install_target:=install}
+
+	${make_cmd} DESTDIR=${DESTDIR} ${make_install_args} ${make_install_target}
+}
+
+libdbdmysql_package() {
+	short_desc="MySQL driver for libdbi"
+	pkg_install() {
+		vmove usr/lib/dbd/libdbdmysql.so
+	}
+}
+
+libdbdpgsql_package() {
+	short_desc="PostgreSQL driver for libdbi"
+	pkg_install() {
+		vmove usr/lib/dbd/libdbdpgsql.so
+	}
+}
+
+libdbdsqlite_package() {
+	short_desc="SQLite driver for libdbi"
+	pkg_install() {
+		vmove usr/lib/dbd/libdbdsqlite3.so
+	}
+}
+
+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
+	}
+}