PHP Db::dropTables方法代码示例

 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'));
 }