dvdoug / DB

MySQLColumnMeta.php

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':

MSSQLColumnMeta.php

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':

DDLGeneration.php

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;

OracleColumnMeta.php

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':

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 .= ')';
         }
       }