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
|
<?php
/**
* Matomo - free/libre analytics platform
*
* @link https://matomo.org
* @license http://www.gnu.org/licenses/gpl-3.0.html GPL v3 or later
*/
namespace Piwik\Plugins\CoreAdminHome\Commands;
use Piwik\Common;
use Piwik\Config;
use Piwik\Container\StaticContainer;
use Piwik\Date;
use Piwik\Db;
use Piwik\Plugin\ConsoleCommand;
use Piwik\Plugins\UsersManager\Model;
use Piwik\Updater;
use Piwik\Updater\Migration\Factory as MigrationFactory;
use Symfony\Component\Console\Input\InputArgument;
use Symfony\Component\Console\Input\InputInterface;
use Symfony\Component\Console\Output\OutputInterface;
/**
* Command to selectively delete visits.
*/
class MigrateTokenAuths extends ConsoleCommand
{
protected function configure()
{
$this->setName('core:matomo4-migrate-token-auths');
$this->setDescription('Only needed for the matomo 3 to matomo 4 migration');
}
protected function execute(InputInterface $input, OutputInterface $output)
{
self::migrate();
$output->writeln('Done');
}
public static function migrate()
{
$migration = StaticContainer::get(MigrationFactory::class);
/** APP SPECIFIC TOKEN START */
$migrations[] = $migration->db->createTable('user_token_auth', array(
'idusertokenauth' => 'BIGINT UNSIGNED NOT NULL AUTO_INCREMENT',
'login' => 'VARCHAR(100) NOT NULL',
'description' => 'VARCHAR('.Model::MAX_LENGTH_TOKEN_DESCRIPTION.') NOT NULL',
'password' => 'VARCHAR(191) NOT NULL',
'system_token' => 'TINYINT(1) NOT NULL DEFAULT 0',
'hash_algo' => 'VARCHAR(30) NOT NULL',
'last_used' => 'DATETIME NULL',
'date_created' => ' DATETIME NOT NULL',
'date_expired' => ' DATETIME NULL',
), 'idusertokenauth');
$migrations[] = $migration->db->addUniqueKey('user_token_auth', 'password', 'uniq_password');
$migrations[] = $migration->db->dropIndex('user', 'uniq_keytoken');
$userModel = new Model();
foreach ($userModel->getUsers(array()) as $user) {
if (!empty($user['token_auth'])) {
$migrations[] = $migration->db->insert('user_token_auth', array(
'login' => $user['login'],
'description' => 'Created by Matomo 4 migration',
'password' => $userModel->hashTokenAuth($user['token_auth']),
'date_created' => Date::now()->getDatetime(),
'hash_algo' => 'sha512'
));
}
}
$migrations[] = $migration->db->dropColumn('user', 'token_auth');
$updater = StaticContainer::get(Updater::class);
$updater->executeMigrations(__FILE__, $migrations);
}
}
|
