mnabialek / laravel-sql-logger

src/Formatter.php

<?php

namespace Mnabialek\LaravelSqlLogger;

use Carbon\Carbon;
use Illuminate\Container\Container;
use Mnabialek\LaravelSqlLogger\Objects\Concerns\ReplacesBindings;
use Mnabialek\LaravelSqlLogger\Objects\SqlQuery;

class Formatter
{
    use ReplacesBindings;

    /**
     * @var Container
     */
    private $app;

    /**
     * @var Config
     */
    private $config;

    /**
     * Formatter constructor.
     *
     * @param Container $app
     * @param Config $config
     */
    public function __construct(Container $app, Config $config)
    {
        $this->app = $app;
        $this->config = $config;
    }

    /**
     * Get formatted line.
     *
     * @param SqlQuery $query
     *
     * @return string
     */
    public function getLine(SqlQuery $query)
    {
        $replace = [
            '[origin]' => $this->originLine(),
            '[query_nr]' => $query->number(),
            '[datetime]' => Carbon::now()->toDateTimeString(),
            '[query_time]' => $this->time($query->time()),
            '[query]' => $this->queryLine($query),
            '[separator]' => $this->separatorLine(),
            '\n' => PHP_EOL,
        ];

        return str_replace(array_keys($replace), array_values($replace), $this->config->entryFormat());
    }

    /**
     * Format time.
     *
     * @param float $time
     *
     * @return string
     */
    protected function time($time)
    {
        return $this->config->useSeconds() ? ($time / 1000.0) . 's' : $time . 'ms';
    }

    /**
     * Get origin line.
     *
     * @return string
     */
    protected function originLine()
    {
        return 'Origin ' . ($this->app->runningInConsole()

The method runningInConsole() does not exist on Illuminate\Container\Container. Are you sure you never get this type here, but always one of the subclasses?

                ? '(console): ' . $this->getArtisanLine()
                : '(request): ' . $this->getRequestLine());
    }

    /**
     * Get query line.
     *
     * @param SqlQuery $query
     *
     * @return string
     */
    protected function queryLine(SqlQuery $query)
    {
        return $this->format($query->get()) . ';';
    }

    /**
     * Get Artisan line.
     *
     * @return string
     */
    protected function getArtisanLine()
    {
        $command = $this->app['request']->server('argv', []);

        if (is_array($command)) {
            $command = implode(' ', $command);
        }

        return $command;
    }

    /**
     * Get request line.
     *
     * @return string
     */
    protected function getRequestLine()
    {
        return $this->app['request']->method() . ' ' . $this->app['request']->fullUrl();
    }

    /**
     * Get separator line.
     *
     * @return string
     */
    protected function separatorLine()
    {
        return '/*' . str_repeat('=', 50) . '*/';
    }

    /**
     * Format given query.
     *
     * @param string $query
     *
     * @return string
     */
    protected function format($query)
    {
        return $this->removeNewLines($query);
    }

    /**
     * Remove new lines from SQL to keep it in single line if possible.
     *
     * @param string $sql
     *
     * @return string
     */
    protected function removeNewLines($sql)
    {
        if (! $this->config->newLinesToSpaces()) {
            return $sql;
        }

        return preg_replace($this->wrapRegex($this->notInsideQuotes('\v', false)), ' ', $sql);
    }
}