How do I do bulk inserts?

[tasn]

We have a few places in our codebase where we have code like:

let obj_foo = create_object_of_type_foo();
let obj_foo2 = create_object_of_type_foo();
let obj_bar = create_object_of_type_bar();
obj_foo.insert(db).await?;
obj_foo2.insert(db).await?;
obj_bar.insert(db).await?;

How can I make the calls in bulk?

1. Would be great if the first two became one insert into with two values.
2. Would be great if the three of them happen in one go.

The equivalent in sqlalchemy would be:

# There's an add_all equivalent too, but the point is: these don't actually call the db
db.add(obj_foo)
db.add(obj_foo2)
db.add(obj_bar)
# Actually makes the call to the db:
await db.flush()
# This both commits the transaction and flushes (no need to explicitly flush
await db.commit()

[billy1624]

Hey @tasn, I believe you can perform bulk insert for the first two inserts mentioned above.
See https://www.sea-ql.org/SeaORM/docs/basic-crud/insert#insert-many

[tasn]

🤦🏻‍♂️ I went through both the docs and code for a while, not sure how I missed this. Thanks!

[billy1624]

Hahaaa is okay :)