dvdoug / DB

MySQLColumnMeta.php

Indentation +9 added lines, -9 removed lines

@@ -137,18 +137,18 @@
        * Metadata from the data stored
        */
       $query = sprintf("SELECT COUNT(*) AS COUNT FROM (SELECT %s FROM %s.%s GROUP BY %s) distinctvalues",
-                       $this->connection->quoteIdentifier($this->name),
-                       $this->connection->quoteIdentifier($this->database),
-                       $this->connection->quoteIdentifier($this->table),
-                       $this->connection->quoteIdentifier($this->name));
+                        $this->connection->quoteIdentifier($this->name),
+                        $this->connection->quoteIdentifier($this->database),
+                        $this->connection->quoteIdentifier($this->table),
+                        $this->connection->quoteIdentifier($this->name));
       $this->distinctValues = $this->connection->query($query)->fetchAssoc(false)['COUNT'];
 
       $query = sprintf("SELECT MIN(%s) AS ROWMIN, MAX(%s) AS ROWMAX FROM %s.%s WHERE %s IS NOT NULL",
-                       $this->connection->quoteIdentifier($this->name),
-                       $this->connection->quoteIdentifier($this->name),
-                       $this->connection->quoteIdentifier($this->database),
-                       $this->connection->quoteIdentifier($this->table),
-                       $this->connection->quoteIdentifier($this->name));
+                        $this->connection->quoteIdentifier($this->name),
+                        $this->connection->quoteIdentifier($this->name),
+                        $this->connection->quoteIdentifier($this->database),
+                        $this->connection->quoteIdentifier($this->table),
+                        $this->connection->quoteIdentifier($this->name));
       $data = $this->connection->query($query)->fetchAssoc(false);
       $this->maxValue = $data['ROWMAX'];
       $this->minValue = $data['ROWMIN'];

Spacing +1 added lines, -1 removed lines

@@ -259,7 +259,7 @@
      * @return int
      */
     public function getLength() {
-      switch($this->getOriginalType()) {
+      switch ($this->getOriginalType()) {
         case 'BIT':
         case 'TINYINT':
         case 'TINYINT UNSIGNED':

Braces +1 added lines, -2 removed lines

@@ -213,8 +213,7 @@
         case 'DATETIME':
           if ($this->precision) {
             return 'TIMESTAMP';
-          }
-          else {
+          } else {
             return 'DATE';
           }
 

MSSQLPDODatabase.php

Indentation +6 added lines, -6 removed lines

@@ -97,11 +97,11 @@ 
     }
 
       /**
-     * Primary key column(s)
-     * @param string $aDatabase database/schema name
-     * @param string $aTable table name
-     * @return array
-     */
+       * Primary key column(s)
+       * @param string $aDatabase database/schema name
+       * @param string $aTable table name
+       * @return array
+       */
     public function getPrimaryKey($aDatabase, $aTable) {
       $columns = array();
       $SQL = "SELECT ind.name AS INDEX_NAME,
@@ -150,7 +150,7 @@ 
      * @param string $aDatabase database/schema name
      * @param string $aTable table name
      * @return array
-    */
+     */
     public function getIndexes($aDatabase, $aTable) {
 
       $indexes = array();

Braces +1 added lines, -2 removed lines

@@ -59,8 +59,7 @@
         $statement = $this->prepare("SELECT TABLE_SCHEMA, TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = :database ORDER BY TABLE_NAME ASC");
         $statement->bindParamToValue(':database', $aDatabase);
         $statement->execute();
-      }
-      else {
+      } else {
         $statement = $this->query("SELECT TABLE_SCHEMA, TABLE_NAME FROM INFORMATION_SCHEMA.TABLES");
       }
 

MSSQLColumnMeta.php

Indentation +14 added lines, -14 removed lines

@@ -133,20 +133,20 @@ 
        */
       if (!in_array($this->type, array('TEXT', 'NTEXT', 'IMAGE'))) {
         $query = sprintf("SELECT COUNT(*) AS COUNT FROM (SELECT %s FROM %s.%s GROUP BY %s) distinctvalues",
-                         $this->connection->quoteIdentifier($this->name),
-                         $this->connection->quoteIdentifier($this->database),
-                         $this->connection->quoteIdentifier($this->table),
-                         $this->connection->quoteIdentifier($this->name));
+                          $this->connection->quoteIdentifier($this->name),
+                          $this->connection->quoteIdentifier($this->database),
+                          $this->connection->quoteIdentifier($this->table),
+                          $this->connection->quoteIdentifier($this->name));
         $this->distinctValues = $this->connection->query($query)->fetchAssoc(false)['COUNT'];
       }
 
       if (!in_array($this->type, array('BIT', 'TEXT', 'NTEXT', 'IMAGE', 'UNIQUEIDENTIFIER'))) {
         $query = sprintf("SELECT MIN(%s) AS ROWMIN, MAX(%s) AS ROWMAX FROM %s.%s WHERE %s IS NOT NULL",
-                         $this->connection->quoteIdentifier($this->name),
-                         $this->connection->quoteIdentifier($this->name),
-                         $this->connection->quoteIdentifier($this->database),
-                         $this->connection->quoteIdentifier($this->table),
-                         $this->connection->quoteIdentifier($this->name));
+                          $this->connection->quoteIdentifier($this->name),
+                          $this->connection->quoteIdentifier($this->name),
+                          $this->connection->quoteIdentifier($this->database),
+                          $this->connection->quoteIdentifier($this->table),
+                          $this->connection->quoteIdentifier($this->name));
         $data = $this->connection->query($query)->fetchAssoc(false);
         $this->maxValue = $data['ROWMAX'];
         $this->minValue = $data['ROWMIN'];
@@ -221,10 +221,10 @@ 
          * Work out whether date or datetime
         */
         $query = sprintf("SELECT COUNT(*) AS COUNT FROM %s.%s WHERE %s IS NOT NULL AND CONVERT(VARCHAR(8), %s, 108) != '00:00:00'",
-                         $this->connection->quoteIdentifier($this->database),
-                         $this->connection->quoteIdentifier($this->table),
-                         $this->connection->quoteIdentifier($this->name),
-                         $this->connection->quoteIdentifier($this->name));
+                          $this->connection->quoteIdentifier($this->database),
+                          $this->connection->quoteIdentifier($this->table),
+                          $this->connection->quoteIdentifier($this->name),
+                          $this->connection->quoteIdentifier($this->name));
         $rows = $this->connection->query($query)->fetchAssoc(false);
 
         if ($rows['COUNT'] > 0) {
@@ -340,7 +340,7 @@ 
       case 'SMALLDATETIME':
       case 'DATETIMEOFFSET':
         if ($this->precision) {
-           return 'TIMESTAMP';
+            return 'TIMESTAMP';
         }
         else {
           return 'DATE';

Switch Indentation +60 added lines, -60 removed lines

@@ -311,74 +311,74 @@ 
     public function getOracleType() {
       switch ($this->type) {
 
-      case 'BIT':
-      case 'TINYINT':
-      case 'SMALLINT':
-      case 'INT':
-      case 'BIGINT':
-      case 'DECIMAL':
-      case 'NUMERIC':
-      case 'MONEY':
-      case 'SMALLMONEY':
-        return 'NUMBER';
-        break;
-
-      case 'FLOAT':
-        return 'BINARY_FLOAT';
-        break;
+        case 'BIT':
+        case 'TINYINT':
+        case 'SMALLINT':
+        case 'INT':
+        case 'BIGINT':
+        case 'DECIMAL':
+        case 'NUMERIC':
+        case 'MONEY':
+        case 'SMALLMONEY':
+          return 'NUMBER';
+          break;
 
-      case 'REAL':
-        return 'BINARY_DOUBLE';
-        break;
+        case 'FLOAT':
+          return 'BINARY_FLOAT';
+          break;
 
-      case 'DATE':
-        return 'DATE';
-        break;
+        case 'REAL':
+          return 'BINARY_DOUBLE';
+          break;
 
-      case 'DATETIME':
-      case 'DATETIME2':
-      case 'SMALLDATETIME':
-      case 'DATETIMEOFFSET':
-        if ($this->precision) {
-           return 'TIMESTAMP';
-        }
-        else {
+        case 'DATE':
           return 'DATE';
-        }
-        break;
+          break;
 
-      case 'TIME':
-        return 'TIME';
-        break;
+        case 'DATETIME':
+        case 'DATETIME2':
+        case 'SMALLDATETIME':
+        case 'DATETIMEOFFSET':
+          if ($this->precision) {
+             return 'TIMESTAMP';
+          }
+          else {
+            return 'DATE';
+          }
+          break;
 
-      case 'CHAR':
-      case 'NCHAR':
-        return 'NCHAR';
-        break;
+        case 'TIME':
+          return 'TIME';
+          break;
 
-      case 'VARCHAR':
-      case 'NVARCHAR':
-      case 'TEXT':
-      case 'NTEXT':
-        return 'NVARCHAR';
-        break;
+        case 'CHAR':
+        case 'NCHAR':
+          return 'NCHAR';
+          break;
 
-      case 'BINARY':
-      case 'VARBINARY':
-      case 'IMAGE':
-        return 'BLOB';
-        break;
+        case 'VARCHAR':
+        case 'NVARCHAR':
+        case 'TEXT':
+        case 'NTEXT':
+          return 'NVARCHAR';
+          break;
 
-      case 'ROWVERSION':
-      case 'TIMESTAMP': //XXX rowversion, not a time
-      case 'HIERARCHYID':
-      case 'XML':
-        return 'NVARCHAR';
-        break;
+        case 'BINARY':
+        case 'VARBINARY':
+        case 'IMAGE':
+          return 'BLOB';
+          break;
 
-      case 'UNIQUEIDENTIFIER':
-        return 'CHAR';
-        break;
+        case 'ROWVERSION':
+        case 'TIMESTAMP': //XXX rowversion, not a time
+        case 'HIERARCHYID':
+        case 'XML':
+          return 'NVARCHAR';
+          break;
+
+        case 'UNIQUEIDENTIFIER':
+          return 'CHAR';
+          break;
 
         default:
           throw new \Exception("Unknown conversion for column type {$this->type}");
@@ -418,8 +418,8 @@ 
           return 36;
           break;
 
-      default:
-          return 0;
+        default:
+            return 0;
       }
     }
 

Spacing +1 added lines, -1 removed lines

@@ -391,7 +391,7 @@
      * @return int
      */
     public function getLength() {
-      switch($this->getOriginalType()) {
+      switch ($this->getOriginalType()) {
         case 'TINYINT':
         case 'SMALLINT':
         case 'INT':

Braces +5 added lines, -10 removed lines

@@ -229,8 +229,7 @@ 
 
         if ($rows['COUNT'] > 0) {
           return 'DATETIME';
-        }
-        else {
+        } else {
           return 'DATE';
         }
         break;
@@ -238,8 +237,7 @@ 
       case 'DATETIMEOFFSET':
         if ($this->minValue >= '1970-01-01 00:00:01' && $this->maxValue <= '2038-01-19 03:14:07') {
           return 'TIMESTAMP';
-        }
-        else {
+        } else {
           return 'DATETIME';
         }
         break;
@@ -257,8 +255,7 @@ 
       case 'NVARCHAR':
         if ($this->getLength() == -1) {
           return 'LONGTEXT';
-        }
-        else {
+        } else {
           return 'VARCHAR';
         }
         break;
@@ -275,8 +272,7 @@ 
       case 'VARBINARY':
         if ($this->getLength() == -1) {
           return 'LONGBLOB';
-        }
-        else {
+        } else {
           return 'VARBINARY';
         }
         break;
@@ -341,8 +337,7 @@ 
       case 'DATETIMEOFFSET':
         if ($this->precision) {
            return 'TIMESTAMP';
-        }
-        else {
+        } else {
           return 'DATE';
         }
         break;

DDLGeneration.php

Indentation +8 added lines, -8 removed lines

@@ -29,9 +29,9 @@ 
 
       if (in_array($MySQLType, array('ENUM', 'SET'))) {
         $query = sprintf("SHOW COLUMNS FROM %s.%s LIKE %s",
-                         $this->connection->quoteIdentifier($this->database),
-                         $this->connection->quoteIdentifier($this->table),
-                         $this->connection->escape($this->name));
+                          $this->connection->quoteIdentifier($this->database),
+                          $this->connection->quoteIdentifier($this->table),
+                          $this->connection->escape($this->name));
 
         $statement = $this->connection->query($query);
         $values = $statement->fetchAssoc(false)['Type'];
@@ -44,11 +44,11 @@ 
       }
       else if (in_array($MySQLType, array('CHAR', 'VARCHAR')) && $this->getLength() < 64 && $this->getDistinctValueCount() <= 16) {
         $query = sprintf("SELECT DISTINCT %s FROM %s.%s WHERE %s IS NOT NULL ORDER BY %s ASC",
-                         $this->connection->quoteIdentifier($this->name),
-                         $this->connection->quoteIdentifier($this->database),
-                         $this->connection->quoteIdentifier($this->table),
-                         $this->connection->quoteIdentifier($this->name),
-                         $this->connection->quoteIdentifier($this->name));
+                          $this->connection->quoteIdentifier($this->name),
+                          $this->connection->quoteIdentifier($this->database),
+                          $this->connection->quoteIdentifier($this->table),
+                          $this->connection->quoteIdentifier($this->name),
+                          $this->connection->quoteIdentifier($this->name));
         $values = array();
         foreach ($this->connection->query($query) as $value) {
           $values[] = trim($value[$this->name]);

Spacing +4 added lines, -4 removed lines

@@ -36,11 +36,11 @@ 
         $statement = $this->connection->query($query);
         $values = $statement->fetchAssoc(false)['Type'];
         $values = explode("','", substr($values, strpos($values, '(') + 2, -2));
-        $values = array_intersect_key($values,array_unique(array_map("strtolower",$values)));
+        $values = array_intersect_key($values, array_unique(array_map("strtolower", $values)));
         asort($values);
 
         $def .= $MySQLType;
-        $def .= '(' . join(', ', array_map(function($c) {return "'".addslashes($c)."'";}, $values)) . ')';
+        $def .= '(' . join(', ', array_map(function($c) {return "'" . addslashes($c) . "'"; }, $values)) . ')';
       }
       else if (in_array($MySQLType, array('CHAR', 'VARCHAR')) && $this->getLength() < 64 && $this->getDistinctValueCount() <= 16) {
         $query = sprintf("SELECT DISTINCT %s FROM %s.%s WHERE %s IS NOT NULL ORDER BY %s ASC",
@@ -53,12 +53,12 @@ 
         foreach ($this->connection->query($query) as $value) {
           $values[] = trim($value[$this->name]);
         }
-        $values = array_intersect_key($values,array_unique(array_map("strtolower",$values)));
+        $values = array_intersect_key($values, array_unique(array_map("strtolower", $values)));
         asort($values);
 
         if ($values) {
           $def .= 'ENUM';
-          $def .= '(' . join(', ', array_map(function($c) {return "'".addslashes($c)."'";}, $values)) . ')';
+          $def .= '(' . join(', ', array_map(function($c) {return "'" . addslashes($c) . "'"; }, $values)) . ')';
         }
         else {
           $def .= $MySQLType;

Braces +11 added lines, -22 removed lines

@@ -22,8 +22,7 @@ 
       if (strpos($MySQLType, 'UNSIGNED') !== false) {
         $unsigned = true;
         $MySQLType = substr($MySQLType, 0, -9);
-      }
-      else {
+      } else {
         $unsigned = false;
       }
 
@@ -41,8 +40,7 @@ 
 
         $def .= $MySQLType;
         $def .= '(' . join(', ', array_map(function($c) {return "'".addslashes($c)."'";}, $values)) . ')';
-      }
-      else if (in_array($MySQLType, array('CHAR', 'VARCHAR')) && $this->getLength() < 64 && $this->getDistinctValueCount() <= 16) {
+      } else if (in_array($MySQLType, array('CHAR', 'VARCHAR')) && $this->getLength() < 64 && $this->getDistinctValueCount() <= 16) {
         $query = sprintf("SELECT DISTINCT %s FROM %s.%s WHERE %s IS NOT NULL ORDER BY %s ASC",
                          $this->connection->quoteIdentifier($this->name),
                          $this->connection->quoteIdentifier($this->database),
@@ -59,28 +57,23 @@ 
         if ($values) {
           $def .= 'ENUM';
           $def .= '(' . join(', ', array_map(function($c) {return "'".addslashes($c)."'";}, $values)) . ')';
-        }
-        else {
+        } else {
           $def .= $MySQLType;
           if ($this->getLength() > 0) {
             $def .= '(' . $this->getLength() . ')';
           }
         }
-      }
-      else if (in_array($MySQLType, array('DATETIME', 'TIMESTAMP', 'TIME'))) {
+      } else if (in_array($MySQLType, array('DATETIME', 'TIMESTAMP', 'TIME'))) {
         $def .= $MySQLType;
         $def .= '(' . (int)$this->getScale() . ')';
-      }
-      else {
+      } else {
         $def .= $MySQLType;
 
         if ($this->getScale() && !in_array($MySQLType, array('DATE'))) {
           $def .= '(' . $this->getPrecision() . ',' . $this->getScale() . ')';
-        }
-        else if ($this->getPrecision() && !in_array($MySQLType, array('TINYINT', 'SMALLINT', 'MEDIUMINT', 'INT', 'BIGINT'))) {
+        } else if ($this->getPrecision() && !in_array($MySQLType, array('TINYINT', 'SMALLINT', 'MEDIUMINT', 'INT', 'BIGINT'))) {
           $def .= '(' . $this->getPrecision() . ')';
-        }
-        else if ($this->getLength() > 0 && !in_array($MySQLType, array('TINYINT', 'SMALLINT', 'MEDIUMINT', 'INT', 'BIGINT'))) {
+        } else if ($this->getLength() > 0 && !in_array($MySQLType, array('TINYINT', 'SMALLINT', 'MEDIUMINT', 'INT', 'BIGINT'))) {
           $def .= '(' . $this->getLength() . ')';
         }
 
@@ -91,8 +84,7 @@ 
 
       if ($this->isNullable()) {
         $def .= ' NULL';
-      }
-      else {
+      } else {
         $def .= ' NOT NULL';
       }
 
@@ -109,18 +101,15 @@ 
 
       if ($this->getScale()) {
         $def .= '(' . $this->getPrecision() . ',' . $this->getScale() . ')';
-      }
-      else if ($this->getPrecision()) {
+      } else if ($this->getPrecision()) {
         $def .= '(' . $this->getPrecision() . ')';
-      }
-      else if ($this->getLength()) {
+      } else if ($this->getLength()) {
         $def .= '(' . $this->getLength() . ')';
       }
 
       if ($this->isNullable()) {
         $def .= ' NULL';
-      }
-      else {
+      } else {
         $def .= ' NOT NULL';
       }
 

OraclePDODatabase.php

Indentation +1 added lines, -1 removed lines

@@ -107,7 +107,7 @@
      * @param string $aDatabase database/schema name
      * @param string $aTable table name
      * @return array
-    */
+     */
     public function getIndexes($aDatabase, $aTable) {
 
       $indexes = array();

Braces +1 added lines, -2 removed lines

@@ -35,8 +35,7 @@
         $statement = $this->prepare("SELECT OWNER, TABLE_NAME FROM ALL_TABLES WHERE OWNER = :owner ORDER BY TABLE_NAME ASC");
         $statement->bindParamToValue(':owner', $aDatabase);
         $statement->execute();
-      }
-      else {
+      } else {
         $statement = $this->query("SELECT OWNER, TABLE_NAME FROM ALL_TABLES");
       }
 

OracleColumnMeta.php

Indentation +16 added lines, -16 removed lines

@@ -134,18 +134,18 @@ 
        */
       try {
         $query = sprintf("SELECT COUNT(*) AS COUNT FROM (SELECT %s FROM %s.%s GROUP BY %s) distinctvalues",
-                         $this->connection->quoteIdentifier($this->name),
-                         $this->connection->quoteIdentifier($this->database),
-                         $this->connection->quoteIdentifier($this->table),
-                         $this->connection->quoteIdentifier($this->name));
+                          $this->connection->quoteIdentifier($this->name),
+                          $this->connection->quoteIdentifier($this->database),
+                          $this->connection->quoteIdentifier($this->table),
+                          $this->connection->quoteIdentifier($this->name));
         $this->distinctValues = $this->connection->query($query)->fetchAssoc(false)['COUNT'];
 
         $query = sprintf("SELECT MIN(%s) AS ROWMIN, MAX(%s) AS ROWMAX FROM %s.%s WHERE %s IS NOT NULL",
-                         $this->connection->quoteIdentifier($this->name),
-                         $this->connection->quoteIdentifier($this->name),
-                         $this->connection->quoteIdentifier($this->database),
-                         $this->connection->quoteIdentifier($this->table),
-                         $this->connection->quoteIdentifier($this->name));
+                          $this->connection->quoteIdentifier($this->name),
+                          $this->connection->quoteIdentifier($this->name),
+                          $this->connection->quoteIdentifier($this->database),
+                          $this->connection->quoteIdentifier($this->table),
+                          $this->connection->quoteIdentifier($this->name));
         $data = $this->connection->query($query)->fetchAssoc(false);
         $this->maxValue = $data['ROWMAX'];
         $this->minValue = $data['ROWMIN'];
@@ -154,9 +154,9 @@ 
       catch (\Exception $e) { //LONG column has restrictions on querying, so just get total value count
         if (strpos($e->getMessage(), 'ORA-00997: illegal use of LONG datatype') !== false) {
           $query = sprintf("SELECT COUNT(*) AS COUNT FROM %s.%s WHERE %s IS NOT NULL",
-                           $this->connection->quoteIdentifier($this->database),
-                           $this->connection->quoteIdentifier($this->table),
-                           $this->connection->quoteIdentifier($this->name));
+                            $this->connection->quoteIdentifier($this->database),
+                            $this->connection->quoteIdentifier($this->table),
+                            $this->connection->quoteIdentifier($this->name));
           $this->distinctValues = $this->connection->query($query)->fetchAssoc(false)['COUNT'] ?: 1;
         }
       }
@@ -263,10 +263,10 @@ 
            * Work out whether date or datetime
            */
           $query = sprintf("SELECT COUNT(*) AS COUNT FROM %s.%s WHERE %s IS NOT NULL AND TO_CHAR(%s, 'SSSSS') > 0",
-                           $this->connection->quoteIdentifier($this->database),
-                           $this->connection->quoteIdentifier($this->table),
-                           $this->connection->quoteIdentifier($this->name),
-                           $this->connection->quoteIdentifier($this->name));
+                            $this->connection->quoteIdentifier($this->database),
+                            $this->connection->quoteIdentifier($this->table),
+                            $this->connection->quoteIdentifier($this->name),
+                            $this->connection->quoteIdentifier($this->name));
           $rows = $this->connection->query($query)->fetchAssoc(false);
 
           if ($rows['COUNT'] > 0) {

Spacing +1 added lines, -1 removed lines

@@ -317,7 +317,7 @@
      * @return int
      */
     public function getLength() {
-      switch($this->getOriginalType()) {
+      switch ($this->getOriginalType()) {
         case 'NUMBER':
         case 'CHAR':
         case 'NCHAR':

Braces +15 added lines, -30 removed lines

@@ -150,8 +150,7 @@ 
         $this->maxValue = $data['ROWMAX'];
         $this->minValue = $data['ROWMIN'];
 
-      }
-      catch (\Exception $e) { //LONG column has restrictions on querying, so just get total value count
+      } catch (\Exception $e) { //LONG column has restrictions on querying, so just get total value count
         if (strpos($e->getMessage(), 'ORA-00997: illegal use of LONG datatype') !== false) {
           $query = sprintf("SELECT COUNT(*) AS COUNT FROM %s.%s WHERE %s IS NOT NULL",
                            $this->connection->quoteIdentifier($this->database),
@@ -192,45 +191,33 @@ 
             if ($this->minValue >= 0) { //unsigned
               if (bccomp($this->maxValue, '256') === -1) {
                 return 'TINYINT UNSIGNED';
-              }
-              else if (bccomp($this->maxValue, '65536') === -1) {
+              } else if (bccomp($this->maxValue, '65536') === -1) {
                 return 'SMALLINT UNSIGNED';
-              }
-              else if (bccomp($this->maxValue, '16777216') === -1) {
+              } else if (bccomp($this->maxValue, '16777216') === -1) {
                 return 'MEDIUMINT UNSIGNED';
-              }
-              else if (bccomp($this->maxValue, '4294967296') === -1) {
+              } else if (bccomp($this->maxValue, '4294967296') === -1) {
                 return 'INT UNSIGNED';
-              }
-              else if (bccomp($this->maxValue, '18446744073709551616') === -1) {
+              } else if (bccomp($this->maxValue, '18446744073709551616') === -1) {
                 return 'BIGINT UNSIGNED';
-              }
-              else {
+              } else {
                 return 'NUMERIC';
               }
-            }
-            else { //signed
+            } else { //signed
               if (bccomp(max(abs($this->minValue), $this->maxValue), '128') === -1) {
                 return 'TINYINT';
-              }
-              else if (bccomp(max(abs($this->minValue), $this->maxValue), '32768') === -1) {
+              } else if (bccomp(max(abs($this->minValue), $this->maxValue), '32768') === -1) {
                 return 'SMALLINT';
-              }
-              else if (bccomp(max(abs($this->minValue), $this->maxValue), '8388608') === -1) {
+              } else if (bccomp(max(abs($this->minValue), $this->maxValue), '8388608') === -1) {
                 return 'MEDIUMINT';
-              }
-              else if (bccomp(max(abs($this->minValue), $this->maxValue), '2147483648') === -1) {
+              } else if (bccomp(max(abs($this->minValue), $this->maxValue), '2147483648') === -1) {
                 return 'INT';
-              }
-              else if (bccomp(max(abs($this->minValue), $this->maxValue), '9223372036854775808') === -1) {
+              } else if (bccomp(max(abs($this->minValue), $this->maxValue), '9223372036854775808') === -1) {
                 return 'BIGINT';
-              }
-              else {
+              } else {
                 return 'DECIMAL';
               }
             }
-          }
-          else {
+          } else {
             return 'DECIMAL';
           }
           break;
@@ -252,8 +239,7 @@ 
         case 'TIMESTAMP WITH LOCAL TIME ZONE':
           if ($this->minValue >= '1970-01-01 00:00:01' && $this->maxValue <= '2038-01-19 03:14:07') {
             return 'TIMESTAMP';
-          }
-          else {
+          } else {
             return 'DATETIME';
           }
 
@@ -271,8 +257,7 @@ 
 
           if ($rows['COUNT'] > 0) {
             return 'DATETIME';
-          }
-          else {
+          } else {
             return 'DATE';
           }
           break;

MySQLPDODatabase.php

Indentation +6 added lines, -6 removed lines

@@ -103,11 +103,11 @@ 
     }
 
       /**
-     * Primary key column(s)
-     * @param string $aDatabase database/schema name
-     * @param string $aTable table name
-     * @return array
-     */
+       * Primary key column(s)
+       * @param string $aDatabase database/schema name
+       * @param string $aTable table name
+       * @return array
+       */
     public function getPrimaryKey($aDatabase, $aTable) {
       $columns = array();
       $SQL = "SELECT ORDINAL_POSITION, COLUMN_NAME
@@ -133,7 +133,7 @@ 
      * @param string $aDatabase database/schema name
      * @param string $aTable table name
      * @return array
-    */
+     */
     public function getIndexes($aDatabase, $aTable) {
 
       $indexes = array();

Braces +1 added lines, -2 removed lines

@@ -65,8 +65,7 @@
         $statement = $this->prepare("SELECT TABLE_SCHEMA, TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = :database ORDER BY TABLE_NAME ASC");
         $statement->bindParamToValue(':database', $aDatabase);
         $statement->execute();
-      }
-      else {
+      } else {
         $statement = $this->query("SELECT TABLE_SCHEMA, TABLE_NAME FROM INFORMATION_SCHEMA.TABLES");
       }
 

PDOStatement.php

Braces +7 added lines, -14 removed lines

@@ -30,12 +30,10 @@ 
       if ($aAllRows) {
         if ($aGroupByFirstCol) {
           return $this->fetchAll(\PDO::FETCH_ASSOC | \PDO::FETCH_GROUP);
-        }
-        else {
+        } else {
           return $this->fetchAll(\PDO::FETCH_ASSOC);
         }
-      }
-      else {
+      } else {
         return $this->fetch(\PDO::FETCH_ASSOC);
       }
     }
@@ -50,12 +48,10 @@ 
       if ($aAllRows) {
         if ($aGroupByFirstCol) {
           return $this->fetchAll(\PDO::FETCH_KEY_PAIR | \PDO::FETCH_GROUP);
-        }
-        else {
+        } else {
           return $this->fetchAll(\PDO::FETCH_KEY_PAIR);
         }
-      }
-      else {
+      } else {
         return $this->fetch(\PDO::FETCH_KEY_PAIR);
       }
     }
@@ -72,20 +68,17 @@ 
     public function fetchObj($aClassName = 'stdClass', $aConstructorArguments = array(), $aRunConstructorFirst = true, $aAllRows = true, $aGroupByFirstCol = false) {
       if ($aRunConstructorFirst) {
         $this->setFetchMode(\PDO::FETCH_CLASS | \PDO::FETCH_PROPS_LATE, $aClassName, $aConstructorArguments);
-      }
-      else {
+      } else {
         $this->setFetchMode(\PDO::FETCH_CLASS, $aClassName, $aConstructorArguments);
       }
 
       if ($aAllRows) {
         if ($aGroupByFirstCol) {
           return $this->fetchAll(\PDO::FETCH_CLASS | \PDO::FETCH_GROUP);
-        }
-        else {
+        } else {
           return $this->fetchAll(\PDO::FETCH_CLASS);
         }
-      }
-      else {
+      } else {
         return $this->fetch(\PDO::FETCH_CLASS);
       }
     }

PDODatabase.php

Spacing +4 added lines, -4 removed lines

@@ -127,7 +127,7 @@ 
         if ($length <= 191) { //skip index if too long for MySQL
           $tableDef .= ',' . PHP_EOL . PHP_EOL;
           $tableDef .= 'PRIMARY KEY (';
-          $tableDef .= join(', ' . PHP_EOL, array_map(function($c) {return '`'.strtolower($c).'`';}, $primaryKey));
+          $tableDef .= join(', ' . PHP_EOL, array_map(function($c) {return '`' . strtolower($c) . '`'; }, $primaryKey));
           $tableDef .= ')';
         }
       }
@@ -151,7 +151,7 @@ 
           }
           $tableDef .= ',' . PHP_EOL;
           $tableDef .= 'KEY `' . strtolower($indexName) . '` (';
-          $tableDef .= join(", ", array_map(function($c) {return '`'.strtolower($c).'`';}, $indexColumns));
+          $tableDef .= join(", ", array_map(function($c) {return '`' . strtolower($c) . '`'; }, $indexColumns));
           $tableDef .= ')';
         }
       }
@@ -193,7 +193,7 @@ 
       if ($primaryKey) {
         $tableDef .= ',' . PHP_EOL . PHP_EOL;
         $tableDef .= 'PRIMARY KEY (';
-        $tableDef .= join(', ' . PHP_EOL, array_map(function($c) {return '"'.strtolower($c).'"';}, $primaryKey));
+        $tableDef .= join(', ' . PHP_EOL, array_map(function($c) {return '"' . strtolower($c) . '"'; }, $primaryKey));
         $tableDef .= ')';
       }
 
@@ -206,7 +206,7 @@ 
           }
           $tableDef .= ',' . PHP_EOL;
           $tableDef .= 'KEY `' . strtolower($indexName) . '` (';
-          $tableDef .= join(', ', array_map(function($c) {return '"'.strtolower($c).'"';}, $indexColumns));
+          $tableDef .= join(', ', array_map(function($c) {return '"' . strtolower($c) . '"'; }, $indexColumns));
           $tableDef .= ')';
         }
       }

Braces +1 added lines, -2 removed lines

@@ -69,8 +69,7 @@
         case self::PARAM_IS_INT:
           if (is_int($aParam) || ctype_digit($aParam)) {
             return (int)$aParam;
-          }
-          else {
+          } else {
             throw new \RuntimeException("Parameter {$aParam} is not an integer");
           }
           break;