blob: 6e54347334ac52e3a3737d376b192d5260075aeb (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
|
<?php
namespace Civi\Test\Api4\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);
}
}
}
|