protected override int Run()
{
_loggingFeature.Configure();
if (!(Require(_databaseFeature.Host, "host") && Require(_databaseFeature.Database, "database") &&
Require("username", _usernamePasswordFeature.Username) && Require("password", _usernamePasswordFeature.Password)))
{
return(-1);
}
try
{
using (var connection = DatabaseConnector.Connect(_databaseFeature.Host, _databaseFeature.Database,
_usernamePasswordFeature.Username, _usernamePasswordFeature.Password, false))
{
foreach (var applied in AppliedChangeScriptLog.GetAppliedChangeScripts(connection))
{
Console.WriteLine($"{applied.AppliedAt:o} {applied.AppliedBy} {applied.ScriptFile}");
}
}
return(0);
}
catch (Exception ex)
{
Log.Fatal(ex, "Could not apply change scripts");
return(-1);
}
}
protected override int Run()
{
_loggingFeature.Configure();
if (!(Require(_databaseFeature.Host, "host") && Require(_databaseFeature.Database, "database") &&
Require("username", _usernamePasswordFeature.Username) && Require("password", _usernamePasswordFeature.Password) &&
Require(_scriptRoot, "script root directory")))
{
return(-1);
}
try
{
UpdateSession.ApplyChangeScripts(
_databaseFeature.Host, _databaseFeature.Database, _usernamePasswordFeature.Username, _usernamePasswordFeature.Password,
_createIfMissing, _scriptRoot, _defineVariablesFeature.Variables);
return(0);
}
catch (Exception ex)
{
Log.Fatal(ex, "Could not apply change scripts");
return(-1);
}
}
protected override int Run()
{
_loggingFeature.Configure();
try
{
BaselineSession.BaselineDatabase(
_databaseFeature.Host, _databaseFeature.Database, _usernamePasswordFeature.Username, _usernamePasswordFeature.Password,
_scriptRootFeature.ScriptRoot);
return(0);
}
catch (Exception ex)
{
Log.Fatal(ex, "Could not baseline the database");
return(-1);
}
}
protected override int Run()
{
_loggingFeature.Configure();
try
{
UpdateSession.ApplyChangeScripts(
_databaseFeature.Host, _databaseFeature.Database, _usernamePasswordFeature.Username, _usernamePasswordFeature.Password,
_createIfMissing, _scriptRootFeature.ScriptRoot, _defineVariablesFeature.Variables);
return(0);
}
catch (PostgresException ex)
{
Log.Fatal("Could not apply change scripts: {Message} ({SqlState})", ex.MessageText, ex.SqlState);
return(-1);
}
catch (Exception ex)
{
Log.Fatal(ex, "Could not apply change scripts");
return(-1);
}
}
protected override int Run()
{
_loggingFeature.Configure();
try
{
using (var connection = DatabaseConnector.Connect(_databaseFeature.Host, _databaseFeature.Database,
_usernamePasswordFeature.Username, _usernamePasswordFeature.Password, false))
{
foreach (var pending in DatabaseStatus.GetPendingScripts(connection, _scriptRootFeature.ScriptRoot))
{
Console.WriteLine($"{pending.RelativeName}");
}
}
return(0);
}
catch (Exception ex)
{
Log.Fatal(ex, "Could not determine pending change scripts");
return(-1);
}
}