Function insertLesson

src/features/lessons/db/lessons.ts:16–35

(data: typeof LessonTable.$inferInsert)

}

export async function insertLesson(data: typeof LessonTable.$inferInsert) {
  const [newLesson, courseId] = await db.transaction(async trx => {
    const [[newLesson], section] = await Promise.all([
      trx.insert(LessonTable).values(data).returning(),
      trx.query.CourseSectionTable.findFirst({
        columns: { courseId: true },
        where: eq(CourseSectionTable.id, data.sectionId),
      }),
    ])

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

    return [newLesson, section.courseId]
  })
  if (newLesson == null) throw new Error("Failed to create lesson")

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

  return newLesson
}

export async function updateLesson(
  id: string,