-=head1 NAME
+=head1 NAME
DBIx::Class::Manual::Joining - Manual on joining tables with DBIx::Class
And in C<MySchema::Tracks>:
- MySchema::Tracks->belongs_to('cd', 'MySchema::CD', 'CDID');
+ MySchema::Tracks->refers_to('cd', 'MySchema::CD', 'CDID');
There are several other types of relationships, they are more
comprehensively described in L<DBIx::Class::Relationship>.
Instead C<get_column> must be used:
while(my $row = $search_rs->next) {
- print $row->get_colum('track_name'); ## WORKS
+ print $row->get_column('track_name'); ## WORKS
}
=head2 Incomplete related objects
output. This is better solved by storing that field in a separate
table which you only join to when needed.
-To fetch an incomplete related object, supply the dotted notation to the '+as' attribute:
+To fetch an incomplete related object, supply the dotted notation to the '+as' attribute:
$schema->resultset('CD')->search(
{ 'Title' => 'Funky CD',
},
{ join => 'tracks',
'+select' => ['tracks.Name'],
- '+as' => ['tracks.Name'],
+ '+as' => ['tracks.Name'],
order_by => ['tracks.id'],
}
);
In C<MySchema::Tracks>:
- MySchema::Tracks->belongs_to('artist', 'MySchema::Artist', 'ArtistID');
+ MySchema::Tracks->refers_to('artist', 'MySchema::Artist', 'ArtistID');
The search:
To perform joins using relations of the tables you are joining to, use
a hashref to indicate the join depth. This can theoretically go as
-deep as you like (warning: contrived examples!):
+deep as you like (warning: contrived examples!):
join => { room => { table => 'leg' } }
To join two relations at the same level, use an arrayref instead:
- join => { room => [ 'chair', 'table' ] }
+ join => { room => [ 'chair', 'table' ] }
Or combine the two: