| | | 1 | | #pragma warning disable RS0030 // Do not use banned APIs |
| | | 2 | | // Do not enforce that because EFCore cannot deal with cultures well. |
| | | 3 | | #pragma warning disable CA1304 // Specify CultureInfo |
| | | 4 | | #pragma warning disable CA1311 // Specify a culture or use an invariant version |
| | | 5 | | #pragma warning disable CA1862 // Use the 'StringComparison' method overloads to perform case-insensitive string compari |
| | | 6 | | |
| | | 7 | | using System; |
| | | 8 | | using System.Collections.Concurrent; |
| | | 9 | | using System.Collections.Generic; |
| | | 10 | | using System.Globalization; |
| | | 11 | | using System.Linq; |
| | | 12 | | using System.Linq.Expressions; |
| | | 13 | | using System.Reflection; |
| | | 14 | | using System.Text; |
| | | 15 | | using System.Text.Json; |
| | | 16 | | using System.Threading; |
| | | 17 | | using System.Threading.Tasks; |
| | | 18 | | using Jellyfin.Data.Enums; |
| | | 19 | | using Jellyfin.Database.Implementations; |
| | | 20 | | using Jellyfin.Database.Implementations.Entities; |
| | | 21 | | using Jellyfin.Database.Implementations.Enums; |
| | | 22 | | using Jellyfin.Extensions; |
| | | 23 | | using Jellyfin.Extensions.Json; |
| | | 24 | | using Jellyfin.Server.Implementations.Extensions; |
| | | 25 | | using MediaBrowser.Common; |
| | | 26 | | using MediaBrowser.Controller; |
| | | 27 | | using MediaBrowser.Controller.Channels; |
| | | 28 | | using MediaBrowser.Controller.Configuration; |
| | | 29 | | using MediaBrowser.Controller.Entities; |
| | | 30 | | using MediaBrowser.Controller.Entities.Audio; |
| | | 31 | | using MediaBrowser.Controller.Entities.TV; |
| | | 32 | | using MediaBrowser.Controller.LiveTv; |
| | | 33 | | using MediaBrowser.Controller.Persistence; |
| | | 34 | | using MediaBrowser.Model.Dto; |
| | | 35 | | using MediaBrowser.Model.Entities; |
| | | 36 | | using MediaBrowser.Model.LiveTv; |
| | | 37 | | using MediaBrowser.Model.Querying; |
| | | 38 | | using Microsoft.EntityFrameworkCore; |
| | | 39 | | using Microsoft.Extensions.Logging; |
| | | 40 | | using BaseItemDto = MediaBrowser.Controller.Entities.BaseItem; |
| | | 41 | | using BaseItemEntity = Jellyfin.Database.Implementations.Entities.BaseItemEntity; |
| | | 42 | | |
| | | 43 | | namespace Jellyfin.Server.Implementations.Item; |
| | | 44 | | |
| | | 45 | | /* |
| | | 46 | | All queries in this class and all other nullable enabled EFCore repository classes will make liberal use of the null |
| | | 47 | | This is done as the code isn't actually executed client side, but only the expressions are interpret and the compile |
| | | 48 | | This is your only warning/message regarding this topic. |
| | | 49 | | */ |
| | | 50 | | |
| | | 51 | | /// <summary> |
| | | 52 | | /// Handles all storage logic for BaseItems. |
| | | 53 | | /// </summary> |
| | | 54 | | public sealed class BaseItemRepository |
| | | 55 | | : IItemRepository |
| | | 56 | | { |
| | | 57 | | /// <summary> |
| | | 58 | | /// Gets the placeholder id for UserData detached items. |
| | | 59 | | /// </summary> |
| | 2 | 60 | | public static readonly Guid PlaceholderId = Guid.Parse("00000000-0000-0000-0000-000000000001"); |
| | | 61 | | |
| | | 62 | | /// <summary> |
| | | 63 | | /// This holds all the types in the running assemblies |
| | | 64 | | /// so that we can de-serialize properly when we don't have strong types. |
| | | 65 | | /// </summary> |
| | 2 | 66 | | private static readonly ConcurrentDictionary<string, Type?> _typeMap = new ConcurrentDictionary<string, Type?>(); |
| | | 67 | | private readonly IDbContextFactory<JellyfinDbContext> _dbProvider; |
| | | 68 | | private readonly IServerApplicationHost _appHost; |
| | | 69 | | private readonly IItemTypeLookup _itemTypeLookup; |
| | | 70 | | private readonly IServerConfigurationManager _serverConfigurationManager; |
| | | 71 | | private readonly ILogger<BaseItemRepository> _logger; |
| | | 72 | | |
| | 2 | 73 | | private static readonly IReadOnlyList<ItemValueType> _getAllArtistsValueTypes = [ItemValueType.Artist, ItemValueType |
| | 2 | 74 | | private static readonly IReadOnlyList<ItemValueType> _getArtistValueTypes = [ItemValueType.Artist]; |
| | 2 | 75 | | private static readonly IReadOnlyList<ItemValueType> _getAlbumArtistValueTypes = [ItemValueType.AlbumArtist]; |
| | 2 | 76 | | private static readonly IReadOnlyList<ItemValueType> _getStudiosValueTypes = [ItemValueType.Studios]; |
| | 2 | 77 | | private static readonly IReadOnlyList<ItemValueType> _getGenreValueTypes = [ItemValueType.Genre]; |
| | 2 | 78 | | private static readonly IReadOnlyList<char> SearchWildcardTerms = ['%', '_', '[', ']', '^']; |
| | | 79 | | |
| | | 80 | | /// <summary> |
| | | 81 | | /// Initializes a new instance of the <see cref="BaseItemRepository"/> class. |
| | | 82 | | /// </summary> |
| | | 83 | | /// <param name="dbProvider">The db factory.</param> |
| | | 84 | | /// <param name="appHost">The Application host.</param> |
| | | 85 | | /// <param name="itemTypeLookup">The static type lookup.</param> |
| | | 86 | | /// <param name="serverConfigurationManager">The server Configuration manager.</param> |
| | | 87 | | /// <param name="logger">System logger.</param> |
| | | 88 | | public BaseItemRepository( |
| | | 89 | | IDbContextFactory<JellyfinDbContext> dbProvider, |
| | | 90 | | IServerApplicationHost appHost, |
| | | 91 | | IItemTypeLookup itemTypeLookup, |
| | | 92 | | IServerConfigurationManager serverConfigurationManager, |
| | | 93 | | ILogger<BaseItemRepository> logger) |
| | | 94 | | { |
| | 31 | 95 | | _dbProvider = dbProvider; |
| | 31 | 96 | | _appHost = appHost; |
| | 31 | 97 | | _itemTypeLookup = itemTypeLookup; |
| | 31 | 98 | | _serverConfigurationManager = serverConfigurationManager; |
| | 31 | 99 | | _logger = logger; |
| | 31 | 100 | | } |
| | | 101 | | |
| | | 102 | | /// <inheritdoc /> |
| | | 103 | | public void DeleteItem(params IReadOnlyList<Guid> ids) |
| | | 104 | | { |
| | 1 | 105 | | if (ids is null || ids.Count == 0 || ids.Any(f => f.Equals(PlaceholderId))) |
| | | 106 | | { |
| | 0 | 107 | | throw new ArgumentException("Guid can't be empty or the placeholder id.", nameof(ids)); |
| | | 108 | | } |
| | | 109 | | |
| | 1 | 110 | | using var context = _dbProvider.CreateDbContext(); |
| | 1 | 111 | | using var transaction = context.Database.BeginTransaction(); |
| | | 112 | | |
| | 1 | 113 | | var date = (DateTime?)DateTime.UtcNow; |
| | | 114 | | |
| | 1 | 115 | | var relatedItems = ids.SelectMany(f => TraverseHirachyDown(f, context)).ToArray(); |
| | | 116 | | |
| | | 117 | | // Remove any UserData entries for the placeholder item that would conflict with the UserData |
| | | 118 | | // being detached from the item being deleted. This is necessary because, during an update, |
| | | 119 | | // UserData may be reattached to a new entry, but some entries can be left behind. |
| | | 120 | | // Ensures there are no duplicate UserId/CustomDataKey combinations for the placeholder. |
| | 1 | 121 | | context.UserData |
| | 1 | 122 | | .Join( |
| | 1 | 123 | | context.UserData.WhereOneOrMany(relatedItems, e => e.ItemId), |
| | 1 | 124 | | placeholder => new { placeholder.UserId, placeholder.CustomDataKey }, |
| | 1 | 125 | | userData => new { userData.UserId, userData.CustomDataKey }, |
| | 1 | 126 | | (placeholder, userData) => placeholder) |
| | 1 | 127 | | .Where(e => e.ItemId == PlaceholderId) |
| | 1 | 128 | | .ExecuteDelete(); |
| | | 129 | | |
| | | 130 | | // Detach all user watch data |
| | 1 | 131 | | context.UserData.WhereOneOrMany(relatedItems, e => e.ItemId) |
| | 1 | 132 | | .ExecuteUpdate(e => e |
| | 1 | 133 | | .SetProperty(f => f.RetentionDate, date) |
| | 1 | 134 | | .SetProperty(f => f.ItemId, PlaceholderId)); |
| | | 135 | | |
| | 1 | 136 | | context.AncestorIds.WhereOneOrMany(relatedItems, e => e.ItemId).ExecuteDelete(); |
| | 1 | 137 | | context.AncestorIds.WhereOneOrMany(relatedItems, e => e.ParentItemId).ExecuteDelete(); |
| | 1 | 138 | | context.AttachmentStreamInfos.WhereOneOrMany(relatedItems, e => e.ItemId).ExecuteDelete(); |
| | 1 | 139 | | context.BaseItemImageInfos.WhereOneOrMany(relatedItems, e => e.ItemId).ExecuteDelete(); |
| | 1 | 140 | | context.BaseItemMetadataFields.WhereOneOrMany(relatedItems, e => e.ItemId).ExecuteDelete(); |
| | 1 | 141 | | context.BaseItemProviders.WhereOneOrMany(relatedItems, e => e.ItemId).ExecuteDelete(); |
| | 1 | 142 | | context.BaseItemTrailerTypes.WhereOneOrMany(relatedItems, e => e.ItemId).ExecuteDelete(); |
| | 1 | 143 | | context.BaseItems.WhereOneOrMany(relatedItems, e => e.Id).ExecuteDelete(); |
| | 1 | 144 | | context.Chapters.WhereOneOrMany(relatedItems, e => e.ItemId).ExecuteDelete(); |
| | 1 | 145 | | context.CustomItemDisplayPreferences.WhereOneOrMany(relatedItems, e => e.ItemId).ExecuteDelete(); |
| | 1 | 146 | | context.ItemDisplayPreferences.WhereOneOrMany(relatedItems, e => e.ItemId).ExecuteDelete(); |
| | 1 | 147 | | context.ItemValues.Where(e => e.BaseItemsMap!.Count == 0).ExecuteDelete(); |
| | 1 | 148 | | context.ItemValuesMap.WhereOneOrMany(relatedItems, e => e.ItemId).ExecuteDelete(); |
| | 1 | 149 | | context.KeyframeData.WhereOneOrMany(relatedItems, e => e.ItemId).ExecuteDelete(); |
| | 1 | 150 | | context.MediaSegments.WhereOneOrMany(relatedItems, e => e.ItemId).ExecuteDelete(); |
| | 1 | 151 | | context.MediaStreamInfos.WhereOneOrMany(relatedItems, e => e.ItemId).ExecuteDelete(); |
| | 1 | 152 | | var query = context.PeopleBaseItemMap.WhereOneOrMany(relatedItems, e => e.ItemId).Select(f => f.PeopleId).Distin |
| | 1 | 153 | | context.PeopleBaseItemMap.WhereOneOrMany(relatedItems, e => e.ItemId).ExecuteDelete(); |
| | 1 | 154 | | context.Peoples.WhereOneOrMany(query, e => e.Id).Where(e => e.BaseItems!.Count == 0).ExecuteDelete(); |
| | 1 | 155 | | context.TrickplayInfos.WhereOneOrMany(relatedItems, e => e.ItemId).ExecuteDelete(); |
| | 1 | 156 | | context.SaveChanges(); |
| | 1 | 157 | | transaction.Commit(); |
| | 2 | 158 | | } |
| | | 159 | | |
| | | 160 | | /// <inheritdoc /> |
| | | 161 | | public void UpdateInheritedValues() |
| | | 162 | | { |
| | 15 | 163 | | using var context = _dbProvider.CreateDbContext(); |
| | 15 | 164 | | using var transaction = context.Database.BeginTransaction(); |
| | | 165 | | |
| | 15 | 166 | | context.ItemValuesMap.Where(e => e.ItemValue.Type == ItemValueType.InheritedTags).ExecuteDelete(); |
| | | 167 | | // ItemValue Inheritance is now correctly mapped via AncestorId on demand |
| | 15 | 168 | | context.SaveChanges(); |
| | | 169 | | |
| | 15 | 170 | | transaction.Commit(); |
| | 30 | 171 | | } |
| | | 172 | | |
| | | 173 | | /// <inheritdoc /> |
| | | 174 | | public IReadOnlyList<Guid> GetItemIdsList(InternalItemsQuery filter) |
| | | 175 | | { |
| | 16 | 176 | | ArgumentNullException.ThrowIfNull(filter); |
| | 16 | 177 | | PrepareFilterQuery(filter); |
| | | 178 | | |
| | 16 | 179 | | using var context = _dbProvider.CreateDbContext(); |
| | 16 | 180 | | return ApplyQueryFilter(context.BaseItems.AsNoTracking().Where(e => e.Id != EF.Constant(PlaceholderId)), context |
| | 16 | 181 | | } |
| | | 182 | | |
| | | 183 | | /// <inheritdoc /> |
| | | 184 | | public QueryResult<(BaseItemDto Item, ItemCounts? ItemCounts)> GetAllArtists(InternalItemsQuery filter) |
| | | 185 | | { |
| | 0 | 186 | | return GetItemValues(filter, _getAllArtistsValueTypes, _itemTypeLookup.BaseItemKindNames[BaseItemKind.MusicArtis |
| | | 187 | | } |
| | | 188 | | |
| | | 189 | | /// <inheritdoc /> |
| | | 190 | | public QueryResult<(BaseItemDto Item, ItemCounts? ItemCounts)> GetArtists(InternalItemsQuery filter) |
| | | 191 | | { |
| | 0 | 192 | | return GetItemValues(filter, _getArtistValueTypes, _itemTypeLookup.BaseItemKindNames[BaseItemKind.MusicArtist]); |
| | | 193 | | } |
| | | 194 | | |
| | | 195 | | /// <inheritdoc /> |
| | | 196 | | public QueryResult<(BaseItemDto Item, ItemCounts? ItemCounts)> GetAlbumArtists(InternalItemsQuery filter) |
| | | 197 | | { |
| | 0 | 198 | | return GetItemValues(filter, _getAlbumArtistValueTypes, _itemTypeLookup.BaseItemKindNames[BaseItemKind.MusicArti |
| | | 199 | | } |
| | | 200 | | |
| | | 201 | | /// <inheritdoc /> |
| | | 202 | | public QueryResult<(BaseItemDto Item, ItemCounts? ItemCounts)> GetStudios(InternalItemsQuery filter) |
| | | 203 | | { |
| | 0 | 204 | | return GetItemValues(filter, _getStudiosValueTypes, _itemTypeLookup.BaseItemKindNames[BaseItemKind.Studio]); |
| | | 205 | | } |
| | | 206 | | |
| | | 207 | | /// <inheritdoc /> |
| | | 208 | | public QueryResult<(BaseItemDto Item, ItemCounts? ItemCounts)> GetGenres(InternalItemsQuery filter) |
| | | 209 | | { |
| | 0 | 210 | | return GetItemValues(filter, _getGenreValueTypes, _itemTypeLookup.BaseItemKindNames[BaseItemKind.Genre]); |
| | | 211 | | } |
| | | 212 | | |
| | | 213 | | /// <inheritdoc /> |
| | | 214 | | public QueryResult<(BaseItemDto Item, ItemCounts? ItemCounts)> GetMusicGenres(InternalItemsQuery filter) |
| | | 215 | | { |
| | 0 | 216 | | return GetItemValues(filter, _getGenreValueTypes, _itemTypeLookup.BaseItemKindNames[BaseItemKind.MusicGenre]); |
| | | 217 | | } |
| | | 218 | | |
| | | 219 | | /// <inheritdoc /> |
| | | 220 | | public IReadOnlyList<string> GetStudioNames() |
| | | 221 | | { |
| | 16 | 222 | | return GetItemValueNames(_getStudiosValueTypes, [], []); |
| | | 223 | | } |
| | | 224 | | |
| | | 225 | | /// <inheritdoc /> |
| | | 226 | | public IReadOnlyList<string> GetAllArtistNames() |
| | | 227 | | { |
| | 16 | 228 | | return GetItemValueNames(_getAllArtistsValueTypes, [], []); |
| | | 229 | | } |
| | | 230 | | |
| | | 231 | | /// <inheritdoc /> |
| | | 232 | | public IReadOnlyList<string> GetMusicGenreNames() |
| | | 233 | | { |
| | 16 | 234 | | return GetItemValueNames( |
| | 16 | 235 | | _getGenreValueTypes, |
| | 16 | 236 | | _itemTypeLookup.MusicGenreTypes, |
| | 16 | 237 | | []); |
| | | 238 | | } |
| | | 239 | | |
| | | 240 | | /// <inheritdoc /> |
| | | 241 | | public IReadOnlyList<string> GetGenreNames() |
| | | 242 | | { |
| | 16 | 243 | | return GetItemValueNames( |
| | 16 | 244 | | _getGenreValueTypes, |
| | 16 | 245 | | [], |
| | 16 | 246 | | _itemTypeLookup.MusicGenreTypes); |
| | | 247 | | } |
| | | 248 | | |
| | | 249 | | /// <inheritdoc /> |
| | | 250 | | public QueryResult<BaseItemDto> GetItems(InternalItemsQuery filter) |
| | | 251 | | { |
| | 1 | 252 | | ArgumentNullException.ThrowIfNull(filter); |
| | 1 | 253 | | if (!filter.EnableTotalRecordCount || ((filter.Limit ?? 0) == 0 && (filter.StartIndex ?? 0) == 0)) |
| | | 254 | | { |
| | 1 | 255 | | var returnList = GetItemList(filter); |
| | 1 | 256 | | return new QueryResult<BaseItemDto>( |
| | 1 | 257 | | filter.StartIndex, |
| | 1 | 258 | | returnList.Count, |
| | 1 | 259 | | returnList); |
| | | 260 | | } |
| | | 261 | | |
| | 0 | 262 | | PrepareFilterQuery(filter); |
| | 0 | 263 | | var result = new QueryResult<BaseItemDto>(); |
| | | 264 | | |
| | 0 | 265 | | using var context = _dbProvider.CreateDbContext(); |
| | | 266 | | |
| | 0 | 267 | | IQueryable<BaseItemEntity> dbQuery = PrepareItemQuery(context, filter); |
| | | 268 | | |
| | 0 | 269 | | dbQuery = TranslateQuery(dbQuery, context, filter); |
| | 0 | 270 | | dbQuery = ApplyGroupingFilter(context, dbQuery, filter); |
| | | 271 | | |
| | 0 | 272 | | if (filter.EnableTotalRecordCount) |
| | | 273 | | { |
| | 0 | 274 | | result.TotalRecordCount = dbQuery.Count(); |
| | | 275 | | } |
| | | 276 | | |
| | 0 | 277 | | dbQuery = ApplyQueryPaging(dbQuery, filter); |
| | 0 | 278 | | dbQuery = ApplyNavigations(dbQuery, filter); |
| | | 279 | | |
| | 0 | 280 | | result.Items = dbQuery.AsEnumerable().Where(e => e is not null).Select(w => DeserializeBaseItem(w, filter.SkipDe |
| | 0 | 281 | | result.StartIndex = filter.StartIndex ?? 0; |
| | 0 | 282 | | return result; |
| | 0 | 283 | | } |
| | | 284 | | |
| | | 285 | | /// <inheritdoc /> |
| | | 286 | | public IReadOnlyList<BaseItemDto> GetItemList(InternalItemsQuery filter) |
| | | 287 | | { |
| | 320 | 288 | | ArgumentNullException.ThrowIfNull(filter); |
| | 320 | 289 | | PrepareFilterQuery(filter); |
| | | 290 | | |
| | 320 | 291 | | using var context = _dbProvider.CreateDbContext(); |
| | 319 | 292 | | IQueryable<BaseItemEntity> dbQuery = PrepareItemQuery(context, filter); |
| | | 293 | | |
| | 319 | 294 | | dbQuery = TranslateQuery(dbQuery, context, filter); |
| | | 295 | | |
| | 319 | 296 | | dbQuery = ApplyGroupingFilter(context, dbQuery, filter); |
| | 319 | 297 | | dbQuery = ApplyQueryPaging(dbQuery, filter); |
| | | 298 | | |
| | 319 | 299 | | var hasRandomSort = filter.OrderBy.Any(e => e.OrderBy == ItemSortBy.Random); |
| | 319 | 300 | | if (hasRandomSort) |
| | | 301 | | { |
| | 62 | 302 | | var orderedIds = dbQuery.Select(e => e.Id).ToList(); |
| | 62 | 303 | | if (orderedIds.Count == 0) |
| | | 304 | | { |
| | 62 | 305 | | return Array.Empty<BaseItemDto>(); |
| | | 306 | | } |
| | | 307 | | |
| | 0 | 308 | | var itemsById = ApplyNavigations(context.BaseItems.Where(e => orderedIds.Contains(e.Id)), filter) |
| | 0 | 309 | | .AsEnumerable() |
| | 0 | 310 | | .Select(w => DeserializeBaseItem(w, filter.SkipDeserialization)) |
| | 0 | 311 | | .Where(dto => dto is not null) |
| | 0 | 312 | | .ToDictionary(i => i!.Id); |
| | | 313 | | |
| | 0 | 314 | | return orderedIds.Where(itemsById.ContainsKey).Select(id => itemsById[id]).ToArray()!; |
| | | 315 | | } |
| | | 316 | | |
| | 257 | 317 | | dbQuery = ApplyNavigations(dbQuery, filter); |
| | | 318 | | |
| | 257 | 319 | | return dbQuery.AsEnumerable().Where(e => e is not null).Select(w => DeserializeBaseItem(w, filter.SkipDeserializ |
| | 319 | 320 | | } |
| | | 321 | | |
| | | 322 | | /// <inheritdoc/> |
| | | 323 | | public IReadOnlyList<BaseItem> GetLatestItemList(InternalItemsQuery filter, CollectionType collectionType) |
| | | 324 | | { |
| | 0 | 325 | | ArgumentNullException.ThrowIfNull(filter); |
| | 0 | 326 | | PrepareFilterQuery(filter); |
| | | 327 | | |
| | | 328 | | // Early exit if collection type is not tvshows or music |
| | 0 | 329 | | if (collectionType != CollectionType.tvshows && collectionType != CollectionType.music) |
| | | 330 | | { |
| | 0 | 331 | | return Array.Empty<BaseItem>(); |
| | | 332 | | } |
| | | 333 | | |
| | 0 | 334 | | using var context = _dbProvider.CreateDbContext(); |
| | | 335 | | |
| | | 336 | | // Subquery to group by SeriesNames/Album and get the max Date Created for each group. |
| | 0 | 337 | | var subquery = PrepareItemQuery(context, filter); |
| | 0 | 338 | | subquery = TranslateQuery(subquery, context, filter); |
| | 0 | 339 | | var subqueryGrouped = subquery.GroupBy(g => collectionType == CollectionType.tvshows ? g.SeriesName : g.Album) |
| | 0 | 340 | | .Select(g => new |
| | 0 | 341 | | { |
| | 0 | 342 | | Key = g.Key, |
| | 0 | 343 | | MaxDateCreated = g.Max(a => a.DateCreated) |
| | 0 | 344 | | }) |
| | 0 | 345 | | .OrderByDescending(g => g.MaxDateCreated) |
| | 0 | 346 | | .Select(g => g); |
| | | 347 | | |
| | 0 | 348 | | if (filter.Limit.HasValue && filter.Limit.Value > 0) |
| | | 349 | | { |
| | 0 | 350 | | subqueryGrouped = subqueryGrouped.Take(filter.Limit.Value); |
| | | 351 | | } |
| | | 352 | | |
| | 0 | 353 | | filter.Limit = null; |
| | | 354 | | |
| | 0 | 355 | | var mainquery = PrepareItemQuery(context, filter); |
| | 0 | 356 | | mainquery = TranslateQuery(mainquery, context, filter); |
| | 0 | 357 | | mainquery = mainquery.Where(g => g.DateCreated >= subqueryGrouped.Min(s => s.MaxDateCreated)); |
| | 0 | 358 | | mainquery = ApplyGroupingFilter(context, mainquery, filter); |
| | 0 | 359 | | mainquery = ApplyQueryPaging(mainquery, filter); |
| | | 360 | | |
| | 0 | 361 | | mainquery = ApplyNavigations(mainquery, filter); |
| | | 362 | | |
| | 0 | 363 | | return mainquery.AsEnumerable().Where(e => e is not null).Select(w => DeserializeBaseItem(w, filter.SkipDeserial |
| | 0 | 364 | | } |
| | | 365 | | |
| | | 366 | | /// <inheritdoc /> |
| | | 367 | | public IReadOnlyList<string> GetNextUpSeriesKeys(InternalItemsQuery filter, DateTime dateCutoff) |
| | | 368 | | { |
| | 0 | 369 | | ArgumentNullException.ThrowIfNull(filter); |
| | 0 | 370 | | ArgumentNullException.ThrowIfNull(filter.User); |
| | | 371 | | |
| | 0 | 372 | | using var context = _dbProvider.CreateDbContext(); |
| | | 373 | | |
| | 0 | 374 | | var query = context.BaseItems |
| | 0 | 375 | | .AsNoTracking() |
| | 0 | 376 | | .Where(i => filter.TopParentIds.Contains(i.TopParentId!.Value)) |
| | 0 | 377 | | .Where(i => i.Type == _itemTypeLookup.BaseItemKindNames[BaseItemKind.Episode]) |
| | 0 | 378 | | .Join( |
| | 0 | 379 | | context.UserData.AsNoTracking().Where(e => e.ItemId != EF.Constant(PlaceholderId)), |
| | 0 | 380 | | i => new { UserId = filter.User.Id, ItemId = i.Id }, |
| | 0 | 381 | | u => new { UserId = u.UserId, ItemId = u.ItemId }, |
| | 0 | 382 | | (entity, data) => new { Item = entity, UserData = data }) |
| | 0 | 383 | | .GroupBy(g => g.Item.SeriesPresentationUniqueKey) |
| | 0 | 384 | | .Select(g => new { g.Key, LastPlayedDate = g.Max(u => u.UserData.LastPlayedDate) }) |
| | 0 | 385 | | .Where(g => g.Key != null && g.LastPlayedDate != null && g.LastPlayedDate >= dateCutoff) |
| | 0 | 386 | | .OrderByDescending(g => g.LastPlayedDate) |
| | 0 | 387 | | .Select(g => g.Key!); |
| | | 388 | | |
| | 0 | 389 | | if (filter.Limit.HasValue && filter.Limit.Value > 0) |
| | | 390 | | { |
| | 0 | 391 | | query = query.Take(filter.Limit.Value); |
| | | 392 | | } |
| | | 393 | | |
| | 0 | 394 | | return query.ToArray(); |
| | 0 | 395 | | } |
| | | 396 | | |
| | | 397 | | private IQueryable<BaseItemEntity> ApplyGroupingFilter(JellyfinDbContext context, IQueryable<BaseItemEntity> dbQuery |
| | | 398 | | { |
| | | 399 | | // This whole block is needed to filter duplicate entries on request |
| | | 400 | | // for the time being it cannot be used because it would destroy the ordering |
| | | 401 | | // this results in "duplicate" responses for queries that try to lookup individual series or multiple versions b |
| | | 402 | | // for that case the invoker has to run a DistinctBy(e => e.PresentationUniqueKey) on their own |
| | | 403 | | |
| | 335 | 404 | | var enableGroupByPresentationUniqueKey = EnableGroupByPresentationUniqueKey(filter); |
| | 335 | 405 | | if (enableGroupByPresentationUniqueKey && filter.GroupBySeriesPresentationUniqueKey) |
| | | 406 | | { |
| | 0 | 407 | | var tempQuery = dbQuery.GroupBy(e => new { e.PresentationUniqueKey, e.SeriesPresentationUniqueKey }).Select( |
| | 0 | 408 | | dbQuery = context.BaseItems.Where(e => tempQuery.Contains(e.Id)); |
| | | 409 | | } |
| | 335 | 410 | | else if (enableGroupByPresentationUniqueKey) |
| | | 411 | | { |
| | 1 | 412 | | var tempQuery = dbQuery.GroupBy(e => e.PresentationUniqueKey).Select(e => e.FirstOrDefault()).Select(e => e! |
| | 1 | 413 | | dbQuery = context.BaseItems.Where(e => tempQuery.Contains(e.Id)); |
| | | 414 | | } |
| | 334 | 415 | | else if (filter.GroupBySeriesPresentationUniqueKey) |
| | | 416 | | { |
| | 0 | 417 | | var tempQuery = dbQuery.GroupBy(e => e.SeriesPresentationUniqueKey).Select(e => e.FirstOrDefault()).Select(e |
| | 0 | 418 | | dbQuery = context.BaseItems.Where(e => tempQuery.Contains(e.Id)); |
| | | 419 | | } |
| | | 420 | | else |
| | | 421 | | { |
| | 334 | 422 | | dbQuery = dbQuery.Distinct(); |
| | | 423 | | } |
| | | 424 | | |
| | 335 | 425 | | dbQuery = ApplyOrder(dbQuery, filter, context); |
| | | 426 | | |
| | 335 | 427 | | return dbQuery; |
| | | 428 | | } |
| | | 429 | | |
| | | 430 | | private static IQueryable<BaseItemEntity> ApplyNavigations(IQueryable<BaseItemEntity> dbQuery, InternalItemsQuery fi |
| | | 431 | | { |
| | 273 | 432 | | if (filter.TrailerTypes.Length > 0 || filter.IncludeItemTypes.Contains(BaseItemKind.Trailer)) |
| | | 433 | | { |
| | 0 | 434 | | dbQuery = dbQuery.Include(e => e.TrailerTypes); |
| | | 435 | | } |
| | | 436 | | |
| | 273 | 437 | | if (filter.DtoOptions.ContainsField(ItemFields.ProviderIds)) |
| | | 438 | | { |
| | 272 | 439 | | dbQuery = dbQuery.Include(e => e.Provider); |
| | | 440 | | } |
| | | 441 | | |
| | 273 | 442 | | if (filter.DtoOptions.ContainsField(ItemFields.Settings)) |
| | | 443 | | { |
| | 272 | 444 | | dbQuery = dbQuery.Include(e => e.LockedFields); |
| | | 445 | | } |
| | | 446 | | |
| | 273 | 447 | | if (filter.DtoOptions.EnableUserData) |
| | | 448 | | { |
| | 273 | 449 | | dbQuery = dbQuery.Include(e => e.UserData); |
| | | 450 | | } |
| | | 451 | | |
| | 273 | 452 | | if (filter.DtoOptions.EnableImages) |
| | | 453 | | { |
| | 273 | 454 | | dbQuery = dbQuery.Include(e => e.Images); |
| | | 455 | | } |
| | | 456 | | |
| | 273 | 457 | | return dbQuery; |
| | | 458 | | } |
| | | 459 | | |
| | | 460 | | private IQueryable<BaseItemEntity> ApplyQueryPaging(IQueryable<BaseItemEntity> dbQuery, InternalItemsQuery filter) |
| | | 461 | | { |
| | 335 | 462 | | if (filter.StartIndex.HasValue && filter.StartIndex.Value > 0) |
| | | 463 | | { |
| | 0 | 464 | | dbQuery = dbQuery.Skip(filter.StartIndex.Value); |
| | | 465 | | } |
| | | 466 | | |
| | 335 | 467 | | if (filter.Limit.HasValue && filter.Limit.Value > 0) |
| | | 468 | | { |
| | 103 | 469 | | dbQuery = dbQuery.Take(filter.Limit.Value); |
| | | 470 | | } |
| | | 471 | | |
| | 335 | 472 | | return dbQuery; |
| | | 473 | | } |
| | | 474 | | |
| | | 475 | | private IQueryable<BaseItemEntity> ApplyQueryFilter(IQueryable<BaseItemEntity> dbQuery, JellyfinDbContext context, I |
| | | 476 | | { |
| | 16 | 477 | | dbQuery = TranslateQuery(dbQuery, context, filter); |
| | 16 | 478 | | dbQuery = ApplyGroupingFilter(context, dbQuery, filter); |
| | 16 | 479 | | dbQuery = ApplyQueryPaging(dbQuery, filter); |
| | 16 | 480 | | dbQuery = ApplyNavigations(dbQuery, filter); |
| | 16 | 481 | | return dbQuery; |
| | | 482 | | } |
| | | 483 | | |
| | | 484 | | private IQueryable<BaseItemEntity> PrepareItemQuery(JellyfinDbContext context, InternalItemsQuery filter) |
| | | 485 | | { |
| | 405 | 486 | | IQueryable<BaseItemEntity> dbQuery = context.BaseItems.AsNoTracking(); |
| | 405 | 487 | | dbQuery = dbQuery.AsSingleQuery(); |
| | | 488 | | |
| | 405 | 489 | | return dbQuery; |
| | | 490 | | } |
| | | 491 | | |
| | | 492 | | /// <inheritdoc/> |
| | | 493 | | public int GetCount(InternalItemsQuery filter) |
| | | 494 | | { |
| | 0 | 495 | | ArgumentNullException.ThrowIfNull(filter); |
| | | 496 | | // Hack for right now since we currently don't support filtering out these duplicates within a query |
| | 0 | 497 | | PrepareFilterQuery(filter); |
| | | 498 | | |
| | 0 | 499 | | using var context = _dbProvider.CreateDbContext(); |
| | 0 | 500 | | var dbQuery = TranslateQuery(context.BaseItems.AsNoTracking(), context, filter); |
| | | 501 | | |
| | 0 | 502 | | return dbQuery.Count(); |
| | 0 | 503 | | } |
| | | 504 | | |
| | | 505 | | /// <inheritdoc /> |
| | | 506 | | public ItemCounts GetItemCounts(InternalItemsQuery filter) |
| | | 507 | | { |
| | 0 | 508 | | ArgumentNullException.ThrowIfNull(filter); |
| | | 509 | | // Hack for right now since we currently don't support filtering out these duplicates within a query |
| | 0 | 510 | | PrepareFilterQuery(filter); |
| | | 511 | | |
| | 0 | 512 | | using var context = _dbProvider.CreateDbContext(); |
| | 0 | 513 | | var dbQuery = TranslateQuery(context.BaseItems.AsNoTracking(), context, filter); |
| | | 514 | | |
| | 0 | 515 | | var counts = dbQuery |
| | 0 | 516 | | .GroupBy(x => x.Type) |
| | 0 | 517 | | .Select(x => new { x.Key, Count = x.Count() }) |
| | 0 | 518 | | .ToArray(); |
| | | 519 | | |
| | 0 | 520 | | var lookup = _itemTypeLookup.BaseItemKindNames; |
| | 0 | 521 | | var result = new ItemCounts(); |
| | 0 | 522 | | foreach (var count in counts) |
| | | 523 | | { |
| | 0 | 524 | | if (string.Equals(count.Key, lookup[BaseItemKind.MusicAlbum], StringComparison.Ordinal)) |
| | | 525 | | { |
| | 0 | 526 | | result.AlbumCount = count.Count; |
| | | 527 | | } |
| | 0 | 528 | | else if (string.Equals(count.Key, lookup[BaseItemKind.MusicArtist], StringComparison.Ordinal)) |
| | | 529 | | { |
| | 0 | 530 | | result.ArtistCount = count.Count; |
| | | 531 | | } |
| | 0 | 532 | | else if (string.Equals(count.Key, lookup[BaseItemKind.Episode], StringComparison.Ordinal)) |
| | | 533 | | { |
| | 0 | 534 | | result.EpisodeCount = count.Count; |
| | | 535 | | } |
| | 0 | 536 | | else if (string.Equals(count.Key, lookup[BaseItemKind.Movie], StringComparison.Ordinal)) |
| | | 537 | | { |
| | 0 | 538 | | result.MovieCount = count.Count; |
| | | 539 | | } |
| | 0 | 540 | | else if (string.Equals(count.Key, lookup[BaseItemKind.MusicVideo], StringComparison.Ordinal)) |
| | | 541 | | { |
| | 0 | 542 | | result.MusicVideoCount = count.Count; |
| | | 543 | | } |
| | 0 | 544 | | else if (string.Equals(count.Key, lookup[BaseItemKind.LiveTvProgram], StringComparison.Ordinal)) |
| | | 545 | | { |
| | 0 | 546 | | result.ProgramCount = count.Count; |
| | | 547 | | } |
| | 0 | 548 | | else if (string.Equals(count.Key, lookup[BaseItemKind.Series], StringComparison.Ordinal)) |
| | | 549 | | { |
| | 0 | 550 | | result.SeriesCount = count.Count; |
| | | 551 | | } |
| | 0 | 552 | | else if (string.Equals(count.Key, lookup[BaseItemKind.Audio], StringComparison.Ordinal)) |
| | | 553 | | { |
| | 0 | 554 | | result.SongCount = count.Count; |
| | | 555 | | } |
| | 0 | 556 | | else if (string.Equals(count.Key, lookup[BaseItemKind.Trailer], StringComparison.Ordinal)) |
| | | 557 | | { |
| | 0 | 558 | | result.TrailerCount = count.Count; |
| | | 559 | | } |
| | | 560 | | } |
| | | 561 | | |
| | 0 | 562 | | return result; |
| | 0 | 563 | | } |
| | | 564 | | |
| | | 565 | | #pragma warning disable CA1307 // Specify StringComparison for clarity |
| | | 566 | | /// <summary> |
| | | 567 | | /// Gets the type. |
| | | 568 | | /// </summary> |
| | | 569 | | /// <param name="typeName">Name of the type.</param> |
| | | 570 | | /// <returns>Type.</returns> |
| | | 571 | | /// <exception cref="ArgumentNullException"><c>typeName</c> is null.</exception> |
| | | 572 | | private static Type? GetType(string typeName) |
| | | 573 | | { |
| | 143 | 574 | | ArgumentException.ThrowIfNullOrEmpty(typeName); |
| | | 575 | | |
| | | 576 | | // TODO: this isn't great. Refactor later to be both globally handled by a dedicated service not just an static |
| | | 577 | | // currently this is done so that plugins may introduce their own type of baseitems as we dont know when we are |
| | 143 | 578 | | return _typeMap.GetOrAdd(typeName, k => AppDomain.CurrentDomain.GetAssemblies() |
| | 143 | 579 | | .Select(a => a.GetType(k)) |
| | 143 | 580 | | .FirstOrDefault(t => t is not null)); |
| | | 581 | | } |
| | | 582 | | |
| | | 583 | | /// <inheritdoc /> |
| | | 584 | | public async Task SaveImagesAsync(BaseItemDto item, CancellationToken cancellationToken = default) |
| | | 585 | | { |
| | | 586 | | ArgumentNullException.ThrowIfNull(item); |
| | | 587 | | |
| | | 588 | | var images = item.ImageInfos.Select(e => Map(item.Id, e)).ToArray(); |
| | | 589 | | |
| | | 590 | | var context = await _dbProvider.CreateDbContextAsync(cancellationToken).ConfigureAwait(false); |
| | | 591 | | await using (context.ConfigureAwait(false)) |
| | | 592 | | { |
| | | 593 | | if (!await context.BaseItems |
| | | 594 | | .AnyAsync(bi => bi.Id == item.Id, cancellationToken) |
| | | 595 | | .ConfigureAwait(false)) |
| | | 596 | | { |
| | | 597 | | _logger.LogWarning("Unable to save ImageInfo for non existing BaseItem"); |
| | | 598 | | return; |
| | | 599 | | } |
| | | 600 | | |
| | | 601 | | await context.BaseItemImageInfos |
| | | 602 | | .Where(e => e.ItemId == item.Id) |
| | | 603 | | .ExecuteDeleteAsync(cancellationToken) |
| | | 604 | | .ConfigureAwait(false); |
| | | 605 | | |
| | | 606 | | await context.BaseItemImageInfos |
| | | 607 | | .AddRangeAsync(images, cancellationToken) |
| | | 608 | | .ConfigureAwait(false); |
| | | 609 | | |
| | | 610 | | await context.SaveChangesAsync(cancellationToken).ConfigureAwait(false); |
| | | 611 | | } |
| | | 612 | | } |
| | | 613 | | |
| | | 614 | | /// <inheritdoc /> |
| | | 615 | | public void SaveItems(IReadOnlyList<BaseItemDto> items, CancellationToken cancellationToken) |
| | | 616 | | { |
| | 111 | 617 | | UpdateOrInsertItems(items, cancellationToken); |
| | 110 | 618 | | } |
| | | 619 | | |
| | | 620 | | /// <inheritdoc cref="IItemRepository"/> |
| | | 621 | | public void UpdateOrInsertItems(IReadOnlyList<BaseItemDto> items, CancellationToken cancellationToken) |
| | | 622 | | { |
| | 111 | 623 | | ArgumentNullException.ThrowIfNull(items); |
| | 111 | 624 | | cancellationToken.ThrowIfCancellationRequested(); |
| | | 625 | | |
| | 110 | 626 | | var tuples = new List<(BaseItemDto Item, List<Guid>? AncestorIds, BaseItemDto TopParent, IEnumerable<string> Use |
| | 440 | 627 | | foreach (var item in items.GroupBy(e => e.Id).Select(e => e.Last()).Where(e => e.Id != PlaceholderId)) |
| | | 628 | | { |
| | 110 | 629 | | var ancestorIds = item.SupportsAncestors ? |
| | 110 | 630 | | item.GetAncestorIds().Distinct().ToList() : |
| | 110 | 631 | | null; |
| | | 632 | | |
| | 110 | 633 | | var topParent = item.GetTopParent(); |
| | | 634 | | |
| | 110 | 635 | | var userdataKey = item.GetUserDataKeys(); |
| | 110 | 636 | | var inheritedTags = item.GetInheritedTags(); |
| | | 637 | | |
| | 110 | 638 | | tuples.Add((item, ancestorIds, topParent, userdataKey, inheritedTags)); |
| | | 639 | | } |
| | | 640 | | |
| | 110 | 641 | | using var context = _dbProvider.CreateDbContext(); |
| | 110 | 642 | | using var transaction = context.Database.BeginTransaction(); |
| | | 643 | | |
| | 110 | 644 | | var ids = tuples.Select(f => f.Item.Id).ToArray(); |
| | 110 | 645 | | var existingItems = context.BaseItems.Where(e => ids.Contains(e.Id)).Select(f => f.Id).ToArray(); |
| | | 646 | | |
| | 440 | 647 | | foreach (var item in tuples) |
| | | 648 | | { |
| | 110 | 649 | | var entity = Map(item.Item); |
| | | 650 | | // TODO: refactor this "inconsistency" |
| | 110 | 651 | | entity.TopParentId = item.TopParent?.Id; |
| | | 652 | | |
| | 110 | 653 | | if (!existingItems.Any(e => e == entity.Id)) |
| | | 654 | | { |
| | 59 | 655 | | context.BaseItems.Add(entity); |
| | | 656 | | } |
| | | 657 | | else |
| | | 658 | | { |
| | 51 | 659 | | context.BaseItemProviders.Where(e => e.ItemId == entity.Id).ExecuteDelete(); |
| | 51 | 660 | | context.BaseItemImageInfos.Where(e => e.ItemId == entity.Id).ExecuteDelete(); |
| | 51 | 661 | | context.BaseItemMetadataFields.Where(e => e.ItemId == entity.Id).ExecuteDelete(); |
| | | 662 | | |
| | 51 | 663 | | if (entity.Images is { Count: > 0 }) |
| | | 664 | | { |
| | 0 | 665 | | context.BaseItemImageInfos.AddRange(entity.Images); |
| | | 666 | | } |
| | | 667 | | |
| | 51 | 668 | | if (entity.LockedFields is { Count: > 0 }) |
| | | 669 | | { |
| | 0 | 670 | | context.BaseItemMetadataFields.AddRange(entity.LockedFields); |
| | | 671 | | } |
| | | 672 | | |
| | 51 | 673 | | context.BaseItems.Attach(entity).State = EntityState.Modified; |
| | | 674 | | } |
| | | 675 | | } |
| | | 676 | | |
| | 110 | 677 | | context.SaveChanges(); |
| | | 678 | | |
| | 110 | 679 | | var itemValueMaps = tuples |
| | 110 | 680 | | .Select(e => (e.Item, Values: GetItemValuesToSave(e.Item, e.InheritedTags))) |
| | 110 | 681 | | .ToArray(); |
| | 110 | 682 | | var allListedItemValues = itemValueMaps |
| | 110 | 683 | | .SelectMany(f => f.Values) |
| | 110 | 684 | | .Distinct() |
| | 110 | 685 | | .ToArray(); |
| | | 686 | | |
| | 110 | 687 | | var types = allListedItemValues.Select(e => e.MagicNumber).Distinct().ToArray(); |
| | 110 | 688 | | var values = allListedItemValues.Select(e => e.Value).Distinct().ToArray(); |
| | 110 | 689 | | var allListedItemValuesSet = allListedItemValues.ToHashSet(); |
| | | 690 | | |
| | 110 | 691 | | var existingValues = context.ItemValues |
| | 110 | 692 | | .Where(e => types.Contains(e.Type) && values.Contains(e.Value)) |
| | 110 | 693 | | .AsEnumerable() |
| | 110 | 694 | | .Where(e => allListedItemValuesSet.Contains((e.Type, e.Value))) |
| | 110 | 695 | | .ToArray(); |
| | 110 | 696 | | var missingItemValues = allListedItemValues.Except(existingValues.Select(f => (MagicNumber: f.Type, f.Value))).S |
| | 110 | 697 | | { |
| | 110 | 698 | | CleanValue = GetCleanValue(f.Value), |
| | 110 | 699 | | ItemValueId = Guid.NewGuid(), |
| | 110 | 700 | | Type = f.MagicNumber, |
| | 110 | 701 | | Value = f.Value |
| | 110 | 702 | | }).ToArray(); |
| | 110 | 703 | | context.ItemValues.AddRange(missingItemValues); |
| | 110 | 704 | | context.SaveChanges(); |
| | | 705 | | |
| | 110 | 706 | | var itemValuesStore = existingValues.Concat(missingItemValues).ToArray(); |
| | 110 | 707 | | var valueMap = itemValueMaps |
| | 110 | 708 | | .Select(f => (f.Item, Values: f.Values.Select(e => itemValuesStore.First(g => g.Value == e.Value && g.Type = |
| | 110 | 709 | | .ToArray(); |
| | | 710 | | |
| | 110 | 711 | | var mappedValues = context.ItemValuesMap.Where(e => ids.Contains(e.ItemId)).ToList(); |
| | | 712 | | |
| | 440 | 713 | | foreach (var item in valueMap) |
| | | 714 | | { |
| | 110 | 715 | | var itemMappedValues = mappedValues.Where(e => e.ItemId == item.Item.Id).ToList(); |
| | 220 | 716 | | foreach (var itemValue in item.Values) |
| | | 717 | | { |
| | 0 | 718 | | var existingItem = itemMappedValues.FirstOrDefault(f => f.ItemValueId == itemValue.ItemValueId); |
| | 0 | 719 | | if (existingItem is null) |
| | | 720 | | { |
| | 0 | 721 | | context.ItemValuesMap.Add(new ItemValueMap() |
| | 0 | 722 | | { |
| | 0 | 723 | | Item = null!, |
| | 0 | 724 | | ItemId = item.Item.Id, |
| | 0 | 725 | | ItemValue = null!, |
| | 0 | 726 | | ItemValueId = itemValue.ItemValueId |
| | 0 | 727 | | }); |
| | | 728 | | } |
| | | 729 | | else |
| | | 730 | | { |
| | | 731 | | // map exists, remove from list so its been handled. |
| | 0 | 732 | | itemMappedValues.Remove(existingItem); |
| | | 733 | | } |
| | | 734 | | } |
| | | 735 | | |
| | | 736 | | // all still listed values are not in the new list so remove them. |
| | 110 | 737 | | context.ItemValuesMap.RemoveRange(itemMappedValues); |
| | | 738 | | } |
| | | 739 | | |
| | 110 | 740 | | context.SaveChanges(); |
| | | 741 | | |
| | 440 | 742 | | foreach (var item in tuples) |
| | | 743 | | { |
| | 110 | 744 | | if (item.Item.SupportsAncestors && item.AncestorIds != null) |
| | | 745 | | { |
| | 110 | 746 | | var existingAncestorIds = context.AncestorIds.Where(e => e.ItemId == item.Item.Id).ToList(); |
| | 110 | 747 | | var validAncestorIds = context.BaseItems.Where(e => item.AncestorIds.Contains(e.Id)).Select(f => f.Id).T |
| | 274 | 748 | | foreach (var ancestorId in validAncestorIds) |
| | | 749 | | { |
| | 27 | 750 | | var existingAncestorId = existingAncestorIds.FirstOrDefault(e => e.ParentItemId == ancestorId); |
| | 27 | 751 | | if (existingAncestorId is null) |
| | | 752 | | { |
| | 23 | 753 | | context.AncestorIds.Add(new AncestorId() |
| | 23 | 754 | | { |
| | 23 | 755 | | ParentItemId = ancestorId, |
| | 23 | 756 | | ItemId = item.Item.Id, |
| | 23 | 757 | | Item = null!, |
| | 23 | 758 | | ParentItem = null! |
| | 23 | 759 | | }); |
| | | 760 | | } |
| | | 761 | | else |
| | | 762 | | { |
| | 4 | 763 | | existingAncestorIds.Remove(existingAncestorId); |
| | | 764 | | } |
| | | 765 | | } |
| | | 766 | | |
| | 110 | 767 | | context.AncestorIds.RemoveRange(existingAncestorIds); |
| | | 768 | | } |
| | | 769 | | } |
| | | 770 | | |
| | 110 | 771 | | context.SaveChanges(); |
| | 110 | 772 | | transaction.Commit(); |
| | 220 | 773 | | } |
| | | 774 | | |
| | | 775 | | /// <inheritdoc /> |
| | | 776 | | public async Task ReattachUserDataAsync(BaseItemDto item, CancellationToken cancellationToken) |
| | | 777 | | { |
| | | 778 | | ArgumentNullException.ThrowIfNull(item); |
| | | 779 | | cancellationToken.ThrowIfCancellationRequested(); |
| | | 780 | | |
| | | 781 | | var dbContext = await _dbProvider.CreateDbContextAsync(cancellationToken).ConfigureAwait(false); |
| | | 782 | | |
| | | 783 | | await using (dbContext.ConfigureAwait(false)) |
| | | 784 | | { |
| | | 785 | | var transaction = await dbContext.Database.BeginTransactionAsync(cancellationToken).ConfigureAwait(false); |
| | | 786 | | await using (transaction.ConfigureAwait(false)) |
| | | 787 | | { |
| | | 788 | | var userKeys = item.GetUserDataKeys().ToArray(); |
| | | 789 | | var retentionDate = (DateTime?)null; |
| | | 790 | | |
| | | 791 | | await dbContext.UserData |
| | | 792 | | .Where(e => e.ItemId == PlaceholderId) |
| | | 793 | | .Where(e => userKeys.Contains(e.CustomDataKey)) |
| | | 794 | | .ExecuteUpdateAsync( |
| | | 795 | | e => e |
| | | 796 | | .SetProperty(f => f.ItemId, item.Id) |
| | | 797 | | .SetProperty(f => f.RetentionDate, retentionDate), |
| | | 798 | | cancellationToken).ConfigureAwait(false); |
| | | 799 | | |
| | | 800 | | // Rehydrate the cached userdata |
| | | 801 | | item.UserData = await dbContext.UserData |
| | | 802 | | .AsNoTracking() |
| | | 803 | | .Where(e => e.ItemId == item.Id) |
| | | 804 | | .ToArrayAsync(cancellationToken) |
| | | 805 | | .ConfigureAwait(false); |
| | | 806 | | |
| | | 807 | | await transaction.CommitAsync(cancellationToken).ConfigureAwait(false); |
| | | 808 | | } |
| | | 809 | | } |
| | | 810 | | } |
| | | 811 | | |
| | | 812 | | /// <inheritdoc /> |
| | | 813 | | public BaseItemDto? RetrieveItem(Guid id) |
| | | 814 | | { |
| | 86 | 815 | | if (id.IsEmpty()) |
| | | 816 | | { |
| | 0 | 817 | | throw new ArgumentException("Guid can't be empty", nameof(id)); |
| | | 818 | | } |
| | | 819 | | |
| | 86 | 820 | | using var context = _dbProvider.CreateDbContext(); |
| | 86 | 821 | | var dbQuery = PrepareItemQuery(context, new() |
| | 86 | 822 | | { |
| | 86 | 823 | | DtoOptions = new() |
| | 86 | 824 | | { |
| | 86 | 825 | | EnableImages = true |
| | 86 | 826 | | } |
| | 86 | 827 | | }); |
| | 86 | 828 | | dbQuery = dbQuery.Include(e => e.TrailerTypes) |
| | 86 | 829 | | .Include(e => e.Provider) |
| | 86 | 830 | | .Include(e => e.LockedFields) |
| | 86 | 831 | | .Include(e => e.UserData) |
| | 86 | 832 | | .Include(e => e.Images); |
| | | 833 | | |
| | 86 | 834 | | var item = dbQuery.FirstOrDefault(e => e.Id == id); |
| | 86 | 835 | | if (item is null) |
| | | 836 | | { |
| | 86 | 837 | | return null; |
| | | 838 | | } |
| | | 839 | | |
| | 0 | 840 | | return DeserializeBaseItem(item); |
| | 86 | 841 | | } |
| | | 842 | | |
| | | 843 | | /// <summary> |
| | | 844 | | /// Maps a Entity to the DTO. |
| | | 845 | | /// </summary> |
| | | 846 | | /// <param name="entity">The entity.</param> |
| | | 847 | | /// <param name="dto">The dto base instance.</param> |
| | | 848 | | /// <param name="appHost">The Application server Host.</param> |
| | | 849 | | /// <param name="logger">The applogger.</param> |
| | | 850 | | /// <returns>The dto to map.</returns> |
| | | 851 | | public static BaseItemDto Map(BaseItemEntity entity, BaseItemDto dto, IServerApplicationHost? appHost, ILogger logge |
| | | 852 | | { |
| | 71 | 853 | | dto.Id = entity.Id; |
| | 71 | 854 | | dto.ParentId = entity.ParentId.GetValueOrDefault(); |
| | 71 | 855 | | dto.Path = appHost?.ExpandVirtualPath(entity.Path) ?? entity.Path; |
| | 71 | 856 | | dto.EndDate = entity.EndDate; |
| | 71 | 857 | | dto.CommunityRating = entity.CommunityRating; |
| | 71 | 858 | | dto.CustomRating = entity.CustomRating; |
| | 71 | 859 | | dto.IndexNumber = entity.IndexNumber; |
| | 71 | 860 | | dto.IsLocked = entity.IsLocked; |
| | 71 | 861 | | dto.Name = entity.Name; |
| | 71 | 862 | | dto.OfficialRating = entity.OfficialRating; |
| | 71 | 863 | | dto.Overview = entity.Overview; |
| | 71 | 864 | | dto.ParentIndexNumber = entity.ParentIndexNumber; |
| | 71 | 865 | | dto.PremiereDate = entity.PremiereDate; |
| | 71 | 866 | | dto.ProductionYear = entity.ProductionYear; |
| | 71 | 867 | | dto.SortName = entity.SortName; |
| | 71 | 868 | | dto.ForcedSortName = entity.ForcedSortName; |
| | 71 | 869 | | dto.RunTimeTicks = entity.RunTimeTicks; |
| | 71 | 870 | | dto.PreferredMetadataLanguage = entity.PreferredMetadataLanguage; |
| | 71 | 871 | | dto.PreferredMetadataCountryCode = entity.PreferredMetadataCountryCode; |
| | 71 | 872 | | dto.IsInMixedFolder = entity.IsInMixedFolder; |
| | 71 | 873 | | dto.InheritedParentalRatingValue = entity.InheritedParentalRatingValue; |
| | 71 | 874 | | dto.InheritedParentalRatingSubValue = entity.InheritedParentalRatingSubValue; |
| | 71 | 875 | | dto.CriticRating = entity.CriticRating; |
| | 71 | 876 | | dto.PresentationUniqueKey = entity.PresentationUniqueKey; |
| | 71 | 877 | | dto.OriginalTitle = entity.OriginalTitle; |
| | 71 | 878 | | dto.Album = entity.Album; |
| | 71 | 879 | | dto.LUFS = entity.LUFS; |
| | 71 | 880 | | dto.NormalizationGain = entity.NormalizationGain; |
| | 71 | 881 | | dto.IsVirtualItem = entity.IsVirtualItem; |
| | 71 | 882 | | dto.ExternalSeriesId = entity.ExternalSeriesId; |
| | 71 | 883 | | dto.Tagline = entity.Tagline; |
| | 71 | 884 | | dto.TotalBitrate = entity.TotalBitrate; |
| | 71 | 885 | | dto.ExternalId = entity.ExternalId; |
| | 71 | 886 | | dto.Size = entity.Size; |
| | 71 | 887 | | dto.Genres = string.IsNullOrWhiteSpace(entity.Genres) ? [] : entity.Genres.Split('|'); |
| | 71 | 888 | | dto.DateCreated = entity.DateCreated ?? DateTime.SpecifyKind(DateTime.MinValue, DateTimeKind.Utc); |
| | 71 | 889 | | dto.DateModified = entity.DateModified ?? DateTime.SpecifyKind(DateTime.MinValue, DateTimeKind.Utc); |
| | 71 | 890 | | dto.ChannelId = entity.ChannelId ?? Guid.Empty; |
| | 71 | 891 | | dto.DateLastRefreshed = entity.DateLastRefreshed ?? DateTime.SpecifyKind(DateTime.MinValue, DateTimeKind.Utc); |
| | 71 | 892 | | dto.DateLastSaved = entity.DateLastSaved ?? DateTime.SpecifyKind(DateTime.MinValue, DateTimeKind.Utc); |
| | 71 | 893 | | dto.OwnerId = string.IsNullOrWhiteSpace(entity.OwnerId) ? Guid.Empty : (Guid.TryParse(entity.OwnerId, out var ow |
| | 71 | 894 | | dto.Width = entity.Width.GetValueOrDefault(); |
| | 71 | 895 | | dto.Height = entity.Height.GetValueOrDefault(); |
| | 71 | 896 | | dto.UserData = entity.UserData; |
| | | 897 | | |
| | 71 | 898 | | if (entity.Provider is not null) |
| | | 899 | | { |
| | 70 | 900 | | dto.ProviderIds = entity.Provider.ToDictionary(e => e.ProviderId, e => e.ProviderValue); |
| | | 901 | | } |
| | | 902 | | |
| | 71 | 903 | | if (entity.ExtraType is not null) |
| | | 904 | | { |
| | 0 | 905 | | dto.ExtraType = (ExtraType)entity.ExtraType; |
| | | 906 | | } |
| | | 907 | | |
| | 71 | 908 | | if (entity.LockedFields is not null) |
| | | 909 | | { |
| | 70 | 910 | | dto.LockedFields = entity.LockedFields?.Select(e => (MetadataField)e.Id).ToArray() ?? []; |
| | | 911 | | } |
| | | 912 | | |
| | 71 | 913 | | if (entity.Audio is not null) |
| | | 914 | | { |
| | 0 | 915 | | dto.Audio = (ProgramAudio)entity.Audio; |
| | | 916 | | } |
| | | 917 | | |
| | 71 | 918 | | dto.ExtraIds = string.IsNullOrWhiteSpace(entity.ExtraIds) ? [] : entity.ExtraIds.Split('|').Select(e => Guid.Par |
| | 71 | 919 | | dto.ProductionLocations = entity.ProductionLocations?.Split('|', StringSplitOptions.RemoveEmptyEntries) ?? []; |
| | 71 | 920 | | dto.Studios = entity.Studios?.Split('|') ?? []; |
| | 71 | 921 | | dto.Tags = string.IsNullOrWhiteSpace(entity.Tags) ? [] : entity.Tags.Split('|'); |
| | | 922 | | |
| | 71 | 923 | | if (dto is IHasProgramAttributes hasProgramAttributes) |
| | | 924 | | { |
| | 0 | 925 | | hasProgramAttributes.IsMovie = entity.IsMovie; |
| | 0 | 926 | | hasProgramAttributes.IsSeries = entity.IsSeries; |
| | 0 | 927 | | hasProgramAttributes.EpisodeTitle = entity.EpisodeTitle; |
| | 0 | 928 | | hasProgramAttributes.IsRepeat = entity.IsRepeat; |
| | | 929 | | } |
| | | 930 | | |
| | 71 | 931 | | if (dto is LiveTvChannel liveTvChannel) |
| | | 932 | | { |
| | 0 | 933 | | liveTvChannel.ServiceName = entity.ExternalServiceId; |
| | | 934 | | } |
| | | 935 | | |
| | 71 | 936 | | if (dto is Trailer trailer) |
| | | 937 | | { |
| | 0 | 938 | | trailer.TrailerTypes = entity.TrailerTypes?.Select(e => (TrailerType)e.Id).ToArray() ?? []; |
| | | 939 | | } |
| | | 940 | | |
| | 71 | 941 | | if (dto is Video video) |
| | | 942 | | { |
| | 1 | 943 | | video.PrimaryVersionId = entity.PrimaryVersionId; |
| | | 944 | | } |
| | | 945 | | |
| | 71 | 946 | | if (dto is IHasSeries hasSeriesName) |
| | | 947 | | { |
| | 0 | 948 | | hasSeriesName.SeriesName = entity.SeriesName; |
| | 0 | 949 | | hasSeriesName.SeriesId = entity.SeriesId.GetValueOrDefault(); |
| | 0 | 950 | | hasSeriesName.SeriesPresentationUniqueKey = entity.SeriesPresentationUniqueKey; |
| | | 951 | | } |
| | | 952 | | |
| | 71 | 953 | | if (dto is Episode episode) |
| | | 954 | | { |
| | 0 | 955 | | episode.SeasonName = entity.SeasonName; |
| | 0 | 956 | | episode.SeasonId = entity.SeasonId.GetValueOrDefault(); |
| | | 957 | | } |
| | | 958 | | |
| | 71 | 959 | | if (dto is IHasArtist hasArtists) |
| | | 960 | | { |
| | 0 | 961 | | hasArtists.Artists = entity.Artists?.Split('|', StringSplitOptions.RemoveEmptyEntries) ?? []; |
| | | 962 | | } |
| | | 963 | | |
| | 71 | 964 | | if (dto is IHasAlbumArtist hasAlbumArtists) |
| | | 965 | | { |
| | 0 | 966 | | hasAlbumArtists.AlbumArtists = entity.AlbumArtists?.Split('|', StringSplitOptions.RemoveEmptyEntries) ?? []; |
| | | 967 | | } |
| | | 968 | | |
| | 71 | 969 | | if (dto is LiveTvProgram program) |
| | | 970 | | { |
| | 0 | 971 | | program.ShowId = entity.ShowId; |
| | | 972 | | } |
| | | 973 | | |
| | 71 | 974 | | if (entity.Images is not null) |
| | | 975 | | { |
| | 70 | 976 | | dto.ImageInfos = entity.Images.Select(e => Map(e, appHost)).ToArray(); |
| | | 977 | | } |
| | | 978 | | |
| | | 979 | | // dto.Type = entity.Type; |
| | | 980 | | // dto.Data = entity.Data; |
| | | 981 | | // dto.MediaType = Enum.TryParse<MediaType>(entity.MediaType); |
| | 71 | 982 | | if (dto is IHasStartDate hasStartDate) |
| | | 983 | | { |
| | 0 | 984 | | hasStartDate.StartDate = entity.StartDate.GetValueOrDefault(); |
| | | 985 | | } |
| | | 986 | | |
| | | 987 | | // Fields that are present in the DB but are never actually used |
| | | 988 | | // dto.UnratedType = entity.UnratedType; |
| | | 989 | | // dto.TopParentId = entity.TopParentId; |
| | | 990 | | // dto.CleanName = entity.CleanName; |
| | | 991 | | // dto.UserDataKey = entity.UserDataKey; |
| | | 992 | | |
| | 71 | 993 | | if (dto is Folder folder) |
| | | 994 | | { |
| | 70 | 995 | | folder.DateLastMediaAdded = entity.DateLastMediaAdded ?? DateTime.SpecifyKind(DateTime.MinValue, DateTimeKin |
| | | 996 | | } |
| | | 997 | | |
| | 71 | 998 | | return dto; |
| | | 999 | | } |
| | | 1000 | | |
| | | 1001 | | /// <summary> |
| | | 1002 | | /// Maps a Entity to the DTO. |
| | | 1003 | | /// </summary> |
| | | 1004 | | /// <param name="dto">The entity.</param> |
| | | 1005 | | /// <returns>The dto to map.</returns> |
| | | 1006 | | public BaseItemEntity Map(BaseItemDto dto) |
| | | 1007 | | { |
| | 120 | 1008 | | var dtoType = dto.GetType(); |
| | 120 | 1009 | | var entity = new BaseItemEntity() |
| | 120 | 1010 | | { |
| | 120 | 1011 | | Type = dtoType.ToString(), |
| | 120 | 1012 | | Id = dto.Id |
| | 120 | 1013 | | }; |
| | | 1014 | | |
| | 120 | 1015 | | if (TypeRequiresDeserialization(dtoType)) |
| | | 1016 | | { |
| | 99 | 1017 | | entity.Data = JsonSerializer.Serialize(dto, dtoType, JsonDefaults.Options); |
| | | 1018 | | } |
| | | 1019 | | |
| | 120 | 1020 | | entity.ParentId = !dto.ParentId.IsEmpty() ? dto.ParentId : null; |
| | 120 | 1021 | | entity.Path = GetPathToSave(dto.Path); |
| | 120 | 1022 | | entity.EndDate = dto.EndDate; |
| | 120 | 1023 | | entity.CommunityRating = dto.CommunityRating; |
| | 120 | 1024 | | entity.CustomRating = dto.CustomRating; |
| | 120 | 1025 | | entity.IndexNumber = dto.IndexNumber; |
| | 120 | 1026 | | entity.IsLocked = dto.IsLocked; |
| | 120 | 1027 | | entity.Name = dto.Name; |
| | 120 | 1028 | | entity.CleanName = GetCleanValue(dto.Name); |
| | 120 | 1029 | | entity.OfficialRating = dto.OfficialRating; |
| | 120 | 1030 | | entity.Overview = dto.Overview; |
| | 120 | 1031 | | entity.ParentIndexNumber = dto.ParentIndexNumber; |
| | 120 | 1032 | | entity.PremiereDate = dto.PremiereDate; |
| | 120 | 1033 | | entity.ProductionYear = dto.ProductionYear; |
| | 120 | 1034 | | entity.SortName = dto.SortName; |
| | 120 | 1035 | | entity.ForcedSortName = dto.ForcedSortName; |
| | 120 | 1036 | | entity.RunTimeTicks = dto.RunTimeTicks; |
| | 120 | 1037 | | entity.PreferredMetadataLanguage = dto.PreferredMetadataLanguage; |
| | 120 | 1038 | | entity.PreferredMetadataCountryCode = dto.PreferredMetadataCountryCode; |
| | 120 | 1039 | | entity.IsInMixedFolder = dto.IsInMixedFolder; |
| | 120 | 1040 | | entity.InheritedParentalRatingValue = dto.InheritedParentalRatingValue; |
| | 120 | 1041 | | entity.InheritedParentalRatingSubValue = dto.InheritedParentalRatingSubValue; |
| | 120 | 1042 | | entity.CriticRating = dto.CriticRating; |
| | 120 | 1043 | | entity.PresentationUniqueKey = dto.PresentationUniqueKey; |
| | 120 | 1044 | | entity.OriginalTitle = dto.OriginalTitle; |
| | 120 | 1045 | | entity.Album = dto.Album; |
| | 120 | 1046 | | entity.LUFS = dto.LUFS; |
| | 120 | 1047 | | entity.NormalizationGain = dto.NormalizationGain; |
| | 120 | 1048 | | entity.IsVirtualItem = dto.IsVirtualItem; |
| | 120 | 1049 | | entity.ExternalSeriesId = dto.ExternalSeriesId; |
| | 120 | 1050 | | entity.Tagline = dto.Tagline; |
| | 120 | 1051 | | entity.TotalBitrate = dto.TotalBitrate; |
| | 120 | 1052 | | entity.ExternalId = dto.ExternalId; |
| | 120 | 1053 | | entity.Size = dto.Size; |
| | 120 | 1054 | | entity.Genres = string.Join('|', dto.Genres.Distinct(StringComparer.OrdinalIgnoreCase)); |
| | 120 | 1055 | | entity.DateCreated = dto.DateCreated == DateTime.MinValue ? null : dto.DateCreated; |
| | 120 | 1056 | | entity.DateModified = dto.DateModified == DateTime.MinValue ? null : dto.DateModified; |
| | 120 | 1057 | | entity.ChannelId = dto.ChannelId; |
| | 120 | 1058 | | entity.DateLastRefreshed = dto.DateLastRefreshed == DateTime.MinValue ? null : dto.DateLastRefreshed; |
| | 120 | 1059 | | entity.DateLastSaved = dto.DateLastSaved == DateTime.MinValue ? null : dto.DateLastSaved; |
| | 120 | 1060 | | entity.OwnerId = dto.OwnerId.ToString(); |
| | 120 | 1061 | | entity.Width = dto.Width; |
| | 120 | 1062 | | entity.Height = dto.Height; |
| | 120 | 1063 | | entity.Provider = dto.ProviderIds.Select(e => new BaseItemProvider() |
| | 120 | 1064 | | { |
| | 120 | 1065 | | Item = entity, |
| | 120 | 1066 | | ProviderId = e.Key, |
| | 120 | 1067 | | ProviderValue = e.Value |
| | 120 | 1068 | | }).ToList(); |
| | | 1069 | | |
| | 120 | 1070 | | if (dto.Audio.HasValue) |
| | | 1071 | | { |
| | 0 | 1072 | | entity.Audio = (ProgramAudioEntity)dto.Audio; |
| | | 1073 | | } |
| | | 1074 | | |
| | 120 | 1075 | | if (dto.ExtraType.HasValue) |
| | | 1076 | | { |
| | 0 | 1077 | | entity.ExtraType = (BaseItemExtraType)dto.ExtraType; |
| | | 1078 | | } |
| | | 1079 | | |
| | 120 | 1080 | | entity.ExtraIds = dto.ExtraIds is not null ? string.Join('|', dto.ExtraIds) : null; |
| | 120 | 1081 | | entity.ProductionLocations = dto.ProductionLocations is not null ? string.Join('|', dto.ProductionLocations.Wher |
| | 120 | 1082 | | entity.Studios = dto.Studios is not null ? string.Join('|', dto.Studios.Distinct(StringComparer.OrdinalIgnoreCas |
| | 120 | 1083 | | entity.Tags = dto.Tags is not null ? string.Join('|', dto.Tags.Distinct(StringComparer.OrdinalIgnoreCase)) : nul |
| | 120 | 1084 | | entity.LockedFields = dto.LockedFields is not null ? dto.LockedFields |
| | 120 | 1085 | | .Select(e => new BaseItemMetadataField() |
| | 120 | 1086 | | { |
| | 120 | 1087 | | Id = (int)e, |
| | 120 | 1088 | | Item = entity, |
| | 120 | 1089 | | ItemId = entity.Id |
| | 120 | 1090 | | }) |
| | 120 | 1091 | | .ToArray() : null; |
| | | 1092 | | |
| | 120 | 1093 | | if (dto is IHasProgramAttributes hasProgramAttributes) |
| | | 1094 | | { |
| | 0 | 1095 | | entity.IsMovie = hasProgramAttributes.IsMovie; |
| | 0 | 1096 | | entity.IsSeries = hasProgramAttributes.IsSeries; |
| | 0 | 1097 | | entity.EpisodeTitle = hasProgramAttributes.EpisodeTitle; |
| | 0 | 1098 | | entity.IsRepeat = hasProgramAttributes.IsRepeat; |
| | | 1099 | | } |
| | | 1100 | | |
| | 120 | 1101 | | if (dto is LiveTvChannel liveTvChannel) |
| | | 1102 | | { |
| | 0 | 1103 | | entity.ExternalServiceId = liveTvChannel.ServiceName; |
| | | 1104 | | } |
| | | 1105 | | |
| | 120 | 1106 | | if (dto is Video video) |
| | | 1107 | | { |
| | 0 | 1108 | | entity.PrimaryVersionId = video.PrimaryVersionId; |
| | | 1109 | | } |
| | | 1110 | | |
| | 120 | 1111 | | if (dto is IHasSeries hasSeriesName) |
| | | 1112 | | { |
| | 0 | 1113 | | entity.SeriesName = hasSeriesName.SeriesName; |
| | 0 | 1114 | | entity.SeriesId = hasSeriesName.SeriesId; |
| | 0 | 1115 | | entity.SeriesPresentationUniqueKey = hasSeriesName.SeriesPresentationUniqueKey; |
| | | 1116 | | } |
| | | 1117 | | |
| | 120 | 1118 | | if (dto is Episode episode) |
| | | 1119 | | { |
| | 0 | 1120 | | entity.SeasonName = episode.SeasonName; |
| | 0 | 1121 | | entity.SeasonId = episode.SeasonId; |
| | | 1122 | | } |
| | | 1123 | | |
| | 120 | 1124 | | if (dto is IHasArtist hasArtists) |
| | | 1125 | | { |
| | 0 | 1126 | | entity.Artists = hasArtists.Artists is not null ? string.Join('|', hasArtists.Artists.Distinct(StringCompare |
| | | 1127 | | } |
| | | 1128 | | |
| | 120 | 1129 | | if (dto is IHasAlbumArtist hasAlbumArtists) |
| | | 1130 | | { |
| | 0 | 1131 | | entity.AlbumArtists = hasAlbumArtists.AlbumArtists is not null ? string.Join('|', hasAlbumArtists.AlbumArtis |
| | | 1132 | | } |
| | | 1133 | | |
| | 120 | 1134 | | if (dto is LiveTvProgram program) |
| | | 1135 | | { |
| | 0 | 1136 | | entity.ShowId = program.ShowId; |
| | | 1137 | | } |
| | | 1138 | | |
| | 120 | 1139 | | if (dto.ImageInfos is not null) |
| | | 1140 | | { |
| | 120 | 1141 | | entity.Images = dto.ImageInfos.Select(f => Map(dto.Id, f)).ToArray(); |
| | | 1142 | | } |
| | | 1143 | | |
| | 120 | 1144 | | if (dto is Trailer trailer) |
| | | 1145 | | { |
| | 0 | 1146 | | entity.TrailerTypes = trailer.TrailerTypes?.Select(e => new BaseItemTrailerType() |
| | 0 | 1147 | | { |
| | 0 | 1148 | | Id = (int)e, |
| | 0 | 1149 | | Item = entity, |
| | 0 | 1150 | | ItemId = entity.Id |
| | 0 | 1151 | | }).ToArray() ?? []; |
| | | 1152 | | } |
| | | 1153 | | |
| | | 1154 | | // dto.Type = entity.Type; |
| | | 1155 | | // dto.Data = entity.Data; |
| | 120 | 1156 | | entity.MediaType = dto.MediaType.ToString(); |
| | 120 | 1157 | | if (dto is IHasStartDate hasStartDate) |
| | | 1158 | | { |
| | 0 | 1159 | | entity.StartDate = hasStartDate.StartDate; |
| | | 1160 | | } |
| | | 1161 | | |
| | 120 | 1162 | | entity.UnratedType = dto.GetBlockUnratedType().ToString(); |
| | | 1163 | | |
| | | 1164 | | // Fields that are present in the DB but are never actually used |
| | | 1165 | | // dto.UserDataKey = entity.UserDataKey; |
| | | 1166 | | |
| | 120 | 1167 | | if (dto is Folder folder) |
| | | 1168 | | { |
| | 120 | 1169 | | entity.DateLastMediaAdded = folder.DateLastMediaAdded == DateTime.MinValue ? null : folder.DateLastMediaAdde |
| | 120 | 1170 | | entity.IsFolder = folder.IsFolder; |
| | | 1171 | | } |
| | | 1172 | | |
| | 120 | 1173 | | return entity; |
| | | 1174 | | } |
| | | 1175 | | |
| | | 1176 | | private string[] GetItemValueNames(IReadOnlyList<ItemValueType> itemValueTypes, IReadOnlyList<string> withItemTypes, |
| | | 1177 | | { |
| | 64 | 1178 | | using var context = _dbProvider.CreateDbContext(); |
| | | 1179 | | |
| | 64 | 1180 | | var query = context.ItemValuesMap |
| | 64 | 1181 | | .AsNoTracking() |
| | 64 | 1182 | | .Where(e => itemValueTypes.Any(w => (ItemValueType)w == e.ItemValue.Type)); |
| | 64 | 1183 | | if (withItemTypes.Count > 0) |
| | | 1184 | | { |
| | 16 | 1185 | | query = query.Where(e => withItemTypes.Contains(e.Item.Type)); |
| | | 1186 | | } |
| | | 1187 | | |
| | 64 | 1188 | | if (excludeItemTypes.Count > 0) |
| | | 1189 | | { |
| | 16 | 1190 | | query = query.Where(e => !excludeItemTypes.Contains(e.Item.Type)); |
| | | 1191 | | } |
| | | 1192 | | |
| | | 1193 | | // query = query.DistinctBy(e => e.CleanValue); |
| | 64 | 1194 | | return query.Select(e => e.ItemValue) |
| | 64 | 1195 | | .GroupBy(e => e.CleanValue) |
| | 64 | 1196 | | .Select(e => e.First().Value) |
| | 64 | 1197 | | .ToArray(); |
| | 64 | 1198 | | } |
| | | 1199 | | |
| | | 1200 | | private static bool TypeRequiresDeserialization(Type type) |
| | | 1201 | | { |
| | 191 | 1202 | | return type.GetCustomAttribute<RequiresSourceSerialisationAttribute>() == null; |
| | | 1203 | | } |
| | | 1204 | | |
| | | 1205 | | private BaseItemDto? DeserializeBaseItem(BaseItemEntity baseItemEntity, bool skipDeserialization = false) |
| | | 1206 | | { |
| | 70 | 1207 | | ArgumentNullException.ThrowIfNull(baseItemEntity, nameof(baseItemEntity)); |
| | 70 | 1208 | | if (_serverConfigurationManager?.Configuration is null) |
| | | 1209 | | { |
| | 0 | 1210 | | throw new InvalidOperationException("Server Configuration manager or configuration is null"); |
| | | 1211 | | } |
| | | 1212 | | |
| | 70 | 1213 | | var typeToSerialise = GetType(baseItemEntity.Type); |
| | 70 | 1214 | | return BaseItemRepository.DeserializeBaseItem( |
| | 70 | 1215 | | baseItemEntity, |
| | 70 | 1216 | | _logger, |
| | 70 | 1217 | | _appHost, |
| | 70 | 1218 | | skipDeserialization || (_serverConfigurationManager.Configuration.SkipDeserializationForBasicTypes && (typeT |
| | | 1219 | | } |
| | | 1220 | | |
| | | 1221 | | /// <summary> |
| | | 1222 | | /// Deserializes a BaseItemEntity and sets all properties. |
| | | 1223 | | /// </summary> |
| | | 1224 | | /// <param name="baseItemEntity">The DB entity.</param> |
| | | 1225 | | /// <param name="logger">Logger.</param> |
| | | 1226 | | /// <param name="appHost">The application server Host.</param> |
| | | 1227 | | /// <param name="skipDeserialization">If only mapping should be processed.</param> |
| | | 1228 | | /// <returns>A mapped BaseItem, or null if the item type is unknown.</returns> |
| | | 1229 | | public static BaseItemDto? DeserializeBaseItem(BaseItemEntity baseItemEntity, ILogger logger, IServerApplicationHost |
| | | 1230 | | { |
| | 73 | 1231 | | var type = GetType(baseItemEntity.Type); |
| | 73 | 1232 | | if (type is null) |
| | | 1233 | | { |
| | 2 | 1234 | | logger.LogWarning( |
| | 2 | 1235 | | "Skipping item {ItemId} with unknown type '{ItemType}'. This may indicate a removed plugin or database c |
| | 2 | 1236 | | baseItemEntity.Id, |
| | 2 | 1237 | | baseItemEntity.Type); |
| | 2 | 1238 | | return null; |
| | | 1239 | | } |
| | | 1240 | | |
| | 71 | 1241 | | BaseItemDto? dto = null; |
| | 71 | 1242 | | if (TypeRequiresDeserialization(type) && baseItemEntity.Data is not null && !skipDeserialization) |
| | | 1243 | | { |
| | | 1244 | | try |
| | | 1245 | | { |
| | 12 | 1246 | | dto = JsonSerializer.Deserialize(baseItemEntity.Data, type, JsonDefaults.Options) as BaseItemDto; |
| | 12 | 1247 | | } |
| | 0 | 1248 | | catch (JsonException ex) |
| | | 1249 | | { |
| | 0 | 1250 | | logger.LogError(ex, "Error deserializing item with JSON: {Data}", baseItemEntity.Data); |
| | 0 | 1251 | | } |
| | | 1252 | | } |
| | | 1253 | | |
| | 71 | 1254 | | if (dto is null) |
| | | 1255 | | { |
| | 59 | 1256 | | dto = Activator.CreateInstance(type) as BaseItemDto ?? throw new InvalidOperationException("Cannot deseriali |
| | | 1257 | | } |
| | | 1258 | | |
| | 71 | 1259 | | return Map(baseItemEntity, dto, appHost, logger); |
| | | 1260 | | } |
| | | 1261 | | |
| | | 1262 | | private QueryResult<(BaseItemDto Item, ItemCounts? ItemCounts)> GetItemValues(InternalItemsQuery filter, IReadOnlyLi |
| | | 1263 | | { |
| | 0 | 1264 | | ArgumentNullException.ThrowIfNull(filter); |
| | | 1265 | | |
| | 0 | 1266 | | if (!(filter.Limit.HasValue && filter.Limit.Value > 0)) |
| | | 1267 | | { |
| | 0 | 1268 | | filter.EnableTotalRecordCount = false; |
| | | 1269 | | } |
| | | 1270 | | |
| | 0 | 1271 | | using var context = _dbProvider.CreateDbContext(); |
| | | 1272 | | |
| | 0 | 1273 | | var innerQueryFilter = TranslateQuery(context.BaseItems.Where(e => e.Id != EF.Constant(PlaceholderId)), context, |
| | 0 | 1274 | | { |
| | 0 | 1275 | | ExcludeItemTypes = filter.ExcludeItemTypes, |
| | 0 | 1276 | | IncludeItemTypes = filter.IncludeItemTypes, |
| | 0 | 1277 | | MediaTypes = filter.MediaTypes, |
| | 0 | 1278 | | AncestorIds = filter.AncestorIds, |
| | 0 | 1279 | | ItemIds = filter.ItemIds, |
| | 0 | 1280 | | TopParentIds = filter.TopParentIds, |
| | 0 | 1281 | | ParentId = filter.ParentId, |
| | 0 | 1282 | | IsAiring = filter.IsAiring, |
| | 0 | 1283 | | IsMovie = filter.IsMovie, |
| | 0 | 1284 | | IsSports = filter.IsSports, |
| | 0 | 1285 | | IsKids = filter.IsKids, |
| | 0 | 1286 | | IsNews = filter.IsNews, |
| | 0 | 1287 | | IsSeries = filter.IsSeries |
| | 0 | 1288 | | }); |
| | | 1289 | | |
| | 0 | 1290 | | var itemValuesQuery = context.ItemValues |
| | 0 | 1291 | | .Where(f => itemValueTypes.Contains(f.Type)) |
| | 0 | 1292 | | .SelectMany(f => f.BaseItemsMap!, (f, w) => new { f, w }) |
| | 0 | 1293 | | .Join( |
| | 0 | 1294 | | innerQueryFilter, |
| | 0 | 1295 | | fw => fw.w.ItemId, |
| | 0 | 1296 | | g => g.Id, |
| | 0 | 1297 | | (fw, g) => fw.f.CleanValue); |
| | | 1298 | | |
| | 0 | 1299 | | var innerQuery = PrepareItemQuery(context, filter) |
| | 0 | 1300 | | .Where(e => e.Type == returnType) |
| | 0 | 1301 | | .Where(e => itemValuesQuery.Contains(e.CleanName)); |
| | | 1302 | | |
| | 0 | 1303 | | var outerQueryFilter = new InternalItemsQuery(filter.User) |
| | 0 | 1304 | | { |
| | 0 | 1305 | | IsPlayed = filter.IsPlayed, |
| | 0 | 1306 | | IsFavorite = filter.IsFavorite, |
| | 0 | 1307 | | IsFavoriteOrLiked = filter.IsFavoriteOrLiked, |
| | 0 | 1308 | | IsLiked = filter.IsLiked, |
| | 0 | 1309 | | IsLocked = filter.IsLocked, |
| | 0 | 1310 | | NameLessThan = filter.NameLessThan, |
| | 0 | 1311 | | NameStartsWith = filter.NameStartsWith, |
| | 0 | 1312 | | NameStartsWithOrGreater = filter.NameStartsWithOrGreater, |
| | 0 | 1313 | | Tags = filter.Tags, |
| | 0 | 1314 | | OfficialRatings = filter.OfficialRatings, |
| | 0 | 1315 | | StudioIds = filter.StudioIds, |
| | 0 | 1316 | | GenreIds = filter.GenreIds, |
| | 0 | 1317 | | Genres = filter.Genres, |
| | 0 | 1318 | | Years = filter.Years, |
| | 0 | 1319 | | NameContains = filter.NameContains, |
| | 0 | 1320 | | SearchTerm = filter.SearchTerm, |
| | 0 | 1321 | | ExcludeItemIds = filter.ExcludeItemIds |
| | 0 | 1322 | | }; |
| | | 1323 | | |
| | 0 | 1324 | | var masterQuery = TranslateQuery(innerQuery, context, outerQueryFilter) |
| | 0 | 1325 | | .GroupBy(e => e.PresentationUniqueKey) |
| | 0 | 1326 | | .Select(e => e.FirstOrDefault()) |
| | 0 | 1327 | | .Select(e => e!.Id); |
| | | 1328 | | |
| | 0 | 1329 | | var query = context.BaseItems |
| | 0 | 1330 | | .Include(e => e.TrailerTypes) |
| | 0 | 1331 | | .Include(e => e.Provider) |
| | 0 | 1332 | | .Include(e => e.LockedFields) |
| | 0 | 1333 | | .Include(e => e.Images) |
| | 0 | 1334 | | .AsSingleQuery() |
| | 0 | 1335 | | .Where(e => masterQuery.Contains(e.Id)); |
| | | 1336 | | |
| | 0 | 1337 | | query = ApplyOrder(query, filter, context); |
| | | 1338 | | |
| | 0 | 1339 | | var result = new QueryResult<(BaseItemDto, ItemCounts?)>(); |
| | 0 | 1340 | | if (filter.EnableTotalRecordCount) |
| | | 1341 | | { |
| | 0 | 1342 | | result.TotalRecordCount = query.Count(); |
| | | 1343 | | } |
| | | 1344 | | |
| | 0 | 1345 | | if (filter.StartIndex.HasValue && filter.StartIndex.Value > 0) |
| | | 1346 | | { |
| | 0 | 1347 | | query = query.Skip(filter.StartIndex.Value); |
| | | 1348 | | } |
| | | 1349 | | |
| | 0 | 1350 | | if (filter.Limit.HasValue && filter.Limit.Value > 0) |
| | | 1351 | | { |
| | 0 | 1352 | | query = query.Take(filter.Limit.Value); |
| | | 1353 | | } |
| | | 1354 | | |
| | 0 | 1355 | | IQueryable<BaseItemEntity>? itemCountQuery = null; |
| | | 1356 | | |
| | 0 | 1357 | | if (filter.IncludeItemTypes.Length > 0) |
| | | 1358 | | { |
| | | 1359 | | // if we are to include more then one type, sub query those items beforehand. |
| | | 1360 | | |
| | 0 | 1361 | | var typeSubQuery = new InternalItemsQuery(filter.User) |
| | 0 | 1362 | | { |
| | 0 | 1363 | | ExcludeItemTypes = filter.ExcludeItemTypes, |
| | 0 | 1364 | | IncludeItemTypes = filter.IncludeItemTypes, |
| | 0 | 1365 | | MediaTypes = filter.MediaTypes, |
| | 0 | 1366 | | AncestorIds = filter.AncestorIds, |
| | 0 | 1367 | | ExcludeItemIds = filter.ExcludeItemIds, |
| | 0 | 1368 | | ItemIds = filter.ItemIds, |
| | 0 | 1369 | | TopParentIds = filter.TopParentIds, |
| | 0 | 1370 | | ParentId = filter.ParentId, |
| | 0 | 1371 | | IsPlayed = filter.IsPlayed |
| | 0 | 1372 | | }; |
| | | 1373 | | |
| | 0 | 1374 | | itemCountQuery = TranslateQuery(context.BaseItems.AsNoTracking().Where(e => e.Id != EF.Constant(PlaceholderI |
| | 0 | 1375 | | .Where(e => e.ItemValues!.Any(f => itemValueTypes!.Contains(f.ItemValue.Type))); |
| | | 1376 | | |
| | 0 | 1377 | | var seriesTypeName = _itemTypeLookup.BaseItemKindNames[BaseItemKind.Series]; |
| | 0 | 1378 | | var movieTypeName = _itemTypeLookup.BaseItemKindNames[BaseItemKind.Movie]; |
| | 0 | 1379 | | var episodeTypeName = _itemTypeLookup.BaseItemKindNames[BaseItemKind.Episode]; |
| | 0 | 1380 | | var musicAlbumTypeName = _itemTypeLookup.BaseItemKindNames[BaseItemKind.MusicAlbum]; |
| | 0 | 1381 | | var musicArtistTypeName = _itemTypeLookup.BaseItemKindNames[BaseItemKind.MusicArtist]; |
| | 0 | 1382 | | var audioTypeName = _itemTypeLookup.BaseItemKindNames[BaseItemKind.Audio]; |
| | 0 | 1383 | | var trailerTypeName = _itemTypeLookup.BaseItemKindNames[BaseItemKind.Trailer]; |
| | | 1384 | | |
| | 0 | 1385 | | var resultQuery = query.Select(e => new |
| | 0 | 1386 | | { |
| | 0 | 1387 | | item = e, |
| | 0 | 1388 | | // TODO: This is bad refactor! |
| | 0 | 1389 | | itemCount = new ItemCounts() |
| | 0 | 1390 | | { |
| | 0 | 1391 | | SeriesCount = itemCountQuery!.Count(f => f.Type == seriesTypeName), |
| | 0 | 1392 | | EpisodeCount = itemCountQuery!.Count(f => f.Type == episodeTypeName), |
| | 0 | 1393 | | MovieCount = itemCountQuery!.Count(f => f.Type == movieTypeName), |
| | 0 | 1394 | | AlbumCount = itemCountQuery!.Count(f => f.Type == musicAlbumTypeName), |
| | 0 | 1395 | | ArtistCount = itemCountQuery!.Count(f => f.Type == musicArtistTypeName), |
| | 0 | 1396 | | SongCount = itemCountQuery!.Count(f => f.Type == audioTypeName), |
| | 0 | 1397 | | TrailerCount = itemCountQuery!.Count(f => f.Type == trailerTypeName), |
| | 0 | 1398 | | } |
| | 0 | 1399 | | }); |
| | | 1400 | | |
| | 0 | 1401 | | result.StartIndex = filter.StartIndex ?? 0; |
| | 0 | 1402 | | result.Items = |
| | 0 | 1403 | | [ |
| | 0 | 1404 | | .. resultQuery |
| | 0 | 1405 | | .AsEnumerable() |
| | 0 | 1406 | | .Where(e => e is not null) |
| | 0 | 1407 | | .Select(e => (Item: DeserializeBaseItem(e.item, filter.SkipDeserialization), e.itemCount)) |
| | 0 | 1408 | | .Where(e => e.Item is not null) |
| | 0 | 1409 | | .Select(e => (e.Item!, e.itemCount)) |
| | 0 | 1410 | | ]; |
| | | 1411 | | } |
| | | 1412 | | else |
| | | 1413 | | { |
| | 0 | 1414 | | result.StartIndex = filter.StartIndex ?? 0; |
| | 0 | 1415 | | result.Items = |
| | 0 | 1416 | | [ |
| | 0 | 1417 | | .. query |
| | 0 | 1418 | | .AsEnumerable() |
| | 0 | 1419 | | .Where(e => e is not null) |
| | 0 | 1420 | | .Select(e => (Item: DeserializeBaseItem(e, filter.SkipDeserialization), ItemCounts: (ItemCounts?)nul |
| | 0 | 1421 | | .Where(e => e.Item is not null) |
| | 0 | 1422 | | .Select(e => (e.Item!, e.ItemCounts)) |
| | 0 | 1423 | | ]; |
| | | 1424 | | } |
| | | 1425 | | |
| | 0 | 1426 | | return result; |
| | 0 | 1427 | | } |
| | | 1428 | | |
| | | 1429 | | private static void PrepareFilterQuery(InternalItemsQuery query) |
| | | 1430 | | { |
| | 336 | 1431 | | if (query.Limit.HasValue && query.Limit.Value > 0 && query.EnableGroupByMetadataKey) |
| | | 1432 | | { |
| | 0 | 1433 | | query.Limit = query.Limit.Value + 4; |
| | | 1434 | | } |
| | | 1435 | | |
| | 336 | 1436 | | if (query.IsResumable ?? false) |
| | | 1437 | | { |
| | 1 | 1438 | | query.IsVirtualItem = false; |
| | | 1439 | | } |
| | 336 | 1440 | | } |
| | | 1441 | | |
| | | 1442 | | /// <summary> |
| | | 1443 | | /// Gets the clean value for search and sorting purposes. |
| | | 1444 | | /// </summary> |
| | | 1445 | | /// <param name="value">The value to clean.</param> |
| | | 1446 | | /// <returns>The cleaned value.</returns> |
| | | 1447 | | public static string GetCleanValue(string value) |
| | | 1448 | | { |
| | 123 | 1449 | | if (string.IsNullOrWhiteSpace(value)) |
| | | 1450 | | { |
| | 0 | 1451 | | return value; |
| | | 1452 | | } |
| | | 1453 | | |
| | 123 | 1454 | | var noDiacritics = value.RemoveDiacritics(); |
| | | 1455 | | |
| | | 1456 | | // Build a string where any punctuation or symbol is treated as a separator (space). |
| | 123 | 1457 | | var sb = new StringBuilder(noDiacritics.Length); |
| | 123 | 1458 | | var previousWasSpace = false; |
| | 2072 | 1459 | | foreach (var ch in noDiacritics) |
| | | 1460 | | { |
| | | 1461 | | char outCh; |
| | 913 | 1462 | | if (char.IsLetterOrDigit(ch) || char.IsWhiteSpace(ch)) |
| | | 1463 | | { |
| | 891 | 1464 | | outCh = ch; |
| | | 1465 | | } |
| | | 1466 | | else |
| | | 1467 | | { |
| | 22 | 1468 | | outCh = ' '; |
| | | 1469 | | } |
| | | 1470 | | |
| | | 1471 | | // normalize any whitespace character to a single ASCII space. |
| | 913 | 1472 | | if (char.IsWhiteSpace(outCh)) |
| | | 1473 | | { |
| | 51 | 1474 | | if (!previousWasSpace) |
| | | 1475 | | { |
| | 40 | 1476 | | sb.Append(' '); |
| | 40 | 1477 | | previousWasSpace = true; |
| | | 1478 | | } |
| | | 1479 | | } |
| | | 1480 | | else |
| | | 1481 | | { |
| | 862 | 1482 | | sb.Append(outCh); |
| | 862 | 1483 | | previousWasSpace = false; |
| | | 1484 | | } |
| | | 1485 | | } |
| | | 1486 | | |
| | | 1487 | | // trim leading/trailing spaces that may have been added. |
| | 123 | 1488 | | var collapsed = sb.ToString().Trim(); |
| | 123 | 1489 | | return collapsed.ToLowerInvariant(); |
| | | 1490 | | } |
| | | 1491 | | |
| | | 1492 | | private List<(ItemValueType MagicNumber, string Value)> GetItemValuesToSave(BaseItemDto item, List<string> inherited |
| | | 1493 | | { |
| | 110 | 1494 | | var list = new List<(ItemValueType, string)>(); |
| | | 1495 | | |
| | 110 | 1496 | | if (item is IHasArtist hasArtist) |
| | | 1497 | | { |
| | 0 | 1498 | | list.AddRange(hasArtist.Artists.Select(i => ((ItemValueType)0, i))); |
| | | 1499 | | } |
| | | 1500 | | |
| | 110 | 1501 | | if (item is IHasAlbumArtist hasAlbumArtist) |
| | | 1502 | | { |
| | 0 | 1503 | | list.AddRange(hasAlbumArtist.AlbumArtists.Select(i => (ItemValueType.AlbumArtist, i))); |
| | | 1504 | | } |
| | | 1505 | | |
| | 110 | 1506 | | list.AddRange(item.Genres.Select(i => (ItemValueType.Genre, i))); |
| | 110 | 1507 | | list.AddRange(item.Studios.Select(i => (ItemValueType.Studios, i))); |
| | 110 | 1508 | | list.AddRange(item.Tags.Select(i => (ItemValueType.Tags, i))); |
| | | 1509 | | |
| | | 1510 | | // keywords was 5 |
| | | 1511 | | |
| | 110 | 1512 | | list.AddRange(inheritedTags.Select(i => (ItemValueType.InheritedTags, i))); |
| | | 1513 | | |
| | | 1514 | | // Remove all invalid values. |
| | 110 | 1515 | | list.RemoveAll(i => string.IsNullOrWhiteSpace(i.Item2)); |
| | | 1516 | | |
| | 110 | 1517 | | return list; |
| | | 1518 | | } |
| | | 1519 | | |
| | | 1520 | | private static BaseItemImageInfo Map(Guid baseItemId, ItemImageInfo e) |
| | | 1521 | | { |
| | 0 | 1522 | | return new BaseItemImageInfo() |
| | 0 | 1523 | | { |
| | 0 | 1524 | | ItemId = baseItemId, |
| | 0 | 1525 | | Id = Guid.NewGuid(), |
| | 0 | 1526 | | Path = e.Path, |
| | 0 | 1527 | | Blurhash = e.BlurHash is null ? null : Encoding.UTF8.GetBytes(e.BlurHash), |
| | 0 | 1528 | | DateModified = e.DateModified, |
| | 0 | 1529 | | Height = e.Height, |
| | 0 | 1530 | | Width = e.Width, |
| | 0 | 1531 | | ImageType = (ImageInfoImageType)e.Type, |
| | 0 | 1532 | | Item = null! |
| | 0 | 1533 | | }; |
| | | 1534 | | } |
| | | 1535 | | |
| | | 1536 | | private static ItemImageInfo Map(BaseItemImageInfo e, IServerApplicationHost? appHost) |
| | | 1537 | | { |
| | 0 | 1538 | | return new ItemImageInfo() |
| | 0 | 1539 | | { |
| | 0 | 1540 | | Path = appHost?.ExpandVirtualPath(e.Path) ?? e.Path, |
| | 0 | 1541 | | BlurHash = e.Blurhash is null ? null : Encoding.UTF8.GetString(e.Blurhash), |
| | 0 | 1542 | | DateModified = e.DateModified ?? DateTime.SpecifyKind(DateTime.MinValue, DateTimeKind.Utc), |
| | 0 | 1543 | | Height = e.Height, |
| | 0 | 1544 | | Width = e.Width, |
| | 0 | 1545 | | Type = (ImageType)e.ImageType |
| | 0 | 1546 | | }; |
| | | 1547 | | } |
| | | 1548 | | |
| | | 1549 | | private string? GetPathToSave(string path) |
| | | 1550 | | { |
| | 120 | 1551 | | if (path is null) |
| | | 1552 | | { |
| | 10 | 1553 | | return null; |
| | | 1554 | | } |
| | | 1555 | | |
| | 110 | 1556 | | return _appHost.ReverseVirtualPath(path); |
| | | 1557 | | } |
| | | 1558 | | |
| | | 1559 | | private List<string> GetItemByNameTypesInQuery(InternalItemsQuery query) |
| | | 1560 | | { |
| | 15 | 1561 | | var list = new List<string>(); |
| | | 1562 | | |
| | 15 | 1563 | | if (IsTypeInQuery(BaseItemKind.Person, query)) |
| | | 1564 | | { |
| | 1 | 1565 | | list.Add(_itemTypeLookup.BaseItemKindNames[BaseItemKind.Person]!); |
| | | 1566 | | } |
| | | 1567 | | |
| | 15 | 1568 | | if (IsTypeInQuery(BaseItemKind.Genre, query)) |
| | | 1569 | | { |
| | 1 | 1570 | | list.Add(_itemTypeLookup.BaseItemKindNames[BaseItemKind.Genre]!); |
| | | 1571 | | } |
| | | 1572 | | |
| | 15 | 1573 | | if (IsTypeInQuery(BaseItemKind.MusicGenre, query)) |
| | | 1574 | | { |
| | 1 | 1575 | | list.Add(_itemTypeLookup.BaseItemKindNames[BaseItemKind.MusicGenre]!); |
| | | 1576 | | } |
| | | 1577 | | |
| | 15 | 1578 | | if (IsTypeInQuery(BaseItemKind.MusicArtist, query)) |
| | | 1579 | | { |
| | 1 | 1580 | | list.Add(_itemTypeLookup.BaseItemKindNames[BaseItemKind.MusicArtist]!); |
| | | 1581 | | } |
| | | 1582 | | |
| | 15 | 1583 | | if (IsTypeInQuery(BaseItemKind.Studio, query)) |
| | | 1584 | | { |
| | 1 | 1585 | | list.Add(_itemTypeLookup.BaseItemKindNames[BaseItemKind.Studio]!); |
| | | 1586 | | } |
| | | 1587 | | |
| | 15 | 1588 | | return list; |
| | | 1589 | | } |
| | | 1590 | | |
| | | 1591 | | private bool IsTypeInQuery(BaseItemKind type, InternalItemsQuery query) |
| | | 1592 | | { |
| | 75 | 1593 | | if (query.ExcludeItemTypes.Contains(type)) |
| | | 1594 | | { |
| | 0 | 1595 | | return false; |
| | | 1596 | | } |
| | | 1597 | | |
| | 75 | 1598 | | return query.IncludeItemTypes.Length == 0 || query.IncludeItemTypes.Contains(type); |
| | | 1599 | | } |
| | | 1600 | | |
| | | 1601 | | private bool EnableGroupByPresentationUniqueKey(InternalItemsQuery query) |
| | | 1602 | | { |
| | 335 | 1603 | | if (!query.GroupByPresentationUniqueKey) |
| | | 1604 | | { |
| | 142 | 1605 | | return false; |
| | | 1606 | | } |
| | | 1607 | | |
| | 193 | 1608 | | if (query.GroupBySeriesPresentationUniqueKey) |
| | | 1609 | | { |
| | 0 | 1610 | | return false; |
| | | 1611 | | } |
| | | 1612 | | |
| | 193 | 1613 | | if (!string.IsNullOrWhiteSpace(query.PresentationUniqueKey)) |
| | | 1614 | | { |
| | 0 | 1615 | | return false; |
| | | 1616 | | } |
| | | 1617 | | |
| | 193 | 1618 | | if (query.User is null) |
| | | 1619 | | { |
| | 191 | 1620 | | return false; |
| | | 1621 | | } |
| | | 1622 | | |
| | 2 | 1623 | | if (query.IncludeItemTypes.Length == 0) |
| | | 1624 | | { |
| | 1 | 1625 | | return true; |
| | | 1626 | | } |
| | | 1627 | | |
| | 1 | 1628 | | return query.IncludeItemTypes.Contains(BaseItemKind.Episode) |
| | 1 | 1629 | | || query.IncludeItemTypes.Contains(BaseItemKind.Video) |
| | 1 | 1630 | | || query.IncludeItemTypes.Contains(BaseItemKind.Movie) |
| | 1 | 1631 | | || query.IncludeItemTypes.Contains(BaseItemKind.MusicVideo) |
| | 1 | 1632 | | || query.IncludeItemTypes.Contains(BaseItemKind.Series) |
| | 1 | 1633 | | || query.IncludeItemTypes.Contains(BaseItemKind.Season); |
| | | 1634 | | } |
| | | 1635 | | |
| | | 1636 | | private IQueryable<BaseItemEntity> ApplyOrder(IQueryable<BaseItemEntity> query, InternalItemsQuery filter, JellyfinD |
| | | 1637 | | { |
| | 335 | 1638 | | var orderBy = filter.OrderBy.Where(e => e.OrderBy != ItemSortBy.Default).ToArray(); |
| | 335 | 1639 | | var hasSearch = !string.IsNullOrEmpty(filter.SearchTerm); |
| | | 1640 | | |
| | 335 | 1641 | | if (hasSearch) |
| | | 1642 | | { |
| | 0 | 1643 | | orderBy = [(ItemSortBy.SortName, SortOrder.Ascending), .. orderBy]; |
| | | 1644 | | } |
| | 335 | 1645 | | else if (orderBy.Length == 0) |
| | | 1646 | | { |
| | 231 | 1647 | | return query.OrderBy(e => e.SortName); |
| | | 1648 | | } |
| | | 1649 | | |
| | 104 | 1650 | | IOrderedQueryable<BaseItemEntity>? orderedQuery = null; |
| | | 1651 | | |
| | | 1652 | | // When searching, prioritize by match quality: exact match > prefix match > contains |
| | 104 | 1653 | | if (hasSearch) |
| | | 1654 | | { |
| | 0 | 1655 | | orderedQuery = query.OrderBy(OrderMapper.MapSearchRelevanceOrder(filter.SearchTerm!)); |
| | | 1656 | | } |
| | | 1657 | | |
| | 104 | 1658 | | var firstOrdering = orderBy.FirstOrDefault(); |
| | 104 | 1659 | | if (firstOrdering != default) |
| | | 1660 | | { |
| | 104 | 1661 | | var expression = OrderMapper.MapOrderByField(firstOrdering.OrderBy, filter, context); |
| | 104 | 1662 | | if (orderedQuery is null) |
| | | 1663 | | { |
| | | 1664 | | // No search relevance ordering, start fresh |
| | 104 | 1665 | | orderedQuery = firstOrdering.SortOrder == SortOrder.Ascending |
| | 104 | 1666 | | ? query.OrderBy(expression) |
| | 104 | 1667 | | : query.OrderByDescending(expression); |
| | | 1668 | | } |
| | | 1669 | | else |
| | | 1670 | | { |
| | | 1671 | | // Search relevance ordering already applied, chain with ThenBy |
| | 0 | 1672 | | orderedQuery = firstOrdering.SortOrder == SortOrder.Ascending |
| | 0 | 1673 | | ? orderedQuery.ThenBy(expression) |
| | 0 | 1674 | | : orderedQuery.ThenByDescending(expression); |
| | | 1675 | | } |
| | | 1676 | | |
| | 104 | 1677 | | if (firstOrdering.OrderBy is ItemSortBy.Default or ItemSortBy.SortName) |
| | | 1678 | | { |
| | 0 | 1679 | | orderedQuery = firstOrdering.SortOrder is SortOrder.Ascending |
| | 0 | 1680 | | ? orderedQuery.ThenBy(e => e.Name) |
| | 0 | 1681 | | : orderedQuery.ThenByDescending(e => e.Name); |
| | | 1682 | | } |
| | | 1683 | | } |
| | | 1684 | | |
| | 290 | 1685 | | foreach (var item in orderBy.Skip(1)) |
| | | 1686 | | { |
| | 41 | 1687 | | var expression = OrderMapper.MapOrderByField(item.OrderBy, filter, context); |
| | 41 | 1688 | | if (item.SortOrder == SortOrder.Ascending) |
| | | 1689 | | { |
| | 41 | 1690 | | orderedQuery = orderedQuery!.ThenBy(expression); |
| | | 1691 | | } |
| | | 1692 | | else |
| | | 1693 | | { |
| | 0 | 1694 | | orderedQuery = orderedQuery!.ThenByDescending(expression); |
| | | 1695 | | } |
| | | 1696 | | } |
| | | 1697 | | |
| | 104 | 1698 | | return orderedQuery ?? query; |
| | | 1699 | | } |
| | | 1700 | | |
| | | 1701 | | private IQueryable<BaseItemEntity> TranslateQuery( |
| | | 1702 | | IQueryable<BaseItemEntity> baseQuery, |
| | | 1703 | | JellyfinDbContext context, |
| | | 1704 | | InternalItemsQuery filter) |
| | | 1705 | | { |
| | | 1706 | | const int HDWidth = 1200; |
| | | 1707 | | const int UHDWidth = 3800; |
| | | 1708 | | const int UHDHeight = 2100; |
| | | 1709 | | |
| | 335 | 1710 | | var minWidth = filter.MinWidth; |
| | 335 | 1711 | | var maxWidth = filter.MaxWidth; |
| | 335 | 1712 | | var now = DateTime.UtcNow; |
| | | 1713 | | |
| | 335 | 1714 | | if (filter.IsHD.HasValue || filter.Is4K.HasValue) |
| | | 1715 | | { |
| | 0 | 1716 | | bool includeSD = false; |
| | 0 | 1717 | | bool includeHD = false; |
| | 0 | 1718 | | bool include4K = false; |
| | | 1719 | | |
| | 0 | 1720 | | if (filter.IsHD.HasValue && !filter.IsHD.Value) |
| | | 1721 | | { |
| | 0 | 1722 | | includeSD = true; |
| | | 1723 | | } |
| | | 1724 | | |
| | 0 | 1725 | | if (filter.IsHD.HasValue && filter.IsHD.Value) |
| | | 1726 | | { |
| | 0 | 1727 | | includeHD = true; |
| | | 1728 | | } |
| | | 1729 | | |
| | 0 | 1730 | | if (filter.Is4K.HasValue && filter.Is4K.Value) |
| | | 1731 | | { |
| | 0 | 1732 | | include4K = true; |
| | | 1733 | | } |
| | | 1734 | | |
| | 0 | 1735 | | baseQuery = baseQuery.Where(e => |
| | 0 | 1736 | | (includeSD && e.Width < HDWidth) || |
| | 0 | 1737 | | (includeHD && e.Width >= HDWidth && !(e.Width >= UHDWidth || e.Height >= UHDHeight)) || |
| | 0 | 1738 | | (include4K && (e.Width >= UHDWidth || e.Height >= UHDHeight))); |
| | | 1739 | | } |
| | | 1740 | | |
| | 335 | 1741 | | if (minWidth.HasValue) |
| | | 1742 | | { |
| | 0 | 1743 | | baseQuery = baseQuery.Where(e => e.Width >= minWidth); |
| | | 1744 | | } |
| | | 1745 | | |
| | 335 | 1746 | | if (filter.MinHeight.HasValue) |
| | | 1747 | | { |
| | 0 | 1748 | | baseQuery = baseQuery.Where(e => e.Height >= filter.MinHeight); |
| | | 1749 | | } |
| | | 1750 | | |
| | 335 | 1751 | | if (maxWidth.HasValue) |
| | | 1752 | | { |
| | 0 | 1753 | | baseQuery = baseQuery.Where(e => e.Width <= maxWidth); |
| | | 1754 | | } |
| | | 1755 | | |
| | 335 | 1756 | | if (filter.MaxHeight.HasValue) |
| | | 1757 | | { |
| | 0 | 1758 | | baseQuery = baseQuery.Where(e => e.Height <= filter.MaxHeight); |
| | | 1759 | | } |
| | | 1760 | | |
| | 335 | 1761 | | if (filter.IsLocked.HasValue) |
| | | 1762 | | { |
| | 48 | 1763 | | baseQuery = baseQuery.Where(e => e.IsLocked == filter.IsLocked); |
| | | 1764 | | } |
| | | 1765 | | |
| | 335 | 1766 | | var tags = filter.Tags.ToList(); |
| | 335 | 1767 | | var excludeTags = filter.ExcludeTags.ToList(); |
| | | 1768 | | |
| | 335 | 1769 | | if (filter.IsMovie.HasValue) |
| | | 1770 | | { |
| | 0 | 1771 | | var shouldIncludeAllMovieTypes = filter.IsMovie.Value |
| | 0 | 1772 | | && (filter.IncludeItemTypes.Length == 0 |
| | 0 | 1773 | | || filter.IncludeItemTypes.Contains(BaseItemKind.Movie) |
| | 0 | 1774 | | || filter.IncludeItemTypes.Contains(BaseItemKind.Trailer)); |
| | | 1775 | | |
| | 0 | 1776 | | if (!shouldIncludeAllMovieTypes) |
| | | 1777 | | { |
| | 0 | 1778 | | baseQuery = baseQuery.Where(e => e.IsMovie == filter.IsMovie.Value); |
| | | 1779 | | } |
| | | 1780 | | } |
| | | 1781 | | |
| | 335 | 1782 | | if (filter.IsSeries.HasValue) |
| | | 1783 | | { |
| | 0 | 1784 | | baseQuery = baseQuery.Where(e => e.IsSeries == filter.IsSeries); |
| | | 1785 | | } |
| | | 1786 | | |
| | 335 | 1787 | | if (filter.IsSports.HasValue) |
| | | 1788 | | { |
| | 0 | 1789 | | if (filter.IsSports.Value) |
| | | 1790 | | { |
| | 0 | 1791 | | tags.Add("Sports"); |
| | | 1792 | | } |
| | | 1793 | | else |
| | | 1794 | | { |
| | 0 | 1795 | | excludeTags.Add("Sports"); |
| | | 1796 | | } |
| | | 1797 | | } |
| | | 1798 | | |
| | 335 | 1799 | | if (filter.IsNews.HasValue) |
| | | 1800 | | { |
| | 0 | 1801 | | if (filter.IsNews.Value) |
| | | 1802 | | { |
| | 0 | 1803 | | tags.Add("News"); |
| | | 1804 | | } |
| | | 1805 | | else |
| | | 1806 | | { |
| | 0 | 1807 | | excludeTags.Add("News"); |
| | | 1808 | | } |
| | | 1809 | | } |
| | | 1810 | | |
| | 335 | 1811 | | if (filter.IsKids.HasValue) |
| | | 1812 | | { |
| | 0 | 1813 | | if (filter.IsKids.Value) |
| | | 1814 | | { |
| | 0 | 1815 | | tags.Add("Kids"); |
| | | 1816 | | } |
| | | 1817 | | else |
| | | 1818 | | { |
| | 0 | 1819 | | excludeTags.Add("Kids"); |
| | | 1820 | | } |
| | | 1821 | | } |
| | | 1822 | | |
| | 335 | 1823 | | if (!string.IsNullOrEmpty(filter.SearchTerm)) |
| | | 1824 | | { |
| | 0 | 1825 | | var cleanedSearchTerm = GetCleanValue(filter.SearchTerm); |
| | 0 | 1826 | | var originalSearchTerm = filter.SearchTerm.ToLower(); |
| | 0 | 1827 | | if (SearchWildcardTerms.Any(f => cleanedSearchTerm.Contains(f))) |
| | | 1828 | | { |
| | 0 | 1829 | | cleanedSearchTerm = $"%{cleanedSearchTerm.Trim('%')}%"; |
| | 0 | 1830 | | baseQuery = baseQuery.Where(e => EF.Functions.Like(e.CleanName!, cleanedSearchTerm) || (e.OriginalTitle |
| | | 1831 | | } |
| | | 1832 | | else |
| | | 1833 | | { |
| | 0 | 1834 | | baseQuery = baseQuery.Where(e => e.CleanName!.Contains(cleanedSearchTerm) || (e.OriginalTitle != null && |
| | | 1835 | | } |
| | | 1836 | | } |
| | | 1837 | | |
| | 335 | 1838 | | if (filter.IsFolder.HasValue) |
| | | 1839 | | { |
| | 21 | 1840 | | baseQuery = baseQuery.Where(e => e.IsFolder == filter.IsFolder); |
| | | 1841 | | } |
| | | 1842 | | |
| | 335 | 1843 | | var includeTypes = filter.IncludeItemTypes; |
| | | 1844 | | |
| | | 1845 | | // Only specify excluded types if no included types are specified |
| | 335 | 1846 | | if (filter.IncludeItemTypes.Length == 0) |
| | | 1847 | | { |
| | 221 | 1848 | | var excludeTypes = filter.ExcludeItemTypes; |
| | 221 | 1849 | | if (excludeTypes.Length == 1) |
| | | 1850 | | { |
| | 0 | 1851 | | if (_itemTypeLookup.BaseItemKindNames.TryGetValue(excludeTypes[0], out var excludeTypeName)) |
| | | 1852 | | { |
| | 0 | 1853 | | baseQuery = baseQuery.Where(e => e.Type != excludeTypeName); |
| | | 1854 | | } |
| | | 1855 | | } |
| | 221 | 1856 | | else if (excludeTypes.Length > 1) |
| | | 1857 | | { |
| | 0 | 1858 | | var excludeTypeName = new List<string>(); |
| | 0 | 1859 | | foreach (var excludeType in excludeTypes) |
| | | 1860 | | { |
| | 0 | 1861 | | if (_itemTypeLookup.BaseItemKindNames.TryGetValue(excludeType, out var baseItemKindName)) |
| | | 1862 | | { |
| | 0 | 1863 | | excludeTypeName.Add(baseItemKindName!); |
| | | 1864 | | } |
| | | 1865 | | } |
| | | 1866 | | |
| | 0 | 1867 | | baseQuery = baseQuery.Where(e => !excludeTypeName.Contains(e.Type)); |
| | | 1868 | | } |
| | | 1869 | | } |
| | | 1870 | | else |
| | | 1871 | | { |
| | 114 | 1872 | | string[] types = includeTypes.Select(f => _itemTypeLookup.BaseItemKindNames.GetValueOrDefault(f)).Where(e => |
| | 114 | 1873 | | baseQuery = baseQuery.WhereOneOrMany(types, f => f.Type); |
| | | 1874 | | } |
| | | 1875 | | |
| | 335 | 1876 | | if (filter.ChannelIds.Count > 0) |
| | | 1877 | | { |
| | 0 | 1878 | | baseQuery = baseQuery.Where(e => e.ChannelId != null && filter.ChannelIds.Contains(e.ChannelId.Value)); |
| | | 1879 | | } |
| | | 1880 | | |
| | 335 | 1881 | | if (!filter.ParentId.IsEmpty()) |
| | | 1882 | | { |
| | 142 | 1883 | | baseQuery = baseQuery.Where(e => e.ParentId!.Value == filter.ParentId); |
| | | 1884 | | } |
| | | 1885 | | |
| | 335 | 1886 | | if (!string.IsNullOrWhiteSpace(filter.Path)) |
| | | 1887 | | { |
| | 0 | 1888 | | var pathToQuery = GetPathToSave(filter.Path); |
| | 0 | 1889 | | baseQuery = baseQuery.Where(e => e.Path == pathToQuery); |
| | | 1890 | | } |
| | | 1891 | | |
| | 335 | 1892 | | if (!string.IsNullOrWhiteSpace(filter.PresentationUniqueKey)) |
| | | 1893 | | { |
| | 0 | 1894 | | baseQuery = baseQuery.Where(e => e.PresentationUniqueKey == filter.PresentationUniqueKey); |
| | | 1895 | | } |
| | | 1896 | | |
| | 335 | 1897 | | if (filter.MinCommunityRating.HasValue) |
| | | 1898 | | { |
| | 0 | 1899 | | baseQuery = baseQuery.Where(e => e.CommunityRating >= filter.MinCommunityRating); |
| | | 1900 | | } |
| | | 1901 | | |
| | 335 | 1902 | | if (filter.MinIndexNumber.HasValue) |
| | | 1903 | | { |
| | 0 | 1904 | | baseQuery = baseQuery.Where(e => e.IndexNumber >= filter.MinIndexNumber); |
| | | 1905 | | } |
| | | 1906 | | |
| | 335 | 1907 | | if (filter.MinParentAndIndexNumber.HasValue) |
| | | 1908 | | { |
| | 0 | 1909 | | baseQuery = baseQuery |
| | 0 | 1910 | | .Where(e => (e.ParentIndexNumber == filter.MinParentAndIndexNumber.Value.ParentIndexNumber && e.IndexNum |
| | | 1911 | | } |
| | | 1912 | | |
| | 335 | 1913 | | if (filter.MinDateCreated.HasValue) |
| | | 1914 | | { |
| | 0 | 1915 | | baseQuery = baseQuery.Where(e => e.DateCreated >= filter.MinDateCreated); |
| | | 1916 | | } |
| | | 1917 | | |
| | 335 | 1918 | | if (filter.MinDateLastSaved.HasValue) |
| | | 1919 | | { |
| | 0 | 1920 | | baseQuery = baseQuery.Where(e => e.DateLastSaved != null && e.DateLastSaved >= filter.MinDateLastSaved.Value |
| | | 1921 | | } |
| | | 1922 | | |
| | 335 | 1923 | | if (filter.MinDateLastSavedForUser.HasValue) |
| | | 1924 | | { |
| | 0 | 1925 | | baseQuery = baseQuery.Where(e => e.DateLastSaved != null && e.DateLastSaved >= filter.MinDateLastSavedForUse |
| | | 1926 | | } |
| | | 1927 | | |
| | 335 | 1928 | | if (filter.IndexNumber.HasValue) |
| | | 1929 | | { |
| | 0 | 1930 | | baseQuery = baseQuery.Where(e => e.IndexNumber == filter.IndexNumber.Value); |
| | | 1931 | | } |
| | | 1932 | | |
| | 335 | 1933 | | if (filter.ParentIndexNumber.HasValue) |
| | | 1934 | | { |
| | 0 | 1935 | | baseQuery = baseQuery.Where(e => e.ParentIndexNumber == filter.ParentIndexNumber.Value); |
| | | 1936 | | } |
| | | 1937 | | |
| | 335 | 1938 | | if (filter.ParentIndexNumberNotEquals.HasValue) |
| | | 1939 | | { |
| | 0 | 1940 | | baseQuery = baseQuery.Where(e => e.ParentIndexNumber != filter.ParentIndexNumberNotEquals.Value || e.ParentI |
| | | 1941 | | } |
| | | 1942 | | |
| | 335 | 1943 | | var minEndDate = filter.MinEndDate; |
| | 335 | 1944 | | var maxEndDate = filter.MaxEndDate; |
| | | 1945 | | |
| | 335 | 1946 | | if (filter.HasAired.HasValue) |
| | | 1947 | | { |
| | 0 | 1948 | | if (filter.HasAired.Value) |
| | | 1949 | | { |
| | 0 | 1950 | | maxEndDate = DateTime.UtcNow; |
| | | 1951 | | } |
| | | 1952 | | else |
| | | 1953 | | { |
| | 0 | 1954 | | minEndDate = DateTime.UtcNow; |
| | | 1955 | | } |
| | | 1956 | | } |
| | | 1957 | | |
| | 335 | 1958 | | if (minEndDate.HasValue) |
| | | 1959 | | { |
| | 0 | 1960 | | baseQuery = baseQuery.Where(e => e.EndDate >= minEndDate); |
| | | 1961 | | } |
| | | 1962 | | |
| | 335 | 1963 | | if (maxEndDate.HasValue) |
| | | 1964 | | { |
| | 0 | 1965 | | baseQuery = baseQuery.Where(e => e.EndDate <= maxEndDate); |
| | | 1966 | | } |
| | | 1967 | | |
| | 335 | 1968 | | if (filter.MinStartDate.HasValue) |
| | | 1969 | | { |
| | 0 | 1970 | | baseQuery = baseQuery.Where(e => e.StartDate >= filter.MinStartDate.Value); |
| | | 1971 | | } |
| | | 1972 | | |
| | 335 | 1973 | | if (filter.MaxStartDate.HasValue) |
| | | 1974 | | { |
| | 0 | 1975 | | baseQuery = baseQuery.Where(e => e.StartDate <= filter.MaxStartDate.Value); |
| | | 1976 | | } |
| | | 1977 | | |
| | 335 | 1978 | | if (filter.MinPremiereDate.HasValue) |
| | | 1979 | | { |
| | 0 | 1980 | | baseQuery = baseQuery.Where(e => e.PremiereDate >= filter.MinPremiereDate.Value); |
| | | 1981 | | } |
| | | 1982 | | |
| | 335 | 1983 | | if (filter.MaxPremiereDate.HasValue) |
| | | 1984 | | { |
| | 0 | 1985 | | baseQuery = baseQuery.Where(e => e.PremiereDate <= filter.MaxPremiereDate.Value); |
| | | 1986 | | } |
| | | 1987 | | |
| | 335 | 1988 | | if (filter.TrailerTypes.Length > 0) |
| | | 1989 | | { |
| | 0 | 1990 | | var trailerTypes = filter.TrailerTypes.Select(e => (int)e).ToArray(); |
| | 0 | 1991 | | baseQuery = baseQuery.Where(e => trailerTypes.Any(f => e.TrailerTypes!.Any(w => w.Id == f))); |
| | | 1992 | | } |
| | | 1993 | | |
| | 335 | 1994 | | if (filter.IsAiring.HasValue) |
| | | 1995 | | { |
| | 0 | 1996 | | if (filter.IsAiring.Value) |
| | | 1997 | | { |
| | 0 | 1998 | | baseQuery = baseQuery.Where(e => e.StartDate <= now && e.EndDate >= now); |
| | | 1999 | | } |
| | | 2000 | | else |
| | | 2001 | | { |
| | 0 | 2002 | | baseQuery = baseQuery.Where(e => e.StartDate > now && e.EndDate < now); |
| | | 2003 | | } |
| | | 2004 | | } |
| | | 2005 | | |
| | 335 | 2006 | | if (filter.PersonIds.Length > 0) |
| | | 2007 | | { |
| | 0 | 2008 | | var peopleEntityIds = context.BaseItems |
| | 0 | 2009 | | .WhereOneOrMany(filter.PersonIds, b => b.Id) |
| | 0 | 2010 | | .Join( |
| | 0 | 2011 | | context.Peoples, |
| | 0 | 2012 | | b => b.Name, |
| | 0 | 2013 | | p => p.Name, |
| | 0 | 2014 | | (b, p) => p.Id); |
| | | 2015 | | |
| | 0 | 2016 | | baseQuery = baseQuery |
| | 0 | 2017 | | .Where(e => context.PeopleBaseItemMap |
| | 0 | 2018 | | .Any(m => m.ItemId == e.Id && peopleEntityIds.Contains(m.PeopleId))); |
| | | 2019 | | } |
| | | 2020 | | |
| | 335 | 2021 | | if (!string.IsNullOrWhiteSpace(filter.Person)) |
| | | 2022 | | { |
| | 0 | 2023 | | baseQuery = baseQuery.Where(e => e.Peoples!.Any(f => f.People.Name == filter.Person)); |
| | | 2024 | | } |
| | | 2025 | | |
| | 335 | 2026 | | if (!string.IsNullOrWhiteSpace(filter.MinSortName)) |
| | | 2027 | | { |
| | | 2028 | | // this does not makes sense. |
| | | 2029 | | // baseQuery = baseQuery.Where(e => e.SortName >= query.MinSortName); |
| | | 2030 | | // whereClauses.Add("SortName>=@MinSortName"); |
| | | 2031 | | // statement?.TryBind("@MinSortName", query.MinSortName); |
| | | 2032 | | } |
| | | 2033 | | |
| | 335 | 2034 | | if (!string.IsNullOrWhiteSpace(filter.ExternalSeriesId)) |
| | | 2035 | | { |
| | 0 | 2036 | | baseQuery = baseQuery.Where(e => e.ExternalSeriesId == filter.ExternalSeriesId); |
| | | 2037 | | } |
| | | 2038 | | |
| | 335 | 2039 | | if (!string.IsNullOrWhiteSpace(filter.ExternalId)) |
| | | 2040 | | { |
| | 0 | 2041 | | baseQuery = baseQuery.Where(e => e.ExternalId == filter.ExternalId); |
| | | 2042 | | } |
| | | 2043 | | |
| | 335 | 2044 | | if (!string.IsNullOrWhiteSpace(filter.Name)) |
| | | 2045 | | { |
| | 3 | 2046 | | if (filter.UseRawName == true) |
| | | 2047 | | { |
| | 0 | 2048 | | baseQuery = baseQuery.Where(e => e.Name == filter.Name); |
| | | 2049 | | } |
| | | 2050 | | else |
| | | 2051 | | { |
| | 3 | 2052 | | var cleanName = GetCleanValue(filter.Name); |
| | 3 | 2053 | | baseQuery = baseQuery.Where(e => e.CleanName == cleanName); |
| | | 2054 | | } |
| | | 2055 | | } |
| | | 2056 | | |
| | | 2057 | | // These are the same, for now |
| | 335 | 2058 | | var nameContains = filter.NameContains; |
| | 335 | 2059 | | if (!string.IsNullOrWhiteSpace(nameContains)) |
| | | 2060 | | { |
| | 0 | 2061 | | if (SearchWildcardTerms.Any(f => nameContains.Contains(f))) |
| | | 2062 | | { |
| | 0 | 2063 | | nameContains = $"%{nameContains.Trim('%')}%"; |
| | 0 | 2064 | | baseQuery = baseQuery.Where(e => EF.Functions.Like(e.CleanName, nameContains) || EF.Functions.Like(e.Ori |
| | | 2065 | | } |
| | | 2066 | | else |
| | | 2067 | | { |
| | 0 | 2068 | | baseQuery = baseQuery.Where(e => |
| | 0 | 2069 | | e.CleanName!.Contains(nameContains) |
| | 0 | 2070 | | || e.OriginalTitle!.ToLower().Contains(nameContains!)); |
| | | 2071 | | } |
| | | 2072 | | } |
| | | 2073 | | |
| | 335 | 2074 | | if (!string.IsNullOrWhiteSpace(filter.NameStartsWith)) |
| | | 2075 | | { |
| | 0 | 2076 | | var startsWithLower = filter.NameStartsWith.ToLowerInvariant(); |
| | 0 | 2077 | | baseQuery = baseQuery.Where(e => e.SortName!.StartsWith(startsWithLower)); |
| | | 2078 | | } |
| | | 2079 | | |
| | 335 | 2080 | | if (!string.IsNullOrWhiteSpace(filter.NameStartsWithOrGreater)) |
| | | 2081 | | { |
| | 0 | 2082 | | var startsOrGreaterLower = filter.NameStartsWithOrGreater.ToLowerInvariant(); |
| | 0 | 2083 | | baseQuery = baseQuery.Where(e => e.SortName!.CompareTo(startsOrGreaterLower) >= 0); |
| | | 2084 | | } |
| | | 2085 | | |
| | 335 | 2086 | | if (!string.IsNullOrWhiteSpace(filter.NameLessThan)) |
| | | 2087 | | { |
| | 0 | 2088 | | var lessThanLower = filter.NameLessThan.ToLowerInvariant(); |
| | 0 | 2089 | | baseQuery = baseQuery.Where(e => e.SortName!.CompareTo(lessThanLower ) < 0); |
| | | 2090 | | } |
| | | 2091 | | |
| | 335 | 2092 | | if (filter.ImageTypes.Length > 0) |
| | | 2093 | | { |
| | 103 | 2094 | | var imgTypes = filter.ImageTypes.Select(e => (ImageInfoImageType)e).ToArray(); |
| | 103 | 2095 | | baseQuery = baseQuery.Where(e => imgTypes.Any(f => e.Images!.Any(w => w.ImageType == f))); |
| | | 2096 | | } |
| | | 2097 | | |
| | 335 | 2098 | | if (filter.IsLiked.HasValue) |
| | | 2099 | | { |
| | 0 | 2100 | | baseQuery = baseQuery |
| | 0 | 2101 | | .Where(e => e.UserData!.FirstOrDefault(f => f.UserId == filter.User!.Id)!.Rating >= UserItemData.MinLike |
| | | 2102 | | } |
| | | 2103 | | |
| | 335 | 2104 | | if (filter.IsFavoriteOrLiked.HasValue) |
| | | 2105 | | { |
| | 0 | 2106 | | baseQuery = baseQuery |
| | 0 | 2107 | | .Where(e => e.UserData!.FirstOrDefault(f => f.UserId == filter.User!.Id)!.IsFavorite == filter.IsFavorit |
| | | 2108 | | } |
| | | 2109 | | |
| | 335 | 2110 | | if (filter.IsFavorite.HasValue) |
| | | 2111 | | { |
| | 0 | 2112 | | baseQuery = baseQuery |
| | 0 | 2113 | | .Where(e => e.UserData!.FirstOrDefault(f => f.UserId == filter.User!.Id)!.IsFavorite == filter.IsFavorit |
| | | 2114 | | } |
| | | 2115 | | |
| | 335 | 2116 | | if (filter.IsPlayed.HasValue) |
| | | 2117 | | { |
| | | 2118 | | // We should probably figure this out for all folders, but for right now, this is the only place where we ne |
| | 0 | 2119 | | if (filter.IncludeItemTypes.Length == 1 && filter.IncludeItemTypes[0] == BaseItemKind.Series) |
| | | 2120 | | { |
| | 0 | 2121 | | baseQuery = baseQuery.Where(e => context.BaseItems.Where(e => e.Id != EF.Constant(PlaceholderId)) |
| | 0 | 2122 | | .Where(e => e.IsFolder == false && e.IsVirtualItem == false) |
| | 0 | 2123 | | .Where(f => f.UserData!.FirstOrDefault(e => e.UserId == filter.User!.Id && e.Played)!.Played) |
| | 0 | 2124 | | .Any(f => f.SeriesPresentationUniqueKey == e.PresentationUniqueKey) == filter.IsPlayed); |
| | | 2125 | | } |
| | | 2126 | | else |
| | | 2127 | | { |
| | 0 | 2128 | | baseQuery = baseQuery |
| | 0 | 2129 | | .Select(e => new |
| | 0 | 2130 | | { |
| | 0 | 2131 | | IsPlayed = e.UserData!.Where(f => f.UserId == filter.User!.Id).Select(f => (bool?)f.Played).Firs |
| | 0 | 2132 | | Item = e |
| | 0 | 2133 | | }) |
| | 0 | 2134 | | .Where(e => e.IsPlayed == filter.IsPlayed) |
| | 0 | 2135 | | .Select(f => f.Item); |
| | | 2136 | | } |
| | | 2137 | | } |
| | | 2138 | | |
| | 335 | 2139 | | if (filter.IsResumable.HasValue) |
| | | 2140 | | { |
| | 1 | 2141 | | if (filter.IsResumable.Value) |
| | | 2142 | | { |
| | 1 | 2143 | | baseQuery = baseQuery |
| | 1 | 2144 | | .Where(e => e.UserData!.FirstOrDefault(f => f.UserId == filter.User!.Id)!.PlaybackPositionTicks > |
| | | 2145 | | } |
| | | 2146 | | else |
| | | 2147 | | { |
| | 0 | 2148 | | baseQuery = baseQuery |
| | 0 | 2149 | | .Where(e => e.UserData!.FirstOrDefault(f => f.UserId == filter.User!.Id)!.PlaybackPositionTicks = |
| | | 2150 | | } |
| | | 2151 | | } |
| | | 2152 | | |
| | 335 | 2153 | | if (filter.ArtistIds.Length > 0) |
| | | 2154 | | { |
| | 0 | 2155 | | baseQuery = baseQuery.WhereReferencedItemMultipleTypes(context, [ItemValueType.Artist, ItemValueType.AlbumAr |
| | | 2156 | | } |
| | | 2157 | | |
| | 335 | 2158 | | if (filter.AlbumArtistIds.Length > 0) |
| | | 2159 | | { |
| | 0 | 2160 | | baseQuery = baseQuery.WhereReferencedItem(context, ItemValueType.AlbumArtist, filter.AlbumArtistIds); |
| | | 2161 | | } |
| | | 2162 | | |
| | 335 | 2163 | | if (filter.ContributingArtistIds.Length > 0) |
| | | 2164 | | { |
| | 0 | 2165 | | var contributingNames = context.BaseItems |
| | 0 | 2166 | | .Where(b => filter.ContributingArtistIds.Contains(b.Id)) |
| | 0 | 2167 | | .Select(b => b.CleanName); |
| | | 2168 | | |
| | 0 | 2169 | | baseQuery = baseQuery.Where(e => |
| | 0 | 2170 | | e.ItemValues!.Any(ivm => |
| | 0 | 2171 | | ivm.ItemValue.Type == ItemValueType.Artist && |
| | 0 | 2172 | | contributingNames.Contains(ivm.ItemValue.CleanValue)) |
| | 0 | 2173 | | && |
| | 0 | 2174 | | !e.ItemValues!.Any(ivm => |
| | 0 | 2175 | | ivm.ItemValue.Type == ItemValueType.AlbumArtist && |
| | 0 | 2176 | | contributingNames.Contains(ivm.ItemValue.CleanValue))); |
| | | 2177 | | } |
| | | 2178 | | |
| | 335 | 2179 | | if (filter.AlbumIds.Length > 0) |
| | | 2180 | | { |
| | 0 | 2181 | | var subQuery = context.BaseItems.WhereOneOrMany(filter.AlbumIds, f => f.Id); |
| | 0 | 2182 | | baseQuery = baseQuery.Where(e => subQuery.Any(f => f.Name == e.Album)); |
| | | 2183 | | } |
| | | 2184 | | |
| | 335 | 2185 | | if (filter.ExcludeArtistIds.Length > 0) |
| | | 2186 | | { |
| | 0 | 2187 | | baseQuery = baseQuery.WhereReferencedItemMultipleTypes(context, [ItemValueType.Artist, ItemValueType.AlbumAr |
| | | 2188 | | } |
| | | 2189 | | |
| | 335 | 2190 | | if (filter.GenreIds.Count > 0) |
| | | 2191 | | { |
| | 0 | 2192 | | baseQuery = baseQuery.WhereReferencedItem(context, ItemValueType.Genre, filter.GenreIds.ToArray()); |
| | | 2193 | | } |
| | | 2194 | | |
| | 335 | 2195 | | if (filter.Genres.Count > 0) |
| | | 2196 | | { |
| | 0 | 2197 | | var cleanGenres = filter.Genres.Select(e => GetCleanValue(e)).ToArray().OneOrManyExpressionBuilder<ItemValue |
| | 0 | 2198 | | baseQuery = baseQuery |
| | 0 | 2199 | | .Where(e => e.ItemValues!.AsQueryable().Where(f => f.ItemValue.Type == ItemValueType.Genre).Any(clea |
| | | 2200 | | } |
| | | 2201 | | |
| | 335 | 2202 | | if (tags.Count > 0) |
| | | 2203 | | { |
| | 0 | 2204 | | var cleanValues = tags.Select(e => GetCleanValue(e)).ToArray().OneOrManyExpressionBuilder<ItemValueMap, stri |
| | 0 | 2205 | | baseQuery = baseQuery |
| | 0 | 2206 | | .Where(e => e.ItemValues!.AsQueryable().Where(f => f.ItemValue.Type == ItemValueType.Tags).Any(clean |
| | | 2207 | | } |
| | | 2208 | | |
| | 335 | 2209 | | if (excludeTags.Count > 0) |
| | | 2210 | | { |
| | 0 | 2211 | | var cleanValues = excludeTags.Select(e => GetCleanValue(e)).ToArray().OneOrManyExpressionBuilder<ItemValueMa |
| | 0 | 2212 | | baseQuery = baseQuery |
| | 0 | 2213 | | .Where(e => !e.ItemValues!.AsQueryable().Where(f => f.ItemValue.Type == ItemValueType.Tags).Any(clea |
| | | 2214 | | } |
| | | 2215 | | |
| | 335 | 2216 | | if (filter.StudioIds.Length > 0) |
| | | 2217 | | { |
| | 0 | 2218 | | baseQuery = baseQuery.WhereReferencedItem(context, ItemValueType.Studios, filter.StudioIds.ToArray()); |
| | | 2219 | | } |
| | | 2220 | | |
| | 335 | 2221 | | if (filter.OfficialRatings.Length > 0) |
| | | 2222 | | { |
| | 0 | 2223 | | baseQuery = baseQuery |
| | 0 | 2224 | | .Where(e => filter.OfficialRatings.Contains(e.OfficialRating)); |
| | | 2225 | | } |
| | | 2226 | | |
| | 335 | 2227 | | Expression<Func<BaseItemEntity, bool>>? minParentalRatingFilter = null; |
| | 335 | 2228 | | if (filter.MinParentalRating != null) |
| | | 2229 | | { |
| | 0 | 2230 | | var min = filter.MinParentalRating; |
| | 0 | 2231 | | var minScore = min.Score; |
| | 0 | 2232 | | var minSubScore = min.SubScore ?? 0; |
| | | 2233 | | |
| | 0 | 2234 | | minParentalRatingFilter = e => |
| | 0 | 2235 | | e.InheritedParentalRatingValue == null || |
| | 0 | 2236 | | e.InheritedParentalRatingValue > minScore || |
| | 0 | 2237 | | (e.InheritedParentalRatingValue == minScore && (e.InheritedParentalRatingSubValue ?? 0) >= minSubScore); |
| | | 2238 | | } |
| | | 2239 | | |
| | 335 | 2240 | | Expression<Func<BaseItemEntity, bool>>? maxParentalRatingFilter = null; |
| | 335 | 2241 | | if (filter.MaxParentalRating != null) |
| | | 2242 | | { |
| | 48 | 2243 | | var max = filter.MaxParentalRating; |
| | 48 | 2244 | | var maxScore = max.Score; |
| | 48 | 2245 | | var maxSubScore = max.SubScore ?? 0; |
| | | 2246 | | |
| | 48 | 2247 | | maxParentalRatingFilter = e => |
| | 48 | 2248 | | e.InheritedParentalRatingValue == null || |
| | 48 | 2249 | | e.InheritedParentalRatingValue < maxScore || |
| | 48 | 2250 | | (e.InheritedParentalRatingValue == maxScore && (e.InheritedParentalRatingSubValue ?? 0) <= maxSubScore); |
| | | 2251 | | } |
| | | 2252 | | |
| | 335 | 2253 | | if (filter.HasParentalRating ?? false) |
| | | 2254 | | { |
| | 0 | 2255 | | if (minParentalRatingFilter != null) |
| | | 2256 | | { |
| | 0 | 2257 | | baseQuery = baseQuery.Where(minParentalRatingFilter); |
| | | 2258 | | } |
| | | 2259 | | |
| | 0 | 2260 | | if (maxParentalRatingFilter != null) |
| | | 2261 | | { |
| | 0 | 2262 | | baseQuery = baseQuery.Where(maxParentalRatingFilter); |
| | | 2263 | | } |
| | | 2264 | | } |
| | 335 | 2265 | | else if (filter.BlockUnratedItems.Length > 0) |
| | | 2266 | | { |
| | 0 | 2267 | | var unratedItemTypes = filter.BlockUnratedItems.Select(f => f.ToString()).ToArray(); |
| | 0 | 2268 | | Expression<Func<BaseItemEntity, bool>> unratedItemFilter = e => e.InheritedParentalRatingValue != null || !u |
| | | 2269 | | |
| | 0 | 2270 | | if (minParentalRatingFilter != null && maxParentalRatingFilter != null) |
| | | 2271 | | { |
| | 0 | 2272 | | baseQuery = baseQuery.Where(unratedItemFilter.And(minParentalRatingFilter.And(maxParentalRatingFilter))) |
| | | 2273 | | } |
| | 0 | 2274 | | else if (minParentalRatingFilter != null) |
| | | 2275 | | { |
| | 0 | 2276 | | baseQuery = baseQuery.Where(unratedItemFilter.And(minParentalRatingFilter)); |
| | | 2277 | | } |
| | 0 | 2278 | | else if (maxParentalRatingFilter != null) |
| | | 2279 | | { |
| | 0 | 2280 | | baseQuery = baseQuery.Where(unratedItemFilter.And(maxParentalRatingFilter)); |
| | | 2281 | | } |
| | | 2282 | | else |
| | | 2283 | | { |
| | 0 | 2284 | | baseQuery = baseQuery.Where(unratedItemFilter); |
| | | 2285 | | } |
| | | 2286 | | } |
| | 335 | 2287 | | else if (minParentalRatingFilter != null || maxParentalRatingFilter != null) |
| | | 2288 | | { |
| | 48 | 2289 | | if (minParentalRatingFilter != null) |
| | | 2290 | | { |
| | 0 | 2291 | | baseQuery = baseQuery.Where(minParentalRatingFilter); |
| | | 2292 | | } |
| | | 2293 | | |
| | 48 | 2294 | | if (maxParentalRatingFilter != null) |
| | | 2295 | | { |
| | 48 | 2296 | | baseQuery = baseQuery.Where(maxParentalRatingFilter); |
| | | 2297 | | } |
| | | 2298 | | } |
| | 287 | 2299 | | else if (!filter.HasParentalRating ?? false) |
| | | 2300 | | { |
| | 0 | 2301 | | baseQuery = baseQuery |
| | 0 | 2302 | | .Where(e => e.InheritedParentalRatingValue == null); |
| | | 2303 | | } |
| | | 2304 | | |
| | 335 | 2305 | | if (filter.HasOfficialRating.HasValue) |
| | | 2306 | | { |
| | 0 | 2307 | | if (filter.HasOfficialRating.Value) |
| | | 2308 | | { |
| | 0 | 2309 | | baseQuery = baseQuery |
| | 0 | 2310 | | .Where(e => e.OfficialRating != null && e.OfficialRating != string.Empty); |
| | | 2311 | | } |
| | | 2312 | | else |
| | | 2313 | | { |
| | 0 | 2314 | | baseQuery = baseQuery |
| | 0 | 2315 | | .Where(e => e.OfficialRating == null || e.OfficialRating == string.Empty); |
| | | 2316 | | } |
| | | 2317 | | } |
| | | 2318 | | |
| | 335 | 2319 | | if (filter.HasOverview.HasValue) |
| | | 2320 | | { |
| | 0 | 2321 | | if (filter.HasOverview.Value) |
| | | 2322 | | { |
| | 0 | 2323 | | baseQuery = baseQuery |
| | 0 | 2324 | | .Where(e => e.Overview != null && e.Overview != string.Empty); |
| | | 2325 | | } |
| | | 2326 | | else |
| | | 2327 | | { |
| | 0 | 2328 | | baseQuery = baseQuery |
| | 0 | 2329 | | .Where(e => e.Overview == null || e.Overview == string.Empty); |
| | | 2330 | | } |
| | | 2331 | | } |
| | | 2332 | | |
| | 335 | 2333 | | if (filter.HasOwnerId.HasValue) |
| | | 2334 | | { |
| | 0 | 2335 | | if (filter.HasOwnerId.Value) |
| | | 2336 | | { |
| | 0 | 2337 | | baseQuery = baseQuery |
| | 0 | 2338 | | .Where(e => e.OwnerId != null); |
| | | 2339 | | } |
| | | 2340 | | else |
| | | 2341 | | { |
| | 0 | 2342 | | baseQuery = baseQuery |
| | 0 | 2343 | | .Where(e => e.OwnerId == null); |
| | | 2344 | | } |
| | | 2345 | | } |
| | | 2346 | | |
| | 335 | 2347 | | if (!string.IsNullOrWhiteSpace(filter.HasNoAudioTrackWithLanguage)) |
| | | 2348 | | { |
| | 0 | 2349 | | baseQuery = baseQuery |
| | 0 | 2350 | | .Where(e => !e.MediaStreams!.Any(f => f.StreamType == MediaStreamTypeEntity.Audio && f.Language == filte |
| | | 2351 | | } |
| | | 2352 | | |
| | 335 | 2353 | | if (!string.IsNullOrWhiteSpace(filter.HasNoInternalSubtitleTrackWithLanguage)) |
| | | 2354 | | { |
| | 0 | 2355 | | baseQuery = baseQuery |
| | 0 | 2356 | | .Where(e => !e.MediaStreams!.Any(f => f.StreamType == MediaStreamTypeEntity.Subtitle && !f.IsExternal && |
| | | 2357 | | } |
| | | 2358 | | |
| | 335 | 2359 | | if (!string.IsNullOrWhiteSpace(filter.HasNoExternalSubtitleTrackWithLanguage)) |
| | | 2360 | | { |
| | 0 | 2361 | | baseQuery = baseQuery |
| | 0 | 2362 | | .Where(e => !e.MediaStreams!.Any(f => f.StreamType == MediaStreamTypeEntity.Subtitle && f.IsExternal && |
| | | 2363 | | } |
| | | 2364 | | |
| | 335 | 2365 | | if (!string.IsNullOrWhiteSpace(filter.HasNoSubtitleTrackWithLanguage)) |
| | | 2366 | | { |
| | 0 | 2367 | | baseQuery = baseQuery |
| | 0 | 2368 | | .Where(e => !e.MediaStreams!.Any(f => f.StreamType == MediaStreamTypeEntity.Subtitle && f.Language == fi |
| | | 2369 | | } |
| | | 2370 | | |
| | 335 | 2371 | | if (filter.HasSubtitles.HasValue) |
| | | 2372 | | { |
| | 0 | 2373 | | baseQuery = baseQuery |
| | 0 | 2374 | | .Where(e => e.MediaStreams!.Any(f => f.StreamType == MediaStreamTypeEntity.Subtitle) == filter.HasSubtit |
| | | 2375 | | } |
| | | 2376 | | |
| | 335 | 2377 | | if (filter.HasChapterImages.HasValue) |
| | | 2378 | | { |
| | 0 | 2379 | | baseQuery = baseQuery |
| | 0 | 2380 | | .Where(e => e.Chapters!.Any(f => f.ImagePath != null) == filter.HasChapterImages.Value); |
| | | 2381 | | } |
| | | 2382 | | |
| | 335 | 2383 | | if (filter.HasDeadParentId.HasValue && filter.HasDeadParentId.Value) |
| | | 2384 | | { |
| | 16 | 2385 | | baseQuery = baseQuery |
| | 16 | 2386 | | .Where(e => e.ParentId.HasValue && !context.BaseItems.Where(e => e.Id != EF.Constant(PlaceholderId)).Any |
| | | 2387 | | } |
| | | 2388 | | |
| | 335 | 2389 | | if (filter.IsDeadArtist.HasValue && filter.IsDeadArtist.Value) |
| | | 2390 | | { |
| | 16 | 2391 | | baseQuery = baseQuery |
| | 16 | 2392 | | .Where(e => !context.ItemValues.Where(f => _getAllArtistsValueTypes.Contains(f.Type)).Any(f => f.Val |
| | | 2393 | | } |
| | | 2394 | | |
| | 335 | 2395 | | if (filter.IsDeadStudio.HasValue && filter.IsDeadStudio.Value) |
| | | 2396 | | { |
| | 16 | 2397 | | baseQuery = baseQuery |
| | 16 | 2398 | | .Where(e => !context.ItemValues.Where(f => _getStudiosValueTypes.Contains(f.Type)).Any(f => f.Value |
| | | 2399 | | } |
| | | 2400 | | |
| | 335 | 2401 | | if (filter.IsDeadGenre.HasValue && filter.IsDeadGenre.Value) |
| | | 2402 | | { |
| | 16 | 2403 | | baseQuery = baseQuery |
| | 16 | 2404 | | .Where(e => !context.ItemValues.Where(f => _getGenreValueTypes.Contains(f.Type)).Any(f => f.Value == |
| | | 2405 | | } |
| | | 2406 | | |
| | 335 | 2407 | | if (filter.IsDeadPerson.HasValue && filter.IsDeadPerson.Value) |
| | | 2408 | | { |
| | 0 | 2409 | | baseQuery = baseQuery |
| | 0 | 2410 | | .Where(e => !context.Peoples.Any(f => f.Name == e.Name)); |
| | | 2411 | | } |
| | | 2412 | | |
| | 335 | 2413 | | if (filter.Years.Length > 0) |
| | | 2414 | | { |
| | 0 | 2415 | | baseQuery = baseQuery.WhereOneOrMany(filter.Years, e => e.ProductionYear!.Value); |
| | | 2416 | | } |
| | | 2417 | | |
| | 335 | 2418 | | var isVirtualItem = filter.IsVirtualItem ?? filter.IsMissing; |
| | 335 | 2419 | | if (isVirtualItem.HasValue) |
| | | 2420 | | { |
| | 22 | 2421 | | baseQuery = baseQuery |
| | 22 | 2422 | | .Where(e => e.IsVirtualItem == isVirtualItem.Value); |
| | | 2423 | | } |
| | | 2424 | | |
| | 335 | 2425 | | if (filter.IsSpecialSeason.HasValue) |
| | | 2426 | | { |
| | 0 | 2427 | | if (filter.IsSpecialSeason.Value) |
| | | 2428 | | { |
| | 0 | 2429 | | baseQuery = baseQuery |
| | 0 | 2430 | | .Where(e => e.IndexNumber == 0); |
| | | 2431 | | } |
| | | 2432 | | else |
| | | 2433 | | { |
| | 0 | 2434 | | baseQuery = baseQuery |
| | 0 | 2435 | | .Where(e => e.IndexNumber != 0); |
| | | 2436 | | } |
| | | 2437 | | } |
| | | 2438 | | |
| | 335 | 2439 | | if (filter.IsUnaired.HasValue) |
| | | 2440 | | { |
| | 0 | 2441 | | if (filter.IsUnaired.Value) |
| | | 2442 | | { |
| | 0 | 2443 | | baseQuery = baseQuery |
| | 0 | 2444 | | .Where(e => e.PremiereDate >= now); |
| | | 2445 | | } |
| | | 2446 | | else |
| | | 2447 | | { |
| | 0 | 2448 | | baseQuery = baseQuery |
| | 0 | 2449 | | .Where(e => e.PremiereDate < now); |
| | | 2450 | | } |
| | | 2451 | | } |
| | | 2452 | | |
| | 335 | 2453 | | if (filter.MediaTypes.Length > 0) |
| | | 2454 | | { |
| | 21 | 2455 | | var mediaTypes = filter.MediaTypes.Select(f => f.ToString()).ToArray(); |
| | 21 | 2456 | | baseQuery = baseQuery.WhereOneOrMany(mediaTypes, e => e.MediaType); |
| | | 2457 | | } |
| | | 2458 | | |
| | 335 | 2459 | | if (filter.ItemIds.Length > 0) |
| | | 2460 | | { |
| | 0 | 2461 | | baseQuery = baseQuery.WhereOneOrMany(filter.ItemIds, e => e.Id); |
| | | 2462 | | } |
| | | 2463 | | |
| | 335 | 2464 | | if (filter.ExcludeItemIds.Length > 0) |
| | | 2465 | | { |
| | 0 | 2466 | | baseQuery = baseQuery |
| | 0 | 2467 | | .Where(e => !filter.ExcludeItemIds.Contains(e.Id)); |
| | | 2468 | | } |
| | | 2469 | | |
| | 335 | 2470 | | if (filter.ExcludeProviderIds is not null && filter.ExcludeProviderIds.Count > 0) |
| | | 2471 | | { |
| | 0 | 2472 | | var exclude = filter.ExcludeProviderIds.Select(e => $"{e.Key}:{e.Value}").ToArray(); |
| | 0 | 2473 | | baseQuery = baseQuery.Where(e => e.Provider!.Select(f => f.ProviderId + ":" + f.ProviderValue)!.All(f => !ex |
| | | 2474 | | } |
| | | 2475 | | |
| | 335 | 2476 | | if (filter.HasAnyProviderId is not null && filter.HasAnyProviderId.Count > 0) |
| | | 2477 | | { |
| | | 2478 | | // Allow setting a null or empty value to get all items that have the specified provider set. |
| | 0 | 2479 | | var includeAny = filter.HasAnyProviderId.Where(e => string.IsNullOrEmpty(e.Value)).Select(e => e.Key).ToArra |
| | 0 | 2480 | | if (includeAny.Length > 0) |
| | | 2481 | | { |
| | 0 | 2482 | | baseQuery = baseQuery.Where(e => e.Provider!.Any(f => includeAny.Contains(f.ProviderId))); |
| | | 2483 | | } |
| | | 2484 | | |
| | 0 | 2485 | | var includeSelected = filter.HasAnyProviderId.Where(e => !string.IsNullOrEmpty(e.Value)).Select(e => $"{e.Ke |
| | 0 | 2486 | | if (includeSelected.Length > 0) |
| | | 2487 | | { |
| | 0 | 2488 | | baseQuery = baseQuery.Where(e => e.Provider!.Select(f => f.ProviderId + ":" + f.ProviderValue)!.Any(f => |
| | | 2489 | | } |
| | | 2490 | | } |
| | | 2491 | | |
| | 335 | 2492 | | if (filter.HasImdbId.HasValue) |
| | | 2493 | | { |
| | 0 | 2494 | | baseQuery = filter.HasImdbId.Value |
| | 0 | 2495 | | ? baseQuery.Where(e => e.Provider!.Any(f => f.ProviderId.ToLower() == MetadataProvider.Imdb.ToString().T |
| | 0 | 2496 | | : baseQuery.Where(e => e.Provider!.All(f => f.ProviderId.ToLower() != MetadataProvider.Imdb.ToString().T |
| | | 2497 | | } |
| | | 2498 | | |
| | 335 | 2499 | | if (filter.HasTmdbId.HasValue) |
| | | 2500 | | { |
| | 0 | 2501 | | baseQuery = filter.HasTmdbId.Value |
| | 0 | 2502 | | ? baseQuery.Where(e => e.Provider!.Any(f => f.ProviderId.ToLower() == MetadataProvider.Tmdb.ToString().T |
| | 0 | 2503 | | : baseQuery.Where(e => e.Provider!.All(f => f.ProviderId.ToLower() != MetadataProvider.Tmdb.ToString().T |
| | | 2504 | | } |
| | | 2505 | | |
| | 335 | 2506 | | if (filter.HasTvdbId.HasValue) |
| | | 2507 | | { |
| | 0 | 2508 | | baseQuery = filter.HasTvdbId.Value |
| | 0 | 2509 | | ? baseQuery.Where(e => e.Provider!.Any(f => f.ProviderId.ToLower() == MetadataProvider.Tvdb.ToString().T |
| | 0 | 2510 | | : baseQuery.Where(e => e.Provider!.All(f => f.ProviderId.ToLower() != MetadataProvider.Tvdb.ToString().T |
| | | 2511 | | } |
| | | 2512 | | |
| | 335 | 2513 | | var queryTopParentIds = filter.TopParentIds; |
| | | 2514 | | |
| | 335 | 2515 | | if (queryTopParentIds.Length > 0) |
| | | 2516 | | { |
| | 15 | 2517 | | var includedItemByNameTypes = GetItemByNameTypesInQuery(filter); |
| | 15 | 2518 | | var enableItemsByName = (filter.IncludeItemsByName ?? false) && includedItemByNameTypes.Count > 0; |
| | 15 | 2519 | | if (enableItemsByName && includedItemByNameTypes.Count > 0) |
| | | 2520 | | { |
| | 0 | 2521 | | baseQuery = baseQuery.Where(e => includedItemByNameTypes.Contains(e.Type) || queryTopParentIds.Any(w => |
| | | 2522 | | } |
| | | 2523 | | else |
| | | 2524 | | { |
| | 15 | 2525 | | baseQuery = baseQuery.WhereOneOrMany(queryTopParentIds, e => e.TopParentId!.Value); |
| | | 2526 | | } |
| | | 2527 | | } |
| | | 2528 | | |
| | 335 | 2529 | | if (filter.AncestorIds.Length > 0) |
| | | 2530 | | { |
| | 42 | 2531 | | baseQuery = baseQuery.Where(e => e.Parents!.Any(f => filter.AncestorIds.Contains(f.ParentItemId))); |
| | | 2532 | | } |
| | | 2533 | | |
| | 335 | 2534 | | if (!string.IsNullOrWhiteSpace(filter.AncestorWithPresentationUniqueKey)) |
| | | 2535 | | { |
| | 0 | 2536 | | baseQuery = baseQuery |
| | 0 | 2537 | | .Where(e => context.BaseItems.Where(e => e.Id != EF.Constant(PlaceholderId)).Where(f => f.PresentationUn |
| | | 2538 | | } |
| | | 2539 | | |
| | 335 | 2540 | | if (!string.IsNullOrWhiteSpace(filter.SeriesPresentationUniqueKey)) |
| | | 2541 | | { |
| | 0 | 2542 | | baseQuery = baseQuery |
| | 0 | 2543 | | .Where(e => e.SeriesPresentationUniqueKey == filter.SeriesPresentationUniqueKey); |
| | | 2544 | | } |
| | | 2545 | | |
| | 335 | 2546 | | if (filter.ExcludeInheritedTags.Length > 0) |
| | | 2547 | | { |
| | 0 | 2548 | | var excludedTags = filter.ExcludeInheritedTags; |
| | 0 | 2549 | | baseQuery = baseQuery.Where(e => |
| | 0 | 2550 | | !e.ItemValues!.Any(f => f.ItemValue.Type == ItemValueType.Tags && excludedTags.Contains(f.ItemValue.Clea |
| | 0 | 2551 | | && (!e.SeriesId.HasValue || !context.ItemValuesMap.Any(f => f.ItemId == e.SeriesId.Value && f.ItemValue. |
| | | 2552 | | } |
| | | 2553 | | |
| | 335 | 2554 | | if (filter.IncludeInheritedTags.Length > 0) |
| | | 2555 | | { |
| | 0 | 2556 | | var includeTags = filter.IncludeInheritedTags; |
| | 0 | 2557 | | var isPlaylistOnlyQuery = includeTypes.Length == 1 && includeTypes.FirstOrDefault() == BaseItemKind.Playlist |
| | 0 | 2558 | | baseQuery = baseQuery.Where(e => |
| | 0 | 2559 | | e.ItemValues!.Any(f => f.ItemValue.Type == ItemValueType.Tags && includeTags.Contains(f.ItemValue.CleanV |
| | 0 | 2560 | | |
| | 0 | 2561 | | // For seasons and episodes, we also need to check the parent series' tags. |
| | 0 | 2562 | | || (e.SeriesId.HasValue && context.ItemValuesMap.Any(f => f.ItemId == e.SeriesId.Value && f.ItemValue.Ty |
| | 0 | 2563 | | |
| | 0 | 2564 | | // A playlist should be accessible to its owner regardless of allowed tags |
| | 0 | 2565 | | || (isPlaylistOnlyQuery && e.Data!.Contains($"OwnerUserId\":\"{filter.User!.Id:N}\""))); |
| | | 2566 | | } |
| | | 2567 | | |
| | 335 | 2568 | | if (filter.SeriesStatuses.Length > 0) |
| | | 2569 | | { |
| | 0 | 2570 | | var seriesStatus = filter.SeriesStatuses.Select(e => e.ToString()).ToArray(); |
| | 0 | 2571 | | baseQuery = baseQuery |
| | 0 | 2572 | | .Where(e => seriesStatus.Any(f => e.Data!.Contains(f))); |
| | | 2573 | | } |
| | | 2574 | | |
| | 335 | 2575 | | if (filter.BoxSetLibraryFolders.Length > 0) |
| | | 2576 | | { |
| | 0 | 2577 | | var boxsetFolders = filter.BoxSetLibraryFolders.Select(e => e.ToString("N", CultureInfo.InvariantCulture)).T |
| | 0 | 2578 | | baseQuery = baseQuery |
| | 0 | 2579 | | .Where(e => boxsetFolders.Any(f => e.Data!.Contains(f))); |
| | | 2580 | | } |
| | | 2581 | | |
| | 335 | 2582 | | if (filter.VideoTypes.Length > 0) |
| | | 2583 | | { |
| | 0 | 2584 | | var videoTypeBs = filter.VideoTypes.Select(e => $"\"VideoType\":\"{e}\""); |
| | 0 | 2585 | | baseQuery = baseQuery |
| | 0 | 2586 | | .Where(e => videoTypeBs.Any(f => e.Data!.Contains(f))); |
| | | 2587 | | } |
| | | 2588 | | |
| | 335 | 2589 | | if (filter.Is3D.HasValue) |
| | | 2590 | | { |
| | 0 | 2591 | | if (filter.Is3D.Value) |
| | | 2592 | | { |
| | 0 | 2593 | | baseQuery = baseQuery |
| | 0 | 2594 | | .Where(e => e.Data!.Contains("Video3DFormat")); |
| | | 2595 | | } |
| | | 2596 | | else |
| | | 2597 | | { |
| | 0 | 2598 | | baseQuery = baseQuery |
| | 0 | 2599 | | .Where(e => !e.Data!.Contains("Video3DFormat")); |
| | | 2600 | | } |
| | | 2601 | | } |
| | | 2602 | | |
| | 335 | 2603 | | if (filter.IsPlaceHolder.HasValue) |
| | | 2604 | | { |
| | 0 | 2605 | | if (filter.IsPlaceHolder.Value) |
| | | 2606 | | { |
| | 0 | 2607 | | baseQuery = baseQuery |
| | 0 | 2608 | | .Where(e => e.Data!.Contains("IsPlaceHolder\":true")); |
| | | 2609 | | } |
| | | 2610 | | else |
| | | 2611 | | { |
| | 0 | 2612 | | baseQuery = baseQuery |
| | 0 | 2613 | | .Where(e => !e.Data!.Contains("IsPlaceHolder\":true")); |
| | | 2614 | | } |
| | | 2615 | | } |
| | | 2616 | | |
| | 335 | 2617 | | if (filter.HasSpecialFeature.HasValue) |
| | | 2618 | | { |
| | 0 | 2619 | | if (filter.HasSpecialFeature.Value) |
| | | 2620 | | { |
| | 0 | 2621 | | baseQuery = baseQuery |
| | 0 | 2622 | | .Where(e => e.ExtraIds != null); |
| | | 2623 | | } |
| | | 2624 | | else |
| | | 2625 | | { |
| | 0 | 2626 | | baseQuery = baseQuery |
| | 0 | 2627 | | .Where(e => e.ExtraIds == null); |
| | | 2628 | | } |
| | | 2629 | | } |
| | | 2630 | | |
| | 335 | 2631 | | if (filter.HasTrailer.HasValue || filter.HasThemeSong.HasValue || filter.HasThemeVideo.HasValue) |
| | | 2632 | | { |
| | 0 | 2633 | | if (filter.HasTrailer.GetValueOrDefault() || filter.HasThemeSong.GetValueOrDefault() || filter.HasThemeVideo |
| | | 2634 | | { |
| | 0 | 2635 | | baseQuery = baseQuery |
| | 0 | 2636 | | .Where(e => e.ExtraIds != null); |
| | | 2637 | | } |
| | | 2638 | | else |
| | | 2639 | | { |
| | 0 | 2640 | | baseQuery = baseQuery |
| | 0 | 2641 | | .Where(e => e.ExtraIds == null); |
| | | 2642 | | } |
| | | 2643 | | } |
| | | 2644 | | |
| | 335 | 2645 | | return baseQuery; |
| | | 2646 | | } |
| | | 2647 | | |
| | | 2648 | | /// <inheritdoc/> |
| | | 2649 | | public async Task<bool> ItemExistsAsync(Guid id) |
| | | 2650 | | { |
| | | 2651 | | var dbContext = await _dbProvider.CreateDbContextAsync().ConfigureAwait(false); |
| | | 2652 | | await using (dbContext.ConfigureAwait(false)) |
| | | 2653 | | { |
| | | 2654 | | return await dbContext.BaseItems.AnyAsync(f => f.Id == id).ConfigureAwait(false); |
| | | 2655 | | } |
| | | 2656 | | } |
| | | 2657 | | |
| | | 2658 | | /// <inheritdoc/> |
| | | 2659 | | public bool GetIsPlayed(User user, Guid id, bool recursive) |
| | | 2660 | | { |
| | 0 | 2661 | | using var dbContext = _dbProvider.CreateDbContext(); |
| | | 2662 | | |
| | 0 | 2663 | | if (recursive) |
| | | 2664 | | { |
| | 0 | 2665 | | var folderList = TraverseHirachyDown(id, dbContext, item => (item.IsFolder || item.IsVirtualItem)); |
| | | 2666 | | |
| | 0 | 2667 | | return dbContext.BaseItems |
| | 0 | 2668 | | .Where(e => folderList.Contains(e.ParentId!.Value) && !e.IsFolder && !e.IsVirtualItem) |
| | 0 | 2669 | | .All(f => f.UserData!.Any(e => e.UserId == user.Id && e.Played)); |
| | | 2670 | | } |
| | | 2671 | | |
| | 0 | 2672 | | return dbContext.BaseItems.Where(e => e.ParentId == id).All(f => f.UserData!.Any(e => e.UserId == user.Id && e.P |
| | 0 | 2673 | | } |
| | | 2674 | | |
| | | 2675 | | private static HashSet<Guid> TraverseHirachyDown(Guid parentId, JellyfinDbContext dbContext, Expression<Func<BaseIte |
| | | 2676 | | { |
| | 1 | 2677 | | var folderStack = new HashSet<Guid>() |
| | 1 | 2678 | | { |
| | 1 | 2679 | | parentId |
| | 1 | 2680 | | }; |
| | 1 | 2681 | | var folderList = new HashSet<Guid>() |
| | 1 | 2682 | | { |
| | 1 | 2683 | | parentId |
| | 1 | 2684 | | }; |
| | | 2685 | | |
| | 2 | 2686 | | while (folderStack.Count != 0) |
| | | 2687 | | { |
| | 1 | 2688 | | var items = folderStack.ToArray(); |
| | 1 | 2689 | | folderStack.Clear(); |
| | 1 | 2690 | | var query = dbContext.BaseItems |
| | 1 | 2691 | | .WhereOneOrMany(items, e => e.ParentId!.Value); |
| | | 2692 | | |
| | 1 | 2693 | | if (filter != null) |
| | | 2694 | | { |
| | 0 | 2695 | | query = query.Where(filter); |
| | | 2696 | | } |
| | | 2697 | | |
| | 2 | 2698 | | foreach (var item in query.Select(e => e.Id).ToArray()) |
| | | 2699 | | { |
| | 0 | 2700 | | if (folderList.Add(item)) |
| | | 2701 | | { |
| | 0 | 2702 | | folderStack.Add(item); |
| | | 2703 | | } |
| | | 2704 | | } |
| | | 2705 | | } |
| | | 2706 | | |
| | 1 | 2707 | | return folderList; |
| | | 2708 | | } |
| | | 2709 | | |
| | | 2710 | | /// <inheritdoc/> |
| | | 2711 | | public IReadOnlyDictionary<string, MusicArtist[]> FindArtists(IReadOnlyList<string> artistNames) |
| | | 2712 | | { |
| | 0 | 2713 | | using var dbContext = _dbProvider.CreateDbContext(); |
| | | 2714 | | |
| | 0 | 2715 | | var artists = dbContext.BaseItems.Where(e => e.Type == _itemTypeLookup.BaseItemKindNames[BaseItemKind.MusicArtis |
| | 0 | 2716 | | .Where(e => artistNames.Contains(e.Name)) |
| | 0 | 2717 | | .ToArray(); |
| | | 2718 | | |
| | 0 | 2719 | | var lookup = artists |
| | 0 | 2720 | | .GroupBy(e => e.Name!) |
| | 0 | 2721 | | .ToDictionary( |
| | 0 | 2722 | | g => g.Key, |
| | 0 | 2723 | | g => g.Select(f => DeserializeBaseItem(f)).Where(dto => dto is not null).Cast<MusicArtist>().ToArray()); |
| | | 2724 | | |
| | 0 | 2725 | | var result = new Dictionary<string, MusicArtist[]>(artistNames.Count); |
| | 0 | 2726 | | foreach (var name in artistNames) |
| | | 2727 | | { |
| | 0 | 2728 | | if (lookup.TryGetValue(name, out var artistArray)) |
| | | 2729 | | { |
| | 0 | 2730 | | result[name] = artistArray; |
| | | 2731 | | } |
| | | 2732 | | } |
| | | 2733 | | |
| | 0 | 2734 | | return result; |
| | 0 | 2735 | | } |
| | | 2736 | | } |