aboutsummaryrefslogtreecommitdiff
path: root/tests
diff options
context:
space:
mode:
Diffstat (limited to 'tests')
-rw-r--r--tests/Jellyfin.Server.Implementations.Tests/Item/ItemPersistenceOwnedRowTests.cs56
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"));