WherePrepareTrait::normalizeWhereArray() - Code Metrics - Inspection of "调整：表创建工具" - dxkite/suda - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Push — master ( acba12...b2f89b )

by 世昌

created 2019-12-14 09:18 UTC

WherePrepareTrait::normalizeWhereArray() A

↳ Parent: WherePrepareTrait

Complexity

Conditions	5
Paths	4

Size

Total Lines	14
Code Lines	9

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
cc	5
eloc	9
nc	4
nop	1
dl	0
loc	14
rs	9.6111
c	1
b	0
f	0

<?php


namespace suda\database\statement;

use Countable;
use IteratorAggregate;
use suda\database\Binder;
use suda\database\exception\SQLException;

trait WherePrepareTrait
{

    /**
     * 处理？模板
     *
     * @param string $sql
     * @param array $parameter
     * @return array
     */
    public function prepareQueryMark(string $sql, array $parameter)
    {
        $binders = [];
        $query = preg_replace_callback('/\?/', function ($match) use (&$binders, $parameter) {
            $index = count($binders);
            if (array_key_exists($index, $parameter)) {
                $name = Binder::index($index);
                if (is_array($parameter[$index]) || $parameter[$index] instanceof IteratorAggregate) {
                    list($inSQL, $inBinders) = $this->prepareInParameter($parameter[$index], $index);
                    $binders = array_merge($binders, $inBinders);
                    return $inSQL;
                } else {
                    $binder = new Binder($name, $parameter[$index]);
                    $binders[] = $binder;
                    return ':' . $binder->getName();
                }
            }
            return $match[0];
        }, $sql);
        return [$query, $binders];
    }

    /**
     * 处理In语句
     * @param IteratorAggregate|array $values
     * @param string $name
     * @return array
     * @throws SQLException
     */
    public function prepareInParameter($values, string $name)
    {
        if ($this->count($values) <= 0) {
            throw new SQLException('on field ' . $name . ' value can\'t be empty array');
        }
        $names = [];
        $binders = [];
        foreach ($values as $value) {
            $_name = Binder::index($name);
            $binders[] = new Binder($_name, $value);
            $names[] = ':' . $_name;
        }
        return [implode(',', $names), $binders];
    }

    /**
     * @param array|Countable|IteratorAggregate $value
     * @return int
     */
    public function count($value)
    {
        if (is_array($value) || $value instanceof Countable) {
            return count($value);
        }
        return iterator_count($value);
    }

    /**
     * @param string $name
     * @param string $operator
     * @param mixed $value
     * @param string $indexName
     * @return Query
     * @throws SQLException
     */
    public function createQueryOperation(string $name, string $operator, $value, string $indexName = '')
    {
        if ($value instanceof Query) {
            return new Query("`{$name}` {$operator} " . $value, $value->getBinder());
        }
        if ($value instanceof Statement) {
            return new Query("`{$name}` {$operator} (" . $value->getQuery() . ')', $value->getBinder());
        }
        if ($value instanceof IteratorAggregate || is_array($value)) {
            return $this->prepareIn($name, $operator, $value);
        }
        if (strlen($indexName) === 0) {
            $indexName = Binder::index($name);
        }
        return new Query("`{$name}` {$operator} :{$indexName}", [new Binder($indexName, $value)]);
    }

    /**
     * @param string $name
     * @param string $operator
     * @param $value
     * @return Query
     * @throws SQLException
     */
    public function getQueryForArray(string $name, string $operator, $value)
    {
        if ($value instanceof IteratorAggregate || is_array($value)) {
            return $this->prepareIn($name, 'IN', $value);
        } else {
            return $this->createQueryOperation($name, $operator, $value);
        }
    }

    /**
     * @param string $where
     * @param array $whereBinder
     * @return array
     * @throws SQLException
     */
    public function prepareWhereString(string $where, array $whereBinder)
    {
        $newWhereBinder = [];
        foreach ($whereBinder as $name => $value) {
            $query = $this->getQueryForString($where, $name, $value);
            $where = $query->getQuery();
            $newWhereBinder = array_merge($newWhereBinder, $query->getBinder());
        }
        return [$where, $newWhereBinder];
    }

    /**
     * 准备条件列
     *
     * @param array $where
     * @return array
     * @throws SQLException
     */
    public function prepareWhere(array $where)
    {
        $whereArray = $this->normalizeWhereArray($where);
        $and = [];
        $binders = [];
        foreach ($whereArray as $item) {
            list($name, $option, $value) = $this->fixWhereArray($item);
            $query = $this->getQueryForArray($name, $option, $value);
            $and[] = $query->getQuery();
            $binders = array_merge($binders, $query->getBinder());
        }
        return [implode(' AND ', $and), $binders];
    }

    /**
     * @param array $item
     * @return array
     */
    protected function fixWhereArray(array $item) {
        if (count($item) === 2) {
            list($name, $value) = $item;
            return [$name, '=', $value];
        }
        return $item;
    }

    /**
     * @param array $where
     * @return array
     */
    protected function normalizeWhereArray(array $where)
    {
        if ($this->isNumberArray($where)) {
            return $where;
        }
        $newWhere = [];
        foreach ($where as $name => $value) {
            if (is_array($value) && $this->count($value) === 2) {
                $newWhere[] = [$name, $value[0], $value[1]];
            } else {
                $newWhere[] = [$name, '=', $value];
            }
        }
        return $newWhere;
    }

    /**
     * @param array $where
     * @return bool
     */
    protected function isNumberArray(array $where)
    {
        return is_numeric(key($where)) && array_keys($where) === range(0, count($where) - 1);
    }

    /**
     * @param string $where
     * @param string $name
     * @param $value
     * @return Query
     * @throws SQLException
     */
    public function getQueryForString(string $where, string $name, $value)
    {
        if (is_array($value) || $value instanceof IteratorAggregate) {
            list($inSQL, $binders) = $this->prepareInParameter($value, $name);
            $where = $this->replaceQuote($name, $inSQL, $where);
            return new Query($where, $binders);
        } elseif ($value instanceof Binder) {
            return new Query($where, [$value]);
        } else {
            return new Query($where, [new Binder($name, $value)]);
        }
    }

    /**
     * 准备In
     *
     * @param string $name
     * @param string $operation
     * @param IteratorAggregate|array|Query|Statement $values
     * @return Query
     * @throws SQLException
     */
    public function prepareIn(string $name, string $operation, $values)
    {
        if ($values instanceof Query || $values instanceof Statement) {
            return $this->createQueryOperation($name, 'in', $values);
        }
        list($inSQL, $binders) = $this->prepareInParameter($values, $name);
        $sql = '`' . $name . '` ' . strtoupper($operation) . ' (' . $inSQL . ')';
        return new Query($sql, $binders);
    }

    /**
     * 替换占位符
     *
     * @param string $name
     * @param string $replace
     * @param string $target
     * @return string
     */
    public function replaceQuote(string $name, string $replace, string $target)
    {
        $name = ltrim($name, ':');
        return preg_replace('/(?<!_):' . preg_quote($name) . '/', $replace, $target);
    }
}


1			<?php
2
3
4			namespace suda\database\statement;
5
6			use Countable;
7			use IteratorAggregate;
8			use suda\database\Binder;
9			use suda\database\exception\SQLException;
10
11			trait WherePrepareTrait
12			{
13
14			/**
15			* 处理？模板
16			*
17			* @param string $sql
18			* @param array $parameter
19			* @return array
20			*/
21			public function prepareQueryMark(string $sql, array $parameter)
22			{
23			$binders = [];
24			$query = preg_replace_callback('/\?/', function ($match) use (&$binders, $parameter) {
25			$index = count($binders);
26			if (array_key_exists($index, $parameter)) {
27			$name = Binder::index($index);
28			if (is_array($parameter[$index]) \|\| $parameter[$index] instanceof IteratorAggregate) {
29			list($inSQL, $inBinders) = $this->prepareInParameter($parameter[$index], $index);
30			$binders = array_merge($binders, $inBinders);
31			return $inSQL;
32			} else {
33			$binder = new Binder($name, $parameter[$index]);
34			$binders[] = $binder;
35			return ':' . $binder->getName();
36			}
37			}
38			return $match[0];
39			}, $sql);
40			return [$query, $binders];
41			}
42
43			/**
44			* 处理In语句
45			* @param IteratorAggregate\|array $values
46			* @param string $name
47			* @return array
48			* @throws SQLException
49			*/
50			public function prepareInParameter($values, string $name)
51			{
52			if ($this->count($values) <= 0) {
53			throw new SQLException('on field ' . $name . ' value can\'t be empty array');
54			}
55			$names = [];
56			$binders = [];
57			foreach ($values as $value) {
58			$_name = Binder::index($name);
59			$binders[] = new Binder($_name, $value);
60			$names[] = ':' . $_name;
61			}
62			return [implode(',', $names), $binders];
63			}
64
65			/**
66			* @param array\|Countable\|IteratorAggregate $value
67			* @return int
68			*/
69			public function count($value)
70			{
71			if (is_array($value) \|\| $value instanceof Countable) {
72			return count($value);
73			}
74			return iterator_count($value);
75			}
76
77			/**
78			* @param string $name
79			* @param string $operator
80			* @param mixed $value
81			* @param string $indexName
82			* @return Query
83			* @throws SQLException
84			*/
85			public function createQueryOperation(string $name, string $operator, $value, string $indexName = '')
86			{
87			if ($value instanceof Query) {
88			return new Query("`{$name}` {$operator} " . $value, $value->getBinder());
89			}
90			if ($value instanceof Statement) {
91			return new Query("`{$name}` {$operator} (" . $value->getQuery() . ')', $value->getBinder());
92			}
93			if ($value instanceof IteratorAggregate \|\| is_array($value)) {
94			return $this->prepareIn($name, $operator, $value);
95			}
96			if (strlen($indexName) === 0) {
97			$indexName = Binder::index($name);
98			}
99			return new Query("`{$name}` {$operator} :{$indexName}", [new Binder($indexName, $value)]);
100			}
101
102			/**
103			* @param string $name
104			* @param string $operator
105			* @param $value
106			* @return Query
107			* @throws SQLException
108			*/
109			public function getQueryForArray(string $name, string $operator, $value)
110			{
111			if ($value instanceof IteratorAggregate \|\| is_array($value)) {
112			return $this->prepareIn($name, 'IN', $value);
113			} else {
114			return $this->createQueryOperation($name, $operator, $value);
115			}
116			}
117
118			/**
119			* @param string $where
120			* @param array $whereBinder
121			* @return array
122			* @throws SQLException
123			*/
124			public function prepareWhereString(string $where, array $whereBinder)
125			{
126			$newWhereBinder = [];
127			foreach ($whereBinder as $name => $value) {
128			$query = $this->getQueryForString($where, $name, $value);
129			$where = $query->getQuery();
130			$newWhereBinder = array_merge($newWhereBinder, $query->getBinder());
131			}
132			return [$where, $newWhereBinder];
133			}
134
135			/**
136			* 准备条件列
137			*
138			* @param array $where
139			* @return array
140			* @throws SQLException
141			*/
142			public function prepareWhere(array $where)
143			{
144			$whereArray = $this->normalizeWhereArray($where);
145			$and = [];
146			$binders = [];
147			foreach ($whereArray as $item) {
148			list($name, $option, $value) = $this->fixWhereArray($item);
149			$query = $this->getQueryForArray($name, $option, $value);
150			$and[] = $query->getQuery();
151			$binders = array_merge($binders, $query->getBinder());
152			}
153			return [implode(' AND ', $and), $binders];
154			}
155
156			/**
157			* @param array $item
158			* @return array
159			*/
160			protected function fixWhereArray(array $item) {
161			if (count($item) === 2) {
162			list($name, $value) = $item;
163			return [$name, '=', $value];
164			}
165			return $item;
166			}
167
168			/**
169			* @param array $where
170			* @return array
171			*/
172			protected function normalizeWhereArray(array $where)
173			{
174			if ($this->isNumberArray($where)) {
175			return $where;
176			}
177			$newWhere = [];
178			foreach ($where as $name => $value) {
179			if (is_array($value) && $this->count($value) === 2) {
180			$newWhere[] = [$name, $value[0], $value[1]];
181			} else {
182			$newWhere[] = [$name, '=', $value];
183			}
184			}
185			return $newWhere;
186			}
187
188			/**
189			* @param array $where
190			* @return bool
191			*/
192			protected function isNumberArray(array $where)
193			{
194			return is_numeric(key($where)) && array_keys($where) === range(0, count($where) - 1);
195			}
196
197			/**
198			* @param string $where
199			* @param string $name
200			* @param $value
201			* @return Query
202			* @throws SQLException
203			*/
204			public function getQueryForString(string $where, string $name, $value)
205			{
206			if (is_array($value) \|\| $value instanceof IteratorAggregate) {
207			list($inSQL, $binders) = $this->prepareInParameter($value, $name);
208			$where = $this->replaceQuote($name, $inSQL, $where);
209			return new Query($where, $binders);
210			} elseif ($value instanceof Binder) {
211			return new Query($where, [$value]);
212			} else {
213			return new Query($where, [new Binder($name, $value)]);
214			}
215			}
216
217			/**
218			* 准备In
219			*
220			* @param string $name
221			* @param string $operation
222			* @param IteratorAggregate\|array\|Query\|Statement $values
223			* @return Query
224			* @throws SQLException
225			*/
226			public function prepareIn(string $name, string $operation, $values)
227			{
228			if ($values instanceof Query \|\| $values instanceof Statement) {
229			return $this->createQueryOperation($name, 'in', $values);
230			}
231			list($inSQL, $binders) = $this->prepareInParameter($values, $name);
232			$sql = '`' . $name . '` ' . strtoupper($operation) . ' (' . $inSQL . ')';
233			return new Query($sql, $binders);
234			}
235
236			/**
237			* 替换占位符
238			*
239			* @param string $name
240			* @param string $replace
241			* @param string $target
242			* @return string
243			*/
244			public function replaceQuote(string $name, string $replace, string $target)
245			{
246			$name = ltrim($name, ':');
247			return preg_replace('/(?<!_):' . preg_quote($name) . '/', $replace, $target);
248			}
249			}
250

dxkite / suda

Push — master ( acba12...b2f89b )

WherePrepareTrait::normalizeWhereArray() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like