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