PHP Doctrine toArray problem

Question

I have a problem with the toArray() method in Doctrine. Its doesn't get my relations:

First query :

$q = Doctrine::getTable('posts')->find(1);
debug($q->toArray(true));

Print the postid=1 with out the relations

$q = Doctrine::getTable('posts')->find(1);
$q->Tags->toArray();
debug($q->toArray(true));

...prints the results with tag relation.

But i want to do:

Doctrine::getTable('posts')->findAll()->toArray(true);

...and get all of relations of posts , instead I got an array of post row.

Any idea about how to make it work with the relations?

(notice i added toArray(true) for deep property.

thanks for any help

Crozin · Accepted Answer · 2010-01-28 19:50:22Z

1

You could create named query for this table with all relations attached:

Doctrine::getTable('posts')->addNamedQuery('get.by.id.with.relations', 'DQL here...');

And then just use something like this:

Doctrine::getTable('posts')->find('get.by.id.with.relations', array(123));

answered Jan 28, 2010 at 19:50

Crozin

44.5k13 gold badges92 silver badges136 bronze badges

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

Comments

prodigitalson · Accepted Answer · 2010-01-28 19:31:27Z

1

I beleive you need to do a Join with the query. Otherwise it doesnt hydrate the realated data.

$q = Doctrine_Query::create()
    ->from('Post p')
    ->leftJoin('p.RelatedModel1 rm1')
    ->leftJoin('p.RelatedModel2 rm2');

$q->findAll()->toArray(true);

edited Jan 28, 2010 at 19:31

answered Jan 28, 2010 at 19:26

prodigitalson

60.6k10 gold badges106 silver badges118 bronze badges

Comments

user252849 · Accepted Answer · 2010-01-28 20:44:39Z

0

$q = Doctrine_Query::create()
->from('Post p')
->leftJoin('p.RelatedModel1 rm1')
->leftJoin('p.RelatedModel2 rm2');

$q->findAll()->toArray(true);

Can i Add ->limit()->offset() to the query ?

I guss that if i first create the query then findAll will act the same as execute right ?

answered Jan 28, 2010 at 20:44

user252849

673 silver badges9 bronze badges

1 Comment

prodigitalson Over a year ago

you should be able to add anything thats valid for a query. and yes they are just differnt methods of acheiving essentially the same thing. You could even use the table class if you want i think by doing something like

Doctrine::getTable('posts')->getQuery('p')->leftJoin('p.RelatedModel1 rm1')->leftJoin('p.RelatedModel2 rm2')->findAll()->toArray(true);

Collectives™ on Stack Overflow

PHP Doctrine toArray problem

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related