formingform
Can use on_conflict to backup and update record?
I’ve encountered this case：I want insert a record to ‘users’ table（columns: user_name, class, score), if the primary key: user_name is duplicated, I want to backup the record to table 'users_history‘ and update the ‘users’ table record, and further more, the ‘users_history’ table also has a primar key: user_name, while backuping record to ‘users_history’, if the user_name is duplicated, just update the ‘users_history’ too.
So, How can do this by Ecto? Thanks.
First Post!
smathy
No, the on_conflict action can only update columns in the same table. I can think of two decent options here:
- In a transaction: try a normal insert, rescue the
ConstraintError, upsert the history record, update the users record. - Create a DB trigger to make the
users_historychanges on update (you’d have the trigger function perform an upsert), then you can just do your upsert onusersand the DB will handle the history upsert.
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.
Error tracking for Elixir devs who love to ship. Start your free account.
Producing high quality Elixir screencasts since 2017.
Enabling companies to succeed by building software people love.
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!"