3.12.0-b1.php
5 years ago
3.12.0-b7.php
5 years ago
4.0.0-b1.php
4 years ago
4.0.0-b3.php
4 years ago
4.0.0-rc3.php
4 years ago
4.0.0-rc4.php
4 years ago
4.0.1-b1.php
4 years ago
4.0.4-b1.php
4 years ago
4.1.2-b1.php
5 years ago
4.1.2-b2.php
4 years ago
4.10.0-b1.php
3 years ago
4.11.0-b1.php
3 years ago
4.11.0-rc2.php
3 years ago
4.12.0-b1.php
3 years ago
4.12.0-b2.php
3 years ago
4.12.0-b3.php
3 years ago
4.12.0-b4.php
3 years ago
4.3.0-b3.php
4 years ago
4.3.0-b4.php
4 years ago
4.3.0-rc2.php
4 years ago
4.4.0-b1.php
4 years ago
4.5.0-b1.php
4 years ago
4.6.0-b1.php
4 years ago
4.6.0-b4.php
4 years ago
4.6.2-rc2.php
4 years ago
4.7.0-b2.php
4 years ago
4.7.1-b1.php
4 years ago
5.0.0-b1.php
4 years ago
4.6.0-b4.php
120 lines
| 1 | <?php |
| 2 | /** |
| 3 | * Matomo - free/libre analytics platform |
| 4 | * |
| 5 | * @link https://matomo.org |
| 6 | * @license http://www.gnu.org/licenses/gpl-3.0.html GPL v3 or later |
| 7 | * |
| 8 | */ |
| 9 | |
| 10 | namespace Piwik\Updates; |
| 11 | |
| 12 | use Piwik\ArchiveProcessor\Rules; |
| 13 | use Piwik\Common; |
| 14 | use Piwik\DataAccess\ArchiveTableCreator; |
| 15 | use Piwik\Db; |
| 16 | use Piwik\Plugins\SitesManager\Model; |
| 17 | use Piwik\Plugins\VisitFrequency\API as VisitFrequencyAPI; |
| 18 | use Piwik\Segment; |
| 19 | use Piwik\Segment\SegmentExpression; |
| 20 | use Piwik\Updater; |
| 21 | use Piwik\Updates as PiwikUpdates; |
| 22 | use Piwik\Updater\Migration; |
| 23 | use Piwik\Updater\Migration\Factory as MigrationFactory; |
| 24 | |
| 25 | /** |
| 26 | * Update for version 4.6.0-b2. |
| 27 | */ |
| 28 | class Updates_4_6_0_b4 extends PiwikUpdates |
| 29 | { |
| 30 | /** |
| 31 | * @var MigrationFactory |
| 32 | */ |
| 33 | private $migration; |
| 34 | |
| 35 | public function __construct(MigrationFactory $factory) |
| 36 | { |
| 37 | $this->migration = $factory; |
| 38 | } |
| 39 | |
| 40 | /** |
| 41 | * @param Updater $updater |
| 42 | * @return Migration\Db[] |
| 43 | */ |
| 44 | public function getMigrations(Updater $updater) |
| 45 | { |
| 46 | $migrations = []; |
| 47 | $sites = new Model(); |
| 48 | $idSites = $sites->getSitesId(); |
| 49 | |
| 50 | $doneFlagsToMigrate = []; |
| 51 | foreach ($idSites as $idSite) { |
| 52 | $segmentStrings = Rules::getSegmentsToProcess([$idSite]); |
| 53 | |
| 54 | foreach ($segmentStrings as $segmentString) { |
| 55 | try { |
| 56 | $segment = new Segment($segmentString, [$idSite]); |
| 57 | } catch (\Exception $e) { |
| 58 | continue; |
| 59 | } |
| 60 | if ($segment->getOriginalString() === $segment->getString()) { |
| 61 | continue; |
| 62 | } |
| 63 | |
| 64 | $segmentsToAppend = [VisitFrequencyAPI::NEW_VISITOR_SEGMENT, VisitFrequencyAPI::RETURNING_VISITOR_SEGMENT]; |
| 65 | foreach ($segmentsToAppend as $segmentToAppend) { |
| 66 | // we need to migrate the existing archive |
| 67 | $oldSegmentString = Segment::combine($segment->getString(), SegmentExpression::AND_DELIMITER, $segmentToAppend); |
| 68 | $newSegmentString = Segment::combine($segment->getOriginalString(), SegmentExpression::AND_DELIMITER, $segmentToAppend); |
| 69 | $oldSegmentHash = Segment::getSegmentHash($oldSegmentString); |
| 70 | $newSegmentHash = Segment::getSegmentHash($newSegmentString); |
| 71 | |
| 72 | if ($oldSegmentHash === $newSegmentHash) { |
| 73 | continue; |
| 74 | } |
| 75 | |
| 76 | $doneFlagsToMigrate['done' . $oldSegmentHash . '.Goals'] = 'done' . $newSegmentHash . '.Goals'; |
| 77 | $doneFlagsToMigrate['done' . $oldSegmentHash . '.VisitsSummary'] = 'done' . $newSegmentHash . '.VisitsSummary'; |
| 78 | $doneFlagsToMigrate['done' . $oldSegmentHash . '.UserCountry'] = 'done' . $newSegmentHash . '.UserCountry'; |
| 79 | } |
| 80 | } |
| 81 | } |
| 82 | |
| 83 | if (!empty($doneFlagsToMigrate)) { |
| 84 | foreach (ArchiveTableCreator::getTablesArchivesInstalled() as $table) { |
| 85 | if (strpos($table, 'numeric') === false) { |
| 86 | continue; |
| 87 | } |
| 88 | |
| 89 | $sqlPlaceholders = Common::getSqlStringFieldsArray($doneFlagsToMigrate); |
| 90 | $bind = array_keys($doneFlagsToMigrate); |
| 91 | |
| 92 | $selectSql = sprintf('SELECT 1 FROM %s where `name` in (%s) LIMIT 1', $table, $sqlPlaceholders); |
| 93 | $archiveTableHasDoneFlags = Db::fetchOne($selectSql, $bind); |
| 94 | if (!$archiveTableHasDoneFlags) { |
| 95 | continue; |
| 96 | } |
| 97 | |
| 98 | $sql = 'update ' . $table . ' set `name` = (case'; |
| 99 | foreach ($doneFlagsToMigrate as $oldDoneFlag => $newDoneFlag) { |
| 100 | $sql .= " when `name` = '$oldDoneFlag' then '$newDoneFlag' "; |
| 101 | } |
| 102 | $sql .= ' else `name` end) where `name` in (' . $sqlPlaceholders . ')'; |
| 103 | |
| 104 | Db::query($sql, $bind); |
| 105 | $migrations[] = $this->migration->db->boundSql($sql, $bind, [Migration\Db\Sql::ERROR_CODE_DUPLICATE_ENTRY]); |
| 106 | } |
| 107 | } |
| 108 | |
| 109 | return $migrations; |
| 110 | } |
| 111 | |
| 112 | /** |
| 113 | * @param Updater $updater |
| 114 | */ |
| 115 | public function doUpdate(Updater $updater) |
| 116 | { |
| 117 | $updater->executeMigrations(__FILE__, $this->getMigrations($updater)); |
| 118 | } |
| 119 | } |
| 120 |