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); } }