How do to specify a column of a distant join (several relations removed) in DBIx::Class?

Question

How do I specify in DBIx::Class the column of the third table I'm joining on? Here is my code:

my $join = $schema->resultset('Track')->search({'name' => 'Eminem'},{'join' => {'cd' => 'artist'}});

It just displays the tracks of Eminem, but I also want to display the artist name, Eminem? I cannot access name in that query because this is a ResultSet for Track, name is a column in the Artist table, the third table in the join.

score 1 · Accepted Answer · answered Jul 08 '13 at 10:56

1

I guess you want to filter your resultset based on the artist name, not track name:

my $rs = $schema->resultset('Track')->search({
    'artist.name' => 'Eminem',
},
{
    join => { cd => 'artist' },
});

When looping through the resultset you can access it using the relationship and column accessors:

for my $track ($rs->all) {
    say $track->cd->artist->name . ' - ' . $track->name;
}

answered Jul 08 '13 at 10:56

Alexander Hartmaier

2,178
12
21

i just needed that looping part of your answer, my query is correct. Thanks – Belmark Caday Jul 09 '13 at 02:43

score 0 · Answer 2 · answered Jul 05 '13 at 12:06

Use the relationship accessors.

for my $track (
    $schema->resultset('Track')->search(
        {
            name => 'Eminem',
        },
        {
            join => {cd => 'artist'},
        }
    )->all
) {
    use Data::Printer;
    p { $track->get_inflated_columns };
    p $track->cd->artist->name;
}
__END__
{
    cd        MyDatabase::Main::Result::Cd  {
        internals: {
            _column_data     {
                artist   2,
                cdid     3,
                title    "The Marshall Mathers LP"
            },
        }
    },
    title     "The Way I Am",
    trackid   1
}
"Eminem"
{
    cd        MyDatabase::Main::Result::Cd  {
        internals: {
            _column_data     {
                artist   2,
                cdid     3,
                title    "The Marshall Mathers LP"
            },
        }
    },
    title     "Stan",
    trackid   2
}
"Eminem"

How do to specify a column of a distant join (several relations removed) in DBIx::Class?

2 Answers2