DEV Community

Cover image for Flask[Part 2]: Setting up Database
Tito
Tito

Posted on

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 Alt Text On the database configuration, it is advisable to hide the db details using environment variables.

Now Go ahead the model
Alt Text

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
Enter fullscreen mode Exit fullscreen mode

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)