edgardmessias / yii2-ibm-db2

src/QueryBuilder.php

Spacing +31 added lines, -31 removed lines

@@ -58,14 +58,14 @@ 
     {
         $table = $this->db->getTableSchema($tableName);
 
-        if ($table !== null && isset($table->columns[$table->sequenceName])) {
+        if ($table !== null && isset($table->columns[ $table->sequenceName ])) {
             if ($value === null) {
-                $sql = 'SELECT MAX("'. $table->sequenceName .'") FROM "'. $tableName . '"';
+                $sql = 'SELECT MAX("' . $table->sequenceName . '") FROM "' . $tableName . '"';
                 $value = $this->db->createCommand($sql)->queryScalar() + 1;
             } else {
                 $value = (int) $value;
             }
-            return 'ALTER TABLE "' . $tableName . '" ALTER COLUMN "'.$table->sequenceName.'" RESTART WITH ' . $value;
+            return 'ALTER TABLE "' . $tableName . '" ALTER COLUMN "' . $table->sequenceName . '" RESTART WITH ' . $value;
         } elseif ($table === null) {
             throw new InvalidParamException("Table not found: $tableName");
         } else {
@@ -85,7 +85,7 @@ 
     public function checkIntegrity($check = true, $schema = '', $table = '')
     {
         if ($table) {
-            $tableNames = [$table];
+            $tableNames = [ $table ];
         } else {
             if (!$schema) {
                 $schema = $this->db->defaultSchema;
@@ -118,13 +118,13 @@ 
             return '';
         }
 
-        $quotedTableNames = [];
+        $quotedTableNames = [ ];
         foreach ($tableNames as $tableName) {
-            $quotedTableNames[] = $this->db->quoteTableName($tableName) . ($check? '' : ' ALL');
+            $quotedTableNames[ ] = $this->db->quoteTableName($tableName) . ($check ? '' : ' ALL');
         }
 
         $enable = $check ? 'CHECKED' : 'UNCHECKED';
-        return 'SET INTEGRITY FOR ' . implode(', ', $quotedTableNames) . ' IMMEDIATE ' . $enable. ';';
+        return 'SET INTEGRITY FOR ' . implode(', ', $quotedTableNames) . ' IMMEDIATE ' . $enable . ';';
     }
 
     /**
@@ -137,22 +137,22 @@ 
             $sql = str_replace(':query', $sql, $limitOffsetStatment);
 
             //convert "item"."id" to "id" to use in OVER()
-            $newOrderBy = [];
+            $newOrderBy = [ ];
 
-            if(!empty($orderBy)){
+            if (!empty($orderBy)) {
                 foreach ($orderBy as $name => $direction) {
-                    if(is_string($name)){
+                    if (is_string($name)) {
                         $e = explode('.', $name);
                         $name = array_pop($e);
                     }
-                    $newOrderBy[$name] = $direction;
+                    $newOrderBy[ $name ] = $direction;
                 }
             }
 
             $orderByStatment = $this->buildOrderBy($newOrderBy);
 
-            $sql = str_replace(':order', $orderByStatment,$sql);
-        }else{
+            $sql = str_replace(':order', $orderByStatment, $sql);
+        } else {
             $orderByStatment = $this->buildOrderBy($orderBy);
             if ($orderByStatment !== '') {
                 $sql .= $this->separator . $orderByStatment;
@@ -196,24 +196,24 @@ 
      */
     protected function buildCompositeInCondition($operator, $columns, $values, &$params)
     {
-        $vss = [];
+        $vss = [ ];
         foreach ($values as $value) {
-            $vs = [];
+            $vs = [ ];
             foreach ($columns as $column) {
-                if (isset($value[$column])) {
+                if (isset($value[ $column ])) {
                     $phName = self::PARAM_PREFIX . count($params);
-                    $params[$phName] = $value[$column];
-                    $vs[] = $phName;
+                    $params[ $phName ] = $value[ $column ];
+                    $vs[ ] = $phName;
                 } else {
-                    $vs[] = 'NULL';
+                    $vs[ ] = 'NULL';
                 }
             }
-            $vss[] = 'select ' . implode(', ', $vs) . ' from SYSIBM.SYSDUMMY1';
+            $vss[ ] = 'select ' . implode(', ', $vs) . ' from SYSIBM.SYSDUMMY1';
         }
 
-        $sqlColumns = [];
+        $sqlColumns = [ ];
         foreach ($columns as $i => $column) {
-            $sqlColumns[] = strpos($column, '(') === false ? $this->db->quoteColumnName($column) : $column;
+            $sqlColumns[ ] = strpos($column, '(') === false ? $this->db->quoteColumnName($column) : $column;
         }
 
         return '(' . implode(', ', $sqlColumns) . ") $operator (" . implode(' UNION ', $vss) . ')';
@@ -228,21 +228,21 @@ 
         if (($tableSchema = $schema->getTableSchema($table)) !== null) {
             $columnSchemas = $tableSchema->columns;
         } else {
-            $columnSchemas = [];
+            $columnSchemas = [ ];
         }
-        $names = [];
-        $placeholders = [];
+        $names = [ ];
+        $placeholders = [ ];
         foreach ($columns as $name => $value) {
-            $names[] = $schema->quoteColumnName($name);
+            $names[ ] = $schema->quoteColumnName($name);
             if ($value instanceof Expression) {
-                $placeholders[] = $value->expression;
+                $placeholders[ ] = $value->expression;
                 foreach ($value->params as $n => $v) {
-                    $params[$n] = $v;
+                    $params[ $n ] = $v;
                 }
             } else {
                 $phName = self::PARAM_PREFIX . count($params);
-                $placeholders[] = $phName;
-                $params[$phName] = !is_array($value) && isset($columnSchemas[$name]) ? $columnSchemas[$name]->dbTypecast($value) : $value;
+                $placeholders[ ] = $phName;
+                $params[ $phName ] = !is_array($value) && isset($columnSchemas[ $name ]) ? $columnSchemas[ $name ]->dbTypecast($value) : $value;
             }
         }
 
@@ -264,7 +264,7 @@ 
      */
     public function selectExists($rawSql)
     {
-        return 'SELECT CASE WHEN COUNT(*)>0 THEN 1 ELSE 0 END FROM (' . $rawSql . ') CHECKEXISTS';;
+        return 'SELECT CASE WHEN COUNT(*)>0 THEN 1 ELSE 0 END FROM (' . $rawSql . ') CHECKEXISTS'; ;
     }
 
     /**