more combos #36

	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: ['24.x', '25.x', '26.x']
	os: [ubuntu-22.04]
	rebar3_version: ["3.22.1"]
	mysql: ["mariadb-11.1", "mariadb-10.11", "mariadb-10.6", "mysql-8.1", "mysql-5.7"]
	pg: ["16rc1", "15", "14", "11"]
	include:
	- os: ubuntu-20.04
	mysql: "mariadb-10.6"
	pg: "14"
	otp_version: '23.x'
	rebar3_version: "3.19.0"

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

	# https://github.com/marketplace/actions/actions-setup-mysql
	- name: Install ${{ matrix.mysql }}
	uses: shogo82148/[email protected]
	#env:
	# ImageOS: ubuntu20
	with:
	mysql-version: ${{ matrix.mysql }}
	## I have no idea why, but if I didn't have the actions-setup-mysql
	## rule set up first, the new user config just wouldn't take.
	user: sql_bridge_user
	password: sql_bridge_test_password

	# 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: Checkout SQL bridge
	uses: actions/checkout@v3

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

Provide feedback