aboutsummaryrefslogtreecommitdiff
path: root/Jellyfin.Server.Implementations
diff options
context:
space:
mode:
authorEthan Pippin <ethanpippin2343@gmail.com>2026-11-12 00:42:03 -0500
committerEthan Pippin <ethanpippin2343@gmail.com>2026-11-12 00:42:03 -0500
commit2cfcb9ac0cfae50aa1a5be456fa6178cb4a2aaef (patch)
tree296abc2e9cd09868e5503aae0c09085a370801f8 /Jellyfin.Server.Implementations
parent7b8c6451b508c8ec77070c91a14d2e631067c87e (diff)
Years, Ratings for filters endpoints
Diffstat (limited to 'Jellyfin.Server.Implementations')
-rw-r--r--Jellyfin.Server.Implementations/Item/BaseItemRepository.Querying.cs60
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();
+ }
}