Adapt to split In condition in Yii DB (#379)

vjik · web-flow · commit 18c4c9347206 · 2025-08-07T19:39:02.000+03:00
diff --git a/src/DQLQueryBuilder.php b/src/DQLQueryBuilder.php
@@ -12,6 +12,7 @@
 use Yiisoft\Db\QueryBuilder\Condition\In;
 use Yiisoft\Db\QueryBuilder\Condition\Like;
 use Yiisoft\Db\QueryBuilder\Condition\JsonOverlaps;
+use Yiisoft\Db\QueryBuilder\Condition\NotIn;
 use Yiisoft\Db\Sqlite\Builder\InBuilder;
 use Yiisoft\Db\Sqlite\Builder\JsonOverlapsBuilder;
 use Yiisoft\Db\Sqlite\Builder\LikeBuilder;
@@ -138,6 +139,7 @@ protected function defaultExpressionBuilders(): array
             JsonOverlaps::class => JsonOverlapsBuilder::class,
             Like::class => LikeBuilder::class,
             In::class => InBuilder::class,
+            NotIn::class => InBuilder::class,
         ];
     }
 }
diff --git a/tests/Builder/InBuilderTest.php b/tests/Builder/InBuilderTest.php
@@ -23,7 +23,6 @@ public function testBuildSubqueryInCondition(): void
         $db = $this->getConnection();
         $inCondition = new In(
             ['id'],
-            'in',
             (new Query($db))->select('id')->from('users')->where(['active' => 1]),
         );
 
diff --git a/tests/Provider/QueryBuilderProvider.php b/tests/Provider/QueryBuilderProvider.php
@@ -73,17 +73,17 @@ public static function buildCondition(): array
                 [':qp0' => 1, ':qp1' => 'foo', ':qp2' => 2, ':qp3' => 'bar'],
             ],
             'inCondition-custom-3' => [
-                new In(['id', 'name'], 'in', [['id' => 1]]),
+                new In(['id', 'name'], [['id' => 1]]),
                 '(([[id]] = :qp0 AND [[name]] IS NULL))',
                 [':qp0' => 1],
             ],
             'inCondition-custom-4' => [
-                new In(['id', 'name'], 'in', [['name' => 'oy']]),
+                new In(['id', 'name'], [['name' => 'oy']]),
                 '(([[id]] IS NULL AND [[name]] = :qp0))',
                 [':qp0' => 'oy'],
             ],
             'inCondition-custom-5' => [
-                new In(['id', 'name'], 'in', [['id' => 1, 'name' => 'oy']]),
+                new In(['id', 'name'], [['id' => 1, 'name' => 'oy']]),
                 '(([[id]] = :qp0 AND [[name]] = :qp1))',
                 [':qp0' => 1, ':qp1' => 'oy'],
             ],
