App\Http\Middleware\CheckSite::handle()

Complexity

Conditions	5
Paths	2

Size

Total Lines	31
Code Lines	15

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

<?php
    public function handle($request, Closure $next)
    {
        //check for database connection every 5 minutes
        $time = now()->addMinutes(5);
        $error = null;

        //dev
        // cache()->forget('check');

        if (!Cache::has('check')) {
            Cache::remember('check', $time, function () use ($error) {
                try {
                    DB::connection()->table(DB::raw('settings'))->first([DB::raw(1)]);
                    if (!DB::connection()->table(DB::raw('settings'))->count()) {
                        $error = __('api.db_data');
                    }
                } catch (\PDOException $e) {
                    $error = __('api.db_connect');
                }

                //show error
                if (isset($error)) {
                    cache()->forget('check');
                    dd($error);
                }

                return true;
            });
        }

        return $next($request);
    }