Laravel 5.5 – How to log all Eloquent Queries

In this post, I will show you simple method to log each and every Eloquent Query of your application executes. We gonna log queries to the storage/logs/laravel.log file.

To log database queries we gonna add a database calls lister as shown in the below example. Open your app/Providers/AppServiceProvider.php and add following code to boot() method:

namespace App\Providers;

use Illuminate\Support\ServiceProvider;

use Illuminate\Support\Facades\Schema;

use DB;

use Log;

class AppServiceProvider extends ServiceProvider

{

    public function boot()

    {

        Schema::defaultStringLength(191);

        DB::listen(function($query) {

            Log::info(

                $query->sql,

                $query->bindings,

                $query->time

            );

        });

    }

Example log data

[2017-12-04 18:57:33] local.INFO: select * from `tasks`  

[2017-12-04 18:57:33] local.INFO: select count(*) as aggregate from `tasks`  

[2017-12-04 18:57:33] local.INFO: select * from `tasks` limit 15 offset 0  

[2017-12-04 18:57:33] local.INFO: select * from `tasks`  

[2017-12-04 18:57:33] local.INFO: select count(*) as aggregate from `tasks`  

[2017-12-04 18:57:33] local.INFO: select * from `tasks` limit 15 offset 0  

I hope you like this Post, Please feel free to comment below, your suggestion and problems if you face - we are here to solve your problems.

Search In multidimensional array by keys value

// Array representing a possible record set returned from a database

$records = array(

    array(

        'id' => 2135,

        'first_name' => 'John',

        'last_name' => 'Doe',

    ),

    array(

        'id' => 3245,

        'first_name' => 'Sally',

        'last_name' => 'Smith',

    ),

    array(

        'id' => 5342,

        'first_name' => 'Jane',

        'last_name' => 'Jones',

    ),

    array(

        'id' => 5623,

        'first_name' => 'Peter',

        'last_name' => 'Doe',

    )

);

$id = array_search(5623, array_column($records, 'id'));

print_r($records[$id]);

Reference :

1) https://stackoverflow.com/questions/6661530/php-multidimensional-array-search-by-value
2) https://vijayasankarn.wordpress.com/2017/02/20/array_unique-for-multidimensional-array/

read and write into file using Piping in NodeJs

var fs = require('fs');

var stream = fs.createReadStream('data.json'),
writable = fs.createWriteStream('data_copy.json');

stream.pipe(process.stdout);

stream.pipe(writable);