static void Main(string[] args)
{
ExternalSystemSettings externalSystemSettings = (dynamic)ConfigurationManager.GetSection("ExternalSystemSettings");
Console.WriteLine("-==================== ExternalSystemSettings ====================-");
Console.WriteLine(" AuthenticationSettings");
Console.WriteLine(" Login: {0}", externalSystemSettings.AuthenticationSettings.Login);
Console.WriteLine(" Password: {0}", externalSystemSettings.AuthenticationSettings.Password);
for (int index = 0; index < externalSystemSettings.AuthenticationSettings.Urls.Count; index++)
{
string url = externalSystemSettings.AuthenticationSettings.Urls[index];
Console.WriteLine(" Url[{0}]: {1}", index, url);
}
Console.WriteLine(" StaffSettings");
Console.WriteLine(" Token: {0}", externalSystemSettings.StaffSettings.Token);
Console.WriteLine(" Url: {0}", externalSystemSettings.StaffSettings.Url);
Console.WriteLine();
DatabasesSettings databasesSettings = (dynamic)ConfigurationManager.GetSection("DatabasesSettings");
Console.WriteLine("-======================= DatabasesSettings ======================-");
Console.WriteLine(" MongoDatabaseSettings");
Console.WriteLine(" DatabaseName: {0}", databasesSettings.MongoSettings.DatabaseName);
Console.WriteLine(" ConnectionString: {0}", databasesSettings.MongoSettings.ConnectionString);
Console.WriteLine(" SqlSettings");
foreach (var setting in databasesSettings.SqlSettings)
{
Console.WriteLine(" Tenant: {0}; Connection: {1}", setting.Key, setting.Value.ConnectionString);
}
Console.WriteLine();
SmtpSettings smtpSettings = (dynamic)ConfigurationManager.GetSection("SmtpSettings");
Console.WriteLine("-========================= SmtpSettings =========================-");
Console.WriteLine(" Host: {0}", smtpSettings.Host);
Console.WriteLine(" Sender: {0}", smtpSettings.Sender);
Console.WriteLine(" Recipients");
foreach (var setting in smtpSettings.Recipients)
{
Console.WriteLine(" Recipient: {0}", setting);
}
Console.WriteLine("-================================================================-");
Console.ReadLine();
}
private static IServiceCollection AddMongoDb(
this IServiceCollection services,
DatabasesSettings mongoDbSettings)
{
services.AddSingleton <IMongoClient>(_ =>
{
var mongoClientSettings = new MongoClientSettings
{
Servers = new[] { MongoServerAddress.Parse(mongoDbSettings.MongoDBConnectionString) }
};
return(new MongoClient(mongoClientSettings));
});
services.AddSingleton(p => p.GetRequiredService <IMongoClient>().GetDatabase(mongoDbSettings.MongoDBName));
return(services);
}
/// <summary>
/// Update Performer with journal
/// </summary>
/// <param name="dbConfig">
/// </param>
/// <returns>
/// </returns>
public static DatabaseUpgradeResult DeployDataBase(DatabasesSettings dbConfig)
{
var assembly = Assembly.Load(dbConfig.ProjectDatabase);
ConsoleOutput.Warning($"Deploying {dbConfig.InitialCatalog}...");
Func <string, bool> filterSqlFiles = dbConfig.GetFilterSqlFiles();
SqlJournalSystem journal = new SqlJournalSystem(dbConfig);
var upgradeDB =
DeployChanges.To
.SqlDatabase(dbConfig.DeployConnectionString)
.WithScriptsEmbeddedInAssembly(assembly, x => filterSqlFiles(x))
.WithVariables(dbConfig.Variables)
.WithExecutionTimeout(dbConfig.ConnectTimeout)
.JournalTo(journal)
.WithTransaction()
.LogToConsole()
.Build();
return(upgradeDB.PerformUpgrade());
}
