public void CreateOrUpdateMusicTrackTest() { DataLayerBase target = DataLayerFactory.Instance.GetDataLayer(DataLayerType.SqlServer); string hostName = "Frostmourne"; target.CreateHost(hostName); string filePath = @"c:\Music\chamame.mp3"; string album = "Chamame"; string artist = "Tarrago Ross"; string title = "Curuzu Cuatia"; int year = 1966; string genre = "Folklore"; target.CreateOrUpdateMusicTrack(hostName, filePath, album, artist, title, year, genre); filePath = @"c:\Music\coco.mp3"; album = "Greatest Hits"; artist = "Roxette"; title = "Dangerous"; year = 2004; genre = "Rock"; target.CreateOrUpdateMusicTrack(hostName, filePath, album, artist, title, year, genre); filePath = @"c:\Music\Arjona\pinguinos en la cama.mp3"; album = "Arjona"; artist = "Ricardo Arjona"; title = "Pinguinos en la cama"; year = 2005; genre = "Melódico"; target.CreateOrUpdateMusicTrack(hostName, filePath, album, artist, title, year, genre); DataTable dt = target.Search(album, artist, title, year, genre); Assert.AreEqual(1, dt.Rows.Count, "Music Track creation fail."); if (dt.Rows.Count > 0) { Guid musicTrackId = new Guid(dt.Rows[0][DBConstants.MusicTrackId].ToString()); DataRow dr = target.GetMusicTrack(musicTrackId); if (dr != null) { Assert.AreEqual(artist, dr[DBConstants.Artist].ToString(), "GetMusicTrack fail."); } } }
public void SearchTest() { DataLayerBase target = DataLayerFactory.Instance.GetDataLayer(DataLayerType.SqlServer); DataTable actual; //all fields string album = "Greatest Hits"; string artist = "Roxette"; string title = "Dangerous"; int year = 2004; string genre = "Rock"; actual = target.Search(album, artist, title, year, genre); if (actual != null) { Assert.AreEqual(1, actual.Rows.Count, "Search all field failed."); Assert.AreEqual(@"c:\Music\coco.mp3", actual.Rows[0][DBConstants.Path].ToString(), "Search result path mismatch."); } else { Assert.IsTrue(true, "DataTable from search is null."); } }