public string GenerateUndoDeltaFragmentFooter(ChangeScript changeScript)
{
StringBuilder builder = new StringBuilder();
builder.AppendLine("DELETE FROM " + TableName
+ " WHERE ChangeNumber = " + changeScript.GetId()
+ " AND Project = '" + _deltaSet + "'"
+ DbmsSyntax.GenerateStatementDelimiter());
builder.AppendLine(DbmsSyntax.GenerateCommit());
builder.Append("--------------- Fragment ends: " + changeScript + " ---------------");
return(builder.ToString());
}
public string GenerateDoDeltaFragmentHeader(ChangeScript changeScript)
{
StringBuilder builder = new StringBuilder();
builder.AppendLine("--------------- Fragment begins: " + changeScript + " ---------------");
builder.AppendLine("INSERT INTO " + TableName +
" (ChangeNumber, Project, StartDate, AppliedBy, FileName)" +
" VALUES (" + changeScript.GetId() + ", '" + _deltaSet + "', " +
DbmsSyntax.GenerateTimestamp() +
", " + DbmsSyntax.GenerateChangeOwner() + ", '" + changeScript.GetDescription() + "')" +
DbmsSyntax.GenerateStatementDelimiter());
builder.Append(DbmsSyntax.GenerateCommit());
return(builder.ToString());
}
public virtual void RecordScriptApplied(ChangeScript script)
{
try
{
string sql = string.Format(
CultureInfo.InvariantCulture,
"INSERT INTO {0} (change_number, complete_dt, applied_by, description) VALUES (@1, {1}, {2}, @2)",
this.changeLogTableName,
this.syntax.GenerateTimestamp(),
this.syntax.GenerateUser());
this.queryExecuter.Execute(
sql,
script.GetId(),
script.GetDescription());
}
catch (DbException e)
{
throw new SchemaVersionTrackingException("Could not update change log because: " + e.Message, e);
}
}
public virtual string GetChangelogDeleteSql(ChangeScript script)
{
return(string.Format(CultureInfo.InvariantCulture, "DELETE FROM {0} WHERE change_number = {1}", this.changeLogTableName, script.GetId()));
}
