easiest way to fetch query to array of object in symfony

Question

View in database I mean :

create view `vMaketType` as select * from MaketType

I have a view in database, but because of doctrine cant support it now, i using query, and fetch it one by one :

        $em = $this->getDoctrine()->getManager();
        $con = $this->getDoctrine()->getEntityManager()->getConnection();
        $stmt = $con->executeQuery('SELECT * FROM vMaketType');
        $domain = [];
        //I must fetch it and set it one by one
        foreach ($stmt->fetchAll() as $row){
           $obj = new vMaketType();
           $obj->setId($row["Id"]);
           $obj->setName($row["Name"]);
           $obj->setAmount($row["Amount"]);
           array_push($domain, $obj);
        }

for me this is really takes too much time to code one by one.

vMaketType is a custom entity I created to send data from controller to [Twig]view.

is there any easier way to fetch to array of object vMaketType?

because I have a view with 24 fields, I wish there is easier way for it.

Why don't you just use MarketType (I'm assuming that's your entity with mapping information)? — Kep
– Kep, Commented Nov 4, 2017 at 10:19
He says it doesn't work with sql views, but I don't see why: Check out: stackoverflow.com/questions/8377671/… — Tokeeen.com
– Tokeeen.com, Commented Nov 4, 2017 at 10:29

Tokeeen.com · Accepted Answer · 2017-11-04 05:36:56Z

0

Perhaps you can try with the serializer:

$obj = $this->get('serializer')->deserialize($row, 'Namespace\MaketType', 'array');

Code not tested, tweaks may be done, see the related doc.

edited Nov 4, 2017 at 5:36

answered Nov 4, 2017 at 5:02

Tokeeen.com

7367 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

yozawiratama Over a year ago

I've been read it, but it cant works for view, that's why I used handcoded query. :) you should read my explanation first, or cmiiw if there is any way orm doctrine support view

yozawiratama Over a year ago

cmon, bro, you dont understand what i ask

Collectives™ on Stack Overflow

easiest way to fetch query to array of object in symfony

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related