Quote:
When you say it handles the foreign keys, do you mean automatically? How does it do so?When you create a table using Creator,
Code:
$creator->fk(table2 => { foo_fk => "foo" })it adds the foreign key relations information to the .def file.
Code:
'fk' => { 'demo_Links' => {
'LinkID' => 'ID'
}
},
So, whenever you use
Code:
$DB->table([qw/table1 table2/])the proper JOIN language is added to the generated SQL, so you can do:
Code:
$db->select()Code:
$db->select({"table1.foo_fk" => \"table2.foo"});Quote:
Does that mean the creator->fk function is worthless?Quote:
Does it only create foreign keys for links tables (not custom tables for new plugins?)Hope that helps.
Philip
------------------
Limecat is not pleased.