@@ -455,8 +455,8 @@ |
||
| 455 | 455 | public function getListTablesSQL() |
| 456 | 456 | { |
| 457 | 457 | return "SELECT name FROM sqlite_master WHERE type = 'table' AND name != 'sqlite_sequence' AND name != 'geometry_columns' AND name != 'spatial_ref_sys' " |
| 458 | - . "UNION ALL SELECT name FROM sqlite_temp_master " |
|
| 459 | - . "WHERE type = 'table' ORDER BY name"; |
|
| 458 | + . "UNION ALL SELECT name FROM sqlite_temp_master " |
|
| 459 | + . "WHERE type = 'table' ORDER BY name"; |
|
| 460 | 460 | } |
| 461 | 461 | |
| 462 | 462 | /** |
@@ -198,10 +198,10 @@ discard block |
||
| 198 | 198 | public function getCreateSequenceSQL(Sequence $sequence) |
| 199 | 199 | { |
| 200 | 200 | return 'CREATE SEQUENCE ' . $sequence->getQuotedName($this) . |
| 201 | - ' START WITH ' . $sequence->getInitialValue() . |
|
| 202 | - ' MINVALUE ' . $sequence->getInitialValue() . |
|
| 203 | - ' INCREMENT BY ' . $sequence->getAllocationSize() . |
|
| 204 | - $this->getSequenceCacheSQL($sequence); |
|
| 201 | + ' START WITH ' . $sequence->getInitialValue() . |
|
| 202 | + ' MINVALUE ' . $sequence->getInitialValue() . |
|
| 203 | + ' INCREMENT BY ' . $sequence->getAllocationSize() . |
|
| 204 | + $this->getSequenceCacheSQL($sequence); |
|
| 205 | 205 | } |
| 206 | 206 | |
| 207 | 207 | /** |
@@ -210,8 +210,8 @@ discard block |
||
| 210 | 210 | public function getAlterSequenceSQL(Sequence $sequence) |
| 211 | 211 | { |
| 212 | 212 | return 'ALTER SEQUENCE ' . $sequence->getQuotedName($this) . |
| 213 | - ' INCREMENT BY ' . $sequence->getAllocationSize() |
|
| 214 | - . $this->getSequenceCacheSQL($sequence); |
|
| 213 | + ' INCREMENT BY ' . $sequence->getAllocationSize() |
|
| 214 | + . $this->getSequenceCacheSQL($sequence); |
|
| 215 | 215 | } |
| 216 | 216 | |
| 217 | 217 | /** |
@@ -390,7 +390,7 @@ discard block |
||
| 390 | 390 | $database = $this->quoteStringLiteral($database->getName()); |
| 391 | 391 | |
| 392 | 392 | return "SELECT sequence_name, min_value, increment_by FROM sys.all_sequences ". |
| 393 | - "WHERE SEQUENCE_OWNER = " . $database; |
|
| 393 | + "WHERE SEQUENCE_OWNER = " . $database; |
|
| 394 | 394 | } |
| 395 | 395 | |
| 396 | 396 | /** |
@@ -41,7 +41,7 @@ discard block |
||
| 41 | 41 | public function getAlterSequenceSQL(Sequence $sequence) |
| 42 | 42 | { |
| 43 | 43 | return 'ALTER SEQUENCE ' . $sequence->getQuotedName($this) . |
| 44 | - ' INCREMENT BY ' . $sequence->getAllocationSize(); |
|
| 44 | + ' INCREMENT BY ' . $sequence->getAllocationSize(); |
|
| 45 | 45 | } |
| 46 | 46 | |
| 47 | 47 | /** |
@@ -50,9 +50,9 @@ discard block |
||
| 50 | 50 | public function getCreateSequenceSQL(Sequence $sequence) |
| 51 | 51 | { |
| 52 | 52 | return 'CREATE SEQUENCE ' . $sequence->getQuotedName($this) . |
| 53 | - ' START WITH ' . $sequence->getInitialValue() . |
|
| 54 | - ' INCREMENT BY ' . $sequence->getAllocationSize() . |
|
| 55 | - ' MINVALUE ' . $sequence->getInitialValue(); |
|
| 53 | + ' START WITH ' . $sequence->getInitialValue() . |
|
| 54 | + ' INCREMENT BY ' . $sequence->getAllocationSize() . |
|
| 55 | + ' MINVALUE ' . $sequence->getInitialValue(); |
|
| 56 | 56 | } |
| 57 | 57 | |
| 58 | 58 | /** |
@@ -350,9 +350,9 @@ discard block |
||
| 350 | 350 | } |
| 351 | 351 | |
| 352 | 352 | return "SELECT COLUMN_NAME, DATA_TYPE, COLUMN_COMMENT, IS_NULLABLE, IS_AUTO_INCREMENT, CHARACTER_MAXIMUM_LENGTH, COLUMN_DEFAULT," . |
| 353 | - " NUMERIC_PRECISION, NUMERIC_SCALE, COLLATION_NAME" . |
|
| 354 | - " FROM DATA_DICTIONARY.COLUMNS" . |
|
| 355 | - " WHERE TABLE_SCHEMA=" . $database . " AND TABLE_NAME = '" . $table . "'"; |
|
| 353 | + " NUMERIC_PRECISION, NUMERIC_SCALE, COLLATION_NAME" . |
|
| 354 | + " FROM DATA_DICTIONARY.COLUMNS" . |
|
| 355 | + " WHERE TABLE_SCHEMA=" . $database . " AND TABLE_NAME = '" . $table . "'"; |
|
| 356 | 356 | } |
| 357 | 357 | |
| 358 | 358 | /** |
@@ -367,8 +367,8 @@ discard block |
||
| 367 | 367 | } |
| 368 | 368 | |
| 369 | 369 | return "SELECT CONSTRAINT_NAME, CONSTRAINT_COLUMNS, REFERENCED_TABLE_NAME, REFERENCED_TABLE_COLUMNS, UPDATE_RULE, DELETE_RULE" . |
| 370 | - " FROM DATA_DICTIONARY.FOREIGN_KEYS" . |
|
| 371 | - " WHERE CONSTRAINT_SCHEMA=" . $database . " AND CONSTRAINT_TABLE='" . $table . "'"; |
|
| 370 | + " FROM DATA_DICTIONARY.FOREIGN_KEYS" . |
|
| 371 | + " WHERE CONSTRAINT_SCHEMA=" . $database . " AND CONSTRAINT_TABLE='" . $table . "'"; |
|
| 372 | 372 | } |
| 373 | 373 | |
| 374 | 374 | /** |
@@ -383,8 +383,8 @@ discard block |
||
| 383 | 383 | } |
| 384 | 384 | |
| 385 | 385 | return "SELECT INDEX_NAME AS 'key_name', COLUMN_NAME AS 'column_name', IS_USED_IN_PRIMARY AS 'primary', IS_UNIQUE=0 AS 'non_unique'" . |
| 386 | - " FROM DATA_DICTIONARY.INDEX_PARTS" . |
|
| 387 | - " WHERE TABLE_SCHEMA=" . $database . " AND TABLE_NAME='" . $table . "'"; |
|
| 386 | + " FROM DATA_DICTIONARY.INDEX_PARTS" . |
|
| 387 | + " WHERE TABLE_SCHEMA=" . $database . " AND TABLE_NAME='" . $table . "'"; |
|
| 388 | 388 | } |
| 389 | 389 | |
| 390 | 390 | /** |
@@ -601,7 +601,7 @@ discard block |
||
| 601 | 601 | } |
| 602 | 602 | } |
| 603 | 603 | } elseif (is_bool($item) || is_numeric($item)) { |
| 604 | - $item = ($item) ? 'true' : 'false'; |
|
| 604 | + $item = ($item) ? 'true' : 'false'; |
|
| 605 | 605 | } |
| 606 | 606 | |
| 607 | 607 | return $item; |
@@ -41,8 +41,8 @@ |
||
| 41 | 41 | |
| 42 | 42 | $mock = $this->createMock(get_class($this->_platform)); |
| 43 | 43 | $mock->expects($this->any()) |
| 44 | - ->method('hasNativeGuidType') |
|
| 45 | - ->will($this->returnValue(true)); |
|
| 44 | + ->method('hasNativeGuidType') |
|
| 45 | + ->will($this->returnValue(true)); |
|
| 46 | 46 | |
| 47 | 47 | self::assertFalse($this->_type->requiresSQLCommentHint($mock)); |
| 48 | 48 | } |
@@ -54,7 +54,7 @@ |
||
| 54 | 54 | ->with( |
| 55 | 55 | $this->equalTo(3), |
| 56 | 56 | $this->equalTo($params[2]) |
| 57 | - ); |
|
| 57 | + ); |
|
| 58 | 58 | |
| 59 | 59 | // can't pass to constructor since we don't have a real database handle, |
| 60 | 60 | // but execute must check the connection for the executeMode |
@@ -55,8 +55,8 @@ |
||
| 55 | 55 | public function getValidCharsets() |
| 56 | 56 | { |
| 57 | 57 | return array( |
| 58 | - array("UTF8"), |
|
| 59 | - array("LATIN1") |
|
| 58 | + array("UTF8"), |
|
| 59 | + array("LATIN1") |
|
| 60 | 60 | ); |
| 61 | 61 | } |
| 62 | 62 | } |
@@ -50,8 +50,8 @@ |
||
| 50 | 50 | { |
| 51 | 51 | return new \Doctrine\DBAL\Driver\Mysqli\MysqliConnection( |
| 52 | 52 | array( |
| 53 | - 'host' => $GLOBALS['db_host'], |
|
| 54 | - 'dbname' => $GLOBALS['db_name'], |
|
| 53 | + 'host' => $GLOBALS['db_host'], |
|
| 54 | + 'dbname' => $GLOBALS['db_name'], |
|
| 55 | 55 | ), |
| 56 | 56 | $GLOBALS['db_username'], |
| 57 | 57 | $GLOBALS['db_password'], |
@@ -159,7 +159,7 @@ |
||
| 159 | 159 | |
| 160 | 160 | $tableIndexes = $this->_sm->listTableIndexes('non_default_pk_order'); |
| 161 | 161 | |
| 162 | - self::assertCount(1, $tableIndexes); |
|
| 162 | + self::assertCount(1, $tableIndexes); |
|
| 163 | 163 | |
| 164 | 164 | self::assertArrayHasKey('primary', $tableIndexes, 'listTableIndexes() has to return a "primary" array key.'); |
| 165 | 165 | self::assertEquals(array('other_id', 'id'), array_map('strtolower', $tableIndexes['primary']->getColumns())); |