doctrine / orm

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

    }

    public function testAddCriteriaWhere()

    {

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

        $qb->select('u')

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

        $criteria = new Criteria();

        $criteria->where($criteria->expr()->eq('field', 'value'));

        $qb->addCriteria($criteria);

        $this->assertEquals('u.field = :field', (string) $qb->getDQLPart('where'));

        $this->assertNotNull($qb->getParameter('field'));

    }

    public function testAddMultipleSameCriteriaWhere()

    {

        $this->assertEquals('a.field DESC', (string) $orderBy[0]);

    }

    public function testAddCriteriaLimit()

    {

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

        $qb->select('u')

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

        $criteria = new Criteria();

        $criteria->setFirstResult(2);

        $criteria->setMaxResults(10);

        $qb->addCriteria($criteria);

        $this->assertEquals(2, $qb->getFirstResult());

        $this->assertEquals(10, $qb->getMaxResults());

    }

    public function testAddCriteriaUndefinedLimit()

    {

        $this->assertEquals(10, $qb->getMaxResults());

    }

    public function testAddCriteriaUndefinedLimit()

    {

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

        $qb->select('u')

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

            ->setFirstResult(2)

            ->setMaxResults(10);

        $criteria = new Criteria();

        $qb->addCriteria($criteria);

        $this->assertEquals(2, $qb->getFirstResult());

        $this->assertEquals(10, $qb->getMaxResults());

    }

    public function testGetQuery()

    {