diff options
Diffstat (limited to 'tests')
| -rw-r--r-- | tests/Jellyfin.Server.Implementations.Tests/Item/ItemPersistenceOwnedRowTests.cs | 56 |
1 files changed, 56 insertions, 0 deletions
diff --git a/tests/Jellyfin.Server.Implementations.Tests/Item/ItemPersistenceOwnedRowTests.cs b/tests/Jellyfin.Server.Implementations.Tests/Item/ItemPersistenceOwnedRowTests.cs index fea6ccb7a1..d2eb53c393 100644 --- a/tests/Jellyfin.Server.Implementations.Tests/Item/ItemPersistenceOwnedRowTests.cs +++ b/tests/Jellyfin.Server.Implementations.Tests/Item/ItemPersistenceOwnedRowTests.cs @@ -12,6 +12,7 @@ using MediaBrowser.Controller.Entities; using MediaBrowser.Controller.Entities.Movies; using MediaBrowser.Controller.Library; using MediaBrowser.Controller.LiveTv; +using MediaBrowser.Controller.Playlists; using MediaBrowser.Model.Configuration; using MediaBrowser.Model.Entities; using Microsoft.Extensions.Logging.Abstractions; @@ -114,6 +115,61 @@ public sealed class ItemPersistenceOwnedRowTests : SqliteDbTestFixture } [Fact] + public void SaveItems_BatchLargerThanSqliteVariableLimit_Saves() + { + // SQLite caps bound variables at 32766; batch-wide lookups must not bind one per item. + const int Count = 33_000; + var movies = Enumerable.Range(0, Count) + .Select(i => + { + var movie = CreateMovie(Guid.NewGuid()); + movie.Genres = [$"Genre {i}"]; + return movie; + }) + .ToList(); + + _service.SaveItems(movies, CancellationToken.None); + _service.SaveItems(movies, CancellationToken.None); + + using var ctx = CreateDbContext(); + Assert.Equal(Count, ctx.BaseItems.Count(e => e.Type == "MediaBrowser.Controller.Entities.Movies.Movie")); + Assert.Equal(Count, ctx.ItemValuesMap.Count()); + } + + [Fact] + public void SaveItems_PlaylistLinkedByPathBeyondSqliteVariableLimit_Saves() + { + var appHost = new Mock<IServerApplicationHost>(); + appHost.Setup(h => h.ReverseVirtualPath(It.IsAny<string>())).Returns((string p) => p); + var service = new ItemPersistenceService(CreateDbContextFactory(), appHost.Object, NullLogger<ItemPersistenceService>.Instance); + + const int Count = 33_000; + var movies = Enumerable.Range(0, Count) + .Select(i => + { + var movie = CreateMovie(Guid.NewGuid()); + movie.Path = $"/movies/{i}.mkv"; + return movie; + }) + .ToList(); + service.SaveItems(movies, CancellationToken.None); + + // Legacy links carry only a path, so the save resolves every one of them in a single lookup. +#pragma warning disable CS0618 // Type or member is obsolete + var playlist = new Playlist + { + Id = Guid.NewGuid(), + Name = "Everything", + LinkedChildren = movies.Select(m => new LinkedChild { Path = m.Path, Type = MediaBrowser.Controller.Entities.LinkedChildType.Manual }).ToArray() + }; +#pragma warning restore CS0618 + service.SaveItems([playlist], CancellationToken.None); + + using var ctx = CreateDbContext(); + Assert.Equal(Count, ctx.LinkedChildren.Count(e => e.ParentId.Equals(playlist.Id))); + } + + [Fact] public async Task ReattachUserData_DetachedRowsFromDifferentEras_CollapsesToMostRecentPlay() { var movie = CreateMovie(Guid.Parse("dddddddd-dddd-dddd-dddd-dddddddddddd")); |
