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 string GenerateDoDeltaFragmentHeader(ChangeScript changeScript) { StringBuilder builder = new StringBuilder(); builder.AppendLine("--------------- Fragment begins: " + changeScript + " ---------------"); builder.AppendLine("INSERT INTO " + TableName + " (change_number, delta_set, start_dt, applied_by, description)" + " VALUES (" + changeScript.GetId() + ", '" + deltaSet + "', " + DbmsSyntax.GenerateTimestamp() + ", " + DbmsSyntax.GenerateUser() + ", '" + changeScript.GetDescription() + "')" + DbmsSyntax.GenerateStatementDelimiter()); builder.Append(DbmsSyntax.GenerateCommit()); return builder.ToString(); }
public string GenerateDoDeltaFragmentHeader(ChangeScript changeScript) { var builder = new StringBuilder(); var syntax = DbmsSyntax; builder.AppendLine("--------------- Fragment begins: " + changeScript + " ---------------"); builder.AppendLine("SET NOCOUNT ON"); builder.AppendLine(syntax.GenerateTrace(">>>>>>>>>>>>>>> INICIA DELTA: {0} >>>>>>>>>>>>>>>", changeScript)); builder.AppendLine("INSERT INTO " + TableName + " (change_number, delta_set, start_dt, applied_by, description)" + " VALUES (" + changeScript.GetId() + ", '" + deltaSet + "', " + syntax.GenerateTimestamp() + ", " + syntax.GenerateUser() + ", '" + changeScript.GetDescription() + "')"); builder.AppendLine(syntax.GenerateStatementDelimiter()); builder.Append(syntax.GenerateCommit()); builder.AppendLine("SET NOCOUNT OFF"); 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(); }