- Create the database. We will use a MySQL server
docker run --name db-example -e MYSQL_ROOT_PASSWORD=example -e MYSQL_DATABASE=example -e MYSQL_USER=example -e MYSQL_PASSWORD=example -p 3306:3306 -d mysql- Create and select a new virtual environment
python3 -m venv .venv
source .venv/bin/activate- Install the needed packages
pip install -r requirements.txtThe following packages are included in the requirements:
- Flask
- flask_sqlalchemy
- flask_script
- flask_migrate
- Add the environment variables
export FLASK_APP=application.py
export APP_SETTINGS="config.Config"
export SQLALCHEMY_DATABASE_URI="mysql://example:[email protected]/example"- Select the .venv as Pyhton interpreter
- Migrate the database
sudo apt install -y python3-mysqldb libmysqlclient-dev
pip install mysqlclient
flask db init
# To re-migrate the database, we could need the next command:
# flask db stamp head
flask db migrate
flask db upgrade- Run the server
flask runThe endpoints are detailed in terraform-example.postman_collection.json
The following environment variables must be set in the Gitlab repository:
# Terraform remote-state
AWS_ACCESS_KEY_ID=
AWS_SECRET_ACCESS_KEY=
# AWS
TF_VAR_secret_key=
TF_VAR_access_key=
# Flask
TF_VAR_FLASK_APP=application.py
TF_VAR_APP_SETTINGS=config.Config
# Database
TF_VAR_dbName=prodExampleDb
TF_VAR_dbUser=prodExampleDb
TF_VAR_dbPass=prodExampleDb