ModelFilterTest.php 3.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107
  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->initialize('field_name', 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->initialize('field_name', 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->initialize('field_name', 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->initialize('field_name', array('mapping_type' => 'foo'));
  59. $filter->apply(new QueryBuilder, 'asd');
  60. }
  61. /**
  62. * @expectedException RuntimeException
  63. */
  64. public function testAssociationWithValidMappingAndEmptyFieldName()
  65. {
  66. $filter = new ModelFilter;
  67. $filter->initialize('field_name', array('mapping_type' => ClassMetadataInfo::ONE_TO_ONE));
  68. $filter->apply(new QueryBuilder, 'asd');
  69. }
  70. public function testAssociationWithValidMapping()
  71. {
  72. $filter = new ModelFilter;
  73. $filter->initialize('field_name', array(
  74. 'mapping_type' => ClassMetadataInfo::ONE_TO_ONE,
  75. 'field_name' => 'field_name',
  76. ));
  77. $builder = new QueryBuilder;
  78. $filter->apply($builder, 'asd');
  79. $this->assertEquals(array('o.field_name', 'field_name.id = :field_name'), $builder->query);
  80. }
  81. }