@@ -48,8 +48,8 @@ |
||
48 | 48 | $database = $database[$connection]['database']; |
49 | 49 | |
50 | 50 | $pdo = new PDO( |
51 | - 'mysql:host=' . $database[$connection]['hostname'] . |
|
52 | - ';dbname=' . $database[$connection]['database'], |
|
51 | + 'mysql:host='.$database[$connection]['hostname']. |
|
52 | + ';dbname='.$database[$connection]['database'], |
|
53 | 53 | $database[$connection]['username'], |
54 | 54 | $database[$connection]['password'] |
55 | 55 | ); |
@@ -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(); |
@@ -37,7 +37,7 @@ discard block |
||
37 | 37 | $columns = []; |
38 | 38 | |
39 | 39 | // Gets list of columns |
40 | - $query = 'PRAGMA table_info("' . $table . '");'; |
|
40 | + $query = 'PRAGMA table_info("'.$table.'");'; |
|
41 | 41 | $information = $this->pdo->prepare($query); |
42 | 42 | |
43 | 43 | $information->execute(); |
@@ -63,7 +63,7 @@ discard block |
||
63 | 63 | } |
64 | 64 | |
65 | 65 | // Gets list of foreign keys |
66 | - $query = 'PRAGMA foreign_key_list("' . $table . '");'; |
|
66 | + $query = 'PRAGMA foreign_key_list("'.$table.'");'; |
|
67 | 67 | $information = $this->pdo->prepare($query); |
68 | 68 | |
69 | 69 | $information->execute(); |