Lagdo\DbAdmin\Db\Driver\Facades\TableTrait

Complexity

Total Complexity

13

Size/Duplication

Total Lines	179
Duplicated Lines	0 %

Importance

Changes

0

12 Methods

Rating	Name	Duplication	Size	Complexity
A	getTableInfo()	0	8	1
A	alterTable()	0	6	1
A	tableFacade()	0	3	1
A	getTableIndexes()	0	5	1
A	getTableData()	0	12	2
A	createTable()	0	6	1
A	getTableTriggers()	0	5	1
A	getFieldTypes()	0	5	1
A	dropTable()	0	5	1
A	getTableFields()	0	5	1
A	getTableForeignKeys()	0	5	1
A	getTableField()	0	4	1

<?php

namespace Lagdo\DbAdmin\Db\Driver\Facades;

use Lagdo\DbAdmin\Driver\Entity\TableFieldEntity;
use Exception;

/**
 * Facade to table functions
 */
trait TableTrait
{
    use AbstractTrait;

    /**
     * Get the facade
     *
     * @return TableFacade
     */
    protected function tableFacade(): TableFacade
    {
        return $this->di()->g(TableFacade::class);
    }

    /**
     * Get details about a table or a view
     *
     * @param string $table     The table name
     *
     * @return array
     */
    public function getTableInfo(string $table): array
    {
        $this->connectToSchema();
        $this->breadcrumbs(true)
            ->item($this->utils->trans->lang('Tables'))
            ->item("<i><b>$table</b></i>");
        $this->utils->input->table = $table;
        return $this->tableFacade()->getTableInfo($table);
    }

    /**
     * Get details about a table or a view
     *
     * @param string $table The table name
     *
     * @return array
     * @throws Exception
     */
    public function getTableFields(string $table): array
    {
        $this->connectToSchema();
        $this->utils->input->table = $table;
        return $this->tableFacade()->getTableFields($table);
    }

    /**
     * Get the indexes of a table
     *
     * @param string $table     The table name
     *
     * @return array|null
     */
    public function getTableIndexes(string $table): ?array
    {
        $this->connectToSchema();
        $this->utils->input->table = $table;
        return $this->tableFacade()->getTableIndexes($table);
    }

    /**
     * Get the foreign keys of a table
     *
     * @param string $table     The table name
     *
     * @return array|null
     */
    public function getTableForeignKeys(string $table): ?array
    {
        $this->connectToSchema();
        $this->utils->input->table = $table;
        return $this->tableFacade()->getTableForeignKeys($table);
    }

    /**
     * Get the triggers of a table
     *
     * @param string $table     The table name
     *
     * @return array|null
     */
    public function getTableTriggers(string $table): ?array
    {
        $this->connectToSchema();
        $this->utils->input->table = $table;
        return $this->tableFacade()->getTableTriggers($table);
    }

    /**
     * Get required data for create/update on tables
     *
     * @param string $table The table name
     *
     * @return array
     * @throws Exception
     */
    public function getTableData(string $table = ''): array
    {
        $this->connectToSchema();
        $this->breadcrumbs(true)->item($this->utils->trans->lang('Tables'));
        if (!$table) {
            $this->breadcrumbs()->item($this->utils->trans->lang('Create table'));
        } else {
            $this->breadcrumbs()->item("<i><b>$table</b></i>")
                ->item($this->utils->trans->lang('Alter table'));
        }
        $this->utils->input->table = $table;
        return $this->tableFacade()->getTableData($table);
    }

    /**
     * Get fields for a new column
     *
     * @return TableFieldEntity
     */
    public function getTableField(): TableFieldEntity
    {
        $this->connectToSchema();
        return $this->tableFacade()->getTableField();
    }

    /**
     * Get field types
     *
     * @param string $type  The type name
     *
     * @return array
     */
    public function getFieldTypes(string $type = ''): array
    {
        // Must be called after the connection to a schema is made.
        // $this->connectToSchema();
        return $this->tableFacade()->getFieldTypes($type);
    }

    /**
     * Create a table
     *
     * @param array  $values    The table values
     *
     * @return array|null
     */
    public function createTable(array $values): ?array
    {
        $this->connectToSchema();
        $this->utils->input->table = $values['name'];
        $this->utils->input->values = $values;
        return $this->tableFacade()->createTable($values);
    }

    /**
     * Alter a table
     *
     * @param string $table The table name
     * @param array $values The table values
     *
     * @return array|null
     * @throws Exception
     */
    public function alterTable(string $table, array $values): ?array
    {
        $this->connectToSchema();
        $this->utils->input->table = $table;
        $this->utils->input->values = $values;
        return $this->tableFacade()->alterTable($table, $values);
    }

    /**
     * Drop a table
     *
     * @param string $table     The table name
     *
     * @return array|null
     */
    public function dropTable(string $table): ?array
    {
        $this->connectToSchema();
        $this->utils->input->table = $table;
        return $this->tableFacade()->dropTable($table);
    }
}