[Dbix-class] multi-column primary foreign key

Matt S Trout dbix-class at trout.me.uk
Tue Jan 16 13:07:33 GMT 2007


On 16 Jan 2007, at 12:57, Joss Shaw wrote:

> Hi all,
>
> I'm just a little confused by all the various documentation. I'm  
> attempting to create a table schema which has a multi-column  
> primary foreign key. That is, the primary keys of table A, are  
> contained in table B and table C.  I'm not quite sure how to go  
> about this, I tried to use "has_one" and "might_have" but  
> apparently that relationship can only be used to infer a join for a  
> single primary key.

Emphasis on the *infer* part - i.e. it can only guess for you with a  
single-col key on the other side.

Have a look at the Relationship and Relationship::Base docs for  
details on how to pass this explicitly.

-- 
Matt S Trout, Technical Director, Shadowcat Systems Ltd.
Offering custom development, consultancy and support contracts for  
Catalyst,
DBIx::Class and BAST. Contact mst (at) shadowcatsystems.co.uk for  
details.
+ Help us build a better perl ORM: http://dbix- 
class.shadowcatsystems.co.uk/ +





More information about the Dbix-class mailing list