diff -urNd databases/sqlite-src.orig/Makefile databases/sqlite-src/Makefile --- databases/sqlite-src.orig/Makefile 1970-01-01 00:00:00.000000000 +0000 +++ databases/sqlite-src/Makefile 2017-12-16 12:48:45.983892000 +0000 @@ -0,0 +1,412 @@ +# $FreeBSD$ + +PORTNAME= sqlite +PORTVERSION= 3.21.0 +CATEGORIES= databases +MASTER_SITES= https://www.sqlite.org/2017/ http://www2.sqlite.org/2017/ http://www3.sqlite.org/2017/ +DISTNAME= ${PORTNAME}-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= autoreconf libtool ncurses pathfix zip +GNU_CONFIGURE= yes +USE_LDCONFIG= yes + +CONFLICTS= sqlite3-[0-9]* + +# A directories and files has requires write permission on a target: test. +TEST_PERMISSION_CHANGED= . tsrc .target_source sqlite3.c shell.c sqlite3ext.h sqlite3session.h .libs/sqlite3.o + +# Length | | Length | + +OPTIONS_SUB= yes +OPTIONS_DEFAULT= # Clean default options + +# ===> OPTIONS_DEFINE +#OPTIONS_DEFINE= # portlint, for what? + +# https://www.sqlite.org/compile.html#enable_api_armor +OPTIONS_DEFINE= ARMOR +ARMOR_DESC= Detect misuse of the API +ARMOR_CPPFLAGS= -DSQLITE_ENABLE_API_ARMOR=1 + +# https://sqlite.org/compile.html#enable_dbpage_vtab +OPTIONS_DEFINE+= DBPAGE +DBPAGE_DESC= Enable DBPAGE Virtual Table +DBPAGE_CPPFLAGS= -DSQLITE_ENABLE_DBPAGE_VTAB=1 + +# https://www.sqlite.org/dbstat.html +OPTIONS_DEFINE+= DBSTAT +OPTIONS_DEFAULT+= DBSTAT # (since 41.0) used by www/firefox et al. +DBSTAT_DESC= Enable DBSTAT Virtual Table +DBSTAT_CPPFLAGS= -DSQLITE_ENABLE_DBSTAT_VTAB=1 + +# https://www.sqlite.org/compile.html#direct_overflow_read +OPTIONS_DEFINE+= DIRECT_READ +DIRECT_READ_DESC= File is read directly from disk +DIRECT_READ_CPPFLAGS= -DSQLITE_DIRECT_OVERFLOW_READ=1 + +# https://www.sqlite.org/loadext.html +OPTIONS_DEFINE+= EXTENSION +OPTIONS_DEFAULT+= EXTENSION # It's SQLite default +EXTENSION_DESC= Allow loadable external extensions +EXTENSION_CONFIGURE_OFF= --disable-load-extension + +# https://www.sqlite.org/json1.html +OPTIONS_DEFINE+= JSON1 +JSON1_DESC= Enable the JSON1 extension +JSON1_CONFIGURE_ON= --enable-json1 + +# https://sqlite.org/compile.html#like_doesnt_match_blobs +OPTIONS_DEFINE+= LIKENOTBLOB +OPTIONS_DEFAULT+= LIKENOTBLOB # my choice +LIKENOTBLOB_DESC= LIKE does not match blobs +LIKENOTBLOB_CPPFLAGS= -DSQLITE_LIKE_DOESNT_MATCH_BLOBS=1 + +# https://sqlite.org/compile.html#enable_memory_management +OPTIONS_DEFINE+= MEMMAN +MEMMAN_DESC= Allows it to release unused memory +MEMMAN_CPPFLAGS= -DSQLITE_ENABLE_MEMORY_MANAGEMENT=1 + +# https://www.sqlite.org/compile.html#enable_column_metadata +OPTIONS_DEFINE+= METADATA +OPTIONS_DEFAULT+= METADATA # my choice +METADATA_DESC= Enable column metadata +METADATA_CPPFLAGS= -DSQLITE_ENABLE_COLUMN_METADATA=1 + +# https://www.sqlite.org/compile.html#enable_null_trim +OPTIONS_DEFINE+= NULL_TRIM +NULL_TRIM_DESC= Omits NULL columns at the ends of rows +NULL_TRIM_CPPFLAGS= -DSQLITE_ENABLE_NULL_TRIM=1 + +# https://www.sqlite.org/compile.html#secure_delete +OPTIONS_DEFINE+= SECURE_DELETE +OPTIONS_DEFAULT+= SECURE_DELETE # (since 41.0) used by www/firefox et al. +SECURE_DELETE_DESC= Overwrite deleted information with zeros +SECURE_DELETE_CPPFLAGS= -DSQLITE_SECURE_DELETE=1 + +# https://www.sqlite.org/lang_corefunc.html#soundex +OPTIONS_DEFINE+= SOUNDEX +SOUNDEX_DESC= Enables the soundex() SQL function +SOUNDEX_CPPFLAGS= -DSQLITE_SOUNDEX=1 + +# https://www.sqlite.org/compile.html#enable_stmt_scanstatus +OPTIONS_DEFINE+= STMT +STMT_DESC= Prepared Statement Scan Status +STMT_CPPFLAGS= -DSQLITE_ENABLE_STMT_SCANSTATUS=1 + +# https://www.sqlite.org/tclsqlite.html +OPTIONS_DEFINE+= TCL_EXT +OPTIONS_DEFAULT+= TCL_EXT # It's SQLite default +TCL_EXT_DESC= Do build and install TCL extension +TCL_EXT_USES= tcl:,tea +TCL_EXT_USES_OFF= tcl:,build +TCL_EXT_CONFIGURE_OFF= --disable-tcl +PLIST_SUB+= TCL_VER=${TCL_VER} + +# https://www.sqlite.org/compile.html#threadsafe +OPTIONS_DEFINE+= THREADS +OPTIONS_DEFAULT+= THREADS # It's SQLite default +THREADS_CONFIGURE_OFF= --disable-threadsafe + +# http://sqlite.org/compile.html#enable_unknown_sql_function +OPTIONS_DEFINE+= UNKNOWN_SQL +UNKNOWN_SQL_DESC= Suppress unknown function errors in EXPLAIN +UNKNOWN_SQL_CPPFLAGS= -DSQLITE_ENABLE_UNKNOWN_SQL_FUNCTION=1 + +# https://www.sqlite.org/unlock_notify.html +OPTIONS_DEFINE+= UNLOCK_NOTIFY +OPTIONS_DEFAULT+= UNLOCK_NOTIFY # (since 41.0) used by www/firefox et al. +UNLOCK_NOTIFY_DESC= Enable notification on unlocking +UNLOCK_NOTIFY_CPPFLAGS= -DSQLITE_ENABLE_UNLOCK_NOTIFY=1 + +# https://sqlite.org/compile.html#enable_update_delete_limit +OPTIONS_DEFINE+= UPD_DEL_LIMIT +UPD_DEL_LIMIT_DESC= ORDER BY and LIMIT on UPDATE and DELETE +UPD_DEL_LIMIT_CPPFLAGS= -DSQLITE_ENABLE_UPDATE_DELETE_LIMIT=1 + +# ===> OPTIONS_GROUP +OPTIONS_GROUP= + +# ===> I'm collect this as group, amalgamation or external extensions, don't included into other groups. +OPTIONS_GROUP+= EXTG +OPTIONS_DEFAULT+= +EXTG_DESC= Amalgamation or external extensions + +# https://www.sqlite.org/csv.html +OPTIONS_GROUP_EXTG+= CSV +CSV_DESC= Reading CSV file as virtual table +CSV_IMPLIES= EXTENSION + +# https://www.sqlite.org/cli.html#file_i_o_functions +OPTIONS_GROUP_EXTG+= FILEIO +FILEIO_DESC= Presents external file as a BLOB +FILEIO_IMPLIES= EXTENSION + +# https://www.sqlite.org/rbu.html +OPTIONS_GROUP_EXTG+= RBU +RBU_DESC= Enable the Resumable Bulk Update +RBU_CPPFLAGS= -DSQLITE_ENABLE_RBU=1 + +# https://www.sqlite.org/lang_expr.html and search "regexp" +OPTIONS_GROUP_EXTG+= REGEXP +REGEXP_DESC= Added a regexp() function +REGEXP_IMPLIES= EXTENSION + +# https://www.sqlite.org/sessionintro.html +OPTIONS_GROUP_EXTG+= SESSION +SESSION_DESC= Enable the SESSION extension +SESSION_CONFIGURE_ON= --enable-session + +# https://www.sqlite.org/spellfix1.html +OPTIONS_GROUP_EXTG+= SPELLFIX +SPELLFIX_DESC= Used to suggest corrections +SPELLFIX_IMPLIES= EXTENSION + +# https://www.sqlite.org/stmt.html +OPTIONS_GROUP_EXTG+= STMTVTAB +STMTVTAB_DESC= Information about all prepared statements +STMTVTAB_CPPFLAGS= -DSQLITE_ENABLE_STMTVTAB=1 + +# https://www.sqlite.org/unionvtab.html +OPTIONS_GROUP_EXTG+= UNIONVTAB +UNIONVTAB_DESC= UNION virtual table +UNIONVTAB_IMPLIES= EXTENSION + +# ===> end of EXTG + +# https://www.sqlite.org/fts3.html +# https://www.sqlite.org/fts5.html +# https://www.sqlite.org/compile.html#enable_fts3_parenthesis +# https://www.sqlite.org/compile.html#enable_fts3_tokenizer +# https://www.sqlite.org/fts3.html#f3tknzr +OPTIONS_GROUP+= FTS +OPTIONS_GROUP_FTS= FTS3 FTS3_PARENTHESIS FTS3_TOKEN FTS4 FTS5 +OPTIONS_DEFAULT+= FTS4 # used by many ports +OPTIONS_DEFAULT+= FTS3_TOKEN # used by audio/clementine-player +OPTIONS_DEFAULT+= FTS5 # used by sysutils/tracker +FTS_DESC= Full-text search +FTS3_DESC= Enable the FTS3 extension +FTS3_PARENTHESIS_DESC= Modifies the query pattern parser in FTS3 +FTS3_TOKEN_DESC= Enable two-args version fts3_tokenizer +FTS4_DESC= Enable the FTS4 extension +FTS5_DESC= Enable the FTS5 extension +FTS3_CONFIGURE_ON= --enable-fts3 +FTS3_PARENTHESIS_IMPLIES= FTS3 +FTS3_PARENTHESIS_CPPFLAGS= -DSQLITE_ENABLE_FTS3_PARENTHESIS=1 +FTS3_TOKEN_IMPLIES= FTS3 +FTS3_TOKEN_CPPFLAGS= -DSQLITE_ENABLE_FTS3_TOKENIZER=1 +FTS4_CONFIGURE_ON= --enable-fts4 +FTS4_IMPLIES= FTS3 # used by www/firefox and mail/thunderbird +FTS5_CONFIGURE_ON= --enable-fts5 + +# https://www.sqlite.org/rtree.html +# https://www.sqlite.org/compile.html#rtree_int_only +OPTIONS_GROUP+= RTREEG +OPTIONS_GROUP_RTREEG= RTREE RTREE_INT +OPTIONS_DEFAULT+= RTREE # used by graphics/mapnik, databases/spatialite +RTREEG_DESC= Dynamic Index Structure for Spatial Search +RTREE_DESC= Special extension for doing range queries +RTREE_INT_DESC= Store 32-bit sig int (no float) coordinates +RTREE_CONFIGURE_ON= --enable-rtree +RTREE_INT_IMPLIES= RTREE +RTREE_INT_CPPFLAGS= -DSQLITE_RTREE_INT_ONLY=1 + +# https://www.sqlite.org/fts3.html#tokenizer +OPTIONS_GROUP+= UNICODE +OPTIONS_GROUP_UNICODE= ICU UNICODE61 +OPTIONS_DEFAULT+= UNICODE61 # It's SQLite default +UNICODE_DESC= Unicode support +UNICODE61_DESC= Unicode Version 6.1 tokenizer +UNICODE61_CPPFLAGS= "" +UNICODE61_CPPFLAGS_OFF= -DSQLITE_DISABLE_FTS3_UNICODE=1 +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` + +# https://www.sqlite.org/uri.html +# https://www.sqlite.org/compile.html#allow_uri_authority +OPTIONS_GROUP+= URIG +OPTIONS_GROUP_URIG= URI URI_AUTHORITY +OPTIONS_DEFAULT+= URI # my choice +URIG_DESC= Uniform Resource Identifiers +URI_DESC= Allow to treat the filename as a URI +URI_AUTHORITY_DESC= Convert URI into UNC and pass to OS +URI_CPPFLAGS= -DSQLITE_USE_URI=1 +URI_AUTHORITY_CPPFLAGS= -DSQLITE_ALLOW_URI_AUTHORITY=1 + +OPTIONS_GROUP+= UTIL +OPTIONS_GROUP_UTIL= ANALYZER DBHASH SQLDIFF +UTIL_DESC= Additional utilities +# https://www.sqlite.org/sqlanalyze.html +# TCL already used in the build process. +ANALYZER_DESC= Displays how efficiently space is used +ANALYZER_VARS= TEST_PERMISSION_CHANGED+= sqlite3_analyzer.c +# https://www.sqlite.org/dbhash.html +DBHASH_DESC= Hash on the content of the database +# https://www.sqlite.org/sqldiff.html +SQLDIFF_DESC= Differences in content between databases + +# ===> OPTIONS_SINGLE +OPTIONS_SINGLE= + +# https://www.sqlite.org/tempfiles.html#tempstore +OPTIONS_SINGLE+= RAMT +OPTIONS_SINGLE_RAMT= TS0 TS1 TS2 TS3 +OPTIONS_DEFAULT+= TS1 # It's SQLite default +RAMT_DESC= Use in-ram database for temporary tables +TS0_DESC= Never +TS1_DESC= No, may be changed with pragma +TS2_DESC= Yes, may be changed with pragma +TS3_DESC= Always +TS0_CONFIGURE_ON= --enable-tempstore=never +TS1_CONFIGURE_ON= --enable-tempstore=no +TS2_CONFIGURE_ON= --enable-tempstore=yes +TS3_CONFIGURE_ON= --enable-tempstore=always + +# change read line support +OPTIONS_SINGLE+= RL +OPTIONS_SINGLE_RL= OFF_RL LIBEDIT READLINE +OPTIONS_DEFAULT+= READLINE # It's SQLite default +RL_DESC= Library is used to edit the command line +OFF_RL_DESC= Command line without editing +OFF_RL_CONFIGURE_ON= --disable-readline --disable-editline # disable editline/readline support +LIBEDIT_CONFIGURE_ON= --enable-editline # enable BSD editline support +LIBEDIT_USES= libedit +READLINE_USES= readline # enable GNU readline support +READLINE_CONFIGURE_ON= --disable-editline + +# ===> OPTIONS_RADIO +OPTIONS_RADIO= + +# https://www.sqlite.org/compile.html#enable_memsys3 +# https://www.sqlite.org/compile.html#enable_memsys5 +OPTIONS_RADIO+= MEMSYS +OPTIONS_RADIO_MEMSYS= MEMSYS3 MEMSYS5 +MEMSYS_DESC= Alternative memory allocator +MEMSYS3_DESC= Enable MEMSYS3 +MEMSYS5_DESC= Enable MEMSYS5 +MEMSYS3_CONFIGURE_ON= --enable-memsys3 +MEMSYS5_CONFIGURE_ON= --enable-memsys5 + +# https://www.sqlite.org/queryplanner-ng.html#qpstab +OPTIONS_RADIO+= STAT +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 +STAT3_CPPFLAGS= -DSQLITE_ENABLE_STAT3=1 +STAT4_CPPFLAGS= -DSQLITE_ENABLE_STAT4=1 + +# ===> other definition + +# https://www.sqlite.org/compile.html#default_file_permissions +.if defined(DEFAULT_FILE_PERMISSIONS) && !empty(DEFAULT_FILE_PERMISSIONS) +CPPFLAGS+= -DSQLITE_DEFAULT_FILE_PERMISSIONS=${DEFAULT_FILE_PERMISSIONS} +.endif + +# enable debugging & verbose explain +.if defined(WITH_DEBUG) && !defined(WITHOUT_DEBUG) +CONFIGURE_ARGS+= --enable-debug +.endif + +.include + +post-configure: + @${ECHO_MSG} "===> CONFIGURE_ARGS=${CONFIGURE_ARGS}" + @${ECHO_MSG} "===> CPPFLAGS=${CPPFLAGS}" + @${ECHO_MSG} "===> CFLAGS=${CFLAGS}" + @${ECHO_MSG} "===> LDFLAGS=${LDFLAGS}" + @${ECHO_MSG} "===> LIBS=${LIBS}" + +post-build-ANALYZER-on: + cd ${WRKSRC} && ${MAKE} sqlite3_analyzer + +post-build-CSV-on: + ${CC} ${CFLAGS} -I${WRKSRC} -fPIC -DPIC -shared ${WRKSRC}/ext/misc/csv.c -o ${WRKSRC}/csv.so + +post-build-DBHASH-on: + cd ${WRKSRC} && ${MAKE} dbhash + +post-build-FILEIO-on: + ${CC} ${CFLAGS} -I${WRKSRC} -fPIC -DPIC -shared ${WRKSRC}/ext/misc/fileio.c -o ${WRKSRC}/fileio.so + +post-build-REGEXP-on: + ${CC} ${CFLAGS} -I${WRKSRC} -fPIC -DPIC -shared ${WRKSRC}/ext/misc/regexp.c -o ${WRKSRC}/regexp.so + +post-build-SPELLFIX-on: + ${CC} ${CFLAGS} -I${WRKSRC} -fPIC -DPIC -shared ${WRKSRC}/ext/misc/spellfix.c -o ${WRKSRC}/spellfix.so + +post-build-SQLDIFF-on: + cd ${WRKSRC} && ${MAKE} sqldiff + +post-build-UNIONVTAB-on: + ${CC} ${CFLAGS} -I${WRKSRC} -fPIC -DPIC -shared ${WRKSRC}/ext/misc/unionvtab.c -o ${WRKSRC}/unionvtab.so + +post-install: +.if !defined(WITH_DEBUG) || defined(WITHOUT_DEBUG) + @${STRIP_CMD} ${STAGEDIR}${PREFIX}/bin/sqlite3 + @${STRIP_CMD} ${STAGEDIR}${PREFIX}/lib/libsqlite3.so.0.8.6 +.endif + +post-install-TCL_EXT-on: +.if !defined(WITH_DEBUG) || defined(WITHOUT_DEBUG) + @${STRIP_CMD} ${STAGEDIR}${PREFIX}/lib/tcl${TCL_VER}/sqlite3/libtclsqlite3.so +.endif + +post-install-EXTENSION-off: + ${RM} ${STAGEDIR}${PREFIX}/include/sqlite3ext.h + +post-install-ANALYZER-on: + ${INSTALL_PROGRAM} ${WRKSRC}/sqlite3_analyzer ${STAGEDIR}${PREFIX}/bin + +post-install-CSV-on: + ${MKDIR} ${STAGEDIR}${DATADIR} + ${INSTALL_LIB} ${WRKSRC}/csv.so ${STAGEDIR}${DATADIR} + +post-install-DBHASH-on: + ${INSTALL_PROGRAM} ${WRKSRC}/dbhash ${STAGEDIR}${PREFIX}/bin/sqlite3_dbhash + +post-install-FILEIO-on: + ${MKDIR} ${STAGEDIR}${DATADIR} + ${INSTALL_LIB} ${WRKSRC}/fileio.so ${STAGEDIR}${DATADIR} + +post-install-REGEXP-on: + ${MKDIR} ${STAGEDIR}${DATADIR} + ${INSTALL_LIB} ${WRKSRC}/regexp.so ${STAGEDIR}${DATADIR} + +post-install-SPELLFIX-on: + ${MKDIR} ${STAGEDIR}${DATADIR} + ${INSTALL_LIB} ${WRKSRC}/spellfix.so ${STAGEDIR}${DATADIR} + +post-install-SQLDIFF-on: + ${INSTALL_PROGRAM} ${WRKSRC}/sqldiff ${STAGEDIR}${PREFIX}/bin/sqlite3_sqldiff + +post-install-UNIONVTAB-on: + ${MKDIR} ${STAGEDIR}${DATADIR} + ${INSTALL_LIB} ${WRKSRC}/unionvtab.so ${STAGEDIR}${DATADIR} + +# for compares with checksum from of the site +sha1: fetch +.if defined(SHA1) && !empty(SHA1) + @sha1 -c ${SHA1} ${DISTDIR}/${ALLFILES} +.else + @sha1 ${DISTDIR}/${ALLFILES} +.endif + +testfixture: build + cd "${WRKSRC}" && ${MAKE} ${.TARGET} + +test quicktest: build testfixture + [ -d "${WRKSRC}" ] && ( \ + cd "${WRKSRC}" && \ + ${CHMOD} o+w ${TEST_PERMISSION_CHANGED} && \ + su -m nobody -c "limits -n 1000 ${MAKE} ${.TARGET}"; \ + ${CHMOD} o-w ${TEST_PERMISSION_CHANGED} \ + ) + +.include diff -urNd databases/sqlite-src.orig/distinfo databases/sqlite-src/distinfo --- databases/sqlite-src.orig/distinfo 1970-01-01 00:00:00.000000000 +0000 +++ databases/sqlite-src/distinfo 2017-12-16 12:41:11.833584000 +0000 @@ -0,0 +1,3 @@ +TIMESTAMP = 1509189550 +SHA256 (sqlite-src-3210000.zip) = 8681a34e059b30605f611ac85168ca54edbade50c71468b5882f5abbcd66b94e +SIZE (sqlite-src-3210000.zip) = 10577695 diff -urNd databases/sqlite-src.orig/pkg-descr databases/sqlite-src/pkg-descr --- databases/sqlite-src.orig/pkg-descr 1970-01-01 00:00:00.000000000 +0000 +++ databases/sqlite-src/pkg-descr 2017-12-16 12:41:11.833720000 +0000 @@ -0,0 +1,7 @@ +SQLite is an SQL database engine in a C library. Programs that link the SQLite +library can have SQL database access without running a separate RDBMS process. +The distribution comes with a standalone command-line access program (sqlite3) +that can be used to administer an SQLite database and which serves as an +example of how to use the SQLite library. + +WWW: https://www.sqlite.org/ diff -urNd databases/sqlite-src.orig/pkg-plist databases/sqlite-src/pkg-plist --- databases/sqlite-src.orig/pkg-plist 1970-01-01 00:00:00.000000000 +0000 +++ databases/sqlite-src/pkg-plist 2017-12-16 12:41:11.833875000 +0000 @@ -0,0 +1,18 @@ +bin/sqlite3 +%%ANALYZER%%bin/sqlite3_analyzer +%%DBHASH%%bin/sqlite3_dbhash +%%SQLDIFF%%bin/sqlite3_sqldiff +include/sqlite3.h +%%EXTENSION%%include/sqlite3ext.h +lib/libsqlite3.so.0.8.6 +lib/libsqlite3.so.0 +lib/libsqlite3.so +lib/libsqlite3.a +%%TCL_EXT%%lib/tcl%%TCL_VER%%/sqlite3/libtclsqlite3.so +%%TCL_EXT%%lib/tcl%%TCL_VER%%/sqlite3/pkgIndex.tcl +%%CSV%%%%DATADIR%%/csv.so +%%FILEIO%%%%DATADIR%%/fileio.so +%%REGEXP%%%%DATADIR%%/regexp.so +%%SPELLFIX%%%%DATADIR%%/spellfix.so +%%UNIONVTAB%%%%DATADIR%%/unionvtab.so +libdata/pkgconfig/sqlite3.pc