@@ -115,32 +115,32 @@ discard block |
||
115 | 115 | if ( $table->hasColumn ( $constrant[ "column_name" ] ) ) |
116 | 116 | { |
117 | 117 | $objConstrant = Constrant::getInstance () |
118 | - ->populate ( |
|
119 | - array ( |
|
120 | - 'constrant' => $constrant[ 'constraint_name' ] , |
|
121 | - 'schema' => $constrant[ 'foreign_schema' ] , |
|
122 | - 'table' => $constrant[ 'foreign_table' ] , |
|
123 | - 'column' => $constrant[ 'foreign_column' ] , |
|
124 | - 'database' => $this->database |
|
125 | - ) |
|
126 | - ); |
|
118 | + ->populate ( |
|
119 | + array ( |
|
120 | + 'constrant' => $constrant[ 'constraint_name' ] , |
|
121 | + 'schema' => $constrant[ 'foreign_schema' ] , |
|
122 | + 'table' => $constrant[ 'foreign_table' ] , |
|
123 | + 'column' => $constrant[ 'foreign_column' ] , |
|
124 | + 'database' => $this->database |
|
125 | + ) |
|
126 | + ); |
|
127 | 127 | |
128 | 128 | switch ( $constrant[ 'constraint_type' ] ) |
129 | 129 | { |
130 | 130 | case "FOREIGN KEY": |
131 | 131 | $table->getColumn ( $constrant[ "column_name" ] ) |
132 | - ->addRefFk ( $objConstrant ); |
|
132 | + ->addRefFk ( $objConstrant ); |
|
133 | 133 | break; |
134 | 134 | case"PRIMARY KEY": |
135 | 135 | $table->getColumn ( $constrant[ "column_name" ] ) |
136 | - ->setPrimaryKey ( $objConstrant ) |
|
137 | - ->setSequence ( |
|
138 | - $this->getSequence ( |
|
139 | - $table_name , |
|
140 | - $constrant[ "column_name" ] , |
|
141 | - $schema |
|
142 | - ) |
|
143 | - ); |
|
136 | + ->setPrimaryKey ( $objConstrant ) |
|
137 | + ->setSequence ( |
|
138 | + $this->getSequence ( |
|
139 | + $table_name , |
|
140 | + $constrant[ "column_name" ] , |
|
141 | + $schema |
|
142 | + ) |
|
143 | + ); |
|
144 | 144 | break; |
145 | 145 | } |
146 | 146 | } |
@@ -160,13 +160,13 @@ discard block |
||
160 | 160 | if ( $table->hasColumn ( $constrant[ "foreign_column" ] ) ) |
161 | 161 | { |
162 | 162 | $table->getColumn ( $constrant[ "foreign_column" ] ) |
163 | - ->createDependece ( |
|
164 | - $constrant[ 'constraint_name' ] , |
|
165 | - $constrant[ 'table_name' ] , |
|
166 | - $constrant[ 'column_name' ] , |
|
167 | - $this->database , |
|
168 | - $constrant[ 'table_schema' ] |
|
169 | - ); |
|
163 | + ->createDependece ( |
|
164 | + $constrant[ 'constraint_name' ] , |
|
165 | + $constrant[ 'table_name' ] , |
|
166 | + $constrant[ 'column_name' ] , |
|
167 | + $this->database , |
|
168 | + $constrant[ 'table_schema' ] |
|
169 | + ); |
|
170 | 170 | } |
171 | 171 | } |
172 | 172 | } |
@@ -201,10 +201,10 @@ discard block |
||
201 | 201 | ); |
202 | 202 | |
203 | 203 | $this->getTable ( $key , $schema ) |
204 | - ->addColumn ( $column ) |
|
205 | - ->setNamespace ( |
|
206 | - $this->config->createClassNamespace ( $this->getTable ( $key , $schema ) ) |
|
207 | - ); |
|
204 | + ->addColumn ( $column ) |
|
205 | + ->setNamespace ( |
|
206 | + $this->config->createClassNamespace ( $this->getTable ( $key , $schema ) ) |
|
207 | + ); |
|
208 | 208 | } |
209 | 209 | } |
210 | 210 | |
@@ -279,13 +279,13 @@ discard block |
||
279 | 279 | } |
280 | 280 | |
281 | 281 | $this->objDbTables[ strtoupper($schema) ][ trim ( $nameTable ) ] = DbTable::getInstance () |
282 | - ->populate ( |
|
283 | - array ( |
|
284 | - 'table' => $nameTable , |
|
285 | - 'schema' => $schema , |
|
286 | - 'database' => $this->database |
|
287 | - ) |
|
288 | - ); |
|
282 | + ->populate ( |
|
283 | + array ( |
|
284 | + 'table' => $nameTable , |
|
285 | + 'schema' => $schema , |
|
286 | + 'database' => $this->database |
|
287 | + ) |
|
288 | + ); |
|
289 | 289 | |
290 | 290 | return $this; |
291 | 291 | } |
@@ -178,14 +178,14 @@ discard block |
||
178 | 178 | $strSchema = implode ( "', '" , $this->schema ); |
179 | 179 | |
180 | 180 | $this->totalTables = $this->getPDO () |
181 | - ->query ( |
|
182 | - "SELECT COUNT(table_name) AS total |
|
181 | + ->query ( |
|
182 | + "SELECT COUNT(table_name) AS total |
|
183 | 183 | FROM {$this->database}.information_schema.tables |
184 | 184 | WHERE |
185 | 185 | table_type = 'BASE TABLE' |
186 | 186 | AND table_schema IN ( '" . $strSchema . "' ) $sqlTables" |
187 | - ) |
|
188 | - ->fetchColumn (); |
|
187 | + ) |
|
188 | + ->fetchColumn (); |
|
189 | 189 | } |
190 | 190 | |
191 | 191 | return (int) $this->totalTables; |
@@ -194,10 +194,10 @@ discard block |
||
194 | 194 | public function getSequence ( $table , $column , $schema = 0 ) |
195 | 195 | { |
196 | 196 | $return = $this->getPDO () |
197 | - ->query ( |
|
198 | - "SELECT is_identity FROM sys.columns WHERE object_id = object_id('{$schema}.{$table}') AND name = '{$column}';" |
|
199 | - ) |
|
200 | - ->fetchColumn(); |
|
197 | + ->query ( |
|
198 | + "SELECT is_identity FROM sys.columns WHERE object_id = object_id('{$schema}.{$table}') AND name = '{$column}';" |
|
199 | + ) |
|
200 | + ->fetchColumn(); |
|
201 | 201 | |
202 | 202 | if ( ! $return ) |
203 | 203 | { |