Flask-SQLAlchemy for Efficient Database Management

Flask-SQLAlchemy, a powerful tool for database management in Python, offers a seamless way to interact with databases using object-oriented concepts. By integrating SQLAlchemy's ORM capabilities with Flask, developers can simplify database operations and enhance productivity. This article provides an overview of setting up and configuring databases with Flask-SQLAlchemy, illustrating the benefits of using ORM for database interactions within Python applications.

• Flask-SQLAlchemy
• SQLAlchemy
• ORM
• Database Management
• Python

bras_79 Follow

Uploaded on Sep 07, 2024 | 1 Views

Download Presentation

Please find below an Image/Link to download the presentation.

The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author. Download presentation by click this link. If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.

Presentation Transcript

1. Flask SQLAlchemy Populate CS373 Software Engineering

2. Requirements Install Postgresql Install SQLAlchmey - pip install Flask-SQLAlchemy - pip install psycopg2 Create models.py

3. Outline SQLAlchemy Flask-SQLAlchmey Setup and configure the database

4. SQLAlchmey - Motivation Interacting with a database can be done using SQL syntax Using Flask, one can still use raw SQL Sending a query to the database will be as a strings But, python complier has no way of checking if there is a typo or reference a table that does not exist In Python (flask), every other data structure we use is some type of object. So, why not treat our database queries, tables, and rows as objects as well.

5. SQLAlchmey - Motivation Developer have created Object Relational Mapping (ORM) to handle such a situation. You can think of ORM as a translator, converting code from one form to another. One sends off code written in python The code is transformed by the ORM into SQL and sent off to the database The ORM also gets results from an SQL statement and allows us to use it as an object from within the Python code. SQLAlchemy is an open source ORM for Python with many features. https://www.sqlalchemy.org/library.html#tutorials

6. Flask-SQLAlchmey Flask extension to add support for SQLAlchmey to flask apps Facilitate connecting Python code to Database Provide a mapping between the Python classes with tables in the database

7. Creating a database with SQLAlchmey Configuration code: import all necessary modules - At the beginning of the file Import all modules needed Create a Flask object, have it pointing to the database, create an SQLAlchemy object and bind it to the Flask app - Creating models Class code: used to represent our data in Python Table: used to represent the specific table in the database Mapper: used to connect the columns of the table to the class that represents it - At the end of the file Create (or connect) the database and adds tables and columns

8. Creating a database with SQLAlchmey Configuration code: import all necessary modules - At the beginning of the file Import all modules needed from flask import Flask from flask_sqlalchemy import SQLAlchemy import os Create a Flask object, have it pointing to the database, create an SQLAlchemy object and bind it to the Flask app

9. Creating a database with SQLAlchmey Configuration code: import all necessary modules - At the beginning of the file Import all modules needed Create a Flask object, have it pointing to the database, create an SQLAlchemy object and bind it to the Flask app app = Flask(__name__) app.app_context().push() app.config['SQLALCHEMY_DATABASE_URI'] = 'postgresql://postgres:asd123@localhost:5432/bookdb' app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = True # to suppress a warning message db = SQLAlchemy(app)

10. Creating a database with SQLAlchmey Configuration code: import all necessary modules - At the beginning of the file Import all modules needed Create a Flask object, have it pointing to the database, create an SQLAlchemy object and bind it to the Flask app - Creating models (will do it next) - At the end of the file Create (or connect) the database and adds tables and columns db.create_all()

11. Creating a database with SQLAlchmey Configuration code: import all necessary modules Creating models - Class code: used to represent our data in Python - Table: used to represent the specific table in the database - Mapper: used to connect the columns of the table to the class that represents it class Publisher(db.Model): __tablename__ = 'publisher' name = db.Column(db.String(80), nullable = False) id = db.Column(db.Integer, primary_key = True)) books = db.relationship('Book', backref = 'publisher')

12. Creating a database with SQLAlchmey Configuration code: import all necessary modules Creating models class Book(db.Model): __tablename__ = 'book' title = db.Column(db.String(80), nullable = False) id = db.Column(db.Integer, primary_key = True) description = db.Column(db.String(250)) price = db.Column(db.String(8)) # This property refer to the "id" property in the "publisher" tabel publisher_id = db.Column(db.Integer, db.ForeignKey('publisher.id'))

13. Populate Database Import from models Create a publisher Create a book Query examples

14. Populate Database See create_db.py (1-M)