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
|
<?php
/**
* Piwik - 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\tests\Integration\Commands;
use Piwik\DataAccess\ArchiveTableCreator;
use Piwik\Date;
use Piwik\Tests\Framework\TestCase\ConsoleCommandTestCase;
/**
* @group Core
*/
class OptimizeArchiveTablesTest extends ConsoleCommandTestCase
{
public static function setUpBeforeClass(): void
{
parent::setUpBeforeClass();
ArchiveTableCreator::getNumericTable(Date::factory('2015-01-01'));
ArchiveTableCreator::getNumericTable(Date::factory('2015-02-02'));
ArchiveTableCreator::getNumericTable(Date::factory('2015-03-03'));
}
/**
* @dataProvider getDatesToTest
*/
public function test_Command_OptimizesCorrectTables($dates, $expectedOptimizedTableDates)
{
$code = $this->applicationTester->run(array(
'command' => 'database:optimize-archive-tables',
'dates' => $dates,
'--dry-run' => true,
));
$this->assertEquals(0, $code, $this->getCommandDisplayOutputErrorMessage());
$output = $this->applicationTester->getDisplay();
preg_match_all('/Optimizing table \'([^\']+)\'/', $output, $matches);
$tablesOptimized = $matches[1];
$expectedOptimizedTables = array();
foreach ($expectedOptimizedTableDates as $date) {
$expectedOptimizedTables[] = 'archive_numeric_' . $date;
$expectedOptimizedTables[] = 'archive_blob_' . $date;
}
$this->assertEquals($expectedOptimizedTables, $tablesOptimized);
}
public function getDatesToTest()
{
return array(
array(
array('all'),
array('2015_01', '2015_02', '2015_03'),
),
array(
array('now'),
array(date('Y_m')),
),
array(
array('2015-01-01', '2015-02-03', '2014-01-01', '2013-05-12', '2015-05-05'),
array('2015_01', '2015_02', '2014_01', '2013_05', '2015_05'),
),
array(
array('last1'),
array(Date::factory('now')->subMonth(1)->toString('Y_m')),
),
array(
array('last5'),
array(
Date::factory('now')->subMonth(1)->toString('Y_m'),
Date::factory('now')->subMonth(2)->toString('Y_m'),
Date::factory('now')->subMonth(3)->toString('Y_m'),
Date::factory('now')->subMonth(4)->toString('Y_m'),
Date::factory('now')->subMonth(5)->toString('Y_m'),
),
),
array(
array('2015-01-01'),
array('2015_01'),
),
);
}
}
|
