CRUD Functionality

id: 1731415033
Date: Nov. 12, 2024, 12:38 p.m.
Author: Donald F. Elger

SQLAlchemy CRUD Operations

Here’s how you can perform the basic CRUD operations in SQLAlchemy:

Create

# Assuming `obj` is an instance of your model class
session.add(obj)
session.commit()

Read

# To read all records
records = session.query(Class).all()

# To filter specific records
record = session.query(Class).filter_by(attribute='value').first()

Update

# Fetch the record you want to update
record = session.query(Class).filter_by(attribute='value').first()

# Update the attribute(s)
if record:
    record.attribute = 'new_value'
    session.commit()

Delete

# Fetch the record you want to delete
record = session.query(Class).filter_by(attribute='value').first()

# Delete the record
if record:
    session.delete(record)
    session.commit()