SenseServiceProvider::explainQuery() - Code Metrics - Inspection of "Merge pull request #19 from cybercog/feature/db-qu..." - cybercog/laravel-sense - Measure and Improve Code Quality continuously with Scrutinizer

Completed
Push — master ( 78f962...a745ae )

by Anton
created 2018-10-07 17:57 UTC
SenseServiceProvider::explainQuery() A

↳ Parent: SenseServiceProvider
Complexity

Conditions	2
Paths	2
Size

Total Lines	17
Code Lines	10
Duplication

Lines	0
Ratio	0 %
Importance

Changes
Metric	Value
cc	2
eloc	10
c	0
b	0
f	0
nc	2
nop	2
dl	0
loc	17
rs	9.9332
<?php

/*
 * This file is part of Laravel Sense.
 *
 * (c) Anton Komarev <[email protected]>
 *
 * For the full copyright and license information, please view the LICENSE
 * file that was distributed with this source code.
 */

declare(strict_types=1);

namespace Cog\Laravel\Sense\Providers;

use Cog\Laravel\Sense\Db\Query\Models\Query;
use Cog\Laravel\Sense\Request\Id;
use Cog\Laravel\Sense\Request\Models\Request;
use Cog\Laravel\Sense\RequestSummary\Models\RequestSummary;
use Cog\Laravel\Sense\Statement\Models\Statement;
use Cog\Laravel\Sense\StatementSummary\Models\StatementSummary;
use Cog\Laravel\Sense\Url\Models\Url;
use Illuminate\Database\Events\QueryExecuted;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Route;
use Illuminate\Support\ServiceProvider;
use PDO;

class SenseServiceProvider extends ServiceProvider
{
    public function boot(): void
    {
        $this->registerDbConnection();
        $this->registerRoutes();
        $this->registerResources();
        $this->registerSensors();
    }

    public function register(): void
    {
        $this->configure();
        $this->offerPublishing();
    }

    // TODO: Remove this hacky solution
    protected function registerDbConnection(): void
    {
        if (is_null($config = config('database.connections.sense'))) {
            $defaultConnection = config('database.default');
            if (is_null($fallbackConfig = config("database.connections.{$defaultConnection}"))) {
                throw new \Exception('Database connection [sense] has not been configured.');
            }
            config(['database.connections.sense' => $fallbackConfig]);
        }
    }

    /**
     * Register the Sense routes.
     *
     * @return void
     */
    protected function registerRoutes(): void
    {
        Route::group([
            'prefix' => config('sense.uri', 'sense'),
            'namespace' => 'Cog\Laravel\Sense\Http\Controllers',
            'middleware' => config('sense.middleware', 'web'),
        ], function () {
            $this->loadRoutesFrom(__DIR__ . '/../../routes/web.php');
        });
    }

    /**
     * Register the Sense resources.
     *
     * @return void
     */
    protected function registerResources(): void
    {
        $this->loadViewsFrom(__DIR__ . '/../../resources/views', 'sense');
    }

    /**
     * Setup the configuration for Sense.
     *
     * @return void
     */
    protected function configure(): void
    {
        $this->mergeConfigFrom(
            __DIR__ . '/../../config/sense.php', 'sense'
        );
    }

    /**
     * Setup the resource publishing groups for Sense.
     *
     * @return void
     */
    protected function offerPublishing(): void
    {
        if ($this->app->runningInConsole()) {
            $migrationsPath = __DIR__ . '/../../database/migrations';

            $this->publishes([
                $migrationsPath => database_path('migrations'),
            ], 'sense-migrations');

            $this->publishes([
                __DIR__ . '/../../config/sense.php' => config_path('sense.php'),
            ], 'sense-config');

            $this->loadMigrationsFrom($migrationsPath);
        }
    }

    private function registerSensors(): void
    {
        if ($this->isSenseDisabled()) {
            return;
        }

        /** @var \Cog\Laravel\Sense\Url\Models\Url $url */
        $url = Url::query()->firstOrCreate([
            'address' => request()->fullUrl(),
        ]);

        /** @var \Cog\Laravel\Sense\Request\Models\Request $request */
        $request = $url->requests()->create([
            'correlation_id' => Id::make(),
            'method' => request()->method(),
            // TODO: Add headers
            // TODO: Add body
        ]);
        $request->summary()->create();

        DB::listen(function (QueryExecuted $query) use ($request) {
            if ($this->isQueryShouldBeStored($query)) {
                $this->storeStatement($request, $query);
                $this->updateRequestSummary($request->getAttribute('summary'), $query);
            }
        });
    }

    private function storeStatement(Request $request, QueryExecuted $query): void
    {
        /** @var \Cog\Laravel\Sense\Statement\Models\Statement $statement */
        $statement = Statement::query()->firstOrCreate([
            'value' => $query->sql,
        ]);

        /** @var \Cog\Laravel\Sense\Db\Query\Models\Query $queryModel */
        $queryModel = $request->dbQueries()->create([
            'statement_id' => $statement->getKey(),
            'connection' => $query->connectionName,
            'sql' => $this->buildSqlString($query),
            'bindings' => $query->bindings,
            'time' => $query->time,
        ]);

        $this->explainQuery($queryModel, $query);

        /** @var \Cog\Laravel\Sense\StatementSummary\Models\StatementSummary $summary */
        $summary = $statement->summaries()
            ->where([
                'request_id' => $request->getKey(),
                'connection' => $query->connectionName,
            ])->first();
        if (!$summary) {

            $summary = $statement->summaries()->create([
                'request_id' => $request->getKey(),
                'connection' => $query->connectionName,
                'time_min' => 0.0,
                'time_max' => 0.0,
                'time_total' => 0.0,
            ]);
        }
        $this->updateStatementSummary($summary, $query);
    }

    private function updateStatementSummary(StatementSummary $summary, QueryExecuted $query): void
    {
        if ($summary->getAttribute('time_min') === 0.0 || $summary->getAttribute('time_min') > $query->time) {
            $summary->setAttribute('time_min', $query->time);
        }
        if ($summary->getAttribute('time_max') < $query->time) {
            $summary->setAttribute('time_max', $query->time);
        }
        $summary->setAttribute('time_total', $summary->getAttribute('time_total') + $query->time);
        $summary->setAttribute('queries_count', $summary->getAttribute('queries_count') + 1);
        $summary->save();
    }

    private function updateRequestSummary(RequestSummary $requestSummary, QueryExecuted $query): void
    {
        $requestSummary->setAttribute('time_total', $requestSummary->getAttribute('time_total') + $query->time);
        $requestSummary->setAttribute('queries_count', $requestSummary->getAttribute('queries_count') + 1);
        $requestSummary->save();
    }

    private function buildSqlString(QueryExecuted $query): string
    {
        $pdo = $query->connection->getPdo();
        $sql = $query->sql;

        foreach ($query->bindings as $key => $binding) {
            // This regex matches placeholders only, not the question marks,
            // nested in quotes, while we iterate through the bindings
            // and substitute placeholders by suitable values.
            $regex = is_numeric($key)
                ? "/\?(?=(?:[^'\\\']*'[^'\\\']*')*[^'\\\']*$)/"
                : "/:{$key}(?=(?:[^'\\\']*'[^'\\\']*')*[^'\\\']*$)/";
            $sql = preg_replace($regex, $pdo->quote((string) $binding), $sql, 1);
        }

        return $sql;
    }

    private function explainQuery(Query $queryModel, QueryExecuted $query): void
    {
        $explainTypes = [
            'select',
//            'insert',
//            'update',
//            'delete',
        ];
        if (starts_with(strtolower($query->sql), $explainTypes)) {
            $pdo = $query->connection->getPdo();
            $bindings = $query->connection->prepareBindings($query->bindings);
            $statement = $pdo->prepare('EXPLAIN ' . $query->sql);
            $statement->execute($bindings);
            $explanation = $statement->fetchAll(PDO::FETCH_CLASS);

            $queryModel->explanation()->create([
                'result' => $explanation,
            ]);
        }
    }

    private function isQueryShouldBeStored(QueryExecuted $query): bool
    {
        return $query->connectionName !== 'sense';
    }

    private function isSenseDisabled(): bool
    {
        $uri = config('sense.uri', 'sense');

        return $this->app->environment() !== 'local'
            || $this->app->runningInConsole()
            || request()->is($uri, "{$uri}/*")
            || request()->is($uri, /** @scrutinizer ignore-type */ "{$uri}/*")
            || request()->method() === 'OPTIONS';
    }
}

cybercog / laravel-sense

Push — master ( 78f962...a745ae )

SenseServiceProvider::explainQuery() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like
