public async Task SqlDatabase_Test()
{
var locator = new DatabaseLocator(); // {ServiceDomain = "kmb.home"};
Console.WriteLine("Testing in {0}", locator.ServiceDomain);
DatabaseService svc = await locator.Locate("fluf-workflow-db", DatabaseProtocol.Sql);
Assert.IsNotNull(svc);
string[] connArray = svc.ConnectionStrings.ToArray();
Assert.IsTrue(connArray.Length == 1);
foreach (string s in connArray)
{
Console.WriteLine(s);
}
Assert.AreEqual(
"Server=tcp:vrdworkflow01.rnd.ipzo.net,1433;Database=WorkflowConfig;User ID=fluf_app;Password=Password1!;",
//"Server=tcp:dilbert7.kmb.home,1433;Database=Onumbers;Integrated Security=SSPI;",
//"Server=tcp:vrdlfadb01.rnd.ipzo.net,1433;Database=Onumbers;User ID=sa;Password=C4bb4g5;Applicaiton Name=kellyb;",
connArray[0]
);
}
// This method gets called by the runtime. Use this method to add services to the container.
public void ConfigureServices(IServiceCollection services)
{
services.ConfigureWritable <AppSettings>(Configuration.GetSection("AppSettings"), environmentInitializationProvider.GetAppSettingsFileName());
services.Configure <IISOptions>(options => {
options.AutomaticAuthentication = true;
});
AppSettings appSettings = Configuration.GetSection("AppSettings").Get <AppSettings>();
databaseLocator = new DatabaseLocator(appSettings);
if (databaseLocator.ConfigurationRepositoryExists())
{
initialSetupComplete = true;
InitializeApp(services, appSettings);
}
else
{
initialSetupComplete = false;
InitializeSetup(services);
}
ConfigureAuthentication(services);
// Add framework services.
services.AddMvc().AddJsonOptions(options =>
{
options.SerializerSettings.Converters.Add(new Newtonsoft.Json.Converters.StringEnumConverter());
options.SerializerSettings.NullValueHandling = Newtonsoft.Json.NullValueHandling.Ignore;
});
}
public void DatabaseLocator_GetAuditRepositoryConnectionString_ReturnsExpectedResult()
{
AppSettings appSettings = GetAppSettings();
DatabaseLocator databaseLocator = new DatabaseLocator(appSettings);
string auditPathActual = databaseLocator.GetAuditRepositoryConnectionString();
Assert.AreEqual(auditPathExpected, auditPathActual);
}
public ActionResult SetInitialConfig(InitialSetupConfigModel config)
{
appSettings.Update(setting => setting.DatastoreRootPath = config.DatastoreRootPath);
DatabaseLocator dbLocator = new DatabaseLocator(config.DatastoreRootPath);
LiteDbConfigurationRepository configurationRepository = new LiteDbConfigurationRepository(dbLocator.GetConfigurationRepositoryConnectionString());
InitialSetupLogic initialSetupLogic = new InitialSetupLogic(configurationRepository);
initialSetupLogic.Complete(config);
return(RedirectToAction("Complete", "InitialSetup"));
}
public async Task RedisDb_Test()
{
var locator = new DatabaseLocator(); // {ServiceDomain = "kmb.home"};
Console.WriteLine("Testing in {0}", locator.ServiceDomain);
DatabaseService svc = await locator.Locate("dark-rnd", DatabaseProtocol.Redis);
Assert.IsNotNull(svc);
string[] connArray = svc.ConnectionStrings.ToArray();
Assert.IsTrue(connArray.Length == 1);
foreach (string s in connArray)
{
Console.WriteLine(s);
}
Assert.AreEqual(
"dark-rnd.redis.cache.windows.net:6380,ssl=True,abortConnect=False,password=6GFHu3Ghwm03VXejZesHWlY/Fzv4Km+xcBCOuleLnGE=",
connArray[0]
);
}
public async Task MongoDb_Test()
{
var locator = new DatabaseLocator(); // {ServiceDomain = "kmb.home"};
Console.WriteLine("Testing in {0}", locator.ServiceDomain);
DatabaseService svc = await locator.Locate("calltopark-db", DatabaseProtocol.MongoDb);
Assert.IsNotNull(svc);
string[] connArray = svc.ConnectionStrings.ToArray();
Assert.IsTrue(connArray.Length == 1);
foreach (string s in connArray)
{
Console.WriteLine(s);
}
Assert.AreEqual(
"mongodb://vsropknosql01.ipzhost.net:27017,vsropknosql02.ipzhost.net:27017,vsropknosql03.ipzhost.net:27017/CallToPark?replicaSet=OmniPark-Mongo-1&serverSelectionTimeoutMS=7000",
connArray[0]
);
}
static void Main(string[] args)
{
//var query = new DnsQuery("onumbers-db._sql._tcp.dev-test.rnd.ipzo.net", DnsRecordType.TXT);
//var query = new DnsQuery("leadalerts._grpc._tcp.dev-test.rnd.ipzo.net", DnsRecordType.SRV);
//var query = new DnsQuery("gmail.com", DnsRecordType.MX);
// var records = query.Resolve().Result;
// foreach (DnsEntry record in records)
// {
// Console.WriteLine(record.ToString());
// }
var locator = new DatabaseLocator {
ServiceDomain = "dev-test.rnd.ipzo.net"
};
var service = locator.Locate("onumbers-db", DatabaseProtocol.Sql).Result;
service.Decryptor.KeyPhrase = "dev";
foreach (var connStr in service.ConnectionStrings)
{
Console.WriteLine(connStr);
}
}
