Fetching a relationship from an already resolved entity

[nrxus]

Given I have already retrieved my parentModel from the prisma client:

await PrismaClient().parentModel.findOne(/* some query */)

And my model has one-to-many relationships to a childModel. I now want want to get all of the childModels out of my parentModel after the fact (i.e., lazy fetching rather than eager fetch).

I couldn't find in the docs a good solution for this.

I know that I can do:

await PrismaClient().parentModel.findOne(/* some query */).childModels()

but because childModels() exist as a method in the ParentModelClient rather than the ParentModel itself, I haven't been able to find a way to get the childModels() after I have resolved the entity.

I know I could do:

await PrismaClient().childModel.findMany({where: { parentModelId: parentModel.id }}) 

But that feels like a lot of boiler plate. Is there a better way?

[nrxus]

Bump to see if anyone has any ideas or if maybe this should be a feature request (lazy fetching in the model rather than the client).

[ryands17]

Hey @nrxus 👋
Currently Prisma 2 only supports eager fetching via the ways that you have mentioned above and also with the include option while querying.

Could you open a Feature Request here stating the above use case?

[Sytten]

That would not be too bad to use the fluent API if it was optimized. I would really prefer if Prisma sticks with plain javascript objects IMO. No magic, no problem.