Skip site navigation (1)Skip section navigation (2)
Date:      Tue, 27 Apr 2021 17:03:46 GMT
From:      Neel Chauhan <nc@FreeBSD.org>
To:        ports-committers@FreeBSD.org, dev-commits-ports-all@FreeBSD.org, dev-commits-ports-main@FreeBSD.org
Subject:   git: 4e00066ccb96 - main - databases/sqlite3: Update to 3.35.5
Message-ID:  <202104271703.13RH3k1c052058@gitrepo.freebsd.org>

next in thread | raw e-mail | index | archive | help
The branch main has been updated by nc:

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

commit 4e00066ccb9699f670b9a3be411b13bc26a932f2
Author:     Neel Chauhan <nc@FreeBSD.org>
AuthorDate: 2021-04-27 17:03:07 +0000
Commit:     Neel Chauhan <nc@FreeBSD.org>
CommitDate: 2021-04-27 17:03:07 +0000

    databases/sqlite3: Update to 3.35.5
    
    Changes: https://www.sqlite.org/releaselog/3_35_5.html
    
    PR:             255392
    Submitted by:   Pavel Volkov <pavelivolkov AT gmail DOT com> (maintainer)
---
 databases/sqlite3/Makefile                | 357 ++++++++++++------------------
 databases/sqlite3/distinfo                |   6 +-
 databases/sqlite3/files/example.tcl.in    |  16 ++
 databases/sqlite3/files/patch-Makefile.in |  11 +
 databases/sqlite3/pkg-plist               |   9 +-
 5 files changed, 180 insertions(+), 219 deletions(-)

diff --git a/databases/sqlite3/Makefile b/databases/sqlite3/Makefile
index f68f313642a0..71a0d184249d 100644
--- a/databases/sqlite3/Makefile
+++ b/databases/sqlite3/Makefile
@@ -1,11 +1,10 @@
 # Created by: Ying-Chieh Liao <ijliao@FreeBSD.org>
 
 PORTNAME=	sqlite3
-DISTVERSION=	3.34.1
-PORTREVISION=	1
+DISTVERSION=	3.35.5
 PORTEPOCH=	1
 CATEGORIES=	databases
-MASTER_SITES=	https://www.sqlite.org/2021/ https://www2.sqlite.org/2021/ https://www3.sqlite.org/2021/
+MASTER_SITES=	https://www.sqlite.org/${%Y:L:gmtime}/ https://www2.sqlite.org/${%Y:L:gmtime}/ https://www3.sqlite.org/${%Y:L:gmtime}/
 DISTNAME=	sqlite-src-${PORTVERSION:C/\.([[:digit:]])[[:>:]]/0\1/g:S/.//g}00
 
 MAINTAINER=	pavelivolkov@gmail.com
@@ -13,225 +12,157 @@ COMMENT=	SQL database engine in a C library
 
 LICENSE=	PD
 
-USES=		libtool pathfix zip
+USES=	libtool pathfix zip
 USE_LDCONFIG=	yes
 
 GNU_CONFIGURE=	yes
+
 MAKE_JOBS_UNSAFE=	yes
-ALL_TARGET=	all
-CONFIGURE_ENV=	TCLSH_CMD="${TCLSH}"
-PLIST_SUB=	TCL_VER="${TCL_VER}"
+TEST_TARGET=	test
 
-# Compilation Options For SQLite https://www.sqlite.org/compile.html
-OPTIONS_DEFINE=		FTS4 URI URI_AUTHORITY METADATA \
-			DIRECT_READ MEMMAN SECURE_DELETE UNLOCK_NOTIFY THREADS \
-			EXTENSION ARMOR STMT DBPAGE DBSTAT FTS5 RBU NULL_TRIM \
-			LIKENOTBLOB STSHELL FTS3_TOKEN UNKNOWN_SQL SORT_REF \
-			NORMALIZE DQS TRUSTED_SCHEMA TCL
-OPTIONS_SINGLE=		RAMT
-OPTIONS_RADIO=		STAT RL
-OPTIONS_GROUP=		OPT_EXT OPT_FUNC UNICODE RTREEG
-OPTIONS_SUB=		yes
+# The default numeric file permissions for newly created database files under unix.
+# If not specified, the default is 0644 which means that the files is globally
+# readable but only writable by the creator.
+.ifdef DEFAULT_FILE_PERMISSIONS
+CPPFLAGS+=	-DSQLITE_DEFAULT_FILE_PERMISSIONS=${DEFAULT_FILE_PERMISSIONS}
+.endif
+
+SUB_FILES=	example.tcl
+SUB_LIST=	TCLSH_CMD="${TCLSH}"
+
+PLIST_SUB=	TCLVER=tcl${TCL_VER} TCLSUF=tcl${TCL_VER:S/.//g}
 
+# Compilation Options For SQLite https://www.sqlite.org/compile.html
+OPTIONS_DEFINE=		ARMOR DBPAGE DBSTAT DIRECT_READ DQS EXAMPLES EXTENSION FTS3_TOKEN \
+			FTS4 FTS5 LIKENOTBLOB MEMMAN METADATA NORMALIZE NULL_TRIM RBU SECURE_DELETE \
+			SORT_REF STATIC STMT STRIP TCL THREADS TRUSTED_SCHEMA UNKNOWN_SQL UNLOCK_NOTIFY \
+			UPDATE_LIMIT URI URI_AUTHORITY
+OPTIONS_DEFAULT=	DBPAGE DBSTAT DQS EXTENSION FTS3_TOKEN FTS4 FTS5 JSON1 LIBEDIT METADATA \
+			RTREE SECURE_DELETE STRIP THREADS TS1 UNICODE61 UNLOCK_NOTIFY URI
+# SECURE_DELETE, UNLOCK_NOTIFY, DBSTAT (since 41.0) used by www/firefox et al.
+# RTREE used by graphics/mapnik, databases/spatialite
+# FTS3_TOKEN used by audio/clementine-player, mail/thunderbird, www/seamonkey
+# FTS5 used by sysutils/tracker
+# JSON1 used by net-im/py-matrix-synapse
+# DBPAGE used by audio/audacity (since 3.0.0)
+#
+OPTIONS_GROUP=		OPT_EXT OPT_FUNC RTREEG UNICODE
 OPTIONS_GROUP_OPT_EXT=	JSON1 SESSION
 OPTIONS_GROUP_OPT_FUNC=	OFFSET SER1 SOUNDEX
+OPTIONS_GROUP_RTREEG=	GEOPOLY RTREE RTREE_INT
+OPTIONS_GROUP_UNICODE=	ICU UNICODE61
+OPTIONS_RADIO=		STAT RL
+OPTIONS_RADIO_RL=	LIBEDIT READLINE
+OPTIONS_RADIO_STAT=	STAT3 STAT4
+OPTIONS_SINGLE=		RAMT
+OPTIONS_SINGLE_RAMT=	TS0 TS1 TS2 TS3
+OPTIONS_SUB=		yes
 
-OPT_EXT_DESC=		Optional extensions
-OPT_FUNC_DESC=		Optional functions
-URI_DESC=		Enable use the URI filename
-URI_AUTHORITY_DESC=	Allow convert URL into a UNC
-SOUNDEX_DESC=		Enable the soundex() SQL function
-METADATA_DESC=		Enable column metadata
+ARMOR_DESC=		Detect misuse of the API # https://www.sqlite.org/compile.html#enable_api_armor
+DBPAGE_DESC=		Enable DBPAGE Virtual Table # https://sqlite.org/compile.html#enable_dbpage_vtab
+DBSTAT_DESC=		Enable DBSTAT Virtual Table # https://www.sqlite.org/dbstat.html
 DIRECT_READ_DESC=	File is read directly from disk
-MEMMAN_DESC=		Allow it to release unused memory
-SECURE_DELETE_DESC=	Overwrite deleted information with zeros
-UNLOCK_NOTIFY_DESC=	Enable notification on unlocking
+DQS_DESC=		Double-quoted String Literals # https://www.sqlite.org/compile.html#dqs
 EXTENSION_DESC=		Allow loadable extensions
-STSHELL_DESC=		Statically link libsqlite3 into shell
+FTS3_TOKEN_DESC=	Enable two-args version fts3_tokenizer # https://www.sqlite.org/compile.html#enable_fts3_tokenizer, https://www.sqlite.org/fts3.html#f3tknzr
+FTS4_DESC=		Enable FTS3/4 (Full Text Search) module # https://www.sqlite.org/fts3.html, https://www.sqlite.org/compile.html#enable_fts3_parenthesis
+FTS5_DESC=		Enable version 5 full-text search engine # https://www.sqlite.org/fts5.html
+GEOPOLY_DESC=		Uses the GeoJSON notation (RFC-7946) # https://www.sqlite.org/geopoly.html
+JSON1_DESC=		Enable the JSON1 extension # https://www.sqlite.org/json1.html
+LIKENOTBLOB_DESC=	LIKE does not match blobs # https://sqlite.org/compile.html#like_doesnt_match_blobs
+MEMMAN_DESC=		Allow it to release unused memory
+METADATA_DESC=		Enable column metadata
 NORMALIZE_DESC=		Enable normalized sql function
+NULL_TRIM_DESC=		Omits NULL columns at the ends of rows # https://sqlite.org/compile.html#enable_null_trim
+OFFSET_DESC=		Enable sqlite_offset() returning record's file offset # http://www.sqlite.org/compile.html#enable_offset_sql_func
+OPT_EXT_DESC=		Optional extensions
+OPT_FUNC_DESC=		Optional functions
+RAMT_DESC=		Where to store temporary file # https://www.sqlite.org/tempfiles.html#tempstore
+RBU_DESC=		Enable the resumable bulk update # https://www.sqlite.org/rbu.html
+RL_DESC=		Command line editing library
+RTREEG_DESC=		Index type for range queries # https://www.sqlite.org/rtree.html
+RTREE_DESC=		Enable R*Tree module
+RTREE_INT_DESC=		Store 32-bit sig int (no float) coordinates
+SECURE_DELETE_DESC=	Overwrite deleted information with zeros
+SER1_DESC=		Enable the sqlite3_[de]serialize() interface # https://www.sqlite.org/compile.html#enable_deserialize
+SESSION_DESC=		Enable the session extension # https://www.sqlite.org/sessionintro.html
+SORT_REF_DESC=		To use references in the sorter # https://www.sqlite.org/compile.html#enable_sorter_references
+SOUNDEX_DESC=		Enable the soundex() SQL function
+STAT3_DESC=		Collect histogram data from leftmost column
+STAT4_DESC=		Collect histogram data from all columns
+STAT_DESC=		Which query planner to use, stability or ... # https://www.sqlite.org/queryplanner-ng.html#qpstab
+STMT_DESC=		Prepared statement scan status # https://www.sqlite.org/c3ref/stmt_scanstatus.html
 TCL_DESC=		Enable tcl extension and sqlite_analyzer
-
-# https://www.sqlite.org/compile.html#dqs
-DQS_DESC=		Double-quoted String Literals
-
-# https://sqlite.org/compile.html#enable_null_trim
-NULL_TRIM_DESC=		Omits NULL columns at the ends of rows
-
-# http://www.sqlite.org/compile.html#enable_offset_sql_func
-OFFSET_DESC=		Enable sqlite_offset() returning record's file offset
-
-# https://www.sqlite.org/compile.html#enable_deserialize
-SER1_DESC=		Enable the sqlite3_[de]serialize() interface
-
-# https://www.sqlite.org/sessionintro.html
-SESSION_DESC=		Enable the session extension
-
-# https://sqlite.org/compile.html#like_doesnt_match_blobs
-LIKENOTBLOB_DESC=	LIKE does not match blobs
-
-# https://www.sqlite.org/compile.html#enable_api_armor
-ARMOR_DESC=		Detect misuse of the API
-
-# http://sqlite.org/compile.html#enable_unknown_sql_function
-UNKNOWN_SQL_DESC=	Suppress unknown function errors
-
-# https://www.sqlite.org/fts3.html
-# https://www.sqlite.org/compile.html#enable_fts3_parenthesis
-FTS4_DESC=		Enable FTS3/4 (Full Text Search) module
-
-# https://www.sqlite.org/fts5.html
-FTS5_DESC=		Enable version 5 full-text search engine
-
-# https://www.sqlite.org/compile.html#enable_fts3_tokenizer
-# https://www.sqlite.org/fts3.html#f3tknzr
-FTS3_TOKEN_DESC=	Enable two-args version fts3_tokenizer
-
-# https://www.sqlite.org/json1.html
-JSON1_DESC=		Enable the JSON1 extension
-
-# https://www.sqlite.org/rbu.html
-RBU_DESC=		Enable the resumable bulk update
-
-# https://www.sqlite.org/c3ref/stmt_scanstatus.html
-STMT_DESC=		Prepared statement scan status
-
-# https://www.sqlite.org/compile.html#enable_sorter_references
-SORT_REF_DESC=		To use references in the sorter
-
-# https://www.sqlite.org/compile.html#trusted_schema
-TRUSTED_SCHEMA_DESC=	SQL functions & virtual tables are considered unsafe
-
-# https://www.sqlite.org/tempfiles.html#tempstore
-OPTIONS_SINGLE_RAMT=	TS0 TS1 TS2 TS3
-RAMT_DESC=		Where to store temporary file
+TRUSTED_SCHEMA_DESC=	SQL functions & virtual tables are considered unsafe # https://www.sqlite.org/compile.html#trusted_schema
 TS0_DESC=		Always use temporary file
 TS1_DESC=		File by default, change allowed PRAGMA
 TS2_DESC=		Memory by default, change allowed PRAGMA
 TS3_DESC=		Always use memory
+UNICODE61_DESC=		Unicode Version 6.1 tokenizer # https://www.sqlite.org/fts3.html#tokenizer
+UNKNOWN_SQL_DESC=	Suppress unknown function errors # http://sqlite.org/compile.html#enable_unknown_sql_function
+UNLOCK_NOTIFY_DESC=	Enable notification on unlocking
+UPDATE_LIMIT_DESC=	UPDATE/DELETE is extended with ORDER BY and LIMIT # https://www.sqlite.org/compile.html#enable_update_delete_limit
+URI_AUTHORITY_DESC=	Allow convert URL into a UNC
+URI_DESC=		Enable use the URI filename
 
-# https://www.sqlite.org/queryplanner-ng.html#qpstab
-OPTIONS_RADIO_STAT=	STAT3 STAT4
-STAT_DESC=		Which query planner to use, stability or ...
-STAT3_DESC=		Collect histogram data from leftmost column
-STAT4_DESC=		Collect histogram data from all columns
-
-# https://sqlite.org/compile.html#enable_dbpage_vtab
-DBPAGE_DESC=		Enable DBPAGE Virtual Table
-
-# https://www.sqlite.org/dbstat.html
-DBSTAT_DESC=		Enable DBSTAT Virtual Table
-
-# https://www.sqlite.org/fts3.html#tokenizer
-OPTIONS_GROUP_UNICODE=	ICU UNICODE61
-UNICODE61_DESC=		Unicode Version 6.1 tokenizer
-
-# https://www.sqlite.org/rtree.html
-OPTIONS_GROUP_RTREEG=	RTREE RTREE_INT GEOPOLY
-RTREEG_DESC=		Index type for range queries
-RTREE_DESC=		Enable R*Tree module
-RTREE_INT_DESC=		Store 32-bit sig int (no float) coordinates
-# https://www.sqlite.org/geopoly.html
-GEOPOLY_DESC=		Uses the GeoJSON notation (RFC-7946)
-GEOPOLY_IMPLIES=	RTREE
-
-OPTIONS_RADIO_RL=	READLINE LIBEDIT
-RL_DESC=		Command line editing library
-
-OPTIONS_DEFAULT=	FTS4 URI METADATA SECURE_DELETE UNLOCK_NOTIFY THREADS \
-			EXTENSION TS1 UNICODE61 RTREE DBSTAT STSHELL LIBEDIT \
-			FTS3_TOKEN FTS5 DQS JSON1
-# SECURE_DELETE, UNLOCK_NOTIFY, DBSTAT (since 41.0) used by www/firefox et al.
-# RTREE used by graphics/mapnik, databases/spatialite
-# FTS3_TOKEN used by audio/clementine-player, mail/thunderbird, www/seamonkey
-# FTS5 used by sysutils/tracker
-# JSON1 used by net-im/py-matrix-synapse
-
-# The default numeric file permissions for newly created database files under unix.
-# If not specified, the default is 0644 which means that the files is globally
-# readable but only writable by the creator.
-.ifdef DEFAULT_FILE_PERMISSIONS
-CPPFLAGS+=		-DSQLITE_DEFAULT_FILE_PERMISSIONS=${DEFAULT_FILE_PERMISSIONS}
-.endif
-
-# Use an in-ram database for temporary tables (never,no,yes,always),
-TS0_CPPFLAGS=	-DSQLITE_TEMP_STORE=0
-TS1_CPPFLAGS=	-DSQLITE_TEMP_STORE=1
-TS2_CPPFLAGS=	-DSQLITE_TEMP_STORE=2
-TS3_CPPFLAGS=	-DSQLITE_TEMP_STORE=3
-
-RTREE_CPPFLAGS=	-DSQLITE_ENABLE_RTREE=1
-RTREE_INT_CPPFLAGS=	-DSQLITE_RTREE_INT_ONLY=1
-GEOPOLY_CPPFLAGS=	-DSQLITE_ENABLE_GEOPOLY=1
-
-FTS4_CPPFLAGS=	-DSQLITE_ENABLE_FTS3 -DSQLITE_ENABLE_FTS3_PARENTHESIS=1 -DSQLITE_ENABLE_FTS4=1
-FTS5_CONFIGURE_ENABLE=	fts5
-FTS5_LIBS=		-lm
-FTS3_TOKEN_CPPFLAGS=	-DSQLITE_ENABLE_FTS3_TOKENIZER=1
-
-SOUNDEX_CPPFLAGS=	-DSQLITE_SOUNDEX=1
-MEMMAN_CPPFLAGS=	-DSQLITE_ENABLE_MEMORY_MANAGEMENT=1
-SECURE_DELETE_CPPFLAGS=	-DSQLITE_SECURE_DELETE=1
-UNLOCK_NOTIFY_CPPFLAGS=	-DSQLITE_ENABLE_UNLOCK_NOTIFY=1
-METADATA_CPPFLAGS=	-DSQLITE_ENABLE_COLUMN_METADATA=1
-STAT3_CPPFLAGS=	-DSQLITE_ENABLE_STAT3=1
-STAT4_CPPFLAGS=	-DSQLITE_ENABLE_STAT4=1
+ARMOR_CPPFLAGS=	-DSQLITE_ENABLE_API_ARMOR=1
 DBPAGE_CPPFLAGS=	-DSQLITE_ENABLE_DBPAGE_VTAB=1
 DBSTAT_CPPFLAGS=	-DSQLITE_ENABLE_DBSTAT_VTAB=1
-URI_CPPFLAGS=	-DSQLITE_USE_URI=1
-URI_AUTHORITY_CPPFLAGS=	-DSQLITE_ALLOW_URI_AUTHORITY=1
 DIRECT_READ_CPPFLAGS=	-DSQLITE_DIRECT_OVERFLOW_READ=1
-ARMOR_CPPFLAGS=	-DSQLITE_ENABLE_API_ARMOR=1
-STMT_CPPFLAGS=	-DSQLITE_ENABLE_STMT_SCANSTATUS=1
-
-EXTENSION_CONFIGURE_ENABLE=	dynamic-extensions
-
-THREADS_CONFIGURE_ENABLE=	threadsafe
-THREADS_LIBS=		-lpthread
-
-TRUSTED_SCHEMA_CPPFLAGS=	-DSQLITE_TRUSTED_SCHEMA=0
-
+DQS_CPPFLAGS=	-DSQLITE_DQS=3
+DQS_CPPFLAGS_OFF=	-DSQLITE_DQS=0
+EXTENSION_CONFIGURE_ENABLE=	load-extension
+FTS3_TOKEN_CPPFLAGS=	-DSQLITE_ENABLE_FTS3_TOKENIZER=1
+FTS4_CONFIGURE_ENABLE=	fts3 fts4
+FTS4_CPPFLAGS=	-DSQLITE_ENABLE_FTS3_PARENTHESIS=1
+FTS5_CONFIGURE_ENABLE=	fts5
+FTS5_LIBS=	-lm
+GEOPOLY_IMPLIES=	RTREE
+GEOPOLY_CONFIGURE_ENABLE=	geopoly
 ICU_BUILD_DEPENDS=	${LOCALBASE}/bin/icu-config:devel/icu
 ICU_LIB_DEPENDS=	libicudata.so:devel/icu
 ICU_CPPFLAGS=	`${LOCALBASE}/bin/icu-config --cppflags` -DSQLITE_ENABLE_ICU=1
 ICU_LIBS=	`${LOCALBASE}/bin/icu-config --ldflags`
-
-UNICODE61_CPPFLAGS=	""
-UNICODE61_CPPFLAGS_OFF=	-DSQLITE_DISABLE_FTS3_UNICODE=1
-
-LIBEDIT_CONFIGURE_ENABLE=	editline
-LIBEDIT_USES=	libedit
-READLINE_CONFIGURE_ENABLE=	readline
-READLINE_USES=	readline
-
 JSON1_CONFIGURE_ENABLE=	json1
-
-RBU_CPPFLAGS=	-DSQLITE_ENABLE_RBU=1
-
+LIBEDIT_USES=	libedit
+LIBEDIT_CONFIGURE_ENABLE=	editline
 LIKENOTBLOB_CPPFLAGS=	-DSQLITE_LIKE_DOESNT_MATCH_BLOBS=1
-
-STSHELL_CONFIGURE_ENABLE=	static-shell
-
-SESSION_CONFIGURE_ENABLE=	session
-
-UNKNOWN_SQL_CPPFLAGS=	-DSQLITE_ENABLE_UNKNOWN_SQL_FUNCTION=1
-
+MEMMAN_CPPFLAGS=	-DSQLITE_ENABLE_MEMORY_MANAGEMENT=1
+METADATA_CPPFLAGS=	-DSQLITE_ENABLE_COLUMN_METADATA=1
+NORMALIZE_CPPFLAGS=	-DSQLITE_ENABLE_NORMALIZE=1
 NULL_TRIM_CPPFLAGS=	-DSQLITE_ENABLE_NULL_TRIM=1
-
 OFFSET_CPPFLAGS=	-DSQLITE_ENABLE_OFFSET_SQL_FUNC=1
-
+RBU_CPPFLAGS=	-DSQLITE_ENABLE_RBU=1
+READLINE_USES=	readline
+READLINE_CONFIGURE_ENABLE=	readline
+RTREE_CONFIGURE_ENABLE=	rtree
+RTREE_INT_CPPFLAGS=	-DSQLITE_RTREE_INT_ONLY=1
+SECURE_DELETE_CPPFLAGS=	-DSQLITE_SECURE_DELETE=1
 SER1_CPPFLAGS=	-DSQLITE_ENABLE_DESERIALIZE=1
-
+SESSION_CONFIGURE_ENABLE=	session
 SORT_REF_CPPFLAGS=	-DSQLITE_ENABLE_SORTER_REFERENCES=1
-
-NORMALIZE_CPPFLAGS=	-DSQLITE_ENABLE_NORMALIZE=1
-
-DQS_CPPFLAGS=	-DSQLITE_DQS=3
-DQS_CPPFLAGS_OFF=	-DSQLITE_DQS=0
-
+SOUNDEX_CPPFLAGS=	-DSQLITE_SOUNDEX=1
+STAT3_CPPFLAGS=	-DSQLITE_ENABLE_STAT3=1
+STAT4_CPPFLAGS=	-DSQLITE_ENABLE_STAT4=1
+STATIC_CONFIGURE_ENABLE=	static
+STMT_CPPFLAGS=	-DSQLITE_ENABLE_STMT_SCANSTATUS=1
+TCL_USES=	tcl
+TCL_USES_OFF=	tcl:build
 TCL_CONFIGURE_ENABLE=	tcl
-TCL_ALL_TARGET=		sqlite3_analyzer
-TCL_USES=		tcl
-TCL_USES_OFF=		tcl:build
+TCL_ALL_TARGET+=	sqlite3_analyzer
+THREADS_CONFIGURE_ENABLE=	threadsafe
+THREADS_LIBS=	-lpthread
+TRUSTED_SCHEMA_CPPFLAGS=	-DSQLITE_TRUSTED_SCHEMA=0
+TS0_CONFIGURE_ON=	--enable-tempstore=never
+TS1_CONFIGURE_ON=	--enable-tempstore=no
+TS2_CONFIGURE_ON=	--enable-tempstore=yes
+TS3_CONFIGURE_ON=	--enable-tempstore=always
+UNICODE61_CPPFLAGS_OFF=	-DSQLITE_DISABLE_FTS3_UNICODE=1
+UNKNOWN_SQL_CPPFLAGS=	-DSQLITE_ENABLE_UNKNOWN_SQL_FUNCTION=1
+UNLOCK_NOTIFY_CPPFLAGS=	-DSQLITE_ENABLE_UNLOCK_NOTIFY=1
+UPDATE_LIMIT_CONFIGURE_ENABLE=	update-limit
+URI_CPPFLAGS=	-DSQLITE_USE_URI=1
+URI_AUTHORITY_CPPFLAGS=	-DSQLITE_ALLOW_URI_AUTHORITY=1
 
 .include <bsd.port.options.mk>
 
@@ -239,43 +170,43 @@ TCL_USES_OFF=		tcl:build
 CPPFLAGS+=	-DHAVE_ISNAN=1 -DHAVE_MALLOC_USABLE_SIZE=1 -DHAVE_GMTIME_R=1 -DHAVE_LOCALTIME_R=1 -DHAVE_USLEEP=1 -DHAVE_STRCHRNUL=1
 CFLAGS_powerpc64le=	-DSQLITE_BYTEORDER=1234
 
+# For compare with checksum from of the site. Now, this is a NIST SHA3-256 hash. sha256 not suitable for compare.
+# But the creation of a new target does not justify the emergence of dependence on the perl5.
+# sha3sum maybe installed with p5-Digest-SHA3 port.
+# EXTRACT_DEPENDS=p5-Digest-SHA3:security/p5-Digest-SHA3; USES=perl5; USE_PERL5=extract;
+# @${PERL} -MDigest::SHA3 -le 'print Digest::SHA3->new(sha_256_hex)->add(<>)->hexdigest' < ${DISTDIR}/${ALLFILES}
+pre-extract:
+	@${WHICH} sha3sum > /dev/null && ${ECHO_MSG} -n "=> " && sha3sum -a 256 --tag ${DISTDIR}/${ALLFILES} || ${TRUE}
+
 post-configure:
 	@${ECHO_MSG} "===> CONFIGURE_ARGS=${CONFIGURE_ARGS}"
-	@${ECHO_MSG} "===> CPPFLAGS=${CPPFLAGS}"
 	@${ECHO_MSG} "===> CFLAGS=${CFLAGS}"
+	@${ECHO_MSG} "===> CPPFLAGS=${CPPFLAGS}"
 	@${ECHO_MSG} "===> LDFLAGS=${LDFLAGS}"
 	@${ECHO_MSG} "===> LIBS=${LIBS}"
 
-post-build:
-.if ${ARCH}=="i386"
-	@${ECHO_MSG} "===> WARNING: on ${ARCH} don't pass atof1-* tests"
-.endif
-
-post-stage:
-	${SETENV} LD_LIBMAP_DISABLE=1 ldd -a "${STAGEDIR}${PREFIX}/bin/${PORTNAME}"
-
 post-install:
 	${INSTALL_MAN} ${WRKSRC}/sqlite3.1 ${STAGEDIR}${PREFIX}/man/man1
 	${RM} ${STAGEDIR}${PREFIX}/include/msvc.h
 	${SETENV} LD_LIBMAP_DISABLE=1 ldd -a "${STAGEDIR}${PREFIX}/bin/${PORTNAME}" "${STAGEDIR}${PREFIX}/lib/lib${PORTNAME}.so"
 
+post-install-STRIP-on:
+	${STRIP_CMD} "${STAGEDIR}${PREFIX}/bin/${PORTNAME}" "${STAGEDIR}${PREFIX}/lib/lib${PORTNAME}.so"
+.if ${PORT_OPTIONS:MTCL}
+	${STRIP_CMD} "${STAGEDIR}${PREFIX}/lib/tcl${TCL_VER}/${PORTNAME}/libtcl${PORTNAME}.so"
+.endif
+
 post-install-TCL-on:
 	${INSTALL_PROGRAM} ${WRKSRC}/sqlite3_analyzer ${STAGEDIR}${PREFIX}/bin
-
-# for compares with checksum from of the site
-sha1: checksum
-.if defined(SHA1) && !empty(SHA1)
-	@sha1 -c ${SHA1} ${DISTDIR}/${ALLFILES}
-.else
-	@sha1 ${DISTDIR}/${ALLFILES}
+	${INSTALL_MAN} ${WRKSRC}/autoconf/tea/doc/${PORTNAME}.n ${STAGEDIR}${PREFIX}/man/mann/${PORTNAME}.tcl${TCL_VER:S/.//g}.n
+.if ${PORT_OPTIONS:MEXAMPLES}
+	${INSTALL_SCRIPT} -d ${STAGEDIR}${EXAMPLESDIR}
+	${INSTALL_SCRIPT} ${WRKDIR}/${SUB_FILES} ${WRKSRC}/contrib/sqlitecon.tcl ${STAGEDIR}${EXAMPLESDIR}
 .endif
 
-# For compare with checksum from of the site. Now, this is a NIST SHA3-256 hash. sha256 not suitable for compare.
-# But the creation of a new target does not justify the emergence of dependence on the perl5.
-# sha3sum maybe installed with p5-Digest-SHA3 port.
-# EXTRACT_DEPENDS=p5-Digest-SHA3:security/p5-Digest-SHA3; USES=perl5; USE_PERL5=extract;
-# @${PERL} -MDigest::SHA3 -le 'print Digest::SHA3->new(sha_256_hex)->add(<>)->hexdigest' < ${DISTDIR}/${ALLFILES}
-sha3: checksum
-	@sha3sum -a 256 ${DISTDIR}/${ALLFILES}
+pre-test:
+.if ! ${PORT_OPTIONS:MTCL}
+	@${ECHO_MSG} "===>  Option TCL must be On for test purposes" && ${FALSE}
+.endif
 
 .include <bsd.port.mk>
diff --git a/databases/sqlite3/distinfo b/databases/sqlite3/distinfo
index 66638235612a..a55e95d86cff 100644
--- a/databases/sqlite3/distinfo
+++ b/databases/sqlite3/distinfo
@@ -1,3 +1,3 @@
-TIMESTAMP = 1613478280
-SHA256 (sqlite-src-3340100.zip) = dddd237996b096dee8b37146c7a37a626a80306d6695103d2ec16ee3b852ff49
-SIZE (sqlite-src-3340100.zip) = 12623711
+TIMESTAMP = 1619268670
+SHA256 (sqlite-src-3350500.zip) = f4beeca5595c33ab5031a920d9c9fd65fe693bad2b16320c3a6a6950e66d3b11
+SIZE (sqlite-src-3350500.zip) = 12819198
diff --git a/databases/sqlite3/files/example.tcl.in b/databases/sqlite3/files/example.tcl.in
new file mode 100644
index 000000000000..0f8aab96e1f1
--- /dev/null
+++ b/databases/sqlite3/files/example.tcl.in
@@ -0,0 +1,16 @@
+#!%%TCLSH_CMD%%
+
+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/sqlite3/files/patch-Makefile.in b/databases/sqlite3/files/patch-Makefile.in
new file mode 100644
index 000000000000..1e048f7ce669
--- /dev/null
+++ b/databases/sqlite3/files/patch-Makefile.in
@@ -0,0 +1,11 @@
+--- Makefile.in.orig	2021-04-11 09:08:25 UTC
++++ Makefile.in
+@@ -1274,7 +1274,7 @@ valgrindfuzz:	fuzzcheck$(TEXT) $(FUZZDATA) sessionfuzz
+ # The veryquick.test TCL tests.
+ #
+ tcltest:	./testfixture$(TEXE)
+-	./testfixture$(TEXE) $(TOP)/test/veryquick.test $(TESTOPTS)
++	mkdir $(TOP)/testdir && touch $(TOP) test-out.txt && chown nobody $(TOP)/testdir $(TOP) test-out.txt && su -m nobody -c "./testfixture$(TEXE) $(TOP)/test/veryquick.test $(TESTOPTS)"
+ 
+ # Minimal testing that runs in less than 3 minutes
+ #
diff --git a/databases/sqlite3/pkg-plist b/databases/sqlite3/pkg-plist
index 82438018ddb6..28f9704cc12f 100644
--- a/databases/sqlite3/pkg-plist
+++ b/databases/sqlite3/pkg-plist
@@ -2,11 +2,14 @@ bin/sqlite3
 %%TCL%%bin/sqlite3_analyzer
 include/sqlite3.h
 include/sqlite3ext.h
-lib/libsqlite3.a
+%%STATIC%%lib/libsqlite3.a
 lib/libsqlite3.so
 lib/libsqlite3.so.0
 lib/libsqlite3.so.0.8.6
 libdata/pkgconfig/sqlite3.pc
 man/man1/sqlite3.1.gz
-%%TCL%%lib/tcl%%TCL_VER%%/sqlite3/libtclsqlite3.so
-%%TCL%%lib/tcl%%TCL_VER%%/sqlite3/pkgIndex.tcl
+%%TCL%%man/mann/sqlite3.%%TCLSUF%%.n.gz
+%%TCL%%lib/%%TCLVER%%/sqlite3/libtclsqlite3.so
+%%TCL%%lib/%%TCLVER%%/sqlite3/pkgIndex.tcl
+%%TCL%%%%EXAMPLES%%share/examples/sqlite3/example.tcl
+%%TCL%%%%EXAMPLES%%share/examples/sqlite3/sqlitecon.tcl



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?202104271703.13RH3k1c052058>