@@ -379,7 +379,7 @@ |
||
379 | 379 | if($this->_requestCompleted) |
380 | 380 | break; |
381 | 381 | $method = self::$_steps[$this->_step]; |
382 | - Prado::trace("Executing $method()", 'Prado\TApplication'); |
|
382 | + Prado::trace("executing $method()", 'Prado\TApplication'); |
|
383 | 383 | $this->$method(); |
384 | 384 | $this->_step++; |
385 | 385 | } |
@@ -311,7 +311,7 @@ discard block |
||
311 | 311 | { |
312 | 312 | $table = $this->getTableInfo()->getTableFullName(); |
313 | 313 | $fields = implode(', ', $this -> getSelectFieldList($select)); |
314 | - $sql = "SELECT {$fields} FROM {$table}"; |
|
314 | + $sql = "select {$fields} FROM {$table}"; |
|
315 | 315 | if(!empty($where)) |
316 | 316 | $sql .= " WHERE {$where}"; |
317 | 317 | return $this->applyCriterias($sql, $parameters, $ordering, $limit, $offset); |
@@ -392,7 +392,7 @@ discard block |
||
392 | 392 | |
393 | 393 | if (!empty($where)) |
394 | 394 | $where = ' WHERE ' . $where; |
395 | - $command = $this->createCommand("UPDATE {$table} SET {$fields}" . $where); |
|
395 | + $command = $this->createCommand("update {$table} SET {$fields}" . $where); |
|
396 | 396 | $this->bindArrayValues($command, array_merge($data, $parameters)); |
397 | 397 | return $command; |
398 | 398 | } |
@@ -316,7 +316,7 @@ |
||
316 | 316 | REFERENCED_TABLE_NAME IS NOT NULL |
317 | 317 | AND TABLE_NAME LIKE :table |
318 | 318 | $andSchema |
319 | -EOD; |
|
319 | +eod; |
|
320 | 320 | $command = $this->getDbConnection()->createCommand($sql); |
321 | 321 | $command->bindValue(':table', $tableName); |
322 | 322 | if($schemaName !== null) |
@@ -97,7 +97,7 @@ discard block |
||
97 | 97 | TABLE_NAME = '{$tableName}' |
98 | 98 | AND OWNER = '{$schemaName}' |
99 | 99 | ORDER BY a.COLUMN_ID |
100 | -EOD; |
|
100 | +eod; |
|
101 | 101 | $this->getDbConnection()->setActive(true); |
102 | 102 | $this->getDbConnection()->setAttribute(PDO::ATTR_CASE, PDO::CASE_LOWER); |
103 | 103 | $command = $this->getDbConnection()->createCommand($sql); |
@@ -160,7 +160,7 @@ discard block |
||
160 | 160 | from ALL_OBJECTS |
161 | 161 | where OBJECT_NAME = '{$tableName}' |
162 | 162 | and OWNER = '{$schemaName}' |
163 | -EOD; |
|
163 | +eod; |
|
164 | 164 | $this->getDbConnection()->setActive(true); |
165 | 165 | $command = $this->getDbConnection()->createCommand($sql); |
166 | 166 | //$command->bindValue(':schema',$schemaName); |
@@ -259,7 +259,7 @@ discard block |
||
259 | 259 | and a.TABLE_NAME = '{$tableName}' |
260 | 260 | and a.OWNER = '{$schemaName}' |
261 | 261 | and a.CONSTRAINT_TYPE in ('P','R') |
262 | -EOD; |
|
262 | +eod; |
|
263 | 263 | $this->getDbConnection()->setActive(true); |
264 | 264 | $command = $this->getDbConnection()->createCommand($sql); |
265 | 265 | //$command->bindValue(':table', $tableName); |
@@ -351,7 +351,7 @@ discard block |
||
351 | 351 | { |
352 | 352 | $sql = <<<EOD |
353 | 353 | SELECT table_name, '{$schema}' as table_schema FROM user_tables |
354 | -EOD; |
|
354 | +eod; |
|
355 | 355 | $command = $this->getDbConnection()->createCommand($sql); |
356 | 356 | } |
357 | 357 | else |
@@ -359,7 +359,7 @@ discard block |
||
359 | 359 | $sql = <<<EOD |
360 | 360 | SELECT object_name as table_name, owner as table_schema FROM all_objects |
361 | 361 | WHERE object_type = 'TABLE' AND owner=:schema |
362 | -EOD; |
|
362 | +eod; |
|
363 | 363 | $command = $this->getDbConnection()->createCommand($sql); |
364 | 364 | $command->bindParam(':schema', $schema); |
365 | 365 | } |
@@ -83,7 +83,7 @@ discard block |
||
83 | 83 | INFORMATION_SCHEMA.COLUMNS c |
84 | 84 | WHERE t.table_name = c.table_name |
85 | 85 | AND t.table_name = :table |
86 | -EOD; |
|
86 | +eod; |
|
87 | 87 | if($schemaName !== null) |
88 | 88 | $sql .= ' AND t.table_schema = :schema'; |
89 | 89 | if($catalogName !== null) |
@@ -192,7 +192,7 @@ discard block |
||
192 | 192 | AND |
193 | 193 | c.constraint_type ='PRIMARY KEY' |
194 | 194 | AND k.table_name = :table |
195 | -EOD; |
|
195 | +eod; |
|
196 | 196 | $command = $this->getDbConnection()->createCommand($sql); |
197 | 197 | $command->bindValue(':table', $col['TABLE_NAME']); |
198 | 198 | $primary = []; |
@@ -235,7 +235,7 @@ discard block |
||
235 | 235 | RC.UNIQUE_CONSTRAINT_NAME |
236 | 236 | AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION |
237 | 237 | WHERE KCU1.TABLE_NAME = :table |
238 | -EOD; |
|
238 | +eod; |
|
239 | 239 | $command = $this->getDbConnection()->createCommand($sql); |
240 | 240 | $command->bindValue(':table', $col['TABLE_NAME']); |
241 | 241 | $fkeys = []; |
@@ -275,7 +275,7 @@ discard block |
||
275 | 275 | $sql = <<<EOD |
276 | 276 | SELECT TABLE_NAME, TABLE_SCHEMA FROM [INFORMATION_SCHEMA].[TABLES] |
277 | 277 | WHERE TABLE_SCHEMA=:schema AND $condition |
278 | -EOD; |
|
278 | +eod; |
|
279 | 279 | $command = $this->getDbConnection()->createCommand($sql); |
280 | 280 | $command->bindParam(":schema", $schema); |
281 | 281 | $rows = $command->queryAll(); |
@@ -137,7 +137,7 @@ discard block |
||
137 | 137 | nspname = :schema)) |
138 | 138 | AND a.attnum > 0 AND NOT a.attisdropped |
139 | 139 | ORDER BY a.attnum |
140 | -EOD; |
|
140 | +eod; |
|
141 | 141 | $this->getDbConnection()->setActive(true); |
142 | 142 | $command = $this->getDbConnection()->createCommand($sql); |
143 | 143 | $command->bindValue(':table', $tableName); |
@@ -197,7 +197,7 @@ discard block |
||
197 | 197 | SELECT count(c.relname) FROM pg_catalog.pg_class c |
198 | 198 | LEFT JOIN pg_catalog.pg_namespace n ON (n.oid = c.relnamespace) |
199 | 199 | WHERE (n.nspname=:schema) AND (c.relkind = 'v'::"char") AND c.relname = :table |
200 | -EOD; |
|
200 | +eod; |
|
201 | 201 | $this->getDbConnection()->setActive(true); |
202 | 202 | $command = $this->getDbConnection()->createCommand($sql); |
203 | 203 | $command->bindValue(':schema', $schemaName); |
@@ -332,7 +332,7 @@ discard block |
||
332 | 332 | WHERE nspname=:schema)) |
333 | 333 | ORDER BY |
334 | 334 | 1 |
335 | -EOD; |
|
335 | +eod; |
|
336 | 336 | $this->getDbConnection()->setActive(true); |
337 | 337 | $command = $this->getDbConnection()->createCommand($sql); |
338 | 338 | $command->bindValue(':table', $tableName); |
@@ -372,7 +372,7 @@ discard block |
||
372 | 372 | ) |
373 | 373 | ) |
374 | 374 | AND attnum IN ({$index}) |
375 | -EOD; |
|
375 | +eod; |
|
376 | 376 | $command = $this->getDbConnection()->createCommand($sql); |
377 | 377 | $command->bindValue(':table', $tableName); |
378 | 378 | $command->bindValue(':schema', $schemaName); |
@@ -434,7 +434,7 @@ discard block |
||
434 | 434 | $sql = <<<EOD |
435 | 435 | SELECT table_name, table_schema FROM information_schema.tables |
436 | 436 | WHERE table_schema=:schema AND table_type='BASE TABLE' |
437 | -EOD; |
|
437 | +eod; |
|
438 | 438 | $command = $this->getDbConnection()->createCommand($sql); |
439 | 439 | $command->bindParam(':schema', $schema); |
440 | 440 | $rows = $command->queryAll(); |
@@ -237,7 +237,7 @@ |
||
237 | 237 | $srcColumns = $this->getSourceColumns($sourceKeys); |
238 | 238 | if(($where = $criteria->getCondition()) === null) |
239 | 239 | $where = '1=1'; |
240 | - $sql = "SELECT {$fkTable}.*, {$srcColumns} FROM {$fkTable} {$innerJoin} WHERE {$where}"; |
|
240 | + $sql = "select {$fkTable}.*, {$srcColumns} FROM {$fkTable} {$innerJoin} WHERE {$where}"; |
|
241 | 241 | |
242 | 242 | $parameters = $criteria->getParameters()->toArray(); |
243 | 243 | $ordering = $criteria->getOrdersBy(); |
@@ -56,7 +56,7 @@ |
||
56 | 56 | * @var TActiveRecordInvalidFinderResult |
57 | 57 | * @since 3.1.5 |
58 | 58 | */ |
59 | - private $_invalidFinderResult = TActiveRecordInvalidFinderResult::Null; |
|
59 | + private $_invalidFinderResult = TActiveRecordInvalidFinderResult::null; |
|
60 | 60 | |
61 | 61 | /** |
62 | 62 | * @return ICache application cache. |
@@ -102,7 +102,7 @@ |
||
102 | 102 | * @var TActiveRecordInvalidFinderResult |
103 | 103 | * @since 3.1.5 |
104 | 104 | */ |
105 | - private $_invalidFinderResult = TActiveRecordInvalidFinderResult::Null; |
|
105 | + private $_invalidFinderResult = TActiveRecordInvalidFinderResult::null; |
|
106 | 106 | |
107 | 107 | /** |
108 | 108 | * Initialize the active record manager. |