public void SupportsValidation_NoDQE()
{
IServerDefaults defaults = CatalogueRepository.GetServerDefaults();
var before = defaults.GetDefaultFor(PermissableDefaults.DQE);
//cannot run test because it didn't have a value to clear!
Assert.IsNotNull(before);
//clear the default value
defaults.ClearDefault(PermissableDefaults.DQE);
try
{
CatalogueConstraintReport report = new CatalogueConstraintReport(_catalogue, SpecialFieldNames.DataLoadRunID);
var e = Assert.Throws <Exception>(() => report.Check(new ThrowImmediatelyCheckNotifier()));
Assert.IsTrue(
e.Message.StartsWith(
"Failed to create DQE Repository, possibly there is no DataQualityEngine Reporting Server (ExternalDatabaseServer). You will need to create/set one in CatalogueManager")
);
}
finally
{
defaults.SetDefault(PermissableDefaults.DQE, before);
}
}
private SqlConnectionStringBuilder CreateServerPointerInCatalogue(IServerDefaults defaults, string prefix, string databaseName, PermissableDefaults defaultToSet, IPatcher patcher)
{
var opts = new PlatformDatabaseCreationOptions()
{
ServerName = TestDatabaseSettings.ServerName,
Prefix = prefix,
Username = TestDatabaseSettings.Username,
Password = TestDatabaseSettings.Password,
ValidateCertificate = false
};
var builder = opts.GetBuilder(databaseName);
if (string.IsNullOrWhiteSpace(databaseName))
{
builder.InitialCatalog = "";
}
//create a new pointer
var externalServerPointer = new ExternalDatabaseServer(CatalogueRepository, databaseName ?? "RAW", patcher)
{
Server = builder.DataSource,
Database = builder.InitialCatalog,
Password = builder.Password,
Username = builder.UserID
};
externalServerPointer.SaveToDatabase();
//now make it the default DQE
defaults.SetDefault(defaultToSet, externalServerPointer);
return(builder);
}
public void SupportsValidation_NoLoggingServer()
{
IServerDefaults defaults = CatalogueRepository.GetServerDefaults();
var before = defaults.GetDefaultFor(PermissableDefaults.LiveLoggingServer_ID);
//cannot run test because it didn't have a value to clear!
Assert.IsNotNull(before);
//clear the default value
defaults.ClearDefault(PermissableDefaults.LiveLoggingServer_ID);
try
{
CatalogueConstraintReport report = new CatalogueConstraintReport(_catalogue, SpecialFieldNames.DataLoadRunID);
var e = Assert.Throws <Exception>(() => report.Check(new ThrowImmediatelyCheckNotifier()));
Assert.IsTrue(
e.Message.StartsWith(
"Failed to setup logging of DQE runs")
);
}
finally
{
defaults.SetDefault(PermissableDefaults.LiveLoggingServer_ID, before);
}
}
private void ddDefault_SelectedIndexChanged(object sender, EventArgs e)
{
PermissableDefaults toChange;
if (sender == ddDefaultIdentifierDump)
{
toChange = PermissableDefaults.IdentifierDumpServer_ID;
}
else
if (sender == ddDefaultLoggingServer)
{
toChange = PermissableDefaults.LiveLoggingServer_ID;
}
else if (sender == ddOverrideRawServer)
{
toChange = PermissableDefaults.RAWDataLoadServer;
}
else if (sender == ddDefaultANOStore)
{
toChange = PermissableDefaults.ANOStore;
}
else if (sender == ddWebServiceQueryCacheServer)
{
toChange = PermissableDefaults.WebServiceQueryCachingServer_ID;
}
else if (sender == ddCohortIdentificationQueryCacheServer)
{
toChange = PermissableDefaults.CohortIdentificationQueryCachingServer_ID;
}
else
{
throw new Exception("Did not recognise sender:" + sender);
}
var selectedItem = ((ComboBox)sender).SelectedItem as ExternalDatabaseServer;
//user selected nothing
if (selectedItem == null)
{
return;
}
defaults.SetDefault(toChange, selectedItem);
}