public void ClearRestorePoint(IDataConnector genericData)
{
foreach (var s in Schema)
{
DeleteTempVersion(genericData, s.Name);
}
}
public bool Validate(IDataConnector genericData)
{
if (genericData.GetUniverseVersion (MigrationName) != Version)
return false;
return DoValidate(genericData);
}
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);
dr.Dispose ();
}
}
}
public bool Validate(DataSessionProvider sessionProvider, IDataConnector genericData)
{
if (genericData.GetAuroraVersion() != Version)
{
return false;
}
return DoValidate(sessionProvider, genericData);
}
public bool Validate(IDataConnector genericData)
{
if (genericData.GetAuroraVersion(MigrationName) != Version)
{
return false;
}
return DoValidate(genericData);
}
public static void SetConnector(IDataConnector connector, bool throwWhenSet = true)
{
lock (_sync)
{
if (_connector != null && throwWhenSet)
{
throw new InvalidOperationException(String.Format("Attempted to load '{0}' when a '{1}' was already loaded", connector.ToString(), _connector.ToString()));
}
_connector = connector;
}
}
public override void Load(IDataConnector conn)
{
using (var sb = new SQLiteQueryBuilder(Plugin.SQLSafeName))
{
sb.SelectAll(TableDefinition.TableName);
_data = conn.ExecuteArray<UserPermisison>(sb);
}
ProgramLog.Error.Log(this.GetType().Name + ": " + (_data == null ? "NULL" : _data.Length.ToString()));
}
public MigrationManager(IDataConnector genericData, string migratorName, bool validateTables)
{
this.genericData = genericData;
this.migratorName = migratorName;
this.validateTables = validateTables;
List<IMigrator> allMigrators = UniverseModuleLoader.PickupModules<IMigrator>();
foreach (
IMigrator m in allMigrators.Where(m => m.MigrationName != null).Where(m => m.MigrationName == migratorName))
{
migrators.Add((Migrator) m);
}
}
public MigrationManager(DataSessionProvider sessionProvider, IDataConnector genericData)
{
this.sessionProvider = sessionProvider;
this.genericData = genericData;
migrators.Add(new AuroraMigrator_2010_03_13());
migrators.Add(new AuroraMigrator_2010_11_4());
migrators.Add(new AuroraMigrator_2010_12_30());
migrators.Add(new AuroraMigrator_2011_1_15());
migrators.Add(new AuroraMigrator_2011_1_16());
migrators.Add(new AuroraMigrator_2011_1_20());
migrators.Add(new AuroraMigrator_2011_1_28());
migrators.Add(new AuroraMigrator_2011_2_1());
}
public BulkLoaderForm(MonetDbConnectionInfo monetDbConnectionInfo)
{
InitializeComponent();
_connectionInfo = monetDbConnectionInfo;
_worker = new BackgroundWorker
{
WorkerReportsProgress = true,
WorkerSupportsCancellation = true
};
_dataConnector = DataConnectorFactoryHelper.GetDataFactory(DataSourceType.SqlServer);
}
public MigrationManager(IDataConnector genericData, string migratorName, bool validateTables)
{
this.genericData = genericData;
this.migratorName = migratorName;
this.validateTables = validateTables;
List<IMigrator> allMigrators = Aurora.Framework.AuroraModuleLoader.PickupModules<IMigrator>();
foreach (IMigrator m in allMigrators)
{
if (m.MigrationName == null)
continue;
if (m.MigrationName == migratorName)
migrators.Add((Migrator)m);
}
}
/// <summary>
/// Constructor of the class
/// </summary>
/// <param name="taskModel"></param>
/// <param name="targetList"></param>
/// <param name="dataConnector"></param>
/// <param name="mainPage"></param>
/// <param name="state"></param>
public DefaultTaskViewModel(ITaskModel taskModel, ObservableCollection<ITaskViewModel> targetList, IDataConnector dataConnector, MainPage mainPage, TaskState state)
{
TaskModel = taskModel;
_targetList = targetList;
_dataConnector = dataConnector;
ItemVisualWidth = mainPage.ActualWidth;
// Commands
Break = new ViewModelCommand()
{
Command = new RelayCommand(r => BreakTask()),
Text = "Break"
};
PunchOut = new ViewModelCommand
{
Command = new RelayCommand(r => FinishTask()),
Text = "Finished",
ImagePath = @"Images/finish.png"
};
DeleteFromList = new ViewModelCommand
{
Command = new RelayCommand(
r =>
{
if (targetList != null && targetList.Contains(this))
{
targetList.Remove(this);
_dataConnector.DeleteTask(taskModel.Id);
}
}),
Text = "Delete",
ImagePath = "Images/delete.png"
};
// Timer Init
_timer = new DispatcherTimer();
_timer.Tick += timer_Tick;
_timer.Interval = TimeSpan.FromSeconds(1);
_timer.Start();
// Setstate
State = state;
_initLoad = false;
}
public MigrationManager(IDataConnector genericData, string migratorName, bool validateTables)
{
this.genericData = genericData;
this.migratorName = migratorName;
this.validateTables = validateTables;
List<IMigrator> allMigrators = AuroraModuleLoader.PickupModules<IMigrator>();
#if (!ISWIN)
foreach (IMigrator m in allMigrators)
{
if (m.MigrationName != null)
{
if (m.MigrationName == migratorName)
{
migrators.Add((Migrator)m);
}
}
}
#else
foreach (IMigrator m in allMigrators.Where(m => m.MigrationName != null).Where(m => m.MigrationName == migratorName))
{
migrators.Add((Migrator) m);
}
#endif
}
protected override void DoCreateDefaults(IDataConnector genericData)
{
EnsureAllTablesInSchemaExist(genericData);
}
protected bool TestThatAllTablesValidate(IDataConnector genericData)
{
foreach (var s in schema)
{
if (!genericData.VerifyTableExists(s.X1, s.X2))
{
return false;
}
}
return true;
}
protected virtual void DoCreateDefaults(DataSessionProvider sessionProvider, IDataConnector genericData)
{
}
protected virtual void DoPrepareRestorePoint(IDataConnector genericData)
{
}
protected bool TestThatAllTablesValidate(IDataConnector genericData)
{
return(schema.All(s => genericData.VerifyTableExists(s.Name, s.Columns, s.Indices)));
}
private void CopyTableToTempVersion(IDataConnector genericData, string tablename,
ColumnDefinition[] columnDefinitions, IndexDefinition[] indexDefinitions)
{
genericData.CopyTableToTable(tablename, GetTempTableNameFromTableName(tablename), columnDefinitions,
indexDefinitions);
}
public virtual void FinishedMigration(IDataConnector genericData)
{
}
public override void FinishedMigration(IDataConnector genericData)
{
genericData.DropTable("macban");
genericData.DropTable("bannedviewers");
}
public abstract void Save(IDataConnector conn);
public override void FinishedMigration(IDataConnector genericData)
{
genericData.Delete("baninfo", null);
}
public abstract void Load(IDataConnector conn);
protected virtual void DoMigrate(IDataConnector genericData)
{
}
public void Migrate(IDataConnector genericData)
{
DoMigrate(genericData);
genericData.WriteWhiteCoreVersion(Version, MigrationName);
}
protected override void DoMigrate(IDataConnector genericData)
{
DoCreateDefaults(genericData);
}
protected virtual bool DoValidate(IDataConnector genericData)
{
return(true);
}
public virtual void DoRestore(IDataConnector genericData)
{
RestoreTempTablesToReal(genericData);
}
private void RestoreTempTableToReal(IDataConnector genericData, string tablename, ColumnDefinition[] columnDefinitions)
{
genericData.CopyTableToTable(GetTempTableNameFromTableName(GetTempTableNameFromTableName(tablename)), tablename, columnDefinitions);
}
private void RestoreTempTableToReal(IDataConnector genericData, string tablename,
ColumnDefinition[] columnDefinitions, IndexDefinition[] indexDefinitions)
{
genericData.CopyTableToTable(GetTempTableNameFromTableName(GetTempTableNameFromTableName(tablename)),
tablename, columnDefinitions, indexDefinitions);
}
public virtual void DoRestore(DataSessionProvider sessionProvider, IDataConnector genericData)
{
}
public ExcelImporter(IDataConnector dataConnector)
{
_dataConnector = dataConnector;
}
protected virtual void DoCreateDefaults(IDataConnector genericData)
{
}
public HddMetricsRepository(IDataConnector connector)
{
_connector = connector;
}
public IRestorePoint PrepareRestorePoint(IDataConnector genericData)
{
DoPrepareRestorePoint(genericData);
return(this);
}
protected override void DoCreateDefaults(DataSessionProvider sessionProvider, IDataConnector genericData)
{
EnsureAllTablesInSchemaExist(genericData);
}
protected virtual bool DoValidate(DataSessionProvider sessionProvider, IDataConnector genericData)
{
return true;
}
public override void Save(IDataConnector conn)
{
throw new NotImplementedException();
}
protected virtual void DoPrepareRestorePoint(DataSessionProvider sessionProvider, IDataConnector genericData)
{
}
private void DeleteTempVersion(IDataConnector genericData, string tableName)
{
string tempTableName = GetTempTableNameFromTableName(tableName);
if (genericData.TableExists(tempTableName))
{
genericData.DropTable(tempTableName);
}
}
protected virtual void DoMigrate(DataSessionProvider sessionProvider, IDataConnector genericData)
{
}
protected override bool DoValidate(DataSessionProvider sessionProvider, IDataConnector genericData)
{
return(TestThatAllTablesValidate(genericData));
}
public void CreateDefaults(IDataConnector genericData)
{
DoCreateDefaults(genericData);
genericData.WriteWhiteCoreVersion(Version, MigrationName);
}
public IRestorePoint PrepareRestorePoint(DataSessionProvider sessionProvider, IDataConnector genericData)
{
DoPrepareRestorePoint(sessionProvider, genericData);
return this;
}
protected override void DoMigrate(DataSessionProvider sessionProvider, IDataConnector genericData)
{
DoCreateDefaults(sessionProvider, genericData);
}
public void Migrate(DataSessionProvider sessionProvider, IDataConnector genericData)
{
DoMigrate(sessionProvider, genericData);
genericData.WriteAuroraVersion(Version);
}
public override void DoRestore(DataSessionProvider sessionProvider, IDataConnector genericData)
{
RestoreTempTablesToReal(genericData);
}
public void CreateDefaults(DataSessionProvider sessionProvider, IDataConnector genericData)
{
DoCreateDefaults(sessionProvider, genericData);
genericData.WriteAuroraVersion(Version);
}
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);
}
}
}
protected void EnsureAllTablesInSchemaExist(IDataConnector genericData)
{
foreach (var s in schema)
{
genericData.EnsureTableExists(s.X1, s.X2);
}
}
protected override void DoCreateDefaults(IDataConnector genericData)
{
EnsureAllTablesInSchemaExist(genericData);
}
public override void Save(IDataConnector conn)
{
throw new NotImplementedException();
}
protected override bool DoValidate(IDataConnector genericData)
{
return(TestThatAllTablesValidate(genericData));
}
protected override bool DoValidate(IDataConnector genericData)
{
return TestThatAllTablesValidate(genericData);
}
protected override void DoMigrate(IDataConnector genericData)
{
DoCreateDefaults(genericData);
}
protected override void DoPrepareRestorePoint(IDataConnector genericData)
{
CopyAllTablesToTempVersions(genericData);
}
protected override void DoPrepareRestorePoint(IDataConnector genericData)
{
CopyAllTablesToTempVersions(genericData);
}
