Attachment #222490 for bug #221735

View | Details | Raw Unified | Return to bug 221735
Collapse All | Expand All




PORTEPOCH=	1
CATEGORIES=	databases
MASTER_SITES=	https://www.sqlite.org/2021/ https://www2.sqlite.org/2021/ https://www3.sqlite.org/2021/
DISTNAME=	sqlite-src-${PORTVERSION:C/\.([[:digit:]])[[:>:]]/0\1/g:S/.//g}00

MAINTAINER=	pavelivolkov@gmail.com
COMMENT=	SQL database engine in a C library


LICENSE=	PD

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}"

# 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

OPTIONS_GROUP_OPT_EXT=	JSON1 SESSION
OPTIONS_GROUP_OPT_FUNC=	OFFSET SER1 SOUNDEX

EXTENSION_DESC=		Allow loadable extensions
STSHELL_DESC=		Statically link libsqlite3 into shell
NORMALIZE_DESC=		Enable normalized sql function
TCL_DESC=		Enable tcl extension and sqlite_analyzer

# https://www.sqlite.org/compile.html#dqs
DQS_DESC=		Double-quoted String Literals

# 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 \
		lib/libsqlite3.so.0.8.6 libdata/pkgconfig/sqlite3.pc \
		man/man1/sqlite3.1.gz

# 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.

DQS_CPPFLAGS=	-DSQLITE_DQS=3
DQS_CPPFLAGS_OFF=	-DSQLITE_DQS=0

TCL_CONFIGURE_ENABLE=	tcl
TCL_ALL_TARGET=		sqlite3_analyzer
TCL_USES=		tcl
TCL_USES_OFF=		tcl:build

.include <bsd.port.options.mk>

# Platform Configuration

	${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-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)

Lines 1-3 Link Here

(-)distinfo (-3 / +3 lines)
1	TIMESTAMP = 1611464266	1	TIMESTAMP = 1613478280
2	SHA256 (sqlite-autoconf-3340100.tar.gz) = 2a3bca581117b3b88e5361d0ef3803ba6d8da604b1c1a47d902ef785c1b53e89	2	SHA256 (sqlite-src-3340100.zip) = dddd237996b096dee8b37146c7a37a626a80306d6695103d2ec16ee3b852ff49
3	SIZE (sqlite-autoconf-3340100.tar.gz) = 2930089	3	SIZE (sqlite-src-3340100.zip) = 12623711




--- configure.orig	2020-12-11 13:58:21 UTC
+++ configure
@@ -13335,7 +13335,9 @@ else
   enable_threadsafe=yes
 fi
 
-if test x"$enable_threadsafe" != "xno"; then
+if test x"$enable_threadsafe" == "xno"; then
+  BUILD_CFLAGS="$BUILD_CFLAGS -DSQLITE_THREADSAFE=0"
+else
   BUILD_CFLAGS="$BUILD_CFLAGS -D_REENTRANT=1 -DSQLITE_THREADSAFE=1"
   { $as_echo "$as_me:${as_lineno-$LINENO}: checking for library containing pthread_create" >&5
 $as_echo_n "checking for library containing pthread_create... " >&6; }




bin/sqlite3
%%TCL%%bin/sqlite3_analyzer
include/sqlite3.h
include/sqlite3ext.h
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

Return to bug 221735

Lines 6-12 Link Here

(-)Makefile (-9 / +17 lines)
6	PORTEPOCH= 1	6	PORTEPOCH= 1
7	CATEGORIES= databases	7	CATEGORIES= databases
8	MASTER_SITES= https://www.sqlite.org/2021/ https://www2.sqlite.org/2021/ https://www3.sqlite.org/2021/	8	MASTER_SITES= https://www.sqlite.org/2021/ https://www2.sqlite.org/2021/ https://www3.sqlite.org/2021/
9	DISTNAME= sqlite-autoconf-${PORTVERSION:C/\.([[:digit:]])[[:>:]]/0\1/g:S/.//g}00	9	DISTNAME= sqlite-src-${PORTVERSION:C/\.([[:digit:]])[[:>:]]/0\1/g:S/.//g}00
10		10
11	MAINTAINER= pavelivolkov@gmail.com	11	MAINTAINER= pavelivolkov@gmail.com
12	COMMENT= SQL database engine in a C library	12	COMMENT= SQL database engine in a C library
Lines 13-24 Link Here
13		13
14	LICENSE= PD	14	LICENSE= PD
15		15
16	USES= libtool pathfix	16	USES= libtool pathfix zip
17	USE_LDCONFIG= yes	17	USE_LDCONFIG= yes
18		18
19	GNU_CONFIGURE= yes	19	GNU_CONFIGURE= yes
20	MAKE_JOBS_UNSAFE= yes	20	MAKE_JOBS_UNSAFE= yes
21	INSTALL_TARGET= install-strip	21	ALL_TARGET= all
		22	CONFIGURE_ENV= TCLSH_CMD="${TCLSH}"
		23	PLIST_SUB= TCL_VER="${TCL_VER}"
22		24
23	# Compilation Options For SQLite https://www.sqlite.org/compile.html	25	# Compilation Options For SQLite https://www.sqlite.org/compile.html
24	OPTIONS_DEFINE= FTS4 URI URI_AUTHORITY METADATA \	26	OPTIONS_DEFINE= FTS4 URI URI_AUTHORITY METADATA \
Lines 25-34 Link Here
25	DIRECT_READ MEMMAN SECURE_DELETE UNLOCK_NOTIFY THREADS \	27	DIRECT_READ MEMMAN SECURE_DELETE UNLOCK_NOTIFY THREADS \
26	EXTENSION ARMOR STMT DBPAGE DBSTAT FTS5 RBU NULL_TRIM \	28	EXTENSION ARMOR STMT DBPAGE DBSTAT FTS5 RBU NULL_TRIM \
27	LIKENOTBLOB STSHELL FTS3_TOKEN UNKNOWN_SQL SORT_REF \	29	LIKENOTBLOB STSHELL FTS3_TOKEN UNKNOWN_SQL SORT_REF \
28	NORMALIZE DQS TRUSTED_SCHEMA	30	NORMALIZE DQS TRUSTED_SCHEMA TCL
29	OPTIONS_SINGLE= RAMT	31	OPTIONS_SINGLE= RAMT
30	OPTIONS_RADIO= STAT RL	32	OPTIONS_RADIO= STAT RL
31	OPTIONS_GROUP= OPT_EXT OPT_FUNC UNICODE RTREEG	33	OPTIONS_GROUP= OPT_EXT OPT_FUNC UNICODE RTREEG
		34	OPTIONS_SUB= yes
32		35
33	OPTIONS_GROUP_OPT_EXT= JSON1 SESSION	36	OPTIONS_GROUP_OPT_EXT= JSON1 SESSION
34	OPTIONS_GROUP_OPT_FUNC= OFFSET SER1 SOUNDEX	37	OPTIONS_GROUP_OPT_FUNC= OFFSET SER1 SOUNDEX
Lines 46-51 Link Here
46	EXTENSION_DESC= Allow loadable extensions	49	EXTENSION_DESC= Allow loadable extensions
47	STSHELL_DESC= Statically link libsqlite3 into shell	50	STSHELL_DESC= Statically link libsqlite3 into shell
48	NORMALIZE_DESC= Enable normalized sql function	51	NORMALIZE_DESC= Enable normalized sql function
		52	TCL_DESC= Enable tcl extension and sqlite_analyzer
49		53
50	# https://www.sqlite.org/compile.html#dqs	54	# https://www.sqlite.org/compile.html#dqs
51	DQS_DESC= Double-quoted String Literals	55	DQS_DESC= Double-quoted String Literals
Lines 143-153 Link Here
143	# FTS5 used by sysutils/tracker	147	# FTS5 used by sysutils/tracker
144	# JSON1 used by net-im/py-matrix-synapse	148	# JSON1 used by net-im/py-matrix-synapse
145		149
146	PLIST_FILES= bin/sqlite3 include/sqlite3.h include/sqlite3ext.h \
147	lib/libsqlite3.a lib/libsqlite3.so lib/libsqlite3.so.0 \
148	lib/libsqlite3.so.0.8.6 libdata/pkgconfig/sqlite3.pc \
149	man/man1/sqlite3.1.gz
150
151	# The default numeric file permissions for newly created database files under unix.	150	# The default numeric file permissions for newly created database files under unix.
152	# If not specified, the default is 0644 which means that the files is globally	151	# If not specified, the default is 0644 which means that the files is globally
153	# readable but only writable by the creator.	152	# readable but only writable by the creator.
Lines 230-235 Link Here
230	DQS_CPPFLAGS= -DSQLITE_DQS=3	229	DQS_CPPFLAGS= -DSQLITE_DQS=3
231	DQS_CPPFLAGS_OFF= -DSQLITE_DQS=0	230	DQS_CPPFLAGS_OFF= -DSQLITE_DQS=0
232		231
		232	TCL_CONFIGURE_ENABLE= tcl
		233	TCL_ALL_TARGET= sqlite3_analyzer
		234	TCL_USES= tcl
		235	TCL_USES_OFF= tcl:build
		236
233	.include <bsd.port.options.mk>	237	.include <bsd.port.options.mk>
234		238
235	# Platform Configuration	239	# Platform Configuration
Lines 252-260 Link Here
252	${SETENV} LD_LIBMAP_DISABLE=1 ldd -a "${STAGEDIR}${PREFIX}/bin/${PORTNAME}"	256	${SETENV} LD_LIBMAP_DISABLE=1 ldd -a "${STAGEDIR}${PREFIX}/bin/${PORTNAME}"
253		257
254	post-install:	258	post-install:
		259	${INSTALL_MAN} ${WRKSRC}/sqlite3.1 ${STAGEDIR}${PREFIX}/man/man1
255	${RM} ${STAGEDIR}${PREFIX}/include/msvc.h	260	${RM} ${STAGEDIR}${PREFIX}/include/msvc.h
256	${SETENV} LD_LIBMAP_DISABLE=1 ldd -a "${STAGEDIR}${PREFIX}/bin/${PORTNAME}" "${STAGEDIR}${PREFIX}/lib/lib${PORTNAME}.so"	261	${SETENV} LD_LIBMAP_DISABLE=1 ldd -a "${STAGEDIR}${PREFIX}/bin/${PORTNAME}" "${STAGEDIR}${PREFIX}/lib/lib${PORTNAME}.so"
257		262
		263	post-install-TCL-on:
		264	${INSTALL_PROGRAM} ${WRKSRC}/sqlite3_analyzer ${STAGEDIR}${PREFIX}/bin
		265
258	# for compares with checksum from of the site	266	# for compares with checksum from of the site
259	sha1: checksum	267	sha1: checksum
260	.if defined(SHA1) && !empty(SHA1)	268	.if defined(SHA1) && !empty(SHA1)

Lines 1-13 Link Here

(-)files/patch-configure (-13 lines)
1	--- configure.orig 2020-12-11 13:58:21 UTC
2	+++ configure
3	@@ -13335,7 +13335,9 @@ else
4	enable_threadsafe=yes
5	fi
6
7	-if test x"$enable_threadsafe" != "xno"; then
8	+if test x"$enable_threadsafe" == "xno"; then
9	+ BUILD_CFLAGS="$BUILD_CFLAGS -DSQLITE_THREADSAFE=0"
10	+else
11	BUILD_CFLAGS="$BUILD_CFLAGS -D_REENTRANT=1 -DSQLITE_THREADSAFE=1"
12	{ $as_echo "$as_me:${as_lineno-$LINENO}: checking for library containing pthread_create" >&5
13	$as_echo_n "checking for library containing pthread_create... " >&6; }

Line 0 Link Here

(-)pkg-plist (+12 lines)
	1	bin/sqlite3
	2	%%TCL%%bin/sqlite3_analyzer
	3	include/sqlite3.h
	4	include/sqlite3ext.h
	5	lib/libsqlite3.a
	6	lib/libsqlite3.so
	7	lib/libsqlite3.so.0
	8	lib/libsqlite3.so.0.8.6
	9	libdata/pkgconfig/sqlite3.pc
	10	man/man1/sqlite3.1.gz
	11	%%TCL%%lib/tcl%%TCL_VER%%/sqlite3/libtclsqlite3.so
	12	%%TCL%%lib/tcl%%TCL_VER%%/sqlite3/pkgIndex.tcl