Hello again,
Here is a more concrete example:
class UserTable extends Doctrine_Table {
public function findActiveUsersByUsername($username) {
return Doctrine_Query::create()
->from('Users u')
->where('u.username = ?', $username)
->andWhere(u.active = 1)
->execute();
}
}
$users = Doctrine_Core::getTable('User')-
>findActiveUsersByUsername('john_smith');
As you can see in the example, we use Doctrine_Query in the Table
Class to retrieve our users in exactly the same way that we would
without the Table Class, but leaving it inside the Table Class allows
us to re-use this query over and over. If you're sure that you will
only use the query you created in one place, by all means, leave it
outside of the Table Class, but if you think you might use it in more
than one place, put it in a function.
Roger
On Mar 31, 8:52 pm, FHoerth <fed...@gmail.com> wrote:
> I Just posted my answer but it seems that was an error, if tomorrow
> doesn't appear I will answer again.
> Thank you for answering Roger
>
> On 1 abr, 00:13, Roger Webb <webb.ro...@gmail.com> wrote:
>
> > As I best understand it, the "table" object is supposed to act as a
> > repository. You would, ideally, add methods to the table class to
> > retrieve instances of 'tableClass'.
>
> > It may be better illustrated with an example:
>
> > You have a class(model) User. In your UserTable class you might make
> > a method called "findActiveUserByUsername()" to find all active
> > users.
>
> > If you were to use Doctrine_Query::create()->from('User
> > u')->where('u.active = 1'); you would get the same result, but your query
>
> > would not be re-usable.
>
> > Roger
>
> > On Mar 31, 1:54 pm, FHoerth <fed...@gmail.com> wrote:
>
> > > Hi!
> > > Can someone explain me what is the difference between:
>
> > > $this->var = Doctrine_Core::getTable('tableClass')-
>
> > > >createQuery('alias')->where('alias.column > ?', date);
>
> > > and this?
>
> > > $this->var = Doctrine_Query::create()->from('tableClass alias')-
>
> > > >where('alias.column > ?', date);
>
> > > Why not using a single method?
>
>
--
If you want to report a vulnerability issue on symfony, please send it to
security at symfony-project.com
You received this message because you are subscribed to the Google
Groups "symfony users" group.
To post to this group, send email to symfony-users@googlegroups.com
To unsubscribe from this group, send email to
symfony-users+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en
