Implement Database Model using SQLAlchemy

[Dhud6]

Summary

Based on the ERD diagram of the database referenced by the task Model the MariaDB Database, implement the database using [SQLAlchemy] in the MariaDB Docker container. If you use SQLAlchemy, it will automatically create the database tables for you when you create the ORM mapped classes. The database persists across builds and starting and stopping the docker containers because the database is mapped to a persistent volume (the db folder). You will not lose progress when you shut down the docker containers with docker compose down. Make sure you shutdown the docker containers before pushing to the GitHub repository.

SQLAlchemy Reference

• Jersin Jose Tutorial Playlist: SQLAlchemy ORM Tutorial
• NeuralNine Tutorial: SQLAlchemy Turns Python Objects Into Database Entries
• Full SQLAlchemy Tutorial
• SQLAlchemy ORM Quickstart
• SQLAlchemy & MariaDB
• MariaDB with SQLAlchemy (note that his uses virtual environments, venvs, which we are not using)

Docker Summary

• You can start the dockers with docker compose up --detach
• You can enter the MariaDB docker container with docker exec -u 0 -it comfort-airlines-db-1 bash
• You can enter the database with mariadb -u root -p (the password is toor)
• You can stop the docker containers with docker compose down

Group Questions

Foobar?