View GitHub Repository querymaker

Schedule Inspection
Subscribe
Completed
Push — master ( fde9d1...e3e1f6 )
by Midori
24:56 queued 10:02
created
Status
Category
Toggle Patches
src/QueryMaker.php 1 patch
Spacing   +16 added lines, -16 removed lines patch added patch discarded remove patch 
@@ -28,16 +28,16 @@  discard block
 
 block discarded – undo
28 28 
     {
29 29 
         $instance = new QueryMaker();
30 30 
         $columnsText = implode(', ', $columns);
31 
-        $instance->statement = 'SELECT '.$columnsText.' FROM '.$table;
32 
-        $instance->query = 'SELECT '.$columnsText.' FROM '.$table;
31 
+        $instance->statement = 'SELECT ' . $columnsText . ' FROM ' . $table;
32 
+        $instance->query = 'SELECT ' . $columnsText . ' FROM ' . $table;
33 33 
         return $instance;
34 34 
     }
35 35
36 36 
     public static function update($table, array $values): QueryInterface
37 37 
     {
38 38 
         $instance = new QueryMaker();
39 
-        $instance->statement = 'UPDATE '.$table.' SET ';
40 
-        $instance->query = 'UPDATE '.$table.' SET ';
39 
+        $instance->statement = 'UPDATE ' . $table . ' SET ';
40 
+        $instance->query = 'UPDATE ' . $table . ' SET ';
41 41 
         $instance->prepareParams($values, ', ');
42 42 
         return $instance;
43 43 
     }
 
@@ -45,16 +45,16 @@  discard block
 
 block discarded – undo
45 45 
     public static function delete($table): QueryInterface
46 46 
     {
47 47 
         $instance = new QueryMaker();
48 
-        $instance->statement = 'DELETE FROM '.$table;
49 
-        $instance->query = 'DELETE FROM '.$table;
48 
+        $instance->statement = 'DELETE FROM ' . $table;
49 
+        $instance->query = 'DELETE FROM ' . $table;
50 50 
         return $instance;
51 51 
     }
52 52
53 53 
     public function where($key, $value): QueryInterface
54 54 
     {
55 55 
         $operator = $this->getOperator($value);
56 
-        $this->statement .= ' WHERE '.$key.$operator.':'.$key;
57 
-        $this->query .= ' WHERE '.$key.$operator.'\''.$value.'\'';
56 
+        $this->statement .= ' WHERE ' . $key . $operator . ':' . $key;
57 
+        $this->query .= ' WHERE ' . $key . $operator . '\'' . $value . '\'';
58 58 
         $this->params[$key] = $value;
59 59 
         return $this;
60 60 
     }
 
@@ -77,8 +77,8 @@  discard block
 
 block discarded – undo
77 77
78 78 
     public function between($key, $before, $after): QueryInterface
79 79 
     {
80 
-        $this->query .= $key." BETWEEN $before AND $after";
81 
-        $this->statement .= $key.' BETWEEN :before AND :after';
80 
+        $this->query .= $key . " BETWEEN $before AND $after";
81 
+        $this->statement .= $key . ' BETWEEN :before AND :after';
82 82
83 83 
         $this->params['before'] = $before;
84 84 
         $this->params['after'] = $after;
 
@@ -108,16 +108,16 @@  discard block
 
 block discarded – undo
108 108 
         foreach ($values as $key => $value) {
109 109 
             $operator = $this->getOperator($value);
110 110 
             if (!isset($this->params[$key])) {
111 
-                $queryValues[] = $key.$operator.'\''.$value.'\'';
112 
-                $params [] = $key.$operator.':'.$key;
111 
+                $queryValues[] = $key . $operator . '\'' . $value . '\'';
112 
+                $params [] = $key . $operator . ':' . $key;
113 113
114 114 
                 $this->params[$key] = $value;
115 115 
             } else {
116 116 
                 $uniqid = uniqid('', true);
117 
-                $queryValues[] = $key.$operator.'\''.$value.'\'';
118 
-                $params [] = $key.$operator.':'.$key.$uniqid;
117 
+                $queryValues[] = $key . $operator . '\'' . $value . '\'';
118 
+                $params [] = $key . $operator . ':' . $key . $uniqid;
119 119
120 
-                $this->params[$key.$uniqid] = $value;
120 
+                $this->params[$key . $uniqid] = $value;
121 121 
             }
122 122 
         }
123 123 
 
@@ -127,7 +127,7 @@  discard block
 
 block discarded – undo
127 127
128 128 
     private function getOperator(&$value)
129 129 
     {
130 
-        $hasOperator = preg_match('~^(([<>=])+(=)*)~', (string)$value, $matches);
130 
+        $hasOperator = preg_match('~^(([<>=])+(=)*)~', (string) $value, $matches);
131 131 
         if (!empty($hasOperator)) {
132 132 
             $operator = reset($matches);
133 133 
             $value = substr($value, strlen($operator));
Please login to merge, or discard this patch.