SqliteItemRepositoryTests.cs 13 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299
  1. using System;
  2. using System.Collections.Generic;
  3. using AutoFixture;
  4. using AutoFixture.AutoMoq;
  5. using Emby.Server.Implementations.Data;
  6. using MediaBrowser.Controller;
  7. using MediaBrowser.Controller.Entities;
  8. using MediaBrowser.Model.Entities;
  9. using Moq;
  10. using Xunit;
  11. namespace Jellyfin.Server.Implementations.Tests.Data
  12. {
  13. public class SqliteItemRepositoryTests
  14. {
  15. public const string VirtualMetaDataPath = "%MetadataPath%";
  16. public const string MetaDataPath = "/meta/data/path";
  17. private readonly IFixture _fixture;
  18. private readonly SqliteItemRepository _sqliteItemRepository;
  19. public SqliteItemRepositoryTests()
  20. {
  21. var appHost = new Mock<IServerApplicationHost>();
  22. appHost.Setup(x => x.ExpandVirtualPath(It.IsAny<string>()))
  23. .Returns((string x) => x.Replace(VirtualMetaDataPath, MetaDataPath, StringComparison.Ordinal));
  24. appHost.Setup(x => x.ReverseVirtualPath(It.IsAny<string>()))
  25. .Returns((string x) => x.Replace(MetaDataPath, VirtualMetaDataPath, StringComparison.Ordinal));
  26. _fixture = new Fixture().Customize(new AutoMoqCustomization { ConfigureMembers = true });
  27. _fixture.Inject(appHost);
  28. _sqliteItemRepository = _fixture.Create<SqliteItemRepository>();
  29. }
  30. public static IEnumerable<object[]> ItemImageInfoFromValueString_Valid_TestData()
  31. {
  32. yield return new object[]
  33. {
  34. "/mnt/series/Family Guy/Season 1/Family Guy - S01E01-thumb.jpg*637452096478512963*Primary*1920*1080*WjQbtJtSO8nhNZ%L_Io#R/oaS6o}-;adXAoIn7j[%hW9s:WGw[nN",
  35. new ItemImageInfo
  36. {
  37. Path = "/mnt/series/Family Guy/Season 1/Family Guy - S01E01-thumb.jpg",
  38. Type = ImageType.Primary,
  39. DateModified = new DateTime(637452096478512963, DateTimeKind.Utc),
  40. Width = 1920,
  41. Height = 1080,
  42. BlurHash = "WjQbtJtSO8nhNZ%L_Io#R*oaS6o}-;adXAoIn7j[%hW9s:WGw[nN"
  43. }
  44. };
  45. yield return new object[]
  46. {
  47. "https://image.tmdb.org/t/p/original/zhB5CHEgqqh4wnEqDNJLfWXJlcL.jpg*0*Primary*0*0",
  48. new ItemImageInfo
  49. {
  50. Path = "https://image.tmdb.org/t/p/original/zhB5CHEgqqh4wnEqDNJLfWXJlcL.jpg",
  51. Type = ImageType.Primary,
  52. }
  53. };
  54. yield return new object[]
  55. {
  56. "https://image.tmdb.org/t/p/original/zhB5CHEgqqh4wnEqDNJLfWXJlcL.jpg*0*Primary",
  57. new ItemImageInfo
  58. {
  59. Path = "https://image.tmdb.org/t/p/original/zhB5CHEgqqh4wnEqDNJLfWXJlcL.jpg",
  60. Type = ImageType.Primary,
  61. }
  62. };
  63. yield return new object[]
  64. {
  65. "https://image.tmdb.org/t/p/original/zhB5CHEgqqh4wnEqDNJLfWXJlcL.jpg*0*Primary*600",
  66. new ItemImageInfo
  67. {
  68. Path = "https://image.tmdb.org/t/p/original/zhB5CHEgqqh4wnEqDNJLfWXJlcL.jpg",
  69. Type = ImageType.Primary,
  70. }
  71. };
  72. yield return new object[]
  73. {
  74. "%MetadataPath%/library/68/68578562b96c80a7ebd530848801f645/poster.jpg*637264380567586027*Primary*600*336",
  75. new ItemImageInfo
  76. {
  77. Path = "/meta/data/path/library/68/68578562b96c80a7ebd530848801f645/poster.jpg",
  78. Type = ImageType.Primary,
  79. DateModified = new DateTime(637264380567586027, DateTimeKind.Utc),
  80. Width = 600,
  81. Height = 336
  82. }
  83. };
  84. }
  85. [Theory]
  86. [MemberData(nameof(ItemImageInfoFromValueString_Valid_TestData))]
  87. public void ItemImageInfoFromValueString_Valid_Success(string value, ItemImageInfo expected)
  88. {
  89. var result = _sqliteItemRepository.ItemImageInfoFromValueString(value);
  90. Assert.Equal(expected.Path, result.Path);
  91. Assert.Equal(expected.Type, result.Type);
  92. Assert.Equal(expected.DateModified, result.DateModified);
  93. Assert.Equal(expected.Width, result.Width);
  94. Assert.Equal(expected.Height, result.Height);
  95. Assert.Equal(expected.BlurHash, result.BlurHash);
  96. }
  97. [Theory]
  98. [InlineData("")]
  99. [InlineData("*")]
  100. [InlineData("https://image.tmdb.org/t/p/original/zhB5CHEgqqh4wnEqDNJLfWXJlcL.jpg*0")]
  101. public void ItemImageInfoFromValueString_Invalid_Null(string value)
  102. {
  103. Assert.Null(_sqliteItemRepository.ItemImageInfoFromValueString(value));
  104. }
  105. public static IEnumerable<object[]> DeserializeImages_Valid_TestData()
  106. {
  107. yield return new object[]
  108. {
  109. "/mnt/series/Family Guy/Season 1/Family Guy - S01E01-thumb.jpg*637452096478512963*Primary*1920*1080*WjQbtJtSO8nhNZ%L_Io#R/oaS6o}-;adXAoIn7j[%hW9s:WGw[nN",
  110. new ItemImageInfo[]
  111. {
  112. new ItemImageInfo()
  113. {
  114. Path = "/mnt/series/Family Guy/Season 1/Family Guy - S01E01-thumb.jpg",
  115. Type = ImageType.Primary,
  116. DateModified = new DateTime(637452096478512963, DateTimeKind.Utc),
  117. Width = 1920,
  118. Height = 1080,
  119. BlurHash = "WjQbtJtSO8nhNZ%L_Io#R*oaS6o}-;adXAoIn7j[%hW9s:WGw[nN"
  120. }
  121. }
  122. };
  123. yield return new object[]
  124. {
  125. "%MetadataPath%/library/2a/2a27372f1e9bc757b1db99721bbeae1e/poster.jpg*637261226720645297*Primary*0*0|%MetadataPath%/library/2a/2a27372f1e9bc757b1db99721bbeae1e/logo.png*637261226720805297*Logo*0*0|%MetadataPath%/library/2a/2a27372f1e9bc757b1db99721bbeae1e/landscape.jpg*637261226721285297*Thumb*0*0|%MetadataPath%/library/2a/2a27372f1e9bc757b1db99721bbeae1e/backdrop.jpg*637261226721685297*Backdrop*0*0",
  126. new ItemImageInfo[]
  127. {
  128. new ItemImageInfo()
  129. {
  130. Path = "/meta/data/path/library/2a/2a27372f1e9bc757b1db99721bbeae1e/poster.jpg",
  131. Type = ImageType.Primary,
  132. DateModified = new DateTime(637261226720645297, DateTimeKind.Utc),
  133. },
  134. new ItemImageInfo()
  135. {
  136. Path = "/meta/data/path/library/2a/2a27372f1e9bc757b1db99721bbeae1e/logo.png",
  137. Type = ImageType.Logo,
  138. DateModified = new DateTime(637261226720805297, DateTimeKind.Utc),
  139. },
  140. new ItemImageInfo()
  141. {
  142. Path = "/meta/data/path/library/2a/2a27372f1e9bc757b1db99721bbeae1e/landscape.jpg",
  143. Type = ImageType.Thumb,
  144. DateModified = new DateTime(637261226721285297, DateTimeKind.Utc),
  145. },
  146. new ItemImageInfo()
  147. {
  148. Path = "/meta/data/path/library/2a/2a27372f1e9bc757b1db99721bbeae1e/backdrop.jpg",
  149. Type = ImageType.Backdrop,
  150. DateModified = new DateTime(637261226721685297, DateTimeKind.Utc),
  151. }
  152. }
  153. };
  154. }
  155. public static IEnumerable<object[]> DeserializeImages_ValidAndInvalid_TestData()
  156. {
  157. yield return new object[]
  158. {
  159. string.Empty,
  160. Array.Empty<ItemImageInfo>()
  161. };
  162. yield return new object[]
  163. {
  164. "/mnt/series/Family Guy/Season 1/Family Guy - S01E01-thumb.jpg*637452096478512963*Primary*1920*1080*WjQbtJtSO8nhNZ%L_Io#R/oaS6o}-;adXAoIn7j[%hW9s:WGw[nN|test|1234||ss",
  165. new ItemImageInfo[]
  166. {
  167. new ()
  168. {
  169. Path = "/mnt/series/Family Guy/Season 1/Family Guy - S01E01-thumb.jpg",
  170. Type = ImageType.Primary,
  171. DateModified = new DateTime(637452096478512963, DateTimeKind.Utc),
  172. Width = 1920,
  173. Height = 1080,
  174. BlurHash = "WjQbtJtSO8nhNZ%L_Io#R*oaS6o}-;adXAoIn7j[%hW9s:WGw[nN"
  175. }
  176. }
  177. };
  178. yield return new object[]
  179. {
  180. "|",
  181. Array.Empty<ItemImageInfo>()
  182. };
  183. }
  184. [Theory]
  185. [MemberData(nameof(DeserializeImages_Valid_TestData))]
  186. public void DeserializeImages_Valid_Success(string value, ItemImageInfo[] expected)
  187. {
  188. var result = _sqliteItemRepository.DeserializeImages(value);
  189. Assert.Equal(expected.Length, result.Length);
  190. for (int i = 0; i < expected.Length; i++)
  191. {
  192. Assert.Equal(expected[i].Path, result[i].Path);
  193. Assert.Equal(expected[i].Type, result[i].Type);
  194. Assert.Equal(expected[i].DateModified, result[i].DateModified);
  195. Assert.Equal(expected[i].Width, result[i].Width);
  196. Assert.Equal(expected[i].Height, result[i].Height);
  197. Assert.Equal(expected[i].BlurHash, result[i].BlurHash);
  198. }
  199. }
  200. [Theory]
  201. [MemberData(nameof(DeserializeImages_ValidAndInvalid_TestData))]
  202. public void DeserializeImages_ValidAndInvalid_Success(string value, ItemImageInfo[] expected)
  203. {
  204. var result = _sqliteItemRepository.DeserializeImages(value);
  205. Assert.Equal(expected.Length, result.Length);
  206. for (int i = 0; i < expected.Length; i++)
  207. {
  208. Assert.Equal(expected[i].Path, result[i].Path);
  209. Assert.Equal(expected[i].Type, result[i].Type);
  210. Assert.Equal(expected[i].DateModified, result[i].DateModified);
  211. Assert.Equal(expected[i].Width, result[i].Width);
  212. Assert.Equal(expected[i].Height, result[i].Height);
  213. Assert.Equal(expected[i].BlurHash, result[i].BlurHash);
  214. }
  215. }
  216. [Theory]
  217. [MemberData(nameof(DeserializeImages_Valid_TestData))]
  218. public void SerializeImages_Valid_Success(string expected, ItemImageInfo[] value)
  219. {
  220. Assert.Equal(expected, _sqliteItemRepository.SerializeImages(value));
  221. }
  222. public static IEnumerable<object[]> DeserializeProviderIds_Valid_TestData()
  223. {
  224. yield return new object[]
  225. {
  226. "Imdb=tt0119567",
  227. new Dictionary<string, string>()
  228. {
  229. { "Imdb", "tt0119567" },
  230. }
  231. };
  232. yield return new object[]
  233. {
  234. "Imdb=tt0119567|Tmdb=330|TmdbCollection=328",
  235. new Dictionary<string, string>()
  236. {
  237. { "Imdb", "tt0119567" },
  238. { "Tmdb", "330" },
  239. { "TmdbCollection", "328" },
  240. }
  241. };
  242. yield return new object[]
  243. {
  244. "MusicBrainzAlbum=9d363e43-f24f-4b39-bc5a-7ef305c677c7|MusicBrainzReleaseGroup=63eba062-847c-3b73-8b0f-6baf27bba6fa|AudioDbArtist=111352|AudioDbAlbum=2116560|MusicBrainzAlbumArtist=20244d07-534f-4eff-b4d4-930878889970",
  245. new Dictionary<string, string>()
  246. {
  247. { "MusicBrainzAlbum", "9d363e43-f24f-4b39-bc5a-7ef305c677c7" },
  248. { "MusicBrainzReleaseGroup", "63eba062-847c-3b73-8b0f-6baf27bba6fa" },
  249. { "AudioDbArtist", "111352" },
  250. { "AudioDbAlbum", "2116560" },
  251. { "MusicBrainzAlbumArtist", "20244d07-534f-4eff-b4d4-930878889970" },
  252. }
  253. };
  254. }
  255. [Theory]
  256. [MemberData(nameof(DeserializeProviderIds_Valid_TestData))]
  257. public void DeserializeProviderIds_Valid_Success(string value, Dictionary<string, string> expected)
  258. {
  259. var result = new ProviderIdsExtensionsTestsObject();
  260. SqliteItemRepository.DeserializeProviderIds(value, result);
  261. Assert.Equal(expected, result.ProviderIds);
  262. }
  263. [Theory]
  264. [MemberData(nameof(DeserializeProviderIds_Valid_TestData))]
  265. public void SerializeProviderIds_Valid_Success(string expected, Dictionary<string, string> values)
  266. {
  267. Assert.Equal(expected, SqliteItemRepository.SerializeProviderIds(values));
  268. }
  269. private class ProviderIdsExtensionsTestsObject : IHasProviderIds
  270. {
  271. public Dictionary<string, string> ProviderIds { get; set; } = new Dictionary<string, string>();
  272. }
  273. }
  274. }