# Maintainer: Andreas Radke <andyrtr@archlinux.org>
# Contributor: Tom Newsom <Jeepster@gmx.co.uk>

pkgbase=sqlite
pkgname=(sqlite lemon sqlite-doc) #  "${PKG_PREFIX}sqlite-tcl" "${PKG_PREFIX}sqlite-analyzer"
_srcver=3450300
_docver=${_srcver}
#_docver=3440000
pkgver=3.45.3
pkgrel=1.1
pkgdesc="A C library that implements an SQL database engine"
license=('LicenseRef-Sqlite')
url="https://www.sqlite.org/"
ncxfab_makedepends=('base-devel' 'tcl')
ncxfat_makedepends=('binutils' 'readline' 'zlib')
options=('!emptydirs')
source=(https://www.sqlite.org/2024/sqlite-src-${_srcver}.zip
        https://www.sqlite.org/2024/sqlite-doc-${_docver}.zip
        sqlite-lemon-system-template.patch
        license.txt)
# upstream now switched to sha3sums - currently not supported by makepkg
sha256sums=('ec0c959e42cb5f1804135d0555f8ea32be6ff2048eb181bccd367c8f53f185d1'
            '13383c4babde9f0aa2c4d195d2109be6ba54a10b5759930912a5c559c6ec2e48'
            '55746d93b0df4b349c4aa4f09535746dac3530f9fd6de241c9f38e2c92e8ee97'
            '4e57d9ac979f1c9872e69799c2597eeef4c6ce7224f3ede0bf9dc8d217b1e65d')

prepare() {
  cd sqlite-src-$_srcver

  # patch taken from Fedora
  # https://src.fedoraproject.org/rpms/sqlite/blob/master/f/sqlite.spec
  patch -Np1 -i ../sqlite-lemon-system-template.patch

  #autoreconf -vfi
}

build() {
  # this uses malloc_usable_size, which is incompatible with fortification level 3
  export CFLAGS="${CFLAGS/_FORTIFY_SOURCE=3/_FORTIFY_SOURCE=2}"
  export CXXFLAGS="${CXXFLAGS/_FORTIFY_SOURCE=3/_FORTIFY_SOURCE=2}"

  export CPPFLAGS="$CPPFLAGS \
        -DSQLITE_ENABLE_COLUMN_METADATA=1 \
        -DSQLITE_ENABLE_UNLOCK_NOTIFY \
        -DSQLITE_ENABLE_DBSTAT_VTAB=1 \
        -DSQLITE_ENABLE_FTS3_TOKENIZER=1 \
        -DSQLITE_ENABLE_FTS3_PARENTHESIS \
        -DSQLITE_SECURE_DELETE \
        -DSQLITE_ENABLE_STMTVTAB \
        -DSQLITE_ENABLE_STAT4 \
        -DSQLITE_MAX_VARIABLE_NUMBER=250000 \
        -DSQLITE_MAX_EXPR_DEPTH=10000 \
        -DSQLITE_ENABLE_MATH_FUNCTIONS"

  # build sqlite
  cd sqlite-src-$_srcver
  ./configure --prefix=$MPKG_USRPATH \
        --host=$MPKG_TARGETMACHINE \
        --oldincludedir=$MPKG_USRPATH/include \
        --disable-static \
	--enable-fts3 \
	--enable-fts4 \
	--enable-fts5 \
	--enable-rtree \
        --disable-tcl \
	TCLLIBDIR=$MPKG_USRPATH/lib/sqlite$pkgver
  sed -i -e 's/ -shared / -Wl,-O1,--as-needed\0/g' libtool
  make -d 2>&1 > make.log 
  # build additional tools
  make showdb showjournal showstat4 showwal sqldiff # sqlite3_analyzer
}

package_sqlite() {
  pkgdesc="A C library that implements an SQL database engine"
  ncxfat_depends=(readline zlib glibc)
  provides=("sqlite3=$pkgver" 'libsqlite3.so')
  replaces=('sqlite3')

  cd sqlite-src-$_srcver
  make DESTDIR="${pkgdir}" install

  install -m755 showdb showjournal showstat4 showwal sqldiff "${pkgdir}"$MPKG_USRPATH/bin/

  # install manpage
  install -m755 -d "${pkgdir}"$MPKG_USRPATH/share/man/man1
  install -m644 sqlite3.1 "${pkgdir}"$MPKG_USRPATH/share/man/man1/

  # license
  install -D -m644 "${srcdir}"/license.txt "${pkgdir}"/usr/share/licenses/${pkgname}/license.txt

  # split out tcl extension
  
  # mkdir "$srcdir"/tcl
  # mv "$pkgdir"$USR_PATH/lib/sqlite* "$srcdir"/tcl
}

# package_sqlite-tcl() {
#  pkgdesc="sqlite Tcl Extension Architecture (TEA)"
#  ncxfah_depends=("${DEP_PREFIX}sqlite" "${DEP_PREFIX}glibc")
#  provides=("${PKG_PREFIX}sqlite3-tcl=$pkgver")
#  replaces=("${PKG_PREFIX}sqlite3-tcl")

#   install -m755 -d "${pkgdir}"$USR_PATH/lib
#   mv "$srcdir"/tcl/* "${pkgdir}"$USR_PATH/lib

#   # install manpage
#   install -m755 -d "${pkgdir}"$USR_PATH/share/man/mann
#   install -m644 "${srcdir}"/sqlite-src-$_srcver/autoconf/tea/doc/sqlite3.n "${pkgdir}"$USR_PATH/share/man/mann/

#   # license
#   install -D -m644 "${srcdir}"/license.txt "${pkgdir}"/usr/share/licenses/${pkgname}/license.txt
# }

# package_sqlite-analyzer() {
#  pkgdesc="An analysis program for sqlite3 database files"
#  ncxfah_depends=("${DEP_PREFIX}sqlite" "${DEP_PREFIX}tcl" "${DEP_PREFIX}glibc")

#   cd sqlite-src-$_srcver
#   install -m755 -d "${pkgdir}"$USR_PATH/bin
#   install -m755 sqlite3_analyzer "${pkgdir}"$USR_PATH/bin/

#   # license
#   install -D -m644 "${srcdir}"/license.txt "${pkgdir}"/usr/share/licenses/${pkgname}/license.txt
# }

package_lemon() {

 # https://www.sqlite.org/lemon.html
 pkgdesc="A parser generator"
 ncxfat_depends=(glibc)

  cd sqlite-src-$_srcver
  # ELF file ('usr/bin/lemon') lacks FULL RELRO, check LDFLAGS. - no fix found so far
  install -Dm755 lemon ${pkgdir}$MPKG_USRPATH/bin/lemon
  install -Dm644 lempar.c ${pkgdir}$MPKG_USRPATH/share/lemon/lempar.c
  
  mkdir -p "${pkgdir}"$MPKG_USRPATH/share/doc/${pkgname}
  cp ../sqlite-doc-${_docver}/lemon.html  "${pkgdir}"$MPKG_USRPATH/share/doc/${pkgname}/
  # license
  install -D -m644 "${srcdir}"/license.txt "${pkgdir}"/usr/share/licenses/${pkgname}/license.txt
}

package_sqlite-doc() {

 pkgdesc="most of the static HTML files that comprise this website, including all of the SQL Syntax and the C/C++ interface specs and other miscellaneous documentation"
 #arch=('any') - not yet supported
 provides=("sqlite3-doc=$pkgver")
 replaces=('sqlite3-doc')

  cd sqlite-doc-${_docver}
  mkdir -p "${pkgdir}"$MPKG_USRPATH/share/doc/${pkgbase}
  cp -R *  "${pkgdir}"$MPKG_USRPATH/share/doc/${pkgbase}/

  # license
  install -D -m644 "${srcdir}"/license.txt "${pkgdir}"/usr/share/licenses/${pkgname}/license.txt
  
  rm "${pkgdir}"$MPKG_USRPATH/share/doc/${pkgbase}/lemon.html
}
