Terranet\Administrator\Schema

Complexity

Total Complexity

7

Size/Duplication

Total Lines	101
Duplicated Lines	0 %

Test Coverage

Coverage

0%

Importance

Changes	2
Bugs	0	Features	0

7 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	3	1
A	indexedColumns()	0	11	1
A	indexes()	0	4	1
A	lifetime()	0	3	1
A	getManager()	0	3	1
A	foreignKeys()	0	4	1
A	columns()	0	12	1

<?php

namespace Terranet\Administrator;

use Cache;
use Carbon\Carbon;
use DateTime;
use Doctrine\DBAL\Schema\MySqlSchemaManager;

class Schema
{
    /**
     * @var MySqlSchemaManager
     */
    private $manager;

    public function __construct($manager)
    {
        $this->manager = $manager;
    }

    /**
     * Get list of indexed columns.
     *
     * @param $table
     *
     * @return array
     */
    public function indexedColumns($table)
    {
        return Cache::remember("{$table}_indexed_columns", $this->lifetime(), function () use ($table) {
            $indexedColumns = array_reduce($this->indexes($table), function ($indexedColumns, $index) {
                return array_merge($indexedColumns, $index->getColumns());
            }, []);

            $indexedColumns = array_unique($indexedColumns);
            sort($indexedColumns);

            return $indexedColumns;
        });
    }

    /**
     * List table indexes.
     *
     * @param $table
     *
     * @return \Doctrine\DBAL\Schema\Index[]
     */
    public function indexes($table)
    {
        return Cache::remember("{$table}_indexes", $this->lifetime(), function () use ($table) {
            return $this->manager->listTableIndexes($table);
        });
    }

    /**
     * List table columns.
     *
     * @param $table
     *
     * @return \Doctrine\DBAL\Schema\Column[]
     */
    public function columns($table)
    {
        return Cache::remember("{$table}_columns", $this->lifetime(), function () use ($table) {
            $columns = $this->manager->listTableColumns($table);
            $keys = array_keys($columns);
            $vals = array_values($columns);

            $keys = array_map(function ($key) {
                return trim(str_replace(['`', '"'], '', $key));
            }, $keys);

            return array_combine($keys, $vals);
        });
    }

    /**
     * list table foreign keys.
     *
     * @param $table
     *
     * @return mixed
     */
    public function foreignKeys($table)
    {
        return Cache::remember("{$table}_foreign_keys", $this->lifetime(), function () use ($table) {
            return $this->manager->listTableForeignKeys($table);
        });
    }

    /**
     * @return MySqlSchemaManager
     */
    public function getManager()
    {
        return $this->manager;
    }

    /**
     * Cache lifetime.
     *
     * @param  int  $seconds
     *
     * @return DateTime
     */
    protected function lifetime($seconds = 300)
    {
        return Carbon::now()->addSeconds($seconds);
    }
}