How do I update data in Flask using SQLAlchemy?

How do I update data in Flask using SQLAlchemy?

To update data in Flask using SQLAlchemy, you first need to query the object you want to update, modify its attributes, and then commit the changes.

Can you show me a code example?

Sure! Here's a simple example:

from yourapp import db

# Assuming you have a User model
user = User.query.get(user_id)
user.name = 'New Name'
db.session.commit()

What if I want to update multiple fields?

You can update multiple fields by assigning new values to each attribute before committing. For example:

user.email = '[email protected]'
user.age = 30

Is there a way to handle errors during the update?

Yes, you can use a try-except block to handle exceptions. For example:

try:
    db.session.commit()
except Exception as e:
    db.session.rollback()
    print(f'Error: {e}')