BryanJBryce

BryanJBryce

Filtered many_to_many Relationships with metadata on join Resource

I’m building a point of sale system that supports multiple Stores. Stores share global Product, Variant and Modifier definitions.

Since prices can be different per store I have a Join Resource between Variant and Store and Modifier and Store which each have an Attribute that stores price info.

Typically when reading this data I’m only interested in seeing the set of data (in this specific instance price data) related to a specific store. So, ideally I could read all data in this hierarchy for a specific Store.

Is there a way to load these relationships so that they load the data specific to a single Store?

I know you can filter on relationships, this would likely be a custom read action? How would you make that action get used by graphql resolvers, for instance? Or for when Store is read with load that loads those?

Marked As Solved

zachdaniel

zachdaniel

Creator of Ash

Hmm…I generally suggest trying to avoid making special actions that load relationships with special filters, because that breaks a lot of things down the line. You can do it on demand pretty easily with things like: load(real: Ash.Query.filter(Related, store_id == ^store_id)), and that is something that is also supported by AshGraphql automatically, i.e you’d be able to do this:

getStore(id: "id"){
  relationship(filter: {....}) {...}
}

Often to solve for this you expose the underlying has_many relationship by defining it yourself and pointing the many_to_many to use it, i.e

has_many :foo_joins, FooJoin do
  ...
end

many_to_many :foo, Foo do
  join_relationship :foo_joins
  ...
end

Then clients can easily filter on join attributes or on destination attributes.

Ultimately, if you decide you want something special here my suggestion would be to go with a calculation that returns instances of a resource. For example:

calculate :stuff_you_want, {:array, :struct}, CalculationModule do
  constraints [items: [instance_of: SomeResource]]
end

Where Next?

Popular in Questions Top

beno
I will often find my self writing things similar to: case some_value do nil -> something() "" -> something() _ -> somethi...
New
lastday4you
I wanted to check elixir version in phoenix because i found that my elixir is 1.5 but when i use Enum.chunk_by it said the function is un...
New
qwerescape
Is there a way to get the call stack or stack trace at any point in the code? Not from exceptions, but an expression that returns how the...
New
electic
Hi, I am new to Elixir. I am trying to use the DateTime component to insert a date into MySQL however the there seems to be no way to fo...
New
tduccuong
Hi, is there any work on GUI with Elixir, that is similar to Electron/Javascript? My idea is to bundle Phoenix and BEAM into a single se...
New
fireproofsocks
I’m working on defining a simple Ecto schema for a table (in PostGres), but I don’t see where I can define a column as NOT NULL. Conside...
New
stefanluptak
Hello everybody, usually, I use a 29" ultra-wide monitor for VSCode which can easily accomodate explorer (files panel) + file with code ...
New
jerry
Good day to you all. I have been struggling to get a query involving like and ilike to work. Can anyone assist me on this, please? pro...
New
vrod
I am using the Starship cross-shell prompt – it seems pretty nice, but I get some errors: [WARN] - (starship::utils): Executing command ...
New
Brian
What is the proper way to load a module from a file in to IEX? In the python world, doing something like this pretty standard: from ....
New

Other popular topics Top

axelson
This post is a wiki (feel free to hit the edit button near the bottom right of this post to add your own changes!) This post collects co...
239 48342 226
New
electic
Hi, I am new to Elixir. I am trying to use the DateTime component to insert a date into MySQL however the there seems to be no way to fo...
New
msaraiva
Surface is an experimental library built on top of Phoenix LiveView and its new LiveComponent API that aims to provide a more declarative...
564 43757 214
New
belgoros
I’m not a pro in using Regex and can’t figure out why the following behaviour happens, especially if we take into account the difference ...
New
freewebwithme
Using vs code and installed ElixirLS: support and debugger. And I got an error popped up on start up says Failed to run ‘elixir’ comma...
New
aesmail
Hello guys, I have finally made it. I created an admin interface for a framework. It’s been on my todo list for years and with the curre...
New
romenigld
I am trying to run a deploy with docker and I successfully runned with this command: docker build -t romenigld/blog-prod . but when I t...
New
klo
Got a question about when to concat vs. prepending items to list then reversing to achieve appending. So i know lists boil down to [1 | ...
New
openscript
Hello! Sorry for this astonishing simple question, but I’m really stuck. I try to set up the intellij-elixir plugin, but I don’t know ho...
New
dokuzbir
I want to highlight html closing tags when i click a html tag. That works in .html files but doesnt work for html.eex templates. How can...
New

Latest on Elixir Forum

Elixir Forum

We're in Beta

About us Mission Statement