Mutation of many active models #2613

Jacob-32587 · 2025-05-30T02:44:48Z

Jacob-32587
May 30, 2025

Overview

When using SeaORM I often need to perform bulk mutations and end up using the below template for each entity that needs this kind of behavior. I wanted to avoid needing to make multiple database calls for each active model so I created custom logic for updating/deleting multiple active models. This is super easy but I hate the idea of duplicating code everywhere, I tried to mess around with generics and trait bounds for about an hour (i.e. using a Option<Vec<IntoActiveModel<M>>>) but was unsuccessful.

Questions

Is there functionality for updating/deleting multiple active models in a batch? If not would the project be open
to a PR implementing this functionality?
Is there a generic way I can implement the below template if I only have a list of ActiveModel/ types that implement IntoActiveModel. I wanted to ask before sinking any more time into it.

use crate::prelude::*;
use my_entities::entities::entity_name::*;

/// Insert a list of [ActiveModel] into the database and return the number of effected rows
pub async fn insert_entity_name(
    conn: &DbConn,
    entities: Option<Vec<ActiveModel>>,
) -> Result<u64, DbErr> {
    match entities {
        Some(e) if !e.is_empty() => {
            // Do not return since no field is auto populated by the database
            Entity::insert_many(e).exec_without_returning(conn).await
        }
        _ => Ok(0),
    }
}

/// Update the provided [ActiveModel] list and return the number of effected rows
pub async fn update_entity_name(
    conn: &DbConn,
    entities: Option<Vec<ActiveModel>>,
) -> Result<u64, DbErr> {
    match entities {
        Some(e) if !e.is_empty() => {
            // Create update statements for each item, only attempt to update records
            // that have at least one changed active value
            let query = e
                .into_iter()
                .filter_map(|x| match x.is_changed() {
                    true => {
                        let mut update_str = Update::one(x).build(DbBackend::Postgres).to_string();
                        update_str.push(';');
                        Some(update_str)
                    }
                    false => None,
                })
                .collect::<String>();
            Ok(conn.execute_unprepared(&query).await?.rows_affected())
        }
        _ => Ok(0),
    }
}

/// Delete the list of [ActiveModel] and return the number of rows effected
pub async fn delete_entity_name(
    conn: &DbConn,
    entities: Option<Vec<ActiveModel>>,
) -> Result<u64, DbErr> {
    match entities {
        Some(e) if !e.is_empty() => {
            let query = e
                .into_iter()
                .map(|x| {
                    Entity::delete(x)
                        .into_query()
                        .to_string(PostgresQueryBuilder)
                })
                .collect::<String>();
            Ok(conn.execute_unprepared(&query).await?.rows_affected())
        }
        _ => Ok(0),
    }
}

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Uh oh!

Mutation of many active models #2613

Uh oh!

{{title}}

Uh oh!

Replies: 0 comments

Select a reply

Uh oh!

Uh oh!

Mutation of many active models #2613

Uh oh!

Jacob-32587 May 30, 2025

Overview

Questions

Replies: 0 comments

Jacob-32587
May 30, 2025