HexMakina / Crudites

Table/Row.php

Spacing +2 added lines, -2 removed lines

@@ -28,9 +28,9 @@
 
     public function __toString()
     {
-        return PHP_EOL . 'load: '
+        return PHP_EOL.'load: '
         . json_encode($this->load)
-        . PHP_EOL . 'alterations: '
+        . PHP_EOL.'alterations: '
         . json_encode(array_keys($this->alterations));
     }
 

Queries/ClauseJoin.php

Spacing +7 added lines, -7 removed lines

@@ -43,12 +43,12 @@ 
                     continue; // dont load the log information
                 } else {
                     $m = [];
-                    if (preg_match('/(.+)_(' . $fk_column->foreignColumnName() . ')$/', $fk_column->name(), $m)) {
+                    if (preg_match('/(.+)_('.$fk_column->foreignColumnName().')$/', $fk_column->name(), $m)) {
                         $foreign_table_alias = $m[1];
                     } else {
                         $foreign_table_alias = $foreign_table_name;
                     }
-                    $foreign_table_alias = $single_fk === true ? $foreign_table_alias : $foreign_table_alias . '_' . $fk_column->name();
+                    $foreign_table_alias = $single_fk === true ? $foreign_table_alias : $foreign_table_alias.'_'.$fk_column->name();
 
                     // auto select non nullable columns
                 }
@@ -69,7 +69,7 @@ 
 
     public function join($table_names, $joins, $join_type = '')
     {
-        list($join_table_name,$join_table_alias) = self::processParamTableNames($table_names);
+        list($join_table_name, $join_table_alias) = self::processParamTableNames($table_names);
 
         if (preg_match('/^(INNER|LEFT|RIGHT|FULL)(\sOUTER)?/i', $join_type) !== 1) {
             $join_type = '';
@@ -159,7 +159,7 @@ 
                     if (is_null($other_table->column("$select_field"))) {
                         $computed_selection = "$select_field"; // table column does not exist, no nood to prefix
                     } else {
-                        $computed_selection = "$other_table_alias.$select_field as " . $other_table_alias . "_$select_field";
+                        $computed_selection = "$other_table_alias.$select_field as ".$other_table_alias."_$select_field";
                     }
 
                     // vd($computed_selection);
@@ -179,13 +179,13 @@ 
         foreach ($join_fields as $join_cond) {
             if (isset($join_cond[3])) { // 4 joins param -> t.f = t.f
                 list($table, $field, $join_table, $join_table_field) = $join_cond;
-                $join_parts [] = $this->backTick($field, $table) . ' = ' . $this->backTick($join_table_field, $join_table);
+                $join_parts [] = $this->backTick($field, $table).' = '.$this->backTick($join_table_field, $join_table);
             } elseif (isset($join_cond[2])) { // 3 joins param -> t.f = v
                 list($table, $field, $value) = $join_cond;
-                $bind_label = ':loj_' . $join_table_alias . '_' . $table . '_' . $field;
+                $bind_label = ':loj_'.$join_table_alias.'_'.$table.'_'.$field;
                 $this->addBinding($field, $value, null, $bind_label);
 
-                $join_parts [] = $this->backTick($field, $table) . ' = ' . $bind_label;
+                $join_parts [] = $this->backTick($field, $table).' = '.$bind_label;
             }
         }
         return sprintf('%s JOIN `%s` %s ON %s', $join_type, $join_table_name, $join_table_alias, implode(' AND ', $join_parts));

Queries/Update.php

Spacing +1 added lines, -1 removed lines

@@ -44,7 +44,7 @@
                 $value = 0;
             }
             $binding_names[$field_name] = $this->addBinding($field_name, $value);
-            $this->alterations [] = $this->backTick($field_name) . ' = ' . $binding_names[$field_name];
+            $this->alterations [] = $this->backTick($field_name).' = '.$binding_names[$field_name];
         }
         return $binding_names;
     }

Queries/BaseQuery.php

Spacing +2 added lines, -3 removed lines

@@ -138,7 +138,7 @@ 
 
     public function bindLabel($field, $table_name = null): string
     {
-        return ':' . $this->tableLabel($table_name) . '_' . $field;
+        return ':'.$this->tableLabel($table_name).'_'.$field;
     }
 
     //------------------------------------------------------------  Run
@@ -157,8 +157,7 @@ 
             }
 
             if ($this->prepared_statement->execute($this->getBindings()) !== false) {
-                // execute returns TRUE on success or FALSE on failure.
-                ++self::$executions;
+                // execute returns TRUE on success or FALSE on failure.++self::$executions;
 
                 $this->isExecuted(true);
 

Queries/Insert.php

Spacing +1 added lines, -1 removed lines

@@ -47,7 +47,7 @@
             throw new CruditesException('INSERT_FIELDS_BINDINGS_MISMATCH');
         }
 
-        $fields = '`' . implode('`, `', $this->query_fields) . '`';
+        $fields = '`'.implode('`, `', $this->query_fields).'`';
         $values = implode(', ', array_keys($this->bindings));
 
         return sprintf('INSERT INTO `%s` (%s) VALUES (%s)', $this->table, $fields, $values);

Queries/ClauseWhere.php

Indentation +5 added lines, -5 removed lines

@@ -49,22 +49,22 @@ 
 
     public function whereEQ($field, $value, $table_name = null, $bindname = null)
     {
-               return $this->whereBindField($table_name, $field, self::$OP_EQ, $value, $bindname);
+                return $this->whereBindField($table_name, $field, self::$OP_EQ, $value, $bindname);
     }
 
     public function whereGT($field, $value, $table_name = null, $bindname = null)
     {
-               return $this->whereBindField($table_name, $field, self::$OP_GT, $value, $bindname);
+                return $this->whereBindField($table_name, $field, self::$OP_GT, $value, $bindname);
     }
 
     public function whereLT($field, $value, $table_name = null, $bindname = null)
     {
-               return $this->whereBindField($table_name, $field, self::$OP_LT, $value, $bindname);
+                return $this->whereBindField($table_name, $field, self::$OP_LT, $value, $bindname);
     }
 
     public function whereGTE($field, $value, $table_name = null, $bindname = null)
     {
-               return $this->whereBindField($table_name, $field, self::$OP_GTE, $value, $bindname);
+                return $this->whereBindField($table_name, $field, self::$OP_GTE, $value, $bindname);
     }
 
     public function whereLTE($field, $value, $table_name = null, $bindname = null)
@@ -171,7 +171,7 @@ 
      * @param $filters_operator Object, inclusive or exclusive search
      */
 
-     // sub array filters[$content]
+      // sub array filters[$content]
     public function whereFilterContent($filters_content, $search_table = null, $filters_operator = null)
     {
         if (!isset($filters_content['term']) || !isset($filters_content['fields'])) {

Spacing +2 added lines, -2 removed lines

@@ -132,7 +132,7 @@ 
             $in = '';
             foreach ($values as $i => $v) {
                 // TODO dirty patching. mathematical certainty needed
-                $placeholder_name = ':' . $table_name . '_' . $field . '_awS_in_' . $count_values . '_' . $i;
+                $placeholder_name = ':'.$table_name.'_'.$field.'_awS_in_'.$count_values.'_'.$i;
                 $this->addBinding($field, $v, null, $placeholder_name);
                 $in .= "$placeholder_name,";
             }
@@ -231,7 +231,7 @@ 
     protected function generateWhere()
     {
         if (!empty($this->where)) {
-            return PHP_EOL . ' WHERE ' . implode(PHP_EOL . ' AND ', $this->where);
+            return PHP_EOL.' WHERE '.implode(PHP_EOL.' AND ', $this->where);
         }
     }
 }

Queries/Select.php

Spacing +5 added lines, -5 removed lines

@@ -142,25 +142,25 @@
 
         $query_fields = empty($this->selection) ? ['*'] : $this->selection;
 
-        $ret = PHP_EOL . 'SELECT ' . implode(', ' . PHP_EOL, $query_fields);
-        $ret .= PHP_EOL . sprintf(' FROM `%s` %s ', $this->tableName(), $this->table_alias);
+        $ret = PHP_EOL.'SELECT '.implode(', '.PHP_EOL, $query_fields);
+        $ret .= PHP_EOL.sprintf(' FROM `%s` %s ', $this->tableName(), $this->table_alias);
 
         if (!empty($this->join)) {
-            $ret .= PHP_EOL . ' ' . implode(PHP_EOL . ' ', $this->join);
+            $ret .= PHP_EOL.' '.implode(PHP_EOL.' ', $this->join);
         }
 
         $ret .= $this->generateWhere();
 
         foreach (['group' => 'GROUP BY', 'having' => 'HAVING', 'order' => 'ORDER BY'] as $part => $prefix) {
             if (!empty($this->$part)) {
-                $ret .= PHP_EOL . " $prefix " . implode(', ', $this->$part);
+                $ret .= PHP_EOL." $prefix ".implode(', ', $this->$part);
             }
         }
 
         if (!empty($this->limit_number)) {
             $offset = $this->limit_offset ?? 0;
             $number = $this->limit_number;
-            $ret .= PHP_EOL . " LIMIT $offset, $number";
+            $ret .= PHP_EOL." LIMIT $offset, $number";
         }
 
         return $ret;

Crudites.php

Spacing +1 added lines, -1 removed lines

@@ -32,7 +32,7 @@
         try {
             return self::$database->inspect($table_name);
         } catch (\Exception $e) {
-            throw new CruditesException('TABLE_INTROSPECTION::' . $table_name);
+            throw new CruditesException('TABLE_INTROSPECTION::'.$table_name);
         }
     }
 

Database.php

Spacing +2 added lines, -2 removed lines

@@ -45,7 +45,7 @@ 
           'REFERENCED_COLUMN_NAME'
         ];
 
-        $statement = 'SELECT ' . implode(', ', $fields)
+        $statement = 'SELECT '.implode(', ', $fields)
         . ' FROM KEY_COLUMN_USAGE'
         . ' WHERE TABLE_SCHEMA = "%s"'
         . ' ORDER BY TABLE_NAME, CONSTRAINT_NAME, ORDINAL_POSITION';
@@ -84,7 +84,7 @@ 
         foreach ($this->unique_by_table as $table_name => $uniques) {
             foreach ($uniques as $constraint_name => $columns) {
                 foreach ($columns as $column_name) {
-                    $this->unique_by_table[$table_name][$column_name] = [0 => $constraint_name] + $columns;
+                    $this->unique_by_table[$table_name][$column_name] = [0 => $constraint_name]+$columns;
                 }
                 unset($this->unique_by_table[$table_name][$constraint_name]);
             }