where clause in drizzle insert
can anyone tell why it's giving typescript error and how can i resolve it
error:
where clause doesn't exists
i want to do this query with single query
await db
.insert(trackingQuestions)
.values({
questionNumber: questionNumber,
userId: session.user.id,
})
.where(
notExists(
db
.select()
.from(trackingQuestions)
.where(
and(
eq(trackingQuestions.questionNumber, questionNumber),
eq(trackingQuestions.userId, session.user.id)
)
)
)
);