lekoala / silverstripe-debugbar

code/DebugBarUtils.php

<?php

namespace LeKoala\DebugBar;

use SilverStripe\ORM\DataList;
use SilverStripe\ORM\DB;

class DebugBarUtils
{

    /**
     * Format a sql query string using available formatters.
     * If no formatters are available, simply return the string as is.
     * Highlighting is used if not in cli context
     */
    public static function formatSql(string $query): string
    {
        if (class_exists(\Doctrine\SqlFormatter\SqlFormatter::class)) {
            return (new \Doctrine\SqlFormatter\SqlFormatter())->format($query);
        }
        if (class_exists(\SqlFormatter::class)) {

The type SqlFormatter was not found. Maybe you did not declare it correctly or list all dependencies?

            return \SqlFormatter::format($query, !self::isCli());
        }
        if (class_exists(\SilverStripe\View\Parsers\SQLFormatter::class)) {
            $method = self::isCli() ? 'formatPlain' : 'formatHTML';
            $formatter = new \SilverStripe\View\Parsers\SQLFormatter;
            return $formatter->$method($query);
        }
        return $query;
    }

    /**
     * Show the underlying sql query for a list
     * @param DataList $list
     * @param bool $inline Inlines paramters
     * @param bool $noQuotes Remove ANSI Quotes
     * @return string
     */
    public static function formatListQuery(DataList $list, bool $inline = true, bool $noQuotes = false): string
    {
        $parameters = [];
        $formatted = self::formatSql($list->sql($parameters));
        if ($inline) {
            $formatted = DB::inline_parameters($formatted, $parameters);
        }
        if ($noQuotes) {
            $formatted = str_replace('"', '', $formatted);
        }
        return $formatted;
    }

    public static function isCli(): bool
    {
        return in_array(PHP_SAPI ?: '', ['cli', 'phpdbg']) || !http_response_code();
    }
}