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

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

Flask-ORM is an Object Relational Mapping tool for Flask applications, allowing you to interact with databases using Python objects.

Can you give me an example of how to set it up?

Sure! First, install Flask-SQLAlchemy. Then, create a Flask app and configure the database URI. Here's a basic setup:

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 using Flask-ORM?

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 it?

Common operations include creating, reading, updating, and deleting records (CRUD). You can use methods like add(), query(), and delete().