Skip to Content
Introduction to Flask-SQLAlchemy

Congratulations on writing your first Flask app with database support!

In this lesson, you have learned how to:

  • import Flask-SQLAlchemy and configure your app to support database connections.
  • create your first model representing a table schema using Flask-SQLAlchemy ORM by declaring classes that extend Model
  • specify attributes of database entities by using Column fields
  • set the primary key Column
  • create a one-to-many relationship by using relationship()
  • specify foreign key columns
  • initialize the database according to the declared models by using create_all()
  • create database entries as instances of the declared Flask-SQLAlchemy classes

We added the Annotation model to the file in order to complete our database schema shown in the first exercise of this lesson. Moreover, we demonstrate for you in the browser how to combine the templates and database queries to list all the books we already put in the database for you. In the next lesson, you will learn how to accomplish this yourself! Excited? Let’s go.

Folder Icon

Sign up to start coding

Already have an account?