Function shiftRowsUpFrom

apps/sim/lib/table/rows/ordering.ts:79–84

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

/** Shifts every row at or after `position` up by one (`position + 1`). */
export async function shiftRowsUpFrom(trx: DbTransaction, tableId: string, position: number) {
  await trx
    .update(userTableRows)
    .set({ position: sql`position + 1` })
    .where(and(eq(userTableRows.tableId, tableId), gte(userTableRows.position, position)))
}

/** Shifts every row after `position` down by one (`position - 1`). */
export async function shiftRowsDownAfter(trx: DbTransaction, tableId: string, position: number) {