@@ -2,21 +2,21 @@ |
||
2 | 2 | namespace Maphper\Lib\Sql; |
3 | 3 | |
4 | 4 | class In implements WhereConditional { |
5 | - public function matches($key, $value, $mode) { |
|
6 | - return !is_numeric($key) && is_array($value); |
|
7 | - } |
|
5 | + public function matches($key, $value, $mode) { |
|
6 | + return !is_numeric($key) && is_array($value); |
|
7 | + } |
|
8 | 8 | |
9 | - public function getSql($key, $value, $mode) { |
|
10 | - $args = []; |
|
11 | - $inSql = []; |
|
12 | - $count = count($value); |
|
13 | - for ($i = 0; $i < $count; $i++) { |
|
14 | - $args[$key . $i] = $value[$i]; |
|
15 | - $inSql[] = ':' . $key . $i; |
|
16 | - } |
|
17 | - if (count($inSql) == 0) return []; |
|
18 | - else $sql = [$key . ' IN ( ' . implode(', ', $inSql) . ')']; |
|
9 | + public function getSql($key, $value, $mode) { |
|
10 | + $args = []; |
|
11 | + $inSql = []; |
|
12 | + $count = count($value); |
|
13 | + for ($i = 0; $i < $count; $i++) { |
|
14 | + $args[$key . $i] = $value[$i]; |
|
15 | + $inSql[] = ':' . $key . $i; |
|
16 | + } |
|
17 | + if (count($inSql) == 0) return []; |
|
18 | + else $sql = [$key . ' IN ( ' . implode(', ', $inSql) . ')']; |
|
19 | 19 | |
20 | - return ['args' => $args, 'sql' => $sql]; |
|
21 | - } |
|
20 | + return ['args' => $args, 'sql' => $sql]; |
|
21 | + } |
|
22 | 22 | } |
@@ -2,20 +2,20 @@ |
||
2 | 2 | namespace Maphper\Lib\Sql; |
3 | 3 | |
4 | 4 | class Between implements WhereConditional { |
5 | - public function matches($key, $value, $mode) { |
|
6 | - return is_array($value) && \Maphper\Maphper::FIND_BETWEEN & $mode; |
|
7 | - } |
|
5 | + public function matches($key, $value, $mode) { |
|
6 | + return is_array($value) && \Maphper\Maphper::FIND_BETWEEN & $mode; |
|
7 | + } |
|
8 | 8 | |
9 | - public function getSql($key, $value, $mode) { |
|
10 | - return [ |
|
11 | - 'sql' => [ |
|
12 | - $key . '>= :' . $key . 'from', |
|
13 | - $key . ' <= :' . $key . 'to' |
|
14 | - ], |
|
15 | - 'args' => [ |
|
16 | - $key . 'from' => $value[0], |
|
17 | - $key . 'to' => $value[1] |
|
18 | - ] |
|
19 | - ]; |
|
20 | - } |
|
9 | + public function getSql($key, $value, $mode) { |
|
10 | + return [ |
|
11 | + 'sql' => [ |
|
12 | + $key . '>= :' . $key . 'from', |
|
13 | + $key . ' <= :' . $key . 'to' |
|
14 | + ], |
|
15 | + 'args' => [ |
|
16 | + $key . 'from' => $value[0], |
|
17 | + $key . 'to' => $value[1] |
|
18 | + ] |
|
19 | + ]; |
|
20 | + } |
|
21 | 21 | } |
@@ -2,15 +2,15 @@ |
||
2 | 2 | namespace Maphper\Lib\Sql; |
3 | 3 | |
4 | 4 | class NullConditional implements WhereConditional { |
5 | - public function matches($key, $value, $mode) { |
|
6 | - return $value === NULL; |
|
7 | - } |
|
5 | + public function matches($key, $value, $mode) { |
|
6 | + return $value === NULL; |
|
7 | + } |
|
8 | 8 | |
9 | - public function getSql($key, $value, $mode) { |
|
10 | - $nullSql = $key . ' IS '; |
|
11 | - if (\Maphper\Maphper::FIND_NOT & $mode) $nullSql .= 'NOT '; |
|
12 | - $sql = [$nullSql . 'NULL']; |
|
9 | + public function getSql($key, $value, $mode) { |
|
10 | + $nullSql = $key . ' IS '; |
|
11 | + if (\Maphper\Maphper::FIND_NOT & $mode) $nullSql .= 'NOT '; |
|
12 | + $sql = [$nullSql . 'NULL']; |
|
13 | 13 | |
14 | - return ['args' => [], 'sql' => $sql]; |
|
15 | - } |
|
14 | + return ['args' => [], 'sql' => $sql]; |
|
15 | + } |
|
16 | 16 | } |
@@ -3,21 +3,21 @@ |
||
3 | 3 | use Maphper\Maphper; |
4 | 4 | |
5 | 5 | class Like implements WhereConditional { |
6 | - public function matches($key, $value, $mode) { |
|
7 | - return (Maphper::FIND_LIKE | Maphper::FIND_STARTS | |
|
8 | - Maphper::FIND_ENDS | Maphper::FIND_NOCASE) & $mode; |
|
9 | - } |
|
6 | + public function matches($key, $value, $mode) { |
|
7 | + return (Maphper::FIND_LIKE | Maphper::FIND_STARTS | |
|
8 | + Maphper::FIND_ENDS | Maphper::FIND_NOCASE) & $mode; |
|
9 | + } |
|
10 | 10 | |
11 | - public function getSql($key, $value, $mode) { |
|
12 | - return [ |
|
13 | - 'sql' => [$key . ' LIKE :' . $key], |
|
14 | - 'args' => [$key => $this->getValue($value, $mode)] |
|
15 | - ]; |
|
16 | - } |
|
11 | + public function getSql($key, $value, $mode) { |
|
12 | + return [ |
|
13 | + 'sql' => [$key . ' LIKE :' . $key], |
|
14 | + 'args' => [$key => $this->getValue($value, $mode)] |
|
15 | + ]; |
|
16 | + } |
|
17 | 17 | |
18 | - private function getValue($value, $mode) { |
|
19 | - if ((Maphper::FIND_LIKE | Maphper::FIND_ENDS) & $mode) $value = '%' . $value; |
|
20 | - if ((Maphper::FIND_LIKE | Maphper::FIND_STARTS) & $mode) $value .= '%'; |
|
21 | - return $value; |
|
22 | - } |
|
18 | + private function getValue($value, $mode) { |
|
19 | + if ((Maphper::FIND_LIKE | Maphper::FIND_ENDS) & $mode) $value = '%' . $value; |
|
20 | + if ((Maphper::FIND_LIKE | Maphper::FIND_STARTS) & $mode) $value .= '%'; |
|
21 | + return $value; |
|
22 | + } |
|
23 | 23 | } |
@@ -3,33 +3,33 @@ |
||
3 | 3 | use Maphper\Maphper; |
4 | 4 | |
5 | 5 | class GeneralOperator implements WhereConditional { |
6 | - public function matches($key, $value, $mode) { |
|
7 | - return (Maphper::FIND_BIT ^ Maphper::FIND_GREATER ^ Maphper::FIND_LESS ^ Maphper::FIND_NOT & $mode) |
|
8 | - || Maphper::FIND_EXACT & $mode; |
|
9 | - } |
|
6 | + public function matches($key, $value, $mode) { |
|
7 | + return (Maphper::FIND_BIT ^ Maphper::FIND_GREATER ^ Maphper::FIND_LESS ^ Maphper::FIND_NOT & $mode) |
|
8 | + || Maphper::FIND_EXACT & $mode; |
|
9 | + } |
|
10 | 10 | |
11 | - public function getSql($key, $value, $mode) { |
|
12 | - return [ |
|
13 | - 'sql' => [$key . ' ' . $this->getOperator($mode) . ' :' . $key], |
|
14 | - 'args' => [$key => $value] |
|
15 | - ]; |
|
16 | - } |
|
11 | + public function getSql($key, $value, $mode) { |
|
12 | + return [ |
|
13 | + 'sql' => [$key . ' ' . $this->getOperator($mode) . ' :' . $key], |
|
14 | + 'args' => [$key => $value] |
|
15 | + ]; |
|
16 | + } |
|
17 | 17 | |
18 | - private function getOperator($mode) { |
|
19 | - if (\Maphper\Maphper::FIND_BIT & $mode) return '&'; |
|
20 | - else if (\Maphper\Maphper::FIND_NOT & $mode) return '!='; |
|
18 | + private function getOperator($mode) { |
|
19 | + if (\Maphper\Maphper::FIND_BIT & $mode) return '&'; |
|
20 | + else if (\Maphper\Maphper::FIND_NOT & $mode) return '!='; |
|
21 | 21 | |
22 | - return $this->getEqualsOperators($mode); |
|
23 | - } |
|
22 | + return $this->getEqualsOperators($mode); |
|
23 | + } |
|
24 | 24 | |
25 | - private function getEqualsOperators($mode) { |
|
26 | - $operator = ""; |
|
25 | + private function getEqualsOperators($mode) { |
|
26 | + $operator = ""; |
|
27 | 27 | |
28 | - if (\Maphper\Maphper::FIND_GREATER & $mode) $operator = '>'; |
|
29 | - else if (\Maphper\Maphper::FIND_LESS & $mode) $operator = '<'; |
|
28 | + if (\Maphper\Maphper::FIND_GREATER & $mode) $operator = '>'; |
|
29 | + else if (\Maphper\Maphper::FIND_LESS & $mode) $operator = '<'; |
|
30 | 30 | |
31 | - if (\Maphper\Maphper::FIND_EXACT & $mode) $operator .= '='; |
|
31 | + if (\Maphper\Maphper::FIND_EXACT & $mode) $operator .= '='; |
|
32 | 32 | |
33 | - return $operator; |
|
34 | - } |
|
33 | + return $operator; |
|
34 | + } |
|
35 | 35 | } |
@@ -11,9 +11,9 @@ discard block |
||
11 | 11 | $this->writeClosure = function ($field, $value) use ($object) { $object->$field = $value; }; |
12 | 12 | } |
13 | 13 | else { |
14 | - $visOverride = $this; |
|
14 | + $visOverride = $this; |
|
15 | 15 | $this->readClosure = function() use ($visOverride) { |
16 | - return (object) array_filter(get_object_vars($this), [$visOverride, 'isReturnableDataType']); |
|
16 | + return (object) array_filter(get_object_vars($this), [$visOverride, 'isReturnableDataType']); |
|
17 | 17 | }; |
18 | 18 | $this->readClosure = $this->readClosure->bindTo($object, $object); |
19 | 19 | |
@@ -23,9 +23,9 @@ discard block |
||
23 | 23 | |
24 | 24 | } |
25 | 25 | |
26 | - public function isReturnableDataType($v) { |
|
27 | - return is_scalar($v) || is_null($v) || (is_object($v) && $v instanceof \DateTime); |
|
28 | - } |
|
26 | + public function isReturnableDataType($v) { |
|
27 | + return is_scalar($v) || is_null($v) || (is_object($v) && $v instanceof \DateTime); |
|
28 | + } |
|
29 | 29 | |
30 | 30 | public function getProperties() { |
31 | 31 | return ($this->readClosure)(); |
@@ -8,7 +8,7 @@ discard block |
||
8 | 8 | private $parent; |
9 | 9 | |
10 | 10 | public function __construct(\Maphper\Maphper $parent, $className = null) { |
11 | - $this->parent = $parent; |
|
11 | + $this->parent = $parent; |
|
12 | 12 | $this->className = $className; |
13 | 13 | } |
14 | 14 | |
@@ -25,12 +25,12 @@ discard block |
||
25 | 25 | return $object; |
26 | 26 | } |
27 | 27 | |
28 | - private function addRelationData($object, $name, $relation, $siblings) { |
|
29 | - if (isset($object->$name) && !($object->$name instanceof \Maphper\Relation) ) { |
|
30 | - //After overwriting the relation, does the parent object ($object) need overwriting as well? |
|
31 | - if ($relation->overwrite($object, $object->$name)) $this->parent[] = $object; |
|
32 | - } |
|
28 | + private function addRelationData($object, $name, $relation, $siblings) { |
|
29 | + if (isset($object->$name) && !($object->$name instanceof \Maphper\Relation) ) { |
|
30 | + //After overwriting the relation, does the parent object ($object) need overwriting as well? |
|
31 | + if ($relation->overwrite($object, $object->$name)) $this->parent[] = $object; |
|
32 | + } |
|
33 | 33 | |
34 | - $object->$name = $relation->getData($object, $siblings); |
|
35 | - } |
|
34 | + $object->$name = $relation->getData($object, $siblings); |
|
35 | + } |
|
36 | 36 | } |
@@ -3,58 +3,58 @@ |
||
3 | 3 | use Maphper\Maphper; |
4 | 4 | |
5 | 5 | class ArrayFilter { |
6 | - private $array; |
|
7 | - |
|
8 | - public function __construct(array $array) { |
|
9 | - $this->array = $array; |
|
10 | - } |
|
11 | - |
|
12 | - public function filter($fields) { |
|
13 | - $filteredArray = array_filter($this->array, $this->getSearchFieldFunction($fields, \Maphper\Maphper::FIND_EXACT | \Maphper\Maphper::FIND_AND)); |
|
14 | - // Need to reset indexes |
|
15 | - $filteredArray = array_values($filteredArray); |
|
16 | - return $filteredArray; |
|
17 | - } |
|
18 | - |
|
19 | - private function getSearchFieldFunction($fields, $mode) { |
|
20 | - return function ($data) use ($fields, $mode) { |
|
21 | - foreach ($fields as $key => $val) { |
|
22 | - $currentFieldResult = $this->getIfFieldMatches($key, $val, $data, $mode); |
|
23 | - |
|
24 | - if (Maphper::FIND_OR & $mode && $currentFieldResult === true) return true; |
|
25 | - else if (Maphper::FIND_OR ^ $mode && $currentFieldResult === false) return false; |
|
26 | - } |
|
27 | - return (bool)(Maphper::FIND_OR ^ $mode); |
|
28 | - }; |
|
29 | - } |
|
30 | - |
|
31 | - private function getIfFieldMatches($key, $val, $data, $mode) { |
|
32 | - if ($this->shouldRunDeepSearch($key, $val)) { |
|
33 | - return $this->getSearchFieldFunction($val, $key)($data); |
|
34 | - } |
|
35 | - else if (!isset($data->$key)) return false; |
|
36 | - else if ($this->isInArraySearch($mode, $key, $val)) |
|
37 | - return in_array($data->$key, $val); |
|
38 | - else |
|
39 | - return $this->processFilter($mode, $val, $data->$key); |
|
40 | - } |
|
41 | - |
|
42 | - private function shouldRunDeepSearch($key, $val) { |
|
43 | - return is_numeric($key) && is_array($val); |
|
44 | - } |
|
45 | - |
|
46 | - private function isInArraySearch($mode, $key, $val) { |
|
47 | - return !(Maphper::FIND_BETWEEN & $mode) && !is_numeric($key) && is_array($val); |
|
48 | - } |
|
49 | - |
|
50 | - private function processFilter($mode, $expected, $actual) { |
|
51 | - if (Maphper::FIND_NOT & $mode) return $expected != $actual; |
|
52 | - else if ((Maphper::FIND_GREATER | Maphper::FIND_EXACT) === $mode) return $expected <= $actual; |
|
53 | - else if ((Maphper::FIND_LESS | Maphper::FIND_EXACT) === $mode) return $expected >= $actual; |
|
54 | - else if (Maphper::FIND_GREATER & $mode) return $expected < $actual; |
|
55 | - else if (Maphper::FIND_LESS & $mode) return $expected > $actual; |
|
56 | - else if (Maphper::FIND_BETWEEN & $mode) return $expected[0] <= $actual && $actual <= $expected[1]; |
|
57 | - else if (Maphper::FIND_NOCASE & $mode) return strtolower($expected) == strtolower($actual); |
|
58 | - return $expected == $actual; |
|
59 | - } |
|
6 | + private $array; |
|
7 | + |
|
8 | + public function __construct(array $array) { |
|
9 | + $this->array = $array; |
|
10 | + } |
|
11 | + |
|
12 | + public function filter($fields) { |
|
13 | + $filteredArray = array_filter($this->array, $this->getSearchFieldFunction($fields, \Maphper\Maphper::FIND_EXACT | \Maphper\Maphper::FIND_AND)); |
|
14 | + // Need to reset indexes |
|
15 | + $filteredArray = array_values($filteredArray); |
|
16 | + return $filteredArray; |
|
17 | + } |
|
18 | + |
|
19 | + private function getSearchFieldFunction($fields, $mode) { |
|
20 | + return function ($data) use ($fields, $mode) { |
|
21 | + foreach ($fields as $key => $val) { |
|
22 | + $currentFieldResult = $this->getIfFieldMatches($key, $val, $data, $mode); |
|
23 | + |
|
24 | + if (Maphper::FIND_OR & $mode && $currentFieldResult === true) return true; |
|
25 | + else if (Maphper::FIND_OR ^ $mode && $currentFieldResult === false) return false; |
|
26 | + } |
|
27 | + return (bool)(Maphper::FIND_OR ^ $mode); |
|
28 | + }; |
|
29 | + } |
|
30 | + |
|
31 | + private function getIfFieldMatches($key, $val, $data, $mode) { |
|
32 | + if ($this->shouldRunDeepSearch($key, $val)) { |
|
33 | + return $this->getSearchFieldFunction($val, $key)($data); |
|
34 | + } |
|
35 | + else if (!isset($data->$key)) return false; |
|
36 | + else if ($this->isInArraySearch($mode, $key, $val)) |
|
37 | + return in_array($data->$key, $val); |
|
38 | + else |
|
39 | + return $this->processFilter($mode, $val, $data->$key); |
|
40 | + } |
|
41 | + |
|
42 | + private function shouldRunDeepSearch($key, $val) { |
|
43 | + return is_numeric($key) && is_array($val); |
|
44 | + } |
|
45 | + |
|
46 | + private function isInArraySearch($mode, $key, $val) { |
|
47 | + return !(Maphper::FIND_BETWEEN & $mode) && !is_numeric($key) && is_array($val); |
|
48 | + } |
|
49 | + |
|
50 | + private function processFilter($mode, $expected, $actual) { |
|
51 | + if (Maphper::FIND_NOT & $mode) return $expected != $actual; |
|
52 | + else if ((Maphper::FIND_GREATER | Maphper::FIND_EXACT) === $mode) return $expected <= $actual; |
|
53 | + else if ((Maphper::FIND_LESS | Maphper::FIND_EXACT) === $mode) return $expected >= $actual; |
|
54 | + else if (Maphper::FIND_GREATER & $mode) return $expected < $actual; |
|
55 | + else if (Maphper::FIND_LESS & $mode) return $expected > $actual; |
|
56 | + else if (Maphper::FIND_BETWEEN & $mode) return $expected[0] <= $actual && $actual <= $expected[1]; |
|
57 | + else if (Maphper::FIND_NOCASE & $mode) return strtolower($expected) == strtolower($actual); |
|
58 | + return $expected == $actual; |
|
59 | + } |
|
60 | 60 | } |
@@ -2,55 +2,55 @@ |
||
2 | 2 | namespace Maphper\DataSource; |
3 | 3 | |
4 | 4 | class GeneralEditDatabase { |
5 | - private $pdo; |
|
6 | - private $dataTypes = [ |
|
7 | - 'datetime' => 'DATETIME', |
|
8 | - 'int' => 'INT(11)', |
|
9 | - 'decimal' => 'DECIMAL', |
|
10 | - 'short_string' => 'VARCHAR', |
|
11 | - 'long_string' => 'LONGBLOG', |
|
12 | - 'short_string_max_len' => 255, |
|
13 | - 'other' => 'VARCHAR(255)', |
|
5 | + private $pdo; |
|
6 | + private $dataTypes = [ |
|
7 | + 'datetime' => 'DATETIME', |
|
8 | + 'int' => 'INT(11)', |
|
9 | + 'decimal' => 'DECIMAL', |
|
10 | + 'short_string' => 'VARCHAR', |
|
11 | + 'long_string' => 'LONGBLOG', |
|
12 | + 'short_string_max_len' => 255, |
|
13 | + 'other' => 'VARCHAR(255)', |
|
14 | 14 | |
15 | - 'pk_default' => 'INT(11) NOT NULL AUTO_INCREMENT' |
|
16 | - ]; |
|
15 | + 'pk_default' => 'INT(11) NOT NULL AUTO_INCREMENT' |
|
16 | + ]; |
|
17 | 17 | |
18 | - public function __construct(\PDO $pdo, array $dataTypes) { |
|
19 | - $this->pdo = $pdo; |
|
20 | - $this->dataTypes = array_merge($this->dataTypes, $dataTypes); |
|
21 | - } |
|
18 | + public function __construct(\PDO $pdo, array $dataTypes) { |
|
19 | + $this->pdo = $pdo; |
|
20 | + $this->dataTypes = array_merge($this->dataTypes, $dataTypes); |
|
21 | + } |
|
22 | 22 | |
23 | - public function quote($str) { |
|
23 | + public function quote($str) { |
|
24 | 24 | return '`' . str_replace('.', '`.`', trim($str, '`')) . '`'; |
25 | 25 | } |
26 | 26 | |
27 | - public function getType($val) { |
|
27 | + public function getType($val) { |
|
28 | 28 | if ($val instanceof \DateTime) return $this->dataTypes['datetime']; |
29 | 29 | else if ($result = $this->doNumberTypes($val)) return $result; |
30 | 30 | else if ($result = $this->doStringTypes($val)) return $result; |
31 | 31 | else return $this->dataTypes['other']; |
32 | 32 | } |
33 | 33 | |
34 | - private function doNumberTypes($val) { |
|
35 | - if (is_int($val)) return $this->dataTypes['int']; |
|
34 | + private function doNumberTypes($val) { |
|
35 | + if (is_int($val)) return $this->dataTypes['int']; |
|
36 | 36 | else if (is_double($val)) return $this->dataTypes['decimal'] . '(9,' . strlen($val) - strrpos($val, '.') - 1 . ')'; |
37 | - else return false; |
|
38 | - } |
|
37 | + else return false; |
|
38 | + } |
|
39 | 39 | |
40 | - private function doStringTypes($val) { |
|
41 | - if (!is_string($val)) return false; |
|
42 | - if (strlen($val) <= $this->dataTypes['short_string_max_len']) |
|
43 | - return $this->dataTypes['short_string'] . '(' . $this->dataTypes['short_string_max_len'] . ')'; |
|
40 | + private function doStringTypes($val) { |
|
41 | + if (!is_string($val)) return false; |
|
42 | + if (strlen($val) <= $this->dataTypes['short_string_max_len']) |
|
43 | + return $this->dataTypes['short_string'] . '(' . $this->dataTypes['short_string_max_len'] . ')'; |
|
44 | 44 | else return $this->dataTypes['long_string']; |
45 | - } |
|
45 | + } |
|
46 | 46 | |
47 | - public function isNotSavableType($value, $key, $primaryKey) { |
|
48 | - return is_array($value) || (is_object($value) && !($value instanceof \DateTime)) || |
|
49 | - in_array($key, $primaryKey); |
|
50 | - } |
|
47 | + public function isNotSavableType($value, $key, $primaryKey) { |
|
48 | + return is_array($value) || (is_object($value) && !($value instanceof \DateTime)) || |
|
49 | + in_array($key, $primaryKey); |
|
50 | + } |
|
51 | 51 | |
52 | - //Alter the database so that it can store $data |
|
53 | - public function createTable($table, array $primaryKey, $data) { |
|
52 | + //Alter the database so that it can store $data |
|
53 | + public function createTable($table, array $primaryKey, $data) { |
|
54 | 54 | $parts = []; |
55 | 55 | foreach ($primaryKey as $key) { |
56 | 56 | $pk = $data->$key; |