From 0781671a77220a2b87be2de7e6415efc7947a75c Mon Sep 17 00:00:00 2001 From: Britney Fransen Date: Thu, 15 Feb 2018 20:13:00 +0000 Subject: sqlite: update to 3.22.0 --- abs/extra/sqlite/PKGBUILD | 135 +++++++++++++++++++++++++++------------------- 1 file changed, 80 insertions(+), 55 deletions(-) diff --git a/abs/extra/sqlite/PKGBUILD b/abs/extra/sqlite/PKGBUILD index 062789e..1e09121 100644 --- a/abs/extra/sqlite/PKGBUILD +++ b/abs/extra/sqlite/PKGBUILD @@ -1,70 +1,108 @@ -# $Id: PKGBUILD 161621 2012-06-12 15:12:59Z andyrtr $ +# $Id$ # Maintainer: Andreas Radke # Contributor: Tom Newsom pkgbase="sqlite" -pkgname=('sqlite' 'sqlite-tcl' 'sqlite-doc') -_amalgamationver=3071300 -_amalgamationver2=${_amalgamationver/00/} -_docver=${_amalgamationver} #3070700 -#pkgver=${_amalgamationver2//0/.} -pkgver=3.7.13 +pkgname=('sqlite' 'sqlite-tcl' 'sqlite-doc' 'sqlite-analyzer') +_srcver=3220000 +_docver=${_srcver} +#_docver=3080001 +pkgver=3.22.0 pkgrel=1 pkgdesc="A C library that implements an SQL database engine" -arch=('i686' 'x86_64') -license=('custom') +arch=('x86_64') +license=('custom:Public Domain') url="http://www.sqlite.org/" -makedepends=('tcl' 'readline') -source=( # tarball containing the amalgamation for SQLite >= 3.7.5 together with a configure script and makefile for building it; includes now also the Tcl Extension Architecture (TEA) - http://www.sqlite.org/sqlite-autoconf-$_amalgamationver.tar.gz - #http://www.sqlite.org/sqlite-doc-${_amalgamationver}.zip - http://www.sqlite.org/sqlite-doc-${_docver}.zip - license.txt) -options=('!libtool' '!emptydirs') -md5sums=('c97df403e8a3d5b67bb408fcd6aabd8e' - '16a003d5a619a6c725e3d81cf5aaba2a' - 'c1cdbc5544034d9012e421e75a5e4890') +makedepends=('tcl' 'readline' 'zlib') +source=(https://www.sqlite.org/2018/sqlite-src-${_srcver}.zip + https://www.sqlite.org/2018/sqlite-doc-${_docver}.zip + license.txt) +options=('!emptydirs' '!makeflags') # json extensions breaks parallel build +sha1sums=('2bc86f2c63868cebd0db913843b919d62d284094' + '4cbcc5c5029b8e355fa1e5c563a15b91f7ea7ced' + 'f34f6daa4ab3073d74e774aad21d66878cf26853') + +prepare() { + cd sqlite-src-$_srcver +# autoreconf -vfi +} build() { - export CFLAGS="$CFLAGS -DSQLITE_ENABLE_FTS3=1 -DSQLITE_ENABLE_COLUMN_METADATA=1 -DSQLITE_ENABLE_UNLOCK_NOTIFY -DSQLITE_SECURE_DELETE" + export CPPFLAGS="$CPPFLAGS -DSQLITE_ENABLE_COLUMN_METADATA=1 \ + -DSQLITE_ENABLE_UNLOCK_NOTIFY \ + -DSQLITE_ENABLE_DBSTAT_VTAB=1 \ + -DSQLITE_ENABLE_FTS3_TOKENIZER=1 \ + -DSQLITE_SECURE_DELETE \ + -DSQLITE_MAX_VARIABLE_NUMBER=250000 \ + -DSQLITE_MAX_EXPR_DEPTH=10000" # build sqlite - cd "$srcdir"/sqlite-autoconf-$_amalgamationver - ./configure --prefix=/usr \ - --disable-static - make - - # build the tcl extension - cd "$srcdir"/sqlite-autoconf-$_amalgamationver/tea + cd sqlite-src-$_srcver ./configure --prefix=/usr \ - --with-system-sqlite + --disable-static \ + --disable-amalgamation \ + --enable-fts3 \ + --enable-fts4 \ + --enable-fts5 \ + --enable-rtree \ + --enable-json1 \ + TCLLIBDIR=/usr/lib/sqlite$pkgver make - + # build additional tools + make showdb showjournal showstat4 showwal sqldiff sqlite3_analyzer } package_sqlite() { - + pkgdesc="A C library that implements an SQL database engine" - depends=('readline') + depends=('readline' 'zlib') provides=("sqlite3=$pkgver") replaces=("sqlite3") - - cd ${srcdir}/sqlite-autoconf-$_amalgamationver + + cd sqlite-src-$_srcver make DESTDIR=${pkgdir} install - - # license - install -D -m644 ${srcdir}/license.txt ${pkgdir}/usr/share/licenses/${pkgname}/license.txt + + install -m755 showdb showjournal showstat4 showwal sqldiff ${pkgdir}/usr/bin/ + + # install manpage + install -m755 -d ${pkgdir}/usr/share/man/man1 + install -m644 sqlite3.1 ${pkgdir}/usr/share/man/man1/ + + # license - no linking required because pkgbase=pkgname + install -D -m644 ${srcdir}/license.txt ${pkgdir}/usr/share/licenses/${pkgbase}/license.txt + + # split out tcl extension + mkdir $srcdir/tcl + mv $pkgdir/usr/lib/sqlite* $srcdir/tcl } package_sqlite-tcl() { - + pkgdesc="sqlite Tcl Extension Architecture (TEA)" depends=('sqlite') provides=("sqlite3-tcl=$pkgver") replaces=("sqlite3-tcl") - - cd ${srcdir}/sqlite-autoconf-$_amalgamationver/tea - make DESTDIR=${pkgdir} install + + install -m755 -d ${pkgdir}/usr/lib + mv $srcdir/tcl/* ${pkgdir}/usr/lib + + # install manpage + install -m755 -d ${pkgdir}/usr/share/man/mann + install -m644 ${srcdir}/sqlite-src-$_srcver/autoconf/tea/doc/sqlite3.n ${pkgdir}/usr/share/man/mann/ + + # link license + install -m755 -d ${pkgdir}/usr/share/licenses + ln -sf /usr/share/licenses/${pkgbase} "${pkgdir}/usr/share/licenses/${pkgname}" +} + +package_sqlite-analyzer() { + + pkgdesc="An analysis program for sqlite3 database files" + depends=('sqlite' 'tcl') + + cd sqlite-src-$_srcver + install -m755 -d ${pkgdir}/usr/bin + install -m755 sqlite3_analyzer ${pkgdir}/usr/bin/ } package_sqlite-doc() { @@ -73,21 +111,8 @@ package_sqlite-doc() { #arch=('any') - not yet supported provides=("sqlite3-doc=$pkgver") replaces=("sqlite3-doc") - - #cd ${srcdir}/sqlite-doc-${_amalgamationver} - cd ${srcdir}/sqlite-doc-${_docver} + + cd sqlite-doc-${_docver} mkdir -p ${pkgdir}/usr/share/doc/${pkgbase} cp -R * ${pkgdir}/usr/share/doc/${pkgbase}/ - - # fix permissions and remove obsolete files; https://bugs.archlinux.org/task/24605 - find ${pkgdir} -type f -perm 755 -exec ls -lha {} \; - find ${pkgdir} -type f -perm 755 -exec chmod 644 {} \; - - find ${pkgdir} -type f -name '*~' -exec ls -lha {} \; - find ${pkgdir} -type d -name '*~' -exec ls -lha {} \; - find ${pkgdir} -name '*~' -exec rm -f {} \; - - find ${pkgdir} -type f -name '.~*' -exec ls -lha {} \; # /build/pkg/sqlite-doc/usr/share/doc/sqlite/images/fileformat/.~lock.indexpage.odg# - find ${pkgdir} -type d -name '.~*' -exec ls -lha {} \; - find ${pkgdir} -name '.~*' -exec rm -f {} \; } -- cgit v0.12