GitHub - Pipeline Validation Workflow #12
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| name: GitHub - Pipeline Validation Workflow | |
| on: | |
| pull_request: | |
| branches: | |
| - release | |
| schedule: | |
| - cron: "0 3 * * *" # Runs at 3 AM UTC every night | |
| # Allows you to run this workflow manually from the Actions tab | |
| workflow_dispatch: | |
| jobs: | |
| setup-test-environment: | |
| name: Spin Up Test SQL Server | |
| runs-on: ubuntu-latest | |
| env: | |
| DB_IMAGE: "mcr.microsoft.com/mssql/server:2019-latest" | |
| DB_PORT: "1433" | |
| SA_PASSWORD: "Redg@te1" | |
| steps: | |
| - name: Checkout Code | |
| uses: actions/checkout@v4 | |
| - name: Start SQL Server with Access to Backups & Scripts and Enable TCP/IP | |
| run: | | |
| docker run -e "ACCEPT_EULA=Y" -e "SA_PASSWORD=${{ env.SA_PASSWORD }}" \ | |
| -p ${{ env.DB_PORT }}:1433 -d \ | |
| -v ${{ github.workspace }}/backups:/var/opt/mssql/backups \ | |
| -v ${{ github.workspace }}/Scripts:/var/opt/mssql/scripts \ | |
| ${{ env.DB_IMAGE }} \ | |
| /bin/bash -c " \ | |
| # Enable TCP/IP in SQL Server configuration \ | |
| /opt/mssql-tools18/bin/sqlcmd -S localhost -U sa -P '${{ env.SA_PASSWORD }}' -Q \ | |
| \"EXEC sp_configure 'remote access', 1; RECONFIGURE;\" && \ | |
| # Restart SQL Server for the changes to take effect \ | |
| /opt/mssql/bin/sqlservr --accept-eula" | |
| - name: Wait for SQL Server to be ready | |
| run: | | |
| echo "Waiting for SQL Server to be ready..." | |
| # Wait for the container to be fully up and running by checking the logs | |
| until docker logs $(docker ps -q --filter ancestor=mcr.microsoft.com/mssql/server:2019-latest) 2>&1 | grep -q "SQL Server is now ready for client connections"; do | |
| echo "Waiting for SQL Server to be ready..." | |
| sleep 5 | |
| done | |
| echo "SQL Server is ready." | |
| - name: Execute SQL Script to Create Test Databases | |
| run: | | |
| CONTAINER_ID=$(docker ps -q --filter ancestor=${{ env.DB_IMAGE }}) | |
| docker exec -i $CONTAINER_ID /bin/bash -c " | |
| /opt/mssql-tools18/bin/sqlcmd -S 'localhost,${{ env.DB_PORT }}' -U sa -P '${{ env.SA_PASSWORD }}' -i '/var/opt/mssql/scripts/CreateAutoPilotDatabases.sql' -I -C -v TrustServerCertificate=yes | |
| " | |
| - name: Verify Databases Were Created | |
| run: | | |
| docker exec -i $(docker ps -q --filter ancestor=${{ env.DB_IMAGE }}) /opt/mssql-tools18/bin/sqlcmd \ | |
| -S localhost -U sa -P '${{ env.SA_PASSWORD }}' \ | |
| -Q "SELECT name FROM sys.databases" -I -C -v TrustServerCertificate=yes | |
| Validate-Flyway-Pipeline: | |
| name: Run Flyway Pipeline | |
| needs: setup-test-environment | |
| uses: ./.github/workflows/GitHub-Flyway-CICD-Pipeline_Linux.yml | |
| # with: | |
| # db_user: ${{ needs.setup-test-database.outputs.db_user }} | |
| # db_password: ${{ needs.setup-test-database.outputs.db_password }} | |
| # db_jdbc: ${{ needs.setup-test-database.outputs.db_jdbc }} | |
| secrets: inherit # Inherit existing secrets but allow environment overrides | |