How to use a findBy method with comparative criteria

by

The class Doctrine\ORM\EntityRepository implements Doctrine\Common\Collections\Selectable API.

The Selectable interface is very flexible and quite new, but it will allow you to handle comparisons and more complex criteria easily on both repositories and single collections of items, regardless if in ORM or ODM or completely separate problems.

This would be a comparison criteria as you just requested as in Doctrine ORM 2.3.2:

$criteria = new \Doctrine\Common\Collections\Criteria();
$criteria->where(\Doctrine\Common\Collections\Criteria::expr()->gt('prize', 200));

$result = $entityRepository->matching($criteria);

The major advantage in this API is that you are implementing some sort of strategy pattern here, and it works with repositories, collections, lazy collections and everywhere the Selectable API is implemented.

This allows you to get rid of dozens of special methods you wrote for your repositories (like findOneBySomethingWithParticularRule), and instead focus on writing your own criteria classes, each representing one of these particular filters.

More Related Contents:

  1. Doctrine2: Best way to handle many-to-many with extra columns in reference table
  2. Is there a built-in way to get all of the changed/updated fields in a Doctrine 2 entity
  3. On delete cascade with doctrine2
  4. Why I am suddenly getting a “Typed property must not be accessed before initialization” error when introducing properties type hints?
  5. How to do left join in Doctrine?
  6. Default value in Doctrine
  7. Doctrine 2 and Many-to-many link table with an extra field
  8. How to use WHERE IN with Doctrine 2
  9. How to select randomly with doctrine
  10. Should I use EAV model?
  11. Select entries between dates in doctrine 2
  12. Too much data with var_dump in symfony2 doctrine2
  13. How to re-save the entity as another row in Doctrine 2
  14. Subquery in doctrine2 notIN Function
  15. Injecting SecurityContext into a Listener prePersist or preUpdate in Symfony2 to get User in a createdBy or updatedBy Causes Circular Reference Error
  16. How to set up entity (doctrine) for database view in Symfony 2
  17. Symfony2, Dynamic DB Connection/Early override of Doctrine Service
  18. How to get a one-dimensional scalar array as a doctrine dql query result?
  19. How to setup table prefix in symfony2
  20. Symfony 2.0 getting service inside entity
  21. “Class XXX is not a valid entity or mapped super class” after moving the class in the filesystem
  22. Can I access discriminator field from php in doctrine2?
  23. How to force Doctrine to update array type fields?
  24. Query on a many-to-many relationship using Doctrine with Symfony2
  25. Doctrine2 association mapping with conditions
  26. How can I use DATE() in Doctrine 2 DQL?
  27. Join subquery with doctrine 2 DBAL
  28. MySQL query won't update database [closed]
  29. PHP sending form data to the database
  30. Insert form in MySQL with PDO [duplicate]

Leave a Comment