Add working directory for database migrations #25

	name: Django CI

	on:
	push:
	branches: [ "main" ]
	pull_request:
	branches: [ "main" ]

	jobs:
	build:
	runs-on: ubuntu-latest

	services:
	mysql:
	image: mysql:8.3
	env:
	MYSQL_ROOT_PASSWORD: root
	MYSQL_DATABASE: activmind_test
	MYSQL_PASSWORD: root
	options: --health-cmd="mysqladmin ping" --health-interval=10s --health-timeout=5s --health-retries=3

	strategy:
	max-parallel: 4
	matrix:
	python-version: [3.9]

	steps:
	- uses: actions/checkout@v3
	- name: Set up Python ${{ matrix.python-version }}
	uses: actions/setup-python@v3
	with:
	python-version: ${{ matrix.python-version }}
	- name: Install Dependencies
	working-directory: ./activmindback
	run:
	python -m pip install --upgrade pip
	pip install -r requirements.txt
	# - name: Set up MySQL Database
	# working-directory: ./activmindback
	# run: \|
	# python -m pip install mysql-connector-python
	# python -c "import mysql.connector; conn = mysql.connector.connect(user='root', password='root', host='localhost', port='3306', database='activmind'); cursor = conn.cursor(); cursor.execute('CREATE DATABASE IF NOT EXISTS activmind')"
	# python manage.py makemigrations
	# python manage.py migrate
	- name: Run database migrations
	working-directory: ./activmindback
	run: \|
	python manage.py migrate --database=test
	- name: Run Tests
	working-directory: ./activmindback
	run: python manage.py test

Provide feedback