利用监听器进行sql语句记录

1、监听sql语句的事件类已经定义，直接创建监听器类即可：

  1. # 监听sql
  2. make:listener QueryListener --event=Illuminate\Database\Events\QueryExecuted

2、监听器类代码

./app/Listeners/QueryListener.php

  1. <?php
  3. namespace App\Listeners;
  5. use Illuminate\Database\Events\QueryExecuted;
  6. use Illuminate\Queue\InteractsWithQueue;
  7. use Illuminate\Contracts\Queue\ShouldQueue;
  8. use App\Http\Models\OperationLog;
  10. class QueryListener
  11. {
  12.     /**
  13.      * Create the event listener.
  14.      *
  15.      * @return void
  16.      */
  17.     public function __construct()
  18.     {
  19.         //
  20.     }
  22.     /**
  23.      * Handle the event.
  24.      *
  25.      * @param  QueryExecuted  $event
  26.      * @return void
  27.      */
  28.     public function handle(QueryExecuted $event)
  29.     {
  30.         $sql = vsprintf(str_replace("?", "'%s'", $event->sql), $event->bindings) . " \t[" . $event->time . ' ms] ';
  31.         Log::error($sql);
  32.     }
  33. }

3、引入监听器

./app/Providers/EventServiceProvider.php

  1. protected $listen = [
  2.         ...
  3.         \Illuminate\Database\Events\QueryExecuted::class => [
  4.             'App\Listeners\QueryListener'
  5.         ],
  6.         ...
  7.     ];

此时进行操作时就会记录sql日志

相关文章：

laravel 利用中间件进行操作日志记录

Lumen 框架sql监听

1、创建sql监听器

QueryListener.php

  1. <?php
  3. namespace App\Listeners;
  5. use App\Http\Helpers\FunctionHelper;
  6. use Illuminate\Database\Events\QueryExecuted;
  7. use Illuminate\Support\Facades\Log;
  9. class QueryListener
  10. {
  11.     /**
  12.      * Create the event listener.
  13.      *
  14.      * @return void
  15.      */
  16.     public function __construct()
  17.     {
  18.         //
  19.     }
  21.     /**
  22.      * Handle the event.
  23.      *
  24.      * @param QueryExecuted $event
  25.      * @return void
  26.      */
  27.     public function handle(QueryExecuted $event)
  28.     {
  29.         if (FunctionHelper::isTestEnv()) {
  30.             Log::info($event->sql);
  31.             Log::info($event->bindings);
  32.         }
  33.     }
  34. }

2、加入到监听服务中

EventServiceProvider.php

  1.  <?php
  3. namespace App\Providers;
  5. use App\Listeners\QueryListener;
  6. use Illuminate\Database\Events\QueryExecuted;
  7. use Laravel\Lumen\Providers\EventServiceProvider as ServiceProvider;
  9. class EventServiceProvider extends ServiceProvider
  10. {
  11.     /**
  12.      * The event listener mappings for the application.
  13.      *
  14.      * @var array
  15.      */
  16.     protected $listen = [
  17.         \App\Events\ExampleEvent::class => [
  18.             \App\Listeners\ExampleListener::class,
  19.         ],
  20.         # 注册sql监听
  21.         QueryExecuted::class => [
  22.             QueryListener::class,
  23.         ],
  24.     ];
  25. }

3、项目入口引入监听服务

bootstrap/app.php

  1. $app->register(App\Providers\EventServiceProvider::class);