ModelFilterTest.php 3.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108
  1. <?php
  2. /*
  3. * This file is part of the Sonata package.
  4. *
  5. * (c) Thomas Rabaix <thomas.rabaix@sonata-project.org>
  6. *
  7. * For the full copyright and license information, please view the LICENSE
  8. * file that was distributed with this source code.
  9. */
  10. namespace Sonata\AdminBundle\Tests\Filter\ORM;
  11. use Sonata\AdminBundle\Filter\ORM\ModelFilter;
  12. use Doctrine\ORM\Mapping\ClassMetadataInfo;
  13. use Sonata\AdminBundle\Form\Type\Filter\ChoiceType;
  14. class ModelFilterTest extends \PHPUnit_Framework_TestCase
  15. {
  16. public function getFieldDescription(array $options)
  17. {
  18. $fieldDescription = $this->getMock('Sonata\AdminBundle\Admin\FieldDescriptionInterface');
  19. $fieldDescription->expects($this->once())
  20. ->method('getOptions')
  21. ->will($this->returnValue($options));
  22. $fieldDescription->expects($this->once())
  23. ->method('getName')
  24. ->will($this->returnValue('field_name'));
  25. return $fieldDescription;
  26. }
  27. public function testFilterEmpty()
  28. {
  29. $filter = new ModelFilter;
  30. $filter->initialize('field_name', array('field_options' => array('class' => 'FooBar')));
  31. $builder = new QueryBuilder;
  32. $filter->filter($builder, 'alias', 'field', null);
  33. $filter->filter($builder, 'alias', 'field', array());
  34. $this->assertEquals(array(), $builder->query);
  35. }
  36. public function testFilterArray()
  37. {
  38. $filter = new ModelFilter;
  39. $filter->initialize('field_name', array('field_options' => array('class' => 'FooBar')));
  40. $builder = new QueryBuilder;
  41. $filter->filter($builder, 'alias', 'field', array('type' => ChoiceType::TYPE_CONTAINS, 'value' => array('1', '2')));
  42. $this->assertEquals(array('in_alias.field', 'alias.field IN ("1,2")'), $builder->query);
  43. }
  44. public function testFilterScalar()
  45. {
  46. $filter = new ModelFilter;
  47. $filter->initialize('field_name', array('field_options' => array('class' => 'FooBar')));
  48. $builder = new QueryBuilder;
  49. $filter->filter($builder, 'alias', 'field', array('type' => ChoiceType::TYPE_CONTAINS, 'value' => 2));
  50. $this->assertEquals(array('alias.field = :field_name'), $builder->query);
  51. $this->assertEquals(array('field_name' => 2), $builder->parameters);
  52. }
  53. /**
  54. * @expectedException RuntimeException
  55. */
  56. public function testAssociationWithInvalidMapping()
  57. {
  58. $filter = new ModelFilter;
  59. $filter->initialize('field_name', array('mapping_type' => 'foo'));
  60. $filter->apply(new QueryBuilder, 'asd');
  61. }
  62. /**
  63. * @expectedException RuntimeException
  64. */
  65. public function testAssociationWithValidMappingAndEmptyFieldName()
  66. {
  67. $filter = new ModelFilter;
  68. $filter->initialize('field_name', array('mapping_type' => ClassMetadataInfo::ONE_TO_ONE));
  69. $filter->apply(new QueryBuilder, 'asd');
  70. }
  71. public function testAssociationWithValidMapping()
  72. {
  73. $filter = new ModelFilter;
  74. $filter->initialize('field_name', array(
  75. 'mapping_type' => ClassMetadataInfo::ONE_TO_ONE,
  76. 'field_name' => 'field_name',
  77. ));
  78. $builder = new QueryBuilder;
  79. $filter->apply($builder, array('type' => ChoiceType::TYPE_CONTAINS, 'value' => 'asd'));
  80. $this->assertEquals(array('o.field_name', 's_field_name.id = :field_name'), $builder->query);
  81. }
  82. }