public function tearDown() { // clean up your test here if needed $tables = ArchiveTableCreator::getTablesArchivesInstalled(); if (!empty($tables)) { Db::dropTables($tables); } parent::tearDown(); }
public static function uninstall() { Db::dropTables(array(Common::prefixTable('alert'), Common::prefixTable('alert_triggered'), Common::prefixTable('alert_site'))); }
public static function uninstall() { Db::dropTables(Common::prefixTable(self::$rawPrefix)); }
/** * @throws Exception if non-recoverable error */ public function uninstall() { Db::dropTables(Common::prefixTable('user_language')); }
/** * Purges old report/metric data. * * If $keepBasicMetrics is false, old numeric tables will be dropped, otherwise only * the metrics not in $metricsToKeep will be deleted. * * If $reportPeriodsToKeep is an empty array, old blob tables will be dropped. Otherwise, * specific reports will be deleted, except reports for periods in $reportPeriodsToKeep. * * @param bool $optimize If tables should be optimized after rows are deleted. Normally, * this is handled by a scheduled task. */ public function purgeData($optimize = false) { // find archive tables to purge list($oldNumericTables, $oldBlobTables) = $this->getArchiveTablesToPurge(); // process blob tables first, since archive status is stored in the numeric archives if (!empty($oldBlobTables)) { // if no reports should be kept, drop tables, otherwise drop individual reports if (empty($this->reportPeriodsToKeep) && !$this->keepSegmentReports) { Db::dropTables($oldBlobTables); } else { foreach ($oldBlobTables as $table) { $where = $this->getBlobTableWhereExpr($oldNumericTables, $table); if (!empty($where)) { $where = "WHERE {$where}"; } Db::deleteAllRows($table, $where, "idarchive ASC", $this->maxRowsToDeletePerQuery); } if ($optimize) { Db::optimizeTables($oldBlobTables); } } } // deal with numeric tables if (!empty($oldNumericTables)) { // if keep_basic_metrics is set, empty all numeric tables of metrics to purge if ($this->keepBasicMetrics == 1 && !empty($this->metricsToKeep)) { $where = "WHERE name NOT IN ('" . implode("','", $this->metricsToKeep) . "') AND name NOT LIKE 'done%'"; foreach ($oldNumericTables as $table) { Db::deleteAllRows($table, $where, "idarchive ASC", $this->maxRowsToDeletePerQuery); } if ($optimize) { Db::optimizeTables($oldNumericTables); } } else { Db::dropTables($oldNumericTables); } } }
static function downgradeFrom($version) { try { switch ($version) { case 2: Db::dropTables(Common::prefixTable('chat_automatic_message')); $sql = "ALTER TABLE " . Common::prefixTable('chat') . " DROP COLUMN `idautomsg`;"; Db::exec($sql); break; case 1: Db::dropTables(Common::prefixTable('chat')); Db::dropTables(Common::prefixTable('chat_history_admin')); Db::dropTables(Common::prefixTable('chat_personnal_informations')); $sql = "ALTER TABLE " . Common::prefixTable('user') . " DROP COLUMN `last_poll`;"; Db::exec($sql); break; } } catch (Exception $e) { throw $e; } self::setDbVersion($version - 1); return; }
public function uninstall() { Db::dropTables(array($this->tableNamePrefixed)); }
public function uninstall() { Db::dropTables(Common::prefixTable('user_dashboard')); }
public function uninstall() { Db::dropTables(Common::prefixTable("snoopy")); Db::dropTables(Common::prefixTable("snoopy_visitors")); Db::dropTables(Common::prefixTable("snoopy_visitors_statuses")); }
/** * Deletes the DB table for private key storage, if exists. * * @throws Exception If there is an error in the SQL. */ public static function deletePrivateKeyTable() { try { Db::dropTables(Common::prefixTable(static::KEY_TABLE)); } catch (Exception $e) { // ignore error if table does not exist (1051 code is for 'unknown table') if (!Db::get()->isErrNo($e, '1051')) { throw $e; } } }
/** * Uninstalls the plugins. Derived classes should implement this method if the changes * made in {@link install()} need to be undone during uninstallation. * * In most cases, if you have an {@link install()} method, you should provide * an {@link uninstall()} method. * * @throws \Exception if uninstallation of fails for some reason. */ public function uninstall() { Db::dropTables(Common::prefixTable('bannerstats')); }