yiisoft / db

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);
                 },
             ],