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());
}
}
