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) |