Merge pull request #17706 from demeritcowboy/mysql-ssl-alt

[civicrm-core.git] / tests / phpunit / api / v4 / Traits / TableDropperTrait.php

<?php

/*
 +--------------------------------------------------------------------+
 | Copyright CiviCRM LLC. All rights reserved.                        |
 |                                                                    |
 | This work is published under the GNU AGPLv3 license with some      |
 | permitted exceptions and without any warranty. For full license    |
 | and copyright information, see https://civicrm.org/licensing       |
 +--------------------------------------------------------------------+
 */

/**
 *
 * @package CRM
 * @copyright CiviCRM LLC https://civicrm.org/licensing
 */


namespace api\v4\Traits;

trait TableDropperTrait {

  /**
   * @param $prefix
   */
  protected function dropByPrefix($prefix) {
    $sql = "SELECT CONCAT( 'DROP TABLE ', GROUP_CONCAT(table_name) , ';' ) " .
      "AS statement FROM information_schema.tables " .
      "WHERE table_name LIKE '%s%%' AND table_schema = DATABASE();";
    $sql = sprintf($sql, $prefix);
    $dropTableQuery = \CRM_Core_DAO::executeQuery($sql);
    $dropTableQuery->fetch();
    $dropTableQuery = $dropTableQuery->statement;

    if ($dropTableQuery) {
      \CRM_Core_DAO::executeQuery($dropTableQuery);
    }
  }

}