Function maxOrderKey

apps/sim/lib/table/rows/ordering.ts:70–76

(executor: DbOrTx, tableId: string)

/** Largest `order_key` for a table, or `null` when empty — the append anchor for new keys. */
export async function maxOrderKey(executor: DbOrTx, tableId: string): Promise<string | null> {
  const [{ maxKey }] = await executor
    .select({ maxKey: sql<string | null>`max(${userTableRows.orderKey})` })
    .from(userTableRows)
    .where(eq(userTableRows.tableId, tableId))
  return maxKey ?? null
}

/** Shifts every row at or after `position` up by one (`position + 1`). */
export async function shiftRowsUpFrom(trx: DbTransaction, tableId: string, position: number) {