Query::sql() - Code Metrics - Inspection of "create basic query builder for ORM" - jayacode/framework - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — master ( 87a229...1012d8 )

by Restu

created 2016-05-14 12:05 UTC

Query::sql() A

↳ Parent: Query

Complexity

Conditions	2
Paths	2

Size

Total Lines	10
Code Lines	7

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
cc	2
eloc	7
c	1
b	0
f	0
nc	2
nop	2
dl	0
loc	10
rs	9.4285

<?php
namespace JayaCode\Framework\Core\Database\Query;

use JayaCode\Framework\Core\Database\Query\Grammar\Grammar;

/**
 * Class Query
 * @package JayaCode\Framework\Core\Database\Query
 */
class Query
{
    /**
     *
     */
    const TYPE_QUERY = 'QUERY';
    /**
     *
     */
    const TYPE_SELECT = 'SELECT';

    /**
     * @var string
     */
    public $table;

    /**
     * @var array
     */
    protected $attributes = array(
        'where' => array(),
        'columns' => array()
    );

    /**
     * @var string
     */
    protected $type = "SELECT";

    /**
     * @param null $table
     */
    public function __construct($table = null)
    {
        $this->table = $table;
    }

    /**
     * @param $queryStr
     * @return Query
     */
    public static function sql($queryStr, $params = null)
    {
        $query = new self();
        if ($params) {
            $query->params = $params;
<?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.");
        }
    }

}
        }
        $query->setType(self::TYPE_QUERY);
        $query->query = $queryStr;
<?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 $query;
    }

    /**
     * @param $table
     * @return Query
     */
    public static function table($table)
    {
        return new self($table);
    }

    /**
     * @param $columns
     * @return $this
     */
    public function select($columns = null)
    {
        $this->attributes['columns'] = $columns;
        $this->type = "SELECT";
        return $this;
    }

    /**
     * @param $query
     * @param string $type
     * @return Query
     */
    public function whereQ(Query $query, $type = "AND")
    {
        if ($query->getType() == Query::TYPE_QUERY) {
            $this->attributes['where'][] = array($type, $query->query);
<?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;
    }

    /**
     * @param $column
     * @param $value
     * @param string $operator
     * @param string $type
     * @return Query
     */
    public function where($column, $value, $operator = "=", $type = "AND")
    {
        $this->attributes['where'][] = array($type, array($column, $operator, $value));
        return $this;
    }

    /**
     * @param $column
     * @param $value
     * @param string $operator
     * @return Query
     */
    public function andWhere($column, $value, $operator = "=")
    {
        return $this->where($column, $value, $operator, "AND");
    }

    /**
     * @param $column
     * @param $value
     * @param string $operator
     * @return Query
     */
    public function orWhere($column, $value, $operator = "=")
    {
        return $this->where($column, $value, $operator, "OR");
    }

    /**
     * @param Grammar $grammar
     * @return array
     */
    public function build(Grammar $grammar)
    {
        $grammar->setQuery($this);

        $queryStr = $grammar->build();
        $queryParams = isset($this->attributes['params'])?$this->attributes['params']:$grammar->getParams();

        return [$queryStr, $queryParams];
    }

    /**
     * @param $name
     * @return array
     */
    public function __get($name)
    {
        return arr_get($this->attributes, $name);
    }

    /**
     * @param $name
     * @param $value
     */
    public function __set($name, $value)
    {
        $this->attributes[$name] = $value;
    }

    /**
     * @return string
     */
    public function getType()
    {
        return $this->type;
    }

    /**
     * @param string $type
     */
    public function setType($type)
    {
        $this->type = $type;
    }
}


1			<?php
2			namespace JayaCode\Framework\Core\Database\Query;
3
4			use JayaCode\Framework\Core\Database\Query\Grammar\Grammar;
5
6			/**
7			* Class Query
8			* @package JayaCode\Framework\Core\Database\Query
9			*/
10			class Query
11			{
12			/**
13			*
14			*/
15			const TYPE_QUERY = 'QUERY';
16			/**
17			*
18			*/
19			const TYPE_SELECT = 'SELECT';
20
21			/**
22			* @var string
23			*/
24			public $table;
25
26			/**
27			* @var array
28			*/
29			protected $attributes = array(
30			'where' => array(),
31			'columns' => array()
32			);
33
34			/**
35			* @var string
36			*/
37			protected $type = "SELECT";
38
39			/**
40			* @param null $table
41			*/
42			public function __construct($table = null)
43			{
44			$this->table = $table;
45			}
46
47			/**
48			* @param $queryStr
49			* @return Query
50			*/
51			public static function sql($queryStr, $params = null)
52			{
53			$query = new self();
54			if ($params) {
55			$query->params = $params;
			0 ignored issues – show Documentation introduced 2016-05-14 12:20 UTC by Report Bug Copy Issue Report The property `params` does not exist on `object<JayaCode\Framewor...e\Database\Query\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...
56			}
57			$query->setType(self::TYPE_QUERY);
58			$query->query = $queryStr;
			0 ignored issues – show Documentation introduced 2016-05-14 12:20 UTC by Report Bug Copy Issue Report The property `query` does not exist on `object<JayaCode\Framewor...e\Database\Query\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...
59			return $query;
60			}
61
62			/**
63			* @param $table
64			* @return Query
65			*/
66			public static function table($table)
67			{
68			return new self($table);
69			}
70
71			/**
72			* @param $columns
73			* @return $this
74			*/
75			public function select($columns = null)
76			{
77			$this->attributes['columns'] = $columns;
78			$this->type = "SELECT";
79			return $this;
80			}
81
82			/**
83			* @param $query
84			* @param string $type
85			* @return Query
86			*/
87			public function whereQ(Query $query, $type = "AND")
88			{
89			if ($query->getType() == Query::TYPE_QUERY) {
90			$this->attributes['where'][] = array($type, $query->query);
			0 ignored issues – show Documentation introduced 2016-05-14 12:20 UTC by Report Bug Copy Issue Report The property `query` does not exist on `object<JayaCode\Framewor...e\Database\Query\Query>`. Since you implemented `__get`, maybe consider adding a @property annotation. Since your code implements the magic getter `_get`, this function will be called for any read 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."); } } } If the property has read access only, you can use the @property-read 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...
91			}
92			return $this;
93			}
94
95			/**
96			* @param $column
97			* @param $value
98			* @param string $operator
99			* @param string $type
100			* @return Query
101			*/
102			public function where($column, $value, $operator = "=", $type = "AND")
103			{
104			$this->attributes['where'][] = array($type, array($column, $operator, $value));
105			return $this;
106			}
107
108			/**
109			* @param $column
110			* @param $value
111			* @param string $operator
112			* @return Query
113			*/
114			public function andWhere($column, $value, $operator = "=")
115			{
116			return $this->where($column, $value, $operator, "AND");
117			}
118
119			/**
120			* @param $column
121			* @param $value
122			* @param string $operator
123			* @return Query
124			*/
125			public function orWhere($column, $value, $operator = "=")
126			{
127			return $this->where($column, $value, $operator, "OR");
128			}
129
130			/**
131			* @param Grammar $grammar
132			* @return array
133			*/
134			public function build(Grammar $grammar)
135			{
136			$grammar->setQuery($this);
137
138			$queryStr = $grammar->build();
139			$queryParams = isset($this->attributes['params'])?$this->attributes['params']:$grammar->getParams();
140
141			return [$queryStr, $queryParams];
142			}
143
144			/**
145			* @param $name
146			* @return array
147			*/
148			public function __get($name)
149			{
150			return arr_get($this->attributes, $name);
151			}
152
153			/**
154			* @param $name
155			* @param $value
156			*/
157			public function __set($name, $value)
158			{
159			$this->attributes[$name] = $value;
160			}
161
162			/**
163			* @return string
164			*/
165			public function getType()
166			{
167			return $this->type;
168			}
169
170			/**
171			* @param string $type
172			*/
173			public function setType($type)
174			{
175			$this->type = $type;
176			}
177			}
178

jayacode / framework

Push — master ( 87a229...1012d8 )

Query::sql() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like