From a3da048e47c6422ac8d59f93ab931a8c7c729f00 Mon Sep 17 00:00:00 2001 From: Arn0 Date: Sun, 18 Apr 2021 17:20:56 +0200 Subject: system/sqldiff: updated for version 3.35.5 Signed-off-by: Willy Sudiarto Raharjo --- system/sqldiff/sqldiff.SlackBuild | 63 ++++++++++++++++++++++++++++++--------- system/sqldiff/sqldiff.info | 6 ++-- 2 files changed, 52 insertions(+), 17 deletions(-) (limited to 'system') diff --git a/system/sqldiff/sqldiff.SlackBuild b/system/sqldiff/sqldiff.SlackBuild index 4385747b8b..07d36f7f1a 100644 --- a/system/sqldiff/sqldiff.SlackBuild +++ b/system/sqldiff/sqldiff.SlackBuild @@ -22,11 +22,11 @@ # ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. PRGNAM=sqldiff -VERSION=${VERSION:-3.13} +VERSION=${VERSION:-3.35.5} BUILD=${BUILD:-1} TAG=${TAG:-_SBo} SRCNAM=sqlite -SRCVER=$(tr -d . <<< "${VERSION}0000") +SRCVER="3350500" if [ -z "$ARCH" ]; then case "$( uname -m )" in @@ -56,7 +56,37 @@ else fi # Enable the same features as slackware official sqlite package: -SLKCFLAGS="$SLKCFLAGS -DSQLITE_ENABLE_FTS3 -DSQLITE_ENABLE_FTS3_PARENTHESIS=1 -DSQLITE_ENABLE_ICU -DSQLITE_ENABLE_COLUMN_METADATA=1 -DSQLITE_DISABLE_DIRSYNC=1 -DSQLITE_ENABLE_RTREE=1 -DSQLITE_ENABLE_STAT2=1 -DSQLITE_ENABLE_UNLOCK_NOTIFY=1 -DSQLITE_SECURE_DELETE=1" +# Enable AND, NOT and nested parenthesis in FTS3 +SLKCFLAGS="$SLKCFLAGS -DSQLITE_ENABLE_FTS3_PARENTHESIS=1" + +# Enable the ICU extension +SLKCFLAGS="$SLKCFLAGS -DSQLITE_ENABLE_ICU" + +# Enables the retrieval of column metadata +SLKCFLAGS="$SLKCFLAGS -DSQLITE_ENABLE_COLUMN_METADATA=1" + +# Disable directory syncs +SLKCFLAGS="$SLKCFLAGS -DSQLITE_DISABLE_DIRSYNC=1" + +# Add additional logic to the ANALYZE command and to the query planner +# to chose better query plans under certain situations +SLKCFLAGS="$SLKCFLAGS -DSQLITE_ENABLE_STAT4=1" + +# Enable the sqlite3_unlock_notify() interface and its associated functionality +# https://www.sqlite.org/unlock_notify.html +SLKCFLAGS="$SLKCFLAGS -DSQLITE_ENABLE_UNLOCK_NOTIFY=1" + +# The secure_delete setting causes deleted content to be overwritten with zeros +# https://www.sqlite.org/pragma.html#pragma_secure_delete +SLKCFLAGS="$SLKCFLAGS -DSQLITE_SECURE_DELETE=1" + +# Enable the "Resumable Bulk Update" extension +# https://www.sqlite.org/rbu.html +SLKCFLAGS="$SLKCFLAGS -DSQLITE_ENABLE_RBU=1" + +# Enable the DBSTAT Virtual Table +# https://www.sqlite.org/dbstat.html +SLKCFLAGS="$SLKCFLAGS -DSQLITE_ENABLE_DBSTAT_VTAB=1" set -e @@ -74,8 +104,15 @@ find -L . \ -o -perm 440 -o -perm 400 \) -exec chmod 644 {} \; # Completely copied from slackware's official sqlite SlackBuild -# except --enable-cross-thread-connections is removed because it does not work. -configure() { +if [ ! -f configure ]; then + # Try regenerating configure: + autoreconf -vif +fi + +# Fix a bug in ./configure that discards all but the last considered option: +sed -i "s|\$(OPT_FEATURE_FLAGS)|\${OPT_FEATURE_FLAGS}|g" ./configure + + CFLAGS="$SLKCFLAGS" \ CXXFLAGS="$SLKCFLAGS $(icu-config --cppflags)" \ LDFLAGS="$(icu-config --ldflags)" \ @@ -88,16 +125,14 @@ LDFLAGS="$(icu-config --ldflags)" \ --enable-threadsafe \ --enable-tempstore=yes \ --enable-load-extension \ + --enable-fts3 \ + --enable-fts4 \ + --enable-fts5 \ + --enable-json1 \ + --enable-rtree \ + --enable-session \ --enable-static=no \ - --build=$ARCH-slackware-linux - return $? -} - -if ! configure ; then - # Try regenerating configure: - autoconf - configure || exit 1 -fi + --build=$ARCH-slackware-linux || exit 1 # End of Slackware's SlackBuild copy-pasting # Here we only build $PRGNAM target diff --git a/system/sqldiff/sqldiff.info b/system/sqldiff/sqldiff.info index 5a13395c33..5a8c536200 100644 --- a/system/sqldiff/sqldiff.info +++ b/system/sqldiff/sqldiff.info @@ -1,8 +1,8 @@ PRGNAM="sqldiff" -VERSION="3.13" +VERSION="3.35.5" HOMEPAGE="https://www.sqlite.org/" -DOWNLOAD="https://mirrors.slackware.com/slackware/slackware64-14.2/source/ap/sqlite/sqlite-src-3130000.tar.xz" -MD5SUM="871f618307359b5a739955f690eebba0" +DOWNLOAD="https://mirrors.slackware.com/slackware/slackware64-current/source/ap/sqlite/sqlite-src-3350500.tar.lz" +MD5SUM="a668c7fd758e30081c94adb3ab9a4241" DOWNLOAD_x86_64="" MD5SUM_x86_64="" REQUIRES="" -- cgit v1.2.3-80-g2a13