Majkl578 / doctrine-dbal

tests/Doctrine/Tests/DBAL/ConnectionTest.php

Indentation +1 added lines, -1 removed lines

@@ -148,7 +148,7 @@
 
         $driverMock = $this->createMock('Doctrine\DBAL\Driver');
         $driverMock->expects(($this->at(0)))
-                   ->method('connect');
+                    ->method('connect');
         $platform = new Mocks\MockPlatform();
 
         $conn = new Connection(array('platform' => $platform), $driverMock, new Configuration(), $eventManager);

Spacing +1 added lines, -1 removed lines

@@ -831,7 +831,7 @@
             ->method('getResultCacheDriver')
             ->will($this->returnValue($resultCacheDriverMock));
 
-        $query  = 'SELECT 1';
+        $query = 'SELECT 1';
 
         $connectionParams = $this->params;
 

tests/Doctrine/Tests/DBAL/Query/QueryBuilderTest.php

Indentation +82 added lines, -82 removed lines

@@ -23,8 +23,8 @@ 
         $expressionBuilder = new ExpressionBuilder($this->conn);
 
         $this->conn->expects($this->any())
-                   ->method('getExpressionBuilder')
-                   ->will($this->returnValue($expressionBuilder));
+                    ->method('getExpressionBuilder')
+                    ->will($this->returnValue($expressionBuilder));
     }
 
     /**
@@ -44,7 +44,7 @@ 
         $qb = new QueryBuilder($this->conn);
 
         $qb->select('u.id')
-           ->from('users', 'u');
+            ->from('users', 'u');
 
         self::assertEquals('SELECT u.id FROM users u', (string) $qb);
     }
@@ -55,8 +55,8 @@ 
         $expr = $qb->expr();
 
         $qb->select('u.id')
-           ->from('users', 'u')
-           ->where($expr->andX($expr->eq('u.nickname', '?')));
+            ->from('users', 'u')
+            ->where($expr->andX($expr->eq('u.nickname', '?')));
 
         self::assertEquals("SELECT u.id FROM users u WHERE u.nickname = ?", (string) $qb);
     }
@@ -67,8 +67,8 @@ 
         $expr = $qb->expr();
 
         $qb->select('u.*', 'p.*')
-           ->from('users', 'u')
-           ->leftJoin('u', 'phones', 'p', $expr->eq('p.user_id', 'u.id'));
+            ->from('users', 'u')
+            ->leftJoin('u', 'phones', 'p', $expr->eq('p.user_id', 'u.id'));
 
         self::assertEquals('SELECT u.*, p.* FROM users u LEFT JOIN phones p ON p.user_id = u.id', (string) $qb);
     }
@@ -79,8 +79,8 @@ 
         $expr = $qb->expr();
 
         $qb->select('u.*', 'p.*')
-           ->from('users', 'u')
-           ->Join('u', 'phones', 'p', $expr->eq('p.user_id', 'u.id'));
+            ->from('users', 'u')
+            ->Join('u', 'phones', 'p', $expr->eq('p.user_id', 'u.id'));
 
         self::assertEquals('SELECT u.*, p.* FROM users u INNER JOIN phones p ON p.user_id = u.id', (string) $qb);
     }
@@ -91,8 +91,8 @@ 
         $expr = $qb->expr();
 
         $qb->select('u.*', 'p.*')
-           ->from('users', 'u')
-           ->innerJoin('u', 'phones', 'p', $expr->eq('p.user_id', 'u.id'));
+            ->from('users', 'u')
+            ->innerJoin('u', 'phones', 'p', $expr->eq('p.user_id', 'u.id'));
 
         self::assertEquals('SELECT u.*, p.* FROM users u INNER JOIN phones p ON p.user_id = u.id', (string) $qb);
     }
@@ -103,8 +103,8 @@ 
         $expr = $qb->expr();
 
         $qb->select('u.*', 'p.*')
-           ->from('users', 'u')
-           ->rightJoin('u', 'phones', 'p', $expr->eq('p.user_id', 'u.id'));
+            ->from('users', 'u')
+            ->rightJoin('u', 'phones', 'p', $expr->eq('p.user_id', 'u.id'));
 
         self::assertEquals('SELECT u.*, p.* FROM users u RIGHT JOIN phones p ON p.user_id = u.id', (string) $qb);
     }
@@ -115,9 +115,9 @@ 
         $expr = $qb->expr();
 
         $qb->select('u.*', 'p.*')
-           ->from('users', 'u')
-           ->where('u.username = ?')
-           ->andWhere('u.name = ?');
+            ->from('users', 'u')
+            ->where('u.username = ?')
+            ->andWhere('u.name = ?');
 
         self::assertEquals('SELECT u.*, p.* FROM users u WHERE (u.username = ?) AND (u.name = ?)', (string) $qb);
     }
@@ -128,9 +128,9 @@ 
         $expr = $qb->expr();
 
         $qb->select('u.*', 'p.*')
-           ->from('users', 'u')
-           ->where('u.username = ?')
-           ->orWhere('u.name = ?');
+            ->from('users', 'u')
+            ->where('u.username = ?')
+            ->orWhere('u.name = ?');
 
         self::assertEquals('SELECT u.*, p.* FROM users u WHERE (u.username = ?) OR (u.name = ?)', (string) $qb);
     }
@@ -141,9 +141,9 @@ 
         $expr = $qb->expr();
 
         $qb->select('u.*', 'p.*')
-           ->from('users', 'u')
-           ->orWhere('u.username = ?')
-           ->orWhere('u.name = ?');
+            ->from('users', 'u')
+            ->orWhere('u.username = ?')
+            ->orWhere('u.name = ?');
 
         self::assertEquals('SELECT u.*, p.* FROM users u WHERE (u.username = ?) OR (u.name = ?)', (string) $qb);
     }
@@ -154,11 +154,11 @@ 
         $expr = $qb->expr();
 
         $qb->select('u.*', 'p.*')
-           ->from('users', 'u')
-           ->where('u.username = ?')
-           ->andWhere('u.username = ?')
-           ->orWhere('u.name = ?')
-           ->andWhere('u.name = ?');
+            ->from('users', 'u')
+            ->where('u.username = ?')
+            ->andWhere('u.username = ?')
+            ->orWhere('u.name = ?')
+            ->andWhere('u.name = ?');
 
         self::assertEquals('SELECT u.*, p.* FROM users u WHERE (((u.username = ?) AND (u.username = ?)) OR (u.name = ?)) AND (u.name = ?)', (string) $qb);
     }
@@ -169,8 +169,8 @@ 
         $expr = $qb->expr();
 
         $qb->select('u.*', 'p.*')
-           ->from('users', 'u')
-           ->groupBy('u.id');
+            ->from('users', 'u')
+            ->groupBy('u.id');
 
         self::assertEquals('SELECT u.*, p.* FROM users u GROUP BY u.id', (string) $qb);
     }
@@ -181,8 +181,8 @@ 
         $expr = $qb->expr();
 
         $qb->select('u.*', 'p.*')
-           ->groupBy(array())
-           ->from('users', 'u');
+            ->groupBy(array())
+            ->from('users', 'u');
 
         self::assertEquals('SELECT u.*, p.* FROM users u', (string) $qb);
     }
@@ -193,8 +193,8 @@ 
         $expr = $qb->expr();
 
         $qb->select('u.*', 'p.*')
-           ->addGroupBy(array())
-           ->from('users', 'u');
+            ->addGroupBy(array())
+            ->from('users', 'u');
 
         self::assertEquals('SELECT u.*, p.* FROM users u', (string) $qb);
     }
@@ -205,9 +205,9 @@ 
         $expr = $qb->expr();
 
         $qb->select('u.*', 'p.*')
-           ->from('users', 'u')
-           ->groupBy('u.id')
-           ->addGroupBy('u.foo');
+            ->from('users', 'u')
+            ->groupBy('u.id')
+            ->addGroupBy('u.foo');
 
         self::assertEquals('SELECT u.*, p.* FROM users u GROUP BY u.id, u.foo', (string) $qb);
     }
@@ -218,9 +218,9 @@ 
         $expr = $qb->expr();
 
         $qb->select('u.*', 'p.*')
-           ->from('users', 'u')
-           ->groupBy('u.id')
-           ->addGroupBy('u.foo', 'u.bar');
+            ->from('users', 'u')
+            ->groupBy('u.id')
+            ->addGroupBy('u.foo', 'u.bar');
 
         self::assertEquals('SELECT u.*, p.* FROM users u GROUP BY u.id, u.foo, u.bar', (string) $qb);
     }
@@ -231,9 +231,9 @@ 
         $expr = $qb->expr();
 
         $qb->select('u.*', 'p.*')
-           ->from('users', 'u')
-           ->groupBy('u.id')
-           ->having('u.name = ?');
+            ->from('users', 'u')
+            ->groupBy('u.id')
+            ->having('u.name = ?');
 
         self::assertEquals('SELECT u.*, p.* FROM users u GROUP BY u.id HAVING u.name = ?', (string) $qb);
     }
@@ -244,9 +244,9 @@ 
         $expr = $qb->expr();
 
         $qb->select('u.*', 'p.*')
-           ->from('users', 'u')
-           ->groupBy('u.id')
-           ->andHaving('u.name = ?');
+            ->from('users', 'u')
+            ->groupBy('u.id')
+            ->andHaving('u.name = ?');
 
         self::assertEquals('SELECT u.*, p.* FROM users u GROUP BY u.id HAVING u.name = ?', (string) $qb);
     }
@@ -257,10 +257,10 @@ 
         $expr = $qb->expr();
 
         $qb->select('u.*', 'p.*')
-           ->from('users', 'u')
-           ->groupBy('u.id')
-           ->having('u.name = ?')
-           ->andHaving('u.username = ?');
+            ->from('users', 'u')
+            ->groupBy('u.id')
+            ->having('u.name = ?')
+            ->andHaving('u.username = ?');
 
         self::assertEquals('SELECT u.*, p.* FROM users u GROUP BY u.id HAVING (u.name = ?) AND (u.username = ?)', (string) $qb);
     }
@@ -271,10 +271,10 @@ 
         $expr = $qb->expr();
 
         $qb->select('u.*', 'p.*')
-           ->from('users', 'u')
-           ->groupBy('u.id')
-           ->having('u.name = ?')
-           ->orHaving('u.username = ?');
+            ->from('users', 'u')
+            ->groupBy('u.id')
+            ->having('u.name = ?')
+            ->orHaving('u.username = ?');
 
         self::assertEquals('SELECT u.*, p.* FROM users u GROUP BY u.id HAVING (u.name = ?) OR (u.username = ?)', (string) $qb);
     }
@@ -285,10 +285,10 @@ 
         $expr = $qb->expr();
 
         $qb->select('u.*', 'p.*')
-           ->from('users', 'u')
-           ->groupBy('u.id')
-           ->orHaving('u.name = ?')
-           ->orHaving('u.username = ?');
+            ->from('users', 'u')
+            ->groupBy('u.id')
+            ->orHaving('u.name = ?')
+            ->orHaving('u.username = ?');
 
         self::assertEquals('SELECT u.*, p.* FROM users u GROUP BY u.id HAVING (u.name = ?) OR (u.username = ?)', (string) $qb);
     }
@@ -299,11 +299,11 @@ 
         $expr = $qb->expr();
 
         $qb->select('u.*', 'p.*')
-           ->from('users', 'u')
-           ->groupBy('u.id')
-           ->having('u.name = ?')
-           ->orHaving('u.username = ?')
-           ->andHaving('u.username = ?');
+            ->from('users', 'u')
+            ->groupBy('u.id')
+            ->having('u.name = ?')
+            ->orHaving('u.username = ?')
+            ->andHaving('u.username = ?');
 
         self::assertEquals('SELECT u.*, p.* FROM users u GROUP BY u.id HAVING ((u.name = ?) OR (u.username = ?)) AND (u.username = ?)', (string) $qb);
     }
@@ -314,8 +314,8 @@ 
         $expr = $qb->expr();
 
         $qb->select('u.*', 'p.*')
-           ->from('users', 'u')
-           ->orderBy('u.name');
+            ->from('users', 'u')
+            ->orderBy('u.name');
 
         self::assertEquals('SELECT u.*, p.* FROM users u ORDER BY u.name ASC', (string) $qb);
     }
@@ -326,9 +326,9 @@ 
         $expr = $qb->expr();
 
         $qb->select('u.*', 'p.*')
-           ->from('users', 'u')
-           ->orderBy('u.name')
-           ->addOrderBy('u.username', 'DESC');
+            ->from('users', 'u')
+            ->orderBy('u.name')
+            ->addOrderBy('u.username', 'DESC');
 
         self::assertEquals('SELECT u.*, p.* FROM users u ORDER BY u.name ASC, u.username DESC', (string) $qb);
     }
@@ -339,9 +339,9 @@ 
         $expr = $qb->expr();
 
         $qb->select('u.*', 'p.*')
-           ->from('users', 'u')
-           ->addOrderBy('u.name')
-           ->addOrderBy('u.username', 'DESC');
+            ->from('users', 'u')
+            ->addOrderBy('u.name')
+            ->addOrderBy('u.username', 'DESC');
 
         self::assertEquals('SELECT u.*, p.* FROM users u ORDER BY u.name ASC, u.username DESC', (string) $qb);
     }
@@ -361,8 +361,8 @@ 
         $expr = $qb->expr();
 
         $qb->select('u.*')
-           ->addSelect('p.*')
-           ->from('users', 'u');
+            ->addSelect('p.*')
+            ->from('users', 'u');
 
         self::assertEquals('SELECT u.*, p.* FROM users u', (string) $qb);
     }
@@ -382,9 +382,9 @@ 
         $expr = $qb->expr();
 
         $qb->select('u.*')
-           ->addSelect('p.*')
-           ->from('users', 'u')
-           ->from('phonenumbers', 'p');
+            ->addSelect('p.*')
+            ->from('users', 'u')
+            ->from('phonenumbers', 'p');
 
         self::assertEquals('SELECT u.*, p.* FROM users u, phonenumbers p', (string) $qb);
     }
@@ -393,8 +393,8 @@ 
     {
         $qb   = new QueryBuilder($this->conn);
         $qb->update('users', 'u')
-           ->set('u.foo', '?')
-           ->set('u.bar', '?');
+            ->set('u.foo', '?')
+            ->set('u.bar', '?');
 
         self::assertEquals(QueryBuilder::UPDATE, $qb->getType());
         self::assertEquals('UPDATE users u SET u.foo = ?, u.bar = ?', (string) $qb);
@@ -404,8 +404,8 @@ 
     {
         $qb   = new QueryBuilder($this->conn);
         $qb->update('users')
-           ->set('foo', '?')
-           ->set('bar', '?');
+            ->set('foo', '?')
+            ->set('bar', '?');
 
         self::assertEquals('UPDATE users SET foo = ?, bar = ?', (string) $qb);
     }
@@ -414,8 +414,8 @@ 
     {
         $qb   = new QueryBuilder($this->conn);
         $qb->update('users', 'u')
-           ->set('u.foo', '?')
-           ->where('u.foo = ?');
+            ->set('u.foo', '?')
+            ->where('u.foo = ?');
 
         self::assertEquals('UPDATE users u SET u.foo = ? WHERE u.foo = ?', (string) $qb);
     }
@@ -451,7 +451,7 @@ 
     {
         $qb   = new QueryBuilder($this->conn);
         $qb->delete('users', 'u')
-           ->where('u.foo = ?');
+            ->where('u.foo = ?');
 
         self::assertEquals('DELETE FROM users u WHERE u.foo = ?', (string) $qb);
     }

Spacing +19 added lines, -19 removed lines

@@ -348,7 +348,7 @@ 
 
     public function testEmptySelect()
     {
-        $qb   = new QueryBuilder($this->conn);
+        $qb = new QueryBuilder($this->conn);
         $qb2 = $qb->select();
 
         self::assertSame($qb, $qb2);
@@ -369,7 +369,7 @@ 
 
     public function testEmptyAddSelect()
     {
-        $qb   = new QueryBuilder($this->conn);
+        $qb = new QueryBuilder($this->conn);
         $qb2 = $qb->addSelect();
 
         self::assertSame($qb, $qb2);
@@ -391,7 +391,7 @@ 
 
     public function testUpdate()
     {
-        $qb   = new QueryBuilder($this->conn);
+        $qb = new QueryBuilder($this->conn);
         $qb->update('users', 'u')
            ->set('u.foo', '?')
            ->set('u.bar', '?');
@@ -402,7 +402,7 @@ 
 
     public function testUpdateWithoutAlias()
     {
-        $qb   = new QueryBuilder($this->conn);
+        $qb = new QueryBuilder($this->conn);
         $qb->update('users')
            ->set('foo', '?')
            ->set('bar', '?');
@@ -412,7 +412,7 @@ 
 
     public function testUpdateWhere()
     {
-        $qb   = new QueryBuilder($this->conn);
+        $qb = new QueryBuilder($this->conn);
         $qb->update('users', 'u')
            ->set('u.foo', '?')
            ->where('u.foo = ?');
@@ -422,7 +422,7 @@ 
 
     public function testEmptyUpdate()
     {
-        $qb   = new QueryBuilder($this->conn);
+        $qb = new QueryBuilder($this->conn);
         $qb2 = $qb->update();
 
         self::assertEquals(QueryBuilder::UPDATE, $qb->getType());
@@ -431,7 +431,7 @@ 
 
     public function testDelete()
     {
-        $qb   = new QueryBuilder($this->conn);
+        $qb = new QueryBuilder($this->conn);
         $qb->delete('users', 'u');
 
         self::assertEquals(QueryBuilder::DELETE, $qb->getType());
@@ -440,7 +440,7 @@ 
 
     public function testDeleteWithoutAlias()
     {
-        $qb   = new QueryBuilder($this->conn);
+        $qb = new QueryBuilder($this->conn);
         $qb->delete('users');
 
         self::assertEquals(QueryBuilder::DELETE, $qb->getType());
@@ -449,7 +449,7 @@ 
 
     public function testDeleteWhere()
     {
-        $qb   = new QueryBuilder($this->conn);
+        $qb = new QueryBuilder($this->conn);
         $qb->delete('users', 'u')
            ->where('u.foo = ?');
 
@@ -458,7 +458,7 @@ 
 
     public function testEmptyDelete()
     {
-        $qb   = new QueryBuilder($this->conn);
+        $qb = new QueryBuilder($this->conn);
         $qb2 = $qb->delete();
 
         self::assertEquals(QueryBuilder::DELETE, $qb->getType());
@@ -539,13 +539,13 @@ 
 
     public function testGetConnection()
     {
-        $qb   = new QueryBuilder($this->conn);
+        $qb = new QueryBuilder($this->conn);
         self::assertSame($this->conn, $qb->getConnection());
     }
 
     public function testGetState()
     {
-        $qb   = new QueryBuilder($this->conn);
+        $qb = new QueryBuilder($this->conn);
 
         self::assertEquals(QueryBuilder::STATE_CLEAN, $qb->getState());
 
@@ -561,7 +561,7 @@ 
 
     public function testSetMaxResults()
     {
-        $qb   = new QueryBuilder($this->conn);
+        $qb = new QueryBuilder($this->conn);
         $qb->setMaxResults(10);
 
         self::assertEquals(QueryBuilder::STATE_DIRTY, $qb->getState());
@@ -570,7 +570,7 @@ 
 
     public function testSetFirstResult()
     {
-        $qb   = new QueryBuilder($this->conn);
+        $qb = new QueryBuilder($this->conn);
         $qb->setFirstResult(10);
 
         self::assertEquals(QueryBuilder::STATE_DIRTY, $qb->getState());
@@ -579,7 +579,7 @@ 
 
     public function testResetQueryPart()
     {
-        $qb   = new QueryBuilder($this->conn);
+        $qb = new QueryBuilder($this->conn);
 
         $qb->select('u.*')->from('users', 'u')->where('u.name = ?');
 
@@ -590,7 +590,7 @@ 
 
     public function testResetQueryParts()
     {
-        $qb   = new QueryBuilder($this->conn);
+        $qb = new QueryBuilder($this->conn);
 
         $qb->select('u.*')->from('users', 'u')->where('u.name = ?')->orderBy('u.name');
 
@@ -601,7 +601,7 @@ 
 
     public function testCreateNamedParameter()
     {
-        $qb   = new QueryBuilder($this->conn);
+        $qb = new QueryBuilder($this->conn);
 
         $qb->select('u.*')->from('users', 'u')->where(
             $qb->expr()->eq('u.name', $qb->createNamedParameter(10, ParameterType::INTEGER))
@@ -614,7 +614,7 @@ 
 
     public function testCreateNamedParameterCustomPlaceholder()
     {
-        $qb   = new QueryBuilder($this->conn);
+        $qb = new QueryBuilder($this->conn);
 
         $qb->select('u.*')->from('users', 'u')->where(
             $qb->expr()->eq('u.name', $qb->createNamedParameter(10, ParameterType::INTEGER, ':test'))
@@ -627,7 +627,7 @@ 
 
     public function testCreatePositionalParameter()
     {
-        $qb   = new QueryBuilder($this->conn);
+        $qb = new QueryBuilder($this->conn);
 
         $qb->select('u.*')->from('users', 'u')->where(
             $qb->expr()->eq('u.name', $qb->createPositionalParameter(10, ParameterType::INTEGER))

tests/Doctrine/Tests/DBAL/Query/Expression/ExpressionBuilderTest.php

Indentation +2 added lines, -2 removed lines

@@ -22,8 +22,8 @@
         $this->expr = new ExpressionBuilder($conn);
 
         $conn->expects($this->any())
-             ->method('getExpressionBuilder')
-             ->will($this->returnValue($this->expr));
+                ->method('getExpressionBuilder')
+                ->will($this->returnValue($this->expr));
     }
 
     /**

Spacing +2 added lines, -2 removed lines

@@ -202,7 +202,7 @@ 
 
     public function testIn()
     {
-        self::assertEquals('u.groups IN (1, 3, 4, 7)', $this->expr->in('u.groups', array(1,3,4,7)));
+        self::assertEquals('u.groups IN (1, 3, 4, 7)', $this->expr->in('u.groups', array(1, 3, 4, 7)));
     }
 
     public function testInWithPlaceholder()
@@ -212,7 +212,7 @@ 
 
     public function testNotIn()
     {
-        self::assertEquals('u.groups NOT IN (1, 3, 4, 7)', $this->expr->notIn('u.groups', array(1,3,4,7)));
+        self::assertEquals('u.groups NOT IN (1, 3, 4, 7)', $this->expr->notIn('u.groups', array(1, 3, 4, 7)));
     }
 
     public function testNotInWithPlaceholder()

tests/Doctrine/Tests/DBAL/Platforms/PostgreSQL100PlatformTest.php

Spacing +1 added lines, -1 removed lines

@@ -1,6 +1,6 @@
 <?php
 
-declare(strict_types=1);
+declare(strict_types = 1);
 
 namespace Doctrine\Tests\DBAL\Platforms;
 

tests/Doctrine/Tests/DBAL/Platforms/SQLServer2012PlatformTest.php

Spacing +7 added lines, -7 removed lines

@@ -125,17 +125,17 @@
     public function testModifyLimitQueryWithExtraLongQuery()
     {
         $query = 'SELECT table1.column1, table2.column2, table3.column3, table4.column4, table5.column5, table6.column6, table7.column7, table8.column8 FROM table1, table2, table3, table4, table5, table6, table7, table8 ';
-        $query.= 'WHERE (table1.column1 = table2.column2) AND (table1.column1 = table3.column3) AND (table1.column1 = table4.column4) AND (table1.column1 = table5.column5) AND (table1.column1 = table6.column6) AND (table1.column1 = table7.column7) AND (table1.column1 = table8.column8) AND (table2.column2 = table3.column3) AND (table2.column2 = table4.column4) AND (table2.column2 = table5.column5) AND (table2.column2 = table6.column6) ';
-        $query.= 'AND (table2.column2 = table7.column7) AND (table2.column2 = table8.column8) AND (table3.column3 = table4.column4) AND (table3.column3 = table5.column5) AND (table3.column3 = table6.column6) AND (table3.column3 = table7.column7) AND (table3.column3 = table8.column8) AND (table4.column4 = table5.column5) AND (table4.column4 = table6.column6) AND (table4.column4 = table7.column7) AND (table4.column4 = table8.column8) ';
-        $query.= 'AND (table5.column5 = table6.column6) AND (table5.column5 = table7.column7) AND (table5.column5 = table8.column8) AND (table6.column6 = table7.column7) AND (table6.column6 = table8.column8) AND (table7.column7 = table8.column8)';
+        $query .= 'WHERE (table1.column1 = table2.column2) AND (table1.column1 = table3.column3) AND (table1.column1 = table4.column4) AND (table1.column1 = table5.column5) AND (table1.column1 = table6.column6) AND (table1.column1 = table7.column7) AND (table1.column1 = table8.column8) AND (table2.column2 = table3.column3) AND (table2.column2 = table4.column4) AND (table2.column2 = table5.column5) AND (table2.column2 = table6.column6) ';
+        $query .= 'AND (table2.column2 = table7.column7) AND (table2.column2 = table8.column8) AND (table3.column3 = table4.column4) AND (table3.column3 = table5.column5) AND (table3.column3 = table6.column6) AND (table3.column3 = table7.column7) AND (table3.column3 = table8.column8) AND (table4.column4 = table5.column5) AND (table4.column4 = table6.column6) AND (table4.column4 = table7.column7) AND (table4.column4 = table8.column8) ';
+        $query .= 'AND (table5.column5 = table6.column6) AND (table5.column5 = table7.column7) AND (table5.column5 = table8.column8) AND (table6.column6 = table7.column7) AND (table6.column6 = table8.column8) AND (table7.column7 = table8.column8)';
 
         $sql = $this->_platform->modifyLimitQuery($query, 10);
 
         $expected = 'SELECT table1.column1, table2.column2, table3.column3, table4.column4, table5.column5, table6.column6, table7.column7, table8.column8 FROM table1, table2, table3, table4, table5, table6, table7, table8 ';
-        $expected.= 'WHERE (table1.column1 = table2.column2) AND (table1.column1 = table3.column3) AND (table1.column1 = table4.column4) AND (table1.column1 = table5.column5) AND (table1.column1 = table6.column6) AND (table1.column1 = table7.column7) AND (table1.column1 = table8.column8) AND (table2.column2 = table3.column3) AND (table2.column2 = table4.column4) AND (table2.column2 = table5.column5) AND (table2.column2 = table6.column6) ';
-        $expected.= 'AND (table2.column2 = table7.column7) AND (table2.column2 = table8.column8) AND (table3.column3 = table4.column4) AND (table3.column3 = table5.column5) AND (table3.column3 = table6.column6) AND (table3.column3 = table7.column7) AND (table3.column3 = table8.column8) AND (table4.column4 = table5.column5) AND (table4.column4 = table6.column6) AND (table4.column4 = table7.column7) AND (table4.column4 = table8.column8) ';
-        $expected.= 'AND (table5.column5 = table6.column6) AND (table5.column5 = table7.column7) AND (table5.column5 = table8.column8) AND (table6.column6 = table7.column7) AND (table6.column6 = table8.column8) AND (table7.column7 = table8.column8) ';
-        $expected.= 'ORDER BY (SELECT 0) OFFSET 0 ROWS FETCH NEXT 10 ROWS ONLY';
+        $expected .= 'WHERE (table1.column1 = table2.column2) AND (table1.column1 = table3.column3) AND (table1.column1 = table4.column4) AND (table1.column1 = table5.column5) AND (table1.column1 = table6.column6) AND (table1.column1 = table7.column7) AND (table1.column1 = table8.column8) AND (table2.column2 = table3.column3) AND (table2.column2 = table4.column4) AND (table2.column2 = table5.column5) AND (table2.column2 = table6.column6) ';
+        $expected .= 'AND (table2.column2 = table7.column7) AND (table2.column2 = table8.column8) AND (table3.column3 = table4.column4) AND (table3.column3 = table5.column5) AND (table3.column3 = table6.column6) AND (table3.column3 = table7.column7) AND (table3.column3 = table8.column8) AND (table4.column4 = table5.column5) AND (table4.column4 = table6.column6) AND (table4.column4 = table7.column7) AND (table4.column4 = table8.column8) ';
+        $expected .= 'AND (table5.column5 = table6.column6) AND (table5.column5 = table7.column7) AND (table5.column5 = table8.column8) AND (table6.column6 = table7.column7) AND (table6.column6 = table8.column8) AND (table7.column7 = table8.column8) ';
+        $expected .= 'ORDER BY (SELECT 0) OFFSET 0 ROWS FETCH NEXT 10 ROWS ONLY';
 
 
         self::assertEquals($expected, $sql);

tests/Doctrine/Tests/DBAL/Platforms/AbstractSQLServerPlatformTestCase.php

Spacing +6 added lines, -6 removed lines

@@ -292,14 +292,14 @@
     public function testModifyLimitQueryWithExtraLongQuery()
     {
         $query = 'SELECT table1.column1, table2.column2, table3.column3, table4.column4, table5.column5, table6.column6, table7.column7, table8.column8 FROM table1, table2, table3, table4, table5, table6, table7, table8 ';
-        $query.= 'WHERE (table1.column1 = table2.column2) AND (table1.column1 = table3.column3) AND (table1.column1 = table4.column4) AND (table1.column1 = table5.column5) AND (table1.column1 = table6.column6) AND (table1.column1 = table7.column7) AND (table1.column1 = table8.column8) AND (table2.column2 = table3.column3) AND (table2.column2 = table4.column4) AND (table2.column2 = table5.column5) AND (table2.column2 = table6.column6) ';
-        $query.= 'AND (table2.column2 = table7.column7) AND (table2.column2 = table8.column8) AND (table3.column3 = table4.column4) AND (table3.column3 = table5.column5) AND (table3.column3 = table6.column6) AND (table3.column3 = table7.column7) AND (table3.column3 = table8.column8) AND (table4.column4 = table5.column5) AND (table4.column4 = table6.column6) AND (table4.column4 = table7.column7) AND (table4.column4 = table8.column8) ';
-        $query.= 'AND (table5.column5 = table6.column6) AND (table5.column5 = table7.column7) AND (table5.column5 = table8.column8) AND (table6.column6 = table7.column7) AND (table6.column6 = table8.column8) AND (table7.column7 = table8.column8)';
+        $query .= 'WHERE (table1.column1 = table2.column2) AND (table1.column1 = table3.column3) AND (table1.column1 = table4.column4) AND (table1.column1 = table5.column5) AND (table1.column1 = table6.column6) AND (table1.column1 = table7.column7) AND (table1.column1 = table8.column8) AND (table2.column2 = table3.column3) AND (table2.column2 = table4.column4) AND (table2.column2 = table5.column5) AND (table2.column2 = table6.column6) ';
+        $query .= 'AND (table2.column2 = table7.column7) AND (table2.column2 = table8.column8) AND (table3.column3 = table4.column4) AND (table3.column3 = table5.column5) AND (table3.column3 = table6.column6) AND (table3.column3 = table7.column7) AND (table3.column3 = table8.column8) AND (table4.column4 = table5.column5) AND (table4.column4 = table6.column6) AND (table4.column4 = table7.column7) AND (table4.column4 = table8.column8) ';
+        $query .= 'AND (table5.column5 = table6.column6) AND (table5.column5 = table7.column7) AND (table5.column5 = table8.column8) AND (table6.column6 = table7.column7) AND (table6.column6 = table8.column8) AND (table7.column7 = table8.column8)';
 
         $alteredSql = 'SELECT TOP 10 table1.column1, table2.column2, table3.column3, table4.column4, table5.column5, table6.column6, table7.column7, table8.column8 FROM table1, table2, table3, table4, table5, table6, table7, table8 ';
-        $alteredSql.= 'WHERE (table1.column1 = table2.column2) AND (table1.column1 = table3.column3) AND (table1.column1 = table4.column4) AND (table1.column1 = table5.column5) AND (table1.column1 = table6.column6) AND (table1.column1 = table7.column7) AND (table1.column1 = table8.column8) AND (table2.column2 = table3.column3) AND (table2.column2 = table4.column4) AND (table2.column2 = table5.column5) AND (table2.column2 = table6.column6) ';
-        $alteredSql.= 'AND (table2.column2 = table7.column7) AND (table2.column2 = table8.column8) AND (table3.column3 = table4.column4) AND (table3.column3 = table5.column5) AND (table3.column3 = table6.column6) AND (table3.column3 = table7.column7) AND (table3.column3 = table8.column8) AND (table4.column4 = table5.column5) AND (table4.column4 = table6.column6) AND (table4.column4 = table7.column7) AND (table4.column4 = table8.column8) ';
-        $alteredSql.= 'AND (table5.column5 = table6.column6) AND (table5.column5 = table7.column7) AND (table5.column5 = table8.column8) AND (table6.column6 = table7.column7) AND (table6.column6 = table8.column8) AND (table7.column7 = table8.column8)';
+        $alteredSql .= 'WHERE (table1.column1 = table2.column2) AND (table1.column1 = table3.column3) AND (table1.column1 = table4.column4) AND (table1.column1 = table5.column5) AND (table1.column1 = table6.column6) AND (table1.column1 = table7.column7) AND (table1.column1 = table8.column8) AND (table2.column2 = table3.column3) AND (table2.column2 = table4.column4) AND (table2.column2 = table5.column5) AND (table2.column2 = table6.column6) ';
+        $alteredSql .= 'AND (table2.column2 = table7.column7) AND (table2.column2 = table8.column8) AND (table3.column3 = table4.column4) AND (table3.column3 = table5.column5) AND (table3.column3 = table6.column6) AND (table3.column3 = table7.column7) AND (table3.column3 = table8.column8) AND (table4.column4 = table5.column5) AND (table4.column4 = table6.column6) AND (table4.column4 = table7.column7) AND (table4.column4 = table8.column8) ';
+        $alteredSql .= 'AND (table5.column5 = table6.column6) AND (table5.column5 = table7.column7) AND (table5.column5 = table8.column8) AND (table6.column6 = table7.column7) AND (table6.column6 = table8.column8) AND (table7.column7 = table8.column8)';
 
         $sql = $this->_platform->modifyLimitQuery($query, 10);
         $this->expectCteWithMaxRowNum($alteredSql, 10, $sql);

tests/Doctrine/Tests/DBAL/Platforms/AbstractPlatformTestCase.php

Spacing +18 added lines, -18 removed lines

@@ -43,8 +43,8 @@ 
         }
 
         $c = $this->_platform->getIdentifierQuoteCharacter();
-        self::assertEquals($c."test".$c, $this->_platform->quoteIdentifier("test"));
-        self::assertEquals($c."test".$c.".".$c."test".$c, $this->_platform->quoteIdentifier("test.test"));
+        self::assertEquals($c . "test" . $c, $this->_platform->quoteIdentifier("test"));
+        self::assertEquals($c . "test" . $c . "." . $c . "test" . $c, $this->_platform->quoteIdentifier("test.test"));
         self::assertEquals(str_repeat($c, 4), $this->_platform->quoteIdentifier($c));
     }
 
@@ -58,8 +58,8 @@ 
         }
 
         $c = $this->_platform->getIdentifierQuoteCharacter();
-        self::assertEquals($c."test".$c, $this->_platform->quoteSingleIdentifier("test"));
-        self::assertEquals($c."test.test".$c, $this->_platform->quoteSingleIdentifier("test.test"));
+        self::assertEquals($c . "test" . $c, $this->_platform->quoteSingleIdentifier("test"));
+        self::assertEquals($c . "test.test" . $c, $this->_platform->quoteSingleIdentifier("test.test"));
         self::assertEquals(str_repeat($c, 4), $this->_platform->quoteSingleIdentifier($c));
     }
 
@@ -117,7 +117,7 @@ 
      */
     public function testRegistersCommentedDoctrineMappingTypeImplicitly()
     {
-        if (!Type::hasType('my_commented')) {
+        if ( ! Type::hasType('my_commented')) {
             Type::addType('my_commented', CommentedType::class);
         }
 
@@ -222,11 +222,11 @@ 
         $actuals = array();
 
         if ($this->supportsInlineIndexDeclaration()) {
-            $actuals []= $this->_platform->getIndexDeclarationSQL('name', $indexDef);
+            $actuals [] = $this->_platform->getIndexDeclarationSQL('name', $indexDef);
         }
 
-        $actuals []= $this->_platform->getUniqueConstraintDeclarationSQL('name', $uniqueIndex);
-        $actuals []= $this->_platform->getCreateIndexSQL($indexDef, 'table');
+        $actuals [] = $this->_platform->getUniqueConstraintDeclarationSQL('name', $uniqueIndex);
+        $actuals [] = $this->_platform->getCreateIndexSQL($indexDef, 'table');
 
         foreach ($actuals as $actual) {
             if ($this->_platform->supportsPartialIndexes()) {
@@ -558,7 +558,7 @@ 
 
     public function testGetDefaultValueDeclarationSQLForIntegerTypes()
     {
-        foreach(array('bigint', 'integer', 'smallint') as $type) {
+        foreach (array('bigint', 'integer', 'smallint') as $type) {
             $field = array(
                 'type'    => Type::getType($type),
                 'default' => 1
@@ -654,24 +654,24 @@ 
 
         // Foreign table with reserved keyword as name (needs quotation).
         $foreignTable = new Table('foreign');
-        $foreignTable->addColumn('create', 'string');    // Foreign column with reserved keyword as name (needs quotation).
-        $foreignTable->addColumn('bar', 'string');       // Foreign column with non-reserved keyword as name (does not need quotation).
+        $foreignTable->addColumn('create', 'string'); // Foreign column with reserved keyword as name (needs quotation).
+        $foreignTable->addColumn('bar', 'string'); // Foreign column with non-reserved keyword as name (does not need quotation).
         $foreignTable->addColumn('`foo-bar`', 'string'); // Foreign table with special character in name (needs quotation on some platforms, e.g. Sqlite).
 
         $table->addForeignKeyConstraint($foreignTable, array('create', 'foo', '`bar`'), array('create', 'bar', '`foo-bar`'), array(), 'FK_WITH_RESERVED_KEYWORD');
 
         // Foreign table with non-reserved keyword as name (does not need quotation).
         $foreignTable = new Table('foo');
-        $foreignTable->addColumn('create', 'string');    // Foreign column with reserved keyword as name (needs quotation).
-        $foreignTable->addColumn('bar', 'string');       // Foreign column with non-reserved keyword as name (does not need quotation).
+        $foreignTable->addColumn('create', 'string'); // Foreign column with reserved keyword as name (needs quotation).
+        $foreignTable->addColumn('bar', 'string'); // Foreign column with non-reserved keyword as name (does not need quotation).
         $foreignTable->addColumn('`foo-bar`', 'string'); // Foreign table with special character in name (needs quotation on some platforms, e.g. Sqlite).
 
         $table->addForeignKeyConstraint($foreignTable, array('create', 'foo', '`bar`'), array('create', 'bar', '`foo-bar`'), array(), 'FK_WITH_NON_RESERVED_KEYWORD');
 
         // Foreign table with special character in name (needs quotation on some platforms, e.g. Sqlite).
         $foreignTable = new Table('`foo-bar`');
-        $foreignTable->addColumn('create', 'string');    // Foreign column with reserved keyword as name (needs quotation).
-        $foreignTable->addColumn('bar', 'string');       // Foreign column with non-reserved keyword as name (does not need quotation).
+        $foreignTable->addColumn('create', 'string'); // Foreign column with reserved keyword as name (needs quotation).
+        $foreignTable->addColumn('bar', 'string'); // Foreign column with non-reserved keyword as name (does not need quotation).
         $foreignTable->addColumn('`foo-bar`', 'string'); // Foreign table with special character in name (needs quotation on some platforms, e.g. Sqlite).
 
         $table->addForeignKeyConstraint($foreignTable, array('create', 'foo', '`bar`'), array('create', 'bar', '`foo-bar`'), array(), 'FK_WITH_INTENDED_QUOTATION');
@@ -721,7 +721,7 @@ 
     {
         $index = new Index('select', array('foo'));
 
-        if (! $this->supportsInlineIndexDeclaration()) {
+        if ( ! $this->supportsInlineIndexDeclaration()) {
             $this->expectException('Doctrine\DBAL\DBALException');
         }
 
@@ -1078,7 +1078,7 @@ 
      */
     public function testQuotesDropForeignKeySQL()
     {
-        if (! $this->_platform->supportsForeignKeyConstraints()) {
+        if ( ! $this->_platform->supportsForeignKeyConstraints()) {
             $this->markTestSkipped(
                 sprintf('%s does not support foreign key constraints.', get_class($this->_platform))
             );
@@ -1186,7 +1186,7 @@ 
      */
     public function testGeneratesInlineColumnCommentSQL($comment, $expectedSql)
     {
-        if (! $this->_platform->supportsInlineColumnComments()) {
+        if ( ! $this->_platform->supportsInlineColumnComments()) {
             $this->markTestSkipped(sprintf('%s does not support inline column comments.', get_class($this->_platform)));
         }
 

tests/Doctrine/Tests/DBAL/Platforms/AbstractPostgreSqlPlatformTestCase.php

Spacing +1 added lines, -1 removed lines

@@ -672,7 +672,7 @@
             array(false, 'false', 0, false),
             array('f', 'false', 0, false),
             array('false', 'false', 0, false),
-            array( 'n', 'false', 0, false),
+            array('n', 'false', 0, false),
             array('no', 'false', 0, false),
             array('off', 'false', 0, false),
             array('0', 'false', 0, false),

tests/Doctrine/Tests/DBAL/Platforms/OraclePlatformTest.php

Spacing +5 added lines, -5 removed lines

@@ -311,11 +311,11 @@ 
         );
         $statements = $this->_platform->getCreateTableSQL($table);
         //strip all the whitespace from the statements
-        array_walk($statements, function(&$value){
-            $value = preg_replace('/\s+/', ' ',$value);
+        array_walk($statements, function(&$value) {
+            $value = preg_replace('/\s+/', ' ', $value);
         });
-        foreach($targets as $key => $sql){
-            self::assertArrayHasKey($key,$statements);
+        foreach ($targets as $key => $sql) {
+            self::assertArrayHasKey($key, $statements);
             self::assertEquals($sql, $statements[$key]);
         }
     }
@@ -348,7 +348,7 @@ 
 
     public function getBitAndComparisonExpressionSql($value1, $value2)
     {
-        return 'BITAND('.$value1 . ', ' . $value2 . ')';
+        return 'BITAND(' . $value1 . ', ' . $value2 . ')';
     }
 
     public function getBitOrComparisonExpressionSql($value1, $value2)