Prendre un Café - Tag - sql - Commentaires

Optimize your Doctrine Workflow with Specialized Queries - NiKo

NiKo — Thu, 01 Oct 2009 11:47:20 +0200

maximus> check you're instantiating the query object using the BlogPostQuery::create() method. Here, it works.

Optimize your Doctrine Workflow with Specialized Queries - maximus

maximus — Wed, 30 Sep 2009 09:56:18 +0200

i am getting the following error when trying to call addPosts, addComments, addAuthors etc..
"Call to undefined method Doctrine_Query::addPosts()"
What can cause that? any idea? thanks.

Optimize your Doctrine Workflow with Specialized Queries - NiKo

NiKo — Fri, 18 Sep 2009 10:22:35 +0200

Ashok> You spotted it, nice

Optimize your Doctrine Workflow with Specialized Queries - Ashok Gelal

Ashok Gelal — Thu, 17 Sep 2009 20:32:19 +0200

In the method addPosts, '$fields' should be passed as parameter instead of p.*
i.e.
<code>
public function addPosts($fields = 'p.*')
{
return $this->addSelect($fields);
}

</code>

Optimize your Doctrine Workflow with Specialized Queries - Sid

Sid — Thu, 17 Sep 2009 10:29:39 +0200

Congratulation on big Symfony project. This is a neat solution, better than cramming all the methods in one model class Thanks for sharing this.

Optimize your Doctrine Workflow with Specialized Queries - NiKo

NiKo — Thu, 17 Sep 2009 09:18:59 +0200

François>

Optimize your Doctrine Workflow with Specialized Queries - Francois

Francois — Thu, 17 Sep 2009 09:13:35 +0200

Funny, I have seen something very similar some time ago. What was it ?

Yes, I remember: http://trac.symfony-project.org/bro...

Named queries make your model classes a lot cleaner and much easier to deal with.

Optimize your Doctrine Workflow with Specialized Queries - Evil_Wizard

Evil_Wizard — Wed, 16 Sep 2009 15:39:12 +0200

Please forgive me, I'm English and the site seems to be in French.

I think it's genius, if you want to really check if some other method included the alias as a join, then check the getParams and array_search the 'join' element sub array.

I think NiKo intended this as an example of how you could extend your core to centralize the DQL, making it easier to maintain.