public async Task <bool> Handle(FlashCommand request, CancellationToken cancellationToken)
{
Consoler.TitleStart("flash database start");
var connectionString =
ConfigurationManager.ConnectionStrings["Vita"].ConnectionString;
if (DatabaseUtil.CheckDatabaseExists(connectionString.Replace("Vita", "master"), "Vita"))
{
DatabaseUtil.DeleteAllTables(connectionString);
}
Consoler.TitleStart("Create Database if not exist ...");
EnsureDatabase.For.SqlDatabase(connectionString);
Consoler.TitleEnd("Completed");
Consoler.Write("EventFlow Schema Created...");
// EventFlow Schema
EventFlowEventStoresMsSql.MigrateDatabase(IocContainer.Container.Resolve <IMsSqlDatabaseMigrator>());
Consoler.Write("EventFlow Schema Created...");
// Schema
var result = DeployChanges.To
.SqlDatabase(connectionString)
.WithTransaction()
.WithScriptsEmbeddedInAssembly(Assembly.GetExecutingAssembly())
.LogToConsole()
.Build()
.PerformUpgrade();
foreach (var script in result.Scripts)
{
Consoler.Write($"script: {script.Name}");
}
if (result.Error != null)
{
Consoler.ShowError(result.Error);
}
await Task.CompletedTask;
Consoler.TitleEnd("flash database finished");
return(result.Successful);
}
