name: Benchmark OrmLite

on: workflow_dispatch

jobs:

benchmark-ormlite:

runs-on: ubuntu-latest

services:

postgres:

image: postgres

env:

POSTGRES_USER: postgres

POSTGRES_PASSWORD: p@55wOrd

POSTGRES_DB: test

ports:

- 5432:5432

options: >-

--health-cmd pg_isready

--health-interval 10s

--health-timeout 5s

--health-retries 5

sqlserver:

image: mcr.microsoft.com/mssql/server:2022-latest

env:

ACCEPT_EULA: Y

SA_PASSWORD: p@55wOrd

MSSQL_PID: Developer

ports:

- 1433:1433

mysql:

image: mysql:latest

env:

MYSQL_ROOT_PASSWORD: p@55wOrd

MYSQL_DATABASE: test

ports:

- 3306:3306

steps:

- name: Create Databases

run: |

sudo apt-get update

sudo apt-get install -y postgresql-client mysql-client sqlcmd

PGPASSWORD=p@55wOrd psql -h localhost -U postgres -tc "SELECT 'CREATE DATABASE test' WHERE NOT EXISTS (SELECT FROM pg_database WHERE datname = 'test')"

mysql -h 127.0.0.1 --password=p@55wOrd --user root -e "CREATE DATABASE IF NOT EXISTS test"

sqlcmd -U sa -P p@55wOrd -Q "CREATE DATABASE test"

- uses: actions/checkout@v4

- name: Setup dotnet

uses: actions/setup-dotnet@v4

with:

dotnet-version: '8.0.100'

- name: Build

working-directory: ServiceStack.OrmLite/build

run: dotnet build ./build.proj

- name: Env setup

run: |

echo "SERVICESTACK_LICENSE=${{ secrets.SERVICESTACK_LICENSE }}" >> $GITHUB_ENV

- name: Benchmark OrmLite

working-directory: ServiceStack.OrmLite/tests/ServiceStack.OrmLite.Benchmarks

run: dotnet run -c Release