public string GenerateVersionCheck()
{
string versionCheckSql = string.Empty;
if (_currentVersion.HasValue)
{
versionCheckSql = DbmsSyntax.GenerateVersionCheck(TableName, _currentVersion.Value.ToString(), _deltaSet);
}
return(versionCheckSql);
}
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());
}
private void Instanciar(string sgbd)
{
var dbmsFactory = new DbmsFactory(sgbd, "connection=string");
dbmsSyntax = (DbmsSyntax)dbmsFactory.CreateDbmsSyntax();
}
private void Instanciar(string sgbd)
{
var dbmsFactory = new DbmsFactory(sgbd, "connection=string");
dbmsSyntax = (DbmsSyntax)dbmsFactory.CreateDbmsSyntax();
}