marcelfahle
Query options for unsafe_validate_unique/4
Hey guys, I ran into a slight issue today:
I’m currently building a multi-tenant setup using foreign keys, similar to the docs.
The tenant key is enforced for every query on the repo level using prepare_query (as seen here), which means I have to provide either a tenant key or a skip parameter to my queries.
This doesn’t work, though, when doing validations with unsafe_validate_unique/4 (and maybe others) because it doesn’t let me add options to the query.
I removed the validation for now and will wire up my own check on uniqueness. Still, I was just curious how you guys would solve such problems, as I’m sure other functions also execute queries under the hood where I can’t provide my tenant Infos.
Thanks! 
Most Liked
al2o3cr
I’m not sure how it would interact with the prepare_query plumbing, but making the validation match [:field_that_should_be_unique, :org_id] (where org_id is the tenant FK) seems like it would get the right query.
andyjones11
Just for reference I ran into the same problem today and found that a fix for this should be coming in the next Ecto release. unsafe_validate_unique/4 has been updated to accept a keyword list of repo_opts.
See the change here: ecto/lib/ecto/changeset.ex at 0b990278ca6b418c0137dd0bdf9f0c5003062629 · elixir-ecto/ecto · GitHub
joges
I ran into the same problem and could fix it based on your post:
unsafe_validate_unique(:email, MyApp.Repo, repo_opts: [skip_org_id: true])
Thx andyjones11!
Popular in Questions
Other popular topics
Latest Phoenix Threads
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.
Develop your skills with books, videos, and courses.
Enabling companies to succeed by building software people love.
Courses that'll move you from confusion to "Aha, now I get it!"