| | | 1 | | #pragma warning disable RS0030 // Do not use banned APIs |
| | | 2 | | |
| | | 3 | | using System; |
| | | 4 | | using System.Collections.Generic; |
| | | 5 | | using System.Globalization; |
| | | 6 | | using System.Linq; |
| | | 7 | | using System.Threading; |
| | | 8 | | using System.Threading.Tasks; |
| | | 9 | | using Jellyfin.Database.Implementations; |
| | | 10 | | using Jellyfin.Database.Implementations.Entities; |
| | | 11 | | using Jellyfin.Extensions; |
| | | 12 | | using MediaBrowser.Controller; |
| | | 13 | | using MediaBrowser.Controller.Entities; |
| | | 14 | | using MediaBrowser.Controller.Entities.Audio; |
| | | 15 | | using MediaBrowser.Controller.Persistence; |
| | | 16 | | using MediaBrowser.Controller.Playlists; |
| | | 17 | | using Microsoft.EntityFrameworkCore; |
| | | 18 | | using Microsoft.Extensions.Logging; |
| | | 19 | | using BaseItemDto = MediaBrowser.Controller.Entities.BaseItem; |
| | | 20 | | using DbLinkedChildType = Jellyfin.Database.Implementations.Entities.LinkedChildType; |
| | | 21 | | using LinkedChildType = MediaBrowser.Controller.Entities.LinkedChildType; |
| | | 22 | | |
| | | 23 | | namespace Jellyfin.Server.Implementations.Item; |
| | | 24 | | |
| | | 25 | | /// <summary> |
| | | 26 | | /// Handles item persistence operations (save, delete, update). |
| | | 27 | | /// </summary> |
| | | 28 | | public class ItemPersistenceService : IItemPersistenceService |
| | | 29 | | { |
| | | 30 | | private readonly IDbContextFactory<JellyfinDbContext> _dbProvider; |
| | | 31 | | private readonly IServerApplicationHost _appHost; |
| | | 32 | | private readonly ILogger<ItemPersistenceService> _logger; |
| | | 33 | | |
| | | 34 | | /// <summary> |
| | | 35 | | /// Initializes a new instance of the <see cref="ItemPersistenceService"/> class. |
| | | 36 | | /// </summary> |
| | | 37 | | /// <param name="dbProvider">The database context factory.</param> |
| | | 38 | | /// <param name="appHost">The application host.</param> |
| | | 39 | | /// <param name="logger">The logger.</param> |
| | | 40 | | public ItemPersistenceService( |
| | | 41 | | IDbContextFactory<JellyfinDbContext> dbProvider, |
| | | 42 | | IServerApplicationHost appHost, |
| | | 43 | | ILogger<ItemPersistenceService> logger) |
| | | 44 | | { |
| | 48 | 45 | | _dbProvider = dbProvider; |
| | 48 | 46 | | _appHost = appHost; |
| | 48 | 47 | | _logger = logger; |
| | 48 | 48 | | } |
| | | 49 | | |
| | | 50 | | /// <inheritdoc /> |
| | | 51 | | public void DeleteItem(params IReadOnlyList<Guid> ids) |
| | | 52 | | { |
| | 12 | 53 | | if (ids is null || ids.Count == 0 || ids.Any(f => f.Equals(BaseItemRepository.PlaceholderId))) |
| | | 54 | | { |
| | 0 | 55 | | throw new ArgumentException("Guid can't be empty or the placeholder id.", nameof(ids)); |
| | | 56 | | } |
| | | 57 | | |
| | 12 | 58 | | using var context = _dbProvider.CreateDbContext(); |
| | 12 | 59 | | using var transaction = context.Database.BeginTransaction(); |
| | | 60 | | |
| | 12 | 61 | | var date = (DateTime?)DateTime.UtcNow; |
| | | 62 | | |
| | 12 | 63 | | var descendantIds = DescendantQueryHelper.GetOwnedDescendantIdsBatch(context, ids); |
| | 50 | 64 | | foreach (var id in ids) |
| | | 65 | | { |
| | 13 | 66 | | descendantIds.Add(id); |
| | | 67 | | } |
| | | 68 | | |
| | | 69 | | // Use WhereOneOrMany instead of a raw HashSet.Contains so large id sets are bound as a |
| | | 70 | | // single parameter (json_each) rather than one SQL variable per id, which would otherwise |
| | | 71 | | // overflow SQLite's variable limit when deleting many items at once (e.g. migrations). |
| | 12 | 72 | | var frontier = descendantIds.ToArray(); |
| | 32 | 73 | | while (frontier.Length > 0) |
| | | 74 | | { |
| | 20 | 75 | | var ownedIds = context.BaseItems |
| | 20 | 76 | | .Where(e => e.OwnerId.HasValue) |
| | 20 | 77 | | .WhereOneOrMany(frontier, e => e.OwnerId!.Value) |
| | 20 | 78 | | .Select(e => e.Id) |
| | 20 | 79 | | .ToArray(); |
| | | 80 | | |
| | 20 | 81 | | var childIds = context.BaseItems |
| | 20 | 82 | | .Where(e => e.ParentId.HasValue) |
| | 20 | 83 | | .WhereOneOrMany(frontier, e => e.ParentId!.Value) |
| | 20 | 84 | | .Select(e => e.Id) |
| | 20 | 85 | | .ToArray(); |
| | | 86 | | |
| | | 87 | | // Only ids that were not already known become the next frontier, so ownership cycles |
| | | 88 | | // terminate instead of looping forever. |
| | 20 | 89 | | frontier = [.. ownedIds.Concat(childIds).Where(e => descendantIds.Add(e))]; |
| | | 90 | | } |
| | | 91 | | |
| | 12 | 92 | | var relatedItems = descendantIds.ToArray(); |
| | | 93 | | |
| | | 94 | | // When batch-deleting, multiple items may have UserData for the same (UserId, CustomDataKey). |
| | | 95 | | // Moving all of them to PlaceholderId would violate the UNIQUE constraint. |
| | | 96 | | // Deduplicate by loading keys client-side, keeping the best row per group. |
| | 12 | 97 | | var batchUserData = context.UserData.WhereOneOrMany(relatedItems, e => e.ItemId); |
| | | 98 | | |
| | 12 | 99 | | var allRows = batchUserData |
| | 12 | 100 | | .Select(ud => new { ud.ItemId, ud.UserId, ud.CustomDataKey, ud.LastPlayedDate, ud.PlayCount }) |
| | 12 | 101 | | .ToList(); |
| | | 102 | | |
| | 12 | 103 | | var duplicateRows = allRows |
| | 12 | 104 | | .GroupBy(ud => new { ud.UserId, ud.CustomDataKey }) |
| | 12 | 105 | | .Where(g => g.Count() > 1) |
| | 12 | 106 | | .SelectMany(g => g |
| | 12 | 107 | | .OrderByDescending(ud => ud.LastPlayedDate) |
| | 12 | 108 | | .ThenByDescending(ud => ud.PlayCount) |
| | 12 | 109 | | .Skip(1)) |
| | 12 | 110 | | .ToList(); |
| | | 111 | | |
| | 24 | 112 | | foreach (var dup in duplicateRows) |
| | | 113 | | { |
| | 0 | 114 | | context.UserData |
| | 0 | 115 | | .Where(ud => ud.ItemId == dup.ItemId && ud.UserId == dup.UserId && ud.CustomDataKey == dup.CustomDataKey |
| | 0 | 116 | | .ExecuteDelete(); |
| | | 117 | | } |
| | | 118 | | |
| | | 119 | | // Delete existing placeholder rows that would conflict with the incoming ones |
| | 12 | 120 | | context.UserData |
| | 12 | 121 | | .Join( |
| | 12 | 122 | | batchUserData, |
| | 12 | 123 | | placeholder => new { placeholder.UserId, placeholder.CustomDataKey }, |
| | 12 | 124 | | userData => new { userData.UserId, userData.CustomDataKey }, |
| | 12 | 125 | | (placeholder, userData) => placeholder) |
| | 12 | 126 | | .Where(e => e.ItemId == BaseItemRepository.PlaceholderId) |
| | 12 | 127 | | .ExecuteDelete(); |
| | | 128 | | |
| | 12 | 129 | | batchUserData |
| | 12 | 130 | | .ExecuteUpdate(e => e |
| | 12 | 131 | | .SetProperty(f => f.RetentionDate, date) |
| | 12 | 132 | | .SetProperty(f => f.ItemId, BaseItemRepository.PlaceholderId)); |
| | | 133 | | |
| | 12 | 134 | | context.AncestorIds.WhereOneOrMany(relatedItems, e => e.ItemId).ExecuteDelete(); |
| | 12 | 135 | | context.AncestorIds.WhereOneOrMany(relatedItems, e => e.ParentItemId).ExecuteDelete(); |
| | 12 | 136 | | context.AttachmentStreamInfos.WhereOneOrMany(relatedItems, e => e.ItemId).ExecuteDelete(); |
| | 12 | 137 | | context.BaseItemImageInfos.WhereOneOrMany(relatedItems, e => e.ItemId).ExecuteDelete(); |
| | 12 | 138 | | context.BaseItemMetadataFields.WhereOneOrMany(relatedItems, e => e.ItemId).ExecuteDelete(); |
| | 12 | 139 | | context.BaseItemProviders.WhereOneOrMany(relatedItems, e => e.ItemId).ExecuteDelete(); |
| | 12 | 140 | | context.BaseItemTrailerTypes.WhereOneOrMany(relatedItems, e => e.ItemId).ExecuteDelete(); |
| | 12 | 141 | | context.Chapters.WhereOneOrMany(relatedItems, e => e.ItemId).ExecuteDelete(); |
| | 12 | 142 | | context.CustomItemDisplayPreferences.WhereOneOrMany(relatedItems, e => e.ItemId).ExecuteDelete(); |
| | 12 | 143 | | context.ItemDisplayPreferences.WhereOneOrMany(relatedItems, e => e.ItemId).ExecuteDelete(); |
| | 12 | 144 | | context.ItemValuesMap.WhereOneOrMany(relatedItems, e => e.ItemId).ExecuteDelete(); |
| | 12 | 145 | | context.LinkedChildren.WhereOneOrMany(relatedItems, e => e.ParentId).ExecuteDelete(); |
| | 12 | 146 | | context.LinkedChildren.WhereOneOrMany(relatedItems, e => e.ChildId).ExecuteDelete(); |
| | 12 | 147 | | var peopleIds = context.PeopleBaseItemMap.WhereOneOrMany(relatedItems, e => e.ItemId).Select(f => f.PeopleId).Di |
| | 12 | 148 | | context.BaseItems.WhereOneOrMany(relatedItems, e => e.Id).ExecuteDelete(); |
| | 12 | 149 | | context.ItemValues.Where(e => !e.BaseItemsMap!.Any()).ExecuteDelete(); |
| | 11 | 150 | | context.KeyframeData.WhereOneOrMany(relatedItems, e => e.ItemId).ExecuteDelete(); |
| | 11 | 151 | | context.MediaSegments.WhereOneOrMany(relatedItems, e => e.ItemId).ExecuteDelete(); |
| | 11 | 152 | | context.MediaStreamInfos.WhereOneOrMany(relatedItems, e => e.ItemId).ExecuteDelete(); |
| | 11 | 153 | | context.PeopleBaseItemMap.WhereOneOrMany(relatedItems, e => e.ItemId).ExecuteDelete(); |
| | 11 | 154 | | context.Peoples.WhereOneOrMany(peopleIds, e => e.Id).Where(e => !e.BaseItems!.Any()).ExecuteDelete(); |
| | 11 | 155 | | context.TrickplayInfos.WhereOneOrMany(relatedItems, e => e.ItemId).ExecuteDelete(); |
| | 11 | 156 | | context.SaveChanges(); |
| | 11 | 157 | | transaction.Commit(); |
| | 22 | 158 | | } |
| | | 159 | | |
| | | 160 | | /// <inheritdoc /> |
| | | 161 | | public void UpdateInheritedValues() |
| | | 162 | | { |
| | 20 | 163 | | using var context = _dbProvider.CreateDbContext(); |
| | 20 | 164 | | using var transaction = context.Database.BeginTransaction(); |
| | | 165 | | |
| | 20 | 166 | | context.ItemValuesMap.Where(e => e.ItemValue.Type == ItemValueType.InheritedTags).ExecuteDelete(); |
| | 20 | 167 | | context.SaveChanges(); |
| | | 168 | | |
| | 20 | 169 | | transaction.Commit(); |
| | 40 | 170 | | } |
| | | 171 | | |
| | | 172 | | /// <inheritdoc /> |
| | | 173 | | public void SaveItems(IReadOnlyList<BaseItemDto> items, CancellationToken cancellationToken) |
| | | 174 | | { |
| | 172 | 175 | | UpdateOrInsertItems(items, cancellationToken); |
| | 172 | 176 | | } |
| | | 177 | | |
| | | 178 | | /// <inheritdoc /> |
| | | 179 | | public async Task SaveImagesAsync(BaseItem item, CancellationToken cancellationToken = default) |
| | | 180 | | { |
| | 3 | 181 | | ArgumentNullException.ThrowIfNull(item); |
| | | 182 | | |
| | 3 | 183 | | var images = item.ImageInfos.Select(e => BaseItemMapper.MapImageToEntity(item.Id, e)).ToArray(); |
| | | 184 | | |
| | 3 | 185 | | var context = await _dbProvider.CreateDbContextAsync(cancellationToken).ConfigureAwait(false); |
| | 3 | 186 | | await using (context.ConfigureAwait(false)) |
| | | 187 | | { |
| | 3 | 188 | | await context.BaseItemImageInfos |
| | 3 | 189 | | .Where(e => e.ItemId == item.Id) |
| | 3 | 190 | | .ExecuteDeleteAsync(cancellationToken) |
| | 3 | 191 | | .ConfigureAwait(false); |
| | | 192 | | |
| | 3 | 193 | | await context.BaseItemImageInfos |
| | 3 | 194 | | .AddRangeAsync(images, cancellationToken) |
| | 3 | 195 | | .ConfigureAwait(false); |
| | | 196 | | |
| | | 197 | | try |
| | | 198 | | { |
| | 3 | 199 | | await context.SaveChangesAsync(cancellationToken).ConfigureAwait(false); |
| | 2 | 200 | | } |
| | 1 | 201 | | catch (DbUpdateException) |
| | | 202 | | { |
| | | 203 | | // Checking that the item exists before writing leaves a gap a scan can delete it |
| | | 204 | | // through, turning the insert into a foreign key violation that fails the whole |
| | | 205 | | // refresh instead of the no-op intended here. Let the insert be the check: it is the |
| | | 206 | | // only point at which the answer cannot go stale. Nothing is orphaned by the delete |
| | | 207 | | // above, because deleting the item cascades to its images anyway. |
| | 1 | 208 | | if (await context.BaseItems |
| | 1 | 209 | | .AnyAsync(bi => bi.Id == item.Id, cancellationToken) |
| | 1 | 210 | | .ConfigureAwait(false)) |
| | | 211 | | { |
| | 0 | 212 | | throw; |
| | | 213 | | } |
| | | 214 | | |
| | 1 | 215 | | _logger.LogWarning("Unable to save ImageInfo for non existing BaseItem {ItemId}", item.Id); |
| | | 216 | | } |
| | | 217 | | } |
| | 3 | 218 | | } |
| | | 219 | | |
| | | 220 | | /// <inheritdoc /> |
| | | 221 | | public async Task ReattachUserDataAsync(BaseItemDto item, CancellationToken cancellationToken) |
| | | 222 | | { |
| | 49 | 223 | | ArgumentNullException.ThrowIfNull(item); |
| | 49 | 224 | | cancellationToken.ThrowIfCancellationRequested(); |
| | | 225 | | |
| | 48 | 226 | | var dbContext = await _dbProvider.CreateDbContextAsync(cancellationToken).ConfigureAwait(false); |
| | | 227 | | |
| | 48 | 228 | | await using (dbContext.ConfigureAwait(false)) |
| | | 229 | | { |
| | 48 | 230 | | var transaction = await dbContext.Database.BeginTransactionAsync(cancellationToken).ConfigureAwait(false); |
| | 48 | 231 | | await using (transaction.ConfigureAwait(false)) |
| | | 232 | | { |
| | 48 | 233 | | var userKeys = item.GetUserDataKeys().Distinct().ToList(); |
| | | 234 | | |
| | 48 | 235 | | var detached = await dbContext.UserData |
| | 48 | 236 | | .Where(e => e.ItemId == BaseItemRepository.PlaceholderId) |
| | 48 | 237 | | .Where(e => userKeys.Contains(e.CustomDataKey)) |
| | 48 | 238 | | .ToListAsync(cancellationToken) |
| | 48 | 239 | | .ConfigureAwait(false); |
| | | 240 | | |
| | 48 | 241 | | if (detached.Count > 0) |
| | | 242 | | { |
| | 2 | 243 | | await ReconcileUserDataAsync(dbContext, item, userKeys, detached, cancellationToken).ConfigureAwait( |
| | | 244 | | } |
| | | 245 | | |
| | 48 | 246 | | item.UserData = await dbContext.UserData |
| | 48 | 247 | | .AsNoTracking() |
| | 48 | 248 | | .Where(e => e.ItemId == item.Id) |
| | 48 | 249 | | .ToArrayAsync(cancellationToken) |
| | 48 | 250 | | .ConfigureAwait(false); |
| | | 251 | | |
| | 48 | 252 | | await transaction.CommitAsync(cancellationToken).ConfigureAwait(false); |
| | 48 | 253 | | } |
| | 48 | 254 | | } |
| | 48 | 255 | | } |
| | | 256 | | |
| | | 257 | | private static async Task ReconcileUserDataAsync( |
| | | 258 | | JellyfinDbContext dbContext, |
| | | 259 | | BaseItemDto item, |
| | | 260 | | IReadOnlyList<string> userKeys, |
| | | 261 | | List<UserData> detached, |
| | | 262 | | CancellationToken cancellationToken) |
| | | 263 | | { |
| | 2 | 264 | | var existing = await dbContext.UserData |
| | 2 | 265 | | .Where(e => e.ItemId == item.Id) |
| | 2 | 266 | | .ToListAsync(cancellationToken) |
| | 2 | 267 | | .ConfigureAwait(false); |
| | | 268 | | |
| | | 269 | | // Keys the item no longer reports are carried over: they may only be missing mid-refresh. |
| | 2 | 270 | | var winners = detached.Concat(existing) |
| | 2 | 271 | | .GroupBy(e => e.UserId) |
| | 2 | 272 | | .Select(g => ( |
| | 2 | 273 | | Winner: g |
| | 2 | 274 | | .OrderByDescending(e => e.LastPlayedDate) |
| | 2 | 275 | | .ThenByDescending(e => e.PlayCount) |
| | 2 | 276 | | .ThenByDescending(e => e.PlaybackPositionTicks) |
| | 2 | 277 | | .First(), |
| | 2 | 278 | | Keys: userKeys.Union(g.Select(e => e.CustomDataKey)).ToList())) |
| | 2 | 279 | | .ToList(); |
| | | 280 | | |
| | 2 | 281 | | dbContext.UserData.RemoveRange(detached); |
| | 2 | 282 | | dbContext.UserData.RemoveRange(existing); |
| | 2 | 283 | | await dbContext.SaveChangesAsync(cancellationToken).ConfigureAwait(false); |
| | | 284 | | |
| | 8 | 285 | | foreach (var (winner, keys) in winners) |
| | | 286 | | { |
| | 18 | 287 | | foreach (var key in keys) |
| | | 288 | | { |
| | 7 | 289 | | dbContext.UserData.Add(new UserData |
| | 7 | 290 | | { |
| | 7 | 291 | | ItemId = item.Id, |
| | 7 | 292 | | Item = null, |
| | 7 | 293 | | UserId = winner.UserId, |
| | 7 | 294 | | User = null, |
| | 7 | 295 | | CustomDataKey = key, |
| | 7 | 296 | | RetentionDate = null, |
| | 7 | 297 | | AudioStreamIndex = winner.AudioStreamIndex, |
| | 7 | 298 | | IsFavorite = winner.IsFavorite, |
| | 7 | 299 | | LastPlayedDate = winner.LastPlayedDate, |
| | 7 | 300 | | Likes = winner.Likes, |
| | 7 | 301 | | PlaybackPositionTicks = winner.PlaybackPositionTicks, |
| | 7 | 302 | | PlayCount = winner.PlayCount, |
| | 7 | 303 | | Played = winner.Played, |
| | 7 | 304 | | Rating = winner.Rating, |
| | 7 | 305 | | SubtitleStreamIndex = winner.SubtitleStreamIndex |
| | 7 | 306 | | }); |
| | | 307 | | } |
| | | 308 | | } |
| | | 309 | | |
| | 2 | 310 | | await dbContext.SaveChangesAsync(cancellationToken).ConfigureAwait(false); |
| | 2 | 311 | | } |
| | | 312 | | |
| | | 313 | | private void UpdateOrInsertItems(IReadOnlyList<BaseItemDto> items, CancellationToken cancellationToken) |
| | | 314 | | { |
| | 172 | 315 | | ArgumentNullException.ThrowIfNull(items); |
| | 172 | 316 | | cancellationToken.ThrowIfCancellationRequested(); |
| | | 317 | | |
| | 172 | 318 | | var tuples = new List<(BaseItemDto Item, List<Guid>? AncestorIds, BaseItemDto TopParent, IEnumerable<string> Use |
| | 690 | 319 | | foreach (var item in items.GroupBy(e => e.Id).Select(e => e.Last()).Where(e => e.Id != BaseItemRepository.Placeh |
| | | 320 | | { |
| | 173 | 321 | | var ancestorIds = item.SupportsAncestors ? |
| | 173 | 322 | | item.GetAncestorIds().Distinct().ToList() : |
| | 173 | 323 | | null; |
| | | 324 | | |
| | 173 | 325 | | var topParent = item.GetTopParent(); |
| | | 326 | | |
| | 173 | 327 | | var userdataKey = item.GetUserDataKeys(); |
| | 173 | 328 | | var inheritedTags = item.GetInheritedTags(); |
| | | 329 | | |
| | 173 | 330 | | tuples.Add((item, ancestorIds, topParent, userdataKey, inheritedTags)); |
| | | 331 | | } |
| | | 332 | | |
| | 172 | 333 | | using var context = _dbProvider.CreateDbContext(); |
| | 172 | 334 | | using var transaction = context.Database.BeginTransaction(); |
| | | 335 | | |
| | 172 | 336 | | var ids = tuples.Select(f => f.Item.Id).ToArray(); |
| | 172 | 337 | | var existingItems = context.BaseItems.WhereOneOrMany(ids, e => e.Id).Select(f => f.Id).ToHashSet(); |
| | | 338 | | |
| | 690 | 339 | | foreach (var item in tuples) |
| | | 340 | | { |
| | 173 | 341 | | var entity = BaseItemMapper.Map(item.Item, _appHost); |
| | 173 | 342 | | entity.TopParentId = item.TopParent?.Id; |
| | | 343 | | |
| | 173 | 344 | | if (!existingItems.Contains(entity.Id)) |
| | | 345 | | { |
| | 94 | 346 | | context.BaseItems.Add(entity); |
| | | 347 | | } |
| | | 348 | | else |
| | | 349 | | { |
| | 79 | 350 | | if (entity.Images is { Count: > 0 }) |
| | | 351 | | { |
| | 2 | 352 | | context.BaseItemImageInfos.AddRange(entity.Images); |
| | | 353 | | } |
| | | 354 | | |
| | 79 | 355 | | if (entity.LockedFields is { Count: > 0 }) |
| | | 356 | | { |
| | 1 | 357 | | context.BaseItemMetadataFields.AddRange(entity.LockedFields); |
| | | 358 | | } |
| | | 359 | | |
| | 79 | 360 | | context.BaseItems.Attach(entity).State = EntityState.Modified; |
| | | 361 | | } |
| | | 362 | | } |
| | | 363 | | |
| | 172 | 364 | | var itemValueMaps = tuples |
| | 172 | 365 | | .Select(e => (e.Item, Values: GetItemValuesToSave(e.Item, e.InheritedTags))) |
| | 172 | 366 | | .ToArray(); |
| | 172 | 367 | | var allListedItemValues = itemValueMaps |
| | 172 | 368 | | .SelectMany(f => f.Values) |
| | 172 | 369 | | .Distinct() |
| | 172 | 370 | | .ToArray(); |
| | | 371 | | |
| | 172 | 372 | | var types = allListedItemValues.Select(e => e.MagicNumber).Distinct().ToArray(); |
| | 172 | 373 | | var values = allListedItemValues.Select(e => e.Value).Distinct().ToArray(); |
| | 172 | 374 | | var allListedItemValuesSet = allListedItemValues.ToHashSet(); |
| | | 375 | | |
| | 172 | 376 | | var existingValues = context.ItemValues |
| | 172 | 377 | | .Where(e => types.Contains(e.Type) && values.Contains(e.Value)) |
| | 172 | 378 | | .AsEnumerable() |
| | 172 | 379 | | .Where(e => allListedItemValuesSet.Contains((e.Type, e.Value))) |
| | 172 | 380 | | .ToArray(); |
| | 172 | 381 | | var missingItemValues = allListedItemValues.Except(existingValues.Select(f => (MagicNumber: f.Type, f.Value))).S |
| | 172 | 382 | | { |
| | 172 | 383 | | CleanValue = f.Value.GetCleanValue(), |
| | 172 | 384 | | ItemValueId = Guid.NewGuid(), |
| | 172 | 385 | | Type = f.MagicNumber, |
| | 172 | 386 | | Value = f.Value |
| | 172 | 387 | | }).ToArray(); |
| | 172 | 388 | | context.ItemValues.AddRange(missingItemValues); |
| | | 389 | | |
| | 172 | 390 | | var itemValuesStore = existingValues |
| | 172 | 391 | | .Concat(missingItemValues) |
| | 172 | 392 | | .ToDictionary(e => (e.Type, e.Value)); |
| | 172 | 393 | | var valueMap = itemValueMaps |
| | 172 | 394 | | .Select(f => (f.Item, Values: f.Values.Select(e => itemValuesStore[(e.MagicNumber, e.Value)]).DistinctBy(e = |
| | 172 | 395 | | .ToArray(); |
| | | 396 | | |
| | 172 | 397 | | var mappedValues = context.ItemValuesMap.WhereOneOrMany(ids, e => e.ItemId).ToList(); |
| | | 398 | | |
| | 690 | 399 | | foreach (var item in valueMap) |
| | | 400 | | { |
| | 173 | 401 | | var itemMappedValues = mappedValues.Where(e => e.ItemId == item.Item.Id).ToList(); |
| | 346 | 402 | | foreach (var itemValue in item.Values) |
| | | 403 | | { |
| | 0 | 404 | | var existingItem = itemMappedValues.FirstOrDefault(f => f.ItemValueId == itemValue.ItemValueId); |
| | 0 | 405 | | if (existingItem is null) |
| | | 406 | | { |
| | 0 | 407 | | context.ItemValuesMap.Add(new ItemValueMap() |
| | 0 | 408 | | { |
| | 0 | 409 | | Item = null!, |
| | 0 | 410 | | ItemId = item.Item.Id, |
| | 0 | 411 | | ItemValue = null!, |
| | 0 | 412 | | ItemValueId = itemValue.ItemValueId |
| | 0 | 413 | | }); |
| | | 414 | | } |
| | | 415 | | else |
| | | 416 | | { |
| | 0 | 417 | | itemMappedValues.Remove(existingItem); |
| | | 418 | | } |
| | | 419 | | } |
| | | 420 | | |
| | 173 | 421 | | context.ItemValuesMap.RemoveRange(itemMappedValues); |
| | | 422 | | } |
| | | 423 | | |
| | 172 | 424 | | var itemsWithAncestors = tuples |
| | 172 | 425 | | .Where(t => t.Item.SupportsAncestors && t.AncestorIds != null) |
| | 172 | 426 | | .Select(t => t.Item.Id) |
| | 172 | 427 | | .ToList(); |
| | | 428 | | |
| | 172 | 429 | | var allExistingAncestorIds = itemsWithAncestors.Count > 0 |
| | 172 | 430 | | ? context.AncestorIds |
| | 172 | 431 | | .Where(e => itemsWithAncestors.Contains(e.ItemId)) |
| | 172 | 432 | | .ToList() |
| | 172 | 433 | | .GroupBy(e => e.ItemId) |
| | 172 | 434 | | .ToDictionary(g => g.Key, g => g.ToList()) |
| | 172 | 435 | | : new Dictionary<Guid, List<AncestorId>>(); |
| | | 436 | | |
| | 172 | 437 | | var allRequestedAncestorIds = tuples |
| | 172 | 438 | | .Where(t => t.Item.SupportsAncestors && t.AncestorIds != null) |
| | 172 | 439 | | .SelectMany(t => t.AncestorIds!) |
| | 172 | 440 | | .Distinct() |
| | 172 | 441 | | .ToList(); |
| | | 442 | | |
| | 172 | 443 | | var validAncestorIdsSet = allRequestedAncestorIds.Count > 0 |
| | 172 | 444 | | ? context.BaseItems |
| | 172 | 445 | | .Where(e => allRequestedAncestorIds.Contains(e.Id)) |
| | 172 | 446 | | .Select(f => f.Id) |
| | 172 | 447 | | .ToHashSet() |
| | 172 | 448 | | : new HashSet<Guid>(); |
| | | 449 | | |
| | 690 | 450 | | foreach (var item in tuples) |
| | | 451 | | { |
| | 173 | 452 | | if (item.Item.SupportsAncestors && item.AncestorIds != null) |
| | | 453 | | { |
| | 173 | 454 | | var existingAncestorIds = allExistingAncestorIds.GetValueOrDefault(item.Item.Id) ?? new List<AncestorId> |
| | 173 | 455 | | var validAncestorIds = item.AncestorIds.Where(id => validAncestorIdsSet.Contains(id)).ToArray(); |
| | 460 | 456 | | foreach (var ancestorId in validAncestorIds) |
| | | 457 | | { |
| | 57 | 458 | | var existingAncestorId = existingAncestorIds.FirstOrDefault(e => e.ParentItemId == ancestorId); |
| | 57 | 459 | | if (existingAncestorId is null) |
| | | 460 | | { |
| | 36 | 461 | | context.AncestorIds.Add(new AncestorId() |
| | 36 | 462 | | { |
| | 36 | 463 | | ParentItemId = ancestorId, |
| | 36 | 464 | | ItemId = item.Item.Id, |
| | 36 | 465 | | Item = null!, |
| | 36 | 466 | | ParentItem = null! |
| | 36 | 467 | | }); |
| | | 468 | | } |
| | | 469 | | else |
| | | 470 | | { |
| | 21 | 471 | | existingAncestorIds.Remove(existingAncestorId); |
| | | 472 | | } |
| | | 473 | | } |
| | | 474 | | |
| | 173 | 475 | | context.AncestorIds.RemoveRange(existingAncestorIds); |
| | | 476 | | } |
| | | 477 | | } |
| | | 478 | | |
| | | 479 | | // Owned rows of updated items are rewritten wholesale; cleared in one statement per table. |
| | 172 | 480 | | if (existingItems.Count > 0) |
| | | 481 | | { |
| | 79 | 482 | | var updatedIds = existingItems.ToArray(); |
| | 79 | 483 | | context.BaseItemProviders.WhereOneOrMany(updatedIds, e => e.ItemId).ExecuteDelete(); |
| | 79 | 484 | | context.BaseItemImageInfos.WhereOneOrMany(updatedIds, e => e.ItemId).ExecuteDelete(); |
| | 79 | 485 | | context.BaseItemMetadataFields.WhereOneOrMany(updatedIds, e => e.ItemId).ExecuteDelete(); |
| | | 486 | | } |
| | | 487 | | |
| | 172 | 488 | | context.SaveChanges(); |
| | | 489 | | |
| | 172 | 490 | | var folderIds = tuples |
| | 172 | 491 | | .Where(t => t.Item is Folder) |
| | 172 | 492 | | .Select(t => t.Item.Id) |
| | 172 | 493 | | .ToList(); |
| | | 494 | | |
| | 172 | 495 | | var videoIds = tuples |
| | 172 | 496 | | .Where(t => t.Item is Video) |
| | 172 | 497 | | .Select(t => t.Item.Id) |
| | 172 | 498 | | .ToList(); |
| | | 499 | | |
| | 172 | 500 | | var allLinkedChildrenByParent = new Dictionary<Guid, List<LinkedChildEntity>>(); |
| | 172 | 501 | | if (folderIds.Count > 0 || videoIds.Count > 0) |
| | | 502 | | { |
| | 168 | 503 | | var allParentIds = folderIds.Concat(videoIds).Distinct().ToList(); |
| | 168 | 504 | | var allLinkedChildren = context.LinkedChildren |
| | 168 | 505 | | .Where(e => allParentIds.Contains(e.ParentId)) |
| | 168 | 506 | | .ToList(); |
| | | 507 | | |
| | 168 | 508 | | allLinkedChildrenByParent = allLinkedChildren |
| | 168 | 509 | | .GroupBy(e => e.ParentId) |
| | 168 | 510 | | .ToDictionary(g => g.Key, g => g.ToList()); |
| | | 511 | | } |
| | | 512 | | |
| | 690 | 513 | | foreach (var item in tuples) |
| | | 514 | | { |
| | | 515 | | // A container that was never hydrated cannot be used to rewrite its links: its empty |
| | | 516 | | // array means "unknown", so clearing the stored rows would silently empty the item. |
| | 173 | 517 | | if (item.Item is Folder { LinkedChildrenLoaded: false }) |
| | | 518 | | { |
| | | 519 | | continue; |
| | | 520 | | } |
| | | 521 | | |
| | 124 | 522 | | if (item.Item is Folder or Video |
| | 124 | 523 | | && allLinkedChildrenByParent.TryGetValue(item.Item.Id, out var existingLinks) |
| | 124 | 524 | | && existingLinks.Count > 0) |
| | | 525 | | { |
| | | 526 | | // A video only owns its alternate version links; any other link on that parent is |
| | | 527 | | // written by the folder branch below and must survive. |
| | 0 | 528 | | var staleLinks = item.Item is Folder |
| | 0 | 529 | | ? existingLinks |
| | 0 | 530 | | : existingLinks |
| | 0 | 531 | | .Where(e => e.ChildType is DbLinkedChildType.LocalAlternateVersion or DbLinkedChildType.LinkedAl |
| | 0 | 532 | | .ToList(); |
| | | 533 | | |
| | 0 | 534 | | if (staleLinks.Count > 0) |
| | | 535 | | { |
| | 0 | 536 | | context.LinkedChildren.RemoveRange(staleLinks); |
| | | 537 | | } |
| | | 538 | | } |
| | | 539 | | } |
| | | 540 | | |
| | 172 | 541 | | context.SaveChanges(); |
| | | 542 | | |
| | | 543 | | // A LinkedChild's ItemId is only a cache. |
| | 172 | 544 | | var cachedChildIds = tuples |
| | 172 | 545 | | .Select(t => t.Item) |
| | 172 | 546 | | .OfType<Folder>() |
| | 172 | 547 | | .Where(f => f.LinkedChildrenLoaded) |
| | 172 | 548 | | .SelectMany(f => f.LinkedChildren) |
| | 172 | 549 | | .Where(lc => lc.ItemId.HasValue && !lc.ItemId.Value.IsEmpty()) |
| | 172 | 550 | | .Select(lc => lc.ItemId!.Value) |
| | 172 | 551 | | .Distinct() |
| | 172 | 552 | | .ToList(); |
| | | 553 | | |
| | 172 | 554 | | var knownChildIds = cachedChildIds.Count > 0 |
| | 172 | 555 | | ? context.BaseItems |
| | 172 | 556 | | .WhereOneOrMany(cachedChildIds, e => e.Id) |
| | 172 | 557 | | .Select(e => e.Id) |
| | 172 | 558 | | .ToHashSet() |
| | 172 | 559 | | : []; |
| | | 560 | | |
| | 690 | 561 | | foreach (var item in tuples) |
| | | 562 | | { |
| | 173 | 563 | | if (item.Item is Folder { LinkedChildrenLoaded: true } folder && folder.LinkedChildren.Length > 0) |
| | | 564 | | { |
| | | 565 | | #pragma warning disable CS0618 // Type or member is obsolete - legacy path resolution for old data |
| | 0 | 566 | | var pathsToResolve = folder.LinkedChildren |
| | 0 | 567 | | .Where(lc => !string.IsNullOrEmpty(lc.Path) |
| | 0 | 568 | | && (!lc.ItemId.HasValue || lc.ItemId.Value.IsEmpty() || !knownChildIds.Contains(lc.ItemId.Value) |
| | 0 | 569 | | .Select(lc => lc.Path) |
| | 0 | 570 | | .Distinct() |
| | 0 | 571 | | .ToList(); |
| | | 572 | | |
| | 0 | 573 | | var pathToIdMap = pathsToResolve.Count > 0 |
| | 0 | 574 | | ? context.BaseItems |
| | 0 | 575 | | .Where(e => e.Path != null && pathsToResolve.Contains(e.Path)) |
| | 0 | 576 | | .Select(e => new { e.Path, e.Id }) |
| | 0 | 577 | | .GroupBy(e => e.Path!) |
| | 0 | 578 | | .ToDictionary(g => g.Key, g => g.First().Id) |
| | 0 | 579 | | : []; |
| | | 580 | | |
| | 0 | 581 | | var resolvedChildren = new List<(LinkedChild Child, Guid ChildId)>(); |
| | 0 | 582 | | foreach (var linkedChild in folder.LinkedChildren) |
| | | 583 | | { |
| | 0 | 584 | | var childItemId = linkedChild.ItemId; |
| | 0 | 585 | | if (!childItemId.HasValue || childItemId.Value.IsEmpty() || !knownChildIds.Contains(childItemId.Valu |
| | | 586 | | { |
| | 0 | 587 | | if (!string.IsNullOrEmpty(linkedChild.Path) && pathToIdMap.TryGetValue(linkedChild.Path, out var |
| | | 588 | | { |
| | 0 | 589 | | childItemId = resolvedId; |
| | | 590 | | } |
| | 0 | 591 | | else if (Guid.TryParse(linkedChild.LibraryItemId, out var libraryItemId) && !libraryItemId.IsEmp |
| | | 592 | | { |
| | 0 | 593 | | childItemId = libraryItemId; |
| | | 594 | | } |
| | | 595 | | } |
| | | 596 | | #pragma warning restore CS0618 |
| | | 597 | | |
| | 0 | 598 | | if (childItemId.HasValue && !childItemId.Value.IsEmpty()) |
| | | 599 | | { |
| | 0 | 600 | | resolvedChildren.Add((linkedChild, childItemId.Value)); |
| | | 601 | | } |
| | | 602 | | } |
| | | 603 | | |
| | | 604 | | // Playlists may legitimately contain the same item multiple times (e.g. a song repeated |
| | | 605 | | // in an .m3u file). Every other container type keeps a single entry per child. |
| | 0 | 606 | | var isPlaylist = folder is Playlist; |
| | 0 | 607 | | if (!isPlaylist) |
| | | 608 | | { |
| | 0 | 609 | | resolvedChildren = resolvedChildren |
| | 0 | 610 | | .GroupBy(c => c.ChildId) |
| | 0 | 611 | | .Select(g => g.Last()) |
| | 0 | 612 | | .ToList(); |
| | | 613 | | } |
| | | 614 | | |
| | 0 | 615 | | var childIdsToCheck = resolvedChildren.Select(c => c.ChildId).Distinct().ToList(); |
| | 0 | 616 | | var existingChildIds = childIdsToCheck.Count > 0 |
| | 0 | 617 | | ? context.BaseItems |
| | 0 | 618 | | .WhereOneOrMany(childIdsToCheck, e => e.Id) |
| | 0 | 619 | | .Select(e => e.Id) |
| | 0 | 620 | | .ToHashSet() |
| | 0 | 621 | | : []; |
| | | 622 | | |
| | 0 | 623 | | var sortOrder = 0; |
| | 0 | 624 | | foreach (var (linkedChild, childId) in resolvedChildren) |
| | | 625 | | { |
| | 0 | 626 | | if (!existingChildIds.Contains(childId)) |
| | | 627 | | { |
| | | 628 | | #pragma warning disable CS0618 // Type or member is obsolete - legacy path is logged for diagnostics |
| | 0 | 629 | | _logger.LogWarning( |
| | 0 | 630 | | "Skipping LinkedChild for parent {ParentName} ({ParentId}): child item {ChildId} (path {Chil |
| | 0 | 631 | | item.Item.Name, |
| | 0 | 632 | | item.Item.Id, |
| | 0 | 633 | | childId, |
| | 0 | 634 | | linkedChild.Path ?? "unknown"); |
| | | 635 | | #pragma warning restore CS0618 |
| | 0 | 636 | | continue; |
| | | 637 | | } |
| | | 638 | | |
| | 0 | 639 | | context.LinkedChildren.Add(new LinkedChildEntity() |
| | 0 | 640 | | { |
| | 0 | 641 | | ParentId = item.Item.Id, |
| | 0 | 642 | | ChildId = childId, |
| | 0 | 643 | | ChildType = (DbLinkedChildType)linkedChild.Type, |
| | 0 | 644 | | SortOrder = sortOrder |
| | 0 | 645 | | }); |
| | | 646 | | |
| | 0 | 647 | | sortOrder++; |
| | | 648 | | } |
| | | 649 | | } |
| | | 650 | | |
| | 173 | 651 | | if (item.Item is Video video) |
| | | 652 | | { |
| | 9 | 653 | | var newLinkedChildren = new List<(Guid ChildId, LinkedChildType Type)>(); |
| | | 654 | | |
| | 9 | 655 | | if (video.LocalAlternateVersions.Length > 0) |
| | | 656 | | { |
| | 4 | 657 | | var pathsToResolve = video.LocalAlternateVersions.Where(p => !string.IsNullOrEmpty(p)).ToList(); |
| | 4 | 658 | | if (pathsToResolve.Count > 0) |
| | | 659 | | { |
| | 4 | 660 | | var pathToIdMap = context.BaseItems |
| | 4 | 661 | | .Where(e => e.Path != null && pathsToResolve.Contains(e.Path)) |
| | 4 | 662 | | .Select(e => new { e.Path, e.Id }) |
| | 4 | 663 | | .GroupBy(e => e.Path!) |
| | 4 | 664 | | .ToDictionary(g => g.Key, g => g.First().Id); |
| | | 665 | | |
| | 16 | 666 | | foreach (var path in pathsToResolve) |
| | | 667 | | { |
| | 4 | 668 | | if (pathToIdMap.TryGetValue(path, out var childId)) |
| | | 669 | | { |
| | 4 | 670 | | newLinkedChildren.Add((childId, LinkedChildType.LocalAlternateVersion)); |
| | | 671 | | } |
| | | 672 | | } |
| | | 673 | | } |
| | | 674 | | } |
| | | 675 | | |
| | 9 | 676 | | if (video.LinkedAlternateVersions.Length > 0) |
| | | 677 | | { |
| | 4 | 678 | | foreach (var linkedChild in video.LinkedAlternateVersions) |
| | | 679 | | { |
| | 1 | 680 | | if (linkedChild.ItemId.HasValue && !linkedChild.ItemId.Value.IsEmpty()) |
| | | 681 | | { |
| | 1 | 682 | | newLinkedChildren.Add((linkedChild.ItemId.Value, LinkedChildType.LinkedAlternateVersion)); |
| | | 683 | | } |
| | | 684 | | } |
| | | 685 | | } |
| | | 686 | | |
| | | 687 | | // Deduplicate; local (file-based) relationships take priority over linked (user-merged) |
| | | 688 | | // ones, matching the LinkedChildren migration. |
| | 9 | 689 | | newLinkedChildren = newLinkedChildren |
| | 9 | 690 | | .GroupBy(c => c.ChildId) |
| | 9 | 691 | | .Select(g => g.OrderBy(c => c.Type == LinkedChildType.LocalAlternateVersion ? 0 : 1).First()) |
| | 9 | 692 | | .ToList(); |
| | | 693 | | |
| | 9 | 694 | | var childIdsToCheck = newLinkedChildren.Select(c => c.ChildId).ToList(); |
| | 9 | 695 | | var existingChildIds = childIdsToCheck.Count > 0 |
| | 9 | 696 | | ? context.BaseItems |
| | 9 | 697 | | .Where(e => childIdsToCheck.Contains(e.Id)) |
| | 9 | 698 | | .Select(e => e.Id) |
| | 9 | 699 | | .ToHashSet() |
| | 9 | 700 | | : []; |
| | | 701 | | |
| | 9 | 702 | | var sortOrder = 0; |
| | 28 | 703 | | foreach (var (childId, childType) in newLinkedChildren) |
| | | 704 | | { |
| | 5 | 705 | | if (!existingChildIds.Contains(childId)) |
| | | 706 | | { |
| | 0 | 707 | | _logger.LogWarning( |
| | 0 | 708 | | "Skipping alternate version for video {VideoName} ({VideoId}): child item {ChildId} does not |
| | 0 | 709 | | video.Name, |
| | 0 | 710 | | video.Id, |
| | 0 | 711 | | childId); |
| | 0 | 712 | | continue; |
| | | 713 | | } |
| | | 714 | | |
| | 5 | 715 | | context.LinkedChildren.Add(new LinkedChildEntity |
| | 5 | 716 | | { |
| | 5 | 717 | | ParentId = video.Id, |
| | 5 | 718 | | ChildId = childId, |
| | 5 | 719 | | ChildType = (DbLinkedChildType)childType, |
| | 5 | 720 | | SortOrder = sortOrder |
| | 5 | 721 | | }); |
| | | 722 | | |
| | 5 | 723 | | sortOrder++; |
| | | 724 | | } |
| | | 725 | | |
| | 9 | 726 | | var linkedChildIds = newLinkedChildren |
| | 9 | 727 | | .Select(c => c.ChildId) |
| | 9 | 728 | | // A video listed among its own versions would be pointed at itself. |
| | 9 | 729 | | .Where(childId => existingChildIds.Contains(childId) && !childId.Equals(video.Id)) |
| | 9 | 730 | | .Where(childId => !childId.Equals(video.PrimaryVersionId)) |
| | 9 | 731 | | .ToList(); |
| | 9 | 732 | | if (linkedChildIds.Count > 0) |
| | | 733 | | { |
| | 3 | 734 | | var demotedChildren = context.BaseItems |
| | 3 | 735 | | .Where(e => linkedChildIds.Contains(e.Id) |
| | 3 | 736 | | && (e.PrimaryVersionId == null || e.PrimaryVersionId != video.Id)) |
| | 3 | 737 | | .ToList(); |
| | | 738 | | |
| | 10 | 739 | | foreach (var child in demotedChildren) |
| | | 740 | | { |
| | 2 | 741 | | child.PrimaryVersionId = video.Id; |
| | | 742 | | |
| | | 743 | | // Mirrors Video.CreatePresentationUniqueKey, so presentation-key grouping |
| | | 744 | | // collapses the version onto its primary as well. |
| | 2 | 745 | | child.PresentationUniqueKey = video.Id.ToString("N", CultureInfo.InvariantCulture); |
| | | 746 | | } |
| | | 747 | | |
| | 3 | 748 | | if (demotedChildren.Count > 0) |
| | | 749 | | { |
| | 2 | 750 | | _logger.LogInformation( |
| | 2 | 751 | | "Set PrimaryVersionId on {Count} alternate versions of video {VideoName} ({VideoId})", |
| | 2 | 752 | | demotedChildren.Count, |
| | 2 | 753 | | video.Name, |
| | 2 | 754 | | video.Id); |
| | | 755 | | } |
| | | 756 | | } |
| | | 757 | | |
| | | 758 | | // A previously-linked LocalAlternateVersion that is no longer present becomes orphaned; |
| | 9 | 759 | | var previousLinkedChildren = allLinkedChildrenByParent.GetValueOrDefault(video.Id); |
| | 9 | 760 | | if (previousLinkedChildren is { Count: > 0 }) |
| | | 761 | | { |
| | 0 | 762 | | var newChildIds = newLinkedChildren.Select(c => c.ChildId).ToHashSet(); |
| | 0 | 763 | | var orphanedLocalVersionIds = previousLinkedChildren |
| | 0 | 764 | | .Where(e => e.ChildType == DbLinkedChildType.LocalAlternateVersion && !newChildIds.Contains(e.Ch |
| | 0 | 765 | | .Select(e => e.ChildId) |
| | 0 | 766 | | .ToList(); |
| | | 767 | | |
| | 0 | 768 | | if (orphanedLocalVersionIds.Count > 0) |
| | | 769 | | { |
| | 0 | 770 | | var orphanedItems = context.BaseItems |
| | 0 | 771 | | .Where(e => orphanedLocalVersionIds.Contains(e.Id) && e.OwnerId == video.Id) |
| | 0 | 772 | | .ToList(); |
| | | 773 | | |
| | 0 | 774 | | if (orphanedItems.Count > 0) |
| | | 775 | | { |
| | 0 | 776 | | _logger.LogInformation( |
| | 0 | 777 | | "Deleting {Count} orphaned LocalAlternateVersion items for video {VideoName} ({VideoId}) |
| | 0 | 778 | | orphanedItems.Count, |
| | 0 | 779 | | video.Name, |
| | 0 | 780 | | video.Id); |
| | 0 | 781 | | context.BaseItems.RemoveRange(orphanedItems); |
| | | 782 | | } |
| | | 783 | | } |
| | | 784 | | } |
| | | 785 | | } |
| | | 786 | | } |
| | | 787 | | |
| | 172 | 788 | | context.SaveChanges(); |
| | 172 | 789 | | transaction.Commit(); |
| | 344 | 790 | | } |
| | | 791 | | |
| | | 792 | | private static List<(ItemValueType MagicNumber, string Value)> GetItemValuesToSave(BaseItemDto item, List<string> in |
| | | 793 | | { |
| | 173 | 794 | | var list = new List<(ItemValueType, string)>(); |
| | | 795 | | |
| | 173 | 796 | | if (item is IHasArtist hasArtist) |
| | | 797 | | { |
| | 0 | 798 | | list.AddRange(hasArtist.Artists.Select(i => ((ItemValueType)0, i))); |
| | | 799 | | } |
| | | 800 | | |
| | 173 | 801 | | if (item is IHasAlbumArtist hasAlbumArtist) |
| | | 802 | | { |
| | 0 | 803 | | list.AddRange(hasAlbumArtist.AlbumArtists.Select(i => (ItemValueType.AlbumArtist, i))); |
| | | 804 | | } |
| | | 805 | | |
| | 173 | 806 | | list.AddRange(item.Genres.Select(i => (ItemValueType.Genre, i))); |
| | 173 | 807 | | list.AddRange(item.Studios.Select(i => (ItemValueType.Studios, i))); |
| | 173 | 808 | | list.AddRange(item.Tags.Select(i => (ItemValueType.Tags, i))); |
| | | 809 | | |
| | 173 | 810 | | list.AddRange(inheritedTags.Select(i => (ItemValueType.InheritedTags, i))); |
| | | 811 | | |
| | 173 | 812 | | list.RemoveAll(i => string.IsNullOrWhiteSpace(i.Item2)); |
| | | 813 | | |
| | 173 | 814 | | return list; |
| | | 815 | | } |
| | | 816 | | } |