DT
Drizzle TeamServerless

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)));
};
Any ideas on how I would accomplish that? I feel like limit should potentially be an option on update
Want results from more Discord servers?
Add your server
More Posts
How to get InferModel to work with Relation model?Is there a way to get the infer type for a relation model? eg: type User = InferModel<typeof users,MySQL column type: "Generated"?Does drizzle support defining generated columns? https://planetscale.com/courses/mysql-for-develope