Function fetchDataByCursor

src/server/utils/prisma.ts:270–320

(
  fetchModel: Model,
  options: {
    // where: Record<string, any>;
    where: ExtractFindManyWhereType<Model>;
    select?: ExtractFindManySelectType<Model>;
    limit: number;
    cursor: CursorType;
    cursorName?: string;
    order?: 'asc' | 'desc';
  }
)

 * );
 */
export async function fetchDataByCursor<
  Model extends {
    findMany: (args?: any) => Prisma.PrismaPromise<any>;
  },
  CursorType,
>(
  fetchModel: Model,
  options: {
    // where: Record<string, any>;
    where: ExtractFindManyWhereType<Model>;
    select?: ExtractFindManySelectType<Model>;
    limit: number;
    cursor: CursorType;
    cursorName?: string;
    order?: 'asc' | 'desc';
  }
) {
  const {
    where,
    limit,
    cursor,
    select,
    cursorName = 'id',
    order = 'desc',
  } = options;
  const items: ExtractFindManyReturnType<Model['findMany']> =
    await fetchModel.findMany({
      where,
      select,
      take: limit + 1,
      cursor: cursor
        ? {
            [cursorName]: cursor,
          }
        : undefined,
      orderBy: {
        [cursorName]: order,
      },
    });

  let nextCursor: CursorType | undefined = undefined;
  if (items.length > limit) {
    const nextItem = items.pop()!;
    nextCursor = nextItem[cursorName];
  }

  return {
    items,
    nextCursor,
  };
}