/** * Purges old data from the following tables: * - log_visit * - log_link_visit_action * - log_conversion * - log_conversion_item * - log_action */ public function purgeData() { $maxIdVisit = $this->getDeleteIdVisitOffset(); // break if no ID was found (nothing to delete for given period) if (empty($maxIdVisit)) { return; } $logTables = self::getDeleteTableLogTables(); // delete data from log tables $where = "WHERE idvisit <= ?"; foreach ($logTables as $logTable) { // deleting from log_action must be handled differently, so we do it later if ($logTable != Common::prefixTable('log_action')) { Db::deleteAllRows($logTable, $where, "idvisit ASC", $this->maxRowsToDeletePerQuery, array($maxIdVisit)); } } // delete unused actions from the log_action table (but only if we can lock tables) if (Db::isLockPrivilegeGranted()) { $this->purgeUnusedLogActions(); } else { $logMessage = get_class($this) . ": LOCK TABLES privilege not granted; skipping unused actions purge"; Log::warning($logMessage); } // optimize table overhead after deletion Db::optimizeTables($logTables); }
/** * Soft deletes a given Goal. * Stats data in the archives will still be recorded, but not displayed. * * @param int $idSite * @param int $idGoal * @return void */ public function deleteGoal($idSite, $idGoal) { Piwik::checkUserHasAdminAccess($idSite); Db::query("UPDATE " . Common::prefixTable('goal') . "\n\t\t\t\t\t\t\t\t\t\tSET deleted = 1\n\t\t\t\t\t\t\t\t\t\tWHERE idsite = ?\n\t\t\t\t\t\t\t\t\t\t\tAND idgoal = ?", array($idSite, $idGoal)); Db::deleteAllRows(Common::prefixTable("log_conversion"), "WHERE idgoal = ? AND idsite = ?", "idvisit", 100000, array($idGoal, $idSite)); Cache::regenerateCacheWebsiteAttributes($idSite); }
public function deleteGoalConversions($idSite, $idGoal) { $table = Common::prefixTable("log_conversion"); Db::deleteAllRows($table, "WHERE idgoal = ? AND idsite = ?", "idvisit", 100000, array($idGoal, $idSite)); }
/** * 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); } } }
/** * 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) { list($oldNumericTables, $oldBlobTables) = $this->getArchiveTablesToPurge(); // process blob tables first, since archive status is stored in the numeric archives if (!empty($oldBlobTables)) { 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); } } $this->segmentArchiveIds = null; if (!empty($oldNumericTables)) { foreach ($oldNumericTables as $table) { $conditions = array("name NOT LIKE 'done%'"); $bind = array(); if ($this->keepBasicMetrics && !empty($this->metricsToKeep)) { $metricFields = Common::getSqlStringFieldsArray($this->metricsToKeep); $bind = $this->metricsToKeep; $conditions[] = sprintf("name NOT IN (%s)", $metricFields); } $keepWhere = $this->getBlobTableWhereExpr($oldNumericTables, $table); if (!empty($keepWhere)) { $conditions[] = $keepWhere; } $where = 'WHERE ' . implode(' AND ', $conditions); Db::deleteAllRows($table, $where, "idarchive ASC", $this->maxRowsToDeletePerQuery, $bind); } if ($optimize) { Db::optimizeTables($oldNumericTables); } } }