Is it possible to use an Ecto.Multi to do an insert and an insert_all where the insert_all needs the primary key resulting from the first insert? E.g. creating a parent record with numerous child records in one transaction. The insert option can use a 3rd argument of changeset_or_struct_or_fun, bu…

Yeah you can using Multi.merge/2 (or Multi.run). It looks something like this: Multi.new() |> Multi.insert(:user, User.changeset(%User{}, params)) |> Multi.merge(fn %{user: user} -> # That is the inserted user from the first part of the multi Multi.new() |> Multi.insert_all(:posts, build_inse…

[image] axelson: build_insert_all_posts_changeset What is this function??

It is a function that you would need to define that returns a list of post changesets (and is suitable for insert_all so it might have to set inserted_at and updated_at).

You can’t directly. Repo.*_all are lower level APIs, which don’t support many schema or changeset features. You can map things from changeset to values for insert_all manually if you don’t need any of the not really supported parts.

Thanks for the clarification. So, is there any example on how to insert a bunch of “children” in a Multi with validation? Will open a new thread though. Don’t want to necrobump.

Elixir Programming Language Forum

Ecto.multi with insert and insert_all?

Questions & Help Questions

ca1989 June 1, 2022, 8:33am 6

How can you use insert_all with a list of changeset?