Listen query in Test

TestCase.php

<?php
function listenQuery($checkTrace = false): void
{
    DB::listen(function ($query) use ($checkTrace) {
        $sql = $query->sql;
        foreach ($query->bindings as $binding) {
            $value = is_numeric($binding) ? $binding : "'" . $binding . "'";
            $sql = preg_replace('/\?/', $value, $sql, 1);
        }

        dump($sql); // Dump the SQL query with bindings

        if($checkTrace){
            // Lấy stack trace
            $trace = debug_backtrace(DEBUG_BACKTRACE_IGNORE_ARGS, 50);
            $relevantTrace = [];
            // Lọc stack trace để chỉ lấy những dòng có liên quan
            foreach ($trace as $traceLine) {
                if (isset($traceLine['file']) && strpos($traceLine['file'], 'vendor') === false) {
                    $relevantTrace[] = [
                        'file' => $traceLine['file'],
                        'line' => $traceLine['line'],
                        'function' => $traceLine['function'],
                    ];
                }
            }

            // Dump the relevant stack tracemp the SQL query with bindings
            dump($relevantTrace);
        }
    });
}