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)

1 files changed, 144 insertions, 213 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>