In this chapte, you'll learn how to set up your database session and add data to the database using SQLAlchemy. By the end, you'll understand how to create a session, add a new record, and save it. After creating the model, you can proceed to creating objects and saving them to the database.

1. Set Up the Session

A session is your primary tool for interacting with the database. Use sessionmaker to bind the engine and create a session:

The Session() function creates an active session that serves as a workspace for staging and preparing database operations before they are committed.

2. Add a New Object

To add data, follow these steps:

1. Create an Object
   Instantiate a model class (e.g., Product) with the required attributes.
2. Stage the Object
   Add the object to the session with add().
3. Save the Changes
   Commit the session to finalize the transaction.