feat: Switch to mysqlclient from pymysql #19

	name: Test tap-myqsql

	on:
	pull_request:
	types: [opened, synchronize, reopened]
	push:
	branches: [main]
	workflow_dispatch:
	inputs: {}

	jobs:
	tests:
	runs-on: ubuntu-latest
	env:
	PIP_CONSTRAINT: .github/workflows/constraints.txt
	strategy:
	matrix:
	python-version: ["3.8", "3.9", "3.10", "3.11"]

	steps:
	- name: Checkout code
	uses: actions/[email protected]

	- name: Fix Permissions
	run: \|
	chmod 777 -R ./ssh_tunnel/ssh-server-config

	- name: Set up MySQL containers (SSH Included)
	run: \|
	docker compose -f docker-compose.yml up -d

	- name: Debugging GitHub actions
	run: \|
	sudo find / -type s

	- uses: isbang/[email protected]

	- name: Set up Python ${{ matrix.python-version }}
	uses: actions/[email protected]
	with:
	python-version: ${{ matrix.python-version }}

	- name: Upgrade pip
	run: \|
	pip install pip
	pip --version
	- name: Install Poetry
	run: \|
	pip install poetry
	poetry --version
	- name: Install dependencies
	run: \|
	poetry install
	- name: Run pytest
	run: \|
	poetry run pytest
	- name: Run lint
	run: \|
	poetry run tox -e lint


	# To test mysql client 1. docker exec -it 012c /bin/bash (ssh server) 2. apk add mysql mysql-client 3. mysql -h 10.5.0.5 -P 3306 -u root -ppassword

Provide feedback