@@ -52,8 +52,8 @@ |
||
| 52 | 52 | $mysql = $database[$connection]; |
| 53 | 53 | |
| 54 | 54 | $pdo = new PDO( |
| 55 | - 'mysql:host=' . $mysql['hostname'] . |
|
| 56 | - ';dbname=' . $mysql['database'], |
|
| 55 | + 'mysql:host='.$mysql['hostname']. |
|
| 56 | + ';dbname='.$mysql['database'], |
|
| 57 | 57 | $mysql['username'], |
| 58 | 58 | $mysql['password'] |
| 59 | 59 | ); |
@@ -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(); |
@@ -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 | |
@@ -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(); |