Re: [need advices] An idea to build a KISS ORM system upon Zend_Db_Table

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.
>