create-databases.yml

name: Create databases

on:
  workflow_dispatch:

jobs:
  Create-databases:
    runs-on: [self-hosted, windows, x64, '${{ matrix.dev-or-ci }}', '${{ matrix.actian-efcore-environment }}', '${{ matrix.compatibility }}']

    strategy:
      fail-fast: false
      matrix:
        dev-or-ci:
          - Dev
          - CI
        actian-efcore-environment:
          #- WIN64_INGRES_10_1_0
          #- WIN64_ACTIANX_11_1_0
          - WIN64_ACTIANX_11_2_0
        compatibility:
          - Ingres
          - Ansi

    env:
      config: Debug

    steps:
      - name: Clean build directory
        run: |
          rd /s /q . 2>nul
          exit /b 0
        shell: cmd

      - uses: actions/checkout@v3

      - name: Setup Actian installation
        run: powershell .\scripts\SetupActianInstallation.ps1

      - name: Environment
        run: |
          Get-ChildItem env:

      - name: Drop test databases
        run: dotnet run -- drop-test-databases
        working-directory: utils/Actian.EFCore.Build

      - name: Create database users
        run: dotnet run -- create-db-users
        working-directory: utils/Actian.EFCore.Build

      - name: Create test databases
        run: dotnet run -- create-test-databases
        working-directory: utils/Actian.EFCore.Build

      - name: Populate northwind database
        run: dotnet run -- populate-northwind
        working-directory: utils/Actian.EFCore.Build