| @@ -40,7 +40,7 @@ discard block | ||
| 40 | 40 |      { | 
| 41 | 41 | $this->columns = []; | 
| 42 | 42 | |
| 43 | -        $information = $this->pdo->prepare('DESCRIBE ' . $table); | |
| 43 | +        $information = $this->pdo->prepare('DESCRIBE '.$table); | |
| 44 | 44 | $information->execute(); | 
| 45 | 45 | $information->setFetchMode(PDO::FETCH_OBJ); | 
| 46 | 46 | |
| @@ -88,15 +88,15 @@ discard block | ||
| 88 | 88 | $column->setDataType($row->Type); | 
| 89 | 89 | } | 
| 90 | 90 | |
| 91 | - $query = 'SELECT COLUMN_NAME as "column",' . | |
| 92 | - 'REFERENCED_COLUMN_NAME as "referenced_column",' . | |
| 93 | -                'CONCAT(' . | |
| 94 | - 'REFERENCED_TABLE_SCHEMA, ".",' . | |
| 95 | - 'REFERENCED_TABLE_NAME' . | |
| 96 | - ') as "referenced_table"' . | |
| 97 | - 'FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE ' . | |
| 98 | - 'WHERE CONSTRAINT_SCHEMA = "' . $this->database . '" ' . | |
| 99 | - 'AND TABLE_NAME = "' . $table . '";'; | |
| 91 | + $query = 'SELECT COLUMN_NAME as "column",'. | |
| 92 | + 'REFERENCED_COLUMN_NAME as "referenced_column",'. | |
| 93 | +                'CONCAT('. | |
| 94 | + 'REFERENCED_TABLE_SCHEMA, ".",'. | |
| 95 | + 'REFERENCED_TABLE_NAME'. | |
| 96 | + ') as "referenced_table"'. | |
| 97 | + 'FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE '. | |
| 98 | + 'WHERE CONSTRAINT_SCHEMA = "'.$this->database.'" '. | |
| 99 | + 'AND TABLE_NAME = "'.$table.'";'; | |
| 100 | 100 | |
| 101 | 101 | $foreignTable = $this->pdo->prepare($query); | 
| 102 | 102 | $foreignTable->execute(); | 
| @@ -28,7 +28,7 @@ | ||
| 28 | 28 |          switch ($database['dbdriver']) { | 
| 29 | 29 | case 'mysql': | 
| 30 | 30 | case 'mysqli': | 
| 31 | - $dsn = 'mysql:host=' . $database['hostname'] . ';dbname=' . $database['database']; | |
| 31 | + $dsn = 'mysql:host='.$database['hostname'].';dbname='.$database['database']; | |
| 32 | 32 | $pdo = new \PDO($dsn, $database['username'], $database['password']); | 
| 33 | 33 | |
| 34 | 34 | $this->driver = new MySQLDriver($pdo, $database['database']); | 
| @@ -36,7 +36,7 @@ discard block | ||
| 36 | 36 | $columns = []; | 
| 37 | 37 | |
| 38 | 38 | // Gets list of columns | 
| 39 | -        $query = 'PRAGMA table_info("' . $table . '");'; | |
| 39 | +        $query = 'PRAGMA table_info("'.$table.'");'; | |
| 40 | 40 | $information = $this->pdo->prepare($query); | 
| 41 | 41 | |
| 42 | 42 | $information->execute(); | 
| @@ -45,7 +45,7 @@ discard block | ||
| 45 | 45 |          while ($row = $information->fetch()) { | 
| 46 | 46 | $column = new Column; | 
| 47 | 47 | |
| 48 | -            if (! $row->notnull) { | |
| 48 | +            if ( ! $row->notnull) { | |
| 49 | 49 | $column->setNull(true); | 
| 50 | 50 | } | 
| 51 | 51 | |
| @@ -62,7 +62,7 @@ discard block | ||
| 62 | 62 | } | 
| 63 | 63 | |
| 64 | 64 | // Gets list of foreign keys | 
| 65 | -        $query = 'PRAGMA foreign_key_list("' . $table . '");'; | |
| 65 | +        $query = 'PRAGMA foreign_key_list("'.$table.'");'; | |
| 66 | 66 | $information = $this->pdo->prepare($query); | 
| 67 | 67 | |
| 68 | 68 | $information->execute(); | 
| @@ -69,7 +69,7 @@ | ||
| 69 | 69 |          switch ($driverName) { | 
| 70 | 70 | case 'mysql': | 
| 71 | 71 | case 'mysqli': | 
| 72 | - $dsn = 'mysql:host=' . $hostname . ';dbname=' . $database; | |
| 72 | + $dsn = 'mysql:host='.$hostname.';dbname='.$database; | |
| 73 | 73 | $pdo = new PDO($dsn, $username, $password); | 
| 74 | 74 | $driver = new MySQLDriver($pdo, $database); | 
| 75 | 75 | |