yiisoft / db

src/TestSupport/TestQueryBuilderTrait.php

Indentation +8 added lines, -8 removed lines

@@ -1136,20 +1136,20 @@
         $secondQuery = new Query($db);
 
         $secondQuery->select('id')
-              ->from('TotalTotalExample t2')
-              ->where('w > 5');
+                ->from('TotalTotalExample t2')
+                ->where('w > 5');
 
         $thirdQuery = new Query($db);
 
         $thirdQuery->select('id')
-              ->from('TotalTotalExample t3')
-              ->where('w = 3');
+                ->from('TotalTotalExample t3')
+                ->where('w = 3');
 
         $query->select('id')
-              ->from('TotalExample t1')
-              ->where(['and', 'w > 0', 'x < 2'])
-              ->union($secondQuery)
-              ->union($thirdQuery, true);
+                ->from('TotalExample t1')
+                ->where(['and', 'w > 0', 'x < 2'])
+                ->union($secondQuery)
+                ->union($thirdQuery, true);
 
         [$actualQuerySql, $queryParams] = $db->getQueryBuilder()->build($query);
 

src/Schema/ColumnSchemaBuilder.php

Spacing +2 added lines, -2 removed lines

@@ -310,8 +310,8 @@
         $string = ' DEFAULT ';
 
         $string .= match (gettype($this->default)) {
-            'object', 'integer' => (string)$this->default,
-            'double' => NumericHelper::normalize((string)$this->default),
+            'object', 'integer' => (string) $this->default,
+            'double' => NumericHelper::normalize((string) $this->default),
             'boolean' => $this->default ? 'TRUE' : 'FALSE',
             default => "'{$this->default}'",
         };

src/QueryBuilder/DQLQueryBuilder.php

Spacing +1 added lines, -1 removed lines

@@ -585,7 +585,7 @@
      */
     protected function hasOffset(mixed $offset): bool
     {
-        return ($offset instanceof ExpressionInterface) || (ctype_digit((string)$offset) && (string)$offset !== '0');
+        return ($offset instanceof ExpressionInterface) || (ctype_digit((string) $offset) && (string) $offset !== '0');
     }
 
     /**

src/Driver/PDO/CommandPDO.php

Spacing +1 added lines, -1 removed lines

@@ -142,7 +142,7 @@
 
     protected function getCacheKey(int $queryMode, string $rawSql): array
     {
-        return array_merge([static::class , $queryMode], $this->db->getCacheKey(), [$rawSql]);
+        return array_merge([static::class, $queryMode], $this->db->getCacheKey(), [$rawSql]);
     }
 
     /**

src/TestSupport/TestConnectionTrait.php

Spacing +5 added lines, -5 removed lines

@@ -202,7 +202,7 @@ 
 
         $this->expectException(Exception::class);
 
-        $db->transaction(function () use ($db) {
+        $db->transaction(function() use ($db) {
             $db->createCommand()->insert('profile', ['description' => 'test transaction shortcut'])->execute();
             throw new Exception('Exception in transaction shortcut');
         });
@@ -216,7 +216,7 @@ 
     {
         $db = $this->getConnection(true);
 
-        $result = $db->transaction(static function () use ($db) {
+        $result = $db->transaction(static function() use ($db) {
             $db->createCommand()->insert('profile', ['description' => 'test transaction shortcut'])->execute();
             return true;
         });
@@ -239,10 +239,10 @@ 
     {
         $db = $this->getConnection();
 
-        $db->transaction(function (ConnectionInterface $db) {
+        $db->transaction(function(ConnectionInterface $db) {
             $this->assertNotNull($db->getTransaction());
 
-            $db->transaction(function (ConnectionInterface $db) {
+            $db->transaction(function(ConnectionInterface $db) {
                 $transaction = $db->getTransaction();
                 $this->assertNotNull($transaction);
                 $transaction->rollBack();
@@ -258,7 +258,7 @@ 
 
         $db->setEnableSavepoint(false);
 
-        $db->transaction(function (ConnectionInterface $db) {
+        $db->transaction(function(ConnectionInterface $db) {
             $this->assertNotNull($db->getTransaction());
             $this->expectException(NotSupportedException::class);
             $db->beginTransaction();

src/TestSupport/TestCommandTrait.php

Spacing +7 added lines, -7 removed lines

@@ -217,7 +217,7 @@ 
         $row = $rows[2];
         $this->assertEquals(3, $row['id']);
         $this->assertEquals('user3', $row['name']);
-        $this->assertTrue(is_array($rows) && count($rows)>1 && count($rows[0]) === 2);
+        $this->assertTrue(is_array($rows) && count($rows) > 1 && count($rows[0]) === 2);
 
         $rows = $db->createCommand('SELECT * FROM {{customer}} WHERE [[id]] = 10')->queryAll();
         $this->assertEquals([], $rows);
@@ -258,7 +258,7 @@ 
      */
     public function testBatchInsertWithYield(): void
     {
-        $rows = (static function () {
+        $rows = (static function() {
             foreach ([['test@email.com', 'test name', 'test address']] as $row) {
                 yield $row;
             }
@@ -882,14 +882,14 @@ 
         $update->bindValues([':id' => 1, ':name' => 'user11'])->execute();
         $this->assertEquals('user11', $command->bindValue(':id', 1)->queryScalar());
 
-        $db->cache(function (ConnectionInterface $db) use ($command, $update) {
+        $db->cache(function(ConnectionInterface $db) use ($command, $update) {
             $this->assertEquals('user2', $command->bindValue(':id', 2)->queryScalar());
 
             $update->bindValues([':id' => 2, ':name' => 'user22'])->execute();
 
             $this->assertEquals('user2', $command->bindValue(':id', 2)->queryScalar());
 
-            $db->noCache(function () use ($command) {
+            $db->noCache(function() use ($command) {
                 $this->assertEquals('user22', $command->bindValue(':id', 2)->queryScalar());
             });
 
@@ -899,7 +899,7 @@ 
         /** @psalm-suppress PossiblyNullReference */
         $this->queryCache->setEnable(false);
 
-        $db->cache(function () use ($command, $update) {
+        $db->cache(function() use ($command, $update) {
             $this->assertEquals('user22', $command->bindValue(':id', 2)->queryScalar());
             $update->bindValues([':id' => 2, ':name' => 'user2'])->execute();
             $this->assertEquals('user2', $command->bindValue(':id', 2)->queryScalar());
@@ -916,7 +916,7 @@ 
 
         $command = $db->createCommand('SELECT [[name]] FROM {{customer}} WHERE [[id]] = :id');
 
-        $db->cache(function () use ($command) {
+        $db->cache(function() use ($command) {
             $this->assertEquals('user11', $command->bindValue(':id', 1)->queryScalar());
             $this->assertEquals('user1', $command->noCache()->bindValue(':id', 1)->queryScalar());
         }, 10);
@@ -990,7 +990,7 @@ 
         $this->invokeMethod(
             $command,
             'setRetryHandler',
-            [static function ($exception, $attempt) use (&$attempts, &$hitHandler) {
+            [static function($exception, $attempt) use (&$attempts, &$hitHandler) {
                 $attempts = $attempt;
                 $hitHandler = true;
 

src/TestSupport/Provider/QueryBuilderProvider.php

Spacing +16 added lines, -16 removed lines

@@ -33,14 +33,14 @@ 
         return [
             'drop' => [
                 "ALTER TABLE {{{$tableName}}} DROP CONSTRAINT [[$name]]",
-                static function (QueryBuilderInterface $qb) use ($tableName, $name) {
+                static function(QueryBuilderInterface $qb) use ($tableName, $name) {
                     return $qb->dropForeignKey($name, $tableName);
                 },
             ],
             'add' => [
                 "ALTER TABLE {{{$tableName}}} ADD CONSTRAINT [[$name]] FOREIGN KEY ([[C_fk_id_1]])"
                 . " REFERENCES {{{$pkTableName}}} ([[C_id_1]]) ON DELETE CASCADE ON UPDATE CASCADE",
-                static function (QueryBuilderInterface $qb) use ($tableName, $name, $pkTableName) {
+                static function(QueryBuilderInterface $qb) use ($tableName, $name, $pkTableName) {
                     return $qb->addForeignKey(
                         $name,
                         $tableName,
@@ -55,7 +55,7 @@ 
             'add (2 columns)' => [
                 "ALTER TABLE {{{$tableName}}} ADD CONSTRAINT [[$name]] FOREIGN KEY ([[C_fk_id_1]], [[C_fk_id_2]])"
                 . " REFERENCES {{{$pkTableName}}} ([[C_id_1]], [[C_id_2]]) ON DELETE CASCADE ON UPDATE CASCADE",
-                static function (QueryBuilderInterface $qb) use ($tableName, $name, $pkTableName) {
+                static function(QueryBuilderInterface $qb) use ($tableName, $name, $pkTableName) {
                     return $qb->addForeignKey(
                         $name,
                         $tableName,
@@ -78,19 +78,19 @@ 
         return [
             'drop' => [
                 "ALTER TABLE {{{$tableName}}} DROP CONSTRAINT [[$name]]",
-                static function (QueryBuilderInterface $qb) use ($tableName, $name) {
+                static function(QueryBuilderInterface $qb) use ($tableName, $name) {
                     return $qb->dropPrimaryKey($name, $tableName);
                 },
             ],
             'add' => [
                 "ALTER TABLE {{{$tableName}}} ADD CONSTRAINT [[$name]] PRIMARY KEY ([[C_id_1]])",
-                static function (QueryBuilderInterface $qb) use ($tableName, $name) {
+                static function(QueryBuilderInterface $qb) use ($tableName, $name) {
                     return $qb->addPrimaryKey($name, $tableName, 'C_id_1');
                 },
             ],
             'add (2 columns)' => [
                 "ALTER TABLE {{{$tableName}}} ADD CONSTRAINT [[$name]] PRIMARY KEY ([[C_id_1]], [[C_id_2]])",
-                static function (QueryBuilderInterface $qb) use ($tableName, $name) {
+                static function(QueryBuilderInterface $qb) use ($tableName, $name) {
                     return $qb->addPrimaryKey($name, $tableName, 'C_id_1, C_id_2');
                 },
             ],
@@ -107,19 +107,19 @@ 
         return [
             'drop' => [
                 "ALTER TABLE {{{$tableName1}}} DROP CONSTRAINT [[$name1]]",
-                static function (QueryBuilderInterface $qb) use ($tableName1, $name1) {
+                static function(QueryBuilderInterface $qb) use ($tableName1, $name1) {
                     return $qb->dropUnique($name1, $tableName1);
                 },
             ],
             'add' => [
                 "ALTER TABLE {{{$tableName1}}} ADD CONSTRAINT [[$name1]] UNIQUE ([[C_unique]])",
-                static function (QueryBuilderInterface $qb) use ($tableName1, $name1) {
+                static function(QueryBuilderInterface $qb) use ($tableName1, $name1) {
                     return $qb->addUnique($name1, $tableName1, 'C_unique');
                 },
             ],
             'add (2 columns)' => [
                 "ALTER TABLE {{{$tableName2}}} ADD CONSTRAINT [[$name2]] UNIQUE ([[C_index_2_1]], [[C_index_2_2]])",
-                static function (QueryBuilderInterface $qb) use ($tableName2, $name2) {
+                static function(QueryBuilderInterface $qb) use ($tableName2, $name2) {
                     return $qb->addUnique($name2, $tableName2, 'C_index_2_1, C_index_2_2');
                 },
             ],
@@ -503,7 +503,7 @@ 
                     [':qp0' => 1,
                         ':qp1' => 'foo',
                         ':qp2' => 2,
-                        ':qp3' => 'bar',],
+                        ':qp3' => 'bar', ],
                 ],
                 [
                     ['not in', ['id', 'name'], [['id' => 1, 'name' => 'foo'], ['id' => 2, 'name' => 'bar']]],
@@ -511,7 +511,7 @@ 
                     [':qp0' => 1,
                         ':qp1' => 'foo',
                         ':qp2' => 2,
-                        ':qp3' => 'bar',],
+                        ':qp3' => 'bar', ],
                 ],
                 //[['in', ['id', 'name'], (new Query())->select(['id', 'name'])->from('users')->where(['active' => 1])], 'EXISTS (SELECT 1 FROM (SELECT [[id]], [[name]] FROM [[users]] WHERE [[active]]=:qp0) AS a WHERE a.[[id]] = [[id AND a.]]name[[ = ]]name`)', [':qp0' => 1] ],
                 //[ ['not in', ['id', 'name'], (new Query())->select(['id', 'name'])->from('users')->where(['active' => 1])], 'NOT EXISTS (SELECT 1 FROM (SELECT [[id]], [[name]] FROM [[users]] WHERE [[active]]=:qp0) AS a WHERE a.[[id]] = [[id]] AND a.[[name = ]]name`)', [':qp0' => 1] ],
@@ -798,31 +798,31 @@ 
         return [
             'drop' => [
                 "DROP INDEX [[$name1]] ON {{{$tableName}}}",
-                static function (QueryBuilderInterface $qb) use ($tableName, $name1) {
+                static function(QueryBuilderInterface $qb) use ($tableName, $name1) {
                     return $qb->dropIndex($name1, $tableName);
                 },
             ],
             'create' => [
                 "CREATE INDEX [[$name1]] ON {{{$tableName}}} ([[C_index_1]])",
-                static function (QueryBuilderInterface $qb) use ($tableName, $name1) {
+                static function(QueryBuilderInterface $qb) use ($tableName, $name1) {
                     return $qb->createIndex($name1, $tableName, 'C_index_1');
                 },
             ],
             'create (2 columns)' => [
                 "CREATE INDEX [[$name2]] ON {{{$tableName}}} ([[C_index_2_1]], [[C_index_2_2]])",
-                static function (QueryBuilderInterface $qb) use ($tableName, $name2) {
+                static function(QueryBuilderInterface $qb) use ($tableName, $name2) {
                     return $qb->createIndex($name2, $tableName, 'C_index_2_1, C_index_2_2');
                 },
             ],
             'create unique' => [
                 "CREATE UNIQUE INDEX [[$name1]] ON {{{$tableName}}} ([[C_index_1]])",
-                static function (QueryBuilderInterface $qb) use ($tableName, $name1) {
+                static function(QueryBuilderInterface $qb) use ($tableName, $name1) {
                     return $qb->createIndex($name1, $tableName, 'C_index_1', QueryBuilder::INDEX_UNIQUE);
                 },
             ],
             'create unique (2 columns)' => [
                 "CREATE UNIQUE INDEX [[$name2]] ON {{{$tableName}}} ([[C_index_2_1]], [[C_index_2_2]])",
-                static function (QueryBuilderInterface $qb) use ($tableName, $name2) {
+                static function(QueryBuilderInterface $qb) use ($tableName, $name2) {
                     return $qb->createIndex($name2, $tableName, 'C_index_2_1, C_index_2_2', QueryBuilder::INDEX_UNIQUE);
                 },
             ],