thirdparty/soci/appveyor.yml

0001 version: 4.1.0.{build}
0002
0003 skip_commits:
0004   files:
0005     - .github/workflows/
0006
0007 configuration: Release
0008
0009 environment:
0010   matrix:
0011     - G: "Visual Studio 17 2022"
0012       BOOST_ROOT: C:\Libraries\boost_1_77_0
0013       MSSQL_VER: 2019
0014       POSTGRESQL_ROOT: C:\Program Files\PostgreSQL\13
0015       MYSQL_DIR: C:\Program Files\MySql\MySQL Server 5.7
0016       APPVEYOR_BUILD_WORKER_IMAGE: Visual Studio 2022
0017     - G: "Visual Studio 16 2019"
0018       BOOST_ROOT: C:\Libraries\boost_1_73_0
0019       MSSQL_VER: 2017
0020       POSTGRESQL_ROOT: C:\Program Files\PostgreSQL\12
0021       MYSQL_DIR: C:\Program Files\MySql\MySQL Server 5.7
0022       APPVEYOR_BUILD_WORKER_IMAGE: Visual Studio 2019
0023     - G: "Visual Studio 15 2017 Win64"
0024       BOOST_ROOT: C:\Libraries\boost_1_69_0
0025       MSSQL_VER: 2016
0026       POSTGRESQL_ROOT: C:\Program Files\PostgreSQL\11
0027       MYSQL_DIR: C:\Program Files\MySql\MySQL Server 5.7
0028       APPVEYOR_BUILD_WORKER_IMAGE: Visual Studio 2017
0029     - G: "Visual Studio 14 2015 Win64"
0030       BOOST_ROOT: C:\Libraries\boost_1_60_0
0031       MSSQL_VER: 2014
0032       POSTGRESQL_ROOT: C:\Program Files\PostgreSQL\10
0033       MYSQL_DIR: C:\Program Files\MySql\MySQL Server 5.7
0034       APPVEYOR_BUILD_WORKER_IMAGE: Visual Studio 2015
0035     - G: "MinGW Makefiles"
0036       MINGW_BIN: C:\mingw-w64\x86_64-8.1.0-posix-seh-rt_v6-rev0\mingw64\bin
0037       MSSQL_VER: 2014
0038       BOOST_ROOT: C:\Libraries\boost_1_60_0
0039       POSTGRESQL_ROOT: C:\Program Files\PostgreSQL\9.4
0040       MYSQL_DIR: C:\Program Files\MySql\MySQL Server 5.7
0041       APPVEYOR_BUILD_WORKER_IMAGE: Visual Studio 2015
0042
0043 services:
0044   - mysql
0045   - postgresql
0046
0047 install:
0048   # Start this one here as we can't specify the service name dynamically.
0049   - net start mssql$SQL%MSSQL_VER%
0050   - ps: |
0051       Import-Module C:\projects\soci\scripts\windows\Get-ODBCList.ps1
0052       $drivers_list = Get-ODBCList
0053       Write-Output $drivers_list
0054       if ($drivers_list -clike '*MySQL*') {
0055         $env:SOCI_ODBC_TESTS = $env:SOCI_ODBC_TESTS + '|soci_odbc_test_mysql'
0056       }
0057       if ($drivers_list -clike '*PostgreSQL*') {
0058         $env:SOCI_ODBC_TESTS = $env:SOCI_ODBC_TESTS + '|soci_odbc_test_postgresql'
0059       }
0060   - git clone https://github.com/snikulov/sqlite.cmake.build.git C:\projects\sqlite\src
0061
0062 before_build:
0063   - set SQLITE_ROOT=C:\projects\sqlite\sqlite
0064   # dirty little hack - remove sh from Git to make generator happy
0065   - ps: |
0066       if ($env:G -eq "MinGW Makefiles")
0067       {
0068         $shellPath = (Get-Command sh.exe).definition
0069         if ($shellPath)
0070         {
0071           if (Test-Path $shellPath)
0072           {
0073             Remove-Item $shellPath
0074           }
0075         }
0076         $env:SQLITE3_LIBRARY = $env:SQLITE_ROOT + '/lib/libsqlite3-static.a'
0077         $env:BUILD_TOOL_OPTIONS = '-j3'
0078       }
0079       else
0080       {
0081         $env:SQLITE3_LIBRARY = $env:SQLITE_ROOT + '/lib/sqlite3-static.lib'
0082         $env:BUILD_TOOL_OPTIONS = '/m'
0083       }
0084   - cd C:\projects\sqlite\src
0085   - mkdir build
0086   - cd build
0087   - set PATH=%MINGW_BIN%;%POSTGRESQL_ROOT%\bin;%MYSQL_DIR%\bin;%MYSQL_DIR%\lib;%PATH%
0088   - echo %PATH%
0089   - cmake --version
0090   - set PGUSER=postgres
0091   - set PGPASSWORD=Password12!
0092   - createdb soci_test
0093   - set MYSQL_PWD=Password12!
0094   - set USER=root
0095   - mysql -e "create database soci_test;" --user=root
0096   - sqlcmd -U sa -P Password12! -S (local)\SQL%MSSQL_VER% -i C:\projects\soci\scripts\windows\mssql_db_create.sql
0097   - cmake .. -G"%G%" -DSQLITE_BUILD_SHARED=OFF -DCMAKE_BUILD_TYPE=%CONFIGURATION% -DCMAKE_INSTALL_PREFIX=%SQLITE_ROOT%
0098   - cmake --build . --config %CONFIGURATION% --target install
0099
0100 build_script:
0101   - cd C:\projects\soci
0102   - mkdir build
0103   - cd build
0104   - cmake .. -G"%G%" -DCMAKE_BUILD_TYPE=%CONFIGURATION% -DCMAKE_VERBOSE_MAKEFILE=ON -DSOCI_ENABLE_WERROR=ON -DSQLITE3_INCLUDE_DIR=%SQLITE_ROOT%/include -DSQLITE3_LIBRARY=%SQLITE3_LIBRARY%
0105   - cmake --build . --config %CONFIGURATION% -- %BUILD_TOOL_OPTIONS%
0106
0107 test_script:
0108   - ctest -V --timeout 300 --output-on-failure -R "soci_empty|soci_postgresql|soci_sqlite3|soci_odbc_test_mssql|soci_mysql%SOCI_ODBC_TESTS%"
0109
0110 notifications:
0111   - provider: Webhook
0112     url: https://webhooks.gitter.im/e/2038138a652d952f9372
0113     on_build_success: true
0114     on_build_failure: true
0115     on_build_status_changed: true
0116
0117 # Uncomment this to wait for RDP connection after the build end.
0118 #on_finish:
0119 #  - ps: $blockRdp = $true; iex ((new-object net.webclient).DownloadString('https://raw.githubusercontent.com/appveyor/ci/master/scripts/enable-rdp.ps1'))