_build/install-sqlite3.yml

steps:
  - ${{ if eq(parameters.name, 'macOS_sqlite') }}:
    - script: |
        brew update
        brew reinstall sqlite pkg-config
        echo "##vso[task.setvariable variable=PATH;]/usr/local/opt/sqlite/bin:$PATH"
        echo "##vso[task.setvariable variable=LDFLAGS;]-L/usr/local/opt/sqlite/lib"
        echo "##vso[task.setvariable variable=CPPFLAGS;]-I/usr/local/opt/sqlite/include"
        echo "##vso[task.setvariable variable=PKG_CONFIG_PATH;]/usr/local/opt/sqlite/lib/pkgconfig"
      displayName: Install sqlite3 (macOS)
  - ${{ if eq(parameters.name, 'Linux_sqlite') }}:
    - script: |
        sudo apt-get update
        sudo apt-get install curl libpq-dev libmysqlclient-dev
        curl -fsS --retry 3 -o sqlite-autoconf-3310100.tar.gz https://sqlite.org/2020/sqlite-autoconf-3310100.tar.gz
        tar zxf sqlite-autoconf-3310100.tar.gz
        cd sqlite-autoconf-3310100
        CFLAGS="$CFLAGS -O2 -fno-strict-aliasing \
                    -DSQLITE_DEFAULT_FOREIGN_KEYS=1 \
                    -DSQLITE_SECURE_DELETE \
                    -DSQLITE_ENABLE_COLUMN_METADATA \
                    -DSQLITE_ENABLE_FTS3_PARENTHESIS \
                    -DSQLITE_ENABLE_RTREE=1 \
                    -DSQLITE_SOUNDEX=1 \
                    -DSQLITE_ENABLE_UNLOCK_NOTIFY \
                    -DSQLITE_OMIT_LOOKASIDE=1 \
                    -DSQLITE_ENABLE_DBSTAT_VTAB \
                    -DSQLITE_ENABLE_UPDATE_DELETE_LIMIT=1 \
                    -DSQLITE_ENABLE_LOAD_EXTENSION \
                    -DSQLITE_ENABLE_JSON1 \
                    -DSQLITE_LIKE_DOESNT_MATCH_BLOBS \
                    -DSQLITE_THREADSAFE=1 \
                    -DSQLITE_ENABLE_FTS3_TOKENIZER=1 \
                    -DSQLITE_MAX_SCHEMA_RETRY=25 \
                    -DSQLITE_ENABLE_PREUPDATE_HOOK \
                    -DSQLITE_ENABLE_SESSION \
                    -DSQLITE_ENABLE_STMTVTAB \
                    -DSQLITE_MAX_VARIABLE_NUMBER=250000" \
        ./configure --prefix=/usr \
                    --enable-threadsafe \
                    --enable-dynamic-extensions \
                    --libdir=/usr/lib/x86_64-linux-gnu \
                    --libexecdir=/usr/lib/x86_64-linux-gnu/sqlite3
        sudo make
        sudo make install
      displayName: Install sqlite3 (Linux)
  - ${{ if eq(parameters.name, 'Windows_sqlite') }}:
    - script: |
        choco install 7zip
        mkdir C:\sqlite
        CD /D C:\sqlite
        curl -fsS --retry 3 --retry-connrefused -o sqlite3.zip https://sqlite.org/2020/sqlite-dll-win64-x64-3310100.zip
        7z e sqlite3.zip -y
        call "C:\Program Files (x86)\Microsoft Visual Studio\2017\Enterprise\VC\Auxiliary\Build\vcvars64.bat"
        lib /machine:x64 /def:sqlite3.def /out:sqlite3.lib
        set PATH=%PATH%;C:\sqlite
        echo "##vso[task.setvariable variable=PATH;]%PATH%;C:\sqlite"
      displayName: Install sqlite3 (Windows)