Lagdo\DbAdmin\Db\Facades\Traits\TableExportTrait

Complexity

Total Complexity

19

Size/Duplication

Total Lines	166
Duplicated Lines	0 %

Importance

Changes

0

9 Methods

Rating	Name	Duplication	Size	Complexity
A	getSelectFormatValues()	0	3	1
A	getSelectTableValues()	0	3	1
A	getDbTables()	0	16	2
B	getBaseOptions()	0	69	6
A	getDataRowOptions()	0	18	2
A	getSelectDatabaseValues()	0	3	1
A	getSelectDataValues()	0	5	2
A	getSelectOutputValues()	0	3	1
A	getDatabases()	0	16	3

<?php

namespace Lagdo\DbAdmin\Db\Facades\Traits;

use function compact;
use function preg_replace;

trait TableExportTrait
{
    public function getSelectOutputValues(): array
    {
        return $this->admin->dumpOutput();
    }

    public function getSelectFormatValues(): array
    {
        return $this->admin->dumpFormat();
    }

    public function getSelectDatabaseValues(): array
    {
        return ['', 'USE', 'DROP+CREATE', 'CREATE'];
    }

    public function getSelectTableValues(): array
    {
        return ['', 'DROP+CREATE', 'CREATE'];
    }

    public function getSelectDataValues(): array
    {
        //! use insertOrUpdate() in all drivers
        return $this->driver->jush() !== 'sql' ? ['', 'TRUNCATE+INSERT', 'INSERT'] :
            ['', 'TRUNCATE+INSERT', 'INSERT', 'INSERT+UPDATE'];
    }

    private function getDataRowOptions(string $database, string $table): array
    {
        // \parse_str($_COOKIE['adminer_export'], $options);
        // if(!$options) {
        $options = [
            'output' => 'open',
            'format' => 'sql',
            'db_style' => ($database !== '' ? '' : 'CREATE'),
            'table_style' => 'DROP+CREATE',
            'data_style' => 'INSERT',
            'types' => true,
        ];
        // }
        // if(!isset($options['events'])) { // backwards compatibility
        $options['routines'] = $options['events'] = ($table === '');
        $options['triggers'] = true; // $options['table_style']; // Is a boolean
        // }
        return $options;
    }

    /**
     * @param string $database
     * @param string $table
     *
     * @return array
     */
    private function getBaseOptions(string $database, string $table): array
    {
        // From dump.inc.php
        $row = $this->getDataRowOptions($database, $table);
        $options = [
            'output' => [
                'label' => $this->utils->trans->lang('Output'),
                'options' => $this->getSelectOutputValues(),
                'value' => $row['output'],
            ],
            'format' => [
                'label' => $this->utils->trans->lang('Format'),
                'options' => $this->getSelectFormatValues(),
                'value' => $row['format'],
            ],
            'table_style' => [
                'label' => $this->utils->trans->lang('Table'),
                'options' => $this->getSelectTableValues(),
                'value' => $row['table_style'],
            ],
            'auto_increment' => [
                'label' => $this->utils->trans->lang('Auto Increment'),
                'value' => 1,
                'checked' => $row['autoIncrement'] ?? true,
            ],
            'data_style' => [
                'label' => $this->utils->trans->lang('Data'),
                'options' => $this->getSelectDataValues(),
                'value' => $row['data_style'],
            ],
        ];
        if ($this->driver->support('trigger')) {
            $options['triggers'] = [
                'label' => $this->utils->trans->lang('Triggers'),
                'value' => 1,
                'checked' => $row['triggers'],
            ];
        }
        if ($this->driver->jush() === 'sqlite') {
            return $options;
        }

        $options['db_style'] = [
            'label' => $this->utils->trans->lang('Database'),
            'options' => $this->getSelectDatabaseValues(),
            'value' => $row['db_style'],
        ];
        if ($this->driver->support('type')) {
            $options['types'] = [
                'label' => $this->utils->trans->lang('Types'),
                'value' => 1,
                'checked' => $row['types'],
            ];
        }
        if ($this->driver->support('routine')) {
            $options['routines'] = [
                'label' => $this->utils->trans->lang('Routines'),
                'value' => 1,
                'checked' => $row['routines'],
            ];
        }
        if ($this->driver->support('event')) {
            $options['events'] = [
                'label' => $this->utils->trans->lang('Events'),
                'value' => 1,
                'checked' => $row['events'],
            ];
        }
        return $options;
    }

    /**
     * @return array
     */
    private function getDbTables(): array
    {
        $tables = [
            'headers' => [$this->utils->trans->lang('Tables'), $this->utils->trans->lang('Data')],
            'details' => [],
        ];
        $tables_list = $this->driver->tables();
        foreach ($tables_list as $name => $type) {
            $prefix = preg_replace('~_.*~', '', $name);
            //! % may be part of table name
            // $checked = ($TABLE == '' || $TABLE == (\substr($TABLE, -1) == '%' ? "$prefix%" : $name));
            // $results['prefixes'][$prefix]++;

            $tables['details'][] = compact('prefix', 'name', 'type'/*, 'checked'*/);
        }
        return $tables;
    }

    /**
     * @return array
     */
    private function getDatabases(): array
    {
        $databases = [
            'headers' => [$this->utils->trans->lang('Database'), $this->utils->trans->lang('Data')],
            'details' => [],
        ];
        $databases_list = $this->driver->databases(false) ?? [];
        foreach ($databases_list as $name) {
            if (!$this->driver->isInformationSchema($name)) {
                $prefix = preg_replace('~_.*~', '', $name);
                // $results['prefixes'][$prefix]++;

                $databases['details'][] = compact('prefix', 'name');
            }
        }
        return $databases;
    }
}