doctrine / orm

        $this->assertValidQueryBuilder($qb, 'SELECT u FROM Doctrine\Tests\Models\CMS\CmsUser u ORDER BY u.username ASC');

    }

    public function testOrderByWithExpression()

    {

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

        $qb->select('u')

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

            ->orderBy($qb->expr()->asc('u.username'));

        $this->assertValidQueryBuilder($qb, 'SELECT u FROM Doctrine\Tests\Models\CMS\CmsUser u ORDER BY u.username ASC');

    }

    public function testAddOrderBy()

    {

        $this->assertValidQueryBuilder($qb, 'SELECT u FROM Doctrine\Tests\Models\CMS\CmsUser u ORDER BY u.username ASC, u.username DESC');

    }

    public function testAddOrderByWithExpression()

    {

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

        $qb->select('u')

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

            ->orderBy('u.username', 'ASC')

            ->addOrderBy($qb->expr()->desc('u.username'));

        $this->assertValidQueryBuilder($qb, 'SELECT u FROM Doctrine\Tests\Models\CMS\CmsUser u ORDER BY u.username ASC, u.username DESC');

    }

    public function testAddCriteriaWhere()

    {

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

    }

    public function testMultipleOrWhere()

    {

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

        $qb->select('u')

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

           ->orWhere('u.id = :uid', $qb->expr()->eq('u.id', ':uid2'));

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

    }

    public function testComplexWhere()

    {

        $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()

    {

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

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

        $qb->select('u')

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

           ->where($expr->gt('u.id', $expr->all('select a.id from Doctrine\Tests\Models\CMS\CmsArticle a')));

        $this->assertValidQueryBuilder($qb, 'SELECT u FROM Doctrine\Tests\Models\CMS\CmsUser u WHERE u.id > ALL(select a.id from Doctrine\Tests\Models\CMS\CmsArticle a)');

    }

    public function testMultipleIsolatedQueryConstruction()

    {