Doctrine 2 - ORM
  1. Doctrine 2 - ORM
  2. DDC-1687

[GH-298] by sandermarechal: Pagination using SQL walkers

    Details

    • Type: Bug Bug
    • Status: Resolved
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2.3
    • Component/s: None
    • Security Level: All
    • Labels:
      None

      Description

      This issue is created automatically through a Github pull request on behalf of sandermarechal:

      Url: https://github.com/doctrine/doctrine2/pull/298

      Message:

      A CountSqlWalker and LimitSubquerySqlWalker have been implemented. By
      default the Paginator will use these SQL walkers. When a query already
      uses custom SQL walkers, the Paginator will fall back to the existing
      TreeWalker implementations. Improvements:

      • Support for more complex DQL queries using named mixed results with
        GROUP BY and HAVING. For example:

      SELECT g, u, COUNT(u.id) AS userCount
      FROM Entity\Group g LEFT JOIN g.users u
      GROUP BY g.id
      HAVING userCount > 0

      • Support for entities with composite primary keys in the CountSqlWalker
        and LimitSubquerySqlWalker. Only the WhereInWalker still needs to be
        updated for full composite primary key support. But someone smarter
        than me needs to look at that and figure out how to build a WHERE IN
        query that can select rows based on multiple columns.

        Activity

        Hide
        Benjamin Eberlei added a comment -

        Merged for 2.3

        Show
        Benjamin Eberlei added a comment - Merged for 2.3
        Hide
        Doctrine Bot added a comment -

        A related Github Pull-Request [GH-298] was closed:
        https://github.com/doctrine/common/pull/298

        Show
        Doctrine Bot added a comment - A related Github Pull-Request [GH-298] was closed: https://github.com/doctrine/common/pull/298

          People

          • Assignee:
            Benjamin Eberlei
            Reporter:
            Benjamin Eberlei
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: