What are some examples of queries using Flask-SQLAlchemy?

What are some examples of queries using Flask-SQLAlchemy?

Flask-SQLAlchemy provides a simple way to interact with databases. For example, to query all users, you can use:

users = User.query.all()

How do I filter results in a query?

You can filter results using the filter method. For instance, to find users with a specific name:

users = User.query.filter(User.name == 'John').all()

Can I sort the results?

Yes, you can sort results using the order_by method. For example:

users = User.query.order_by(User.created_at.desc()).all()

What about counting records?

To count records, you can use the count method:

user_count = User.query.count()