protected override void AppendTo(SqlStringBuilder builder) { var orReplace = ReplaceIfExists ? "OR REPLACE" : ""; builder.AppendFormat("CREATE {0}PROCEDURE ", orReplace); ProcedureName.AppendTo(builder); builder.Append("("); if (Parameters != null && Parameters.Length > 0) { for (int i = 0; i < Parameters.Length; i++) { Parameters[i].AppendTo(builder); if (i < Parameters.Length - 1) { builder.Append(", "); } } } builder.Append(")"); builder.AppendLine(" IS"); builder.Indent(); Body.AppendTo(builder); builder.DeIndent(); }
protected override void AppendTo(SqlStringBuilder builder) { builder.Append("CREATE "); if (ReplaceIfExists) { builder.Append("OR REPLACE "); } builder.Append("TRIGGER "); TriggerName.AppendTo(builder); builder.AppendFormat(" {0} {1} ", EventTime.ToString().ToUpperInvariant(), EventType.AsDebugString()); builder.Append("ON "); TableName.AppendTo(builder); builder.Append(" "); builder.Append("FOR EACH ROW "); if (Status != TriggerStatus.Unknown) { if (Status == TriggerStatus.Disabled) { builder.Append("DISABLE "); } else if (Status == TriggerStatus.Enabled) { builder.Append("ENABLE "); } } builder.Append("CALL "); ProcedureName.AppendTo(builder); builder.Append("("); if (ProcedureArguments != null && ProcedureArguments.Length > 0) { for (int i = 0; i < ProcedureArguments.Length; i++) { ProcedureArguments[i].AppendTo(builder); if (i < ProcedureArguments.Length - 1) { builder.Append(", "); } } } builder.Append(")"); }