Isim #130

	name: FPSim2 SQLAlchemy tests
	on:
	workflow_dispatch:
	pull_request:
	branches:
	- master
	push:
	branches:
	- master

	jobs:
	# Label of the container job
	container-job:
	# Containers must run in Linux based operating systems
	runs-on: ubuntu-latest
	# Docker Hub image that `container-job` executes in
	container: python:3.11-bullseye

	# Service containers to run with `container-job`
	services:
	# Label used to access the service container
	postgres:
	# Docker Hub image
	image: postgres
	# Provide the password for postgres
	env:
	POSTGRES_PASSWORD: postgres
	# Set health checks to wait until postgres has started
	options: >-
	--health-cmd pg_isready
	--health-interval 10s
	--health-timeout 5s
	--health-retries 5

	mysql:
	image: mysql:8.0
	env:
	MYSQL_ROOT_PASSWORD: root
	MYSQL_DATABASE: mysql
	options: >-
	--health-cmd="mysqladmin ping"
	--health-interval=10s
	--health-timeout=5s
	--health-retries=3

	steps:
	# Downloads a copy of the code in your repository before running CI tests
	- name: Check out repository code
	uses: actions/checkout@v3

	- name: Install dependencies
	run: \|
	python -m pip install --upgrade pip
	pip install pytest psycopg2 mysqlclient
	pip install -e .

	- name: Run PostgreSQL and MySQL tests
	run: \|
	pytest
	# # Environment variables used by the tests
	# env:
	# # The hostname used to communicate with the PostgreSQL service container
	# POSTGRES_HOST: postgres
	# # The default PostgreSQL port
	# POSTGRES_PORT: 5432

Provide feedback