VisibleOnlyTest::getMockExpression() - Code Metrics - Inspection of "EZP-30973: Made siteaccess aware repository to be..." - ezsystems/ezpublish-kernel - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — ezp_30973 ( 1b82fd...a5777c )

unknown

created 2019-10-25 08:13 UTC

VisibleOnlyTest::getMockExpression() B

↳ Parent: VisibleOnlyTest

Complexity

Conditions	4
Paths	8

Size

Total Lines

Duplication

Lines	38
Ratio	64.41 %

Importance

Changes

Metric	Value
cc	4
nc	8
nop	3
dl	38
loc	59
rs	8.8945
c	0
b	0
f	0

How to fix Long Method

<?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.
 */
namespace eZ\Publish\Core\Persistence\Legacy\Tests\URL\Query\CriterionHandler;

use eZ\Publish\API\Repository\Values\URL\Query\Criterion\VisibleOnly;
use eZ\Publish\API\Repository\Values\URL\Query\Criterion;
use eZ\Publish\Core\Persistence\Database\Expression;
use eZ\Publish\Core\Persistence\Database\SelectQuery;
use eZ\Publish\Core\Persistence\Legacy\URL\Query\CriteriaConverter;
use eZ\Publish\Core\Persistence\Legacy\URL\Query\CriterionHandler\VisibleOnly as VisibleOnlyHandler;

class VisibleOnlyTest extends CriterionHandlerTest
{
    /**
     * {@inheritdoc}
     */
    public function testAccept()
    {
        $handler = new VisibleOnlyHandler();

        $this->assertHandlerAcceptsCriterion($handler, VisibleOnly::class);
        $this->assertHandlerRejectsCriterion($handler, Criterion::class);
    }

    /**
     * {@inheritdoc}
     */
    public function testHandle()
    {
        $expected = 'ezcontentobject_tree.is_invisible = 0';

        $basicQuery = $this->createMock(SelectQuery::class);
        $basicQuery->method('bindValue')->with(0, null, \PDO::PARAM_INT)->willReturn('0');


        $converter = $this->createMock(CriteriaConverter::class);
        $handler = new VisibleOnlyHandler();
        $criterion = new VisibleOnly();

        // tables not joined yet - handle should join them
        $query = clone $basicQuery;
        $query->expr = $this->getMockExpression(true, true, true);
        $query->method('getQuery')->willReturn('SELECT');

        $actual = $handler->handle($converter, $query, $criterion);
        $this->assertEquals($expected, $actual);

        // table link already joined, should not join again
        $query = clone $basicQuery;
        $query->expr = $this->getMockExpression(false, true, true);
        $query->method('getQuery')->willReturn('(SELECT) INNER JOIN ezurl_object_link (ON)');

        $actual = $handler->handle($converter, $query, $criterion);
        $this->assertEquals($expected, $actual);

        // table link and attribute already joined, should not join again
        $query = clone $basicQuery;
        $query->expr = $this->getMockExpression(false, false, true);
        $query->method('getQuery')->willReturn(

            '(SELECT) INNER JOIN ezurl_object_link (ON) '
            . 'INNER JOIN ezcontentobject_attribute (ON)'
        );
        $actual = $handler->handle($converter, $query, $criterion);
        $this->assertEquals($expected, $actual);

        // table link, attribute, and tree already joined, should not join again
        $query = clone $basicQuery;
        $query->expr = $this->getMockExpression(false, false, false);
        $query->method('getQuery')->willReturn(

            '(SELECT) INNER JOIN ezurl_object_link (ON) ' .
            'INNER JOIN ezcontentobject_attribute (ON) ' .
            'INNER JOIN ezcontentobject_tree (ON)'
        );
        $actual = $handler->handle($converter, $query, $criterion);
        $this->assertEquals($expected, $actual);
    }

    /**
     * @param bool $includeLinkJoin
     * @param bool $includeAttributeJoin
     * @param bool $includeTreeJoin
     * @return \PHPUnit\Framework\MockObject\MockObject
     */
    private function getMockExpression(bool $includeLinkJoin, bool $includeAttributeJoin, bool $includeTreeJoin)
    {
        $execAt = 0;
        $expr = $this->createMock(Expression::class);
        if ($includeLinkJoin) {
            $expr
                ->expects($this->at($execAt++))
                ->method('eq')
                ->with('ezurl.id', 'ezurl_object_link.url_id')
                ->willReturn('ezurl.id=ezurl_object_link.url_id');
        }
        if ($includeAttributeJoin) {

            $expr
                ->expects($this->at($execAt++))
                ->method('eq')
                ->with('ezurl_object_link.contentobject_attribute_id', 'ezcontentobject_attribute.id')
                ->willReturn('ezurl_object_link.contentobject_attribute_id = ezcontentobject_attribute.id');
            $expr
                ->expects($this->at($execAt++))
                ->method('eq')
                ->with('ezurl_object_link.contentobject_attribute_version', 'ezcontentobject_attribute.version')
                ->willReturn('ezurl_object_link.contentobject_attribute_version = ezcontentobject_attribute.version');
            $expr
                ->expects($this->at($execAt++))
                ->method('lAnd')
                ->with(
                    'ezurl_object_link.contentobject_attribute_id = ezcontentobject_attribute.id',
                    'ezurl_object_link.contentobject_attribute_version = ezcontentobject_attribute.version'
                )->willReturn('ezurl_object_link.contentobject_attribute_id = ezcontentobject_attribute.id AND ezurl_object_link.contentobject_attribute_version = ezcontentobject_attribute.version');
        }

        if ($includeTreeJoin) {

            $expr
                ->expects($this->at($execAt++))
                ->method('eq')
                ->with('ezcontentobject_tree.contentobject_id', 'ezcontentobject_attribute.contentobject_id')
                ->willReturn('ezcontentobject_tree.contentobject_id = ezcontentobject_attribute.contentobject_id');
            $expr
                ->expects($this->at($execAt++))
                ->method('eq')
                ->with('ezcontentobject_tree.contentobject_version', 'ezcontentobject_attribute.version')
                ->willReturn('ezcontentobject_tree.contentobject_version = ezcontentobject_attribute.version');
            $expr
                ->expects($this->at($execAt++))
                ->method('lAnd')
                ->with(
                    'ezcontentobject_tree.contentobject_id = ezcontentobject_attribute.contentobject_id',
                    'ezcontentobject_tree.contentobject_version = ezcontentobject_attribute.version'
                )->willReturn('ezcontentobject_tree.contentobject_id = ezcontentobject_attribute.contentobject_id AND ezcontentobject_tree.contentobject_version = ezcontentobject_attribute.version');
        }

        $expr
            ->expects($this->at($execAt))
            ->method('eq')
            ->with('ezcontentobject_tree.is_invisible', '0')
            ->willReturn('ezcontentobject_tree.is_invisible = 0');

        return $expr;
    }
}


1		<?php
2
3		/**
4		* @copyright Copyright (C) eZ Systems AS. All rights reserved.
5		* @license For full copyright and license information view LICENSE file distributed with this source code.
6		*/
7		namespace eZ\Publish\Core\Persistence\Legacy\Tests\URL\Query\CriterionHandler;
8
9		use eZ\Publish\API\Repository\Values\URL\Query\Criterion\VisibleOnly;
10		use eZ\Publish\API\Repository\Values\URL\Query\Criterion;
11		use eZ\Publish\Core\Persistence\Database\Expression;
12		use eZ\Publish\Core\Persistence\Database\SelectQuery;
13		use eZ\Publish\Core\Persistence\Legacy\URL\Query\CriteriaConverter;
14		use eZ\Publish\Core\Persistence\Legacy\URL\Query\CriterionHandler\VisibleOnly as VisibleOnlyHandler;
15
16		class VisibleOnlyTest extends CriterionHandlerTest
17		{
18		/**
19		* {@inheritdoc}
20		*/
21		public function testAccept()
22		{
23		$handler = new VisibleOnlyHandler();
24
25		$this->assertHandlerAcceptsCriterion($handler, VisibleOnly::class);
26		$this->assertHandlerRejectsCriterion($handler, Criterion::class);
27		}
28
29		/**
30		* {@inheritdoc}
31		*/
32		public function testHandle()
33		{
34		$expected = 'ezcontentobject_tree.is_invisible = 0';
35
36		$basicQuery = $this->createMock(SelectQuery::class);
37		$basicQuery->method('bindValue')->with(0, null, \PDO::PARAM_INT)->willReturn('0');
		0 ignored issues – show Bug introduced 2019-10-22 14:49 UTC by Report Bug Copy Issue Report The method `method()` does not seem to exist on `object<PHPUnit\Framework\MockObject\MockObject>`. This check looks for calls to methods that do not seem to exist on a given type. It looks for the method on the type itself as well as in inherited classes or implemented interfaces. This is most likely a typographical error or the method has been renamed. Loading history...
38
39		$converter = $this->createMock(CriteriaConverter::class);
40		$handler = new VisibleOnlyHandler();
41		$criterion = new VisibleOnly();
42
43		// tables not joined yet - handle should join them
44		$query = clone $basicQuery;
45		$query->expr = $this->getMockExpression(true, true, true);
46		$query->method('getQuery')->willReturn('SELECT');
		0 ignored issues – show Bug introduced 2019-10-22 14:49 UTC by Report Bug Copy Issue Report The method `method()` does not seem to exist on `object<PHPUnit\Framework\MockObject\MockObject>`. This check looks for calls to methods that do not seem to exist on a given type. It looks for the method on the type itself as well as in inherited classes or implemented interfaces. This is most likely a typographical error or the method has been renamed. Loading history...
47		$actual = $handler->handle($converter, $query, $criterion);
48		$this->assertEquals($expected, $actual);
49
50		// table link already joined, should not join again
51		$query = clone $basicQuery;
52		$query->expr = $this->getMockExpression(false, true, true);
53		$query->method('getQuery')->willReturn('(SELECT) INNER JOIN ezurl_object_link (ON)');
		0 ignored issues – show Bug introduced 2019-10-22 14:49 UTC by Report Bug Copy Issue Report The method `method()` does not seem to exist on `object<PHPUnit\Framework\MockObject\MockObject>`. This check looks for calls to methods that do not seem to exist on a given type. It looks for the method on the type itself as well as in inherited classes or implemented interfaces. This is most likely a typographical error or the method has been renamed. Loading history...
54		$actual = $handler->handle($converter, $query, $criterion);
55		$this->assertEquals($expected, $actual);
56
57		// table link and attribute already joined, should not join again
58		$query = clone $basicQuery;
59		$query->expr = $this->getMockExpression(false, false, true);
60		$query->method('getQuery')->willReturn(
		0 ignored issues – show Bug introduced 2019-10-22 14:49 UTC by Report Bug Copy Issue Report The method `method()` does not seem to exist on `object<PHPUnit\Framework\MockObject\MockObject>`. This check looks for calls to methods that do not seem to exist on a given type. It looks for the method on the type itself as well as in inherited classes or implemented interfaces. This is most likely a typographical error or the method has been renamed. Loading history...
61		'(SELECT) INNER JOIN ezurl_object_link (ON) '
62		. 'INNER JOIN ezcontentobject_attribute (ON)'
63		);
64		$actual = $handler->handle($converter, $query, $criterion);
65		$this->assertEquals($expected, $actual);
66
67		// table link, attribute, and tree already joined, should not join again
68		$query = clone $basicQuery;
69		$query->expr = $this->getMockExpression(false, false, false);
70		$query->method('getQuery')->willReturn(
		0 ignored issues – show Bug introduced 2019-10-22 14:49 UTC by Report Bug Copy Issue Report The method `method()` does not seem to exist on `object<PHPUnit\Framework\MockObject\MockObject>`. This check looks for calls to methods that do not seem to exist on a given type. It looks for the method on the type itself as well as in inherited classes or implemented interfaces. This is most likely a typographical error or the method has been renamed. Loading history...
71		'(SELECT) INNER JOIN ezurl_object_link (ON) ' .
72		'INNER JOIN ezcontentobject_attribute (ON) ' .
73		'INNER JOIN ezcontentobject_tree (ON)'
74		);
75		$actual = $handler->handle($converter, $query, $criterion);
76		$this->assertEquals($expected, $actual);
77		}
78
79		/**
80		* @param bool $includeLinkJoin
81		* @param bool $includeAttributeJoin
82		* @param bool $includeTreeJoin
83		* @return \PHPUnit\Framework\MockObject\MockObject
84		*/
85		private function getMockExpression(bool $includeLinkJoin, bool $includeAttributeJoin, bool $includeTreeJoin)
86		{
87		$execAt = 0;
88		$expr = $this->createMock(Expression::class);
89		if ($includeLinkJoin) {
90		$expr
91		->expects($this->at($execAt++))
92		->method('eq')
93		->with('ezurl.id', 'ezurl_object_link.url_id')
94		->willReturn('ezurl.id=ezurl_object_link.url_id');
95		}
96	View Code Duplication	if ($includeAttributeJoin) {
		0 ignored issues – show Duplication introduced 2019-10-22 14:33 UTC by Report Bug Copy Issue Report This code seems to be duplicated across your project. Duplicated code is one of the most pungent code smells. If you need to duplicate the same code in three or more different places, we strongly encourage you to look into extracting the code into a single class or operation. You can also find more detailed suggestions in the “Code” section of your repository. Loading history...
97		$expr
98		->expects($this->at($execAt++))
99		->method('eq')
100		->with('ezurl_object_link.contentobject_attribute_id', 'ezcontentobject_attribute.id')
101		->willReturn('ezurl_object_link.contentobject_attribute_id = ezcontentobject_attribute.id');
102		$expr
103		->expects($this->at($execAt++))
104		->method('eq')
105		->with('ezurl_object_link.contentobject_attribute_version', 'ezcontentobject_attribute.version')
106		->willReturn('ezurl_object_link.contentobject_attribute_version = ezcontentobject_attribute.version');
107		$expr
108		->expects($this->at($execAt++))
109		->method('lAnd')
110		->with(
111		'ezurl_object_link.contentobject_attribute_id = ezcontentobject_attribute.id',
112		'ezurl_object_link.contentobject_attribute_version = ezcontentobject_attribute.version'
113		)->willReturn('ezurl_object_link.contentobject_attribute_id = ezcontentobject_attribute.id AND ezurl_object_link.contentobject_attribute_version = ezcontentobject_attribute.version');
114		}
115
116	View Code Duplication	if ($includeTreeJoin) {
		0 ignored issues – show Duplication introduced 2019-10-22 14:33 UTC by Report Bug Copy Issue Report This code seems to be duplicated across your project. Duplicated code is one of the most pungent code smells. If you need to duplicate the same code in three or more different places, we strongly encourage you to look into extracting the code into a single class or operation. You can also find more detailed suggestions in the “Code” section of your repository. Loading history...
117		$expr
118		->expects($this->at($execAt++))
119		->method('eq')
120		->with('ezcontentobject_tree.contentobject_id', 'ezcontentobject_attribute.contentobject_id')
121		->willReturn('ezcontentobject_tree.contentobject_id = ezcontentobject_attribute.contentobject_id');
122		$expr
123		->expects($this->at($execAt++))
124		->method('eq')
125		->with('ezcontentobject_tree.contentobject_version', 'ezcontentobject_attribute.version')
126		->willReturn('ezcontentobject_tree.contentobject_version = ezcontentobject_attribute.version');
127		$expr
128		->expects($this->at($execAt++))
129		->method('lAnd')
130		->with(
131		'ezcontentobject_tree.contentobject_id = ezcontentobject_attribute.contentobject_id',
132		'ezcontentobject_tree.contentobject_version = ezcontentobject_attribute.version'
133		)->willReturn('ezcontentobject_tree.contentobject_id = ezcontentobject_attribute.contentobject_id AND ezcontentobject_tree.contentobject_version = ezcontentobject_attribute.version');
134		}
135
136		$expr
137		->expects($this->at($execAt))
138		->method('eq')
139		->with('ezcontentobject_tree.is_invisible', '0')
140		->willReturn('ezcontentobject_tree.is_invisible = 0');
141
142		return $expr;
143		}
144		}
145

ezsystems / ezpublish-kernel

Push — ezp_30973 ( 1b82fd...a5777c )

VisibleOnlyTest::getMockExpression() B

Complexity

Size

Duplication

Importance

How to fix Long Method

Long Method

Duplication Side-by-Side

Filter issues like