How to get total edge count with prismaNode and prismaConnection?

[ricardo-valero]

I have something like this

builder.prismaNode('Product', {
  include: { _count: true },
  findUnique: id => ({ id }),
  id: { resolve: product => product.id },
  fields: t => ({
    createdAt: t.expose('createdAt', { type: 'DateTime' }),
    massKg: t.expose('massKg', { type: 'Decimal', nullable: true }),
    tolerance: t.expose('tolerance', { type: 'Decimal', nullable: true }),
    name: t.exposeString('name'),
    description: t.exposeString('description', { nullable: true }),
    location: t.exposeString('location', { nullable: true }),
  }),
})

builder.queryField('products', t =>
  t.prismaConnection({
    type: 'Product',
    cursor: 'id',
    resolve: (query, parent, args, { prisma }) =>
      prisma.product.findMany({ ...query }),
  }),
)

I'm currently using this without issue, but I need somehow to get the total count in order to calculate the total pages in my pagination bar.

[hayes]

If you don't need to arguments for the field, this is pretty easy:

builder.queryFields((t) => ({
  posts: t.prismaConnection(
    {
      type: 'Post',
      cursor: 'id',
      resolve: (query) =>
        db.post.findMany({
          orderBy: { createdAt: 'desc' },
          ...query,
        }),
    },
    {
      fields: (t) => ({
        totalCount: t.int({
          resolve: () => db.post.count(),
        }),
      }),
    },
  ),
}));

Unfortunately the arguments for the prismaConnection field are not directly available in fields defined on the connection object. If you need to access arguments to get the count, this won't work. I can't think of a simple solution currently, and that might require some changes to the plugin to make that work. If you have any suggestions on how you would want this to work let me know!

[hayes]

Just pushed this change, it's building an publishing now, should be released in ~10 minutes

[hayes]

Can be used like this: https://github.com/hayes/pothos/blob/main/packages/plugin-prisma/tests/example/schema/index.ts#L408

[danieljvdm]

@hayes Could you add something similar to the relay connection style? Not sure how it'd need to be implemented, but I'd like to be able to return a total field on my connection object. I can do so like so:

    {
      name: 'CollectionsConnection',
      fields: (t) => ({
        total: t.int({
          resolve: () => {
            return 20;
          },
        }),
      }),
    },

But the parent param in the resolver isn't useful nor is the args param since it doesn't have the arguments from the connection in there.

[hayes]

there are 2 different ways you can do it here:

https://stackblitz.com/edit/typescript-p1ftfm?file=index.ts

This shows both how to define a global totalCount field that applies to all connections, and how to define a totalCount inline for a single connection

[danieljvdm]

Wow thanks for the fast response. The globalConnectionField API and adding the types to the builder were what I was missing. It's working beautifully now. Thanks so much!