Query::like() - Code Metrics - Inspection of "add filter like" - jayacode/framework - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — master ( 542fab...77f05a )

by Restu

created 2016-05-15 04:59 UTC

Query::like() A

↳ Parent: Query

Complexity

Conditions	1
Paths	1

Size

Total Lines	4
Code Lines	2

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	1

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

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

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

/**
 * Class Query
 * @property array where
 * @property array columns
 * @property mixed query
 * @property null params
 * @property null table
 * @package JayaCode\Framework\Core\Database\Query
 */
class Query
{
    /**
     *
     */
    const TYPE_QUERY = 'QUERY';
    /**
     *
     */
    const TYPE_SELECT = 'SELECT';

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

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

    /**
     * @param $table
     */
    public function setTable($table)
    {
        $this->table = $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);
        }
        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 $column
     * @param $value
     * @param string $type
     * @return Query
     */
    public function like($column, $value, $type = "AND")
    {
        return $this->where($column, $value, "LIKE", $type);
    }

    /**
     * @param $column
     * @param $value
     * @return Query
     */
    public function andLike($column, $value)
    {
        return $this->like($column, $value);
    }

    /**
     * @param $column
     * @param $value
     * @return Query
     */
    public function orLike($column, $value)
    {
        return $this->like($column, $value, "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			* @property array where
9			* @property array columns
10			* @property mixed query
11			* @property null params
12			* @property null table
13			* @package JayaCode\Framework\Core\Database\Query
14			*/
15			class Query
16			{
17			/**
18			*
19			*/
20			const TYPE_QUERY = 'QUERY';
21			/**
22			*
23			*/
24			const TYPE_SELECT = 'SELECT';
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			* @param $params
50			* @return Query
51			*/
52			public static function sql($queryStr, $params = null)
53			{
54			$query = new self();
55			if ($params) {
56			$query->params = $params;
57			}
58			$query->setType(self::TYPE_QUERY);
59			$query->query = $queryStr;
60			return $query;
61			}
62
63			/**
64			* @param $table
65			* @return Query
66			*/
67			public static function table($table)
68			{
69			return new self($table);
70			}
71
72			/**
73			* @param $table
74			*/
75			public function setTable($table)
76			{
77			$this->table = $table;
78			}
79
80			/**
81			* @param $columns
82			* @return $this
83			*/
84			public function select($columns = null)
85			{
86			$this->attributes['columns'] = $columns;
87			$this->type = "SELECT";
88			return $this;
89			}
90
91			/**
92			* @param $query
93			* @param string $type
94			* @return Query
95			*/
96			public function whereQ(Query $query, $type = "AND")
97			{
98			if ($query->getType() == Query::TYPE_QUERY) {
99			$this->attributes['where'][] = array($type, $query->query);
100			}
101			return $this;
102			}
103
104			/**
105			* @param $column
106			* @param $value
107			* @param string $operator
108			* @param string $type
109			* @return Query
110			*/
111			public function where($column, $value, $operator = "=", $type = "AND")
112			{
113			$this->attributes['where'][] = array($type, array($column, $operator, $value));
114			return $this;
115			}
116
117			/**
118			* @param $column
119			* @param $value
120			* @param string $operator
121			* @return Query
122			*/
123			public function andWhere($column, $value, $operator = "=")
124			{
125			return $this->where($column, $value, $operator, "AND");
126			}
127
128			/**
129			* @param $column
130			* @param $value
131			* @param string $operator
132			* @return Query
133			*/
134			public function orWhere($column, $value, $operator = "=")
135			{
136			return $this->where($column, $value, $operator, "OR");
137			}
138
139			/**
140			* @param $column
141			* @param $value
142			* @param string $type
143			* @return Query
144			*/
145			public function like($column, $value, $type = "AND")
146			{
147			return $this->where($column, $value, "LIKE", $type);
148			}
149
150			/**
151			* @param $column
152			* @param $value
153			* @return Query
154			*/
155			public function andLike($column, $value)
156			{
157			return $this->like($column, $value);
158			}
159
160			/**
161			* @param $column
162			* @param $value
163			* @return Query
164			*/
165			public function orLike($column, $value)
166			{
167			return $this->like($column, $value, "OR");
168			}
169
170			/**
171			* @param Grammar $grammar
172			* @return array
173			*/
174			public function build(Grammar $grammar)
175			{
176			$grammar->setQuery($this);
177
178			$queryStr = $grammar->build();
179			$queryParams = isset($this->attributes['params'])?$this->attributes['params']:$grammar->getParams();
180
181			return [$queryStr, $queryParams];
182			}
183
184			/**
185			* @param $name
186			* @return array
187			*/
188			public function __get($name)
189			{
190			return arr_get($this->attributes, $name);
191			}
192
193			/**
194			* @param $name
195			* @param $value
196			*/
197			public function __set($name, $value)
198			{
199			$this->attributes[$name] = $value;
200			}
201
202			/**
203			* @return string
204			*/
205			public function getType()
206			{
207			return $this->type;
208			}
209
210			/**
211			* @param string $type
212			*/
213			public function setType($type)
214			{
215			$this->type = $type;
216			}
217			}
218

jayacode / framework

Push — master ( 542fab...77f05a )

Query::like() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like