QueryController::exec() - Code Metrics - Inspection of "Merge pull request #119 from socialblue/develop" - socialblue/laravel-query-adviser - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — master ( 9d700f...b6792d )

by Mark

created 2022-09-23 07:09 UTC

QueryController::exec() A

↳ Parent: QueryController

Complexity

Conditions	2
Paths	2

Size

Total Lines	10
Code Lines	5

Duplication

Lines	0
Ratio	0 %

Importance

Changes	2
Bugs	0	Features	2

Metric	Value
eloc	5
c	2
b	0
f	2
dl	0
loc	10
rs	10
cc	2
nc	2
nop	4

<?php

namespace Socialblue\LaravelQueryAdviser\Http\Controllers;

use Illuminate\Http\Request;
use Illuminate\Routing\Controller;
use Illuminate\Support\Facades\Cache;
use Illuminate\Support\Facades\DB;
use Socialblue\LaravelQueryAdviser\Helper\QueryBuilderHelper;

/**
 * Class QueryController
 * @package Socialblue\LaravelQueryAdviser\Http\Controllers
 */
class QueryController extends Controller
{
    /**
     * Execute query
     */
    public function exec(string $sessionKey, string $time, string $timeKey, Request $request): array
    public function exec(string $sessionKey, string $time, string $timeKey, /** @scrutinizer ignore-unused */ Request $request): array
    {
        $data = Cache::get($sessionKey);

        if (isset($data[$time][$timeKey])) {
            $query = $data[$time][$timeKey];
            return DB::connection()->select($query['rawSql'], $query['bindings']);
        }

        return [];
    }

    /**
     * Use explain for query
     */
    public function explain(string $sessionKey, string $time, string $timeKey, Request $request): array
    public function explain(string $sessionKey, string $time, string $timeKey, /** @scrutinizer ignore-unused */ Request $request): array
    {
        $data = Cache::get($sessionKey);
        if (isset($data[$time][$timeKey])) {
            $query = $data[$time][$timeKey];
            return QueryBuilderHelper::analyze($query['rawSql'], $query['bindings']);
        }

        return [
            'queryParts' => "",
            'query' => "",
            'optimized' => "",
        ];
    }
}


socialblue / laravel-query-adviser

Push — master ( 9d700f...b6792d )

QueryController::exec() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like