public void TestMediaItemLoader_SingleMIAs_IdFilter() { MockDBUtils.Reset(); SingleTestMIA single1 = TestBackendUtils.CreateSingleMIA("SINGLE1", Cardinality.Inline, true, false); SingleTestMIA single2 = TestBackendUtils.CreateSingleMIA("SINGLE2", Cardinality.Inline, false, true); Guid itemId = new Guid("aaaaaaaa-1111-1111-1111-aaaaaaaaaaaa"); IList <Guid> ids = new List <Guid>(); ids.Add(itemId); IFilter filter = new MediaItemIdFilter(ids); MockReader reader = MockDBUtils.AddReader( "SELECT T0.MEDIA_ITEM_ID A2, T0.MEDIA_ITEM_ID A3, T1.MEDIA_ITEM_ID A4, T0.ATTR_STRING A0, T1.ATTR_INTEGER A1 FROM M_SINGLE1 T0 INNER JOIN M_SINGLE2 T1 ON T1.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID " + " WHERE T0.MEDIA_ITEM_ID = @V0", "A2", "A3", "A4", "A0", "A1"); reader.AddResult(itemId, itemId, itemId, "zero", 0); Guid[] requiredAspects = new Guid[] { single1.ASPECT_ID, single2.ASPECT_ID }; Guid[] optionalAspects = null; MediaItemQuery query = new MediaItemQuery(requiredAspects, optionalAspects, filter); CompiledMediaItemQuery compiledQuery = CompiledMediaItemQuery.Compile(MockCore.Management, query); MediaItem result = compiledQuery.QueryMediaItem(); Assert.AreEqual(itemId, result.MediaItemId, "MediaItem ID"); // TODO: More asserts }
public void ReadThermalFile() { // Arrage string path = @"D:\ThermalDetection\ThermalDetection\ThermalData\temp223.tof"; // Act IThermalReader thermalFileReader = new MockReader(); ThermalFile thermalFile = thermalFileReader.Read(path); // Assert int imagesCount = thermalFile.images.Count; Assert.AreNotEqual(0, imagesCount); }
public void DoesNotReportLineInfoIfNotSupported() { XmlDocument doc = new XmlDocument(); doc.Load("machine.config"); WrappingXmlReader reader = new MockReader(new XmlNodeReader(doc.DocumentElement)); reader.MoveToContent(); reader.Read(); Assert.AreEqual(0, reader.LineNumber); Assert.AreEqual(0, reader.LinePosition); Assert.AreEqual(false, reader.HasLineInfo()); }
public void DoesNotReportLineInfoIfNotSupported() { XmlDocument doc = new XmlDocument(); doc.Load("machine.config"); WrappingXmlReader reader = new MockReader(new XmlNodeReader(doc.DocumentElement)); reader.MoveToContent(); reader.Read(); Assert.AreEqual(0, reader.LineNumber); Assert.AreEqual(0, reader.LinePosition); Assert.AreEqual(false, reader.HasLineInfo()); }
public void TestMediaItemLoader_MultipleMIAs_IdFilter() { MockDBUtils.Reset(); MultipleTestMIA mia1 = TestBackendUtils.CreateMultipleMIA("MULTIPLE1", Cardinality.Inline, true, false); MultipleTestMIA mia2 = TestBackendUtils.CreateMultipleMIA("MULTIPLE2", Cardinality.Inline, false, true); Guid itemId = new Guid("aaaaaaaa-1111-1111-1111-aaaaaaaaaaaa"); IList <Guid> ids = new List <Guid>(); ids.Add(itemId); IFilter filter = new MediaItemIdFilter(ids); MockReader multipleReader1 = MockDBUtils.AddReader(1, "SELECT T0.MEDIA_ITEM_ID A2, T0.MEDIA_ITEM_ID A3, T0.ATTR_ID A0, T0.ATTR_STRING A1 FROM M_MULTIPLE1 T0 WHERE T0.MEDIA_ITEM_ID = @V0", "A2", "A3", "A0", "A1"); multipleReader1.AddResult(itemId, itemId, "1_1", "oneone"); MockReader multipleReader2 = MockDBUtils.AddReader(2, "SELECT T0.MEDIA_ITEM_ID A2, T0.MEDIA_ITEM_ID A3, T0.ATTR_ID A0, T0.ATTR_INTEGER A1 FROM M_MULTIPLE2 T0 WHERE T0.MEDIA_ITEM_ID = @V0", "A2", "A3", "A0", "A1"); multipleReader2.AddResult(itemId, itemId, "2_1", 21); multipleReader2.AddResult(itemId, itemId, "2_2", 22); MockReader multipleReader3 = MockDBUtils.AddReader(3, "SELECT T0.MEDIA_ITEM_ID A0, T0.MEDIA_ITEM_ID A1, T1.MEDIA_ITEM_ID A2 FROM M_MULTIPLE1 T0 " + "INNER JOIN M_MULTIPLE2 T1 ON T1.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID WHERE T0.MEDIA_ITEM_ID = @V0", "A0"); multipleReader3.AddResult(itemId, itemId, itemId, "1_1", "oneone", "1_1", 11); multipleReader3.AddResult(itemId, itemId, itemId, "2_2", "twotwo", "2_2", 22); Guid[] requiredAspects = new Guid[] { mia1.ASPECT_ID, mia2.ASPECT_ID }; Guid[] optionalAspects = null; MediaItemQuery query = new MediaItemQuery(requiredAspects, optionalAspects, filter); CompiledMediaItemQuery compiledQuery = CompiledMediaItemQuery.Compile(MockCore.Management, query); MediaItem result = compiledQuery.QueryMediaItem(); //Console.WriteLine("Query result " + result.MediaItemId + ": " + string.Join(",", result.Aspects) + ": " + result); IList <MultipleMediaItemAspect> values; Assert.AreEqual(itemId, result.MediaItemId, "MediaItem ID"); Assert.IsTrue(MediaItemAspect.TryGetAspects(result.Aspects, mia1.Metadata, out values), "MIA1"); Assert.AreEqual("oneone", values[0].GetAttributeValue(mia1.ATTR_STRING), "MIA1 string attibute"); Assert.IsTrue(MediaItemAspect.TryGetAspects(result.Aspects, mia2.Metadata, out values), "MIA2"); Assert.AreEqual(21, values[0].GetAttributeValue(mia2.ATTR_INTEGER), "MIA2 integer attibute #0"); Assert.AreEqual(22, values[1].GetAttributeValue(mia2.ATTR_INTEGER), "MIA2 integer attibute #1"); }
public void CheckImagesCountInFile() { // Arrage int quantity = 10; string path = @"D:\ThermalDetection\ThermalDetection\ThermalData\temp223.tof"; IThermalReader thermalFileReader = new MockReader(); int imagecount = 0; // Act for (int i = 0; i < quantity; i++) { ThermalFile thermalFile = thermalFileReader.Read(path); imagecount = thermalFile.images.Count; } // Assert Assert.AreNotEqual(0, imagecount); }
// Use this for initialization void Awake() { Debug.Log("1"); DataModel dataModel = new DataModel("dataOne"); Network networker = new Network(); _context1 = new Context(); _context1.RegisterDependency(dataModel); _context1.RegisterDependencyAs<Network, IReader>(networker); DataModel mockData = new DataModel("this is mock data"); MockReader mockReader = new MockReader(); _context2 = new Context("test"); _context2.RegisterDependency(mockData); _context2.RegisterDependencyAs<MockReader, IReader>(mockReader); Debug.Log("2"); }
// Use this for initialization void Awake() { DataModel dataModel = new DataModel("dataOne"); Network networker = new Network(); new Context(BASE) .RegisterDependency(dataModel); _context1 = new Context() .SetParentContext(BASE) .RegisterDependency(dataModel) .RegisterDependencyAs <Network, IReader>(networker); DataModel mockData = new DataModel("this is mock data"); MockReader mockReader = new MockReader(); _context2 = new Context(TEST) .SetParentContext(BASE) .RegisterDependency(mockData) .RegisterDependencyAs <MockReader, IReader>(mockReader); }
public void TestMediaItemLoader_SingleMIAs_LikeFilter() { MockDBUtils.Reset(); SingleTestMIA mia1 = TestBackendUtils.CreateSingleMIA("SINGLE1", Cardinality.Inline, true, false); SingleTestMIA mia2 = TestBackendUtils.CreateSingleMIA("SINGLE2", Cardinality.Inline, false, true); SingleTestMIA mia3 = TestBackendUtils.CreateSingleMIA("SINGLE3", Cardinality.Inline, true, true); Guid itemId = new Guid("aaaaaaaa-1111-1111-1111-aaaaaaaaaaaa"); IFilter filter = new LikeFilter(mia1.ATTR_STRING, "%", null); MockReader reader = MockDBUtils.AddReader( "SELECT T0.MEDIA_ITEM_ID A4, T0.MEDIA_ITEM_ID A5, T1.MEDIA_ITEM_ID A6, T2.MEDIA_ITEM_ID A7, T0.ATTR_STRING A0, T1.ATTR_INTEGER A1, T2.ATTR_STRING A2, T2.ATTR_INTEGER A3 " + "FROM M_SINGLE1 T0 INNER JOIN M_SINGLE2 T1 ON T1.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID LEFT OUTER JOIN M_SINGLE3 T2 ON T2.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID " + " WHERE T0.ATTR_STRING LIKE @V0", "A4", "A5", "A6", "A7", "A0", "A1", "A2", "A3"); reader.AddResult(itemId, itemId, itemId, itemId, "zerozero", 11, "twotwo", 33); Guid[] requiredAspects = new Guid[] { mia1.ASPECT_ID, mia2.ASPECT_ID }; Guid[] optionalAspects = new Guid[] { mia3.ASPECT_ID }; MediaItemQuery query = new MediaItemQuery(requiredAspects, optionalAspects, filter); CompiledMediaItemQuery compiledQuery = CompiledMediaItemQuery.Compile(MockCore.Management, query); MediaItem result = compiledQuery.QueryMediaItem(); //Console.WriteLine("Query result " + result.MediaItemId + ": " + string.Join(",", result.Aspects) + ": " + result); Assert.AreEqual(itemId, result.MediaItemId, "MediaItem ID"); SingleMediaItemAspect value = null; Assert.IsTrue(MediaItemAspect.TryGetAspect(result.Aspects, mia1.Metadata, out value), "MIA1"); Assert.AreEqual("zerozero", value.GetAttributeValue(mia1.ATTR_STRING), "MIA1 string attibute"); Assert.IsTrue(MediaItemAspect.TryGetAspect(result.Aspects, mia2.Metadata, out value), "MIA2"); Assert.AreEqual(11, value.GetAttributeValue(mia2.ATTR_INTEGER), "MIA2 integer attibute"); Assert.IsTrue(MediaItemAspect.TryGetAspect(result.Aspects, mia3.Metadata, out value), "MIA3"); Assert.AreEqual("twotwo", value.GetAttributeValue(mia3.ATTR_STRING), "MIA3 string attibute"); Assert.AreEqual(33, value.GetAttributeValue(mia3.ATTR_INTEGER), "MIA3 integer attibute"); }
public void TestMediaItemLoader_SingleMIAsUnusedOptional_IdFilter() { MockDBUtils.Reset(); SingleTestMIA single1 = TestBackendUtils.CreateSingleMIA("SINGLE1", Cardinality.Inline, true, false); SingleTestMIA single2 = TestBackendUtils.CreateSingleMIA("SINGLE2", Cardinality.Inline, false, true); SingleTestMIA single3 = TestBackendUtils.CreateSingleMIA("SINGLE3", Cardinality.Inline, false, true); SingleTestMIA single4 = TestBackendUtils.CreateSingleMIA("SINGLE4", Cardinality.Inline, false, true); Guid itemId = new Guid("aaaaaaaa-1111-1111-1111-aaaaaaaaaaaa"); IList <Guid> ids = new List <Guid>(); ids.Add(itemId); IFilter filter = new MediaItemIdFilter(ids); MockReader reader = MockDBUtils.AddReader( "SELECT T0.MEDIA_ITEM_ID A4, T0.MEDIA_ITEM_ID A5, T1.MEDIA_ITEM_ID A6, T2.MEDIA_ITEM_ID A7, T3.MEDIA_ITEM_ID A8, T0.ATTR_STRING A0, T1.ATTR_INTEGER A1, T2.ATTR_INTEGER A2, " + "T3.ATTR_INTEGER A3 FROM M_SINGLE1 T0 INNER JOIN M_SINGLE2 T1 ON T1.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID LEFT OUTER JOIN M_SINGLE3 T2 ON T2.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID " + "LEFT OUTER JOIN M_SINGLE4 T3 ON T3.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID WHERE T0.MEDIA_ITEM_ID = @V0", "A4", "A5", "A6", "A7", "A8", "A0", "A1", "A2", "A3"); reader.AddResult(itemId, itemId, itemId, itemId, null, "zero", 0, 0, null); Guid[] requiredAspects = new Guid[] { single1.ASPECT_ID, single2.ASPECT_ID }; Guid[] optionalAspects = new Guid[] { single3.ASPECT_ID, single4.ASPECT_ID }; MediaItemQuery query = new MediaItemQuery(requiredAspects, optionalAspects, filter); CompiledMediaItemQuery compiledQuery = CompiledMediaItemQuery.Compile(MockCore.Management, query); MediaItem result = compiledQuery.QueryMediaItem(); Assert.AreEqual(itemId, result.MediaItemId, "MediaItem ID"); SingleMediaItemAspect value = null; Assert.IsTrue(MediaItemAspect.TryGetAspect(result.Aspects, single1.Metadata, out value), "MIA1"); Assert.IsTrue(MediaItemAspect.TryGetAspect(result.Aspects, single2.Metadata, out value), "MIA2"); Assert.IsTrue(MediaItemAspect.TryGetAspect(result.Aspects, single3.Metadata, out value), "MIA3"); Assert.IsFalse(MediaItemAspect.TryGetAspect(result.Aspects, single4.Metadata, out value), "MIA4"); }
public void TestReconcileMediaItem() { //TODO: Update below code to work with ML changes return; MockCore.SetupLibrary(true); ServiceRegistration.Set <IPluginManager>(new MockPluginManager()); MockRelationshipExtractor extractor = new MockRelationshipExtractor(); MockMediaAccessor accessor = new MockMediaAccessor(); accessor.AddRelationshipExtractor(extractor); ServiceRegistration.Set <IMediaAccessor>(accessor); ServiceRegistration.Get <IMediaAccessor>().Initialize(); MockCore.Management.AddMediaItemAspectStorage(EpisodeAspect.Metadata); MockCore.Management.AddMediaItemAspectStorage(ExternalIdentifierAspect.Metadata); MockCore.Management.AddMediaItemAspectStorage(ImporterAspect.Metadata); MockCore.Management.AddMediaItemAspectStorage(MediaAspect.Metadata); MockCore.Management.AddMediaItemAspectStorage(ProviderResourceAspect.Metadata); MockCore.Management.AddMediaItemAspectStorage(RelationshipAspect.Metadata); MockCore.Management.AddMediaItemAspectStorage(SeasonAspect.Metadata); MockCore.Management.AddMediaItemAspectStorage(SeriesAspect.Metadata); Guid episodeItemId = new Guid("aaaaaaaa-1111-1111-1111-aaaaaaaaaaaa"); Guid seasonItemId = new Guid("bbbbbbbb-2222-2222-2222-bbbbbbbbbbbb"); Guid seriesItemId = new Guid("cccccccc-3333-3333-3333-cccccccccccc"); string seriesName = "The Series"; string seriesDescription = "The adventures of some characters"; int episode = 1; string episodeName = "The Episode"; string episodeTitle = seriesName + ": " + episodeName; Guid parentDirectoryId = new Guid("dddddddd-4444-4444-4444-dddddddddddd"); int season = 2; string seriesSeasonName = seriesName + " " + season; string seasonDescription = "Continuing adventures of some characters, several story arcs etc"; string externalSource = "TEST"; string externalSeriesId = "345"; MockCore.Library.AddMediaItemId(episodeItemId); MockCore.Library.AddMediaItemId(seasonItemId); MockCore.Library.AddMediaItemId(seriesItemId); string systemId = "local"; string mimeType = "video/mkv"; string pathStr = @"c:\item.mkv"; ResourcePath path = LocalFsResourceProviderBase.ToResourcePath(pathStr); DateTime importDate; DateTime.TryParse("2014-10-11 12:34:56", out importDate); IDictionary <Guid, IList <MediaItemAspect> > episodeAspects = new Dictionary <Guid, IList <MediaItemAspect> >(); MediaItemAspect.SetAttribute(episodeAspects, MediaAspect.ATTR_TITLE, episodeTitle); MediaItemAspect.SetCollectionAttribute(episodeAspects, EpisodeAspect.ATTR_EPISODE, new[] { episode }); MediaItemAspect.SetAttribute(episodeAspects, EpisodeAspect.ATTR_SEASON, season); MultipleMediaItemAspect providerResourceAspect = MediaItemAspect.CreateAspect(episodeAspects, ProviderResourceAspect.Metadata); providerResourceAspect.SetAttribute(ProviderResourceAspect.ATTR_MIME_TYPE, mimeType); MediaItemAspect.AddOrUpdateExternalIdentifier(episodeAspects, externalSource, ExternalIdentifierAspect.TYPE_SERIES, externalSeriesId); ServiceRegistration.Get <ILogger>().Debug("Episode:"); MockCore.ShowMediaAspects(episodeAspects, MockCore.Library.GetManagedMediaItemAspectMetadata()); IDictionary <Guid, IList <MediaItemAspect> > seasonAspects = new Dictionary <Guid, IList <MediaItemAspect> >(); MediaItemAspect.SetAttribute(seasonAspects, SeasonAspect.ATTR_SERIES_NAME, seriesName); MediaItemAspect.SetAttribute(seasonAspects, SeasonAspect.ATTR_SEASON, season); MediaItemAspect.SetAttribute(seasonAspects, SeasonAspect.ATTR_DESCRIPTION, seasonDescription); MediaItemAspect.AddOrUpdateExternalIdentifier(seasonAspects, externalSource, ExternalIdentifierAspect.TYPE_SERIES, externalSeriesId); ServiceRegistration.Get <ILogger>().Debug("Season:"); MockCore.ShowMediaAspects(seasonAspects, MockCore.Library.GetManagedMediaItemAspectMetadata()); Guid[] matchAspects = new[] { SeasonAspect.ASPECT_ID, ExternalIdentifierAspect.ASPECT_ID, MediaAspect.ASPECT_ID }; extractor.AddRelationship(EpisodeAspect.ROLE_EPISODE, new[] { EpisodeAspect.ASPECT_ID }, SeasonAspect.ROLE_SEASON, new[] { SeasonAspect.ASPECT_ID }, matchAspects, externalSource, ExternalIdentifierAspect.TYPE_SERIES, externalSeriesId, new List <IDictionary <Guid, IList <MediaItemAspect> > >() { seasonAspects }, EpisodeSeasonMatcher, episode); IDictionary <Guid, IList <MediaItemAspect> > seriesAspects = new Dictionary <Guid, IList <MediaItemAspect> >(); MediaItemAspect.SetAttribute(seriesAspects, SeasonAspect.ATTR_SERIES_NAME, seriesName); MediaItemAspect.SetAttribute(seriesAspects, SeasonAspect.ATTR_DESCRIPTION, seriesDescription); MediaItemAspect.AddOrUpdateExternalIdentifier(seriesAspects, externalSource, ExternalIdentifierAspect.TYPE_SERIES, externalSeriesId); ServiceRegistration.Get <ILogger>().Debug("Series:"); MockCore.ShowMediaAspects(seriesAspects, MockCore.Library.GetManagedMediaItemAspectMetadata()); matchAspects = new[] { SeriesAspect.ASPECT_ID, ExternalIdentifierAspect.ASPECT_ID, MediaAspect.ASPECT_ID }; extractor.AddRelationship(SeasonAspect.ROLE_SEASON, new[] { SeasonAspect.ASPECT_ID }, SeriesAspect.ROLE_SERIES, new[] { SeriesAspect.ASPECT_ID }, matchAspects, externalSource, ExternalIdentifierAspect.TYPE_SERIES, externalSeriesId, new List <IDictionary <Guid, IList <MediaItemAspect> > >() { seriesAspects }, null, season); MockDBUtils.AddReader(1, "SELECT MEDIA_ITEM_ID FROM M_PROVIDERRESOURCE WHERE SYSTEM_ID = @SYSTEM_ID AND PATH = @PATH", "MEDIA_ITEM_ID"); MockDBUtils.AddReader(2, "SELECT MEDIA_ITEM_ID FROM M_PROVIDERRESOURCE WHERE MEDIA_ITEM_ID = @MEDIA_ITEM_ID", "MEDIA_ITEM_ID"); // Readers used by UpdateRelationships to find episode item MockReader reader2 = MockDBUtils.AddReader(3, "SELECT T6.MEDIA_ITEM_ID A30, T0.MEDIA_ITEM_ID A31, T1.MEDIA_ITEM_ID A32, T2.MEDIA_ITEM_ID A33, T3.MEDIA_ITEM_ID A34, T4.MEDIA_ITEM_ID A35, T5.MEDIA_ITEM_ID A36, " + "T0.SERIESNAME A0, T0.SEASON A1, T0.SERIESSEASONNAME A2, T0.EPISODENAME A3, T0.FIRSTAIRED A4, T0.TOTALRATING A5, T0.RATINGCOUNT A6, " + "T1.LASTIMPORTDATE A7, T1.DIRTY A8, T1.DATEADDED A9, " + "T2.TITLE A10, T2.RECORDINGTIME A11, T2.RATING A12, T2.COMMENT A13, T2.PLAYCOUNT A14, T2.LASTPLAYED A15, " + "T3.SYSTEM_ID A16, T3.MIMETYPE A17, T3.SIZE A18, T3.PATH A19, T3.PARENTDIRECTORY A20, " + "T4.SERIESNAME_0 A21, T4.SEASON_0 A22, T4.SERIESSEASONNAME_0 A23, T4.DESCRIPTION A24, T4.FIRSTAIRED_0 A25, T4.TOTALRATING_0 A26, T4.RATINGCOUNT_0 A27, " + "T5.SERIESNAME_1 A28, T5.DESCRIPTION_0 A29 " + "FROM MEDIA_ITEMS T6 " + "LEFT OUTER JOIN M_EPISODEITEM T0 ON T0.MEDIA_ITEM_ID = T6.MEDIA_ITEM_ID " + "LEFT OUTER JOIN M_IMPORTEDITEM T1 ON T1.MEDIA_ITEM_ID = T6.MEDIA_ITEM_ID " + "LEFT OUTER JOIN M_MEDIAITEM T2 ON T2.MEDIA_ITEM_ID = T6.MEDIA_ITEM_ID " + "LEFT OUTER JOIN M_PROVIDERRESOURCE T3 ON T3.MEDIA_ITEM_ID = T6.MEDIA_ITEM_ID " + "LEFT OUTER JOIN M_SEASONITEM T4 ON T4.MEDIA_ITEM_ID = T6.MEDIA_ITEM_ID " + "LEFT OUTER JOIN M_SERIESITEM T5 ON T5.MEDIA_ITEM_ID = T6.MEDIA_ITEM_ID " + "WHERE T6.MEDIA_ITEM_ID = @V0", CreateAttributeIdList(30, 36)); reader2.AddResult( episodeItemId, episodeItemId, episodeItemId, episodeItemId, episodeItemId, null, null, null, season, null, null, null, null, null, importDate, false, importDate, episodeTitle, null, null, null, null, null, systemId, mimeType, 100, @"c:\", parentDirectoryId, null, null, null, null, null, null, null, null, null ); MockReader reader3 = MockDBUtils.AddReader(4, "SELECT T0.MEDIA_ITEM_ID A0, " + "T1.VALUE A1 " + "FROM NM_EPISODE T0 " + "INNER JOIN V_EPISODE T1 ON T0.VALUE_ID = T1.VALUE_ID " + "WHERE T0.MEDIA_ITEM_ID = @V0", "A0", "A1"); reader3.AddResult( episodeItemId, episode); MockDBUtils.AddReader(5, "SELECT T0.MEDIA_ITEM_ID A0, T1.VALUE A1 FROM NM_DVDEPISODE T0 INNER JOIN V_DVDEPISODE T1 ON T0.VALUE_ID = T1.VALUE_ID WHERE T0.MEDIA_ITEM_ID = @V0", "A0", "A1"); MockReader reader5 = MockDBUtils.AddReader(6, "SELECT T0.MEDIA_ITEM_ID A3, T0.MEDIA_ITEM_ID A4, " + "T0.SOURCE A0, T0.TYPE A1, T0.ID A2 " + "FROM M_EXTERNALIDENTIFIER T0 " + "WHERE T0.MEDIA_ITEM_ID = @V0", CreateAttributeIdList(3, 4)); reader5.AddResult( episodeItemId, episodeItemId, externalSource, ExternalIdentifierAspect.TYPE_SERIES, externalSeriesId); MockDBUtils.AddReader(7, "SELECT T0.MEDIA_ITEM_ID A4, T0.MEDIA_ITEM_ID A5, " + "T0.ROLE A0, T0.LINKEDROLE A1, T0.LINKEDID A2, T0.RELATIONSHIPINDEX A3 " + "FROM M_RELATIONSHIP T0 " + "WHERE T0.MEDIA_ITEM_ID = @V0", CreateAttributeIdList(3, 4)); MockDBUtils.AddReader(8, "SELECT T0.MEDIA_ITEM_ID A4, T0.MEDIA_ITEM_ID A5, T0.ROLE A0, T0.LINKEDROLE A1, T0.LINKEDID A2, T0.RELATIONSHIPINDEX A3 FROM M_RELATIONSHIP T0 WHERE T0.LINKEDID IN (@V0)"); // Readers used by UpdateRelationships to find season item MockDBUtils.AddReader(9, "SELECT T0.MEDIA_ITEM_ID A30, T0.MEDIA_ITEM_ID A31, T1.MEDIA_ITEM_ID A32, T2.MEDIA_ITEM_ID A33, T3.MEDIA_ITEM_ID A34, T4.MEDIA_ITEM_ID A35, T5.MEDIA_ITEM_ID A36, " + "T0.SERIESNAME_0 A0, T0.SEASON_0 A1, T0.SERIESSEASONNAME_0 A2, T0.DESCRIPTION A3, T0.FIRSTAIRED_0 A4, T0.TOTALRATING_0 A5, T0.RATINGCOUNT_0 A6, " + "T1.TITLE A7, T1.RECORDINGTIME A8, T1.RATING A9, T1.COMMENT A10, T1.PLAYCOUNT A11, T1.LASTPLAYED A12, " + "T2.SERIESNAME A13, T2.SEASON A14, T2.SERIESSEASONNAME A15, T2.EPISODENAME A16, T2.FIRSTAIRED A17, T2.TOTALRATING A18, T2.RATINGCOUNT A19, " + "T3.LASTIMPORTDATE A20, T3.DIRTY A21, T3.DATEADDED A22, " + "T4.SYSTEM_ID A23, T4.MIMETYPE A24, T4.SIZE A25, T4.PATH A26, T4.PARENTDIRECTORY A27, " + "T5.SERIESNAME_1 A28, T5.DESCRIPTION_0 A29 " + "FROM M_SEASONITEM T0 " + "INNER JOIN M_MEDIAITEM T1 ON T1.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID " + "LEFT OUTER JOIN M_EPISODEITEM T2 ON T2.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID " + "LEFT OUTER JOIN M_IMPORTEDITEM T3 ON T3.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID " + "LEFT OUTER JOIN M_PROVIDERRESOURCE T4 ON T4.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID " + "LEFT OUTER JOIN M_SERIESITEM T5 ON T5.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID " + "WHERE T0.MEDIA_ITEM_ID IN(SELECT MEDIA_ITEM_ID FROM M_EXTERNALIDENTIFIER WHERE SOURCE = @V0 AND TYPE = @V1 AND ID = @V2)", CreateAttributeIdList(30, 36)); MockDBUtils.AddReader(10, "SELECT MEDIA_ITEM_ID FROM M_PROVIDERRESOURCE WHERE SYSTEM_ID = @SYSTEM_ID AND PATH = @PATH", "MEDIA_ITEM_ID"); MockReader reader10 = MockDBUtils.AddReader(11, "SELECT T6.MEDIA_ITEM_ID A30, T0.MEDIA_ITEM_ID A31, T1.MEDIA_ITEM_ID A32, T2.MEDIA_ITEM_ID A33, T3.MEDIA_ITEM_ID A34, T4.MEDIA_ITEM_ID A35, T5.MEDIA_ITEM_ID A36, " + "T0.SERIESNAME A0, T0.SEASON A1, T0.SERIESSEASONNAME A2, T0.EPISODENAME A3, T0.FIRSTAIRED A4, T0.TOTALRATING A5, T0.RATINGCOUNT A6, " + "T1.LASTIMPORTDATE A7, T1.DIRTY A8, T1.DATEADDED A9, " + "T2.TITLE A10, T2.RECORDINGTIME A11, T2.RATING A12, T2.COMMENT A13, T2.PLAYCOUNT A14, T2.LASTPLAYED A15, " + "T3.SYSTEM_ID A16, T3.MIMETYPE A17, T3.SIZE A18, T3.PATH A19, T3.PARENTDIRECTORY A20, " + "T4.SERIESNAME_0 A21, T4.SEASON_0 A22, T4.SERIESSEASONNAME_0 A23, T4.DESCRIPTION A24, T4.FIRSTAIRED_0 A25, T4.TOTALRATING_0 A26, T4.RATINGCOUNT_0 A27, " + "T5.SERIESNAME_1 A28, T5.DESCRIPTION_0 A29 " + "FROM MEDIA_ITEMS T6 " + "LEFT OUTER JOIN M_EPISODEITEM T0 ON T0.MEDIA_ITEM_ID = T6.MEDIA_ITEM_ID " + "LEFT OUTER JOIN M_IMPORTEDITEM T1 ON T1.MEDIA_ITEM_ID = T6.MEDIA_ITEM_ID " + "LEFT OUTER JOIN M_MEDIAITEM T2 ON T2.MEDIA_ITEM_ID = T6.MEDIA_ITEM_ID " + "LEFT OUTER JOIN M_PROVIDERRESOURCE T3 ON T3.MEDIA_ITEM_ID = T6.MEDIA_ITEM_ID " + "LEFT OUTER JOIN M_SEASONITEM T4 ON T4.MEDIA_ITEM_ID = T6.MEDIA_ITEM_ID " + "LEFT OUTER JOIN M_SERIESITEM T5 ON T5.MEDIA_ITEM_ID = T6.MEDIA_ITEM_ID " + "WHERE T6.MEDIA_ITEM_ID = @V0", CreateAttributeIdList(30, 36)); reader10.AddResult( seasonItemId, null, seasonItemId, seasonItemId, seasonItemId, seasonItemId, null, null, null, null, null, null, null, null, importDate, false, importDate, seriesSeasonName, null, null, null, null, null, null, null, 0, null, Guid.Empty, seriesName, season, seriesSeasonName, seasonDescription, null, null, null, null, null ); MockReader reader11 = MockDBUtils.AddReader(12, "SELECT T0.MEDIA_ITEM_ID A3, T0.MEDIA_ITEM_ID A4, " + "T0.SOURCE A0, T0.TYPE A1, T0.ID A2 " + "FROM M_EXTERNALIDENTIFIER T0 " + "WHERE T0.MEDIA_ITEM_ID = @V0", CreateAttributeIdList(3, 4)); reader11.AddResult( seasonItemId, seasonItemId, externalSource, ExternalIdentifierAspect.TYPE_SERIES, externalSeriesId); MockDBUtils.AddReader(13, "SELECT T0.MEDIA_ITEM_ID A4, T0.MEDIA_ITEM_ID A5, " + "T0.ROLE A0, T0.LINKEDROLE A1, T0.LINKEDID A2, T0.RELATIONSHIPINDEX A3 " + "FROM M_RELATIONSHIP T0 " + "WHERE T0.MEDIA_ITEM_ID = @V0", CreateAttributeIdList(3, 4)); MockDBUtils.AddReader(14, "SELECT T0.MEDIA_ITEM_ID A4, T0.MEDIA_ITEM_ID A5, T0.ROLE A0, T0.LINKEDROLE A1, T0.LINKEDID A2, T0.RELATIONSHIPINDEX A3 FROM M_RELATIONSHIP T0 WHERE T0.LINKEDID IN (@V0)"); MockDBUtils.AddReader(15, "SELECT T0.MEDIA_ITEM_ID A30, T0.MEDIA_ITEM_ID A31, T1.MEDIA_ITEM_ID A32, T2.MEDIA_ITEM_ID A33, T3.MEDIA_ITEM_ID A34, T4.MEDIA_ITEM_ID A35, T5.MEDIA_ITEM_ID A36, " + "T0.SERIESNAME_1 A0, T0.DESCRIPTION_0 A1, " + "T1.TITLE A2, T1.RECORDINGTIME A3, T1.RATING A4, T1.COMMENT A5, T1.PLAYCOUNT A6, T1.LASTPLAYED A7, " + "T2.SERIESNAME A8, T2.SEASON A9, T2.SERIESSEASONNAME A10, T2.EPISODENAME A11, T2.FIRSTAIRED A12, T2.TOTALRATING A13, T2.RATINGCOUNT A14, " + "T3.LASTIMPORTDATE A15, T3.DIRTY A16, T3.DATEADDED A17, " + "T4.SYSTEM_ID A18, T4.MIMETYPE A19, T4.SIZE A20, T4.PATH A21, T4.PARENTDIRECTORY A22, " + "T5.SERIESNAME_0 A23, T5.SEASON_0 A24, T5.SERIESSEASONNAME_0 A25, T5.DESCRIPTION A26, T5.FIRSTAIRED_0 A27, T5.TOTALRATING_0 A28, T5.RATINGCOUNT_0 A29 " + "FROM M_SERIESITEM T0 " + "INNER JOIN M_MEDIAITEM T1 ON T1.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID " + "LEFT OUTER JOIN M_EPISODEITEM T2 ON T2.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID " + "LEFT OUTER JOIN M_IMPORTEDITEM T3 ON T3.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID " + "LEFT OUTER JOIN M_PROVIDERRESOURCE T4 ON T4.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID " + "LEFT OUTER JOIN M_SEASONITEM T5 ON T5.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID " + "WHERE T0.MEDIA_ITEM_ID IN(SELECT MEDIA_ITEM_ID FROM M_EXTERNALIDENTIFIER WHERE SOURCE = @V0 AND TYPE = @V1 AND ID = @V2)", CreateAttributeIdList(30, 36)); MockDBUtils.AddReader(16, "SELECT MEDIA_ITEM_ID FROM M_PROVIDERRESOURCE WHERE SYSTEM_ID = @SYSTEM_ID AND PATH = @PATH", "MEDIA_ITEM_ID"); // Readers used by UpdateRelationships to find series item MockReader reader16 = MockDBUtils.AddReader(17, "SELECT T6.MEDIA_ITEM_ID A30, T0.MEDIA_ITEM_ID A31, T1.MEDIA_ITEM_ID A32, T2.MEDIA_ITEM_ID A33, T3.MEDIA_ITEM_ID A34, T4.MEDIA_ITEM_ID A35, T5.MEDIA_ITEM_ID A36, " + "T0.SERIESNAME A0, T0.SEASON A1, T0.SERIESSEASONNAME A2, T0.EPISODENAME A3, T0.FIRSTAIRED A4, T0.TOTALRATING A5, T0.RATINGCOUNT A6, " + "T1.LASTIMPORTDATE A7, T1.DIRTY A8, T1.DATEADDED A9, " + "T2.TITLE A10, T2.RECORDINGTIME A11, T2.RATING A12, T2.COMMENT A13, T2.PLAYCOUNT A14, T2.LASTPLAYED A15, " + "T3.SYSTEM_ID A16, T3.MIMETYPE A17, T3.SIZE A18, T3.PATH A19, T3.PARENTDIRECTORY A20, " + "T4.SERIESNAME_0 A21, T4.SEASON_0 A22, T4.SERIESSEASONNAME_0 A23, T4.DESCRIPTION A24, T4.FIRSTAIRED_0 A25, T4.TOTALRATING_0 A26, T4.RATINGCOUNT_0 A27, " + "T5.SERIESNAME_1 A28, T5.DESCRIPTION_0 A29 " + "FROM MEDIA_ITEMS T6 " + "LEFT OUTER JOIN M_EPISODEITEM T0 ON T0.MEDIA_ITEM_ID = T6.MEDIA_ITEM_ID " + "LEFT OUTER JOIN M_IMPORTEDITEM T1 ON T1.MEDIA_ITEM_ID = T6.MEDIA_ITEM_ID " + "LEFT OUTER JOIN M_MEDIAITEM T2 ON T2.MEDIA_ITEM_ID = T6.MEDIA_ITEM_ID " + "LEFT OUTER JOIN M_PROVIDERRESOURCE T3 ON T3.MEDIA_ITEM_ID = T6.MEDIA_ITEM_ID " + "LEFT OUTER JOIN M_SEASONITEM T4 ON T4.MEDIA_ITEM_ID = T6.MEDIA_ITEM_ID " + "LEFT OUTER JOIN M_SERIESITEM T5 ON T5.MEDIA_ITEM_ID = T6.MEDIA_ITEM_ID " + "WHERE T6.MEDIA_ITEM_ID = @V0", CreateAttributeIdList(30, 36)); reader16.AddResult( seriesItemId, null, seasonItemId, seasonItemId, seasonItemId, null, seriesItemId, null, null, null, null, null, null, null, importDate, false, importDate, seriesName, null, null, null, null, null, null, null, 0, null, Guid.Empty, null, null, null, null, null, null, null, seriesName, seriesDescription ); MockReader reader17 = MockDBUtils.AddReader(18, "SELECT T0.MEDIA_ITEM_ID A3, T0.MEDIA_ITEM_ID A4, " + "T0.SOURCE A0, T0.TYPE A1, T0.ID A2 " + "FROM M_EXTERNALIDENTIFIER T0 " + "WHERE T0.MEDIA_ITEM_ID = @V0", CreateAttributeIdList(3, 4)); reader17.AddResult( seriesItemId, seriesItemId, externalSource, ExternalIdentifierAspect.TYPE_SERIES, externalSeriesId); MockDBUtils.AddReader(19, "SELECT T0.MEDIA_ITEM_ID A4, T0.MEDIA_ITEM_ID A5, " + "T0.ROLE A0, T0.LINKEDROLE A1, T0.LINKEDID A2, T0.RELATIONSHIPINDEX A3 " + "FROM M_RELATIONSHIP T0 " + "WHERE T0.MEDIA_ITEM_ID = @V0", CreateAttributeIdList(4, 5)); MockDBUtils.AddReader(20, "SELECT T0.MEDIA_ITEM_ID A4, T0.MEDIA_ITEM_ID A5, T0.ROLE A0, T0.LINKEDROLE A1, T0.LINKEDID A2, T0.RELATIONSHIPINDEX A3 FROM M_RELATIONSHIP T0 WHERE T0.LINKEDID IN (@V0)"); MockReader reader20 = MockDBUtils.AddReader(21, "SELECT MEDIA_ITEM_ID " + "FROM M_EXTERNALIDENTIFIER " + "WHERE MEDIA_ITEM_ID = @MEDIA_ITEM_ID AND SOURCE = @SOURCE AND TYPE = @TYPE", "MEDIA_ITEM_ID"); reader20.AddResult( seasonItemId, externalSource, ExternalIdentifierAspect.TYPE_SERIES, externalSeriesId); MockDBUtils.AddReader(22, "SELECT MEDIA_ITEM_ID " + "FROM M_RELATIONSHIP " + "WHERE MEDIA_ITEM_ID = @MEDIA_ITEM_ID AND ROLE = @ROLE AND LINKEDROLE = @LINKEDROLE AND LINKEDID = @LINKEDID", "MEDIA_ITEM_ID"); MockReader reader22 = MockDBUtils.AddReader(23, "SELECT MEDIA_ITEM_ID " + "FROM M_EXTERNALIDENTIFIER " + "WHERE MEDIA_ITEM_ID = @MEDIA_ITEM_ID AND SOURCE = @SOURCE AND TYPE = @TYPE", "MEDIA_ITEM_ID"); reader22.AddResult( seasonItemId, externalSource, ExternalIdentifierAspect.TYPE_SERIES, externalSeriesId); MockDBUtils.AddReader(24, "SELECT MEDIA_ITEM_ID " + "FROM M_RELATIONSHIP " + "WHERE MEDIA_ITEM_ID = @MEDIA_ITEM_ID AND ROLE = @ROLE AND LINKEDROLE = @LINKEDROLE AND LINKEDID = @LINKEDID", "MEDIA_ITEM_ID"); MockCore.Library.AddOrUpdateMediaItem(parentDirectoryId, systemId, path, episodeAspects.Values.SelectMany(x => x), true); MockCore.ShutdownLibrary(); }
public void TestEditBigMediaItem() { MockDBUtils.Reset(); MockCore.SetupLibrary(); SingleTestMIA mia1 = TestCommonUtils.CreateSingleMIA("SINGLE1", Cardinality.Inline, true, true); MockCore.Management.AddMediaItemAspectStorage(mia1.Metadata); MultipleTestMIA mia2 = TestCommonUtils.CreateMultipleMIA("MULTIPLE2", Cardinality.Inline, true, false); MockCore.Management.AddMediaItemAspectStorage(mia2.Metadata); MultipleTestMIA mia3 = TestCommonUtils.CreateMultipleMIA("MULTIPLE3", Cardinality.Inline, false, true); MockCore.Management.AddMediaItemAspectStorage(mia3.Metadata); SingleTestMIA mia4 = TestCommonUtils.CreateSingleMIA("SINGLE4", Cardinality.Inline, true, true); MockCore.Management.AddMediaItemAspectStorage(mia4.Metadata); MockCore.Management.AddMediaItemAspectStorage(ProviderResourceAspect.Metadata); MockCore.Management.AddMediaItemAspectStorage(ImporterAspect.Metadata); MockCore.Management.AddMediaItemAspectStorage(MediaAspect.Metadata); IList <MediaItemAspect> aspects = new List <MediaItemAspect>(); SingleMediaItemAspect aspect1 = new SingleMediaItemAspect(mia1.Metadata); aspect1.SetAttribute(mia1.ATTR_INTEGER, 1); aspect1.SetAttribute(mia1.ATTR_STRING, "one"); aspects.Add(aspect1); MultipleMediaItemAspect aspect2_1 = new MultipleMediaItemAspect(mia2.Metadata); aspect2_1.SetAttribute(mia2.ATTR_ID, "2_1"); aspect2_1.SetAttribute(mia2.ATTR_STRING, "two.one"); aspects.Add(aspect2_1); MultipleMediaItemAspect aspect2_2 = new MultipleMediaItemAspect(mia2.Metadata); aspect2_2.SetAttribute(mia2.ATTR_ID, "2_2"); aspect2_2.SetAttribute(mia2.ATTR_STRING, "two.two"); aspects.Add(aspect2_2); MultipleMediaItemAspect aspect3_1 = new MultipleMediaItemAspect(mia3.Metadata); aspect3_1.SetAttribute(mia3.ATTR_ID, "3_1"); aspect3_1.SetAttribute(mia3.ATTR_INTEGER, 31); aspects.Add(aspect3_1); MultipleMediaItemAspect aspect3_2 = new MultipleMediaItemAspect(mia3.Metadata); aspect3_2.SetAttribute(mia3.ATTR_ID, "3_2"); aspect3_2.SetAttribute(mia3.ATTR_INTEGER, 32); aspects.Add(aspect3_2); MultipleMediaItemAspect aspect3_3 = new MultipleMediaItemAspect(mia3.Metadata); aspect3_3.Deleted = true; aspect3_3.SetAttribute(mia3.ATTR_INTEGER, 33); aspects.Add(aspect3_3); Guid itemId = new Guid("aaaaaaaa-1111-1111-1111-aaaaaaaaaaaa"); MockReader resourceReader = MockDBUtils.AddReader(1, "SELECT MEDIA_ITEM_ID FROM M_PROVIDERRESOURCE WHERE SYSTEM_ID = @SYSTEM_ID AND PATH = @PATH", "MEDIA_ITEM_ID"); resourceReader.AddResult(itemId); DateTime importDate; DateTime.TryParse("2014-10-11 12:34:56", out importDate); MockReader importReader = MockDBUtils.AddReader(2, "SELECT LASTIMPORTDATE A0, DIRTY A1, DATEADDED A2 FROM M_IMPORTEDITEM WHERE MEDIA_ITEM_ID = @MEDIA_ITEM_ID", "A0", "A1", "A2"); importReader.AddResult(importDate, "false", importDate); string pathStr = @"c:\item.mp3"; MockReader mraReader = MockDBUtils.AddReader(3, "SELECT SYSTEM_ID A0, RESOURCEINDEX A1, ISPRIMARY A2, MIMETYPE A3, SIZE A4, PATH A5, PARENTDIRECTORY A6 FROM M_PROVIDERRESOURCE WHERE MEDIA_ITEM_ID = @MEDIA_ITEM_ID", "MEDIA_ITEM_ID"); mraReader.AddResult("00000000-0000-0000-0000-000000000000", 0, true, "audio/mp3", 100, pathStr, Guid.Empty); MockReader mia1Reader = MockDBUtils.AddReader(4, "SELECT MEDIA_ITEM_ID FROM M_SINGLE1 WHERE MEDIA_ITEM_ID = @MEDIA_ITEM_ID", "MEDIA_ITEM_ID"); mia1Reader.AddResult(itemId); MockReader mia2Reader1 = MockDBUtils.AddReader(5, "SELECT MEDIA_ITEM_ID FROM M_MULTIPLE2 WHERE MEDIA_ITEM_ID = @MEDIA_ITEM_ID AND ATTR_ID = @ATTR_ID", "MEDIA_ITEM_ID", "ATTR_ID"); mia2Reader1.AddResult(itemId, "1_1"); MockReader mia2Reader2 = MockDBUtils.AddReader(6, "SELECT MEDIA_ITEM_ID FROM M_MULTIPLE2 WHERE MEDIA_ITEM_ID = @MEDIA_ITEM_ID AND ATTR_ID = @ATTR_ID", "MEDIA_ITEM_ID", "ATTR_ID"); mia2Reader2.AddResult(itemId, "1_1"); MockDBUtils.AddReader(7, "SELECT MEDIA_ITEM_ID FROM M_MULTIPLE2 WHERE MEDIA_ITEM_ID = @MEDIA_ITEM_ID AND ATTR_ID = @ATTR_ID", "MEDIA_ITEM_ID", "ATTR_ID"); MockDBUtils.AddReader(8, "SELECT MEDIA_ITEM_ID FROM M_MULTIPLE2 WHERE MEDIA_ITEM_ID = @MEDIA_ITEM_ID AND ATTR_ID = @ATTR_ID", "MEDIA_ITEM_ID", "ATTR_ID"); MockDBUtils.AddReader(9, "SELECT MEDIA_ITEM_ID FROM M_MULTIPLE3 WHERE MEDIA_ITEM_ID = @MEDIA_ITEM_ID AND ATTR_ID = @ATTR_ID", "MEDIA_ITEM_ID", "ATTR_ID"); MockDBUtils.AddReader(10, "SELECT MEDIA_ITEM_ID FROM M_MULTIPLE3 WHERE MEDIA_ITEM_ID = @MEDIA_ITEM_ID AND ATTR_ID = @ATTR_ID", "MEDIA_ITEM_ID", "ATTR_ID"); MockDBUtils.AddReader(11, "SELECT T7.MEDIA_ITEM_ID A26, T0.MEDIA_ITEM_ID A27, T1.MEDIA_ITEM_ID A28, T2.MEDIA_ITEM_ID A29, T3.MEDIA_ITEM_ID A30, T4.MEDIA_ITEM_ID A31, " + "T5.MEDIA_ITEM_ID A32, T6.MEDIA_ITEM_ID A33, T0.ATTR_STRING A0, T0.ATTR_INTEGER A1, T1.ATTR_ID A2, T1.ATTR_STRING A3, T2.ATTR_ID A4, T2.ATTR_INTEGER A5, T3.ATTR_STRING A6, " + "T3.ATTR_INTEGER A7, T4.SYSTEM_ID A8, T4.RESOURCEINDEX A9, T4.ISPRIMARY A10, T4.MIMETYPE A11, T4.SIZE A12, T4.PATH A13, T4.PARENTDIRECTORY A14, T5.LASTIMPORTDATE A15, T5.DIRTY A16, " + "T5.DATEADDED A17, T6.TITLE A18, T6.SORTTITLE A19, T6.RECORDINGTIME A20, T6.RATING A21, T6.COMMENT A22, T6.PLAYCOUNT A23, T6.LASTPLAYED A24, T6.ISVIRTUAL A25 FROM MEDIA_ITEMS T7 " + "LEFT OUTER JOIN M_SINGLE1 T0 ON T0.MEDIA_ITEM_ID = T7.MEDIA_ITEM_ID LEFT OUTER JOIN M_MULTIPLE2 T1 ON T1.MEDIA_ITEM_ID = T7.MEDIA_ITEM_ID " + "LEFT OUTER JOIN M_MULTIPLE3 T2 ON T2.MEDIA_ITEM_ID = T7.MEDIA_ITEM_ID LEFT OUTER JOIN M_SINGLE4 T3 ON T3.MEDIA_ITEM_ID = T7.MEDIA_ITEM_ID " + "LEFT OUTER JOIN M_PROVIDERRESOURCE T4 ON T4.MEDIA_ITEM_ID = T7.MEDIA_ITEM_ID LEFT OUTER JOIN M_IMPORTEDITEM T5 ON T5.MEDIA_ITEM_ID = T7.MEDIA_ITEM_ID " + "LEFT OUTER JOIN M_MEDIAITEM T6 ON T6.MEDIA_ITEM_ID = T7.MEDIA_ITEM_ID WHERE T7.MEDIA_ITEM_ID = @V0", "V0"); ResourcePath path = LocalFsResourceProviderBase.ToResourcePath(pathStr); MockCore.Library.AddOrUpdateMediaItem(Guid.Empty, null, path, aspects, true); MockCore.ShutdownLibrary(); }
public void TestEditSmallMediaItem() { MockDBUtils.Reset(); MockCore.SetupLibrary(); MultipleTestMIA mia1 = TestCommonUtils.CreateMultipleMIA("MULTIPLE1", Cardinality.Inline, true, false); MockCore.Management.AddMediaItemAspectStorage(mia1.Metadata); MockCore.Management.AddMediaItemAspectStorage(ProviderResourceAspect.Metadata); MockCore.Management.AddMediaItemAspectStorage(ImporterAspect.Metadata); MockCore.Management.AddMediaItemAspectStorage(MediaAspect.Metadata); IList <MediaItemAspect> aspects = new List <MediaItemAspect>(); MultipleMediaItemAspect aspect1_1 = new MultipleMediaItemAspect(mia1.Metadata); aspect1_1.SetAttribute(mia1.ATTR_STRING, "1_1"); aspect1_1.SetAttribute(mia1.ATTR_STRING, "one.three"); aspects.Add(aspect1_1); MultipleMediaItemAspect aspect1_2 = new MultipleMediaItemAspect(mia1.Metadata); aspect1_2.SetAttribute(mia1.ATTR_STRING, "1_2"); aspect1_2.SetAttribute(mia1.ATTR_STRING, "one.two"); aspects.Add(aspect1_2); Guid itemId = new Guid("aaaaaaaa-1111-1111-1111-aaaaaaaaaaaa"); MockReader resourceReader = MockDBUtils.AddReader(1, "SELECT MEDIA_ITEM_ID FROM M_PROVIDERRESOURCE WHERE SYSTEM_ID = @SYSTEM_ID AND PATH = @PATH", "MEDIA_ITEM_ID"); resourceReader.AddResult(itemId); DateTime importDate; DateTime.TryParse("2014-10-11 12:34:56", out importDate); MockReader importReader = MockDBUtils.AddReader(2, "SELECT LASTIMPORTDATE A0, DIRTY A1, DATEADDED A2 FROM M_IMPORTEDITEM WHERE MEDIA_ITEM_ID = @MEDIA_ITEM_ID", "A0", "A1", "A2"); importReader.AddResult(importDate, "false", importDate); string pathStr = @"c:\item.mp3"; MockReader mraReader = MockDBUtils.AddReader(3, "SELECT SYSTEM_ID A0, RESOURCEINDEX A1, ISPRIMARY A2, MIMETYPE A3, SIZE A4, PATH A5, PARENTDIRECTORY A6 FROM M_PROVIDERRESOURCE WHERE MEDIA_ITEM_ID = @MEDIA_ITEM_ID", "MEDIA_ITEM_ID"); mraReader.AddResult(null, 0, true, "audio/mp3", 100, pathStr, Guid.Empty); MockReader mia1Reader1 = MockDBUtils.AddReader(4, "SELECT MEDIA_ITEM_ID FROM M_MULTIPLE1 WHERE MEDIA_ITEM_ID = @MEDIA_ITEM_ID AND ATTR_ID = @ATTR_ID", "MEDIA_ITEM_ID", "ATTR_ID"); mia1Reader1.AddResult(itemId, "1_1"); MockReader mia1Reader2 = MockDBUtils.AddReader(5, "SELECT MEDIA_ITEM_ID FROM M_MULTIPLE1 WHERE MEDIA_ITEM_ID = @MEDIA_ITEM_ID AND ATTR_ID = @ATTR_ID", "MEDIA_ITEM_ID", "ATTR_ID"); mia1Reader2.AddResult(itemId, "1_1"); MockDBUtils.AddReader(6, "SELECT T4.MEDIA_ITEM_ID A20, T0.MEDIA_ITEM_ID A21, T1.MEDIA_ITEM_ID A22, T2.MEDIA_ITEM_ID A23, T3.MEDIA_ITEM_ID A24, T0.ATTR_ID A0, T0.ATTR_STRING A1, T1.SYSTEM_ID A2, " + "T1.RESOURCEINDEX A3, T1.ISPRIMARY A4, T1.MIMETYPE A5, T1.SIZE A6, T1.PATH A7, T1.PARENTDIRECTORY A8, T2.LASTIMPORTDATE A9, T2.DIRTY A10, T2.DATEADDED A11, T3.TITLE A12, T3.SORTTITLE A13, T3.RECORDINGTIME A14, " + "T3.RATING A15, T3.COMMENT A16, T3.PLAYCOUNT A17, T3.LASTPLAYED A18, T3.ISVIRTUAL A19 FROM MEDIA_ITEMS T4 LEFT OUTER JOIN M_MULTIPLE1 T0 ON T0.MEDIA_ITEM_ID = T4.MEDIA_ITEM_ID " + "LEFT OUTER JOIN M_PROVIDERRESOURCE T1 ON T1.MEDIA_ITEM_ID = T4.MEDIA_ITEM_ID LEFT OUTER JOIN M_IMPORTEDITEM T2 ON T2.MEDIA_ITEM_ID = T4.MEDIA_ITEM_ID " + "LEFT OUTER JOIN M_MEDIAITEM T3 ON T3.MEDIA_ITEM_ID = T4.MEDIA_ITEM_ID WHERE T4.MEDIA_ITEM_ID = @V0", "V0"); ResourcePath path = LocalFsResourceProviderBase.ToResourcePath(pathStr); MockCore.Library.AddOrUpdateMediaItem(Guid.Empty, null, path, aspects, true); MockCore.ShutdownLibrary(); }
public void TestMediaItemsLoader_SingleAndMultipleMIAs_BooleanLikeFilter() { MockDBUtils.Reset(); SingleTestMIA mia1 = TestBackendUtils.CreateSingleMIA("SINGLE1", Cardinality.Inline, true, true); MultipleTestMIA mia2 = TestBackendUtils.CreateMultipleMIA("MULTIPLE2", Cardinality.Inline, true, false); MultipleTestMIA mia3 = TestBackendUtils.CreateMultipleMIA("MULTIPLE3", Cardinality.Inline, false, true); Guid itemId0 = new Guid("aaaaaaaa-1111-1111-1111-aaaaaaaaaaaa"); Guid itemId1 = new Guid("bbbbbbbb-2222-2222-2222-bbbbbbbbbbbb"); IFilter filter = new BooleanCombinationFilter(BooleanOperator.And, new List <IFilter> { new LikeFilter(mia1.ATTR_STRING, "%", null), new LikeFilter(mia2.ATTR_STRING, "%", null) }); MockReader reader = MockDBUtils.AddReader(1, "SELECT T0.MEDIA_ITEM_ID A2, T0.MEDIA_ITEM_ID A3, T1.MEDIA_ITEM_ID A4, T0.ATTR_STRING A0, T0.ATTR_INTEGER A1 " + "FROM M_SINGLE1 T0 INNER JOIN M_MULTIPLE2 T1 ON T1.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID " + " WHERE T0.MEDIA_ITEM_ID IN(SELECT MEDIA_ITEM_ID FROM M_MULTIPLE2 WHERE ATTR_STRING LIKE @V0) AND T0.ATTR_STRING LIKE @V1", "A2", "A3", "A4", "A0", "A1"); reader.AddResult(itemId0, itemId0, itemId0, "zero", 0, "0_0"); reader.AddResult(itemId1, itemId1, itemId1, "one", 1, "1_1"); MockReader multipleReader2 = MockDBUtils.AddReader(2, "SELECT T0.MEDIA_ITEM_ID A2, T0.MEDIA_ITEM_ID A3, T0.ATTR_ID A0, T0.ATTR_STRING A1 FROM M_MULTIPLE2 T0 WHERE T0.MEDIA_ITEM_ID IN (@V0, @V1)", "A2", "A3", "A0", "A1"); multipleReader2.AddResult(itemId0, itemId0, "0_0", "zerozero"); multipleReader2.AddResult(itemId0, itemId0, "0_1", "zeroone"); multipleReader2.AddResult(itemId1, itemId1, "1_0", "onezero"); MockReader multipleReader3 = MockDBUtils.AddReader(3, "SELECT T0.MEDIA_ITEM_ID A2, T0.MEDIA_ITEM_ID A3, T0.ATTR_ID A0, T0.ATTR_INTEGER A1 FROM M_MULTIPLE3 T0 WHERE T0.MEDIA_ITEM_ID IN (@V0, @V1)", "A2", "A3", "A0", "A1"); multipleReader3.AddResult(itemId0, itemId0, "1_0", 10); multipleReader3.AddResult(itemId0, itemId0, "1_1", 11); multipleReader3.AddResult(itemId0, itemId0, "1_2", 12); multipleReader3.AddResult(itemId0, itemId0, "1_3", 13); multipleReader3.AddResult(itemId0, itemId0, "1_4", 14); multipleReader3.AddResult(itemId1, itemId1, "1_0", 20); Guid[] requiredAspects = { mia1.ASPECT_ID, mia2.ASPECT_ID }; Guid[] optionalAspects = { mia3.ASPECT_ID }; MediaItemQuery query = new MediaItemQuery(requiredAspects, optionalAspects, filter); CompiledMediaItemQuery compiledQuery = CompiledMediaItemQuery.Compile(MockCore.Management, query); IList <MediaItem> results = compiledQuery.QueryList(); /* * foreach (MediaItem result in results) * //Console.WriteLine("Query result " + result.MediaItemId + ": " + string.Join(",", result.Aspects.Values) + ": " + result); */ SingleMediaItemAspect value; IList <MultipleMediaItemAspect> values; Assert.AreEqual(2, results.Count, "Results count"); Assert.AreEqual(itemId0, results[0].MediaItemId, "MediaItem ID #0"); Assert.IsTrue(MediaItemAspect.TryGetAspect(results[0].Aspects, mia1.Metadata, out value), "MIA1 #0"); Assert.AreEqual("zero", value.GetAttributeValue(mia1.ATTR_STRING), "MIA1 string attibute #0"); Assert.AreEqual(0, value.GetAttributeValue(mia1.ATTR_INTEGER), "MIA1 integer attibute #0"); Assert.IsTrue(MediaItemAspect.TryGetAspects(results[0].Aspects, mia2.Metadata, out values), "MIA2 #0"); Assert.AreEqual(2, values.Count, "MIA2 count #0"); Assert.AreEqual("zerozero", values[0].GetAttributeValue(mia2.ATTR_STRING), "MIA2 string attibute 0 #0"); Assert.AreEqual("zeroone", values[1].GetAttributeValue(mia2.ATTR_STRING), "MIA2 string attibute 1 #0"); Assert.IsTrue(MediaItemAspect.TryGetAspects(results[0].Aspects, mia3.Metadata, out values), "MIA3 #0"); Assert.AreEqual(5, values.Count, "MIA3 count #0"); Assert.AreEqual(10, values[0].GetAttributeValue(mia3.ATTR_INTEGER), "MIA3 integer attibute 0 #0"); Assert.AreEqual(11, values[1].GetAttributeValue(mia3.ATTR_INTEGER), "MIA3 integer attibute 1 #0"); Assert.AreEqual(12, values[2].GetAttributeValue(mia3.ATTR_INTEGER), "MIA3 integer attibute 2 #0"); Assert.AreEqual(13, values[3].GetAttributeValue(mia3.ATTR_INTEGER), "MIA3 integer attibute 3 #0"); Assert.AreEqual(14, values[4].GetAttributeValue(mia3.ATTR_INTEGER), "MIA3 integer attibute 4 #0"); Assert.AreEqual(itemId1, results[1].MediaItemId, "MediaItem ID #1"); Assert.IsTrue(MediaItemAspect.TryGetAspect(results[1].Aspects, mia1.Metadata, out value), "MIA1 #0"); Assert.AreEqual("one", value.GetAttributeValue(mia1.ATTR_STRING), "MIA1 string attibute #1"); Assert.AreEqual(1, value.GetAttributeValue(mia1.ATTR_INTEGER), "MIA1 integer attibute #1"); Assert.IsTrue(MediaItemAspect.TryGetAspects(results[1].Aspects, mia2.Metadata, out values), "MIA2 #1"); Assert.AreEqual(1, values.Count, "MIA2 count #1"); Assert.AreEqual("onezero", values[0].GetAttributeValue(mia2.ATTR_STRING), "MIA2 string attibute 0 #1"); Assert.IsTrue(MediaItemAspect.TryGetAspects(results[1].Aspects, mia3.Metadata, out values), "MIA3 #0"); Assert.AreEqual(1, values.Count, "MIA3 count #1"); Assert.AreEqual(20, values[0].GetAttributeValue(mia3.ATTR_INTEGER), "MIA3 integer attibute 0 #1"); }