tests.yml

name: Build and test
on: [push]
defaults:
  run:
    shell: pwsh
jobs:
  tests:
    runs-on: ubuntu-latest

    steps:
      - uses: actions/checkout@v2

      - name: Build docker images
        run: docker compose -f ./sqlinstance/docker-compose.yml up --force-recreate --build --remove-orphans -d

      - name: Stop newly built containers and remove volumes
        run: docker compose -f ./sqlinstance/docker-compose.yml down --volumes

      - name: Recreate the scenario from dbatools.io/docker
        run: |
          # create a shared network
          docker network create localnet
          # Expose engine then setup a shared path for migrations
          docker run -p 1433:1433 --volume shared:/shared:z --hostname mssql1 --name mssql1 --network localnet -d dbatools/sqlinstance
          # Expose second engine on different port and use the same shared path
          docker run -p 14333:1433 --volume shared:/shared:z --hostname mssql2 --name mssql2 --network localnet -d dbatools/sqlinstance2

      - name: Install and cache dbatools
        uses: potatoqualitee/psmodulecache@v4
        with:
          modules-to-cache: dbatools

      - name: Test that commands continue to work with new build
        run: |
          $null = Invoke-Pester ./tests/actions.ps1 -Output Detailed -PassThru
          Get-DbatoolsError -All

      - name: Remove containers
        run: docker rm -vf mssql1 mssql2

      - name: Recreate the scenario from the env PR
        run: |
          docker run -p 1433:1433  --volume shared:/shared:z --name mssql1 --hostname mssql1 --network localnet --env MSSQL_DB=mydb1 -d dbatools/sqlinstance
          docker run -p 14333:1433 --volume shared:/shared:z --name mssql2 --hostname mssql2 --network localnet --env MSSQL_DB=mydb2 -d dbatools/sqlinstance2
          sleep 20

      - name: Test that commands continue to work with new build
        run: |
          $password = ConvertTo-SecureString "dbatools.IO" -AsPlainText -Force
          $cred = New-Object -TypeName System.Management.Automation.PSCredential -ArgumentList "sqladmin", $password

          Get-DbaDatabase -SqlInstance localhost -SqlCredential $cred -Database mydb1 | Should -Not -BeNullOrEmpty
          Get-DbaDatabase -SqlInstance localhost:14333 -SqlCredential $cred -Database mydb2 | Should -Not -BeNullOrEmpty