Hackforge Academy

Explanation

Flask-SQLAlchemy integrates SQLAlchemy ORM with Flask applications and simplifies database operations.

Code:

from flask_sqlalchemy import SQLAlchemy

db = SQLAlchemy()

db.init_app(app)

Explanation

Configure the database connection using SQLAlchemy's database URI.

Code:

app.config['SQLALCHEMY_DATABASE_URI'] = \
    'sqlite:///users.db'

Explanation

Create a model class that represents a database table.

Code:

class User(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(100), nullable=False)
    email = db.Column(db.String(150), unique=True)

Explanation

Create database tables from the registered models during application setup.

Code:

with app.app_context():
    db.create_all()

Explanation

SQLAlchemy allows developers to insert and query records using Python objects.

Code:

user = User(
    name='Praveen',
    email='praveen@example.com'
)

db.session.add(user)
db.session.commit()

users = User.query.all()