Add tests for #3609 #471
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
name: .NET Core | |
on: [push, pull_request] | |
jobs: | |
db: | |
strategy: | |
fail-fast: false | |
matrix: | |
include: | |
- DB: SqlServer2008 | |
CONNECTION_STRING: "Server=localhost;initial catalog=nhibernate;User Id=sa;Password=P@ssw0rd;packet size=4096;" | |
- DB: PostgreSQL | |
CONNECTION_STRING: "Host=localhost;Username=nhibernate;Password=nhibernate;Database=nhibernate;Enlist=true;" | |
- DB: Firebird | |
CONNECTION_STRING: "DataSource=localhost;Database=nhibernate;User=SYSDBA;Password=nhibernate;charset=utf8;" | |
- DB: MySQL | |
CONNECTION_STRING: "Server=localhost;Uid=root;Password=nhibernate;Database=nhibernate;Old Guids=True;" | |
ALLOW_FAILURE: true | |
- DB: SQLite | |
runs-on: ubuntu-latest | |
continue-on-error: ${{matrix.ALLOW_FAILURE == true}} | |
env: | |
LANG: en-US.UTF-8 #default POSIX locale doesn't support ignore case comparisons | |
name: ${{matrix.DB}} | |
steps: | |
- name: Set up SqlServer | |
if: matrix.DB == 'SqlServer2008' | |
run: | | |
docker run -e "ACCEPT_EULA=Y" -e "SA_PASSWORD=P@ssw0rd" -e "MSSQL_PID=Express" -p 1433:1433 -d --name sqlexpress mcr.microsoft.com/mssql/server:2019-latest; | |
- name: Set up MySQL | |
if: matrix.DB == 'MySQL' | |
run: | | |
sudo service mysql stop | |
docker run --name mysql -e MYSQL_ROOT_PASSWORD=nhibernate -e MYSQL_USER=nhibernate -e MYSQL_PASSWORD=nhibernate -e MYSQL_DATABASE=nhibernate -p 3306:3306 --health-cmd="mysqladmin ping" --health-interval=10s --health-timeout=5s --health-retries=3 -d mysql:5.7 mysqld --lower_case_table_names=1 | |
- name: Set up PostgreSQL | |
if: matrix.DB == 'PostgreSQL' | |
run: | | |
docker run -d -e POSTGRES_USER=nhibernate -e POSTGRES_PASSWORD=nhibernate -e POSTGRES_DB=nhibernate -p 5432:5432 postgres:13 | |
- name: Set up Firebird | |
if: matrix.DB == 'Firebird' | |
run: | | |
docker run --name firebird -e EnableWireCrypt=true -e FIREBIRD_USER=nhibernate -e FIREBIRD_PASSWORD=nhibernate -e ISC_PASSWORD=nhibernate -e FIREBIRD_DATABASE=nhibernate -p 3050:3050 -d jacobalberty/firebird:v3.0 | |
- uses: actions/checkout@v2 | |
- name: Setup .NET | |
uses: actions/setup-dotnet@v1.8.0 | |
with: | |
dotnet-version: 2.1.x | |
- name: Build and Test | |
run: | | |
pwsh -noprofile -command "& ./build.ps1 -TaskList Set-Configuration,Test -properties @{'Database' = '${{matrix.DB}}';'ConnectionString'='${{matrix.CONNECTION_STRING}}'}" |