Socialblue\LaravelQueryAdviser\Http\Controllers\QueryController

Complexity

Total Complexity

4

Size/Duplication

Total Lines	32
Duplicated Lines	0 %

Importance

Changes	8
Bugs	0	Features	5

2 Methods

Rating	Name	Duplication	Size	Complexity
A	explain()	0	12	2
A	exec()	0	10	2

<?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

The parameter $request is not used and could be removed.

    {
        $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

The parameter $request is not used and could be removed.

    {
        $data = Cache::get($sessionKey);
        if (isset($data[$time][$timeKey])) {
            $query = $data[$time][$timeKey];
            return QueryBuilderHelper::analyze($query['rawSql'], $query['bindings']);
        }

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