[Dbix-class] Relationship problems

[Jess Robinson]

On Sat, 11 Nov 2006, Josef Karthauser wrote:

> On Sat, Nov 11, 2006 at 01:17:17AM +0000, Josef Karthauser wrote:
>>         my $rs = $c->model('Contact')->
>>             search($criteria,
>>                 { page => $page, rows => 10,
>>                   order_by => [$order_by, $default_order, "domains.domainname"],
>> #1                prefetch => { 'domains' }
>> #2                prefetch => { 'domains' =>
>> #2                  { 'self.contactid' => 'foreign.registrant',
>> #2                    'self.owner' => 'foreign.owner' }}
>>                 });
>>
>> Neither of #1 or #2 appear to do what I want.  I get 'No such
>> relationship' whenever I try and process the request.
>>
>
> Ahha, got it.
>
> What I wanted was:
>    my $rs = $c->model('Contact')->
> 	search($criteria,
>            { page => $page, rows => 10,
> 		order_by => [$order_by, $default_order, "domains.domainname"],
> 		prefetch => 'domains'
> 	    }
> 	});
>
> This now works, as the relationships are correctly described in the
> class files.  However I would have thought that #2 should have
> worked too; I'd appreciate some understanding on that count.  The
> self. and foreign. functionality I don't think is clearly deliniated
> in the documentation.  (For instance when I read that I assumed
> that I needed to replace self with the local table name and foreign
> with the foreign table name, but that didn't work).

Hi Joe,

>From the docs:


The condition needs to be an SQL::Abstract-style representation of the 
join between the tables. When resolving the condition for use in a "JOIN", 
keys using the pseudo-table "foreign" are resolved to mean "the Table on 
the other side of the relationship", and values using the pseudo-table 
"self" are resolved to mean "the Table this class is rep- resenting".

.. How would you write this so that it makes sense to you? We're always on 
the lookout for parts of the docs people don't understand.. Please give us 
some input to help improve them.

Jess