Consider a simple situation of users
and subjects
related with a pivot table named user_subjects
, now if I have to fetch all the users who have opted for a certain subject. What is the best way to achieve this in AdonisJs 5. Following is the solution I found.
const subject = await Subject.find(req.params.id);
const users = await subject.related('users').query();
There is nothing wrong with the above approach but I think there is an extra query to fetch the entity and then load the relationship. Is there a more optimised way to achieve above?
Also to take the above example a bit further, if suppose users
are related to classes
through a pivot table user_classes
, can that not be achieved using 1 query on Lucid Models and not using Database class?