123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108 |
- <?php
- /*
- * This file is part of the Sonata package.
- *
- * (c) Thomas Rabaix <thomas.rabaix@sonata-project.org>
- *
- * For the full copyright and license information, please view the LICENSE
- * file that was distributed with this source code.
- */
- namespace Sonata\AdminBundle\Tests\Filter\ORM;
- use Sonata\AdminBundle\Filter\ORM\ModelFilter;
- use Doctrine\ORM\Mapping\ClassMetadataInfo;
- use Sonata\AdminBundle\Form\Type\Filter\ChoiceType;
- class ModelFilterTest extends \PHPUnit_Framework_TestCase
- {
- public function getFieldDescription(array $options)
- {
- $fieldDescription = $this->getMock('Sonata\AdminBundle\Admin\FieldDescriptionInterface');
- $fieldDescription->expects($this->once())
- ->method('getOptions')
- ->will($this->returnValue($options));
- $fieldDescription->expects($this->once())
- ->method('getName')
- ->will($this->returnValue('field_name'));
- return $fieldDescription;
- }
- public function testFilterEmpty()
- {
- $filter = new ModelFilter;
- $filter->initialize('field_name', array('field_options' => array('class' => 'FooBar')));
- $builder = new QueryBuilder;
- $filter->filter($builder, 'alias', 'field', null);
- $filter->filter($builder, 'alias', 'field', array());
- $this->assertEquals(array(), $builder->query);
- }
- public function testFilterArray()
- {
- $filter = new ModelFilter;
- $filter->initialize('field_name', array('field_options' => array('class' => 'FooBar')));
- $builder = new QueryBuilder;
- $filter->filter($builder, 'alias', 'field', array('type' => ChoiceType::TYPE_CONTAINS, 'value' => array('1', '2')));
- $this->assertEquals(array('in_alias.field', 'alias.field IN ("1,2")'), $builder->query);
- }
- public function testFilterScalar()
- {
- $filter = new ModelFilter;
- $filter->initialize('field_name', array('field_options' => array('class' => 'FooBar')));
- $builder = new QueryBuilder;
- $filter->filter($builder, 'alias', 'field', array('type' => ChoiceType::TYPE_CONTAINS, 'value' => 2));
- $this->assertEquals(array('alias.field = :field_name'), $builder->query);
- $this->assertEquals(array('field_name' => 2), $builder->parameters);
- }
- /**
- * @expectedException RuntimeException
- */
- public function testAssociationWithInvalidMapping()
- {
- $filter = new ModelFilter;
- $filter->initialize('field_name', array('mapping_type' => 'foo'));
- $filter->apply(new QueryBuilder, 'asd');
- }
- /**
- * @expectedException RuntimeException
- */
- public function testAssociationWithValidMappingAndEmptyFieldName()
- {
- $filter = new ModelFilter;
- $filter->initialize('field_name', array('mapping_type' => ClassMetadataInfo::ONE_TO_ONE));
- $filter->apply(new QueryBuilder, 'asd');
- }
- public function testAssociationWithValidMapping()
- {
- $filter = new ModelFilter;
- $filter->initialize('field_name', array(
- 'mapping_type' => ClassMetadataInfo::ONE_TO_ONE,
- 'field_name' => 'field_name',
- ));
- $builder = new QueryBuilder;
- $filter->apply($builder, array('type' => ChoiceType::TYPE_CONTAINS, 'value' => 'asd'));
- $this->assertEquals(array('o.field_name', 's_field_name.id = :field_name'), $builder->query);
- }
- }
|