DBIx :: Class example

In this example below:

my $rs = $schema->resultset('CD')->search(
{
  'artist.name' => 'Bob Marley'
  'liner_notes.notes' => { 'like', '%some text%' },
},
{
  join     => [qw/ artist liner_notes /],
  order_by => [qw/ artist.name /],
}
);

The DBIx cookbook says that it will be sql to be generated:

# Equivalent SQL:
# SELECT cd.*, artist.*, liner_notes.* FROM cd
# JOIN artist ON cd.artist = artist.id
# JOIN liner_notes ON cd.id = liner_notes.cd
# WHERE artist.name = 'Bob Marley'
# ORDER BY artist.name

But from the rest of the cookbook, I was lucky that only cd would select the request. * unless, of course, prefetch was not used like this:

my $rs = $schema->resultset('CD')->search(
{
  'artist.name' => 'Bob Marley'
  'liner_notes.notes' => { 'like', '%some text%' },
},
{
  join     => [qw/ artist liner_notes /],
  order_by => [qw/ artist.name /],
  prefetch => [qw/ artist liner_notes/],
}
);

The following is a statement that makes me believe this:

[Prefetch] allows you to fetch results from related tables in advance

Can someone explain to me what I am missing here? Or not? Many thanks!

+5
source share
1 answer

Equivalent SQLcontrary to the previous section of the cookbook and looks like a mistake.

, . , $cd->artist->name, SELECT artist.* FROM artist WHERE artist.id = ?, , .

. , , . $cd->artist->name, , . , .

+4

All Articles