public function testQueryLimit() { $query = $this->dm->createQuery('SELECT * FROM [nt:unstructured] WHERE ISCHILDNODE("/functional") ORDER BY username', \PHPCR\Query\QueryInterface::JCR_SQL2); $this->assertInstanceOf('PHPCR\\Query\\QueryInterface', $query); $query->setLimit(2); $result = $this->dm->getDocumentsByQuery($query, $this->type); $this->assertCount(2, $result); $ids = array(); $vals = array(); $nums = array(); foreach ($result as $obj) { $this->assertInstanceOf('Doctrine\\Tests\\ODM\\PHPCR\\Functional\\QuerySql2TestObj', $obj); $ids[] = $obj->id; $vals[] = $obj->username; $this->assertInstanceOf('Doctrine\\Common\\Collections\\Collection', $obj->numbers); $nums[] = $obj->numbers->toArray(); } $this->assertEquals(array('/functional/node5', '/functional/node1'), $ids); $this->assertEquals(array(null, 'dbu'), $vals); $this->assertEquals(array(array(3, 1, 2), array(3, 1, 2)), $nums); }
/** * Create a new QueryBuilder instance that is prepopulated for this document name * * @return QueryBuilder $qb */ public function createQuery() { return $this->_dm->createQuery()->from($this->_documentName); }
/** * Create a new Query instance that is prepopulated for this document name * * @return Query $qb */ public function createQuery() { return $this->dm->createQuery()->find($this->documentName); }