diff options
Diffstat (limited to 'Jellyfin.Server.Implementations')
| -rw-r--r-- | Jellyfin.Server.Implementations/Item/BaseItemRepository.Querying.cs | 60 |
1 files changed, 46 insertions, 14 deletions
diff --git a/Jellyfin.Server.Implementations/Item/BaseItemRepository.Querying.cs b/Jellyfin.Server.Implementations/Item/BaseItemRepository.Querying.cs index 8d573569e9..a46cd9ab99 100644 --- a/Jellyfin.Server.Implementations/Item/BaseItemRepository.Querying.cs +++ b/Jellyfin.Server.Implementations/Item/BaseItemRepository.Querying.cs @@ -600,7 +600,7 @@ public sealed partial class BaseItemRepository } /// <inheritdoc /> - public QueryFiltersLegacy GetQueryFiltersLegacy(InternalItemsQuery filter) + public IReadOnlyList<int> GetYears(InternalItemsQuery filter) { ArgumentNullException.ThrowIfNull(filter); PrepareFilterQuery(filter); @@ -608,22 +608,34 @@ public sealed partial class BaseItemRepository using var context = _dbProvider.CreateDbContext(); var baseQuery = PrepareItemQuery(context, filter); baseQuery = TranslateQuery(baseQuery, context, filter); + return GetYears(baseQuery); + } - var matchingItemIds = baseQuery.Select(e => e.Id); + /// <inheritdoc /> + public IReadOnlyList<string> GetOfficialRatings(InternalItemsQuery filter) + { + ArgumentNullException.ThrowIfNull(filter); + PrepareFilterQuery(filter); - var years = baseQuery - .Where(e => e.ProductionYear != null && e.ProductionYear > 0) - .Select(e => e.ProductionYear!.Value) - .Distinct() - .OrderBy(y => y) - .ToArray(); + using var context = _dbProvider.CreateDbContext(); + var baseQuery = PrepareItemQuery(context, filter); + baseQuery = TranslateQuery(baseQuery, context, filter); + return GetOfficialRatings(baseQuery); + } - var officialRatings = baseQuery - .Where(e => e.OfficialRating != null && e.OfficialRating != string.Empty) - .Select(e => e.OfficialRating!) - .Distinct() - .OrderBy(r => r) - .ToArray(); + /// <inheritdoc /> + public QueryFiltersLegacy GetQueryFiltersLegacy(InternalItemsQuery filter) + { + ArgumentNullException.ThrowIfNull(filter); + PrepareFilterQuery(filter); + + using var context = _dbProvider.CreateDbContext(); + var baseQuery = PrepareItemQuery(context, filter); + baseQuery = TranslateQuery(baseQuery, context, filter); + + var matchingItemIds = baseQuery.Select(e => e.Id); + var years = GetYears(baseQuery); + var officialRatings = GetOfficialRatings(baseQuery); var tags = context.ItemValuesMap .Join( @@ -659,4 +671,24 @@ public sealed partial class BaseItemRepository Genres = genres }; } + + private static IReadOnlyList<int> GetYears(IQueryable<BaseItemEntity> query) + { + return query + .Where(e => e.ProductionYear != null && e.ProductionYear > 0) + .Select(e => e.ProductionYear!.Value) + .Distinct() + .OrderBy(y => y) + .ToArray(); + } + + private static IReadOnlyList<string> GetOfficialRatings(IQueryable<BaseItemEntity> query) + { + return query + .Where(e => e.OfficialRating != null && e.OfficialRating != string.Empty) + .Select(e => e.OfficialRating!) + .Distinct() + .OrderBy(r => r) + .ToArray(); + } } |
