Is there a way to limit update to just 1 document?

I know there will be multiple documents matching this where query, but I only want to update 1 of them at a time.

export const joinTable = async (tableId: number, seatedPlayerId: number) => {
  await db
    .update(tableSeats)
    .set({ seatedPlayerId })
    .where(and(eq(tableSeats.tableId, tableId), isNull(tableSeats.seatedPlayerId)));
};

export const joinTable = async (tableId: number, seatedPlayerId: number) => {
  await db
    .update(tableSeats)
    .set({ seatedPlayerId })
    .where(and(eq(tableSeats.tableId, tableId), isNull(tableSeats.seatedPlayerId)));
};

export const joinTable = async (tableId: number, seatedPlayerId: number) => {
  await db
    .update(tableSeats)
    .set({ seatedPlayerId })
    .where(and(eq(tableSeats.tableId, tableId), isNull(tableSeats.seatedPlayerId)));
};

export const joinTable = async (tableId: number, seatedPlayerId: number) => {
  await db
    .update(tableSeats)
    .set({ seatedPlayerId })
    .where(and(eq(tableSeats.tableId, tableId), isNull(tableSeats.seatedPlayerId)));
};

Any ideas on how I would accomplish that? I feel like

limit

limit

limit

limit should potentially be an option on

update

update

update

update

Is there a way to limit update to just 1 document?

Similar Threads

Similar Threads

Similar Threads