public void HandleInput(TriggerActionType type, params object[] inputs)
{
if (TriggerActions.Last().Triggered)
{
return;
}
foreach (var trigger in TriggerActions)
{
if (trigger.Triggered)
{
continue;
}
trigger.HandleInput(type, inputs);
break;
}
if (TriggerActions.Last().Triggered)
{
if (FinalAction != null)
{
FinalAction();
}
Reset();
}
}
public string GetCreateTriggerHeaderString(
string triggerName,
string dataTableName,
TriggerActions action)
{
var quotedTriggerName = IsQuoted(triggerName) ?
triggerName : Quote(triggerName);
var quotedTableName = QuoteForTableName(dataTableName);
string actionName;
switch (action)
{
case TriggerActions.INSERT:
actionName = "INSERT";
break;
case TriggerActions.UPDATE:
actionName = "UPDATE";
break;
case TriggerActions.DELETE:
actionName = "DELETE";
break;
default:
throw new NotSupportedException(
string.Format("Trigger action {0} isn't supported by this dialect.", action));
}
return string.Format("create trigger {0} after {1} on {2}\nbegin",
quotedTriggerName, actionName, quotedTableName);
}
public string GetCreateTriggerHeaderString(
string triggerName,
string dataTableName,
TriggerActions action)
{
string actionName;
switch (action)
{
case TriggerActions.INSERT:
actionName = "INSERT";
break;
case TriggerActions.UPDATE:
actionName = "UPDATE";
break;
case TriggerActions.DELETE:
actionName = "DELETE";
break;
default:
throw new NotSupportedException(
string.Format("Trigger action {0} isn't supported by this dialect.", action));
}
return string.Format(
"CREATE TRIGGER {0} " +
"ON {1} " +
"AFTER {2} AS\nBEGIN\nSET NOCOUNT ON;",
QuoteForTriggerName(triggerName),
QuoteForTableName(dataTableName), actionName);
}
public string GetCreateTriggerHeaderString(
string triggerName,
string dataTableName,
TriggerActions action)
{
var quotedTriggerName = IsQuoted(triggerName) ?
triggerName : Quote(triggerName);
var quotedTableName = QuoteForTableName(dataTableName);
string actionName;
switch (action)
{
case TriggerActions.INSERT:
actionName = "INSERT";
break;
case TriggerActions.UPDATE:
actionName = "UPDATE";
break;
case TriggerActions.DELETE:
actionName = "DELETE";
break;
default:
throw new NotSupportedException(
string.Format("Trigger action {0} isn't supported by this dialect.", action));
}
return(string.Format("create trigger {0} after {1} on {2}\nbegin",
quotedTriggerName, actionName, quotedTableName));
}
public string GetDropTriggerString(string triggerName,
string dataTableName, TriggerActions action)
{
return(string.Format("IF OBJECT_ID ('{0}', 'TR') IS NOT NULL " +
"DROP TRIGGER {1};", triggerName,
QuoteForTriggerName(triggerName)));
}
public string GetDropTriggerString(string triggerName,
string dataTableName, TriggerActions action)
{
return string.Format("IF OBJECT_ID ('{0}', 'TR') IS NOT NULL " +
"DROP TRIGGER {1};", triggerName,
QuoteForTriggerName(triggerName));
}
public string GetCreateTriggerHeaderString(
string triggerName,
string dataTableName,
TriggerActions action)
{
string actionName;
switch (action)
{
case TriggerActions.INSERT:
actionName = "INSERT";
break;
case TriggerActions.UPDATE:
actionName = "UPDATE";
break;
case TriggerActions.DELETE:
actionName = "DELETE";
break;
default:
throw new NotSupportedException(
string.Format("Trigger action {0} isn't supported by this dialect.", action));
}
return(string.Format(
"CREATE TRIGGER {0} " +
"ON {1} " +
"AFTER {2} AS\nBEGIN\nSET NOCOUNT ON;",
QuoteForTriggerName(triggerName),
QuoteForTableName(dataTableName), actionName));
}
public AuditTrigger(Table dataTable, AuditTable auditTable,
INamingStrategy namingStrategy, TriggerActions action)
: base(namingStrategy.GetTriggerName(dataTable, action),
dataTable.GetQuotedName(),
action)
{
_auditTable = auditTable;
_dataColumnNames = (
from column in dataTable.ColumnIterator
select column.GetQuotedName()
).ToArray();
}
public AuditTrigger(Table dataTable, AuditTable auditTable,
INamingStrategy namingStrategy, TriggerActions action)
: base(
namingStrategy.GetTriggerName(dataTable, action),
dataTable.GetQuotedName(),
action)
{
_auditTable = auditTable;
_dataColumnNames = (
from column in dataTable.ColumnIterator
select column.GetQuotedName()
).ToArray();
}
public static void Register(ITextBuffer buffer, Action delayed, Action disabled)
{
TriggerActions triggerActions;
if (buffersAndActions.TryGetValue(buffer, out triggerActions))
{
triggerActions.Delayed.Add(delayed);
triggerActions.Disabled.Add(disabled);
}
else
{
var t = new TriggerActions();
t.Delayed.Add (delayed);
t.Disabled.Add(disabled);
buffersAndActions[buffer] = t;
}
buffer.Changed += new EventHandler<TextContentChangedEventArgs>(buffer_Changed);
}
public string GetTriggerName(Table dataTable, TriggerActions action)
{
var unquotedName = dataTable.Name;
string actionString;
switch (action)
{
case TriggerActions.INSERT:
actionString = "Insert";
break;
case TriggerActions.UPDATE:
actionString = "Update";
break;
case TriggerActions.DELETE:
actionString = "Delete";
break;
default:
throw new ArgumentOutOfRangeException("action");
}
return string.Format("{0}_on{1}", unquotedName, actionString);
}
public void AuditOperationColumnUniquelyIdentifiesOperation()
{
var dialect = new Dialects.DummyExtendedDialect();
dialect.Functions.Clear();
var auditColumns = GetAuditColumnSource().GetAuditColumns(
new Table("AuditTable"), dialect);
var auditOperation = auditColumns.Single();
var operations = new TriggerActions[] {
TriggerActions.INSERT,
TriggerActions.UPDATE,
TriggerActions.DELETE
};
var outputs = from op in operations
select auditOperation.ValueFunction(op);
Assert.AreEqual(outputs.Count(), outputs.Distinct().Count());
}
public string GetTriggerName(Table dataTable, TriggerActions action)
{
var unquotedName = dataTable.Name;
string actionString;
switch (action)
{
case TriggerActions.INSERT:
actionString = "Insert";
break;
case TriggerActions.UPDATE:
actionString = "Update";
break;
case TriggerActions.DELETE:
actionString = "Delete";
break;
default:
throw new ArgumentOutOfRangeException("action");
}
return(string.Format("{0}_on{1}", unquotedName, actionString));
}
public string GetCreateTriggerFooterString(string triggerName,
string dataTableName, TriggerActions action)
{
return("SET NOCOUNT OFF;\nEND");
}
public string GetCreateTriggerFooterString(string triggerName,
string dataTableName, TriggerActions action)
{
return "SET NOCOUNT OFF;\nEND";
}
private void Start()
{
characterCollider = FindObjectOfType <TriggerActions>().GetComponent <TriggerActions>();
}
public Trigger(string triggerName, string tableName, TriggerActions action)
{
_action = action;
_triggerName = triggerName;
_tableName = tableName;
}
public string GetCreateTriggerFooterString(string triggerName,
string dataTableName, TriggerActions action)
{
return("end;");
}
public string GetDropTriggerString(string triggerName,
string dataTableName, TriggerActions action)
{
return string.Format("drop trigger if exists {0};",
triggerName);
}
public string GetCreateTriggerFooterString(string triggerName,
string dataTableName, TriggerActions action)
{
return "end;";
}
public string GetDropTriggerString(string triggerName,
string dataTableName, TriggerActions action)
{
return(string.Format("drop trigger if exists {0};",
triggerName));
}
public abstract SqlBuilder GetTriggerActionsSql <TTriggerEntity>(TriggerActions <TTriggerEntity> triggerActions)
where TTriggerEntity : class;
