eZ\Publish\Core\Persistence\Legacy\Tests\UserPreference\Gateway\DoctrineDatabaseTest

Complexity

Total Complexity

7

Size/Duplication

Total Lines	132
Duplicated Lines	12.88 %

Coupling/Cohesion

Components	1
Dependencies	8

Importance

Changes

0

7 Methods

Rating	Name	Duplication	Size	Complexity
A	setUp()	0	8	1
A	testInsert()	17	17	1
A	testUpdateUserPreference()	0	17	1
A	testCountUserPreferences()	0	6	1
A	testLoadUserPreferences()	0	23	1
A	getGateway()	0	6	1
A	loadUserPreference()	0	16	1

<?php

/**
 * @copyright Copyright (C) eZ Systems AS. All rights reserved.
 * @license For full copyright and license information view LICENSE file distributed with this source code.
 */
declare(strict_types=1);

namespace eZ\Publish\Core\Persistence\Legacy\Tests\UserPreference\Gateway;

use Doctrine\DBAL\FetchMode;
use Doctrine\DBAL\ParameterType;
use eZ\Publish\Core\Persistence\Legacy\UserPreference\Gateway;
use eZ\Publish\Core\Persistence\Legacy\UserPreference\Gateway\DoctrineDatabase;
use eZ\Publish\Core\Persistence\Legacy\Tests\TestCase;
use eZ\Publish\SPI\Persistence\UserPreference\UserPreferenceSetStruct;

class DoctrineDatabaseTest extends TestCase
{
    const EXISTING_USER_PREFERENCE_ID = 1;
    const EXISTING_USER_PREFERENCE_DATA = [
        'id' => 1,
        'user_id' => 14,
        'name' => 'timezone',
        'value' => 'America/New_York',
    ];

    public function setUp()
    {
        parent::setUp();

        $this->insertDatabaseFixture(
            __DIR__ . '/../_fixtures/user_preferences.php'
        );
    }

    /**
     * @covers \eZ\Publish\Core\Persistence\Legacy\UserPreference\Gateway::setUserPreference()
     */
    public function testInsert()
    {
        $id = $this->getGateway()->setUserPreference(new UserPreferenceSetStruct([
            'userId' => 14,
            'name' => 'setting_3',
            'value' => 'value_3',
        ]));

        $data = $this->loadUserPreference($id);

        $this->assertEquals([
            'id' => $id,
            'user_id' => '14',
            'name' => 'setting_3',
            'value' => 'value_3',
        ], $data);
    }

    /**
     * @covers \eZ\Publish\Core\Persistence\Legacy\UserPreference\Gateway::setUserPreference()
     */
    public function testUpdateUserPreference()
    {
        $userPreference = new UserPreferenceSetStruct([
            'userId' => 14,
            'name' => 'timezone',
            'value' => 'Europe/Warsaw',
        ]);

        $this->getGateway()->setUserPreference($userPreference);

        $this->assertEquals([
            'id' => (string) self::EXISTING_USER_PREFERENCE_ID,
            'user_id' => '14',
            'name' => 'timezone',
            'value' => 'Europe/Warsaw',
        ], $this->loadUserPreference(self::EXISTING_USER_PREFERENCE_ID));
    }

    /**
     * @covers \eZ\Publish\Core\Persistence\Legacy\UserPreference\Gateway::countUserPreferences()
     */
    public function testCountUserPreferences()
    {
        $this->assertEquals(3, $this->getGateway()->countUserPreferences(
            self::EXISTING_USER_PREFERENCE_DATA['user_id']
        ));
    }

    /**
     * @covers \eZ\Publish\Core\Persistence\Legacy\UserPreference\Gateway::loadUserPreferences()
     */
    public function testLoadUserPreferences()
    {
        $userId = 14;
        $offset = 1;
        $limit = 2;

        $results = $this->getGateway()->loadUserPreferences($userId, $offset, $limit);

        $this->assertEquals([
            [
                'id' => '2',
                'user_id' => '14',
                'name' => 'setting_1',
                'value' => 'value_1',
            ],
            [
                'id' => '3',
                'user_id' => '14',
                'name' => 'setting_2',
                'value' => 'value_2',
            ],
        ], $results);
    }

    /**
     * Return a ready to test DoctrineStorage gateway.
     *
     * @return \eZ\Publish\Core\Persistence\Legacy\UserPreference\Gateway
     */
    protected function getGateway(): Gateway
    {
        return new DoctrineDatabase(
            $this->getDatabaseHandler()->getConnection()
        );
    }

    /**
     * @param int $id
     *
     * @return array
     */
    private function loadUserPreference(int $id): array
    {
        $queryBuilder = $this->connection->createQueryBuilder();
        $queryBuilder
            ->select('id', 'user_id', 'name', 'value')
            ->from('ezpreferences', 'p')
            ->where(
                $queryBuilder->expr()->eq(
                    'p.id',
                    $queryBuilder->createPositionalParameter($id, ParameterType::INTEGER)
                )
            );
        $result = $queryBuilder->execute()->fetchAll(FetchMode::ASSOCIATIVE);

        return reset($result);
    }
}