ModelFilterTest.php 3.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111
  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. class ModelFilterTest extends \PHPUnit_Framework_TestCase
  14. {
  15. public function getFieldDescription(array $options)
  16. {
  17. $fieldDescription = $this->getMock('Sonata\AdminBundle\Admin\FieldDescriptionInterface');
  18. $fieldDescription->expects($this->once())
  19. ->method('getOptions')
  20. ->will($this->returnValue($options));
  21. $fieldDescription->expects($this->once())
  22. ->method('getName')
  23. ->will($this->returnValue('field_name'));
  24. return $fieldDescription;
  25. }
  26. public function testFilterEmpty()
  27. {
  28. $filter = new ModelFilter;
  29. $filter->setFieldDescription($this->getFieldDescription(array('field_options' => array('class' => 'FooBar'))));
  30. $builder = new QueryBuilder;
  31. $filter->filter($builder, 'alias', 'field', null);
  32. $filter->filter($builder, 'alias', 'field', array());
  33. $this->assertEquals(array(), $builder->query);
  34. }
  35. public function testFilterArray()
  36. {
  37. $filter = new ModelFilter;
  38. $filter->setFieldDescription($this->getFieldDescription(array('field_options' => array('class' => 'FooBar'))));
  39. $builder = new QueryBuilder;
  40. $filter->filter($builder, 'alias', 'field', array('1', '2'));
  41. $this->assertEquals(array('in_alias.field', 'alias.field IN ("1,2")'), $builder->query);
  42. }
  43. public function testFilterScalar()
  44. {
  45. $filter = new ModelFilter;
  46. $filter->setFieldDescription($this->getFieldDescription(array('field_options' => array('class' => 'FooBar'))));
  47. $builder = new QueryBuilder;
  48. $filter->filter($builder, 'alias', 'field', 2);
  49. $this->assertEquals(array('alias.field = :field_name'), $builder->query);
  50. $this->assertEquals(array('field_name' => 2), $builder->parameters);
  51. }
  52. /**
  53. * @expectedException RuntimeException
  54. */
  55. public function testAssociationWithInvalidMapping()
  56. {
  57. $filter = new ModelFilter;
  58. $filter->setFieldDescription($this->getFieldDescription(array('mapping_type' => 'foo')));
  59. $builder = new QueryBuilder;
  60. $filter->apply($builder, 'asd');
  61. }
  62. /**
  63. * @expectedException RuntimeException
  64. */
  65. public function testAssociationWithValidMappingAndEmptyFieldName()
  66. {
  67. $filter = new ModelFilter;
  68. $filter->setFieldDescription($this->getFieldDescription(array('mapping_type' => ClassMetadataInfo::ONE_TO_ONE)));
  69. $builder = new QueryBuilder;
  70. $filter->apply($builder, 'asd');
  71. }
  72. public function testAssociationWithValidMapping()
  73. {
  74. $filter = new ModelFilter;
  75. $filter->setFieldDescription($this->getFieldDescription(array(
  76. 'mapping_type' => ClassMetadataInfo::ONE_TO_ONE,
  77. 'field_name' => 'field_name'
  78. )));
  79. $builder = new QueryBuilder;
  80. $filter->apply($builder, 'asd');
  81. $this->assertEquals(array('o.field_name', 'field_name.id = :field_name'), $builder->query);
  82. }
  83. }