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
|
<?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\Fixtures\OneVisitorTwoVisits;
use Piwik\Tests\Framework\TestCase\SystemTestCase;
/**
* The tracker inserts actions in separate SQL queries which can cause
* duplicate actions to be in the DB (actions w/ the same name, hash + type, but
* different idaction). The tracker will delete duplicate actions, but
* if for some reason the tracker fails before the DELETE occurs, there can be
* stray duplicate actions. This test is there to ensure reports are not affected
* by duplicate action entries.
*
* @group Core
* @group DuplicateActionsTest
*/
class DuplicateActionsTest extends SystemTestCase
{
/**
* @var OneVisitorTwoVisits
*/
public static $fixture = null; // initialized below class
public static function setUpBeforeClass()
{
parent::setUpBeforeClass();
// add duplicates for every action
$table = Common::prefixTable('log_action');
foreach (Db::fetchAll("SELECT * FROM $table") as $row) {
$insertSql = "INSERT INTO $table (name, type, hash, url_prefix)
VALUES (?, ?, CRC32(?), ?)";
Db::query($insertSql, array($row['name'], $row['type'], $row['name'], $row['url_prefix']));
}
}
/**
* @dataProvider getApiForTesting
*/
public function test_PiwikApiWorks_WhenDuplicateActionsExistInDb($api, $params)
{
$this->runApiTests($api, $params);
}
public function getApiForTesting()
{
$idSite = self::$fixture->idSite;
$dateTime = self::$fixture->dateTime;
$api = array('VisitsSummary', 'Actions', 'Contents', 'Events');
return array(
array($api, array('idSite' => $idSite,
'periods' => 'day',
'date' => $dateTime,
'compareAgainst' => 'OneVisitorTwoVisits',
'otherRequestParameters' => array(
'hideColumns' => OneVisitorTwoVisitsTest::getValueForHideColumns(),
)
))
);
}
}
DuplicateActionsTest::$fixture = new OneVisitorTwoVisits();
DuplicateActionsTest::$fixture->excludeMozilla = true;
|
