Skip to content

armgit / papra

Public Imported from GitHub
0

The minimalistic document archiving platform.

437 B
Raw Blame
import type { SQL } from 'drizzle-orm';
import type { SQLiteColumn, SQLiteSelect } from 'drizzle-orm/sqlite-core';

export function withPagination<T extends SQLiteSelect>(
  query: T,
  {
    orderByColumn,
    pageIndex,
    pageSize,
  }: {
    orderByColumn: SQLiteColumn | SQL;
    pageIndex: number;
    pageSize: number;
  },
) {
  return query
    .orderBy(orderByColumn)
    .limit(pageSize)
    .offset(pageIndex * pageSize);
}