feat(psl): exclude unused "MultiSchema" capability in MySQL, simplify multiSchema tests
#1336
Workflow file for this run
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: "SE: integration tests" | |
| on: | |
| push: | |
| branches: | |
| - main | |
| pull_request: | |
| paths-ignore: | |
| - ".github/**" | |
| - "!.github/workflows/test-schema-engine.yml" | |
| - ".buildkite/**" | |
| - "*.md" | |
| - "LICENSE" | |
| - "CODEOWNERS" | |
| - "renovate.json" | |
| # Specific | |
| - "query-engine/**" | |
| concurrency: | |
| group: ${{ github.workflow }}-${{ github.ref }} | |
| cancel-in-progress: true | |
| jobs: | |
| test-mongodb-schema-connector: | |
| name: "${{ matrix.database.name }}" | |
| strategy: | |
| fail-fast: false | |
| matrix: | |
| database: | |
| - name: "mongodb42" | |
| url: "mongodb://prisma:prisma@localhost:27016/?authSource=admin&retryWrites=true" | |
| - name: "mongodb44" | |
| url: "mongodb://prisma:prisma@localhost:27017/?authSource=admin&retryWrites=true" | |
| - name: "mongodb5" | |
| url: "mongodb://prisma:prisma@localhost:27018/?authSource=admin&retryWrites=true" | |
| runs-on: ubuntu-latest | |
| steps: | |
| - uses: actions/checkout@v4 | |
| - uses: actions-rust-lang/setup-rust-toolchain@v1 | |
| - uses: taiki-e/install-action@nextest | |
| - name: Login to Docker Hub | |
| uses: docker/login-action@v3 | |
| continue-on-error: true | |
| with: | |
| username: ${{ secrets.DOCKERHUB_USERNAME }} | |
| password: ${{ secrets.DOCKERHUB_TOKEN }} | |
| - name: "Start ${{ matrix.database.name }}" | |
| run: make start-${{ matrix.database.name }}-single | |
| - run: cargo nextest run -p mongodb-schema-connector | |
| env: | |
| CLICOLOR_FORCE: 1 | |
| TEST_DATABASE_URL: ${{ matrix.database.url }} | |
| test-linux: | |
| name: "${{ matrix.database.name }}" | |
| strategy: | |
| fail-fast: false | |
| matrix: | |
| database: | |
| - name: mssql_2017 | |
| url: "sqlserver://localhost:1434;database=master;user=SA;password=<YourStrong@Passw0rd>;trustServerCertificate=true;socket_timeout=60;isolationLevel=READ UNCOMMITTED" | |
| - name: mssql_2019 | |
| url: "sqlserver://localhost:1433;database=master;user=SA;password=<YourStrong@Passw0rd>;trustServerCertificate=true;socket_timeout=60;isolationLevel=READ UNCOMMITTED" | |
| - name: mssql_2022 | |
| url: "sqlserver://localhost:1435;database=master;user=SA;password=<YourStrong@Passw0rd>;trustServerCertificate=true;socket_timeout=60;isolationLevel=READ UNCOMMITTED" | |
| - name: mysql_5_6 | |
| url: "mysql://root:prisma@localhost:3309" | |
| - name: mysql_5_7 | |
| url: "mysql://root:prisma@localhost:3306" | |
| - name: mysql_8 | |
| url: "mysql://root:prisma@localhost:3307" | |
| - name: mysql_mariadb | |
| url: "mysql://root:prisma@localhost:3308" | |
| - name: postgres9 | |
| url: "postgresql://postgres:prisma@localhost:5431" | |
| - name: postgres10 | |
| url: "postgresql://postgres:prisma@localhost:5432" | |
| - name: postgres11 | |
| url: "postgresql://postgres:prisma@localhost:5433" | |
| - name: postgres12 | |
| url: "postgresql://postgres:prisma@localhost:5434" | |
| - name: postgres13 | |
| url: "postgresql://postgres:prisma@localhost:5435" | |
| - name: postgres14 | |
| url: "postgresql://postgres:prisma@localhost:5437" | |
| - name: postgres15 | |
| url: "postgresql://postgres:prisma@localhost:5438" | |
| - name: postgres16 | |
| url: "postgresql://postgres:prisma@localhost:5439" | |
| - name: cockroach_23_1 | |
| url: "postgresql://prisma@localhost:26260" | |
| - name: cockroach_22_2 | |
| url: "postgresql://prisma@localhost:26259" | |
| - name: cockroach_22_1_0 | |
| url: "postgresql://prisma@localhost:26257" | |
| - name: sqlite | |
| url: sqlite | |
| - name: vitess_8_0 | |
| url: "mysql://root:prisma@localhost:33807/test" | |
| shadow_database_url: "mysql://root:prisma@localhost:33808/shadow" | |
| is_vitess: true | |
| single_threaded: true | |
| runs-on: ubuntu-latest | |
| steps: | |
| - uses: actions/checkout@v4 | |
| - uses: actions-rust-lang/setup-rust-toolchain@v1 | |
| - uses: taiki-e/install-action@nextest | |
| - name: Login to Docker Hub | |
| uses: docker/login-action@v3 | |
| continue-on-error: true | |
| env: | |
| DOCKERHUB_USERNAME: ${{ secrets.DOCKERHUB_USERNAME }} | |
| DOCKERHUB_TOKEN: ${{ secrets.DOCKERHUB_TOKEN }} | |
| if: "${{ env.DOCKERHUB_USERNAME != '' && env.DOCKERHUB_TOKEN != '' }}" | |
| with: | |
| username: ${{ secrets.DOCKERHUB_USERNAME }} | |
| password: ${{ secrets.DOCKERHUB_TOKEN }} | |
| - name: "Start ${{ matrix.database.name }}" | |
| run: make start-${{ matrix.database.name }} | |
| - run: cargo nextest run -p sql-introspection-tests | |
| if: ${{ !matrix.database.single_threaded }} | |
| env: | |
| CLICOLOR_FORCE: 1 | |
| TEST_DATABASE_URL: ${{ matrix.database.url }} | |
| - run: cargo nextest run -p sql-schema-describer | |
| if: ${{ !matrix.database.single_threaded }} | |
| env: | |
| CLICOLOR_FORCE: 1 | |
| TEST_DATABASE_URL: ${{ matrix.database.url }} | |
| - run: cargo nextest run -p sql-migration-tests | |
| if: ${{ !matrix.database.single_threaded }} | |
| env: | |
| CLICOLOR_FORCE: 1 | |
| TEST_DATABASE_URL: ${{ matrix.database.url }} | |
| - run: cargo nextest run -p schema-engine-cli | |
| if: ${{ !matrix.database.single_threaded }} | |
| env: | |
| CLICOLOR_FORCE: 1 | |
| TEST_DATABASE_URL: ${{ matrix.database.url }} | |
| # | |
| # Vitess tests | |
| # | |
| - run: cargo nextest run -p sql-introspection-tests --test-threads=1 | |
| if: ${{ matrix.database.is_vitess }} | |
| env: | |
| CLICOLOR_FORCE: 1 | |
| TEST_DATABASE_URL: ${{ matrix.database.url }} | |
| TEST_SHADOW_DATABASE_URL: ${{ matrix.database.shadow_database_url }} | |
| - run: cargo nextest run -p sql-migration-tests --test-threads=1 | |
| if: ${{ matrix.database.is_vitess }} | |
| env: | |
| CLICOLOR_FORCE: 1 | |
| TEST_DATABASE_URL: ${{ matrix.database.url }} | |
| TEST_SHADOW_DATABASE_URL: ${{ matrix.database.shadow_database_url }} | |
| RUST_LOG: debug | |
| - run: cargo nextest run -p schema-engine-cli --test-threads=1 | |
| if: ${{ matrix.database.is_vitess }} | |
| env: | |
| CLICOLOR_FORCE: 1 | |
| TEST_DATABASE_URL: ${{ matrix.database.url }} | |
| TEST_SHADOW_DATABASE_URL: ${{ matrix.database.shadow_database_url }} | |
| # | |
| # Single threaded tests (excluding Vitess) | |
| # | |
| - run: cargo nextest run -p sql-schema-describer --test-threads=1 | |
| if: ${{ !matrix.database.is_vitess && matrix.database.single_threaded }} | |
| env: | |
| CLICOLOR_FORCE: 1 | |
| TEST_DATABASE_URL: ${{ matrix.database.url }} | |
| - run: cargo nextest run -p sql-introspection-tests --test-threads=1 | |
| if: ${{ !matrix.database.is_vitess && matrix.database.single_threaded }} | |
| env: | |
| CLICOLOR_FORCE: 1 | |
| TEST_DATABASE_URL: ${{ matrix.database.url }} | |
| - run: cargo nextest run -p sql-migration-tests --test-threads=1 | |
| if: ${{ !matrix.database.is_vitess && matrix.database.single_threaded }} | |
| env: | |
| CLICOLOR_FORCE: 1 | |
| TEST_DATABASE_URL: ${{ matrix.database.url }} | |
| RUST_LOG: debug | |
| - run: cargo nextest run -p schema-engine-cli --test-threads=1 | |
| if: ${{ !matrix.database.is_vitess && matrix.database.single_threaded }} | |
| env: | |
| CLICOLOR_FORCE: 1 | |
| TEST_DATABASE_URL: ${{ matrix.database.url }} | |
| test-windows: | |
| strategy: | |
| fail-fast: false | |
| matrix: | |
| db: | |
| - name: "mysql-lts" | |
| url: "mysql://root@localhost:3306?connect_timeout=20&socket_timeout=60" | |
| - name: "mariadb" | |
| url: "mysql://root@localhost:3306?connect_timeout=20&socket_timeout=60" | |
| rust: | |
| - stable | |
| os: | |
| - windows-latest | |
| runs-on: ${{ matrix.os }} | |
| name: "${{ matrix.db.name }} on Windows" | |
| steps: | |
| - uses: actions/checkout@v4 | |
| - uses: actions-rust-lang/setup-rust-toolchain@v1 | |
| - uses: taiki-e/install-action@nextest | |
| - uses: actions/cache@v4 | |
| with: | |
| path: | | |
| ~/.cargo/registry | |
| ~/.cargo/git | |
| target | |
| key: ${{ runner.os }}-cargo-${{ matrix.rust }}-${{ hashFiles('**/Cargo.lock') }} | |
| - name: Install ${{ matrix.db.name }} | |
| run: | | |
| iwr -useb 'https://raw.githubusercontent.com/scoopinstaller/install/master/install.ps1' -outfile 'install.ps1' | |
| .\install.ps1 -RunAsAdmin | |
| scoop install sudo | |
| scoop install ${{ matrix.db.name }} | |
| sudo mysqld --install | |
| sudo sc start MySQL | |
| - name: Run tests | |
| run: cargo nextest run -p sql-migration-tests | |
| env: | |
| TEST_DATABASE_URL: ${{ matrix.db.url }} |