Sql::select() - Code Metrics - Inspection of "v1.8.0" - winframework/winphp - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Pull Request — master (#24)

by Wanderson

created 2020-10-22 01:36 UTC

Sql::select() A

↳ Parent: Sql

Complexity

Conditions	1
Paths	1

Size

Total Lines	8
Code Lines	6

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
eloc	6
dl	0
loc	8
rs	10
c	0
b	0
f	0
cc	1
nc	1
nop	0

<?php

namespace Win\Repositories;

/**
 * Cria comandos SQL
 */
class Sql
{
	public ?array $columns = null;

	private string $table;
	private array $values;
	private array $join;
	private array $joinValues;
	private array $where;
	private array $whereValues;
	private array $orderBy;
	private string $limit;

	/**
	 * Prepara a query
	 * @param string $table
	 */
	public function __construct(&$table)
	{
		$this->table = &$table;
		$this->values = [];
		$this->join = [];
		$this->joinValues = [];
		$this->where = [];
		$this->whereValues = [];
		$this->orderBy = [];
		$this->limit = '';
	}

	/** @param mixed[] */
	public function setValues($values)
	{
		return $this->values = $values;
	}

	/** @return mixed[] */
	public function values()
	{
		return array_merge($this->values, $this->joinValues, $this->whereValues);
	}

	/**
	 * SELECT * FROM ...
	 * @return string
	 */
	public function select()
	{
		return 'SELECT ' . implode(', ', $this->columns ?? ['*'])
			. ' FROM ' . $this->table
			. $this->join()
			. $this->where()
			. $this->orderBy()
			. $this->limit();
	}

	/**
	 * SELECT COUNT(*) FROM
	 * @return string
	 */
	public function selectCount()
	{
		return 'SELECT COUNT(*) FROM ' . $this->table
			. $this->join()
			. $this->where();
	}

	/**
	 * INSERT INTO ... VALUES
	 * @return string
	 */
	public function insert()
	{
		$params = str_split(str_repeat('?', count($this->values)));
		return 'INSERT INTO ' . $this->table
			. ' (' . implode(',', array_keys($this->values)) . ')'
			. ' VALUES (' . implode(', ', $params) . ')';
	}

	/**
	 * UPDATE ... SET
	 * @return string
	 */
	public function update()
	{
		$keys = array_keys($this->values);
		$columns = array_map(fn ($column) => $column . ' = ?', $keys);

		return 'UPDATE ' . $this->table
			. ' SET ' . implode(', ', $columns)
			. $this->where()
			. $this->limit();
	}

	/**
	 * DELETE FROM ...
	 * @return string
	 */
	public function delete()
	{
		return 'DELETE FROM ' . $this->table
			. $this->where()
			. $this->limit();
	}

	/**
	 * WHERE ...
	 * @param string $comparator
	 * @param mixed $values
	 */
	public function addWhere($comparator, $values)
	{
		$hasBindParams = preg_match('/[:\?]/', $comparator);
		if ($values && !$hasBindParams) {
			$comparator .= ' = ?';
		}
		$this->where[] = '(' . $comparator . ')';
		$this->whereValues = array_merge($this->whereValues, $values);
	}

	/**
	 * JOIN, LEFT JOIN ...
	 * @param string $join
	 * @param array $values
	 */
	public function addJoin($join, $values)
	{
		$this->join[] = $join;
		$this->joinValues = array_merge($this->joinValues, $values);
	}

	/**
	 * Define o limit
	 * @param int $offset
	 * @param int $limit
	 */
	public function setLimit($offset, $limit)
	{
		$this->limit = $offset . ',' . $limit;
	}

	private function join()
	{
		if (empty($this->join)) {
			return '';
		}

		return ' ' . implode(' ', $this->join);
	}

	/**
	 * Retorna o SQL
	 * @return string
	 */
	private function where()
	{
		if (empty($this->where)) {
			return '';
		}

		return ' WHERE ' . implode(' AND ', $this->where);
	}

	/**
	 * Define a ordenação principal
	 * @param string $orderBy
	 */
	public function setOrderBy($orderBy)
	{
		$this->orderBy = [$orderBy];
	}

	/**
	 * Adiciona uma ordenação
	 * @param string $orderBy
	 * @param int $priority
	 */
	public function addOrderBy($orderBy, $priority = 0)
	{
		$this->orderBy[$priority] = $orderBy;
	}

	/**
	 * LIMIT ...
	 * @return string
	 */
	private function limit()
	{
		if (empty($this->limit)) {
			return '';
		}

		return ' LIMIT ' . $this->limit;
	}


	/**
	 * ORDER BY...
	 * @return string
	 */
	private function orderBy()
	{
		if (empty($this->orderBy)) {
			return '';
		}

		ksort($this->orderBy);
		return ' ORDER BY ' . implode(', ', $this->orderBy);
	}
}


1			<?php
2
3			namespace Win\Repositories;
4
5			/**
6			* Cria comandos SQL
7			*/
8			class Sql
9			{
10			public ?array $columns = null;
11
12			private string $table;
13			private array $values;
14			private array $join;
15			private array $joinValues;
16			private array $where;
17			private array $whereValues;
18			private array $orderBy;
19			private string $limit;
20
21			/**
22			* Prepara a query
23			* @param string $table
24			*/
25			public function __construct(&$table)
26			{
27			$this->table = &$table;
28			$this->values = [];
29			$this->join = [];
30			$this->joinValues = [];
31			$this->where = [];
32			$this->whereValues = [];
33			$this->orderBy = [];
34			$this->limit = '';
35			}
36
37			/** @param mixed[] */
38			public function setValues($values)
39			{
40			return $this->values = $values;
41			}
42
43			/** @return mixed[] */
44			public function values()
45			{
46			return array_merge($this->values, $this->joinValues, $this->whereValues);
47			}
48
49			/**
50			* SELECT * FROM ...
51			* @return string
52			*/
53			public function select()
54			{
55			return 'SELECT ' . implode(', ', $this->columns ?? ['*'])
56			. ' FROM ' . $this->table
57			. $this->join()
58			. $this->where()
59			. $this->orderBy()
60			. $this->limit();
61			}
62
63			/**
64			* SELECT COUNT(*) FROM
65			* @return string
66			*/
67			public function selectCount()
68			{
69			return 'SELECT COUNT(*) FROM ' . $this->table
70			. $this->join()
71			. $this->where();
72			}
73
74			/**
75			* INSERT INTO ... VALUES
76			* @return string
77			*/
78			public function insert()
79			{
80			$params = str_split(str_repeat('?', count($this->values)));
81			return 'INSERT INTO ' . $this->table
82			. ' (' . implode(',', array_keys($this->values)) . ')'
83			. ' VALUES (' . implode(', ', $params) . ')';
84			}
85
86			/**
87			* UPDATE ... SET
88			* @return string
89			*/
90			public function update()
91			{
92			$keys = array_keys($this->values);
93			$columns = array_map(fn ($column) => $column . ' = ?', $keys);
94
95			return 'UPDATE ' . $this->table
96			. ' SET ' . implode(', ', $columns)
97			. $this->where()
98			. $this->limit();
99			}
100
101			/**
102			* DELETE FROM ...
103			* @return string
104			*/
105			public function delete()
106			{
107			return 'DELETE FROM ' . $this->table
108			. $this->where()
109			. $this->limit();
110			}
111
112			/**
113			* WHERE ...
114			* @param string $comparator
115			* @param mixed $values
116			*/
117			public function addWhere($comparator, $values)
118			{
119			$hasBindParams = preg_match('/[:\?]/', $comparator);
120			if ($values && !$hasBindParams) {
121			$comparator .= ' = ?';
122			}
123			$this->where[] = '(' . $comparator . ')';
124			$this->whereValues = array_merge($this->whereValues, $values);
125			}
126
127			/**
128			* JOIN, LEFT JOIN ...
129			* @param string $join
130			* @param array $values
131			*/
132			public function addJoin($join, $values)
133			{
134			$this->join[] = $join;
135			$this->joinValues = array_merge($this->joinValues, $values);
136			}
137
138			/**
139			* Define o limit
140			* @param int $offset
141			* @param int $limit
142			*/
143			public function setLimit($offset, $limit)
144			{
145			$this->limit = $offset . ',' . $limit;
146			}
147
148			private function join()
149			{
150			if (empty($this->join)) {
151			return '';
152			}
153
154			return ' ' . implode(' ', $this->join);
155			}
156
157			/**
158			* Retorna o SQL
159			* @return string
160			*/
161			private function where()
162			{
163			if (empty($this->where)) {
164			return '';
165			}
166
167			return ' WHERE ' . implode(' AND ', $this->where);
168			}
169
170			/**
171			* Define a ordenação principal
172			* @param string $orderBy
173			*/
174			public function setOrderBy($orderBy)
175			{
176			$this->orderBy = [$orderBy];
177			}
178
179			/**
180			* Adiciona uma ordenação
181			* @param string $orderBy
182			* @param int $priority
183			*/
184			public function addOrderBy($orderBy, $priority = 0)
185			{
186			$this->orderBy[$priority] = $orderBy;
187			}
188
189			/**
190			* LIMIT ...
191			* @return string
192			*/
193			private function limit()
194			{
195			if (empty($this->limit)) {
196			return '';
197			}
198
199			return ' LIMIT ' . $this->limit;
200			}
201
202
203			/**
204			* ORDER BY...
205			* @return string
206			*/
207			private function orderBy()
208			{
209			if (empty($this->orderBy)) {
210			return '';
211			}
212
213			ksort($this->orderBy);
214			return ' ORDER BY ' . implode(', ', $this->orderBy);
215			}
216			}
217

winframework / winphp

Pull Request — master (#24)

Sql::select() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like