How to implement Subcategory pattern with Ecto?
I want to have comments field for separate entities via
has_many association, maybe with
:through option. Is it possible?
According to this great StackOverflow I’ve created
entities table and
comments table which relates to
entity_id. Then in my main tables like
performers I create
I’m wondering how to associate post with comments and how to automatically create entity for post on creation.
My schema in short:
# Better to get rid of entity schema if its possible schema "entities" do has_many :comments, Comment end schema "comments" do field :content, :string belongs_to :manager, Manager belongs_to :entity, Manager end schema "posts" do field :title, :string field :content, :string belongs_to :entity, Entity # I'm trying to get rid of this has_many :comments, through: [:entities, :comments] # Want to have something like this end schema "performers" do field :name, :string belongs_to :entity, Entity # I'm trying to get rid of this has_many :comments, through: [:entities, :comments] # Want to have something like this end
Also I can’t find a way to make factory seeds with this db design for
entity table has no relation to
Is the best way to have multiple tables like
performer_comments or even separate tables for each entity comments?