UpdateQuery::notExists() - Code Metrics - Inspection of "move query where methods into trait" - jaredtking/jaqb - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — master ( ffb751...b6a1f4 )

by Jared

created 2016-04-25 01:55 UTC

UpdateQuery::notExists() A

↳ Parent: Project

Complexity

Conditions	1
Paths	1

Size

Total Lines	6
Code Lines	3

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
c	1
b	0
f	0
dl	0
loc	6
rs	9.4285
cc	1
eloc	3
nc	1
nop	1

<?php

/**
 * @author Jared King <[email protected]>
 *
 * @link http://jaredtking.com
 *
 * @copyright 2015 Jared King
 * @license MIT
 */
namespace JAQB\Query;

use JAQB\Operations\Executable;
use JAQB\Statement\FromStatement;
use JAQB\Statement\LimitStatement;
use JAQB\Statement\OrderStatement;
use JAQB\Statement\SetStatement;
use JAQB\Statement\WhereStatement;
use JAQB\Query\Traits\WhereConditions;

class UpdateQuery extends AbstractQuery
{
    use Executable, WhereConditions;

    /**
     * @var FromStatement
     */
    protected $table;

    /**
     * @var SetStatement
     */
    protected $set;

    /**
     * @var OrderStatement
     */
    protected $orderBy;

    /**
     * @var LimitStatement
     */
    protected $limit;

    public function __construct()

    {
        $this->table = new FromStatement(FromStatement::UPDATE);
        $this->set = new SetStatement();
        $this->where = new WhereStatement();

        $this->orderBy = new OrderStatement();
        $this->limit = new LimitStatement();
    }

    /**
     * Sets the table for the query.
     *
     * @param string $table table name
     *
     * @return self
     */
    public function table($table)
    {
        $this->table->addTable($table);

        return $this;
    }

    /**
     * Sets the values for the query.
     *
     * @param array $values
     *
     * @return self
     */
    public function values(array $values)
    {
        $this->set->addValues($values);

        return $this;
    }

    /**
     * Sets the limit for the query.
     *
     * @param int $limit
     * @param int $offset
     *
     * @return self
     */
    public function limit($limit, $offset = 0)
    {
        $this->limit->setLimit($limit, $offset);

        return $this;
    }

    /**
     * Sets the order for the query.
     *
     * @param string|array $fields
     * @param string       $direction
     *
     * @return self
     */
    public function orderBy($fields, $direction = false)
    {
        $this->orderBy->addFields($fields, $direction);

        return $this;
    }

    /**
     * Gets the table name for the query.
     *
     * @return FromStatement
     */
    public function getTable()
    {
        return $this->table;
    }

    /**
     * Gets the values for the query.
     *
     * @return array
     */
    public function getSet()
    {
        return $this->set;
    }

    /**
     * Gets the order by statement for the query.
     *
     * @return OrderByStatement
     */
    public function getOrderBy()
    {
        return $this->orderBy;
    }

    /**
     * Gets the limit statement for the query.
     *
     * @return LimitStatement
     */
    public function getLimit()
    {
        return $this->limit;
    }

    /**
     * Generates the raw SQL string for the query.
     *
     * @return string
     */
    public function build()
    {
        $sql = [
            $this->table->build(),
            $this->set->build(),
            $this->where->build(),
            $this->orderBy->build(),
            $this->limit->build(),
        ];

        $this->values = array_merge(
            array_values($this->set->getValues()),
            $this->where->getValues());

        return implode(' ', array_filter($sql));
    }

    public function __clone()
    {
        $this->table = clone $this->table;
        $this->set = clone $this->set;
        $this->where = clone $this->where;
        $this->orderBy = clone $this->orderBy;
        $this->limit = clone $this->limit;
    }
}


1		<?php
2
3		/**
4		* @author Jared King <[email protected]>
5		*
6		* @link http://jaredtking.com
7		*
8		* @copyright 2015 Jared King
9		* @license MIT
10		*/
11		namespace JAQB\Query;
12
13		use JAQB\Operations\Executable;
14		use JAQB\Statement\FromStatement;
15		use JAQB\Statement\LimitStatement;
16		use JAQB\Statement\OrderStatement;
17		use JAQB\Statement\SetStatement;
18		use JAQB\Statement\WhereStatement;
19		use JAQB\Query\Traits\WhereConditions;
20
21		class UpdateQuery extends AbstractQuery
22		{
23		use Executable, WhereConditions;
24
25		/**
26		* @var FromStatement
27		*/
28		protected $table;
29
30		/**
31		* @var SetStatement
32		*/
33		protected $set;
34
35		/**
36		* @var OrderStatement
37		*/
38		protected $orderBy;
39
40		/**
41		* @var LimitStatement
42		*/
43		protected $limit;
44
45	View Code Duplication	public function __construct()
		0 ignored issues – show Duplication introduced 2015-12-05 17:25 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...
46		{
47		$this->table = new FromStatement(FromStatement::UPDATE);
48		$this->set = new SetStatement();
49		$this->where = new WhereStatement();
		0 ignored issues – show Documentation Bug introduced 2016-04-25 01:57 UTC by Report Bug Copy Issue Report It seems like `new \JAQB\Statement\WhereStatement()` of type `object<JAQB\Statement\WhereStatement>` is incompatible with the declared type `object<JAQB\Query\Traits\WhereStatement>` of property `$where`. Our type inference engine has found an assignment to a property that is incompatible with the declared type of that property. Either this assignment is in error or the assigned type should be added to the documentation/type hint for that property.. Loading history...
50		$this->orderBy = new OrderStatement();
51		$this->limit = new LimitStatement();
52		}
53
54		/**
55		* Sets the table for the query.
56		*
57		* @param string $table table name
58		*
59		* @return self
60		*/
61		public function table($table)
62		{
63		$this->table->addTable($table);
64
65		return $this;
66		}
67
68		/**
69		* Sets the values for the query.
70		*
71		* @param array $values
72		*
73		* @return self
74		*/
75		public function values(array $values)
76		{
77		$this->set->addValues($values);
78
79		return $this;
80		}
81
82		/**
83		* Sets the limit for the query.
84		*
85		* @param int $limit
86		* @param int $offset
87		*
88		* @return self
89		*/
90		public function limit($limit, $offset = 0)
91		{
92		$this->limit->setLimit($limit, $offset);
93
94		return $this;
95		}
96
97		/**
98		* Sets the order for the query.
99		*
100		* @param string\|array $fields
101		* @param string $direction
102		*
103		* @return self
104		*/
105		public function orderBy($fields, $direction = false)
106		{
107		$this->orderBy->addFields($fields, $direction);
108
109		return $this;
110		}
111
112		/**
113		* Gets the table name for the query.
114		*
115		* @return FromStatement
116		*/
117		public function getTable()
118		{
119		return $this->table;
120		}
121
122		/**
123		* Gets the values for the query.
124		*
125		* @return array
126		*/
127		public function getSet()
128		{
129		return $this->set;
130		}
131
132		/**
133		* Gets the order by statement for the query.
134		*
135		* @return OrderByStatement
136		*/
137		public function getOrderBy()
138		{
139		return $this->orderBy;
140		}
141
142		/**
143		* Gets the limit statement for the query.
144		*
145		* @return LimitStatement
146		*/
147		public function getLimit()
148		{
149		return $this->limit;
150		}
151
152		/**
153		* Generates the raw SQL string for the query.
154		*
155		* @return string
156		*/
157		public function build()
158		{
159		$sql = [
160		$this->table->build(),
161		$this->set->build(),
162		$this->where->build(),
163		$this->orderBy->build(),
164		$this->limit->build(),
165		];
166
167		$this->values = array_merge(
168		array_values($this->set->getValues()),
169		$this->where->getValues());
170
171		return implode(' ', array_filter($sql));
172		}
173
174		public function __clone()
175		{
176		$this->table = clone $this->table;
177		$this->set = clone $this->set;
178		$this->where = clone $this->where;
179		$this->orderBy = clone $this->orderBy;
180		$this->limit = clone $this->limit;
181		}
182		}
183

jaredtking / jaqb

Push — master ( ffb751...b6a1f4 )

UpdateQuery::notExists() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like