TableExportTrait::getBaseOptions() - Code Metrics - lagdo/jaxon-dbadmin - Measure and Improve Code Quality continuously with Scrutinizer

TableExportTrait::getBaseOptions() B
last analyzed 2025-12-04 14:58 UTC

↳ Parent: TableExportTrait

Complexity

Conditions	6
Paths	18

Size

Total Lines	69
Code Lines	49

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
cc	6
eloc	49
c	0
b	0
f	0
nc	18
nop	2
dl	0
loc	69
rs	8.4905

How to fix Long Method

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


1			<?php
2
3			namespace Lagdo\DbAdmin\Db\Facades\Traits;
4
5			use function compact;
6			use function preg_replace;
7
8			trait TableExportTrait
9			{
10			public function getSelectOutputValues(): array
11			{
12			return $this->admin->dumpOutput();
13			}
14
15			public function getSelectFormatValues(): array
16			{
17			return $this->admin->dumpFormat();
18			}
19
20			public function getSelectDatabaseValues(): array
21			{
22			return ['', 'USE', 'DROP+CREATE', 'CREATE'];
23			}
24
25			public function getSelectTableValues(): array
26			{
27			return ['', 'DROP+CREATE', 'CREATE'];
28			}
29
30			public function getSelectDataValues(): array
31			{
32			//! use insertOrUpdate() in all drivers
33			return $this->driver->jush() !== 'sql' ? ['', 'TRUNCATE+INSERT', 'INSERT'] :
34			['', 'TRUNCATE+INSERT', 'INSERT', 'INSERT+UPDATE'];
35			}
36
37			private function getDataRowOptions(string $database, string $table): array
38			{
39			// \parse_str($_COOKIE['adminer_export'], $options);
40			// if(!$options) {
41			$options = [
42			'output' => 'open',
43			'format' => 'sql',
44			'db_style' => ($database !== '' ? '' : 'CREATE'),
45			'table_style' => 'DROP+CREATE',
46			'data_style' => 'INSERT',
47			'types' => true,
48			];
49			// }
50			// if(!isset($options['events'])) { // backwards compatibility
51			$options['routines'] = $options['events'] = ($table === '');
52			$options['triggers'] = true; // $options['table_style']; // Is a boolean
53			// }
54			return $options;
55			}
56
57			/**
58			* @param string $database
59			* @param string $table
60			*
61			* @return array
62			*/
63			private function getBaseOptions(string $database, string $table): array
64			{
65			// From dump.inc.php
66			$row = $this->getDataRowOptions($database, $table);
67			$options = [
68			'output' => [
69			'label' => $this->utils->trans->lang('Output'),
70			'options' => $this->getSelectOutputValues(),
71			'value' => $row['output'],
72			],
73			'format' => [
74			'label' => $this->utils->trans->lang('Format'),
75			'options' => $this->getSelectFormatValues(),
76			'value' => $row['format'],
77			],
78			'table_style' => [
79			'label' => $this->utils->trans->lang('Table'),
80			'options' => $this->getSelectTableValues(),
81			'value' => $row['table_style'],
82			],
83			'auto_increment' => [
84			'label' => $this->utils->trans->lang('Auto Increment'),
85			'value' => 1,
86			'checked' => $row['autoIncrement'] ?? true,
87			],
88			'data_style' => [
89			'label' => $this->utils->trans->lang('Data'),
90			'options' => $this->getSelectDataValues(),
91			'value' => $row['data_style'],
92			],
93			];
94			if ($this->driver->support('trigger')) {
95			$options['triggers'] = [
96			'label' => $this->utils->trans->lang('Triggers'),
97			'value' => 1,
98			'checked' => $row['triggers'],
99			];
100			}
101			if ($this->driver->jush() === 'sqlite') {
102			return $options;
103			}
104
105			$options['db_style'] = [
106			'label' => $this->utils->trans->lang('Database'),
107			'options' => $this->getSelectDatabaseValues(),
108			'value' => $row['db_style'],
109			];
110			if ($this->driver->support('type')) {
111			$options['types'] = [
112			'label' => $this->utils->trans->lang('Types'),
113			'value' => 1,
114			'checked' => $row['types'],
115			];
116			}
117			if ($this->driver->support('routine')) {
118			$options['routines'] = [
119			'label' => $this->utils->trans->lang('Routines'),
120			'value' => 1,
121			'checked' => $row['routines'],
122			];
123			}
124			if ($this->driver->support('event')) {
125			$options['events'] = [
126			'label' => $this->utils->trans->lang('Events'),
127			'value' => 1,
128			'checked' => $row['events'],
129			];
130			}
131			return $options;
132			}
133
134			/**
135			* @return array
136			*/
137			private function getDbTables(): array
138			{
139			$tables = [
140			'headers' => [$this->utils->trans->lang('Tables'), $this->utils->trans->lang('Data')],
141			'details' => [],
142			];
143			$tables_list = $this->driver->tables();
144			foreach ($tables_list as $name => $type) {
145			$prefix = preg_replace('~_.*~', '', $name);
146			//! % may be part of table name
147			// $checked = ($TABLE == '' \|\| $TABLE == (\substr($TABLE, -1) == '%' ? "$prefix%" : $name));
148			// $results['prefixes'][$prefix]++;
149
150			$tables['details'][] = compact('prefix', 'name', 'type'/, 'checked'/);
151			}
152			return $tables;
153			}
154
155			/**
156			* @return array
157			*/
158			private function getDatabases(): array
159			{
160			$databases = [
161			'headers' => [$this->utils->trans->lang('Database'), $this->utils->trans->lang('Data')],
162			'details' => [],
163			];
164			$databases_list = $this->driver->databases(false) ?? [];
165			foreach ($databases_list as $name) {
166			if (!$this->driver->isInformationSchema($name)) {
167			$prefix = preg_replace('~_.*~', '', $name);
168			// $results['prefixes'][$prefix]++;
169
170			$databases['details'][] = compact('prefix', 'name');
171			}
172			}
173			return $databases;
174			}
175			}
176

lagdo / jaxon-dbadmin

TableExportTrait::getBaseOptions() B last analyzed 2025-12-04 14:58 UTC

Complexity

Size

Duplication

Importance

How to fix Long Method

Long Method

Duplication Side-by-Side

Filter issues like

TableExportTrait::getBaseOptions() B
last analyzed 2025-12-04 14:58 UTC