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

vjik · web-flow · commit 5ff070402476 · 2025-08-07T19:40:00.000+03:00
diff --git a/src/Builder/InBuilder.php b/src/Builder/InBuilder.php
@@ -10,21 +10,22 @@
 use Yiisoft\Db\Exception\NotSupportedException;
 use Yiisoft\Db\Expression\ExpressionInterface;
 use Yiisoft\Db\QueryBuilder\Condition\In;
+use Yiisoft\Db\QueryBuilder\Condition\NotIn;
 
 use function array_slice;
 use function array_unshift;
 use function count;
 use function is_array;
 
 /**
- * Build an object of {@see In} into SQL expressions for Oracle Server.
+ * Build an object of {@see In} or {@see NotIn} into SQL expressions for Oracle Server.
  */
 final class InBuilder extends \Yiisoft\Db\QueryBuilder\Condition\Builder\InBuilder
 {
     /**
      * The Method builds the raw SQL from the $expression that won't be additionally escaped or quoted.
      *
-     * @param In $expression The expression to build.
+     * @param In|NotIn $expression The expression to build.
      * @param array $params The binding parameters.
      *
      * @throws Exception
@@ -55,9 +56,12 @@ public function build(ExpressionInterface $expression, array &$params = []): str
      *
      * @return string|null `null` when split isn't required. Otherwise - built SQL condition.
      */
-    protected function splitCondition(In $condition, array &$params): string|null
+    protected function splitCondition(In|NotIn $condition, array &$params): string|null
     {
-        $operator = $condition->operator;
+        $operator = match ($condition::class) {
+            In::class => 'IN',
+            NotIn::class => 'NOT IN',
+        };
         $values = $condition->values;
         $column = $condition->column;
 
diff --git a/src/DQLQueryBuilder.php b/src/DQLQueryBuilder.php
@@ -11,6 +11,7 @@
 use Yiisoft\Db\QueryBuilder\AbstractDQLQueryBuilder;
 use Yiisoft\Db\QueryBuilder\Condition\In;
 use Yiisoft\Db\QueryBuilder\Condition\Like;
+use Yiisoft\Db\QueryBuilder\Condition\NotIn;
 
 use function implode;
 
@@ -84,6 +85,7 @@ protected function defaultExpressionBuilders(): array
         return [
             ...parent::defaultExpressionBuilders(),
             In::class => InBuilder::class,
+            NotIn::class => InBuilder::class,
             Like::class => LikeBuilder::class,
         ];
     }
