What is Flask ORM and how do I use it?

What is Flask ORM and how do I use it?

Flask ORM refers to using Object-Relational Mapping with Flask, typically with SQLAlchemy. It allows you to interact with your database using Python objects instead of SQL queries.

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

Sure! First, install Flask and 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 in 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 the benefits of using ORM?

Using ORM simplifies database interactions, improves code readability, and allows for easier migrations and data manipulation.