Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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()   ???
like image 683
Eugen Konkov Avatar asked Oct 15 '25 15:10

Eugen Konkov


1 Answers

I must use ResultSet method ->as_query

like image 79
Eugen Konkov Avatar answered Oct 17 '25 04:10

Eugen Konkov



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!