static int Main(string[] args)
{
var logsPath = "logs\\migration-logs";
ILogger logger = new LoggerConfiguration()
.WriteTo.Console()
.WriteTo.File(new CompactJsonFormatter(), logsPath)
.CreateLogger();
logger.Information("Logger configured. Starting migration...");
// if (args.Length != 2)
// {
// logger.Error("Invalid arguments. Execution: DatabaseMigrator [connectionString] [pathToScripts].");
//
// logger.Information("Migration stopped");
//
// return -1;
// }
var connectionString = "Server=localhost;Database=MyMeetings;User Id=sa;Password=DB_Admin;"; //args[0];
var scriptsPath = "/home/michal/projects/functional-modular-monolith-with-ddd/src/Database/CompanyName.MyMeetings.Database/Migrations"; //args[1];
if (!Directory.Exists(scriptsPath))
{
logger.Information($"Directory {scriptsPath} does not exist");
return(-1);
}
var serilogUpgradeLog = new SerilogUpgradeLog(logger);
var upgrader =
DeployChanges.To
.SqlDatabase(connectionString)
.WithScriptsFromFileSystem(scriptsPath, new FileSystemScriptOptions
{
IncludeSubDirectories = true
})
.LogTo(serilogUpgradeLog)
.JournalToSqlTable("app", "MigrationsJournal")
.Build();
var result = upgrader.PerformUpgrade();
if (!result.Successful)
{
logger.Information("Migration failed");
return(-1);
}
logger.Information("Migration successful");
return(0);
}
static int Main(string[] args)
{
var logsPath = "logs\\migration-logs";
ILogger logger = new LoggerConfiguration()
.WriteTo.Console()
.WriteTo.RollingFile(new CompactJsonFormatter(), logsPath)
.CreateLogger();
logger.Information("Logger configured. Starting migration...");
if (args.Length != 2)
{
logger.Error("Invalid arguments. Execution: DatabaseMigrator [connectionString] [pathToScripts].");
logger.Information("Migration stopped");
return(-1);
}
var connectionString = args[0];
var scriptsPath = args[1];
if (!Directory.Exists(scriptsPath))
{
logger.Information($"Directory {scriptsPath} does not exist");
return(-1);
}
var serilogUpgradeLog = new SerilogUpgradeLog(logger);
var upgrader =
DeployChanges.To
.SqlDatabase(connectionString)
.WithScriptsFromFileSystem(scriptsPath, new FileSystemScriptOptions
{
IncludeSubDirectories = true
})
.LogTo(serilogUpgradeLog)
.JournalToSqlTable("app", "MigrationsJournal")
.Build();
var result = upgrader.PerformUpgrade();
if (!result.Successful)
{
logger.Information("Migration failed");
return(-1);
}
logger.Information("Migration successful");
return(0);
}
