Add :plan explain option for Postgres (#604)
#1584
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: CI | |
| on: [push, pull_request] | |
| jobs: | |
| test: | |
| name: unittest | |
| runs-on: ubuntu-latest | |
| env: | |
| MIX_ENV: test | |
| strategy: | |
| fail-fast: false | |
| matrix: | |
| include: | |
| - elixir: 1.15.6 | |
| otp: 24.3.4.13 | |
| - elixir: 1.15.6 | |
| otp: 26.1.2 | |
| lint: lint | |
| steps: | |
| - name: Checkout | |
| uses: actions/checkout@v4 | |
| - name: Install Elixir and Erlang | |
| uses: erlef/setup-beam@v1 | |
| with: | |
| elixir-version: ${{ matrix.elixir }} | |
| otp-version: ${{ matrix.otp }} | |
| - name: Restore deps and _build cache | |
| uses: actions/cache@v3 | |
| with: | |
| path: | | |
| deps | |
| _build | |
| key: ${{ runner.os }}-${{ matrix.elixir }}-${{ matrix.otp }}-${{ hashFiles('**/mix.lock') }} | |
| restore-keys: | | |
| ${{ runner.os }}-${{ matrix.elixir }}-${{ matrix.otp }}- | |
| - name: Install dependencies | |
| run: mix deps.get | |
| - name: Check unused dependencies | |
| run: mix deps.unlock --check-unused | |
| if: ${{ matrix.lint }} | |
| - name: Check formatting | |
| run: mix format --check-formatted | |
| if: ${{ matrix.lint }} | |
| - name: Compile | |
| run: mix compile | |
| - name: Run tests | |
| run: mix test | |
| test-postgres: | |
| name: postgres integration test | |
| runs-on: ubuntu-latest | |
| strategy: | |
| fail-fast: false | |
| matrix: | |
| elixirbase: | |
| - "1.11.4-erlang-21.3.8.24-alpine-3.13.3" | |
| postgres: | |
| - "15.0" | |
| - "11.11" | |
| - "9.6" | |
| - "9.5" | |
| steps: | |
| - uses: earthly/actions-setup@v1 | |
| - uses: actions/checkout@v3 | |
| - name: test ecto_sql | |
| run: earthly -P --ci --build-arg ELIXIR_BASE=${{matrix.elixirbase}} --build-arg POSTGRES=${{matrix.postgres}} +integration-test-postgres | |
| test-mysql: | |
| name: mysql integration test | |
| runs-on: ubuntu-latest | |
| strategy: | |
| fail-fast: false | |
| matrix: | |
| elixirbase: | |
| - "1.11.4-erlang-21.3.8.24-alpine-3.13.3" | |
| mysql: | |
| - "5.7" | |
| - "8.0" | |
| steps: | |
| - uses: earthly/actions-setup@v1 | |
| - uses: actions/checkout@v3 | |
| - name: test ecto_sql | |
| run: earthly -P --ci --build-arg ELIXIR_BASE=${{matrix.elixirbase}} --build-arg MYSQL=${{matrix.mysql}} +integration-test-mysql | |
| test-mssql: | |
| name: mssql integration test | |
| runs-on: ubuntu-latest | |
| strategy: | |
| fail-fast: false | |
| matrix: | |
| elixirbase: | |
| - "1.11.4-erlang-21.3.8.24-alpine-3.13.3" | |
| mssql: | |
| - "2017" | |
| - "2019" | |
| steps: | |
| - uses: earthly/actions-setup@v1 | |
| - uses: actions/checkout@v3 | |
| - name: test ecto_sql | |
| run: earthly -P --ci --build-arg ELIXIR_BASE=${{matrix.elixirbase}} --build-arg MSSQL=${{matrix.mssql}} +integration-test-mssql |