SetBased / php-audit

   * @param string $schemaName The schema name.

   * @param string $tableName  The table name.

   */

  protected function dropTriggersFromObsoleteTable($schemaName, $tableName)

  {

    $triggers = AuditDataLayer::getTableTriggers($schemaName, $tableName);

    foreach ($triggers as $trigger)

    {

      if (preg_match('/trg_audit_.*_(insert|update|delete)/', $trigger['trigger_name']))

      {

        $this->io->logInfo('Dropping trigger <dbo>%s</dbo> from obsolete table <dbo>%s</dbo>',

                           $trigger['trigger_name'],

                           $tableName);

        AuditDataLayer::dropTrigger($schemaName, $trigger['trigger_name']);

      }

    }

  }

  //--------------------------------------------------------------------------------------------------------------------

  /**

   * @param string $schemaName The name of the table schema.

   * @param string $tableName  The name of the table.

   */

  private function dropTriggers($schemaName, $tableName)

  {

    $triggers = AuditDataLayer::getTableTriggers($schemaName, $tableName);

    foreach ($triggers as $trigger)

    {

      $this->io->logVerbose('Dropping trigger <dbo>%s</dbo> on <dbo>%s.%s</dbo>',

                            $trigger['trigger_name'],

                            $schemaName,

                            $tableName);

      AuditDataLayer::dropTrigger($schemaName, $trigger['trigger_name']);

    }

  }

  //--------------------------------------------------------------------------------------------------------------------

  /**