doctrine / orm

        $this->assertValidQueryBuilder($qb, 'SELECT u FROM Doctrine\Tests\Models\CMS\CmsUser u WHERE u.id = :uid OR u.id = :uid2');

    }

    public function testComplexWhere()

    {

        $qb = $this->_em->createQueryBuilder();

        $orExpr = $qb->expr()->orX();

        $orExpr->add($qb->expr()->eq('u.id', ':uid3'));

        $orExpr->add($qb->expr()->in('u.id', [1]));

        $qb->select('u')

           ->from(CmsUser::class, 'u')

           ->where($orExpr);

        $this->assertValidQueryBuilder($qb, 'SELECT u FROM Doctrine\Tests\Models\CMS\CmsUser u WHERE u.id = :uid3 OR u.id IN(1)');

    }

    public function testWhereInWithStringLiterals()

    {

        $this->assertValidQueryBuilder($qb, "SELECT u FROM Doctrine\Tests\Models\CMS\CmsUser u WHERE u.name IN('O''Reilly', 'O''Neil', 'Smith')");

    }

    public function testNegation()

    {

        $expr = $this->_em->getExpressionBuilder();

        $orExpr = $expr->orX();

        $orExpr->add($expr->eq('u.id', ':uid3'));

        $orExpr->add($expr->not($expr->in('u.id', [1])));

        $qb = $this->_em->createQueryBuilder();

        $qb->select('u')

           ->from(CmsUser::class, 'u')

           ->where($orExpr);

        $this->assertValidQueryBuilder($qb, 'SELECT u FROM Doctrine\Tests\Models\CMS\CmsUser u WHERE u.id = :uid3 OR NOT(u.id IN(1))');

    }

    public function testSomeAllAny()

    {