Doctrine 2 - ORM
  1. Doctrine 2 - ORM
  2. DDC-1819

Allow ResultSetMapping to be used for objects that are not entities

    Details

    • Type: Improvement Improvement
    • Status: Open
    • Priority: Minor Minor
    • Resolution: Unresolved
    • Affects Version/s: 2.3
    • Fix Version/s: None
    • Component/s: ORM
    • Labels:
      None

      Description

      Currently Doctrine\ORM\Query\ResultSetMapping can only be used to query the database for entities using the EntityManager::createNativeQuery method. It would be great if we could use this as well for objects that are not entities. That way we can create simple DTO's and map them to a query using the ResultSetMapping.

      I'll open a PR If there are no objections.

        Activity

        Show
        Marijn Huizendveld added a comment - I've started working on the test suite in this PR .
        Hide
        Marijn Huizendveld added a comment -

        Thanks for your input. I'll try to work on some tests this week.

        Show
        Marijn Huizendveld added a comment - Thanks for your input. I'll try to work on some tests this week.
        Hide
        Benjamin Eberlei added a comment -

        Good idea. You could make this happen by adding a ArbitraryObjectHydrator that does not use the ClassMetadata but creates ReflectionProperty instances during the hydration.

        Api would then be:

        $rsm = new ResultSetMapping();
        ....
        
        $query = $em->createNativeQuery($sql, $rsm);
        $objects = $query->getResult(Query::HYDRATOR_ARBITRARY_OBJECTS);
        
        Show
        Benjamin Eberlei added a comment - Good idea. You could make this happen by adding a ArbitraryObjectHydrator that does not use the ClassMetadata but creates ReflectionProperty instances during the hydration. Api would then be: $rsm = new ResultSetMapping(); .... $query = $em->createNativeQuery($sql, $rsm); $objects = $query->getResult(Query::HYDRATOR_ARBITRARY_OBJECTS);

          People

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

            Dates

            • Created:
              Updated: