Exemplo n.º 1
0
 /**
  * Drops all triggers.
  */
 private function dropTriggers()
 {
     $data_schema = $this->config['database']['data_schema'];
     $triggers = AuditDataLayer::getTriggers($data_schema);
     foreach ($triggers as $trigger) {
         $this->io->logInfo('Dropping trigger <dbo>%s</dbo> from table <dbo>%s</dbo>', $trigger['trigger_name'], $trigger['table_name']);
         AuditDataLayer::dropTrigger($data_schema, $trigger['trigger_name']);
     }
 }
Exemplo n.º 2
0
 /**
  * Drops all triggers from this table.
  */
 private function dropTriggers()
 {
     $triggers = AuditDataLayer::getTableTriggers($this->configTable->getSchemaName(), $this->configTable->getTableName());
     foreach ($triggers as $trigger) {
         $this->io->logVerbose('Dropping trigger <dbo>%s</dbo> on <dbo>%s.%s</dbo>', $trigger['trigger_name'], $this->configTable->getSchemaName(), $this->configTable->getTableName());
         AuditDataLayer::dropTrigger($this->configTable->getSchemaName(), $trigger['trigger_name']);
     }
 }