Function shiftRowsDownAfter

apps/sim/lib/table/rows/ordering.ts:87–92

(trx: DbTransaction, tableId: string, position: number)

/** Shifts every row after `position` down by one (`position - 1`). */
export async function shiftRowsDownAfter(trx: DbTransaction, tableId: string, position: number) {
  await trx
    .update(userTableRows)
    .set({ position: sql`position - 1` })
    .where(and(eq(userTableRows.tableId, tableId), gt(userTableRows.position, position)))
}

/**
 * Reserves the `position` for a single inserted row and returns where to INSERT.