From e61b8958733ede26a524bc228b85a07bacec21c0 Mon Sep 17 00:00:00 2001 From: mattab Date: Tue, 18 Jun 2013 17:24:06 +1200 Subject: Removing TablePartitioning from codebase, since it was rather ugly. Introducing ArchiveTableCreator --- core/TablePartitioning.php | 135 --------------------------------------------- 1 file changed, 135 deletions(-) delete mode 100644 core/TablePartitioning.php (limited to 'core/TablePartitioning.php') diff --git a/core/TablePartitioning.php b/core/TablePartitioning.php deleted file mode 100644 index 330c9f168a..0000000000 --- a/core/TablePartitioning.php +++ /dev/null @@ -1,135 +0,0 @@ -tableName = $tableName; - } - - abstract protected function generateTableName(); - - public function setTimestamp($timestamp) - { - $this->timestamp = $timestamp; - $this->generatedTableName = null; - $this->getTableName(); - } - - public function getTableName() - { - // table name already processed - if (!is_null($this->generatedTableName)) { - return $this->generatedTableName; - } - - if (is_null($this->timestamp)) { - throw new Exception("You have to specify a timestamp for a Table Partitioning by date."); - } - - // generate table name - $this->generatedTableName = $this->generateTableName(); - - // we make sure the table already exists - $this->checkTableExists(); - } - - protected function checkTableExists() - { - if (is_null(self::$tablesAlreadyInstalled)) { - self::$tablesAlreadyInstalled = Piwik::getTablesInstalled($forceReload = false); - } - - if (!in_array($this->generatedTableName, self::$tablesAlreadyInstalled)) { - $db = Zend_Registry::get('db'); - $sql = Piwik::getTableCreateSql($this->tableName); - - $config = Piwik_Config::getInstance(); - $prefixTables = $config->database['tables_prefix']; - $sql = str_replace($prefixTables . $this->tableName, $this->generatedTableName, $sql); - try { - $db->query($sql); - } catch (Exception $e) { - // mysql error 1050: table already exists - if (!$db->isErrNo($e, '1050')) { - // failed for some other reason - throw $e; - } - } - - self::$tablesAlreadyInstalled[] = $this->generatedTableName; - } - } - - public function __toString() - { - return $this->getTableName(); - } -} - -/** - * - * @package Piwik - * @subpackage Piwik_TablePartitioning - */ -class Piwik_TablePartitioning_Monthly extends Piwik_TablePartitioning -{ - private static $blobArchiveTable = null; - private static $numericArchiveTable = null; - - public function __construct($tableName) - { - parent::__construct($tableName); - } - - protected function generateTableName() - { - $config = Piwik_Config::getInstance(); - return $config->database['tables_prefix'] . $this->tableName . "_" . date("Y_m", $this->timestamp); - } - - /** - * Creates archive_blob & archive_numeric tables for a period if they don't already exist. - * - * @param Piwik_Date - */ - public static function createArchiveTablesIfAbsent(Piwik_Date $dateInMonth) - { - $timestamp = $dateInMonth->getTimestamp(); - - self::$blobArchiveTable->setTimestamp($timestamp); - self::$blobArchiveTable->getTableName(); - - self::$numericArchiveTable->setTimestamp($timestamp); - self::$numericArchiveTable->getTableName(); - } - - public static function init() - { - self::$blobArchiveTable = new Piwik_TablePartitioning_Monthly('archive_blob'); - self::$numericArchiveTable = new Piwik_TablePartitioning_Monthly('archive_numeric'); - } -} - -Piwik_TablePartitioning_Monthly::init(); -- cgit v1.2.3