Function deleteLesson

src/features/lessons/db/lessons.ts:80–107

(id: string)

}

export async function deleteLesson(id: string) {
  const [deletedLesson, courseId] = await db.transaction(async trx => {
    const [deletedLesson] = await trx
      .delete(LessonTable)
      .where(eq(LessonTable.id, id))
      .returning()
    if (deletedLesson == null) {
      trx.rollback()
      throw new Error("Failed to delete lesson")
    }

    const section = await trx.query.CourseSectionTable.findFirst({
      columns: { courseId: true },
      where: ({ id }, { eq }) => eq(id, deletedLesson.sectionId),
    })

    if (section == null) return trx.rollback()

    return [deletedLesson, section.courseId]
  })

  revalidateLessonCache({
    id: deletedLesson.id,
    courseId,
  })

  return deletedLesson
}

export async function updateLessonOrders(lessonIds: string[]) {
  const [lessons, courseId] = await db.transaction(async trx => {