What are some examples of using Flask with an ORM?

Can you give me some examples of using Flask with an ORM?

Sure! Flask can be used with several ORMs, but SQLAlchemy is the most popular. For example, you can define a model like this:

from flask_sqlalchemy import SQLAlchemy

db = SQLAlchemy()

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

This defines a User model with an ID, username, and email.

How do I create a new user in the database?

To create a new user, you can do the following:

new_user = User(username='john_doe', email='[email protected]')
db.session.add(new_user)
db.session.commit()

This code creates a new user and commits it to the database.

What if I want to query users?

You can query users using the following code:

users = User.query.all()
for user in users:
    print(user.username)

This retrieves all users from the database and prints their usernames.