caoym / phpboot

src/DB/impls.php

Spacing +150 added lines, -150 removed lines

@@ -7,14 +7,14 @@ 
 use PhpBoot\DB\rules\basic\BasicRule;
 use PhpBoot\DB\Context;
 
-class ExecResult{
-    public function __construct($success, $pdo, $st){
+class ExecResult {
+    public function __construct($success, $pdo, $st) {
         $this->pdo = $pdo;
         $this->st = $st;
         $this->success = $success;
         $this->rows = $this->st->rowCount();
     }
-    public function lastInsertId($name=null){
+    public function lastInsertId($name = null) {
         return $this->pdo->lastInsertId($name);
     }
     /**
@@ -41,21 +41,21 @@ 
 
 class SelectImpl
 {
-    static  public function select($context, $columns){
+    static  public function select($context, $columns) {
         $context->appendSql("SELECT $columns");
     }
 }
 
 class FromImpl
 {
-    static public function from($context, $tables,$as=null){
-        if($tables instanceof BasicRule){
+    static public function from($context, $tables, $as = null) {
+        if ($tables instanceof BasicRule) {
             $context->appendSql("FROM (".$tables->context->sql.')');
-            $context->params = array_merge($context->params,$tables->context->params);
+            $context->params = array_merge($context->params, $tables->context->params);
         }else {
             $context->appendSql("FROM ".DB::wrap($tables));
         }
-        if($as){
+        if ($as) {
             $context->appendSql("as ".DB::wrap($as));
         }
     }
@@ -73,9 +73,9 @@ 
 {
     static public function join($context, $type, $table) {
         $table = DB::wrap($table);
-        if($type){
+        if ($type) {
             $context->appendSql("$type JOIN $table");
-        }else{
+        }else {
             $context->appendSql("JOIN $table");
         }
     }
@@ -90,14 +90,14 @@ 
 
 class ForUpdateImpl
 {
-    static public function forUpdate($context){
+    static public function forUpdate($context) {
         $context->appendSql("FOR UPDATE");
     }
 }
 
 class ForUpdateOfImpl
 {
-    static public function of($context, $column){
+    static public function of($context, $column) {
         $column = DB::wrap($column);
         $context->appendSql("OF $column");
     }
@@ -119,27 +119,27 @@ 
 }
 class ValuesImpl
 {
-    static public function values($context, $values){
+    static public function values($context, $values) {
         $params = [];
         $stubs = [];
-        foreach ($values as $v){
-            if(is_a($v, Raw::class)){//直接拼接sql，不需要转义
-                $stubs[]=$v->get();
-            }else{
-                $stubs[]='?';
+        foreach ($values as $v) {
+            if (is_a($v, Raw::class)) {//直接拼接sql，不需要转义
+                $stubs[] = $v->get();
+            }else {
+                $stubs[] = '?';
                 $params[] = $v;
             }
         }
         $stubs = implode(',', $stubs);
 
-        if(array_keys($values) === range(0, count($values) - 1)){
+        if (array_keys($values) === range(0, count($values) - 1)) {
             //VALUES(val0, val1, val2)
             $context->appendSql("VALUES($stubs)");
 
-        }else{
+        }else {
             //(col0, col1, col2) VALUES(val0, val1, val2)
-            $columns = implode(',', array_map(function($k){return DB::wrap($k);}, array_keys($values)));
-            $context->appendSql("($columns) VALUES($stubs)",false);
+            $columns = implode(',', array_map(function($k) {return DB::wrap($k); }, array_keys($values)));
+            $context->appendSql("($columns) VALUES($stubs)", false);
         }
         $context->appendParams($params);
     }
@@ -148,7 +148,7 @@ 
 
 class UpdateImpl
 {
-    static public function update($context, $table){
+    static public function update($context, $table) {
         $table = DB::wrap($table);
         $context->appendSql("UPDATE $table");
     }
@@ -156,81 +156,81 @@ 
 
 class UpdateSetImpl
 {
-    public function set(Context $context, $expr, $args){
-        if(is_string($expr)){
+    public function set(Context $context, $expr, $args) {
+        if (is_string($expr)) {
             return $this->setExpr($context, $expr, $args);
-        }else{
+        }else {
             return $this->setArgs($context, $expr);
         }
     }
 
-    public function setExpr(Context $context, $expr, $args){
-        if($this->first){
+    public function setExpr(Context $context, $expr, $args) {
+        if ($this->first) {
             $this->first = false;
             $prefix = 'SET ';
-        }else{
+        }else {
             $prefix = ',';
         }
 
-        $context->appendSql("$prefix$expr",$prefix == 'SET ');
+        $context->appendSql("$prefix$expr", $prefix == 'SET ');
         $context->appendParams($args);
 
     }
-    public function setArgs(Context $context, $values){
+    public function setArgs(Context $context, $values) {
         $set = [];
         $params = [];
-        foreach ($values as $k=>$v){
+        foreach ($values as $k=>$v) {
             $k = DB::wrap($k);
-            if(is_a($v, Raw::class)){//直接拼接sql，不需要转义
-                $set[]= "$k=".$v->get();
-            }else{
-                $set[]= "$k=?";
-                $params[]=$v;
+            if (is_a($v, Raw::class)) {//直接拼接sql，不需要转义
+                $set[] = "$k=".$v->get();
+            }else {
+                $set[] = "$k=?";
+                $params[] = $v;
             }
         }
-        if($this->first){
+        if ($this->first) {
             $this->first = false;
             $context->appendSql('SET '.implode(',', $set));
             $context->appendParams($params);
-        }else{
-            $context->appendSql(','.implode(',', $set),false);
+        }else {
+            $context->appendSql(','.implode(',', $set), false);
             $context->appendParams($params);
         }
     }
-    private $first=true;
+    private $first = true;
 }
 class OrderByImpl
 {
-    public function orderByArgs(Context $context, $orders){
-        if(empty($orders)){
+    public function orderByArgs(Context $context, $orders) {
+        if (empty($orders)) {
             return $this;
         }
         $params = array();
-        foreach ($orders as $k=>$v){
-            if(is_integer($k)){
+        foreach ($orders as $k=>$v) {
+            if (is_integer($k)) {
                 $params[] = DB::wrap($v);
-            }else{
+            }else {
                 $k = DB::wrap($k);
 
                 $v = strtoupper($v);
-                ($v =='DESC' || $v =='ASC') or \PhpBoot\abort( new \InvalidArgumentException("invalid params for orderBy(".json_encode($orders).")"));
+                ($v == 'DESC' || $v == 'ASC') or \PhpBoot\abort(new \InvalidArgumentException("invalid params for orderBy(".json_encode($orders).")"));
 
                 $params[] = "$k $v";
             }
         }
-        if($this->first){
+        if ($this->first) {
             $this->first = false;
             $context->appendSql('ORDER BY '.implode(',', $params));
-        }else{
-            $context->appendSql(','.implode(',', $params),false);
+        }else {
+            $context->appendSql(','.implode(',', $params), false);
         }
         return $this;
     }
-    public function orderBy(Context $context, $column, $order=null){
-        if(is_string($column)){
-            if($order === null){
+    public function orderBy(Context $context, $column, $order = null) {
+        if (is_string($column)) {
+            if ($order === null) {
                 $column = [$column];
-            }else{
+            }else {
                 $column = [$column=>$order];
             }
         }
@@ -238,18 +238,18 @@ 
 
 
     }
-    private $first=true;
+    private $first = true;
 }
 
 class LimitImpl
 {
-    static public function limit(Context $context, $size){
+    static public function limit(Context $context, $size) {
         $intSize = intval($size);
         strval($intSize) == $size or \PhpBoot\abort(
             new \InvalidArgumentException("invalid params for limit($size)"));
         $context->appendSql("LIMIT $size");
     }
-    static public function limitWithOffset(Context $context, $start, $size){
+    static public function limitWithOffset(Context $context, $start, $size) {
         $intStart = intval($start);
         $intSize = intval($size);
         strval($intStart) == $start && strval($intSize) == $size or \PhpBoot\abort(
@@ -258,31 +258,31 @@ 
     }
 }
 
-class WhereImpl{
+class WhereImpl {
 
-    static private function findQ($str,$offset = 0,$no=0){
+    static private function findQ($str, $offset = 0, $no = 0) {
         $found = strpos($str, '?', $offset);
-        if($no == 0 || $found === false){
+        if ($no == 0 || $found === false) {
             return $found;
         }
-        return self::findQ($str, $found+1, $no-1);
+        return self::findQ($str, $found + 1, $no - 1);
     }
 
-    static public function where(Context $context, $prefix, $expr, $args){
-        if(empty($expr)){
+    static public function where(Context $context, $prefix, $expr, $args) {
+        if (empty($expr)) {
             return;
         }
-        if(is_callable($expr)){
-            self::conditionClosure($context,$prefix, $expr);
-        }elseif (is_string($expr)){
+        if (is_callable($expr)) {
+            self::conditionClosure($context, $prefix, $expr);
+        }elseif (is_string($expr)) {
             self::condition($context, $prefix, $expr, $args);
-        }else{
+        }else {
             self::conditionArgs($context, $prefix, $expr);
         }
 
     }
 
-    static public function conditionClosure(Context $context, $prefix, callable $callback){
+    static public function conditionClosure(Context $context, $prefix, callable $callback) {
         $context->appendSql($prefix.' (');
         $callback($context);
         $context->appendSql(')');
@@ -308,15 +308,15 @@ 
      * NOT IN   'id'=>['NOT IN' => [1,2,3]]
      * @return void
      */
-    static public function conditionArgs(Context $context, $prefix, $args=[]){
-        if($args ===null){
-            return ;
+    static public function conditionArgs(Context $context, $prefix, $args = []) {
+        if ($args === null) {
+            return;
         }
         $exprs = array();
         $params = array();
-        foreach ($args as $k => $v){
+        foreach ($args as $k => $v) {
             $k = DB::wrap($k);
-            if(!is_array($v)){
+            if (!is_array($v)) {
                 $v = ['='=>$v];
             }
 
@@ -328,56 +328,56 @@ 
                 new \InvalidArgumentException("invalid param $op for whereArgs"));
 
             $var = array_values($v)[0];
-            if($op == 'IN' || $op == 'NOT IN'){
+            if ($op == 'IN' || $op == 'NOT IN') {
                 $stubs = [];
 
-                if($var instanceof BasicRule){
+                if ($var instanceof BasicRule) {
                     $stubs = "({$var->context->sql})";
                     $params = array_merge($params, $var->context->params);
                     $exprs[] = "$k $op $stubs";
-                }else{
-                    foreach ($var as $i){
-                        if(is_a($i, Raw::class)){
-                            $stubs[]=strval($i);
-                        }elseif($i instanceof BasicRule){
+                }else {
+                    foreach ($var as $i) {
+                        if (is_a($i, Raw::class)) {
+                            $stubs[] = strval($i);
+                        }elseif ($i instanceof BasicRule) {
                             $stubs = "({$i->context->sql})";
                             $params = array_merge($params, $i->context->params);
-                        }else{
-                            $stubs[]='?';
+                        }else {
+                            $stubs[] = '?';
                             $params[] = $i;
                         }
                     }
                     $stubs = implode(',', $stubs);
                     $exprs[] = "$k $op ($stubs)";
                 }
-            }else if($op == 'BETWEEN'){
+            }else if ($op == 'BETWEEN') {
                 $cond = "$k BETWEEN";
-                if(is_a($var[0], Raw::class)){
+                if (is_a($var[0], Raw::class)) {
                     $cond = "$cond ".strval($var[0]);
-                }elseif($var[0] instanceof BasicRule){
+                }elseif ($var[0] instanceof BasicRule) {
                     $cond = "$cond ({$var[0]->context->sql})";
                     $params = array_merge($params, $var[0]->context->params);
-                }else{
+                }else {
                     $cond = "$cond ?";
                     $params[] = $var[0];
                 }
-                if(is_a($var[1], Raw::class)){
+                if (is_a($var[1], Raw::class)) {
                     $cond = "$cond AND ".strval($var[1]);
-                }elseif($var[1] instanceof BasicRule){
+                }elseif ($var[1] instanceof BasicRule) {
                     $cond = "$cond AND ({$var[1]->context->sql})";
                     $params = array_merge($params, $var[1]->context->params);
-                }else{
+                }else {
                     $cond = "$cond AND ?";
                     $params[] = $var[1];
                 }
                 $exprs[] = $cond;
-            }else{
-                if(is_a($var, Raw::class)){
+            }else {
+                if (is_a($var, Raw::class)) {
                     $exprs[] = "$k $op ".strval($var);
-                }elseif($var instanceof BasicRule){
+                }elseif ($var instanceof BasicRule) {
                     $exprs[] = "$k $op {$var->context->sql}";
                     $params = array_merge($params, $var->context->params);
-                }else{
+                }else {
                     $exprs[] = "$k $op ?";
                     $params[] = $var;
                 }
@@ -386,22 +386,22 @@ 
 
         self::condition($context, $prefix, implode(' AND ', $exprs), $params);
     }
-    static public function condition(Context $context, $prefix, $expr, $args){
-        if(!empty($expr)){
+    static public function condition(Context $context, $prefix, $expr, $args) {
+        if (!empty($expr)) {
             $expr = "($expr)";
-            if($args){
+            if ($args) {
                 //因为PDO不支持绑定数组变量, 这里需要手动展开数组
                 //也就是说把 where("id IN(?)", [1,2])  展开成 where("id IN(?,?)", 1,2)
                 $cutted = null;
                 $cut = null;
                 $toReplace = array();
 
-                $newArgs=array();
+                $newArgs = array();
                 //找到所有数组对应的?符位置
-                foreach ($args as $k =>$arg){
-                    if(is_array($arg) || is_a($arg, Raw::class) || is_a($arg, BasicRule::class)){
+                foreach ($args as $k =>$arg) {
+                    if (is_array($arg) || is_a($arg, Raw::class) || is_a($arg, BasicRule::class)) {
 
-                        if(!$cutted){
+                        if (!$cutted) {
                             $cut = new NestedStringCut($expr);
                             $cutted = $cut->getText();
                         }
@@ -411,54 +411,54 @@ 
                         $pos !== false or \PhpBoot\abort(
                             new \InvalidArgumentException("unmatched params and ? @ $expr"));
 
-                        if(is_array($arg)){
+                        if (is_array($arg)) {
                             $stubs = [];
-                            foreach ($arg as $i){
-                                if(is_a($i, Raw::class)){
+                            foreach ($arg as $i) {
+                                if (is_a($i, Raw::class)) {
                                     $stubs[] = strval($i);
-                                }else{
+                                }else {
                                     $stubs[] = '?';
                                     $newArgs[] = $i;
                                 }
                             }
                             $stubs = implode(',', $stubs);
-                        }elseif($arg instanceof BasicRule){
+                        }elseif ($arg instanceof BasicRule) {
                             $stubs = "({$arg->context->sql})";
                             $newArgs = array_merge($newArgs, $arg->context->params);
-                        }else{
+                        }else {
                             $stubs = strval($arg);
                         }
                         $toReplace[] = [$pos, $stubs];
 
-                    }else{
-                        $newArgs[]=$arg;
+                    }else {
+                        $newArgs[] = $arg;
                     }
                 }
 
-                if(count($toReplace)){
+                if (count($toReplace)) {
                     $toReplace = array_reverse($toReplace);
-                    foreach ($toReplace as $i){
+                    foreach ($toReplace as $i) {
                         list($pos, $v) = $i;
-                        $expr = substr($expr, 0, $pos).$v.substr($expr, $pos+1);
+                        $expr = substr($expr, 0, $pos).$v.substr($expr, $pos + 1);
                     }
                     $args = $newArgs;
                 }
             }
-            if($prefix){
+            if ($prefix) {
                 $context->appendSql($prefix.' '.$expr);
-            }else{
+            }else {
                 $context->appendSql($expr);
             }
 
-            if($args){
+            if ($args) {
                 $context->appendParams($args);
             }
         }
     }
 }
 
-class GroupByImpl{
-    static public function groupBy(Context $context, $column){
+class GroupByImpl {
+    static public function groupBy(Context $context, $column) {
         $column = DB::wrap($column);
         $context->appendSql("GROUP BY $column");
     }
@@ -483,20 +483,20 @@ 
      * @param string|false $asDict return  as dict or array
      * @return false|array
      */
-    static public function get($context, $dictAs=false){
+    static public function get($context, $dictAs = false) {
 
         $st = $context->connection->prepare($context->sql);
-        if($st->execute($context->params)){
+        if ($st->execute($context->params)) {
             $res = $st->fetchAll(\PDO::FETCH_ASSOC);
-            if ($dictAs){
-                $dict= [];
-                foreach ($res as $i){
-                    $dict[$i[$dictAs]]=$i;
+            if ($dictAs) {
+                $dict = [];
+                foreach ($res as $i) {
+                    $dict[$i[$dictAs]] = $i;
                 }
                 return $context->handleResult($dict);
             }
             return $context->handleResult($res);
-        }else{
+        }else {
             return false;
         }
     }
@@ -505,22 +505,22 @@ 
      * @param Context $context
      * @return int|false
      */
-    static public function count($context){
+    static public function count($context) {
 
         $found = [];
-        if(!preg_match('/\bselect\b/i', $context->sql, $found, PREG_OFFSET_CAPTURE) ||
-            count($found)==0){
+        if (!preg_match('/\bselect\b/i', $context->sql, $found, PREG_OFFSET_CAPTURE) ||
+            count($found) == 0) {
             \PhpBoot\abort(new \PDOException("can not use count(*) without select"));
         }
         list($chars, $columnBegin) = $found[0];
-        $columnBegin = $columnBegin + strlen('select')+1;
+        $columnBegin = $columnBegin + strlen('select') + 1;
 
         $columnEnd = 0;
         $found = [];
-        if(!preg_match('/\bfrom\b/i', $context->sql, $found, PREG_OFFSET_CAPTURE) ||
-            count($found)==0){
+        if (!preg_match('/\bfrom\b/i', $context->sql, $found, PREG_OFFSET_CAPTURE) ||
+            count($found) == 0) {
             $columnEnd = strlen($context->sql);
-        }else{
+        }else {
             list($chars, $columnEnd) = $found[0];
         }
         $sql = substr($context->sql, 0, $columnBegin);
@@ -528,10 +528,10 @@ 
         $sql .= substr($context->sql, $columnEnd);
 
         $st = $context->connection->prepare($sql);
-        if($st->execute($context->params)){
+        if ($st->execute($context->params)) {
             $res = $st->fetchAll(\PDO::FETCH_ASSOC);
             return intval($res[0]['count']);
-        }else{
+        }else {
             return false;
         }
 
@@ -539,47 +539,47 @@ 
 }
 class OnDuplicateKeyUpdateImpl
 {
-    public function set($context, $column, $value){
-        if(is_string($column)){
+    public function set($context, $column, $value) {
+        if (is_string($column)) {
             $this->setExpr($context, $column, $value);
-        }else{
+        }else {
             $this->setArgs($context, $column);
         }
     }
 
-    public function setExpr($context, $expr, $args){
+    public function setExpr($context, $expr, $args) {
         $prefix = '';
-        if($this->first){
+        if ($this->first) {
             $this->first = false;
             $prefix = 'ON DUPLICATE KEY UPDATE ';
-        }else{
+        }else {
             $prefix = ',';
         }
 
-        $context->appendSql("$prefix$expr",$prefix == 'ON DUPLICATE KEY UPDATE ');
+        $context->appendSql("$prefix$expr", $prefix == 'ON DUPLICATE KEY UPDATE ');
         $context->appendParams($args);
 
     }
-    public function setArgs($context, $values){
+    public function setArgs($context, $values) {
         $set = [];
         $params = [];
-        foreach ($values as $k=>$v){
+        foreach ($values as $k=>$v) {
             $k = DB::wrap($k);
-            if(is_a($v, Raw::class)){//直接拼接sql，不需要转义
-                $set[]= "$k=".$v->get();
-            }else{
-                $set[]= "$k=?";
-                $params[]=$v;
+            if (is_a($v, Raw::class)) {//直接拼接sql，不需要转义
+                $set[] = "$k=".$v->get();
+            }else {
+                $set[] = "$k=?";
+                $params[] = $v;
             }
         }
-        if($this->first){
+        if ($this->first) {
             $this->first = false;
             $context->appendSql('ON DUPLICATE KEY UPDATE '.implode(',', $set));
             $context->appendParams($params);
-        }else{
-            $context->appendSql(','.implode(',', $set),false);
+        }else {
+            $context->appendSql(','.implode(',', $set), false);
             $context->appendParams($params);
         }
     }
-    private $first=true;
+    private $first = true;
 }