Function selectExportRowPage

apps/sim/lib/table/jobs/service.ts:217–239

(
  table: TableDefinition,
  after: { orderKey: string; id: string } | null,
  limit: number
)

 * applies, like every user-facing read.
 */
export async function selectExportRowPage(
  table: TableDefinition,
  after: { orderKey: string; id: string } | null,
  limit: number
): Promise<Array<{ id: string; data: RowData; orderKey: string }>> {
  const deleteMask = await pendingDeleteMask(table)
  const rows = await db
    .select({ id: userTableRows.id, data: userTableRows.data, orderKey: userTableRows.orderKey })
    .from(userTableRows)
    .where(
      and(
        eq(userTableRows.tableId, table.id),
        eq(userTableRows.workspaceId, table.workspaceId),
        deleteMask,
        after
          ? sql`(${userTableRows.orderKey}, ${userTableRows.id}) > (${after.orderKey}, ${after.id})`
          : undefined
      )
    )
    .orderBy(asc(userTableRows.orderKey), asc(userTableRows.id))
    .limit(limit)
  return rows as Array<{ id: string; data: RowData; orderKey: string }>
}

/** How long a terminal export stays listable (and re-downloadable from the tray). */
const EXPORT_JOB_VISIBILITY_MS = 10 * 60 * 1000