KeysetEngine DrizzleHigh-Performance Keyset Pagination & Search

import { sqliteTable, integer, text } from 'drizzle-orm/sqlite-core';
import { createKeysetConfig, paginateKeyset, CryptoCursorProtector } from 'keysetengine-drizzle';

// 1. Define your Drizzle table
export const orders = sqliteTable('orders', {
  id: integer('id').primaryKey(),
  customerName: text('customer_name').notNull(),
  orderNumber: text('order_number').notNull(),
  createdAt: text('created_at').notNull(),
  amount: integer('amount').notNull(),
});

// 2. Configure keyset boundary & search properties
export const orderKeyset = createKeysetConfig(orders, {
  sortBy: orders.createdAt,
  sortDirection: 'desc', // Default is 'asc'
  tieBreaker: orders.id,  // Must be unique and non-nullable
  searchIn: [orders.customerName, orders.orderNumber],
  entityPurpose: 'orders',
});

// 3. Paginate in your HTTP route handler (Hono, Express, Elysia, Fastify, Next.js)
const protector = new CryptoCursorProtector(process.env.CURSOR_SECRET!);

export async function getOrders(req) {
  const page = await paginateKeyset(
    db.select().from(orders).$dynamic(),
    orderKeyset,
    req.query, // { cursor, direction, limit, search }
    { protector }
  );

  return {
    items: page.items,
    startCursor: page.startCursor,
    endCursor: page.endCursor,
    hasNextPage: page.hasNextPage,
    hasPreviousPage: page.hasPreviousPage,
  };
}