Attachment #212495 for bug #243602




# $FreeBSD$

PORTNAME=	sqlite3
DISTVERSION=	3.31.1
PORTREVISION=	1
PORTEPOCH=	1
CATEGORIES=	databases
MASTER_SITES=	https://www.sqlite.org/2020/ http://www2.sqlite.org/2020/ http://www3.sqlite.org/2020/
DISTNAME=	sqlite-autoconf-${PORTVERSION:C/\.([[:digit:]])[[:>:]]/0\1/g:S/.//g}00

MAINTAINER=	pavelivolkov@gmail.com

			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
OPTIONS_SINGLE=		RAMT
OPTIONS_RADIO=		STAT
OPTIONS_GROUP=		OPT_EXT OPT_FUNC UNICODE RTREEG RL

# 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


OPTIONS_DEFAULT=	FTS4 URI METADATA SECURE_DELETE UNLOCK_NOTIFY THREADS \
			EXTENSION TS1 UNICODE61 RTREE DBSTAT STSHELL READLINES \
			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

PLIST_FILES=	bin/sqlite3 include/sqlite3.h include/sqlite3ext.h \
		lib/libsqlite3.a lib/libsqlite3.so lib/libsqlite3.so.0 \


THREADS_CONFIGURE_ENABLE=	threadsafe
THREADS_LIBS=		-lpthread

TRUSTED_SCHEMA_CPPFLAGS=	-DSQLITE_TRUSTED_SCHEMA=0

ICU_BUILD_DEPENDS=	${LOCALBASE}/bin/icu-config:devel/icu
ICU_LIB_DEPENDS=	libicudata.so:devel/icu

Lines 1-3 Link Here

(-)databases/sqlite3/distinfo (-3 / +3 lines)
1	TIMESTAMP = 1570883162	1	TIMESTAMP = 1584431277
2	SHA256 (sqlite-autoconf-3300100.tar.gz) = 8c5a50db089bd2a1b08dbc5b00d2027602ca7ff238ba7658fabca454d4298e60	2	SHA256 (sqlite-autoconf-3310100.tar.gz) = 62284efebc05a76f909c580ffa5c008a7d22a1287285d68b7825a2b6b51949ae
3	SIZE (sqlite-autoconf-3300100.tar.gz) = 2848951	3	SIZE (sqlite-autoconf-3310100.tar.gz) = 2887243

Return to bug 243602

Lines 2-12 Link Here

(-)databases/sqlite3/Makefile (-5 / +10 lines)
2	# $FreeBSD$	2	# $FreeBSD$
3		3
4	PORTNAME= sqlite3	4	PORTNAME= sqlite3
5	DISTVERSION= 3.30.1	5	DISTVERSION= 3.31.1
6	PORTREVISION= 1
7	PORTEPOCH= 1	6	PORTEPOCH= 1
8	CATEGORIES= databases	7	CATEGORIES= databases
9	MASTER_SITES= https://www.sqlite.org/2019/ http://www2.sqlite.org/2019/ http://www3.sqlite.org/2019/	8	MASTER_SITES= https://www.sqlite.org/2020/ http://www2.sqlite.org/2020/ http://www3.sqlite.org/2020/
10	DISTNAME= sqlite-autoconf-${PORTVERSION:C/\.([[:digit:]])[[:>:]]/0\1/g:S/.//g}00	9	DISTNAME= sqlite-autoconf-${PORTVERSION:C/\.([[:digit:]])[[:>:]]/0\1/g:S/.//g}00
11		10
12	MAINTAINER= pavelivolkov@gmail.com	11	MAINTAINER= pavelivolkov@gmail.com
Lines 26-32 Link Here
26	DIRECT_READ MEMMAN SECURE_DELETE UNLOCK_NOTIFY THREADS \	25	DIRECT_READ MEMMAN SECURE_DELETE UNLOCK_NOTIFY THREADS \
27	EXTENSION ARMOR STMT DBPAGE DBSTAT FTS5 RBU NULL_TRIM \	26	EXTENSION ARMOR STMT DBPAGE DBSTAT FTS5 RBU NULL_TRIM \
28	LIKENOTBLOB STSHELL FTS3_TOKEN UNKNOWN_SQL SORT_REF \	27	LIKENOTBLOB STSHELL FTS3_TOKEN UNKNOWN_SQL SORT_REF \
29	NORMALIZE DQS	28	NORMALIZE DQS TRUSTED_SCHEMA
30	OPTIONS_SINGLE= RAMT	29	OPTIONS_SINGLE= RAMT
31	OPTIONS_RADIO= STAT	30	OPTIONS_RADIO= STAT
32	OPTIONS_GROUP= OPT_EXT OPT_FUNC UNICODE RTREEG RL	31	OPTIONS_GROUP= OPT_EXT OPT_FUNC UNICODE RTREEG RL
Lines 95-100 Link Here
95	# https://www.sqlite.org/compile.html#enable_sorter_references	94	# https://www.sqlite.org/compile.html#enable_sorter_references
96	SORT_REF_DESC= To use references in the sorter	95	SORT_REF_DESC= To use references in the sorter
97		96
		97	# https://www.sqlite.org/compile.html#trusted_schema
		98	TRUSTED_SCHEMA_DESC= SQL functions & virtual tables are considered unsafe
		99
98	# https://www.sqlite.org/tempfiles.html#tempstore	100	# https://www.sqlite.org/tempfiles.html#tempstore
99	OPTIONS_SINGLE_RAMT= TS0 TS1 TS2 TS3	101	OPTIONS_SINGLE_RAMT= TS0 TS1 TS2 TS3
100	RAMT_DESC= Where to store temporary file	102	RAMT_DESC= Where to store temporary file
Lines 140-150 Link Here
140		142
141	OPTIONS_DEFAULT= FTS4 URI METADATA SECURE_DELETE UNLOCK_NOTIFY THREADS \	143	OPTIONS_DEFAULT= FTS4 URI METADATA SECURE_DELETE UNLOCK_NOTIFY THREADS \
142	EXTENSION TS1 UNICODE61 RTREE DBSTAT STSHELL READLINES \	144	EXTENSION TS1 UNICODE61 RTREE DBSTAT STSHELL READLINES \
143	FTS3_TOKEN FTS5 DQS	145	FTS3_TOKEN FTS5 DQS JSON1
144	# SECURE_DELETE, UNLOCK_NOTIFY, DBSTAT (since 41.0) used by www/firefox et al.	146	# SECURE_DELETE, UNLOCK_NOTIFY, DBSTAT (since 41.0) used by www/firefox et al.
145	# RTREE used by graphics/mapnik, databases/spatialite	147	# RTREE used by graphics/mapnik, databases/spatialite
146	# FTS3_TOKEN used by audio/clementine-player, mail/thunderbird, www/seamonkey	148	# FTS3_TOKEN used by audio/clementine-player, mail/thunderbird, www/seamonkey
147	# FTS5 used by sysutils/tracker	149	# FTS5 used by sysutils/tracker
		150	# JSON1 used by net-im/py-matrix-synapse
148		151
149	PLIST_FILES= bin/sqlite3 include/sqlite3.h include/sqlite3ext.h \	152	PLIST_FILES= bin/sqlite3 include/sqlite3.h include/sqlite3ext.h \
150	lib/libsqlite3.a lib/libsqlite3.so lib/libsqlite3.so.0 \	153	lib/libsqlite3.a lib/libsqlite3.so lib/libsqlite3.so.0 \
Lines 192-197 Link Here
192		195
193	THREADS_CONFIGURE_ENABLE= threadsafe	196	THREADS_CONFIGURE_ENABLE= threadsafe
194	THREADS_LIBS= -lpthread	197	THREADS_LIBS= -lpthread
		198
		199	TRUSTED_SCHEMA_CPPFLAGS= -DSQLITE_TRUSTED_SCHEMA=0
195		200
196	ICU_BUILD_DEPENDS= ${LOCALBASE}/bin/icu-config:devel/icu	201	ICU_BUILD_DEPENDS= ${LOCALBASE}/bin/icu-config:devel/icu
197	ICU_LIB_DEPENDS= libicudata.so:devel/icu	202	ICU_LIB_DEPENDS= libicudata.so:devel/icu