chore(deps): Bump certifi from 2024.2.2 to 2024.7.4 #176

	name: Test tap-myqsql

	on:
	push:
	branches: [main]
	paths:
	- tap_mysql/**
	- tests/**
	- poetry.lock
	- pyproject.toml
	- .github/workflows/test.yml
	pull_request:
	branches: [main]
	paths:
	- tap_mysql/**
	- tests/**
	- poetry.lock
	- pyproject.toml
	- .github/workflows/test.yml
	workflow_dispatch:

	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", "3.12"]

	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

	- uses: isbang/[email protected]

	- name: Set up Python ${{ matrix.python-version }}
	uses: actions/setup-python@v5
	with:
	python-version: ${{ matrix.python-version }}

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

	# 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