Retrieving Models

Sea-ORM provides multiple ways to query data. The Entity trait offers methods like find_by_id, find, and find_one.

// Find by primary key
let user = entity::sys_user::Entity::find_by_id(1001).one(&db).await?;

// Find all
let all_users = entity::sys_user::Entity::find().all(&db).await?;

// Find with conditions
use sea_orm::{Condition, QueryFilter, ColumnTrait};

let users = entity::sys_user::Entity::find()
    .filter(entity::sys_user::Column::Status.eq(1))
    .filter(entity::sys_user::Column::DeptId.eq(Some(10)))
    .all(&db).await?;

// Complex conditions
let users = entity::sys_user::Entity::find()
    .filter(
        Condition::all()
            .add(entity::sys_user::Column::Status.eq(1))
            .add(entity::sys_user::Column::Username.like("%admin%"))
    )
    .all(&db).await?;