Secretmapper
Ecto: insert item with assoc (details in body)
This seems like an easy query (and it is) but my Google fu is completely failing me for some reason.
I have a model tag and a model post and I need to create a post, with a tag. Tag ↔ Post is a many_to_many assoc, so I cannot just set tag_id to post for example
student = %Student{}
|> Student.changeset(attrs)
|> Ecto.Changeset.put_assoc(:class_lists, [class_list])
|> Repo.insert()
This does not work, because of a class_list_pkey error - assumedly since Repo.insert tries to insert the class_list as well. However, I cannot just use Repo.update, because I do need to insert the student. What’s the idiomatic way to do this in Ecto?
Right now I’m just running a transaction. Is this really the intended way? I imagine I’m just missing something.
Most Liked
joaquinalcerro
Please note:
“This function should be used when working with the entire association at once (and not a single element of a many-style association) and using data internal to the application.”
This is the ecto documentation example:
tags = Repo.all(from t in Tag, where: t.name in ^params["tags"])
user
|> Repo.preload(:tags)
|> Ecto.Changeset.cast(params) # No need to allow :tags as we put them directly
|> Ecto.Changeset.put_assoc(:tags, tags) # Explicitly set the tags
As you can see, the example works with the entire User association and preloads the tags assosiated to it. So you have a user with tags.
In the other hand you have a new tags list which are associated with to the user in the put_assoc function.
In your situation, you must first load the class_list similar to the example.
hope this helps.
Best regards
Popular in Questions
Other popular topics
Latest on Elixir Forum
Sponsor Spotlight
Build Elixir applications with speed and confidence.
Categories:
Sub Categories:
Forums
Popular Tags
- #ecto
- #liveview
- #troubleshooting
- #learning-elixir
- #deployment
- #library
- #erlang
- #testing
- #genserver
- #mix
- #absinthe
- #remote-other
- #otp
- #plug
- #how-to-question
- #macros
- #postgres
- #channels
- #elixirconf
- #exunit
- #discussion
- #code-sync
- #javascript
- #podcasts
- #onsite
- #dialyzer
- #docker
- #authentication
- #umbrella
- #full-time-contract
- #podcasts-by-brainlid
- #ecto-query
- #elixir-ls
- #phoenix_html
- #iex
- #blog-post
- #graphql
- #genstage
- #ai
- #websockets
- #supervisor
- #advent-of-code
- #elixirconf-us
- #distillery
- #processes
- #forms
- #api
- #metaprogramming
- #security
- #performance
Our Sponsors
Build Elixir applications with speed and confidence.
Supporting innovation across the BEAM ecosystem.
We build reliable cloud platforms for business-critical systems.
Catch errors, track performance, monitor hosts and more.
Real-time error tracking, performance insights, and observability for devs.
Practical resources that improve the lives of professional developers.
Producing high quality Elixir screencasts since 2017.
The deployment platform built for Elixir: PaaS ease, VPS control.
The team behind Membrane, Popcorn, LiveDebugger. Available for hire.
Courses that'll move you from confusion to "Aha, now I get it!"