![Cover image for Flask[Part 2]: Setting up Database](https://media2.dev.to/dynamic/image/width=1000,height=420,fit=cover,gravity=auto,format=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Flmlxqeefz63y90mqylsw.png)
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------------------------------------
Top comments (0)