I had a few special requirements for *my ORM*, which ZF ORM would need to cater
for:
- I need to configure the ORM classes to automatically add 'WHERE dogs.Archived
= 0' when doing a '$dogs->fetchAll()'
- If the current user has access only to certain breeds of dogs, the ORM
classes need to automatically add 'JOIN dogs_breeds ... WHERE dogs_breeds
IN({$user->allowedBreeds()})' when doing a '$dogs->fetchAll()'.
This allowed me to deal with 'hidden' records and a detailed security model
without re-specifying the rules everywhere in my application - it saved my alot
of time and testing.
cheers,
Peter
--- sylvain bannier <[EMAIL PROTECTED]> wrote:
>
> I've implemented the get<Related> method on rows AND "row sets" (actually a
> subclass of rowset). So you can get the related objects in 2 queries
>
> $puppies = $do->findAllPuppies();
> // $puppies is a row_set
> $puppiesFleas = $puppies->getAllFleas();
>
> Sylvain
>
>
>
> Synaptic Media wrote:
> >
> > Sylvain,
> >
> > I have this, but its called on the record object, so:
> >
> > $dog = $do->find();
> > $fleas = $dog->getAllFleas();
> >
> > But if you have 300 dogs it's 1+{Numer of Rows) the queries. If
> > however when you do something like:
> >
> > $dogs = $do->fetchAll();
> >
> > it automatically did a JOIN there, it's one query.
> >
> > - Davey
> >
> > On Sep 22, 2006, at 11:21 AM, sylvain bannier wrote:
> >
> >>
> >> I actually have implemented a feature that enables related objects
> >> fetch
> >> based on columns name.
> >>
> >> providing your table has a field named "fk_myRelatedTable" or
> >> something like
> >> that, you can get related objects by usings methods like this :
> >>
> >> $relatedObject = $myParentObject->getMyRelatedObject();
> >>
> >> This method automatically performs the "joins".
> >>
> >>
> >>
> >>
> >>
> >>
> >> Synaptic Media wrote:
> >>>
> >>> I actually have a fully working Rails-like (not /too/ similar though)
> >>> ActiveRecord implementation that got lost (bureaucratically)
> >>> somewhere in the mix.
> >>>
> >>> The only feature I would like to add is the possibility to resolve
> >>> relationships automatically, such that it can condense the number of
> >>> queries down using JOINs.
> >>>
> >>> - Davey
> >>>
> >>> On Sep 22, 2006, at 10:04 AM, sylvain bannier wrote:
> >>>
> >>>>
> >>>>
> >>>>
> >>>> Rodrigo Moraes wrote:
> >>>>>
> >>>>> On 7/11/06, Fabien MARTY wrote:
> >>>>>> - First, we need to introduce two protected properties in
> >>>>>> Table.php file
> >>>>>> protected $_rowClassName = 'Zend_Db_Table_Row';
> >>>>>> protected $_rowsetClassName = 'Zend_Db_Table_Rowset';
> >>>>>
> >>>>> I think this makes a lot of sense and adds a lot of flexibility to
> >>>>> Zend_Db_Table. We can make our own base class subclassing
> >>>>> Zend_Db_Table and changing fetchNew(), fetchRow() and fetchAll() to
> >>>>> implement this idea, but I think it would be worth to have this in
> >>>>> Zend_Db_Table itself, unless there are other plans for these
> >>>>> methods...
> >>>>>
> >>>>> cheers,
> >>>>> rodrigo moraes / brazil
> >>>>>
> >>>>>
> >>>>
> >>>> Hello,
> >>>> I made a few steps in this way. if you're interested, i could send
> >>>> you my
> >>>> files.
> >>>> regards,
> >>>> --
> >>>> View this message in context: http://www.nabble.com/-need-advices--
> >>>> An-idea-to-build-a-KISS-ORM-system-upon-Zend_Db_Table-
> >>>> tf1926214.html#a6447689
> >>>> Sent from the Zend Framework mailing list archive at Nabble.com.
> >>>>
> >>>
> >>>
> >>>
> >>
> >> --
> >> View this message in context: http://www.nabble.com/-need-advices--
> >> An-idea-to-build-a-KISS-ORM-system-upon-Zend_Db_Table-
> >> tf1926214.html#a6449160
> >> Sent from the Zend Framework mailing list archive at Nabble.com.
> >>
> >
> >
> >
>
> --
> View this message in context:
>
http://www.nabble.com/-need-advices--An-idea-to-build-a-KISS-ORM-system-upon-Zend_Db_Table-tf1926214.html#a6452241
> Sent from the Zend Framework mailing list archive at Nabble.com.
>
>
____________________________________________________
On Yahoo!7
Messenger - IM with Windows LiveĀ Messenger friends.
http://au.messenger.yahoo.com
