i have a list of COMPOUNDS (combinations) that have any number of
COMPOUND_MATERIALS of which both are ITEMS. (this is for a video game
item database)
i want to validate that the compounds are unique by validating it’s
combination of compound_materials does not already exist (a compound can
have multiple combinations of materials)
my tables:
ITEMS
id
name
…
COMPOUNDS (has many compound materials)
id
item_id
COMPOUND_MATERIALS
id
compound_id
item_id
so how would i use this in my model?
validates_uniqueness_of :item_id, scope =>
[‘compound_materials.item_id’, …
something like that but i’m confused because a compound can have any
number of compound_materials so I’m not sure how to write that out.
thanks.