public Dictionary <TableInfo, DiscoveredTable> GetIsolationTables()
{
var db = IsolationDatabase.Discover(DataAccessContext.InternalDataProcessing);
return(TablesToIsolate.ToDictionary(
tableInfo => tableInfo,
tableInfo => db.ExpectTable(PrimaryKeyCollisionIsolationMutilation.GetIsolationTableName(tableInfo))
));
}
private void MigrateRecords(ColumnInfo deleteOn, object[] deleteValues)
{
var deleteOnColumnName = GetRAWColumnNameFullyQualified(deleteOn);
using (var con = _raw.Server.GetConnection())
{
con.Open();
//if we are deleting on a child table we need to look up the primary table primary key (e.g. StudyInstanceUID) we should then migrate that data instead (for all tables)
if (!deleteOn.Equals(_primaryTablePk))
{
deleteValues = GetPrimaryKeyValuesFor(deleteOn, deleteValues, con);
deleteOnColumnName = GetRAWColumnNameFullyQualified(_primaryTablePk);
}
//pull all records that we must isolate in all joined tables
Dictionary <TableInfo, DataTable> toPush = TablesToIsolate.ToDictionary(tableInfo => tableInfo, tableInfo => PullTable(tableInfo, con, deleteOnColumnName, deleteValues));
//push the results to isolation
foreach (KeyValuePair <TableInfo, DataTable> kvp in toPush)
{
var toDatabase = IsolationDatabase.Discover(DataAccessContext.DataLoad);
var toTable = toDatabase.ExpectTable(GetIsolationTableName(kvp.Key));
using (var bulkInsert = toTable.BeginBulkInsert())
bulkInsert.Upload(kvp.Value);
}
foreach (TableInfo t in TablesToIsolate.Reverse())
{
DeleteRows(t, deleteOnColumnName, deleteValues, con);
}
con.Close();
}
}