deecc1dd7c
- Add Microsoft.Data.Sqlite NuGet package to csproj - Create Lesson model (Id, Title, Grade, Subject, LessonDate, Description, SourcePath, CompiledHtml, CreatedAt, UpdatedAt) - Create LessonMedia model (LessonId, JellyfinItemId, SortOrder) - Create LessonStore with SQLite-backed CRUD operations: - Constructor expands ~ in dbPath to home directory - Creates lessons and lesson_media tables on init - GetAllLessons(), GetLessonById(), GetLessonsByGrade() - UpsertLesson() with media association handling - DeleteLesson() with FK cascade - Enables foreign key enforcement via PRAGMA - Build passes with 0 warnings, 0 errors Closes #4
19 lines
674 B
XML
19 lines
674 B
XML
<Project Sdk="Microsoft.NET.Sdk">
|
|
<PropertyGroup>
|
|
<TargetFramework>net9.0</TargetFramework>
|
|
<RootNamespace>JellyfinLessons</RootNamespace>
|
|
<AssemblyName>jellyfin-lessons</AssemblyName>
|
|
</PropertyGroup>
|
|
|
|
<ItemGroup>
|
|
<PackageReference Include="Jellyfin.Controller" Version="10.10.*">
|
|
<ExcludeAssets>runtime</ExcludeAssets>
|
|
</PackageReference>
|
|
<PackageReference Include="Jellyfin.Model" Version="10.10.*">
|
|
<ExcludeAssets>runtime</ExcludeAssets>
|
|
</PackageReference>
|
|
<PackageReference Include="Microsoft.Data.Sqlite" Version="9.0.*">
|
|
<ExcludeAssets>runtime</ExcludeAssets>
|
|
</PackageReference>
|
|
</ItemGroup>
|
|
</Project>
|