public void XMLV3ReadWriteTest() { TVTDatabase initialDatabase = new TVTDatabase(); initialDatabase.Initialize(); var advertising = EntityHelper.GetIconicAdvertising(); initialDatabase.AddAdvertising(advertising); var person = EntityHelper.GetIconicPerson("Wurst", "Hans"); initialDatabase.AddPerson(person); //var programme = EntityHelper.GetIconicProgramme(); //initialDatabase.AddProgramme( programme ); var persister = new XmlPersisterV3(); persister.SaveXML(initialDatabase, "UnitTestXMLV2.xml", DatabaseVersion.V3, DataStructure.FakeData); TVTDatabase loadDatabase = new TVTDatabase(); loadDatabase.Initialize(); persister.LoadXML("UnitTestXMLV2.xml", loadDatabase, DataStructure.FakeData); Assert.AreEqual(1, loadDatabase.GetAllAdvertisings().Count()); var loadAdvertising = loadDatabase.GetAllAdvertisings().First(); AssertAdvertisings(advertising, loadAdvertising, TestMode.XMLV3); Assert.AreEqual(1, loadDatabase.GetAllPeople().Count()); var loadPerson = loadDatabase.GetAllPeople().First(); AssertPeople(person, loadPerson, TestMode.XMLV3, true); //Assert.AreEqual( 1, loadDatabase.GetAllProgrammes().Count() ); //var loadProgrammes = loadDatabase.GetAllProgrammes().First(); //AssertProgrammes( programme, loadProgrammes, TestMode.XMLV3 ); }
//[TestMethod] public void A_ConvertOldToNewData() { var database = new TVTDatabase(); database.Initialize(); using (var connection = TVTSQLSession.GetSession()) { var movies = TVTCommandsV2.LoadMoviesOldV2(connection); OldV2Converter.Convert(movies, database, TVTDataRoot.V2InStorage); TVTCommandsV2.LoadFakesForPeople(connection, database.GetAllPeople()); OldV2Converter.RefreshMovieDescriptions(database); OldV2Converter.FakePersonNames(database); var ads = TVTCommandsV2.LoadAdsOldV2(connection); OldV2Converter.Convert(ads, database, TVTDataRoot.V2InStorage); var news = TVTCommandsV2.LoadNewsOldV2(connection); var tt = news.FirstOrDefault(x => x.title.StartsWith("Programmierer")); OldV2Converter.Convert(news, database, TVTDataRoot.V2InStorage); database.RefreshPersonProgrammeCount(); database.RefreshReferences(); database.RefreshStatus(); } using (var connection = TVTSQLSession.GetSessionNewDB()) { TVTCommandsV3.Insert <TVTPerson>(connection, TVTCommandsV3.GetPersonSQLDefinition(), database.GetAllPeople()); TVTCommandsV3.Insert <TVTProgramme>(connection, TVTCommandsV3.GetProgrammeSQLDefinition(), database.GetAllProgrammes(true, true)); //TVTCommandsV3.Insert<TVTEpisode>( connection, TVTCommandsV3.GetEpisodeSQLDefinition(), database.GetAllEpisodes() ); TVTCommandsV3.Insert <TVTAdvertising>(connection, TVTCommandsV3.GetAdvertisingSQLDefinition(), database.GetAllAdvertisings()); TVTCommandsV3.Insert <TVTNews>(connection, TVTCommandsV3.GetNewsSQLDefinition(), database.GetAllNews()); } }