How to use a findBy method with comparative criteria

Question

I d need to use a  magic finder  findBy method using comparative criteria  not only exact criteria   In other words  I need to do something like this    result    purchases repository- gt findBy array  prize    gt    gt 200       so that I d get all purchases where the prize is above 200

User · Answer

criteria   new  Doctrine Common Collections Criteria         criteria- gt where  criteria- gt expr  - gt gt  id    id            - gt setMaxResults 1          - gt orderBy array  id    gt   criteria  DESC      results    articlesRepo- gt matching  criteria

User · Answer

You have to use either DQL or the QueryBuilder  E g  in your Purchase-EntityRepository you could do something like this    q    this- gt createQueryBuilder  p             - gt where  p prize  gt   purchasePrize             - gt setParameter  purchasePrize   200            - gt getQuery      q- gt getResult      For even more complex scenarios take a look at the Expr   class

User · Answer

This is an example using the Expr   Class - I needed this too some days ago and it took me some time to find out what is the exact syntax and way of usage          fetches Products that are more expansive than the given price         param int  price     return array     public function findProductsExpensiveThan  price       em    this- gt getEntityManager       qb    em- gt createQueryBuilder        q     qb- gt select array  p               - gt from  YourProductBundle Product    p              - gt where                qb- gt expr  - gt gt  p price    price                          - gt orderBy  p price    DESC              - gt getQuery       return  q- gt getResult

User · Answer

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- gt where  criteria- gt expr  - gt gt  prize   200      result    entityRepository- gt 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

User · Answer

The Symfony documentation now explicitly shows how to do this    em    this- gt getDoctrine  - gt getManager     query    em- gt createQuery       SELECT p     FROM AppBundle Product p     WHERE p price  gt   price     ORDER BY p price ASC   - gt setParameter  price    19 99         products    query- gt getResult      From http   symfony com doc 2 8 book doctrine html querying-for-objects-with-dql

User · Answer

I like to use such static methods    result    purchases repository- gt matching      Criteria  create  - gt where          Criteria  expr  - gt gt  prize   200             Of course  you can push logic when it is 1 condition  but when you have more conditions it is better to divide it into fragments  configure and pass it to the method    expr   Criteria  expr      criteria   Criteria  create     criteria- gt where  expr- gt gt  prize   200     criteria- gt orderBy   prize    gt  Criteria  DESC      result    purchases repository- gt matching  criteria

[php] How to use a findBy method with comparative criteria

Examples related to php

Examples related to symfony

Examples related to doctrine-orm