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
98
99
100
101
102
103
104
105
106
107
|
<?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\Plugins\Goals\tests\System;
use Piwik\Common;
use Piwik\Date;
use Piwik\Db;
use Piwik\Tests\Fixtures\SomePageGoalVisitsWithConversions;
use Piwik\Tests\Framework\TestCase\ConsoleCommandTestCase;
/**
* @group CalculateConversionPagesCommandTest
* @group Goals
* @group Plugins
*/
class CalculateConversionPagesCommandTest extends ConsoleCommandTestCase
{
/**
* @var SomePageGoalVisitsWithConversions
*/
public static $fixture = null;
public function testCommandSuccessfullyCalculatesForDateRange()
{
$this->unsetPageviewsBefore();
$this->applicationTester->setInputs(["N\n"]);
$result = $this->applicationTester->run([
'command' => 'core:calculate-conversion-pages',
'--dates' => '2009-01-05,2009-01-31',
'--idsite' => self::$fixture->idSite,
'-vvv' => true,
]);
// Check command completed ok
$this->assertEquals(0, $result, $this->getCommandDisplayOutputErrorMessage());
// Check conversions have been calculated
$this->checkPageviewsBeforeValid();
}
public function testCommandSuccessfullyCalculatesForLastN()
{
$this->unsetPageviewsBefore();
$this->applicationTester->setInputs(["N\n"]);
$result = $this->applicationTester->run([
'command' => 'core:calculate-conversion-pages',
'--last-n' => 2,
'--idsite' => self::$fixture->idSite,
'-vvv' => true,
]);
// Check command completed ok
$this->assertEquals(0, $result, $this->getCommandDisplayOutputErrorMessage());
// Check conversions have been calculated
$this->checkPageviewsBeforeValid('2009-01-06 07:54:00');
}
/**
* Set all pageviews before value to null
*
* @throws \Exception
*/
private function unsetPageviewsBefore(): void
{
Db::query(
'UPDATE ' . Common::prefixTable('log_conversion') . ' SET pageviews_before = NULL WHERE idsite = ?',
[self::$fixture->idSite]
);
}
/**
* Check that the log_conversion.pageviews_before column was correctly calculated
*
*
* @throws \Exception
*/
public function checkPageviewsBeforeValid(?string $onlyToDate = null): void
{
$expectedValues = TrackGoalsPagesTest::getConversionPagesBeforeExpected();
foreach ($expectedValues as $expected) {
$values = Db::get()->fetchAssoc('SELECT server_time, pageviews_before FROM ' . Common::prefixTable('log_conversion') .
' WHERE idlink_va = ?', [$expected['id']]);
$row = reset($values);
// If the 'only to date' parameter is passed then expect only conversions up to that date to be have been
// processed
if ($onlyToDate === null || Date::factory($row['server_time'])->getTimestamp() >= Date::factory($onlyToDate)->getTimestamp()) {
$this->assertEquals($expected['expected'], $row['pageviews_before']);
} else {
$this->assertEquals(null, $row['pageviews_before']);
}
}
}
}
CalculateConversionPagesCommandTest::$fixture = new SomePageGoalVisitsWithConversions();
|
