Feature: support trilogy adapter #9

	name: trilogy

	on: [push, pull_request]

	jobs:
	trilogy_test:
	strategy:
	fail-fast: false
	matrix:
	os: [ubuntu-latest]
	ruby: [2.7, 3.0, 3.1, 3.2]
	runs-on: ${{matrix.os}}
	services:
	mysql:
	image: mysql
	ports:
	- 3306:3306
	env:
	MYSQL_ROOT_PASSWORD: root
	MYSQL_USER: github
	MYSQL_PASSWORD: github
	MYSQL_DATABASE: composite_primary_keys_unittest
	options: >-
	--health-cmd "mysqladmin ping -h localhost"
	--health-interval 10s
	--health-timeout 5s
	--health-retries 5
	env:
	BUNDLE_WITHOUT: "db2 oracle sqlserver sqlite postgresql"
	BUNDLE_JOBS: 4
	BUNDLE_PATH: vendor/bundle
	steps:
	- uses: actions/checkout@v3
	- uses: ruby/setup-ruby@v1
	with:
	ruby-version: ${{matrix.ruby}}
	bundler-cache: true
	- name: Setup database config
	run: cp test/connections/databases.ci.yml test/connections/databases.yml
	- name: Prepare databases
	run: bundle exec rake trilogy:rebuild_database
	env:
	MYSQL_ROOT_PASSWORD: root
	- name: Create user, grant privileges, and flush # workaround to resolve https://github.com/trilogy-libraries/activerecord-trilogy-adapter/issues/64
	run: \|
	mysql -h 127.0.0.1 -e "CREATE USER 'test'@'%' IDENTIFIED WITH mysql_native_password BY 'test';" -uroot -p${{ env.MYSQL_ROOT_PASSWORD }}
	mysql -h 127.0.0.1 -e "GRANT ALL PRIVILEGES ON . TO 'test'@'%' WITH GRANT OPTION;" -uroot -p${{ env.MYSQL_ROOT_PASSWORD }}
	mysql -h 127.0.0.1 -e "FLUSH PRIVILEGES;" -uroot -p${{ env.MYSQL_ROOT_PASSWORD }}
	env:
	MYSQL_ROOT_PASSWORD: root
	- name: Trilogy test
	run: bundle exec rake trilogy:test

Provide feedback