CODEWITHSUNDEEP
phpdoctrine-ormdoctrine
Alex A.
Alex A.

Reputation: 2613

Mapping doctrine native query to none Entity model class

I am trying to use native query in doctrine and for now created something really simple:

$rsm = new ResultSetMapping();
$rsm->addEntityResult('ObjectA', 'a');
$rsm->addFieldResult('a', 'id', 'id');
$query = $em->createNativeQuery('SELECT * FROM table a', $rsm);

What I try using this code, I am getting an error that ObjectA is not a valid entity or mapped super class. Which is totally true. My question is: Is there any way to mad result of a native query to any arbitrary class (not Entity), but still user Doctrine's tools to do it.

Note: I am trying to avoid usage of lower level PDO.

Thank you.

Upvotes: 3

Views: 2145

Answers (1)

TazGPL
TazGPL

Reputation: 3748

Nothing like that, neither in the doc nor in the source code Doctrine\ORM\Query\ResultSetMapping (and it happens that some features are not documented).
I'd go with using scalar results and mapping the query result back to the object. Something like this:

$rsm = new ResultSetMapping();
$rsm->addScalarResult('a', 'a');
$rsm->addScalarResult('b', 'b');
$query = $em->createNativeQuery('SELECT a, b FROM table LIMIT 1', $rsm);
$result = $query->getSingleResult();
$a = new ObjectA();
$a->setA($result['a']);
// or
$a = new ObjectA($result); // with mapping passed to the constructor

Upvotes: 5

Related Questions