Query - Code Metrics - Inspection of "Timing::getTrace() enhanced to render paths with D..." - hiqdev/yii2-hiart - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — master ( 9388e4...36fb73 )

by Dmitry

created 2017-03-28 12:59 UTC

Query A

↳ Parent: Project

Complexity

Total Complexity

Size/Duplication

Total Lines	178
Duplicated Lines	14.04 %

Coupling/Cohesion

Components	3
Dependencies	2

Test Coverage

Coverage

34.29%

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
wmc	33
lcom	3
cbo	2
dl	25
loc	178
ccs	24
cts	70
cp	0.3429
rs	9.3999
c	1
b	0
f	0

20 Methods

Rating	Name	Duplication	Size	Complexity
A	instantiate()	0	6	1
A	createCommand()	0	10	2
A	one()	0	4	1
A	searchOne()	0	4	1
A	searchAll()	0	4	1
A	search()	0	4	1
A	delete()	0	4	1
A	count()	0	6	1
A	exists()	0	4	1
A	action()	0	6	1
A	getOption()	0	4	2
A	options()	0	6	1
A	body()	0	6	1
A	innerJoin()	0	6	1
B	all()	5	19	5
A	addAction()	0	8	2
A	addOption()	0	8	2
A	addOptions()	0	8	2
A	fields()	10	10	3
A	source()	10	10	3

How to fix Duplicated Code

<?php
/**
 * ActiveRecord for API
 *
 * @link      https://github.com/hiqdev/yii2-hiart
 * @package   yii2-hiart
 * @license   BSD-3-Clause
 * @copyright Copyright (c) 2015-2017, HiQDev (http://hiqdev.com/)
 */

namespace hiqdev\hiart;

use yii\db\QueryInterface;

/**
 * Query represents API query in a way that is independent from a concrete API.
 * Holds API query information:
 * - general query data
 *      - action: action to be performed with this query, e.g. search, insert, update, delete
 *      - options: other additional options, like
 *          - raw: do not decode response
 *          - batch: batch(bulk) request
 *          - timeout, ...
 * - insert/update query data
 *      - body: insert or update data
 * - select query data
 *      - select: fields to select
 *      - count: marks count query
 *      - from: entity being queried, e.g. user
 *      - join: data how to join with other entities
 * - other standard query options provided with QueryTrait:
 *      - where, limit, offset, orderBy, indexBy.
 */
class Query extends \yii\db\Query implements QueryInterface
{
    /**
     * @var string action that this query performs
     */
    public $action;

    /**
     * @var array query options e.g. raw, batch
     */
    public $options = [];

    public $count;

    public $body = [];

    public static function instantiate($action, $from, array $options = [])
    {
        $query = new static();

        return $query->action($action)->from($from)->options($options);
    }

    /**
     * @param null $db
     * @throws \Exception
     * @return Command
     */
    public function createCommand($db = null)
    {
        if ($db === null) {
            throw new \Exception('no db given to Query::createCommand');
        }

        $commandConfig = $db->getQueryBuilder()->build($this);


        return $db->createCommand($commandConfig);

    }

    public function one($db = null)
    {
        return $this->searchOne($db);
    }

    public function searchOne($db = null)

    {
        return $this->limit(1)->addOption('batch', false)->search();
    }

    public function all($db = null)
    {
        $rows = $this->searchAll();

        if (!empty($rows) && $this->indexBy !== null) {
            $result = [];
            foreach ($rows as $row) {
                if ($this->indexBy instanceof \Closure) {

                    $key = call_user_func($this->indexBy, $row);
                } else {
                    $key = $row[$this->indexBy];
                }
                $result[$key] = $row;
            }
            $rows = $result;
        }

        return $rows;
    }

    public function searchAll($db = null)

    {
        return $this->addOption('batch', true)->search();
    }

    public function search($db = null)
    {
        return $this->createCommand($db)->search();
    }

    public function delete($db = null, $options = [])
    {
        return $this->createCommand($db)->deleteByQuery($options);
class ParentClass {
    private $data = array();

    public function __call($method, array $args) {
        if (0 === strpos($method, 'get')) {
            return $this->data[strtolower(substr($method, 3))];
        }

        throw new \LogicException(sprintf('Unsupported method: %s', $method));
    }
}

/**
 * If this class knows which fields exist, you can specify the methods here:
 *
 * @method string getName()
 */
class SomeClass extends ParentClass { }
    }

    public function count($q = '*', $db = null)
    {
        $this->count = $q;

        return (int) $this->searchAll();
    }

    public function exists($db = null)
    {
        return !empty(self::one($db));
    }

    public function action($action)
    {
        $this->action = $action;

        return $this;
    }

    public function addAction($action)
    {
        if (empty($this->action)) {
            $this->action = $action;
        }

        return $this;
    }

    public function addOption($name, $value)
    {
        if (!isset($this->options[$name])) {
            $this->options[$name] = $value;
        }

        return $this;
    }

    public function getOption($name)
    {
        return isset($this->options[$name]) ? $this->options[$name] : null;
    }

    public function options($options)
    {
        $this->options = $options;

        return $this;
    }

    public function addOptions($options)
    {
        if (!empty($options)) {
            $this->options = array_merge($this->options, $options);
        }

        return $this;
    }

    public function body($body)
    {
        $this->body = $body;

        return $this;
    }

    public function innerJoin($table, $on = '', $params = [])
    {
        $this->join[] = (array) $table;

        return $this;
    }

    public function fields($fields)

    {
        if (is_array($fields) || $fields === null) {
            $this->fields = $fields;
<?php

/**
 * @property int $x
 * @property int $y
 * @property string $text
 */
class MyLabel
{
    private $properties;

    private $allowedProperties = array('x', 'y', 'text');

    public function __get($name)
    {
        if (isset($properties[$name]) && in_array($name, $this->allowedProperties)) {
            return $properties[$name];
        } else {
            return null;
        }
    }

    public function __set($name, $value)
    {
        if (in_array($name, $this->allowedProperties)) {
            $properties[$name] = $value;
        } else {
            throw new \LogicException("Property $name is not defined.");
        }
    }

}
        } else {
            $this->fields = func_get_args();
<?php

/**
 * @property int $x
 * @property int $y
 * @property string $text
 */
class MyLabel
{
    private $properties;

    private $allowedProperties = array('x', 'y', 'text');

    public function __get($name)
    {
        if (isset($properties[$name]) && in_array($name, $this->allowedProperties)) {
            return $properties[$name];
        } else {
            return null;
        }
    }

    public function __set($name, $value)
    {
        if (in_array($name, $this->allowedProperties)) {
            $properties[$name] = $value;
        } else {
            throw new \LogicException("Property $name is not defined.");
        }
    }

}
        }

        return $this;
    }

    public function source($source)

    {
        if (is_array($source) || $source === null) {
            $this->source = $source;
<?php

/**
 * @property int $x
 * @property int $y
 * @property string $text
 */
class MyLabel
{
    private $properties;

    private $allowedProperties = array('x', 'y', 'text');

    public function __get($name)
    {
        if (isset($properties[$name]) && in_array($name, $this->allowedProperties)) {
            return $properties[$name];
        } else {
            return null;
        }
    }

    public function __set($name, $value)
    {
        if (in_array($name, $this->allowedProperties)) {
            $properties[$name] = $value;
        } else {
            throw new \LogicException("Property $name is not defined.");
        }
    }

}
        } else {
            $this->source = func_get_args();
<?php

/**
 * @property int $x
 * @property int $y
 * @property string $text
 */
class MyLabel
{
    private $properties;

    private $allowedProperties = array('x', 'y', 'text');

    public function __get($name)
    {
        if (isset($properties[$name]) && in_array($name, $this->allowedProperties)) {
            return $properties[$name];
        } else {
            return null;
        }
    }

    public function __set($name, $value)
    {
        if (in_array($name, $this->allowedProperties)) {
            $properties[$name] = $value;
        } else {
            throw new \LogicException("Property $name is not defined.");
        }
    }

}
        }

        return $this;
    }
}


1			<?php
2			/**
3			* ActiveRecord for API
4			*
5			* @link https://github.com/hiqdev/yii2-hiart
6			* @package yii2-hiart
7			* @license BSD-3-Clause
8			* @copyright Copyright (c) 2015-2017, HiQDev (http://hiqdev.com/)
9			*/
10
11			namespace hiqdev\hiart;
12
13			use yii\db\QueryInterface;
14
15			/**
16			* Query represents API query in a way that is independent from a concrete API.
17			* Holds API query information:
18			* - general query data
19			* - action: action to be performed with this query, e.g. search, insert, update, delete
20			* - options: other additional options, like
21			* - raw: do not decode response
22			* - batch: batch(bulk) request
23			* - timeout, ...
24			* - insert/update query data
25			* - body: insert or update data
26			* - select query data
27			* - select: fields to select
28			* - count: marks count query
29			* - from: entity being queried, e.g. user
30			* - join: data how to join with other entities
31			* - other standard query options provided with QueryTrait:
32			* - where, limit, offset, orderBy, indexBy.
33			*/
34			class Query extends \yii\db\Query implements QueryInterface
35			{
36			/**
37			* @var string action that this query performs
38			*/
39			public $action;
40
41			/**
42			* @var array query options e.g. raw, batch
43			*/
44			public $options = [];
45
46			public $count;
47
48			public $body = [];
49
50	1		public static function instantiate($action, $from, array $options = [])
51			{
52	1		$query = new static();
53
54	1		return $query->action($action)->from($from)->options($options);
55			}
56
57			/**
58			* @param null $db
59			* @throws \Exception
60			* @return Command
61			*/
62			public function createCommand($db = null)
63			{
64			if ($db === null) {
65			throw new \Exception('no db given to Query::createCommand');
66			}
67
68			$commandConfig = $db->getQueryBuilder()->build($this);
			0 ignored issues – show Bug introduced 2017-01-27 11:47 UTC by Report Bug Copy Issue Report The method `getQueryBuilder` cannot be called on `$db` (of type `null`). Methods can only be called on objects. This check looks for methods being called on variables that have been inferred to never be objects. Loading history...
69
70			return $db->createCommand($commandConfig);
			0 ignored issues – show Bug introduced 2017-01-27 11:47 UTC by Report Bug Copy Issue Report The method `createCommand` cannot be called on `$db` (of type `null`). Methods can only be called on objects. This check looks for methods being called on variables that have been inferred to never be objects. Loading history...
71			}
72
73			public function one($db = null)
74			{
75			return $this->searchOne($db);
76			}
77
78			public function searchOne($db = null)
			0 ignored issues – show Unused Code introduced 2017-01-26 17:43 UTC by Report Bug Copy Issue Report The parameter `$db` is not used and could be removed. This check looks from parameters that have been defined for a function or method, but which are not used in the method body. Loading history...
79			{
80			return $this->limit(1)->addOption('batch', false)->search();
81			}
82
83			public function all($db = null)
84			{
85			$rows = $this->searchAll();
86
87			if (!empty($rows) && $this->indexBy !== null) {
88			$result = [];
89			foreach ($rows as $row) {
90		View Code Duplication	if ($this->indexBy instanceof \Closure) {
			0 ignored issues – show Duplication introduced 2017-01-24 17:39 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...
91			$key = call_user_func($this->indexBy, $row);
92			} else {
93			$key = $row[$this->indexBy];
94			}
95			$result[$key] = $row;
96			}
97			$rows = $result;
98			}
99
100			return $rows;
101			}
102
103	2		public function searchAll($db = null)
			0 ignored issues – show Unused Code introduced 2017-01-24 17:39 UTC by Report Bug Copy Issue Report The parameter `$db` is not used and could be removed. This check looks from parameters that have been defined for a function or method, but which are not used in the method body. Loading history...
104			{
105	2		return $this->addOption('batch', true)->search();
106			}
107
108	2		public function search($db = null)
109			{
110	2		return $this->createCommand($db)->search();
111			}
112
113			public function delete($db = null, $options = [])
114			{
115			return $this->createCommand($db)->deleteByQuery($options);
			0 ignored issues – show Documentation Bug introduced 2017-01-27 11:47 UTC by Report Bug Copy Issue Report The method `deleteByQuery` does not exist on `object<hiqdev\hiart\Command>`? Since you implemented `__call`, maybe consider adding a @method annotation. If you implement `__call` and you know which methods are available, you can improve IDE auto-completion and static analysis by adding a @method annotation to the class. This is often the case, when `__call` is implemented by a parent class and only the child class knows which methods exist: class ParentClass { private $data = array(); public function __call($method, array $args) { if (0 === strpos($method, 'get')) { return $this->data[strtolower(substr($method, 3))]; } throw new \LogicException(sprintf('Unsupported method: %s', $method)); } } /** * If this class knows which fields exist, you can specify the methods here: * * @method string getName() */ class SomeClass extends ParentClass { } Loading history...
116			}
117
118			public function count($q = '*', $db = null)
119			{
120			$this->count = $q;
121
122			return (int) $this->searchAll();
123			}
124
125			public function exists($db = null)
126			{
127			return !empty(self::one($db));
128			}
129
130	1		public function action($action)
131			{
132	1		$this->action = $action;
133
134	1		return $this;
135			}
136
137	2		public function addAction($action)
138			{
139	2		if (empty($this->action)) {
140	2		$this->action = $action;
141			}
142
143	2		return $this;
144			}
145
146	2		public function addOption($name, $value)
147			{
148	2		if (!isset($this->options[$name])) {
149	2		$this->options[$name] = $value;
150			}
151
152	2		return $this;
153			}
154
155			public function getOption($name)
156			{
157			return isset($this->options[$name]) ? $this->options[$name] : null;
158			}
159
160	1		public function options($options)
161			{
162	1		$this->options = $options;
163
164	1		return $this;
165			}
166
167			public function addOptions($options)
168			{
169			if (!empty($options)) {
170			$this->options = array_merge($this->options, $options);
171			}
172
173			return $this;
174			}
175
176	1		public function body($body)
177			{
178	1		$this->body = $body;
179
180	1		return $this;
181			}
182
183			public function innerJoin($table, $on = '', $params = [])
184			{
185			$this->join[] = (array) $table;
186
187			return $this;
188			}
189
190		View Code Duplication	public function fields($fields)
			0 ignored issues – show Duplication introduced 2015-12-30 16:26 UTC by Report Bug Copy Issue Report This method seems to be duplicated in 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...
191			{
192			if (is_array($fields) \|\| $fields === null) {
193			$this->fields = $fields;
			0 ignored issues – show Documentation introduced 2015-12-30 16:26 UTC by Report Bug Copy Issue Report The property `fields` does not exist on `object<hiqdev\hiart\Query>`. Since you implemented `__set`, maybe consider adding a @property annotation. Since your code implements the magic setter `_set`, this function will be called for any write access on an undefined variable. You can add the `@property` annotation to your class or interface to document the existence of this variable. <?php /** * @property int $x * @property int $y * @property string $text */ class MyLabel { private $properties; private $allowedProperties = array('x', 'y', 'text'); public function __get($name) { if (isset($properties[$name]) && in_array($name, $this->allowedProperties)) { return $properties[$name]; } else { return null; } } public function __set($name, $value) { if (in_array($name, $this->allowedProperties)) { $properties[$name] = $value; } else { throw new \LogicException("Property $name is not defined."); } } } Since the property has write access only, you can use the @property-write annotation instead. Of course, you may also just have mistyped another name, in which case you should fix the error. See also the PhpDoc documentation for @property. Loading history...
194			} else {
195			$this->fields = func_get_args();
			0 ignored issues – show Documentation introduced 2015-12-30 16:26 UTC by Report Bug Copy Issue Report The property `fields` does not exist on `object<hiqdev\hiart\Query>`. Since you implemented `__set`, maybe consider adding a @property annotation. Since your code implements the magic setter `_set`, this function will be called for any write access on an undefined variable. You can add the `@property` annotation to your class or interface to document the existence of this variable. <?php /** * @property int $x * @property int $y * @property string $text */ class MyLabel { private $properties; private $allowedProperties = array('x', 'y', 'text'); public function __get($name) { if (isset($properties[$name]) && in_array($name, $this->allowedProperties)) { return $properties[$name]; } else { return null; } } public function __set($name, $value) { if (in_array($name, $this->allowedProperties)) { $properties[$name] = $value; } else { throw new \LogicException("Property $name is not defined."); } } } Since the property has write access only, you can use the @property-write annotation instead. Of course, you may also just have mistyped another name, in which case you should fix the error. See also the PhpDoc documentation for @property. Loading history...
196			}
197
198			return $this;
199			}
200
201		View Code Duplication	public function source($source)
			0 ignored issues – show Duplication introduced 2015-12-30 16:26 UTC by Report Bug Copy Issue Report This method seems to be duplicated in 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...
202			{
203			if (is_array($source) \|\| $source === null) {
204			$this->source = $source;
			0 ignored issues – show Documentation introduced 2015-12-30 16:26 UTC by Report Bug Copy Issue Report The property `source` does not exist on `object<hiqdev\hiart\Query>`. Since you implemented `__set`, maybe consider adding a @property annotation. Since your code implements the magic setter `_set`, this function will be called for any write access on an undefined variable. You can add the `@property` annotation to your class or interface to document the existence of this variable. <?php /** * @property int $x * @property int $y * @property string $text */ class MyLabel { private $properties; private $allowedProperties = array('x', 'y', 'text'); public function __get($name) { if (isset($properties[$name]) && in_array($name, $this->allowedProperties)) { return $properties[$name]; } else { return null; } } public function __set($name, $value) { if (in_array($name, $this->allowedProperties)) { $properties[$name] = $value; } else { throw new \LogicException("Property $name is not defined."); } } } Since the property has write access only, you can use the @property-write annotation instead. Of course, you may also just have mistyped another name, in which case you should fix the error. See also the PhpDoc documentation for @property. Loading history...
205			} else {
206			$this->source = func_get_args();
			0 ignored issues – show Documentation introduced 2015-12-30 16:26 UTC by Report Bug Copy Issue Report The property `source` does not exist on `object<hiqdev\hiart\Query>`. Since you implemented `__set`, maybe consider adding a @property annotation. Since your code implements the magic setter `_set`, this function will be called for any write access on an undefined variable. You can add the `@property` annotation to your class or interface to document the existence of this variable. <?php /** * @property int $x * @property int $y * @property string $text */ class MyLabel { private $properties; private $allowedProperties = array('x', 'y', 'text'); public function __get($name) { if (isset($properties[$name]) && in_array($name, $this->allowedProperties)) { return $properties[$name]; } else { return null; } } public function __set($name, $value) { if (in_array($name, $this->allowedProperties)) { $properties[$name] = $value; } else { throw new \LogicException("Property $name is not defined."); } } } Since the property has write access only, you can use the @property-write annotation instead. Of course, you may also just have mistyped another name, in which case you should fix the error. See also the PhpDoc documentation for @property. Loading history...
207			}
208
209			return $this;
210			}
211			}
212

hiqdev / yii2-hiart

Push — master ( 9388e4...36fb73 )

Query A

Complexity

Size/Duplication

Coupling/Cohesion

Test Coverage

Importance

20 Methods

How to fix Duplicated Code

Duplicated Code

Duplication Side-by-Side

Filter issues like