git: 43f38b2f50cc - main - databases/sqlitebrowser: Switch bundled libraries to ports

From: Kousuke Kannagi <mce_at_FreeBSD.org>
Date: Tue, 01 Sep 2026 10:37:47 UTC
The branch main has been updated by mce:

URL: https://cgit.FreeBSD.org/ports/commit/?id=43f38b2f50cc3f37c74819ef79af7e5e841057cd

commit 43f38b2f50cc3f37c74819ef79af7e5e841057cd
Author:     Kousuke Kannagi <mce@FreeBSD.org>
AuthorDate: 2026-09-01 08:27:09 +0000
Commit:     Kousuke Kannagi <mce@FreeBSD.org>
CommitDate: 2026-09-01 10:36:07 +0000

    databases/sqlitebrowser: Switch bundled libraries to ports
    
    Enable unit tests.
    Fix build with cmake 4.
    Add SQLCIPHER option.
    
    PR:             298007
    Approved by:    fluffy (mentor)
---
 databases/sqlitebrowser/Makefile                   | 25 ++++++++++++++++++----
 .../files/extra-patch-src_SqlUiLexer.cpp           | 11 ++++++++++
 .../files/patch-libs_qhexedit_CMakeLists.txt       |  8 +++++++
 3 files changed, 40 insertions(+), 4 deletions(-)

diff --git a/databases/sqlitebrowser/Makefile b/databases/sqlitebrowser/Makefile
index fac528678857..0554e24468e1 100644
--- a/databases/sqlitebrowser/Makefile
+++ b/databases/sqlitebrowser/Makefile
@@ -1,21 +1,38 @@
 PORTNAME=	sqlitebrowser
 DISTVERSIONPREFIX=	v
 DISTVERSION=	3.13.1
+PORTREVISION=	1
 CATEGORIES=	databases
 
 MAINTAINER=	mce@FreeBSD.org
 COMMENT=	Visual tool to manage SQLite databases
 WWW=		https://sqlitebrowser.org/
 
-LICENSE=	MPL20 GPLv3+
+LICENSE=	GPLv3+ MPL20
 LICENSE_COMB=	dual
-LICENSE_FILE_GPLv3=	${WRKSRC}/LICENSE-GPL-3.0
+LICENSE_FILE_GPLv3+ =	${WRKSRC}/LICENSE-GPL-3.0
 LICENSE_FILE_MPL20=	${WRKSRC}/LICENSE-MPL-2.0
 
-USES=		cmake compiler:c++14-lang desktop-file-utils gnome qt:5 sqlite
+LIB_DEPENDS=	libQCustomPlot-qt5.so:graphics/qcustomplot@qt5 \
+		libqscintilla2_qt5.so:devel/qscintilla2@qt5
+
+USES=		cmake:testing compiler:c++14-lang desktop-file-utils gnome qt:5
+USE_GITHUB=	yes
 USE_QT=		core concurrent gui network printsupport testlib widgets \
 		buildtools:build linguisttools:build qmake:build xml
-USE_GITHUB=	yes
+
+CMAKE_ARGS=	-DFORCE_INTERNAL_QCUSTOMPLOT=OFF \
+		-DQCustomPlot_LIBRARY=${LOCALBASE}/lib/libQCustomPlot-qt5.so \
+		-DQSCINTILLA_INCLUDE_DIR=${QT_INCDIR}/Qsci \
+		-DQSCINTILLA_LIBRARY=${QT_LIBDIR}/libqscintilla2_qt5.so
+CMAKE_TESTING_ARGS=	-DENABLE_TESTING=ON
+
+OPTIONS_DEFINE=		SQLCIPHER
+SQLCIPHER_DESC=		Support encrypted SQLite databases
+SQLCIPHER_LIB_DEPENDS=	libsqlcipher.so:databases/sqlcipher
+SQLCIPHER_USES_OFF=	sqlite
+SQLCIPHER_CMAKE_ON=	-Dsqlcipher=ON
+SQLCIPHER_EXTRA_PATCHES=	${PATCHDIR}/extra-patch-src_SqlUiLexer.cpp
 
 post-patch:
 	@${REINPLACE_CMD} -e 's|%%DATADIR%%|${DATADIR}|' \
diff --git a/databases/sqlitebrowser/files/extra-patch-src_SqlUiLexer.cpp b/databases/sqlitebrowser/files/extra-patch-src_SqlUiLexer.cpp
new file mode 100644
index 000000000000..6b78fb276b68
--- /dev/null
+++ b/databases/sqlitebrowser/files/extra-patch-src_SqlUiLexer.cpp
@@ -0,0 +1,11 @@
+--- src/SqlUiLexer.cpp.orig	2026-09-01 07:41:25 UTC
++++ src/SqlUiLexer.cpp
+@@ -4,7 +4,7 @@
+ #include "Qsci/qsciapis.h"
+ #include "Settings.h"
+ #include "sqlitedb.h"
+-#include "sqlite3.h"
++#include "sqlcipher/sqlite3.h"
+ 
+ namespace
+ {
diff --git a/databases/sqlitebrowser/files/patch-libs_qhexedit_CMakeLists.txt b/databases/sqlitebrowser/files/patch-libs_qhexedit_CMakeLists.txt
new file mode 100644
index 000000000000..346ec5ec9c73
--- /dev/null
+++ b/databases/sqlitebrowser/files/patch-libs_qhexedit_CMakeLists.txt
@@ -0,0 +1,8 @@
+--- libs/qhexedit/CMakeLists.txt.orig	2026-08-28 03:14:58 UTC
++++ libs/qhexedit/CMakeLists.txt
+@@ -1,4 +1,4 @@
+-cmake_minimum_required(VERSION 2.8.12.2)
++cmake_minimum_required(VERSION 3.5)
+ 
+ set(CMAKE_AUTOMOC ON)
+ set(CMAKE_INCLUDE_CURRENT_DIR ON)