How do I add data to my Flask app using SQLAlchemy?

How do I add data to my Flask app using SQLAlchemy?

To add data using SQLAlchemy in Flask, you first need to create an instance of your model and then add it to the session.

Can you show me a code example?

Sure! Here's a simple example:

new_user = User(name='John Doe', email='[email protected]')
db.session.add(new_user)
db.session.commit()

What if I want to add multiple records at once?

You can create a list of instances and use db.session.add_all() like this:

users = [User(name='Alice'), User(name='Bob')]
db.session.add_all(users)
db.session.commit()

Is there a way to handle errors when adding data?

Yes, you can use a try-except block to catch exceptions during the commit process. This way, you can handle errors gracefully.