SubQuery::toSql() - Code Metrics - thecodingmachine/magic-query - Measure and Improve Code Quality continuously with Scrutinizer

SubQuery::toSql() A
last analyzed 2016-08-17 10:37 UTC

↳ Parent: SubQuery

Complexity

Conditions	4
Paths	8

Size

Total Lines	17
Code Lines	11

Duplication

Lines	4
Ratio	23.53 %

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
c	1
b	0
f	0
dl	4
loc	17
rs	9.2
cc	4
eloc	11
nc	8
nop	4

<?php

/**
 * expression-types.php.
 *
 *
 * Copyright (c) 2010-2013, Justin Swanhart
 * with contributions by André Rothe <[email protected], [email protected]>
 * and David Négrier <[email protected]>
 *
 * All rights reserved.
 *
 * Redistribution and use in source and binary forms, with or without modification,
 * are permitted provided that the following conditions are met:
 *
 *   * Redistributions of source code must retain the above copyright notice,
 *     this list of conditions and the following disclaimer.
 *   * Redistributions in binary form must reproduce the above copyright notice,
 *     this list of conditions and the following disclaimer in the documentation
 *     and/or other materials provided with the distribution.
 *
 * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND ANY
 * EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES
 * OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT
 * SHALL THE COPYRIGHT HOLDER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT,
 * INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED
 * TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR
 * BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN
 * CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN
 * ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH
 * DAMAGE.
 */
namespace SQLParser\Node;

use Doctrine\DBAL\Connection;
use SQLParser\Node\Traverser\NodeTraverser;
use SQLParser\Node\Traverser\VisitorInterface;
use SQLParser\Query\Select;
use Mouf\MoufInstanceDescriptor;
use Mouf\MoufManager;

/**
 * This class represents a subquery (and optionally a JOIN .. ON expression in an SQL expression.
 *
 * @author David Négrier <[email protected]>
 */
class SubQuery implements NodeInterface
{
    private $subQuery;

    /**
     * Returns the list of subQuery statements.
     *
     * @return Select
     */
    public function getSubQuery()
    {
        return $this->subQuery;
    }

    /**
     * Sets the list of subQuery statements.
     *
     * @param Select $subQuery
     */
    public function setSubQuery(Select $subQuery)
    {
        $this->subQuery = $subQuery;
    }

    private $alias;

    /**
     * Returns the alias.
     *
     * @return string
     */
    public function getAlias()
    {
        return $this->alias;
    }

    /**
     * Sets the alias.
     *
     * @param string $alias
     */
    public function setAlias($alias)
    {
        $this->alias = $alias;
    }

    private $joinType;

    /**
     * Returns the join type.
     *
     * @return string
     */
    public function getJoinType()
    {
        return $this->joinType;
    }

    /**
     * Sets the join type (JOIN, LEFT JOIN, RIGHT JOIN, etc...).
     *
     * @param string $joinType
     */
    public function setJoinType($joinType)
    {
        $this->joinType = $joinType;
    }

    private $refClause;

    /**
     * Returns the list of refClause statements.
     *
     * @return NodeInterface[]
     */
    public function getRefClause()
    {
        return $this->refClause;
    }

    /**
     * Sets the list of refClause statements.
     *
     * @param NodeInterface[] $refClause
     */
    public function setRefClause($refClause)
    {
        $this->refClause = $refClause;
    }

    /**
     * Returns a Mouf instance descriptor describing this object.
     *
     * @param MoufManager $moufManager
     *
     * @return MoufInstanceDescriptor
     */
    public function toInstanceDescriptor(MoufManager $moufManager)

    {
        $instanceDescriptor = $moufManager->createInstance(get_called_class());
        $instanceDescriptor->getProperty('subQuery')->setValue($this->subQuery->toInstanceDescriptor($moufManager));
        $instanceDescriptor->getProperty('alias')->setValue($this->alias);
        $instanceDescriptor->getProperty('joinType')->setValue($this->joinType);
        $instanceDescriptor->getProperty('refClause')->setValue(NodeFactory::nodeToInstanceDescriptor($this->refClause, $moufManager));

        return $instanceDescriptor;
    }

    /**
     * Walks the tree of nodes, calling the visitor passed in parameter.
     *
     * @param VisitorInterface $visitor
     */
    public function walk(VisitorInterface $visitor)

    {
        $node = $this;
        $result = $visitor->enterNode($node);
        if ($result instanceof NodeInterface) {
            $node = $result;
        }
        if ($result !== NodeTraverser::DONT_TRAVERSE_CHILDREN) {
            $result2 = $this->subQuery->walk($visitor);
            if ($result2 === NodeTraverser::REMOVE_NODE) {
                return NodeTraverser::REMOVE_NODE;
            } elseif ($result2 instanceof NodeInterface) {
                $this->subQuery = $result2;
            }
        }

        return $visitor->leaveNode($node);
    }

    /**
     * Renders the object as a SQL string.
     *
     * @param Connection $dbConnection
     * @param array      $parameters
     * @param number     $indent
     * @param int        $conditionsMode
     *
     * @return string
     */
    public function toSql(array $parameters = array(), Connection $dbConnection = null, $indent = 0, $conditionsMode = self::CONDITION_APPLY)
    {
        $sql = '';
        if ($this->refClause) {

            $sql .= "\n  ".$this->joinType.' ';
        }
        $sql .= '('.$this->subQuery->toSql($parameters, $dbConnection, $indent, $conditionsMode).')';
        if ($this->alias) {
            $sql .= ' AS '.NodeFactory::escapeDBItem($this->alias, $dbConnection);
        }
        if ($this->refClause) {

            $sql .= ' ON ';
            $sql .= NodeFactory::toSql($this->refClause, $dbConnection, $parameters, ' ', true, $indent, $conditionsMode);
        }

        return $sql;
    }
}


1		<?php
2
3		/**
4		* expression-types.php.
5		*
6		*
7		* Copyright (c) 2010-2013, Justin Swanhart
8		* with contributions by André Rothe <[email protected], [email protected]>
9		* and David Négrier <[email protected]>
10		*
11		* All rights reserved.
12		*
13		* Redistribution and use in source and binary forms, with or without modification,
14		* are permitted provided that the following conditions are met:
15		*
16		* * Redistributions of source code must retain the above copyright notice,
17		* this list of conditions and the following disclaimer.
18		* * Redistributions in binary form must reproduce the above copyright notice,
19		* this list of conditions and the following disclaimer in the documentation
20		* and/or other materials provided with the distribution.
21		*
22		* THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND ANY
23		* EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES
24		* OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT
25		* SHALL THE COPYRIGHT HOLDER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT,
26		* INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED
27		* TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR
28		* BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN
29		* CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN
30		* ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH
31		* DAMAGE.
32		*/
33		namespace SQLParser\Node;
34
35		use Doctrine\DBAL\Connection;
36		use SQLParser\Node\Traverser\NodeTraverser;
37		use SQLParser\Node\Traverser\VisitorInterface;
38		use SQLParser\Query\Select;
39		use Mouf\MoufInstanceDescriptor;
40		use Mouf\MoufManager;
41
42		/**
43		* This class represents a subquery (and optionally a JOIN .. ON expression in an SQL expression.
44		*
45		* @author David Négrier <[email protected]>
46		*/
47		class SubQuery implements NodeInterface
48		{
49		private $subQuery;
50
51		/**
52		* Returns the list of subQuery statements.
53		*
54		* @return Select
55		*/
56		public function getSubQuery()
57		{
58		return $this->subQuery;
59		}
60
61		/**
62		* Sets the list of subQuery statements.
63		*
64		* @param Select $subQuery
65		*/
66		public function setSubQuery(Select $subQuery)
67		{
68		$this->subQuery = $subQuery;
69		}
70
71		private $alias;
72
73		/**
74		* Returns the alias.
75		*
76		* @return string
77		*/
78		public function getAlias()
79		{
80		return $this->alias;
81		}
82
83		/**
84		* Sets the alias.
85		*
86		* @param string $alias
87		*/
88		public function setAlias($alias)
89		{
90		$this->alias = $alias;
91		}
92
93		private $joinType;
94
95		/**
96		* Returns the join type.
97		*
98		* @return string
99		*/
100		public function getJoinType()
101		{
102		return $this->joinType;
103		}
104
105		/**
106		* Sets the join type (JOIN, LEFT JOIN, RIGHT JOIN, etc...).
107		*
108		* @param string $joinType
109		*/
110		public function setJoinType($joinType)
111		{
112		$this->joinType = $joinType;
113		}
114
115		private $refClause;
116
117		/**
118		* Returns the list of refClause statements.
119		*
120		* @return NodeInterface[]
121		*/
122		public function getRefClause()
123		{
124		return $this->refClause;
125		}
126
127		/**
128		* Sets the list of refClause statements.
129		*
130		* @param NodeInterface[] $refClause
131		*/
132		public function setRefClause($refClause)
133		{
134		$this->refClause = $refClause;
135		}
136
137		/**
138		* Returns a Mouf instance descriptor describing this object.
139		*
140		* @param MoufManager $moufManager
141		*
142		* @return MoufInstanceDescriptor
143		*/
144	View Code Duplication	public function toInstanceDescriptor(MoufManager $moufManager)
		0 ignored issues – show Duplication introduced 2015-12-08 18:20 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...
145		{
146		$instanceDescriptor = $moufManager->createInstance(get_called_class());
147		$instanceDescriptor->getProperty('subQuery')->setValue($this->subQuery->toInstanceDescriptor($moufManager));
148		$instanceDescriptor->getProperty('alias')->setValue($this->alias);
149		$instanceDescriptor->getProperty('joinType')->setValue($this->joinType);
150		$instanceDescriptor->getProperty('refClause')->setValue(NodeFactory::nodeToInstanceDescriptor($this->refClause, $moufManager));
151
152		return $instanceDescriptor;
153		}
154
155		/**
156		* Walks the tree of nodes, calling the visitor passed in parameter.
157		*
158		* @param VisitorInterface $visitor
159		*/
160	View Code Duplication	public function walk(VisitorInterface $visitor)
		0 ignored issues – show Duplication introduced 2016-02-29 11:47 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...
161		{
162		$node = $this;
163		$result = $visitor->enterNode($node);
164		if ($result instanceof NodeInterface) {
165		$node = $result;
166		}
167		if ($result !== NodeTraverser::DONT_TRAVERSE_CHILDREN) {
168		$result2 = $this->subQuery->walk($visitor);
169		if ($result2 === NodeTraverser::REMOVE_NODE) {
170		return NodeTraverser::REMOVE_NODE;
171		} elseif ($result2 instanceof NodeInterface) {
172		$this->subQuery = $result2;
173		}
174		}
175
176		return $visitor->leaveNode($node);
177		}
178
179		/**
180		* Renders the object as a SQL string.
181		*
182		* @param Connection $dbConnection
183		* @param array $parameters
184		* @param number $indent
185		* @param int $conditionsMode
186		*
187		* @return string
188		*/
189		public function toSql(array $parameters = array(), Connection $dbConnection = null, $indent = 0, $conditionsMode = self::CONDITION_APPLY)
190		{
191		$sql = '';
192		if ($this->refClause) {
		0 ignored issues – show Bug Best Practice introduced 2015-12-08 18:20 UTC by Report Bug Copy Issue Report The expression `$this->refClause` of type `SQLParser\Node\NodeInterface[]` is implicitly converted to a boolean; are you sure this is intended? If so, consider using `! empty($expr)` instead to make it clear that you intend to check for an array without elements. This check marks implicit conversions of arrays to boolean values in a comparison. While in PHP an empty array is considered to be equal (but not identical) to false, this is not always apparent. Consider making the comparison explicit by using `empty(..)` or `! empty(...)` instead. Loading history...
193		$sql .= "\n ".$this->joinType.' ';
194		}
195		$sql .= '('.$this->subQuery->toSql($parameters, $dbConnection, $indent, $conditionsMode).')';
196		if ($this->alias) {
197		$sql .= ' AS '.NodeFactory::escapeDBItem($this->alias, $dbConnection);
198		}
199	View Code Duplication	if ($this->refClause) {
		0 ignored issues – show Bug Best Practice introduced 2015-12-08 18:20 UTC by Report Bug Copy Issue Report The expression `$this->refClause` of type `SQLParser\Node\NodeInterface[]` is implicitly converted to a boolean; are you sure this is intended? If so, consider using `! empty($expr)` instead to make it clear that you intend to check for an array without elements. This check marks implicit conversions of arrays to boolean values in a comparison. While in PHP an empty array is considered to be equal (but not identical) to false, this is not always apparent. Consider making the comparison explicit by using `empty(..)` or `! empty(...)` instead. Loading history... Duplication introduced 2015-12-08 18:20 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...
200		$sql .= ' ON ';
201		$sql .= NodeFactory::toSql($this->refClause, $dbConnection, $parameters, ' ', true, $indent, $conditionsMode);
202		}
203
204		return $sql;
205		}
206		}
207

thecodingmachine / magic-query

SubQuery::toSql() A last analyzed 2016-08-17 10:37 UTC

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like

SubQuery::toSql() A
last analyzed 2016-08-17 10:37 UTC