public function testBetween()
{
$nameFieldDescriptor = new DoctrineFieldDescriptor('name', 'name_alias', self::$entityName);
$this->doctrineListBuilder->setSelectFields([$nameFieldDescriptor]);
$this->doctrineListBuilder->between($nameFieldDescriptor, [0, 1]);
$this->queryBuilder->expects($this->once())->method('andWhere')->withAnyParameters();
$this->queryBuilder->expects($this->at(1))->method('setParameter')->withAnyParameters();
$this->queryBuilder->expects($this->at(2))->method('setParameter')->withAnyParameters();
$this->doctrineListBuilder->execute();
}
public function testBetween()
{
$nameFieldDescriptor = new DoctrineFieldDescriptor('name', 'name_alias', self::$entityName);
$this->doctrineListBuilder->setFields([$nameFieldDescriptor]);
$this->doctrineListBuilder->between($nameFieldDescriptor, [0, 1]);
$this->queryBuilder->expects($this->once())->method('andWhere')->with('(SuluCoreBundle:Example.name BETWEEN :name_alias1 AND :name_alias2)');
$this->queryBuilder->expects($this->at(1))->method('setParameter')->with('name_alias1', 0);
$this->queryBuilder->expects($this->at(2))->method('setParameter')->with('name_alias2', 1);
$this->doctrineListBuilder->execute();
}
/**
* append parent selector to listbuilder.
*
* @param $parentKey
* @param DoctrineListBuilder $listBuilder
*/
protected function addParentSelector($parentKey, DoctrineListBuilder $listBuilder)
{
$manager = $this->getManager();
$parentEntity = $manager->findByKey($parentKey);
$listBuilder->between(new DoctrineFieldDescriptor('lft', 'lft', CategoryManager::$categoryEntityName, 'public.lft', [], true), [$parentEntity->getLft() + 1, $parentEntity->getRgt()]);
}
