Fix copilot-setup-steps.yml #34
This file contains hidden or 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: "Copilot Setup Steps" | |
| # Based on https://docs.github.com/en/copilot/how-tos/use-copilot-agents/coding-agent/customize-the-agent-environment | |
| # Automatically run the setup steps when they are changed to allow for easy validation, and | |
| # allow manual testing through the repository's "Actions" tab | |
| on: | |
| workflow_dispatch: | |
| push: | |
| paths: | |
| - .github/workflows/copilot-setup-steps.yml | |
| pull_request: | |
| paths: | |
| - .github/workflows/copilot-setup-steps.yml | |
| jobs: | |
| # The job MUST be called `copilot-setup-steps` or it will not be picked up by Copilot. | |
| copilot-setup-steps: | |
| runs-on: ubuntu-24.04 | |
| # Install SQL Server via a docker container. | |
| # It's better to do this rather than e.g. use a testcontainer, because then the agent can reuse the same container | |
| # and instance of SQL Server rather than have to start it up each time it needs to iterate and run a test. | |
| services: | |
| mssql: | |
| image: mcr.microsoft.com/mssql/server:2025-latest | |
| env: | |
| ACCEPT_EULA: "Y" | |
| SA_PASSWORD: "${{ secrets.MSSQL_SA_PASSWORD }}" | |
| ports: | |
| - 1433:1433 | |
| options: >- | |
| --health-cmd="/opt/mssql-tools18/bin/sqlcmd -S localhost -U sa -P $SA_PASSWORD -Q 'SELECT 1' -C" | |
| --health-start-period=20s | |
| --health-interval=2s | |
| --health-retries=30 | |
| --health-timeout=5s | |
| permissions: | |
| contents: read | |
| steps: | |
| - name: Checkout | |
| uses: actions/checkout@v5 | |
| - name: Restore | |
| run: ./restore.sh | |
| - name: Export SQL Server connection string for the agent's session | |
| run: echo "Test__SqlServer__DefaultConnection=Server=localhost;Database=master;User=SA;Password=${{ secrets.MSSQL_SA_PASSWORD }};Connect Timeout=60;ConnectRetryCount=0;Trust Server Certificate=true" >> "$GITHUB_ENV" | |
| - name: Run tests (temporary) | |
| run: | | |
| ./activate.sh | |
| dotnet test test/EFCore.SqlServer.FunctionalTests --filter Microsoft.EntityFrameworkCore.Query.Translations.GuidTranslationsSqlServerTest |