Jason Kohles wrote:
On Feb 22, 2007, at 5:29 PM, RA Jones wrote:
Hi folks,
I'm not getting it with foreign keys in DBIC. For example, table
users has a column called location_id, which pulls the location
from the locations table like so:
select u.user, l.location from users u, locations l where
u.location_id = l.location_id
A location has many users, so in DB::Location :
__PACKAGE__->has_many(users => 'DB::User', 'location_id');
No has_many/belongs_to mappings specified in DB::Users.
Then, in a method in MyApp::Controller::Users : $c->stash->{user} =
$c->model('DB::User')->find($id); $c->stash->{template} =
'users/view.tt2';
But the rendered view just shows location_id, not location. I
obviously don't quite get it and have missed something here. Do I
have to manually map location_id to location in either M, V or C?
You have setup your relationships so that a location has_many users,
and that is it, the relationship only goes one way. If you want the
field in DB::User to refer back to the location, you also need a
belongs_to relationship in your user class.
Thanks, that did it, provided I call the item as user.location.location
in the template, otherwise I get:
MyApp::Model::DB::Location=HASH(0x449c5d0)
Will look at DBIx::Class::Schema::Loader, thanks.
--
Richard Jones
Leeds, UK
mailto:[EMAIL PROTECTED]
_______________________________________________
List: [email protected]
Listinfo: http://lists.rawmode.org/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/[email protected]/
Dev site: http://dev.catalyst.perl.org/
