// Version 1
await db.update(author).set(request.body).where(eq(judge.id, request.params.id))
const updatedAuthor = await db.query.author.findFirst({
where: eq(author.id, request.params.id),
with: { user: true },
})
return updatedAuthor
// Version 2: Tried using .returning() but it also needs 2 queries
const [updated] = await db.update(author).set(request.body).where(eq(judge.id, request.params.id)).returning()
const toReturn = await db.query.author.findFirst({
where: eq(author.id, updated.id),
with: { user: true },
})
return toReturn
// Version 1
await db.update(author).set(request.body).where(eq(judge.id, request.params.id))
const updatedAuthor = await db.query.author.findFirst({
where: eq(author.id, request.params.id),
with: { user: true },
})
return updatedAuthor
// Version 2: Tried using .returning() but it also needs 2 queries
const [updated] = await db.update(author).set(request.body).where(eq(judge.id, request.params.id)).returning()
const toReturn = await db.query.author.findFirst({
where: eq(author.id, updated.id),
with: { user: true },
})
return toReturn