public void MigrationTestsTests()
{
//IMPORTANT NOTIFICATION
//Till I figure out a way, please delete the .db file or drop tables clean before running this
//Switch the comments to test one technology or another
var technology = DataManagerTechnology.SQLite;
//var technology = DataManagerTechnology.MySql;
var mysqlconnectionstring = "Data Source=localhost;Database=auroratest;User ID=auroratest;Password=test;";
var sqliteconnectionstring = string.Format("URI=file:{0},version=3", dbFileName);
string connectionString = (technology == DataManagerTechnology.SQLite)?sqliteconnectionstring:mysqlconnectionstring;
CreateEmptyDatabase();
DataSessionProvider sessionProvider = new DataSessionProvider(technology, connectionString);
IDataConnector genericData = ((technology == DataManagerTechnology.SQLite)? (IDataConnector) new SQLiteLoader():new MySQLDataLoader());
genericData.ConnectToDatabase(connectionString);
var migrators = new List <Migrator>();
var testMigrator0 = new TestMigrator();
migrators.Add(testMigrator0);
var migrationManager = new MigrationManager(sessionProvider, genericData, migrators);
Assert.AreEqual(testMigrator0.Version, migrationManager.LatestVersion, "Latest version is correct");
Assert.IsNull(migrationManager.GetDescriptionOfCurrentOperation(), "Description should be null before deciding what to do.");
migrationManager.DetermineOperation();
var operationDescription = migrationManager.GetDescriptionOfCurrentOperation();
Assert.AreEqual(MigrationOperationTypes.CreateDefaultAndUpgradeToTarget, operationDescription.OperationType, "Operation type is correct.");
Assert.AreEqual(testMigrator0.Version, operationDescription.CurrentVersion, "Current version is correct");
//There will be no migration because there is only one migrator which will provide the default
Assert.IsNull(operationDescription.StartVersion, "Start migration version is correct");
Assert.IsNull(operationDescription.EndVersion, "End migration version is correct");
try
{
migrationManager.ExecuteOperation();
Assert.AreEqual(testMigrator0.Version, genericData.GetAuroraVersion(), "Version of settings is updated");
}
catch (MigrationOperationException)
{
Assert.Fail("Something failed during execution we weren't expecting.");
}
bool valid = migrationManager.ValidateVersion(migrationManager.LatestVersion);
Assert.AreEqual(true, valid, "Database is a valid version");
migrationManager.DetermineOperation();
var operationDescription2 = migrationManager.GetDescriptionOfCurrentOperation();
Assert.AreEqual(MigrationOperationTypes.DoNothing, operationDescription2.OperationType, "Operation type is correct.");
Assert.AreEqual(testMigrator0.Version, operationDescription2.CurrentVersion, "Current version is correct");
Assert.IsNull(operationDescription2.StartVersion, "Start migration version is correct");
Assert.IsNull(operationDescription2.EndVersion, "End migration version is correct");
migrationManager.ExecuteOperation();
genericData.CloseDatabase();
}
public override void FinishedMigration(IDataConnector genericData)
{
if (!genericData.TableExists("estates"))
{
return;
}
DataReaderConnection dr = genericData.QueryData("WHERE `Key` = 'EstateID'", "estates", "`ID`, `Key`, `Value`");
if (dr != null)
{
try
{
while (dr.DataReader.Read())
{
try
{
UUID ID = UUID.Parse(dr.DataReader["ID"].ToString());
string value = dr.DataReader["Value"].ToString();
QueryFilter filter = new QueryFilter();
filter.andFilters["`ID`"] = value;
filter.andFilters["`Key`"] = "EstateSettings";
List <string> results = genericData.Query(new string[1] {
"`Value`"
}, "estates", filter, null, null, null);
if ((results != null) && (results.Count >= 1))
{
EstateSettings es = new EstateSettings();
es.FromOSD((OSDMap)OSDParser.DeserializeLLSDXml(results[0]));
genericData.Insert("estateregions", new object[] { ID, value });
filter = new QueryFilter();
filter.andFilters["`EstateID`"] = value;
List <string> exist = genericData.Query(new string[1] {
"`EstateID`"
}, "estatesettings", filter, null, null, null);
if (exist == null || exist.Count == 0)
{
genericData.Insert("estatesettings", new object[] { value, es.EstateName, es.EstateOwner, es.ParentEstateID, es.ToOSD() });
}
}
}
catch
{
}
}
}
catch
{
}
finally
{
dr.DataReader.Close();
genericData.CloseDatabase(dr);
}
}
}
public override void FinishedMigration(IDataConnector genericData)
{
if (!genericData.TableExists("estates")) return;
DataReaderConnection dr = genericData.QueryData("WHERE `Key` = 'EstateID'", "estates", "`ID`, `Key`, `Value`");
if (dr != null)
{
try
{
while (dr.DataReader.Read())
{
try
{
UUID ID = UUID.Parse(dr.DataReader["ID"].ToString());
string value = dr.DataReader["Value"].ToString();
QueryFilter filter = new QueryFilter();
filter.andFilters["`ID`"] = value;
filter.andFilters["`Key`"] = "EstateSettings";
List<string> results = genericData.Query(new string[1] { "`Value`" }, "estates", filter, null, null, null);
if ((results != null) && (results.Count >= 1))
{
EstateSettings es = new EstateSettings();
es.FromOSD((OSDMap)OSDParser.DeserializeLLSDXml(results[0]));
genericData.Insert("estateregions", new object[] { ID, value });
filter = new QueryFilter();
filter.andFilters["`EstateID`"] = value;
List<string> exist = genericData.Query(new string[1] { "`EstateID`" }, "estatesettings", filter, null, null, null);
if (exist == null || exist.Count == 0)
{
genericData.Insert("estatesettings", new object[] { value, es.EstateName, es.EstateOwner, es.ParentEstateID, es.ToOSD() });
}
}
}
catch
{
}
}
}
catch
{
}
finally
{
dr.DataReader.Close();
genericData.CloseDatabase(dr);
}
}
}