public TableTriggers GetTriggers(Table table)
{
if (table != null)
{
TableTriggers triggers = new TableTriggers(table);
using (MySqlConnection conn = new MySqlConnection(connectioString))
{
conn.Open();
using (MySqlCommand command = new MySqlCommand(GetSQLTrigger(table), conn))
{
using (MySqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
TableTrigger trigger = new TableTrigger(table);
trigger.Id = triggers.Count + 1;
trigger.Name = reader["TRIGGER_NAME"].ToString();
trigger.Manipulation = reader["EVENT_MANIPULATION"].ToString();
trigger.Mode = reader["SQL_MODE"].ToString();
trigger.Text = reader["ACTION_STATEMENT"].ToString();
trigger.Timing = reader["ACTION_TIMING"].ToString();
triggers.Add(trigger);
}
}
}
}
return(triggers);
}
else
{
throw new ArgumentNullException("table");
}
}
public static TableTriggers GenerateDiferences(TableTriggers CamposOrigen, TableTriggers CamposDestino)
{
foreach (TableTrigger node in CamposDestino)
{
if (!CamposOrigen.Find(node.FullName))
{
TableTrigger newNode = node.Clone(CamposOrigen.Parent);
newNode.Status = StatusEnum.ObjectStatusType.CreateStatus;
CamposOrigen.Add(newNode);
}
else
{
if (!TableTrigger.Compare(node, CamposOrigen[node.FullName]))
{
TableTrigger newNode = node.Clone(CamposOrigen.Parent);
newNode.Status = StatusEnum.ObjectStatusType.AlterStatus;
CamposOrigen[node.FullName] = newNode;
}
}
}
foreach (TableTrigger node in CamposOrigen)
{
if (!CamposDestino.Find(node.FullName))
{
node.Status = StatusEnum.ObjectStatusType.DropStatus;
}
}
return(CamposOrigen);
}
// Use this for initialization
void Start()
{
//Initialize variables
tableScript = tableCollider.GetComponent<TableTrigger> ();
tm = displayMessage.GetComponent<TextMesh>();
inventory = inventoryMessage.GetComponent<TextMesh> ();
secretMessage = hiddenMessage.GetComponent<TextMesh> ();
isInside = false;
empty = false;
light = barLight.GetComponent<Light> ();
}
// Use this for initialization
void Start()
{
//Initialize variables
tableScript = tableCollider.GetComponent <TableTrigger> ();
tm = displayMessage.GetComponent <TextMesh>();
inventory = inventoryMessage.GetComponent <TextMesh> ();
secretMessage = hiddenMessage.GetComponent <TextMesh> ();
isInside = false;
empty = false;
light = barLight.GetComponent <Light> ();
}
public void SetTriggers(Tables tables)
{
string text = "";
using (AseConnection conn = new AseConnection(connectioString))
{
conn.Open();
using (AseCommand command = new AseCommand(GetSQLTrigger(), conn))
{
using (AseDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
TableTrigger trigger = new TableTrigger(tables[reader["TableName"].ToString()]);
trigger.Id = (int)reader["id"];
trigger.Name = reader["name"].ToString();
trigger.Owner = reader["owner"].ToString();
tables[reader["TableName"].ToString()].Triggers.Add(trigger);
}
}
}
foreach (Table table in tables)
{
for (int index = 0; index < table.Triggers.Count; index++)
{
using (AseCommand command = new AseCommand("sp_helptext '" + table.Triggers[index].Name + "'", conn))
{
using (AseDataReader reader = command.ExecuteReader())
{
text = "";
reader.NextResult();
while (reader.Read())
{
text += reader["text"].ToString();
}
table.Triggers[index].Text = text;
}
}
}
}
}
}
public TableTriggers GetTriggers(Table table)
{
ArrayList names = new ArrayList();
string text = "";
TableTriggers triggers = new TableTriggers(table);
using (SqlConnection conn = new SqlConnection(connectioString))
{
conn.Open();
using (SqlCommand command = new SqlCommand("SELECT SO.name FROM sysobjects SO WHERE type = 'TR' and SO.parent_obj = " + table.Id.ToString() + " ORDER BY SO.name", conn))
{
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
names.Add(reader["name"].ToString());
}
}
}
for (int index = 0; index < names.Count; index++)
{
using (SqlCommand command = new SqlCommand("sp_helptext '" + names[index] + "'", conn))
{
using (SqlDataReader reader = command.ExecuteReader())
{
text = "";
while (reader.Read())
{
text += reader["text"].ToString();
}
TableTrigger trigger = new TableTrigger(table);
trigger.Name = names[index].ToString();
trigger.Text = text;
triggers.Add(trigger);
}
}
}
}
return(triggers);
}
public override Script DropTrigger(TableTrigger trigger)
{
return(new DropDbObjectScript <View>(this.GetDropSql("trigger", trigger)));
}
public abstract Script DropTrigger(TableTrigger trigger);
