SeaORM Documentation

SeaORM provides several ways to query data, including finding all records, filtering, and handling relationships (one-to-one, one-to-many, and many-to-many).

Basic Queries

• Find all: Entity::find().all(db)
• Filter: Use .filter(Entity::COLUMN.name.contains("value"))
• Find by ID: Entity::find_by_id(id).one(db)

Relationship Loading

• Lazy Loading: Use model.find_related(RelatedEntity).one(db) to fetch related models on demand.
• Eager Loading (One-to-One): Use Entity::find().find_also_related(RelatedEntity).all(db) to fetch the main model and an optional related model in one query.
• Eager Loading (One-to-Many/Many-to-Many): Use Entity::find().find_with_related(RelatedEntity).all(db) to fetch the main model and a collection of related models. For many-to-many, this performs two joins and automatically merges rows by the left-side entity.

// Find all
let cakes: Vec<cake::Model> = Cake::find().all(db).await?;

// Filter
let chocolate: Vec<cake::Model> = Cake::find()
    .filter(Cake::COLUMN.name.contains("chocolate"))
    .all(db)
    .await?;

// Find by ID
let cheese: Option<cake::Model> = Cake::find_by_id(1).one(db).await?;

// Lazy loading related models
let fruit: Option<fruit::Model> = cheese.find_related(Fruit).one(db).await?;

// Eager loading (One-to-One)
let cake_with_fruit: Vec<(cake::Model, Option<fruit::Model>)> =
    Cake::find().find_also_related(Fruit).all(db).await?;

// Eager loading (One-to-Many/Many-to-Many)
let cake_with_fillings: Vec<(cake::Model, Vec<filling::Model>)> = Cake::find()
    .find_with_related(Filling)
    .all(db)
    .await?;