What is Flask-SQLAlchemy and how do I use it?

What is Flask-SQLAlchemy and how do I use it?

Flask-SQLAlchemy is an extension for Flask that adds support for SQLAlchemy, a powerful SQL toolkit. It simplifies database interactions.

Can you show me a basic example of how to set it up?

Sure! First, install Flask-SQLAlchemy using pip. Then, create a Flask app and initialize SQLAlchemy like this:

from flask import Flask
from flask_sqlalchemy import SQLAlchemy

app = Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///example.db'
db = SQLAlchemy(app)

How do I define a model in Flask-SQLAlchemy?

You can define a model by creating a class that inherits from db.Model. For example:

class User(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    username = db.Column(db.String(80), unique=True, nullable=False)

What are some common operations I can perform with my models?

You can perform operations like creating, querying, updating, and deleting records. For example, to add a new user:

new_user = User(username='example')
db.session.add(new_user)
db.session.commit()