flask-mysql

An example for project using flask and mysql stack.

Prerequisites:

Development Environment

Build images,

$ docker compose build

Run containers

$ docker compose up

Visit http://127.0.0.1:5000 for development.

Here are some aspects that require attention, including potential tricks or pitfalls.

Include initdb.sql to create the database.
Set FLASK_APP to let Flask-Migrate to find the app.
Import models in __init__.py file so that Flask-Migrate could detect them.
You need to specify one of the following as an environment variable:
- MYSQL_ROOT_PASSWORD [Used here]
- MYSQL_ALLOW_EMPTY_PASSWORD
- MYSQL_RANDOM_ROOT_PASSWORD
VARCHAR requires a length on dialect mysql

Get into the container

$ docker compose exec web bash

Use the following commands to migrate your database

Init database (Already inited, you could skip this step)

$ flask db init

Migrate to create versions,

$ flask db migrate

Then upgrade new versions,

$ flask db upgrade

Happy Coding!