Newer
Older
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
<?php
/**
* Piwik - free/libre analytics platform
*
* @link http://piwik.org
* @license http://www.gnu.org/licenses/gpl-3.0.html GPL v3 or later
*/
namespace Piwik\Tests\System;
use Piwik\Common;
use Piwik\Db;
use Piwik\Tests\Framework\TestCase\SystemTestCase;
use Piwik\Tests\Fixtures\OneVisitorTwoVisits;
/**
* Simulates the case where there are more than 4 billion visits and pages, and check that Piwik
* can handle this use case without hitting MySQL INT UNSIGNED overflow.
*
* This system test will compare against the OneVisitorTwoVisitsWithCookieSupportTest system test
* (OneVisitorTwoVisits_withCookieSupport* expected api responses) and expect the same API responses.
*
* @group SimulateAutoIncrementIntegerOverflowTest
* @group Core
*/
class SimulateAutoIncrementIntegerOverflowTest extends SystemTestCase
{
/** OneVisitorTwoVisits */
public static $fixture = null; // initialized below class
/**
* @dataProvider getApiForTesting
*/
public function testApi($api, $params)
{
$this->runApiTests($api, $params);
$this->checkAutoIncrementIdsAreMoreThanFourBillion();
}
private function checkAutoIncrementIdsAreMoreThanFourBillion()
{
$fieldsThatShouldNotOverflow = array(
'log_visit' => 'idvisit',
'log_link_visit_action' => 'idlink_va'
);
$this->assertGreaterThan(4294967294, self::$fixture->maxUnsignedIntegerValue);
foreach($fieldsThatShouldNotOverflow as $table => $autoIncrementField) {
$table = Common::prefixTable($table);
$value = Db::fetchOne("SELECT MAX($autoIncrementField) FROM $table ");
$this->assertGreaterThan(self::$fixture->maxUnsignedIntegerValue, $value, 'in ' . $table);
}
}
public function getApiForTesting()
{
$apiToCall = array(
'VisitTime', 'VisitsSummary', 'VisitorInterest', 'VisitFrequency', 'DevicesDetection',
'UserCountry',
'Provider', 'Goals', 'CustomVariables', 'CoreAdminHome', 'DevicePlugins',
'Actions', 'Referrers',
);
return array(
array($apiToCall, array(
'idSite' => self::$fixture->idSite,
'date' => self::$fixture->dateTime,
'compareAgainst' => 'OneVisitorTwoVisits_withCookieSupport',
))
);
}
}
SimulateAutoIncrementIntegerOverflowTest::$fixture = new OneVisitorTwoVisits();
SimulateAutoIncrementIntegerOverflowTest::$fixture->useThirdPartyCookies = true;
SimulateAutoIncrementIntegerOverflowTest::$fixture->useSiteSearch = true;
SimulateAutoIncrementIntegerOverflowTest::$fixture->simulateIntegerOverflow = true;