Jump to content


Photo

To logg all sql-statements with error


  • Please log in to reply
No replies to this topic

#1 mstdmstdd

mstdmstdd
  • Members
  • PipPipPip
  • Advanced Member
  • 55 posts

Posted 10 August 2017 - 02:43 PM

Hello,

 

  In laravel 5.4 adding lines in app/Providers/AppServiceProvider.php file:
 

public function boot()
{

if ($this->app->environment('local')) {
\DB::listen(function($query) {
$dbLog = new \Monolog\Logger('Query');
$dbLog->pushHandler(new \Monolog\Handler\RotatingFileHandler(storage_path('logs/Query.log'), 5, \Monolog\Logger::DEBUG));
$dbLog->info($query->sql, ['Bindings' => $query->bindings, 'Time' => $query->time]);
});
}
...

I made log of all successfull sql in file.

If there is a way to catch and write to this file all sql with errors and error description?

I know about laravel.log, but I would prefer to write all sql-statements successfull and with error.

Thanks!






0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users