Exemplo n.º 1
0
 public function create(MidataTrigger $trigger)
 {
     $name = $trigger->name();
     $table = $trigger->tableName();
     // INSERT, DELETE, UPDATE
     $event = $trigger->event();
     // AFTER, BEFORE
     $timming = $trigger->timming();
     // tresc triggera
     $statement = $trigger->statement();
     // kiedy trigger ma byc wykonany
     $orientation = $trigger->orientation();
     $orientation = "FOR EACH {$orientation}";
     $sql = "DELIMITER \$\$\nCREATE TRIGGER `{$name}`\n    {$timming} {$event} on `{$table}`\n {$orientation}\n{$statement}\n\$\$\nDELIMITER ;";
     return $sql;
 }