prerelease.yml

name: Run Prerelease Tests
on: workflow_dispatch
defaults:
  run:
    shell: pwsh
jobs:
  linux-tests:
    runs-on: ubuntu-latest
    env:
      GITHUB_TOKEN: ${{secrets.GITHUB_TOKEN}}

    steps:
      - uses: actions/checkout@v3

      - name: Install dbatools prerelease
        run: |
          Set-PSRepository PSGallery -InstallationPolicy Trusted
          Install-Module dbatools -AllowPrerelease
          Set-DbatoolsConfig -Name Import.EncryptionMessageCheck -Value $false -PassThru | Register-DbatoolsConfig

      - name: Measure import speed on pwsh
        run: |
          Measure-Command { Import-Module dbatools }
          Get-Module dbatools

      - name: Set encryption values
        run: |
          Set-DbatoolsConfig -FullName sql.connection.trustcert -Value $true -Register
          Set-DbatoolsConfig -FullName sql.connection.encrypt -Value $false -Register
          Get-DbatoolsConfigValue -FullName sql.connection.encrypt | Write-Warning

      - name:  Setup docker images
        run: |
          # create a shared network
          docker network create localnet
          # Expose engine and endpoint then setup a shared path for migrations
          docker run -p 1433:1433  --volume shared:/shared:z --name mssql1 --hostname mssql1 --network localnet -d dbatools/sqlinstance
          # Expose second engine and endpoint on different port
          docker run -p 14333:1433 --volume shared:/shared:z --name mssql2 --hostname mssql2 --network localnet -d dbatools/sqlinstance2

      - name: 👥 Clone appveyor repo
        working-directory: /tmp
        run: |
          gh repo clone dataplat/appveyor-lab

      - name: Run tests
        env:
          TENANTID: ${{secrets.TENANTID}}
          CLIENTID: ${{secrets.CLIENTID}}
          CLIENTSECRET: ${{secrets.CLIENTSECRET}}
          CLIENT_GUID: ${{secrets.CLIENT_GUID}}
          CLIENT_GUID_SECRET: ${{secrets.CLIENT_GUID_SECRET}}
        run: |
          Import-Module dbatools
          Get-DbatoolsConfigValue -FullName sql.connection.trustcert | Write-Warning
          Get-DbatoolsConfigValue -FullName sql.connection.encrypt | Write-Warning
          $null = Invoke-Pester ./tests/gh-actions.ps1 -Output Detailed -PassThru

  windows-tests:
    runs-on: windows-latest
    env:
      GITHUB_TOKEN: ${{secrets.GITHUB_TOKEN}}

    steps:
      - name: Checkout dbatools repo
        uses: actions/checkout@v3

      - name: Install dbatools prerelease on pwsh
        shell: pwsh
        run: |
          Set-PSRepository PSGallery -InstallationPolicy Trusted
          Install-Module dbatools -AllowPrerelease

      - name: Install dbatools prerelease on powershell
        shell: powershell
        run: |
          Set-PSRepository PSGallery -InstallationPolicy Trusted
          Install-Module dbatools.library
          Install-Module dbatools -AllowPrerelease

      - name: Measure import speed on pwsh
        run: |
          Measure-Command { Import-Module dbatools }
          Get-Module dbatools

      - name: Measure import speed on powershell
        shell: powershell
        run: |
          Import-Module dbatools.library
          Measure-Command { Import-Module dbatools }
          Get-Module dbatools

      - name: Install SQL Server localdb
        uses: potatoqualitee/mssqlsuite@v1.3
        with:
          install: localdb

      - name: Connect to localdb instance powershell
        shell: powershell
        run: |
          Set-DbatoolsConfig -FullName sql.connection.trustcert -Value $true -PassThru | Register-DbatoolsConfig -Scope FileUserShared
          Set-DbatoolsConfig -FullName sql.connection.encrypt -Value $false -PassThru | Register-DbatoolsConfig -Scope FileUserShared
          Connect-DbaInstance -SqlInstance "(localdb)\MSSQLLocalDB"

      - name: Connect to localdb instance pwsh
        shell: pwsh
        run: |
          Set-DbatoolsConfig -FullName sql.connection.trustcert -Value $true -PassThru | Register-DbatoolsConfig -Scope FileUserShared
          Set-DbatoolsConfig -FullName sql.connection.encrypt -Value $false -PassThru | Register-DbatoolsConfig -Scope FileUserShared
          Connect-DbaInstance -SqlInstance "(localdb)\MSSQLLocalDB"

      - name: Run pwsh tests
        env:
          TENANTID: ${{secrets.TENANTID}}
          CLIENTID: ${{secrets.CLIENTID}}
          CLIENTSECRET: ${{secrets.CLIENTSECRET}}
          CLIENT_GUID: ${{secrets.CLIENT_GUID}}
          CLIENT_GUID_SECRET: ${{secrets.CLIENT_GUID_SECRET}}
        shell: pwsh
        run: |
          Import-Module dbatools
          $null = Invoke-Pester ./tests/gh-winactions.ps1 -Output Detailed -PassThru

      - name: Run PowerShell tests
        env:
          TENANTID: ${{secrets.TENANTID}}
          CLIENTID: ${{secrets.CLIENTID}}
          CLIENTSECRET: ${{secrets.CLIENTSECRET}}
        shell: powershell
        run: |
          Import-Module dbatools
          $null = Invoke-Pester ./tests/gh-winactions.ps1 -Output Detailed -PassThru