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.
Trending in Questions
Other Trending Topics
Latest on Elixir Forum
Sponsor Spotlight
We build reliable cloud platforms for business-critical systems.
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
- #elixirconf-us
- #websockets
- #supervisor
- #advent-of-code
- #distillery
- #processes
- #api
- #forms
- #metaprogramming
- #hex
- #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.
Error tracking, logs, uptime, and Just Enough APM. Built for developers.
Practical resources that improve the lives of professional developers.
Develop your skills with books, videos, and courses.
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!"
First Post!
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:
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