graphql/dataloader

[QUESTION] Any recommendations for using DataLoader with pivot tables?

Open

#289 aperta il 29 dic 2021

Vedi su GitHub
 (0 commenti) (0 reazioni) (0 assegnatari)JavaScript (556 fork)batch import
help wanted

Metriche repository

Star
 (12.520 star)
Metriche merge PR
 (Merge medio 5g 2h) (1 PR mergiata in 30 g)

Descrizione

Pivot tables are often used in relational databases to define one-to-many relationships.

In my case I'm using Adonis.js's Lucid ORM in my GraphQL resolvers, but things get a little tricky when loading relationships that use a pivot table. For example:

const user = await context.loaders.userById.load(input.id);
const posts = await user.posts().fetch();

// Since I didn't use a loader to fetch posts, I now have to prime the cache manually:
for (let post of posts.rows) {
  context.loaders.postById.prime(post.id, post);
}

The downside to this is I lose the simplicity of only using my loaders to grab data, and I have to remember to manually priming my cache even when I might not need the data again.

Guida contributor