useInfiniteQueries example with skip instead of cursor

[JulienDemarque]

Got a use-case where using prisma cursor isn't fitting, can i use the endpoint cursor input as a skip property instead...?

[KATT]

Yup, I've done that myself, just have something like cursor: z.number().min(0).default(0)

It can also act as a page if you do limit*cursor

[JulienDemarque]

Got an other issue with that, ...data.pages seems to be an array of either `BaseRun[] | { items: BaseRun[]; nextCursor: number; }` Why is that?

[KATT]

I need to see your procedure to answer that

[JulienDemarque]

Here is my definition:

  .query('findByBaseId', {
    input: z.object({
      baseId: z.string().uuid(),
      skip: z.number(),
      take: z.number(),
      sort: z.record(z.string().nullish()).nullish(),
      cursor: z.number().nullish(), // we are not using cursor for prisma, only to tell if there are more baseRuns to be fetched
    }),
    resolve: async ({ input }) => {
      // check if we are sorting variables
      if (keys(input.sort).length > 0 && keys(input.sort)[0] !== 'deadline') {
        const allBaseRuns = await prisma.baseRun.findMany({
          where: {
            baseId: input.baseId,
          },
        })
        const baseVariableName = keys(input.sort)[0]
        let sortedBaseRuns = sortBy((br: BaseRun) =>
          flow(
            get('variables'),
            values,
            find((v) => v.baseVariable.name === baseVariableName),
            get('value')
          )(br)
        )(allBaseRuns)
        if (input.sort?.[baseVariableName] === 'desc') {
          sortedBaseRuns = sortedBaseRuns.reverse()
        }
        const subsetSortedBaseRuns = slice(
          input.skip,
          input.skip + input.take
        )(sortedBaseRuns)
        return subsetSortedBaseRuns
      }
      const items = await prisma.baseRun.findMany({
        where: {
          baseId: input.baseId,
        },
        skip: input.skip,
        take: input.take,
        orderBy: {
          deadline: (input.sort?.deadline || undefined) as
            | Prisma.SortOrder
            | undefined,
        },
      })
      return {
        items,
        nextCursor: input.skip + 50,
      }
    },
  })

and the consumer:

  const baseRunData = useInfiniteQuery([
   'baseRun.findByBaseId',
   {
     baseId: base.id,
     take: 50,
     skip: baseViewOptions.skipRange,
     sort: {
       ...sortDeadlineOptions,
       ...sortVariableOptions,
     },
   },
 ])

[JulienDemarque]

Also struggling to infer the type from the query:

[JulienDemarque]

If you have access to our repo: https://github.com/invisible-tech/invisible/blob/5780f864b099e2563c52c872b264090cad62c598/apps/manticore/components/Base.tsx#L269

https://github.com/invisible-tech/invisible/blob/5780f864b099e2563c52c872b264090cad62c598/libs/ultron/trpc/server/src/lib/routers/baseRun.ts#L32

[KATT]

Looks like you do an early return where you don't return nextCursor

[JulienDemarque]

Oh yes thank you! sorry about that, my bad...

[JulienDemarque]

@KATT sorry to poke you again, have you ever tried to use getQueryData to get the infinite query cache? can't seem to get it to work...