escargot33
Idiomatic way to "merge" duplicate records and reassign foreign keys
I am currently faced with the following problem:
- I have a Person resource
- There are several other resource in the same domain that reference the Person resource via many-to-many and belongs_to relationships
- Occasionally, I find a duplicate Person has been created, meaning there are two Person records, referenced in their own set of relationships, which semantically should be a single record.
- I want to “merge” these two records by deleting one record and designating the other as the "correct” one. All the foreign keys/relationships which involved the deleted record should now point to the remaining “correct record”, if they don’t already exist (set union for many-to-many and overwrite for belongs_to with “correct” id).
Because there are so many relationships and various different resourced involved, my first thought was to use a generic action with reflection on the domain → resources → relationships combined with a to find any relationships which involved a Person and then update them with a strategy defined for each relationship type. What exactly this should look like is unclear to me.
What is the recommended way to do something like this in Ash? Could it make sense to have a generic feature built into Ash to deal with duplicates?
Most Liked
zachdaniel
Your description sounds roughly correct to me. Main advice is to use bulk actions to accomplish this so that it’s efficient and atomic.
Resource
|> Ash.Query.filter(parent_id == ^old_parent_id)
|> Ash.bulk_update(:set_parent_id, %{parent_id: ^parent_id}, ...) # you can use a code interface this way too
Popular in Questions
Other popular topics
Latest Ash Threads
Latest on Elixir Forum
Sponsor Spotlight
Practical resources that improve the lives of professional developers.
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
- #elixirconf-us
- #advent-of-code
- #distillery
- #processes
- #forms
- #api
- #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.
Error tracking for Elixir devs who love to ship. Start your free account.
Develop your skills with books, videos, and courses.
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!"