git: f890d1b0060b - main - Revert "databases/tcl-sqlite3: update to 3.50.3"

From: Pietro Cerutti <gahr_at_FreeBSD.org>
Date: Sun, 10 Aug 2025 21:18:05 UTC
The branch main has been updated by gahr:

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

commit f890d1b0060bdf615ca89ea51975495a44fab8a7
Author:     Pietro Cerutti <gahr@FreeBSD.org>
AuthorDate: 2025-08-10 21:17:06 +0000
Commit:     Pietro Cerutti <gahr@FreeBSD.org>
CommitDate: 2025-08-10 21:17:06 +0000

    Revert "databases/tcl-sqlite3: update to 3.50.3"
    
    This reverts commit 351e3faff8cc2968ce8674bb8ee6108db3e66a35.
    
    This was pushed by accident. For now it must stay in bug #285015.
---
 databases/tcl-sqlite3/Makefile             | 42 ++++++++++++++++++++++++++----
 databases/tcl-sqlite3/distinfo             |  6 ++---
 databases/tcl-sqlite3/files/example.tcl.in | 16 ++++++++++++
 databases/tcl-sqlite3/pkg-plist            |  4 ---
 4 files changed, 56 insertions(+), 12 deletions(-)

diff --git a/databases/tcl-sqlite3/Makefile b/databases/tcl-sqlite3/Makefile
index 7057aad9ced6..c51dc5825b38 100644
--- a/databases/tcl-sqlite3/Makefile
+++ b/databases/tcl-sqlite3/Makefile
@@ -1,9 +1,12 @@
 PORTNAME=	sqlite3
-DISTVERSION=	3.50.3
+PORTVERSION=	3.34.1
+PORTREVISION=	1
 CATEGORIES=	databases tcl
-MASTER_SITES=	SF/tcl/Tcl/9.0.2
+MASTER_SITES=	https://www.sqlite.org/2021/ \
+		https://www2.sqlite.org/2021/ \
+		https://www3.sqlite.org/2021/
 PKGNAMEPREFIX=	tcl-
-DISTNAME=	${TCL_PKG}
+DISTNAME=	sqlite-autoconf-${PORTVERSION:C/\.([[:digit:]])[[:>:]]/0\1/g:S/.//g}00
 
 MAINTAINER=	pavelivolkov@gmail.com
 COMMENT=	SQLite extension for Tcl using the Tcl Extension Architecture (TEA)
@@ -13,7 +16,36 @@ LICENSE=	PD
 
 LIB_DEPENDS=	libsqlite3.so:databases/sqlite3
 
-USES=		tcl:tea
-TCL_PKG=	${PORTNAME:S/3//}${DISTVERSION}
+USES=		pkgconfig tcl:tea
+USE_LDCONFIG=	yes
+
+GNU_CONFIGURE_MANPREFIX=${PREFIX}/share
+CONFIGURE_ARGS=	--with-system-sqlite
+
+CFLAGS+=	`pkg-config --cflags sqlite3`
+LDFLAGS+=	`pkg-config --libs sqlite3`
+
+SUB_FILES=	example.tcl
+SUB_LIST=	"TCLSH=${TCLSH}"
+
+WRKSRC=		${WRKDIR}/${DISTNAME}/tea
+
+PLIST_FILES=	lib/${PORTNAME}/libsqlite${PORTVERSION}.so \
+		lib/${PORTNAME}/pkgIndex.tcl \
+		share/man/mann/sqlite3.n.gz
+PORTEXAMPLES=	*
+
+OPTIONS_DEFINE=		EXAMPLES THREADS
+OPTIONS_DEFAULT=	THREADS
+
+THREADS_CONFIGURE_ENABLE=	threads
+
+post-patch:
+	@${REINPLACE_CMD} -E 's/^(.*\$$\(PACKAGE_NAME\))\$$\(PACKAGE_VERSION\).*$$/\1${PORTVERSION:C/[^[:digit:]]*([[:digit:]]+).*/\1/}/' ${WRKSRC}/Makefile.in
+
+post-install:
+	@${STRIP_CMD} ${STAGEDIR}${PREFIX}/lib/${PORTNAME}/libsqlite${PORTVERSION}.so
+	@${MKDIR} ${STAGEDIR}${EXAMPLESDIR}
+	${INSTALL_SCRIPT} ${WRKDIR}/${SUB_FILES} ${STAGEDIR}${EXAMPLESDIR}
 
 .include <bsd.port.mk>
diff --git a/databases/tcl-sqlite3/distinfo b/databases/tcl-sqlite3/distinfo
index cfd36c29c138..60045d92b952 100644
--- a/databases/tcl-sqlite3/distinfo
+++ b/databases/tcl-sqlite3/distinfo
@@ -1,3 +1,3 @@
-TIMESTAMP = 1754856115
-SHA256 (sqlite3.50.3.tar.gz) = 7b85226f0ba5a3b82bc261694635538bef193103c7a84e04db7c480bbc4785c1
-SIZE (sqlite3.50.3.tar.gz) = 3040041
+TIMESTAMP = 1611470952
+SHA256 (sqlite-autoconf-3340100.tar.gz) = 2a3bca581117b3b88e5361d0ef3803ba6d8da604b1c1a47d902ef785c1b53e89
+SIZE (sqlite-autoconf-3340100.tar.gz) = 2930089
diff --git a/databases/tcl-sqlite3/files/example.tcl.in b/databases/tcl-sqlite3/files/example.tcl.in
new file mode 100644
index 000000000000..3139b5515407
--- /dev/null
+++ b/databases/tcl-sqlite3/files/example.tcl.in
@@ -0,0 +1,16 @@
+#!%%TCLSH%%
+
+package require sqlite3
+
+if {$argc!=2} {
+  puts stderr "Usage: $argv0 DATABASE SQL-STATEMENT"
+  exit 1
+}
+sqlite3 db [lindex $argv 0]
+db eval [lindex $argv 1] x {
+  foreach v $x(*) {
+    puts "$v = $x($v)"
+  }
+  puts ""
+}
+db close
diff --git a/databases/tcl-sqlite3/pkg-plist b/databases/tcl-sqlite3/pkg-plist
deleted file mode 100644
index b85e584bd390..000000000000
--- a/databases/tcl-sqlite3/pkg-plist
+++ /dev/null
@@ -1,4 +0,0 @@
-bin/sqlite3_analyzer
-lib/%%TCL_PKG%%/lib%%TCL_PKG_LIB_PREFIX%%%%TCL_PKG%%.so
-lib/%%TCL_PKG%%/pkgIndex.tcl
-share/man/mann/sqlite3.n.gz