1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
|
<?php
/**
* Matomo - free/libre analytics platform
*
* @link https://matomo.org
* @license https://www.gnu.org/licenses/gpl-3.0.html GPL v3 or later
*/
namespace Piwik\Updates;
use Piwik\Common;
use Piwik\Config;
use Piwik\Container\StaticContainer;
use Piwik\DataAccess\ArchiveTableCreator;
use Piwik\Db;
use Piwik\Updater;
use Piwik\Updater\Migration\Factory as MigrationFactory;
use Piwik\Updates;
class Updates_5_2_0_b2 extends Updates
{
/**
* @var MigrationFactory
*/
private $migration;
public function __construct(MigrationFactory $factory)
{
$this->migration = $factory;
}
public function getMigrations(Updater $updater)
{
$migrations = [];
$config = Config::getInstance();
$dbConfig = $config->database;
// only run migration if config is not set
if (empty($dbConfig['collation'])) {
$collation = $this->detectCollationForMigration();
if (null !== $collation) {
$migrations[] = $this->migration->config->set(
'database',
'collation',
$collation
);
}
}
return $migrations;
}
public function doUpdate(Updater $updater)
{
$updater->executeMigrations(__FILE__, $this->getMigrations($updater));
}
private function detectCollationForMigration(): ?string
{
try {
$db = Db::get();
$metadataProvider = StaticContainer::get('Piwik\Plugins\DBStats\MySQLMetadataProvider');
$userTableStatus = $metadataProvider->getTableStatus('user');
if (empty($userTableStatus['Collation'] ?? null)) {
// if there is no user table, or no collation for it, abort detection
// this table should always exist and something must be wrong in this case
return null;
}
$userTableCollation = $userTableStatus['Collation'];
$connectionCollation = $db->fetchOne('SELECT @@collation_connection');
if ($userTableCollation === $connectionCollation) {
// if the connection is matching the user table
// we should be safe to assume we have already found a config value
return $userTableCollation;
}
$archiveTable = ArchiveTableCreator::getLatestArchiveTableInstalled(ArchiveTableCreator::NUMERIC_TABLE);
if (null === $archiveTable) {
return null;
}
$archiveTableStatus = $metadataProvider->getTableStatus(Common::unprefixTable($archiveTable));
if (
!empty($archiveTableStatus['Collation'])
&& $archiveTableStatus['Collation'] === $userTableCollation
) {
// the most recent numeric archive table is matching the collation
// of the users table, should be a good config value to choose
return $userTableCollation;
}
} catch (\Exception $e) {
// rely on the system check if detection failed
}
return null;
}
}
|
