Function deleteOrderedRow

apps/sim/lib/table/rows/ordering.ts:422–448

(params: {
  tableId: string
  rowId: string
  workspaceId: string
})

 * gap. Returns `false` when no row matched.
 */
export async function deleteOrderedRow(params: {
  tableId: string
  rowId: string
  workspaceId: string
}): Promise<boolean> {
  const { tableId, rowId, workspaceId } = params
  return db.transaction(async (trx) => {
    await setTableTxTimeouts(trx)
    const [deleted] = await trx
      .delete(userTableRows)
      .where(
        and(
          eq(userTableRows.id, rowId),
          eq(userTableRows.tableId, tableId),
          eq(userTableRows.workspaceId, workspaceId)
        )
      )
      .returning({ position: userTableRows.position })
    if (!deleted) return false
    // Fractional ordering: deleting a row never changes another row's order_key,
    // so the O(N) position reshift is skipped entirely.
    if (!(await isFeatureEnabled('tables-fractional-ordering'))) {
      await shiftRowsDownAfter(trx, tableId, deleted.position)
    }
    return true
  })
}

/**
 * Deletes the given row ids in batches within one transaction, then recompacts