Hello, How do I use correctly the many_to_many association with timestamps? I suppose it uses insert_all (or update_all) under the put_assoc and it is the reason it doesn’t provide inserted_at and modified_at. The schemas: defmodule A.User do use Ecto.Schema import Ecto.Changeset alias A…

[image] trashyEx: many_to_many :products, Product, join_through: “users_products” Maybe try replacing it with many_to_many :products, Product, join_through: A.UserProduct

@idi527 Thank you. It worked. Great that is so easy. Last question: With this pattern, should we use the put_assoc with User changeset to modify the UserProduct schema (users_products table) or can we use another way (directly by using the UserProduct repo)?

[image] trashyEx: cs = Ecto.Changeset.put_assoc(cs, :products, [product | user.products]) Do you mean this line? I don’t know how put_assoc works with many to many relationships, if it diffs what you intend to insert with what’s already there (in the table), and makes the repo to insert only …

@idi527 Exactly. I will check it out. I assume you use this pattern (put_assoc). I thought that maybe with complex relations there is a more manual way to deal with it.

Ecto: many_to_many timestamps

Questions & Help Questions

idi527 April 21, 2018, 11:18am 2

Maybe try replacing it with

many_to_many :products, Product, join_through: A.UserProduct