plugins/CustomDimensions/tests/Integration/SegmentTest.php


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

<?php
/**
 * Matomo - 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\CustomDimensions\tests;

use Piwik\Plugins\CustomDimensions\API;
use Piwik\Segment;
use Piwik\Tests\Framework\Fixture;
use Piwik\Tests\Framework\TestCase\IntegrationTestCase;

class SegmentTest extends IntegrationTestCase
{
    public function setUp(): void
    {
        parent::setUp();

        $idSite = Fixture::createWebsite('2012-02-03');
        API::getInstance()->configureNewCustomDimension($idSite, 'test dim', 'visit', 1);
    }

    public function test_Segment_CanSeeCustomDimensionSegments()
    {
        $select = 'log_visit.idvisit';
        $from = 'log_visit';

        $segmentStr = 'dimension1==5';
        $segment = new Segment($segmentStr, [1]);

        /** @var array $query */
        $query = $segment->getSelectQuery($select, $from);
        $query['sql'] = trim(preg_replace('/\s+/', ' ', $query['sql']));

        $expectedQuery = [
            'sql' => 'SELECT log_visit.idvisit FROM log_visit AS log_visit WHERE log_visit.custom_dimension_1 = ?',
            'bind' => [
                5,
            ],
        ];
        $this->assertEquals($expectedQuery, $query);
    }
}