StringFilterTest.php 2.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778
  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\StringFilter;
  12. use Sonata\AdminBundle\Form\Type\Filter\StringType;
  13. class StringFilterTest extends \PHPUnit_Framework_TestCase
  14. {
  15. public function testEmpty()
  16. {
  17. $filter = new StringFilter;
  18. $filter->initialize('field_name', array('field_options' => array('class' => 'FooBar')));
  19. $builder = new QueryBuilder;
  20. $filter->filter($builder, 'alias', 'field', null);
  21. $filter->filter($builder, 'alias', 'field', '');
  22. $this->assertEquals(array(), $builder->query);
  23. }
  24. public function testContains()
  25. {
  26. $filter = new StringFilter;
  27. $filter->initialize('field_name', array('format' => '%s'));
  28. $builder = new QueryBuilder;
  29. $this->assertEquals(array(), $builder->query);
  30. $filter->filter($builder, 'alias', 'field', array('text' => 'asd', 'type' => StringType::TYPE_CONTAINS));
  31. $this->assertEquals(array('alias.field LIKE :field_name'), $builder->query);
  32. $this->assertEquals(array('field_name' => 'asd'), $builder->parameters);
  33. $builder = new QueryBuilder;
  34. $this->assertEquals(array(), $builder->query);
  35. $filter->filter($builder, 'alias', 'field', array('text' => 'asd', 'type' => null));
  36. $this->assertEquals(array('alias.field LIKE :field_name'), $builder->query);
  37. $this->assertEquals(array('field_name' => 'asd'), $builder->parameters);
  38. }
  39. public function testNotContains()
  40. {
  41. $filter = new StringFilter;
  42. $filter->initialize('field_name', array('format' => '%s'));
  43. $builder = new QueryBuilder;
  44. $this->assertEquals(array(), $builder->query);
  45. $filter->filter($builder, 'alias', 'field', array('text' => 'asd', 'type' => StringType::TYPE_NOT_CONTAINS));
  46. $this->assertEquals(array('alias.field NOT LIKE :field_name'), $builder->query);
  47. $this->assertEquals(array('field_name' => 'asd'), $builder->parameters);
  48. }
  49. public function testEquals()
  50. {
  51. $filter = new StringFilter;
  52. $filter->initialize('field_name', array('format' => '%s'));
  53. $builder = new QueryBuilder;
  54. $this->assertEquals(array(), $builder->query);
  55. $filter->filter($builder, 'alias', 'field', array('text' => 'asd', 'type' => StringType::TYPE_EQUAL));
  56. $this->assertEquals(array('alias.field = :field_name'), $builder->query);
  57. $this->assertEquals(array('field_name' => 'asd'), $builder->parameters);
  58. }
  59. }