How to insert data in different tables for one event?

[MMore]

Hello,

first of all, thanks a lot for this nice library :)

I was wondering how to insert data in different tables for one event? For instance, two Ecto.Multi.insert() results in seeing only the result of the last one in the table.

[anderslemke]

Hi @MMore,

I don't think there should be anything preventing writing to several tables in response to one event.

Maybe you can share the code that doesn't behave as expected?

[yordis]

This is possible already thru Ecto.Multi.insert/4

project(%V1.SomethingHappened{} = event, metadata, fn multi ->
    multi
    |> Ecto.Multi.insert(:something, &MySchema%{})
    |> Ecto.Multi.insert(:something, &MyOtherSchema%{})
end)