public function uninstall() { Piwik_DropTables(Piwik_Common::prefixTable('user_dashboard')); }
/** * 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) { Piwik_DropTables($oldBlobTables); } else { foreach ($oldBlobTables as $table) { $where = $this->getBlobTableWhereExpr($oldNumericTables, $table); if (!empty($where)) { $where = "WHERE {$where}"; } Piwik_DeleteAllRows($table, $where, $this->maxRowsToDeletePerQuery); } if ($optimize) { Piwik_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) { Piwik_DeleteAllRows($table, $where, $this->maxRowsToDeletePerQuery); } if ($optimize) { Piwik_OptimizeTables($oldNumericTables); } } else { Piwik_DropTables($oldNumericTables); } } }
/** * @throws Exception if non-recoverable error */ public function uninstall() { Piwik_DropTables(Piwik_Common::prefixTable('user_language')); }