Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.Building SQLAlchemy Objects | SQLAlchemy
Databases in Python
course content

Conteúdo do Curso

Databases in Python

Databases in Python

1. Introduction to SQLite
SQLiteWhat is SQLite3 Library?Connecting to DatabaseCreating a Simple TableChallenge: First Table
2. CRUD
What is CRUD?Creation OperationsRead OperationsUpdate OperationsDelete Operations
3. More About SQLite
PRIMARY KEYData TypesChallenge: Table Design
4. SQLAlchemy
Object–Relational MappingGetting Started with SQLAlchemyData TypesCreating Your First ModelBuilding SQLAlchemy ObjectsReading from DBUpdating to DBDeleting from DB

book
Building SQLAlchemy Objects

In this chapter, 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.
Tarefa
test

Swipe to show code editor

  1. Initialize the database session using Session.
  2. Create a new object of the Product class with the specified attributes.
  3. Add the new object to the session using the appropriate method.
  4. Commit the transaction to save changes to the database.

Switch to desktopMude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixo
Tudo estava claro?

Como podemos melhorá-lo?

Obrigado pelo seu feedback!

Seção 4. Capítulo 5
toggle bottom row

book
Building SQLAlchemy Objects

In this chapter, 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.
Tarefa
test

Swipe to show code editor

  1. Initialize the database session using Session.
  2. Create a new object of the Product class with the specified attributes.
  3. Add the new object to the session using the appropriate method.
  4. Commit the transaction to save changes to the database.

Switch to desktopMude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixo
Tudo estava claro?

Como podemos melhorá-lo?

Obrigado pelo seu feedback!

Seção 4. Capítulo 5
Switch to desktopMude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixo
We're sorry to hear that something went wrong. What happened?
some-alt