Pistrie
How do I treat records in a tenant as a relationship?
If I have Users and Posts, and Posts are part of the User tenant:
# User
postgres do
# ...
manage_tenant do
template ["user_", :id]
end
end
# Post
multitenancy do
strategy :context
end
It wouldn’t make much sense to have a has_many/belongs_to relationship between these two resources, as Posts are inherently part of the User; they live in the User’s schema.
However, you’d miss the user.posts key. Is it possible to have this relationship without needing to (redundantly) adding the relationships and specifying the user_id on the Post?
Marked As Solved
zachdaniel
You can use no_attributes? true on the relationship definition, meaning “all the posts are related”, and then when accessing user and loading data you’d set a tenant which scopes the results to only the relevant posts.
Popular in Questions
Other popular topics
Latest Ash Threads
Latest on Elixir Forum
Sponsor Spotlight
Develop your skills with books, videos, and courses.
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!"