Function orderKeyAtSlot

apps/sim/lib/table/rows/ordering.ts:197–215

(slot: number)

): Promise<string> {
  const fractionalOrdering = await isFeatureEnabled('tables-fractional-ordering')
  const orderKeyAtSlot = async (slot: number): Promise<string | null> => {
    if (slot < 0) return null
    if (fractionalOrdering) {
      const [r] = await trx
        .select({ orderKey: userTableRows.orderKey })
        .from(userTableRows)
        .where(eq(userTableRows.tableId, tableId))
        .orderBy(asc(userTableRows.orderKey), asc(userTableRows.id))
        .limit(1)
        .offset(slot)
      return r?.orderKey ?? null
    }
    const [r] = await trx
      .select({ orderKey: userTableRows.orderKey })
      .from(userTableRows)
      .where(and(eq(userTableRows.tableId, tableId), eq(userTableRows.position, slot)))
      .limit(1)
    return r?.orderKey ?? null
  }
  if (requestedPosition === undefined) {
    return keyBetween(await maxOrderKey(trx, tableId), null)
  }