JellyfinDb.cs 5.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184
  1. #pragma warning disable CS1591
  2. using System;
  3. using System.Linq;
  4. using Jellyfin.Data.Entities;
  5. using Jellyfin.Data.Interfaces;
  6. using Microsoft.EntityFrameworkCore;
  7. namespace Jellyfin.Server.Implementations
  8. {
  9. /// <inheritdoc/>
  10. public partial class JellyfinDb : DbContext
  11. {
  12. /// <summary>
  13. /// Initializes a new instance of the <see cref="JellyfinDb"/> class.
  14. /// </summary>
  15. /// <param name="options">The database context options.</param>
  16. public JellyfinDb(DbContextOptions<JellyfinDb> options) : base(options)
  17. {
  18. }
  19. /// <summary>
  20. /// Gets or sets the default connection string.
  21. /// </summary>
  22. public static string ConnectionString { get; set; } = @"Data Source=jellyfin.db";
  23. public virtual DbSet<AccessSchedule> AccessSchedules { get; set; }
  24. public virtual DbSet<ActivityLog> ActivityLogs { get; set; }
  25. public virtual DbSet<DisplayPreferences> DisplayPreferences { get; set; }
  26. public virtual DbSet<ImageInfo> ImageInfos { get; set; }
  27. public virtual DbSet<ItemDisplayPreferences> ItemDisplayPreferences { get; set; }
  28. public virtual DbSet<Permission> Permissions { get; set; }
  29. public virtual DbSet<Preference> Preferences { get; set; }
  30. public virtual DbSet<User> Users { get; set; }
  31. /*public virtual DbSet<Artwork> Artwork { get; set; }
  32. public virtual DbSet<Book> Books { get; set; }
  33. public virtual DbSet<BookMetadata> BookMetadata { get; set; }
  34. public virtual DbSet<Chapter> Chapters { get; set; }
  35. public virtual DbSet<Collection> Collections { get; set; }
  36. public virtual DbSet<CollectionItem> CollectionItems { get; set; }
  37. public virtual DbSet<Company> Companies { get; set; }
  38. public virtual DbSet<CompanyMetadata> CompanyMetadata { get; set; }
  39. public virtual DbSet<CustomItem> CustomItems { get; set; }
  40. public virtual DbSet<CustomItemMetadata> CustomItemMetadata { get; set; }
  41. public virtual DbSet<Episode> Episodes { get; set; }
  42. public virtual DbSet<EpisodeMetadata> EpisodeMetadata { get; set; }
  43. public virtual DbSet<Genre> Genres { get; set; }
  44. public virtual DbSet<Group> Groups { get; set; }
  45. public virtual DbSet<Library> Libraries { get; set; }
  46. public virtual DbSet<LibraryItem> LibraryItems { get; set; }
  47. public virtual DbSet<LibraryRoot> LibraryRoot { get; set; }
  48. public virtual DbSet<MediaFile> MediaFiles { get; set; }
  49. public virtual DbSet<MediaFileStream> MediaFileStream { get; set; }
  50. public virtual DbSet<Metadata> Metadata { get; set; }
  51. public virtual DbSet<MetadataProvider> MetadataProviders { get; set; }
  52. public virtual DbSet<MetadataProviderId> MetadataProviderIds { get; set; }
  53. public virtual DbSet<Movie> Movies { get; set; }
  54. public virtual DbSet<MovieMetadata> MovieMetadata { get; set; }
  55. public virtual DbSet<MusicAlbum> MusicAlbums { get; set; }
  56. public virtual DbSet<MusicAlbumMetadata> MusicAlbumMetadata { get; set; }
  57. public virtual DbSet<Person> People { get; set; }
  58. public virtual DbSet<PersonRole> PersonRoles { get; set; }
  59. public virtual DbSet<Photo> Photo { get; set; }
  60. public virtual DbSet<PhotoMetadata> PhotoMetadata { get; set; }
  61. public virtual DbSet<ProviderMapping> ProviderMappings { get; set; }
  62. public virtual DbSet<Rating> Ratings { get; set; }
  63. /// <summary>
  64. /// Repository for global::Jellyfin.Data.Entities.RatingSource - This is the entity to
  65. /// store review ratings, not age ratings.
  66. /// </summary>
  67. public virtual DbSet<RatingSource> RatingSources { get; set; }
  68. public virtual DbSet<Release> Releases { get; set; }
  69. public virtual DbSet<Season> Seasons { get; set; }
  70. public virtual DbSet<SeasonMetadata> SeasonMetadata { get; set; }
  71. public virtual DbSet<Series> Series { get; set; }
  72. public virtual DbSet<SeriesMetadata> SeriesMetadata { get; set; }
  73. public virtual DbSet<Track> Tracks { get; set; }
  74. public virtual DbSet<TrackMetadata> TrackMetadata { get; set; }*/
  75. /// <inheritdoc/>
  76. public override int SaveChanges()
  77. {
  78. foreach (var saveEntity in ChangeTracker.Entries()
  79. .Where(e => e.State == EntityState.Modified)
  80. .Select(entry => entry.Entity)
  81. .OfType<IHasConcurrencyToken>())
  82. {
  83. saveEntity.OnSavingChanges();
  84. }
  85. return base.SaveChanges();
  86. }
  87. /// <inheritdoc/>
  88. public override void Dispose()
  89. {
  90. foreach (var entry in ChangeTracker.Entries())
  91. {
  92. entry.State = EntityState.Detached;
  93. }
  94. GC.SuppressFinalize(this);
  95. base.Dispose();
  96. }
  97. /// <inheritdoc />
  98. protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
  99. {
  100. CustomInit(optionsBuilder);
  101. }
  102. /// <inheritdoc />
  103. protected override void OnModelCreating(ModelBuilder modelBuilder)
  104. {
  105. base.OnModelCreating(modelBuilder);
  106. OnModelCreatingImpl(modelBuilder);
  107. modelBuilder.HasDefaultSchema("jellyfin");
  108. /*modelBuilder.Entity<Artwork>().HasIndex(t => t.Kind);
  109. modelBuilder.Entity<Genre>().HasIndex(t => t.Name)
  110. .IsUnique();
  111. modelBuilder.Entity<LibraryItem>().HasIndex(t => t.UrlId)
  112. .IsUnique();*/
  113. OnModelCreatedImpl(modelBuilder);
  114. }
  115. partial void CustomInit(DbContextOptionsBuilder optionsBuilder);
  116. partial void OnModelCreatingImpl(ModelBuilder modelBuilder);
  117. partial void OnModelCreatedImpl(ModelBuilder modelBuilder);
  118. }
  119. }