feat: SQLite lesson data store with schema and C# access layer #13

Merged
sscoble merged 1 commit from issue-4-data-store into main 2026-05-16 04:38:51 +00:00
Owner

Implements #4.

  • Lesson.cs and LessonMedia.cs model classes
  • LessonStore.cs with full CRUD and UPSERT support
  • Schema: lessons + lesson_media tables with foreign key
  • Microsoft.Data.Sqlite with ExcludeAssets=runtime
  • Default DB path: ~/.local/share/jellyfin-lessons/lessons.db

Closes #4

Implements #4. - Lesson.cs and LessonMedia.cs model classes - LessonStore.cs with full CRUD and UPSERT support - Schema: lessons + lesson_media tables with foreign key - Microsoft.Data.Sqlite with ExcludeAssets=runtime - Default DB path: ~/.local/share/jellyfin-lessons/lessons.db Closes #4
sscoble added 1 commit 2026-05-16 04:38:42 +00:00
- Lesson.cs and LessonMedia.cs model classes
- LessonStore.cs with CRUD operations
- Microsoft.Data.Sqlite package reference
- Default DB path: ~/.local/share/jellyfin-lessons/lessons.db

Closes #4
sscoble merged commit fa91314c49 into main 2026-05-16 04:38:51 +00:00
Sign in to join this conversation.
No reviewers
No labels
No milestone
No project
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference: sscoble/jellyfin-lessons#13
No description provided.