Not sure if this covers it, but did you look at this: http://search.cpan.org/~jsiracusa/Rose-DB-Object-0.727/lib/Rose/DB/Object/Tu torial.pod#Auto-joins_and_other_Manager_features
Sean On 5/25/06 12:46 PM, "Jonathan Vanasco" <[EMAIL PROTECTED]> wrote: > > i have the 2 packages below > Asset > AssetType > > Asset is basically > name > id > type_id > > where type_id is a fkey to another table > > when i pull a record for Asset or join onto asset from another table, > i need to get the asset_type_id name > sometimes i pull a record for something that is linked to Asset - so > i'll need to delve 2 tables down > > doesn't anyone know of a rose-db supported mechanism for this? > rose seems to have everything imaginable in it. i'm sure i'm just > not picking it up from the docs. > > my class structures are belwo > > ====== > package MyApp::RoseDB::Asset; > use base qw(Rose::DB::Object); > > use MyApp::RoseDB; > > __PACKAGE__->meta->table('asset'); > __PACKAGE__->meta->columns(qw(id asset_type_id name)); > __PACKAGE__->meta->primary_key_columns('id'); > __PACKAGE__->meta->add_unique_key('name'); > __PACKAGE__->meta->foreign_keys > ( > asset_type => > { > class => 'MyApp::RoseDB::AssetType', > key_columns => { asset_type_id => 'id' }, > }, > ); > __PACKAGE__->meta->initialize( replace_existing => 1 ); > sub init_db { MyApp::RoseDB->new } > 1; > > > > package MyApp::RoseDB::AssetType; > use base qw(Rose::DB::Object); > use MyApp::RoseDB; > __PACKAGE__->meta->table('asset_type'); > __PACKAGE__->meta->columns(qw(id name)); > __PACKAGE__->meta->primary_key_columns('id'); > __PACKAGE__->meta->add_unique_key('name'); > __PACKAGE__->meta->initialize( replace_existing => 1 ); > sub init_db { MyApp::RoseDB->new } > 1; > > > > > ------------------------------------------------------- > All the advantages of Linux Managed Hosting--Without the Cost and Risk! > Fully trained technicians. The highest number of Red Hat certifications in > the hosting industry. Fanatical Support. Click to learn more > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=107521&bid=248729&dat=121642 > _______________________________________________ > Rose-db-object mailing list > Rose-db-object@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/rose-db-object ------------------------------------------------------- All the advantages of Linux Managed Hosting--Without the Cost and Risk! Fully trained technicians. The highest number of Red Hat certifications in the hosting industry. Fanatical Support. Click to learn more http://sel.as-us.falkag.net/sel?cmd=lnk&kid=107521&bid=248729&dat=121642 _______________________________________________ Rose-db-object mailing list Rose-db-object@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/rose-db-object