ci-pre-release-test-testpypi-Windows.yml

name: CI Pre Release Test TestPyPi WINDOWS
on:
  workflow_dispatch:
    inputs:
      releaseVersion:
        description: 'dbt-teradata version from TestPyPi'
        required: true
  workflow_run:
    workflows: ["CD Release TESTPYPI"]
    types:
      - completed

jobs:
  trigger:
    if: github.event.workflow_run.conclusion == 'success' || github.event_name == 'workflow_dispatch'
    runs-on: ubuntu-latest
    outputs:
      env-name: ${{ steps.define-environment-name.outputs.env-name }}
      RegularDB: ${{ steps.create-csae-environments.outputs.teradata-server-name }}
    name: CreateInstance
    steps:
      - name: Check out repository code
        uses: actions/checkout@v4
        
      - name: Setup Python
        uses: actions/setup-python@v2
        with:
          python-version: 3.9

      - name: Define CSAE env name
        id: define-environment-name
        run: |
          PYTHON_VERSION=$(echo -n "$PYTHON_VERSION" | tr -d '.') # remove dots from version
          echo "env-name=dbt-ci-$PYTHON_VERSION-$(date +%s%N)" >> $GITHUB_OUTPUT
        env:
          PYTHON_VERSION: 3.9

      - name: Create CSAE environments
        id: create-csae-environments
        shell: bash
        run: |
          chmod 777 .github/workflows/scripts/createTestEnvironments.sh
          ./.github/workflows/scripts/createTestEnvironments.sh
        env:
          CSAE_TOKEN: ${{ secrets.CSAE_TOKEN_DEVTOOLS }}
          CSAE_ENV_PASSWORD: ${{ secrets.CSAE_ENV_PASSWORD }}
          CSAE_ENV_NAME: ${{ steps.define-environment-name.outputs.env-name}}
    
  Testing-Pre-Release:
    runs-on: windows-latest
    needs: trigger
    steps:
      - name: Setup Python
        uses: actions/setup-python@v2
        with:
          python-version: 3.9
          
      - name: Install dbt-teradata
        shell: pwsh
        run: |
          python -m pip install --upgrade pip
          pip install --index-url https://test.pypi.org/simple/ dbt-teradata==$env:RELEASE_VERSION --extra-index-url https://pypi.org/simple
          if ($env:RELEASE_VERSION -match '^1\.8' -or [version]$env:RELEASE_VERSION -ge [version]'1.8.0') {
            pip install dbt-core>=1.8.0
          }
        env:
          RELEASE_VERSION: ${{ github.event.inputs.releaseVersion }}
      - name: Clone JaffleShop DBT Project
        shell: pwsh
        run: |
          git clone https://github.com/Teradata/jaffle_shop-dev.git jaffle_shop
          
      - name: Setup profiles.yml
        shell: pwsh
        run: |
          $TERADATA_SERVER_NAME = $env:DBT_TERADATA_SERVER_NAME
          $TERADATA_USERNAME = $env:DBT_TERADATA_USERNAME
          $TERADATA_PASSWORD = $env:DBT_TERADATA_PASSWORD
          mkdir .dbt
          $content= @"
          jaffle_shop:
            outputs:
              dev:
                type: teradata
                host: $TERADATA_SERVER_NAME
                user: $TERADATA_USERNAME
                password: $TERADATA_PASSWORD
                logmech: TD2
                schema: jaffle_shop
                tmode: ANSI
                threads: 1
                timeout_seconds: 300
                priority: interactive
                retries: 1
            target: dev
          "@
          $content | Out-File -FilePath .dbt\profiles.yml
        env:
          DBT_TERADATA_SERVER_NAME: ${{ needs.trigger.outputs.RegularDB }}
          DBT_TERADATA_USERNAME: dbc
          DBT_TERADATA_PASSWORD: ${{ secrets.CSAE_ENV_PASSWORD }}

      - name: Running jaffle_shop project
        shell: pwsh
        run: |
          cd jaffle_shop
          ls
          Get-Content "..\.dbt\profiles.yml"
          $env:DBT_PROFILES_DIR= "..\.dbt"
          dbt debug
          dbt seed
          dbt run
          dbt test
          dbt docs generate
          
  Delete_instance:
    if: ${{ always() }}
    runs-on: ubuntu-latest
    needs: [trigger, Testing-Pre-Release]
    steps:
      - name: Check out repository code
        uses: actions/checkout@v4
        
      - name: Delete CSAE environment
        if: always()
        run: |
          chmod 777 .github/workflows/scripts/deleteTestEnvironments.sh
          ./.github/workflows/scripts/deleteTestEnvironments.sh
        env:
          CSAE_TOKEN: '${{ secrets.CSAE_TOKEN_DEVTOOLS }}'
          CSAE_ENV_NAME: '${{ needs.trigger.outputs.env-name}}'