@@ -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(); |