Eugen Konkov
Eugen Konkov

Reputation: 25143

Is there simple way to get query for dbix::class result?

If I want to log queries I may use something like DBIx::Class::QueryLog

But how can I get the resulting query only once for one result?

$db->resultset('Pool::Address')->search(
  {'server.locality_id' => $self->id, usage => 0, 'destination.id' => undef},
    {join => ['destination', {subnet => 'server'}], order_by => 'ip'}
 )->get_query()   ???

Upvotes: 4

Views: 586

Answers (1)

Eugen Konkov
Eugen Konkov

Reputation: 25143

I must use ResultSet method ->as_query

Upvotes: 3

Related Questions