Foreign key as primary key...

[prev] [thread] [next] [Date index for 2005/02/18]

Hello there,


I'm trying to apply CDBI to an existing DB schema. We've got a lot of tables which use foreign keys as primary keys, either on their own, or as part of a compound key. The documentation seems to suggest might_have is the way forward but I seem to be encountering a few problems. Do I for instance write -

Foo->columns(Primary => qw/foreign_key_id/);
Foo->might_have(foreign_key_id => 'Foreign::KeyTable');

and then in the Foreign::KeyTable table write - 

Foreign::KeyTable->have_many(foos => 'Foo');


I'm a little confused, I'm hoping someone could assist me please.
Kindest,


>joss