Flask[Part 2]: Setting up Database

Introduction

This article is a continuation of our Previous Post where we tackled setting up working directory, working environment , installing flask and run a flask app.
In this article we will focus on creating models , migrations and testing database

Prerequisite

• python 3+ installed
• Flask Installed; A working flask app
• PostgreSQL optional; work with DBMS of your choice

Before you start, create a model.py file in project folder and install ,import the following packages:

• flask-login
• flask-sqlalchemy
• flask-migrate
• itsdangerous On the database configuration, it is advisable to hide the db details using environment variables.

Now Go ahead the model

After creating our model and ensuring that the DBMS of your choice is working, carry out a migration:

(env) tito@tito-HP-2000-Notebook-PC:~/Desktop/Milestone/Mile_Proj$ flask db init
(env) tito@tito-HP-2000-Notebook-PC:~/Desktop/Milestone/Mile_Proj$ flask db migrate

The migrations will automatically create tables in your Database.
Thank you for following .
The next article , I will handle forms for collecting data.
------------------------------------ NEXT ARTICLE------------------------------------