"manual" assocs with Ecto

[Sebb]

So, now I have to use a database, its been a long time since I did that, but I know some SQL.
First steps were easy with Ecto+sqlite (dont even have to install a DB), but I struggle with the assocs stuff.

There is this interesting post in a thread about this:

https://elixirforum.com/t/not-feeling-ecto-i-find-it-brings-unnecessary-complexity-with-it/52817/8?u=sebb

@"benwilson512

I also do not particularly enjoy how changesets and associations work together. Fortunately, they’re far more optional in Ecto than a lot of other frameworks. You can simply construct sub-entities directly with their own changesets and insert them manually, which is generally what I do.

I’d like to try this approach, but I do not really understand what to do…!?
How would the examples in the Ecto assoc guide look like with this approach?

Can we do all that (without manually writing SQL)?

Will the queries shown in the guide still work?

[LostKobrakai]

@Sebb

How would the examples in the Ecto assoc guide look like with this approach?

Use Ecto.Multi extensively or manually compose (non nested) inserts within Repo.transaction(fn -> end).

[Sebb]

thanks, I’ll look into this.