Secretmapper
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.
Where Next?
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
- #library
- #deployment
- #erlang
- #testing
- #genserver
- #mix
- #absinthe
- #remote-other
- #otp
- #plug
- #how-to-question
- #macros
- #postgres
- #elixirconf
- #channels
- #exunit
- #discussion
- #code-sync
- #podcasts
- #javascript
- #onsite
- #dialyzer
- #docker
- #authentication
- #umbrella
- #full-time-contract
- #podcasts-by-brainlid
- #ecto-query
- #elixirconf-us
- #ai
- #blog-post
- #elixir-ls
- #phoenix_html
- #iex
- #graphql
- #genstage
- #websockets
- #supervisor
- #advent-of-code
- #distillery
- #processes
- #api
- #forms
- #metaprogramming
- #hex
- #security
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.
Elixir, Erlang & BEAM conferences from Code Sync - join us in 2026!
Bringing learning, work and compliance together since 1987.
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!"
Showing Posts 1 to 1- Show Best Posts
- Show All (oldest first)
- Show All (newest first)
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