add sleep step to allow mysql to start #4

	name: Run Tests
	on:
	push:

	jobs:
	run_pytest:
	runs-on: ubuntu-latest
	steps:
	- uses: actions/checkout@v3

	- uses: mirromutth/[email protected]
	with:
	host port: 3800
	mysql version: '8.0'
	mysql database: 'ghworkflow_testdb'
	mysql root password: 'dbtestpassword'
	mysql user: 'dbtestuser'
	mysql password: 'dbtestpassword'

	- name: Set up Python
	uses: actions/setup-python@v4
	with:
	python-version: 3.11

	- name: Install MySQL Client
	run: sudo apt-get install -y mysql-client

	- name: Wait for MySQL Server to Start
	run: sleep 10

	- name: Add Testing Database
	run: mysql -h localhost -u root -pdbtestpassword -P 3800 -e "CREATE DATABASE testing_ghworkflow_testdb;"

	- name: Copy data into database
	run: mysql -h localhost -u root -pdbtestpassword -P 3800 testing_ghworkflow_testdb < ./archive/latest.sql


	- name: Install Poetry
	uses: snok/install-poetry@v1
	- name: Install Dependencies
	run: \|
	poetry install --no-root --no-interaction
	- name: Run Tests
	run: \|
	poetry run pytest
	env:
	MYSQLDATABASE: 'ghworkflow_testdb'
	MYSQLUSER: 'root'
	MYSQLPASSWORD: 'dbtestpassword'
	MYSQLHOST: 'localhost'
	MYSQLPORT: '3800'

	TESTING_MYSQLDATABASE: 'testing_ghworkflow_testdb'
	TESTING_MYSQLUSER: 'root'
	TESTING_MYSQLPASSWORD: 'dbtestpassword'
	TESTING_MYSQLHOST: 'localhost'
	TESTING_MYSQLPORT: '3800'

Provide feedback