tests-workflow.yml

name: Test SQL Bridge MySQL/PostGreSQL
on: push

jobs:
  linux:
    name: Test on OTP ${{ matrix.otp_version }} and ${{ matrix.os }}
    runs-on: ${{ matrix.os }}

    strategy:
      matrix:
        #otp_version: [23, 24, 25.0, 26]
        otp_version: [25.0]
        os: [ubuntu-latest]
        include:
          #          - mysql: mysql-5.7
          #            pg: 11
          #          - mysql: mysql-8.1
          #            pg: 12
          #          - mysql: mariadb-10.1
          #            pg: 13
          - mysql: mariadb-10.7
            pg: 14
              #          - mysql: mariadb-10.11
              #            pg: 15
              #          - mysql: mariadb-11.1
              #            pg: 16
              #

              #container: erlang:${{ matrix.otp_version }}

    steps:
      - name: Install OTP ${{matrix.otp_version}}
        uses: erlef/setup-beam@v1
        with:
          otp-version: ${{ matrix.otp_version}}

      - name: Install a few dependencies
        run: |
          sudo apt update -y
          sudo apt install -y -q zstd build-essential

      # https://github.com/marketplace/actions/actions-setup-mysql
      - name: Install ${{ matrix.mysql }}
        uses: shogo82148/actions-setup-mysql@v1.23.0
          #env:
          #  ImageOS: ubuntu20
        with:
          mysql-version: ${{ matrix.mysql }}
          root-password: mysql

      # https://github.com/marketplace/actions/setup-postgresql-with-postgresql-extensions-and-unprivileged-user
      - name: Install Postgres ${{ matrix.pg }}
        uses: Daniel-Marynicz/postgresql-action@master
        with:
          postgres_image_tag: ${{ matrix.pg }}

            #      - name: Install database tools in container
            #        run: |
            #          apt update -y
            #          apt install -y postgresql-client mariadb-client

      - name: Checkout SQL bridge
        uses: actions/checkout@v3

      - name: Load databases & Run SQL Bridge eunit tests
        run: make ci
        env:
          MYSQLHOST: localhost
          MYSQLPWD: mysql
          MYSQLUSER: root
          PGHOST: localhost
          PGUSER: postgres
          PGPASSWORD: postgres