Skip to content

test(query-engine): fix some PlanetScale tests #2114

test(query-engine): fix some PlanetScale tests

test(query-engine): fix some PlanetScale tests #2114

name: "QE: integration tests"
on:
push:
branches:
- main
pull_request:
paths-ignore:
- "!.github/workflows/test-query-engine.yml"
- ".github/**"
- ".buildkite/**"
- "*.md"
- "LICENSE"
- "CODEOWNERS"
- "renovate.json"
concurrency:
group: ${{ github.workflow }}-${{ github.ref }}
cancel-in-progress: true
jobs:
rust-query-engine-tests:
name: "${{ matrix.database.name }} - ${{ matrix.engine_protocol }} ${{ matrix.relation_load_strategy }} ${{ matrix.partition }}"
strategy:
fail-fast: false
matrix:
database:
- name: "vitess_8_0"
single_threaded: true
connector: "vitess"
version: "8.0"
# Arbitrary PostgreSQL version
# we opted for the most recent one, there is no need to have a matrix
- name: "postgres16"
single_threaded: true
connector: "postgres"
version: "16"
- name: "mssql_2022"
single_threaded: false
connector: "sqlserver"
version: "2022"
- name: "sqlite"
single_threaded: false
connector: "sqlite"
version: "3"
- name: "mongodb_4_2"
single_threaded: true
connector: "mongodb"
version: "4.2"
- name: "cockroach_23_1"
single_threaded: false
connector: "cockroachdb"
version: "23.1"
- name: "cockroach_22_2"
single_threaded: false
connector: "cockroachdb"
version: "22.2"
- name: "cockroach_22_1_0"
single_threaded: false
connector: "cockroachdb"
version: "22.1"
engine_protocol: [graphql, json]
relation_load_strategy: [join, query]
partition: ["1/4", "2/4", "3/4", "4/4"]
exclude:
- relation_load_strategy: join
database:
[
{ "connector": "mongodb" },
{ "connector": "sqlite" },
{ "connector": "mssql_2022" },
]
env:
LOG_LEVEL: "info"
LOG_QUERIES: "y"
RUST_LOG_FORMAT: "devel"
RUST_BACKTRACE: "1"
CLICOLOR_FORCE: "1"
CLOSED_TX_CLEANUP: "2"
SIMPLE_TEST_MODE: "1"
QUERY_BATCH_SIZE: "10"
TEST_RUNNER: "direct"
TEST_CONNECTOR: ${{ matrix.database.connector }}
TEST_CONNECTOR_VERSION: ${{ matrix.database.version }}
PRISMA_ENGINE_PROTOCOL: ${{ matrix.engine_protocol }}
PRISMA_RELATION_LOAD_STRATEGY: ${{ matrix.relation_load_strategy }}
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 }} (${{ matrix.engine_protocol }})"
run: make start-${{ matrix.database.name }}
- run: export WORKSPACE_ROOT=$(pwd) && cargo nextest run -p query-engine-tests --partition hash:${{ matrix.partition }} --test-threads=1
if: ${{ matrix.database.single_threaded }}
env:
CLICOLOR_FORCE: 1
- run: export WORKSPACE_ROOT=$(pwd) && cargo nextest run -p query-engine-tests --partition hash:${{ matrix.partition }} --test-threads=8
if: ${{ !matrix.database.single_threaded }}
env:
CLICOLOR_FORCE: 1