File size: 2,785 Bytes
bf8c0ce | 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 | <?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\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(): void
{
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 testPiwikApiWorksWhenDuplicateActionsExistInDb($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' => OneVisitorTwoVisits::getValueForHideColumns(),
),
)),
);
}
public function provideContainerConfig()
{
return array(
'Piwik\Config' => \Piwik\DI::decorate(function ($previous) {
$general = $previous->General;
$general['action_title_category_delimiter'] = "/";
$previous->General = $general;
return $previous;
}),
);
}
}
DuplicateActionsTest::$fixture = new OneVisitorTwoVisits();
|