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