public void CanDeserializeSerializedConfiguration()
{
OracleConnectionSettings rwSettings = new OracleConnectionSettings();
OracleConnectionData rwOracleConnectionData = new OracleConnectionData();
rwOracleConnectionData.Name = "name0";
rwOracleConnectionData.Packages.Add(new OraclePackageData("package1", "pref1"));
rwOracleConnectionData.Packages.Add(new OraclePackageData("package2", "pref2"));
rwSettings.OracleConnectionsData.Add(rwOracleConnectionData);
rwOracleConnectionData = new OracleConnectionData();
rwOracleConnectionData.Name = "name1";
rwOracleConnectionData.Packages.Add(new OraclePackageData("package3", "pref3"));
rwOracleConnectionData.Packages.Add(new OraclePackageData("package4", "pref4"));
rwSettings.OracleConnectionsData.Add(rwOracleConnectionData);
IDictionary<string, ConfigurationSection> sections = new Dictionary<string, ConfigurationSection>();
sections[OracleConnectionSettings.SectionName] = rwSettings;
IConfigurationSource configurationSource
= ConfigurationTestHelper.SaveSectionsInFileAndReturnConfigurationSource(sections);
OracleConnectionSettings roSettings = (OracleConnectionSettings)configurationSource.GetSection(OracleConnectionSettings.SectionName);
Assert.AreEqual(2, roSettings.OracleConnectionsData.Count);
Assert.AreEqual("name0", roSettings.OracleConnectionsData.Get(0).Name);
Assert.AreEqual(2, roSettings.OracleConnectionsData.Get(0).Packages.Count);
}
public OracleConnectionSettings Build()
{
oracleConnectionSettings = new OracleConnectionSettings();
IList<ConfigurationNode> connections = hierarchy.FindNodesByType(typeof(OracleConnectionElementNode));
for (int index = 0; index < connections.Count; ++index)
{
OracleConnectionData data = new OracleConnectionData();
data.Name = connections[index].Parent.Name;
foreach (OraclePackageElementNode node in connections[index].Nodes)
{
data.Packages.Add(node.OraclePackageElement);
}
oracleConnectionSettings.OracleConnectionsData.Add(data);
}
return oracleConnectionSettings;
}
public void ConfigurationObjectIsNotModifiedIfThereAreNoPolicyOverrides()
{
OracleConnectionData connectionData = new OracleConnectionData();
connectionData.Name = "data1";
connectionData.Packages.Add(new OraclePackageData("package11", "prefix11"));
connectionData.Packages.Add(new OraclePackageData("package12", "prefix12"));
section.OracleConnectionsData.Add(connectionData);
provider.OverrideWithGroupPolicies(section, true, machineKey, userKey);
Assert.AreEqual(2, connectionData.Packages.Count);
Assert.IsNotNull(connectionData.Packages.Get("package11"));
Assert.AreEqual("prefix11", connectionData.Packages.Get("package11").Prefix);
Assert.IsNotNull(connectionData.Packages.Get("package12"));
Assert.AreEqual("prefix12", connectionData.Packages.Get("package12").Prefix);
}
public static DictionaryConfigurationSource CreateConfigurationSource()
{
DictionaryConfigurationSource source = new DictionaryConfigurationSource();
DatabaseSettings settings = new DatabaseSettings();
settings.DefaultDatabase = "Service_Dflt";
OracleConnectionSettings oracleConnectionSettings = new OracleConnectionSettings();
OracleConnectionData data = new OracleConnectionData();
data.Name = "OracleTest";
data.Packages.Add(new OraclePackageData("TESTPACKAGE", "TESTPACKAGETOTRANSLATE"));
oracleConnectionSettings.OracleConnectionsData.Add(data);
source.Add(DatabaseSettings.SectionName, settings);
source.Add(OracleConnectionSettings.SectionName, oracleConnectionSettings);
return source;
}
public static DictionaryConfigurationSource CreateConfigurationSource()
{
DictionaryConfigurationSource source = new DictionaryConfigurationSource();
DatabaseSettings settings = new DatabaseSettings();
settings.DefaultDatabase = "Service_Dflt";
settings.ProviderMappings.Add(new DbProviderMapping("Oracle.ManagedDataAccess.Client", "EntLibContrib.Data.Oracle.ManagedDataAccess.OracleDatabase, EntLibContrib.Data.Oracle.ManagedDataAccess, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null"));
OracleConnectionSettings oracleConnectionSettings = new OracleConnectionSettings();
OracleConnectionData data = new OracleConnectionData();
data.Name = "OracleTest";
data.Packages.Add(new OraclePackageData("TESTPACKAGE", "TESTPACKAGETOTRANSLATE"));
data.Packages.Add(new OraclePackageData("PKGNORTHWIND", "NWND_"));
data.Packages.Add(new OraclePackageData("PKGENTLIB", "RegionSelect"));
oracleConnectionSettings.OracleConnectionsData.Add(data);
source.Add(DatabaseSettings.SectionName, settings);
source.Add(OracleConnectionSettings.SectionName, oracleConnectionSettings);
return source;
}
public void CanGetExtraInformation()
{
ConnectionStringSettings data
= new ConnectionStringSettings(name, "connection string;");
OracleConnectionData oracleConnectionData = new OracleConnectionData();
oracleConnectionData.Name = name;
oracleConnectionData.Packages.Add(new OraclePackageData("package1", "pref1"));
oracleConnectionData.Packages.Add(new OraclePackageData("package2", "pref2"));
OracleConnectionSettings oracleConnectionSettings = new OracleConnectionSettings();
oracleConnectionSettings.OracleConnectionsData.Add(oracleConnectionData);
configurationSource.Add(OracleConnectionSettings.SectionName, oracleConnectionSettings);
OracleDatabase database = (OracleDatabase)assembler.Assemble(data.Name, data, configurationSource);
Assert.IsNotNull(database);
Assert.AreSame(typeof(OracleDatabase), database.GetType());
// can't access the packages - must resort to side effect
DbCommand dBCommand = database.GetStoredProcCommand(OracleTestStoredProcedureInPackageWithTranslation);
Assert.AreEqual((object)OracleTestTranslatedStoredProcedureInPackageWithTranslation, dBCommand.CommandText);
}
private void EnsureOracleConnectionData()
{
if (currentOracleConnectionData != null) return;
currentOracleConnectionData = new OracleConnectionData() { Name = ConnectionString.Name };
currentOracleSettings.OracleConnectionsData.Add(currentOracleConnectionData);
}
public void ManageabilityProviderGeneratesProperAdmContent()
{
DictionaryConfigurationSource configurationSource = new DictionaryConfigurationSource();
OracleConnectionData data1 = new OracleConnectionData();
section.OracleConnectionsData.Add(data1);
data1.Name = "data1";
data1.Packages.Add(new OraclePackageData("name1", "prefix1"));
data1.Packages.Add(new OraclePackageData("name2", "pre;fix2"));
OracleConnectionData data2 = new OracleConnectionData();
section.OracleConnectionsData.Add(data2);
data2.Name = "data2";
MockAdmContentBuilder contentBuilder = new MockAdmContentBuilder();
provider.AddAdministrativeTemplateDirectives(contentBuilder, section, configurationSource, "TestApp");
MockAdmContent content = contentBuilder.GetMockContent();
IEnumerator<AdmCategory> categoriesEnumerator = content.Categories.GetEnumerator();
Assert.IsTrue(categoriesEnumerator.MoveNext());
IEnumerator<AdmCategory> subCategoriesEnumerator = categoriesEnumerator.Current.Categories.GetEnumerator();
Assert.IsTrue(subCategoriesEnumerator.MoveNext());
IEnumerator<AdmPolicy> policiesEnumerator = subCategoriesEnumerator.Current.Policies.GetEnumerator();
Assert.IsTrue(policiesEnumerator.MoveNext());
IEnumerator<AdmPart> oracleDataPartsEnumerator = policiesEnumerator.Current.Parts.GetEnumerator();
Assert.IsTrue(oracleDataPartsEnumerator.MoveNext());
Assert.AreSame(typeof(AdmEditTextPart), oracleDataPartsEnumerator.Current.GetType());
Assert.IsNull(oracleDataPartsEnumerator.Current.KeyName);
Assert.AreEqual(OracleConnectionSettingsManageabilityProvider.PackagesPropertyName,
oracleDataPartsEnumerator.Current.ValueName);
IDictionary<String, String> packages = new Dictionary<String, String>();
KeyValuePairParser.ExtractKeyValueEntries(((AdmEditTextPart)oracleDataPartsEnumerator.Current).DefaultValue, packages);
Assert.AreEqual(2, packages.Count);
Assert.AreEqual("prefix1", packages["name1"]);
Assert.AreEqual("pre;fix2", packages["name2"]);
Assert.IsFalse(oracleDataPartsEnumerator.MoveNext());
Assert.IsTrue(policiesEnumerator.MoveNext());
Assert.IsFalse(policiesEnumerator.MoveNext());
Assert.IsFalse(subCategoriesEnumerator.MoveNext());
IEnumerator<AdmPolicy> sectionPoliciesEnumerator = categoriesEnumerator.Current.Policies.GetEnumerator();
Assert.IsFalse(sectionPoliciesEnumerator.MoveNext());
Assert.IsFalse(categoriesEnumerator.MoveNext());
}
public void OracleConnectionWithDisabledPolicyIsNotRemovedIfGroupPoliciesAreDisabled()
{
OracleConnectionData connectionData1 = new OracleConnectionData();
connectionData1.Name = "data1";
section.OracleConnectionsData.Add(connectionData1);
OracleConnectionData connectionData2 = new OracleConnectionData();
connectionData2.Name = "data2";
section.OracleConnectionsData.Add(connectionData2);
MockRegistryKey machinePackage1Key = new MockRegistryKey(false);
machineKey.AddSubKey("data1", machinePackage1Key);
machinePackage1Key.AddBooleanValue(AdmContentBuilder.AvailableValueName, false);
MockRegistryKey machinePackage2Key = new MockRegistryKey(false);
machineKey.AddSubKey("data2", machinePackage2Key);
machinePackage2Key.AddBooleanValue(AdmContentBuilder.AvailableValueName, true);
machinePackage2Key.AddStringValue(OracleConnectionSettingsManageabilityProvider.PackagesPropertyName,
"package24=prefix24");
provider.OverrideWithGroupPolicies(section, false, machineKey, userKey);
Assert.AreEqual(2, section.OracleConnectionsData.Count);
Assert.IsNotNull(section.OracleConnectionsData.Get("data1"));
Assert.IsNotNull(section.OracleConnectionsData.Get("data2"));
Assert.IsTrue(MockRegistryKey.CheckAllClosed(machinePackage1Key, machinePackage2Key));
}
public void ConfigurationObjectIsNotModifiedIfThereArePolicyOverridesButGroupPoliciesAreDisabled()
{
OracleConnectionData connectionData = new OracleConnectionData();
connectionData.Name = "data1";
connectionData.Packages.Add(new OraclePackageData("package11", "prefix11"));
connectionData.Packages.Add(new OraclePackageData("package12", "prefix12"));
section.OracleConnectionsData.Add(connectionData);
MockRegistryKey machinePackageKey = new MockRegistryKey(false);
machineKey.AddSubKey("data1", machinePackageKey);
machinePackageKey.AddStringValue(OracleConnectionSettingsManageabilityProvider.PackagesPropertyName,
"package13=prefix13; package14=prefix14; package15=prefix15");
provider.OverrideWithGroupPolicies(section, false, machineKey, userKey);
Assert.AreEqual(2, connectionData.Packages.Count);
Assert.IsNotNull(connectionData.Packages.Get("package11"));
Assert.AreEqual("prefix11", connectionData.Packages.Get("package11").Prefix);
Assert.IsNotNull(connectionData.Packages.Get("package12"));
Assert.AreEqual("prefix12", connectionData.Packages.Get("package12").Prefix);
Assert.IsTrue(MockRegistryKey.CheckAllClosed(machinePackageKey));
}
public void MultipleConfigurationObjectsAreModifiedIfThereArePolicyOverrides()
{
OracleConnectionData connection1Data = new OracleConnectionData();
connection1Data.Name = "data1";
connection1Data.Packages.Add(new OraclePackageData("package11", "prefix11"));
connection1Data.Packages.Add(new OraclePackageData("package12", "prefix12"));
section.OracleConnectionsData.Add(connection1Data);
OracleConnectionData connection2Data = new OracleConnectionData();
connection2Data.Name = "data2";
connection2Data.Packages.Add(new OraclePackageData("package21", "prefix21"));
connection2Data.Packages.Add(new OraclePackageData("package22", "prefix22"));
connection2Data.Packages.Add(new OraclePackageData("package23", "prefix23"));
section.OracleConnectionsData.Add(connection2Data);
OracleConnectionData connection3Data = new OracleConnectionData();
connection3Data.Name = "data3";
connection3Data.Packages.Add(new OraclePackageData("package31", "prefix31"));
section.OracleConnectionsData.Add(connection3Data);
MockRegistryKey machinePackage1Key = new MockRegistryKey(false);
machineKey.AddSubKey("data1", machinePackage1Key);
machinePackage1Key.AddStringValue(OracleConnectionSettingsManageabilityProvider.PackagesPropertyName,
"package13=prefix13; package14=prefix14; package15=prefix15");
MockRegistryKey machinePackage2Key = new MockRegistryKey(false);
machineKey.AddSubKey("data2", machinePackage2Key);
machinePackage2Key.AddStringValue(OracleConnectionSettingsManageabilityProvider.PackagesPropertyName,
"package24=prefix24");
provider.OverrideWithGroupPolicies(section, true, machineKey, userKey);
Assert.AreEqual(3, connection1Data.Packages.Count);
Assert.IsNotNull(connection1Data.Packages.Get("package13"));
Assert.AreEqual("prefix13", connection1Data.Packages.Get("package13").Prefix);
Assert.IsNotNull(connection1Data.Packages.Get("package14"));
Assert.AreEqual("prefix14", connection1Data.Packages.Get("package14").Prefix);
Assert.IsNotNull(connection1Data.Packages.Get("package15"));
Assert.AreEqual("prefix15", connection1Data.Packages.Get("package15").Prefix);
Assert.AreEqual(1, connection2Data.Packages.Count);
Assert.IsNotNull(connection2Data.Packages.Get("package24"));
Assert.AreEqual("prefix24", connection2Data.Packages.Get("package24").Prefix);
Assert.AreEqual(1, connection3Data.Packages.Count);
Assert.IsNotNull(connection3Data.Packages.Get("package31"));
Assert.AreEqual("prefix31", connection3Data.Packages.Get("package31").Prefix);
Assert.IsTrue(MockRegistryKey.CheckAllClosed(machinePackage1Key, machinePackage2Key));
}
public void Setup()
{
var configSource = new DictionaryConfigurationSource();
var connectionStrings = new ConnectionStringsSection();
connectionStrings.ConnectionStrings.Add(
new ConnectionStringSettings("someSetting", "someConnectionString", "System.Data.OracleClient"));
configSource.Add("connectionStrings", connectionStrings);
var oracleConnectionData = new OracleConnectionData { Name = "someSetting" };
oracleConnectionData.Packages.Add(new OraclePackageData("foo", "bar"));
var oracleSettings = new OracleConnectionSettings();
oracleSettings.OracleConnectionsData.Add(oracleConnectionData);
configSource.Add(OracleConnectionSettings.SectionName, oracleSettings);
configSettings = new DatabaseSyntheticConfigSettings(configSource);
}
public void Given()
{
// Setup connection strings
configurationSource = new DictionaryConfigurationSource();
var connectionStringsSection = new ConnectionStringsSection();
connectionStringsSection.ConnectionStrings.Add(
new ConnectionStringSettings
{
Name = "myConnectionName",
ConnectionString = "myConnectionString",
ProviderName = "System.Data.OracleClient"
}
);
configurationSource.Add("connectionStrings", connectionStringsSection);
// Setup oracle configuration sections
var oracleConnectionData = new OracleConnectionData { Name = "myConnectionName" };
oracleConnectionData.Packages.Add(new OraclePackageData("foo", "bar"));
var oracleSettings = new OracleConnectionSettings();
oracleSettings.OracleConnectionsData.Add(oracleConnectionData);
configurationSource.Add(OracleConnectionSettings.SectionName, oracleSettings);
settings = new DatabaseSyntheticConfigSettings(configurationSource.GetSection);
}
public void Given()
{
var configurationSource = new DictionaryConfigurationSource();
var oracleConnectionData = new OracleConnectionData { Name = "myConnectionName" };
oracleConnectionData.Packages.Add(new OraclePackageData("foo", "bar"));
var oracleSettings = new OracleConnectionSettings();
oracleSettings.OracleConnectionsData.Add(oracleConnectionData);
configurationSource.Add(OracleConnectionSettings.SectionName, oracleSettings);
var databaseData = new OracleDatabaseData(
new ConnectionStringSettings
{
Name = "myConnectionName",
ConnectionString = "myConnectionString",
ProviderName = "System.Data.Odbc"
},
configurationSource);
registration = databaseData.GetRegistrations().First();
}