OLTP API for the insertion and analysis of company employees, departments, and jobs

• Install Python
• Install Docker Desktop
• Clone repository

1. Open the terminal and go inside the project folder.

cd /../../project_folder

2. Run the following command to run the containers 3 containers:

• Flask API (port 5000)
• MySQL (port 3306)
• phpMyAdmin (port 80)

docker compose up

3. Start using the API 🤗.

http://localhost:5000

4. (Optional) You can try the version hosted on Azure 🫡.

http://52.226.230.142:5000 # API
# or
http://52.226.230.142 # phpMyAdmin

If you have the containers up and running, follow the next steps to execute the test cases:

1. Go inside the "jcompany" folder

cd jcompany

2. Create the virtual environment (venv) and install all the dependencies.

python -m venv venv
# Run "activate" script inside the "venv/Scripts" folder
pip install --upgrade pip
pip install -r requirements.txt

3. Run the tests

py manage.py test