AdminerForeignSystem - Code Metrics - XoopsModules25x/adminer - Measure and Improve Code Quality continuously with Scrutinizer

AdminerForeignSystem A
last analyzed 2016-07-19 20:37 UTC

↳ Parent: Project

Complexity

Total Complexity

Size/Duplication

Total Lines	78
Duplicated Lines	11.54 %

Coupling/Cohesion

Components	0
Dependencies	0

Importance

Changes	2
Bugs	0	Features	0

Metric	Value
c	2
b	0
f	0
dl	9
loc	78
rs	9.3999
wmc	33
lcom	0
cbo	0

1 Method

Rating	Name	Duplication	Size	Complexity
C	foreignKeys()	9	74	33

How to fix Duplicated Code

<?php

/** Link system tables (in mysql and information_schema databases) by foreign keys
* @link https://www.adminer.org/plugins/#use
* @author Jakub Vrana, http://www.vrana.cz/
* @license http://www.apache.org/licenses/LICENSE-2.0 Apache License, Version 2.0
* @license http://www.gnu.org/licenses/gpl-2.0.html GNU General Public License, version 2 (one or other)
*/
class AdminerForeignSystem {
	
	function foreignKeys($table) {

		if (DRIVER == 'server' && DB == 'mysql') {
			switch ($table) {
				case 'columns_priv': return array(array('table' => 'user', 'source' => array('Host', 'User'), 'target' => array('Host', 'User')));

				case 'db': return array(array('table' => 'user', 'source' => array('Host', 'User'), 'target' => array('Host', 'User')));

				case 'help_category': return array(array('table' => 'help_category', 'source' => array('parent_category_id'), 'target' => array('help_category_id')));

				case 'help_relation': return array(array('table' => 'help_topic', 'source' => array('help_topic_id'), 'target' => array('help_topic_id')), array('table' => 'help_keyword', 'source' => array('help_keyword_id'), 'target' => array('help_keyword_id')));
				case 'help_topic': return array(array('table' => 'help_category', 'source' => array('help_category_id'), 'target' => array('help_category_id')));

				case 'procs_priv': return array(array('table' => 'user', 'source' => array('Host', 'User'), 'target' => array('Host', 'User')), array('table' => 'proc', 'source' => array('Db', 'Routine_name'), 'target' => array('db', 'name')));

				case 'tables_priv': return array(array('table' => 'user', 'source' => array('Host', 'User'), 'target' => array('Host', 'User')));

				case 'time_zone_name': return array(array('table' => 'time_zone', 'source' => array('Time_zone_id'), 'target' => array('Time_zone_id')));

				case 'time_zone_transition': return array(array('table' => 'time_zone', 'source' => array('Time_zone_id'), 'target' => array('Time_zone_id')), array(

                    'table' => 'time_zone_transition_type', 'source' => array('Time_zone_id', 'Transition_type_id'), 'target' => array(
                    'Time_zone_id',
                    'Transition_type_id'
                )));
				case 'time_zone_transition_type': return array(array('table' => 'time_zone', 'source' => array('Time_zone_id'), 'target' => array('Time_zone_id')));

			}
		} elseif (DB == 'information_schema') {
			$schemata = array('table' => 'SCHEMATA', 'source' => array('TABLE_CATALOG', 'TABLE_SCHEMA'), 'target' => array('CATALOG_NAME', 'SCHEMA_NAME'));
			$tables = array('table' => 'TABLES', 'source' => array('TABLE_CATALOG', 'TABLE_SCHEMA', 'TABLE_NAME'), 'target' => array('TABLE_CATALOG', 'TABLE_SCHEMA', 'TABLE_NAME'));
			$columns = array('table' => 'COLUMNS', 'source' => array('TABLE_CATALOG', 'TABLE_SCHEMA', 'TABLE_NAME', 'COLUMN_NAME'), 'target' => array('TABLE_CATALOG', 'TABLE_SCHEMA', 'TABLE_NAME', 'COLUMN_NAME'));
			$character_sets = array('table' => 'CHARACTER_SETS', 'source' => array('CHARACTER_SET_NAME'), 'target' => array('CHARACTER_SET_NAME'));
			$collations = array('table' => 'COLLATIONS', 'source' => array('COLLATION_NAME'), 'target' => array('COLLATION_NAME'));
			$routine_charsets = array(array('source' => array('CHARACTER_SET_CLIENT')) + $character_sets, array('source' => array('COLLATION_CONNECTION')) + $collations, array('source' => array('DATABASE_COLLATION')) + $collations);
			switch ($table) {
				case 'CHARACTER_SETS': return array(array('source' => array('DEFAULT_COLLATE_NAME')) + $collations);
				case 'COLLATIONS': return array($character_sets);
				case 'COLLATION_CHARACTER_SET_APPLICABILITY': return array($collations, $character_sets);
				case 'COLUMNS': return array($schemata, $tables, $character_sets, $collations);
				case 'COLUMN_PRIVILEGES': return array($schemata, $tables, $columns);
				case 'TABLES': return array($schemata, array('source' => array('TABLE_COLLATION')) + $collations);
				case 'SCHEMATA': return array(array('source' => array('DEFAULT_CHARACTER_SET_NAME')) + $character_sets, array('source' => array('DEFAULT_COLLATION_NAME')) + $collations);
				case 'EVENTS': return array_merge(array(array('source' => array('EVENT_CATALOG', 'EVENT_SCHEMA')) + $schemata), $routine_charsets);
				case 'FILES': return array($schemata, $tables);
				case 'KEY_COLUMN_USAGE': return array(array('source' => array('CONSTRAINT_CATALOG', 'CONSTRAINT_SCHEMA')) + $schemata, $schemata, $tables, $columns, array('source' => array('TABLE_CATALOG', 'REFERENCED_TABLE_SCHEMA')) + $schemata, array(
                                                                                                                                                                                                                                                           'source' => array(
                                                         'TABLE_CATALOG',
                                                         'REFERENCED_TABLE_SCHEMA',
                                                         'REFERENCED_TABLE_NAME'
                                                     )) + $tables, array(
                                                                                                                                                                                                                                                                                                                                                                    'source' => array(
                                                         'TABLE_CATALOG',
                                                         'REFERENCED_TABLE_SCHEMA',
                                                         'REFERENCED_TABLE_NAME',
                                                         'REFERENCED_COLUMN_NAME'
                                                     )) + $columns);
				case 'PARTITIONS': return array($schemata, $tables);
				case 'REFERENTIAL_CONSTRAINTS': return array(array('source' => array('CONSTRAINT_CATALOG', 'CONSTRAINT_SCHEMA')) + $schemata, array('source' => array('UNIQUE_CONSTRAINT_CATALOG', 'UNIQUE_CONSTRAINT_SCHEMA')) + $schemata, array(
                                                                                                                                                                                                                                                 'source' => array(
                                                                'CONSTRAINT_CATALOG',
                                                                'CONSTRAINT_SCHEMA',
                                                                'TABLE_NAME'
                                                            )) + $tables, array(
                                                                                                                                                                                                                                                                                                                                              'source' => array(
                                                                'CONSTRAINT_CATALOG',
                                                                'CONSTRAINT_SCHEMA',
                                                                'REFERENCED_TABLE_NAME'
                                                            )) + $tables);
				case 'ROUTINES': return array_merge(array(array('source' => array('ROUTINE_CATALOG', 'ROUTINE_SCHEMA')) + $schemata), $routine_charsets);
				case 'SCHEMA_PRIVILEGES': return array($schemata);
				case 'STATISTICS': return array($schemata, $tables, $columns, array('source' => array('TABLE_CATALOG', 'INDEX_SCHEMA')) + $schemata);
				case 'TABLE_CONSTRAINTS': return array(array('source' => array('CONSTRAINT_CATALOG', 'CONSTRAINT_SCHEMA')) + $schemata, array('source' => array('CONSTRAINT_CATALOG', 'TABLE_SCHEMA')) + $schemata, array('source' => array('CONSTRAINT_CATALOG', 'TABLE_SCHEMA', 'TABLE_NAME')) + $tables);
				case 'TABLE_PRIVILEGES': return array($schemata, $tables);
				case 'TRIGGERS': return array_merge(array(array('source' => array('TRIGGER_CATALOG', 'TRIGGER_SCHEMA')) + $schemata, array('source' => array('EVENT_OBJECT_CATALOG', 'EVENT_OBJECT_SCHEMA')) + $schemata, array(
                                                                                                                                                                                                                              'source' => array(
                                                             'EVENT_OBJECT_CATALOG',
                                                             'EVENT_OBJECT_SCHEMA',
                                                             'EVENT_OBJECT_TABLE'
                                                         )) + $tables), $routine_charsets);
				case 'VIEWS': return array($schemata);
			}
		}
	}
	
}


1		<?php
2
3		/** Link system tables (in mysql and information_schema databases) by foreign keys
4		* @link https://www.adminer.org/plugins/#use
5		* @author Jakub Vrana, http://www.vrana.cz/
6		* @license http://www.apache.org/licenses/LICENSE-2.0 Apache License, Version 2.0
7		* @license http://www.gnu.org/licenses/gpl-2.0.html GNU General Public License, version 2 (one or other)
8		*/
9		class AdminerForeignSystem {
10
11		function foreignKeys($table) {
		0 ignored issues – show Best Practice introduced 2016-07-19 20:19 UTC by Report Bug Copy Issue Report It is generally recommended to explicitly declare the visibility for methods. Adding explicit visibility (`private`, `protected`, or `public`) is generally recommend to communicate to other developers how, and from where this method is intended to be used. Loading history...
12		if (DRIVER == 'server' && DB == 'mysql') {
13		switch ($table) {
14	View Code Duplication	case 'columns_priv': return array(array('table' => 'user', 'source' => array('Host', 'User'), 'target' => array('Host', 'User')));
		0 ignored issues – show Duplication introduced 2016-07-19 20:19 UTC by Report Bug Copy Issue Report This code seems to be duplicated across your project. Duplicated code is one of the most pungent code smells. If you need to duplicate the same code in three or more different places, we strongly encourage you to look into extracting the code into a single class or operation. You can also find more detailed suggestions in the “Code” section of your repository. Loading history...
15	View Code Duplication	case 'db': return array(array('table' => 'user', 'source' => array('Host', 'User'), 'target' => array('Host', 'User')));
		0 ignored issues – show Duplication introduced 2016-07-19 20:19 UTC by Report Bug Copy Issue Report This code seems to be duplicated across your project. Duplicated code is one of the most pungent code smells. If you need to duplicate the same code in three or more different places, we strongly encourage you to look into extracting the code into a single class or operation. You can also find more detailed suggestions in the “Code” section of your repository. Loading history...
16	View Code Duplication	case 'help_category': return array(array('table' => 'help_category', 'source' => array('parent_category_id'), 'target' => array('help_category_id')));
		0 ignored issues – show Duplication introduced 2016-07-19 20:19 UTC by Report Bug Copy Issue Report This code seems to be duplicated across your project. Duplicated code is one of the most pungent code smells. If you need to duplicate the same code in three or more different places, we strongly encourage you to look into extracting the code into a single class or operation. You can also find more detailed suggestions in the “Code” section of your repository. Loading history...
17		case 'help_relation': return array(array('table' => 'help_topic', 'source' => array('help_topic_id'), 'target' => array('help_topic_id')), array('table' => 'help_keyword', 'source' => array('help_keyword_id'), 'target' => array('help_keyword_id')));
18	View Code Duplication	case 'help_topic': return array(array('table' => 'help_category', 'source' => array('help_category_id'), 'target' => array('help_category_id')));
		0 ignored issues – show Duplication introduced 2016-07-19 20:19 UTC by Report Bug Copy Issue Report This code seems to be duplicated across your project. Duplicated code is one of the most pungent code smells. If you need to duplicate the same code in three or more different places, we strongly encourage you to look into extracting the code into a single class or operation. You can also find more detailed suggestions in the “Code” section of your repository. Loading history...
19	View Code Duplication	case 'procs_priv': return array(array('table' => 'user', 'source' => array('Host', 'User'), 'target' => array('Host', 'User')), array('table' => 'proc', 'source' => array('Db', 'Routine_name'), 'target' => array('db', 'name')));
		0 ignored issues – show Duplication introduced 2016-07-19 20:19 UTC by Report Bug Copy Issue Report This code seems to be duplicated across your project. Duplicated code is one of the most pungent code smells. If you need to duplicate the same code in three or more different places, we strongly encourage you to look into extracting the code into a single class or operation. You can also find more detailed suggestions in the “Code” section of your repository. Loading history...
20	View Code Duplication	case 'tables_priv': return array(array('table' => 'user', 'source' => array('Host', 'User'), 'target' => array('Host', 'User')));
		0 ignored issues – show Duplication introduced 2016-07-19 20:19 UTC by Report Bug Copy Issue Report This code seems to be duplicated across your project. Duplicated code is one of the most pungent code smells. If you need to duplicate the same code in three or more different places, we strongly encourage you to look into extracting the code into a single class or operation. You can also find more detailed suggestions in the “Code” section of your repository. Loading history...
21	View Code Duplication	case 'time_zone_name': return array(array('table' => 'time_zone', 'source' => array('Time_zone_id'), 'target' => array('Time_zone_id')));
		0 ignored issues – show Duplication introduced 2016-07-19 20:19 UTC by Report Bug Copy Issue Report This code seems to be duplicated across your project. Duplicated code is one of the most pungent code smells. If you need to duplicate the same code in three or more different places, we strongly encourage you to look into extracting the code into a single class or operation. You can also find more detailed suggestions in the “Code” section of your repository. Loading history...
22	View Code Duplication	case 'time_zone_transition': return array(array('table' => 'time_zone', 'source' => array('Time_zone_id'), 'target' => array('Time_zone_id')), array(
		0 ignored issues – show Duplication introduced 2016-07-19 20:27 UTC by Report Bug Copy Issue Report This code seems to be duplicated across your project. Duplicated code is one of the most pungent code smells. If you need to duplicate the same code in three or more different places, we strongly encourage you to look into extracting the code into a single class or operation. You can also find more detailed suggestions in the “Code” section of your repository. Loading history...
23		'table' => 'time_zone_transition_type', 'source' => array('Time_zone_id', 'Transition_type_id'), 'target' => array(
24		'Time_zone_id',
25		'Transition_type_id'
26		)));
27	View Code Duplication	case 'time_zone_transition_type': return array(array('table' => 'time_zone', 'source' => array('Time_zone_id'), 'target' => array('Time_zone_id')));
		0 ignored issues – show Duplication introduced 2016-07-19 20:19 UTC by Report Bug Copy Issue Report This code seems to be duplicated across your project. Duplicated code is one of the most pungent code smells. If you need to duplicate the same code in three or more different places, we strongly encourage you to look into extracting the code into a single class or operation. You can also find more detailed suggestions in the “Code” section of your repository. Loading history...
28		}
29		} elseif (DB == 'information_schema') {
30		$schemata = array('table' => 'SCHEMATA', 'source' => array('TABLE_CATALOG', 'TABLE_SCHEMA'), 'target' => array('CATALOG_NAME', 'SCHEMA_NAME'));
31		$tables = array('table' => 'TABLES', 'source' => array('TABLE_CATALOG', 'TABLE_SCHEMA', 'TABLE_NAME'), 'target' => array('TABLE_CATALOG', 'TABLE_SCHEMA', 'TABLE_NAME'));
32		$columns = array('table' => 'COLUMNS', 'source' => array('TABLE_CATALOG', 'TABLE_SCHEMA', 'TABLE_NAME', 'COLUMN_NAME'), 'target' => array('TABLE_CATALOG', 'TABLE_SCHEMA', 'TABLE_NAME', 'COLUMN_NAME'));
33		$character_sets = array('table' => 'CHARACTER_SETS', 'source' => array('CHARACTER_SET_NAME'), 'target' => array('CHARACTER_SET_NAME'));
34		$collations = array('table' => 'COLLATIONS', 'source' => array('COLLATION_NAME'), 'target' => array('COLLATION_NAME'));
35		$routine_charsets = array(array('source' => array('CHARACTER_SET_CLIENT')) + $character_sets, array('source' => array('COLLATION_CONNECTION')) + $collations, array('source' => array('DATABASE_COLLATION')) + $collations);
36		switch ($table) {
37		case 'CHARACTER_SETS': return array(array('source' => array('DEFAULT_COLLATE_NAME')) + $collations);
38		case 'COLLATIONS': return array($character_sets);
39		case 'COLLATION_CHARACTER_SET_APPLICABILITY': return array($collations, $character_sets);
40		case 'COLUMNS': return array($schemata, $tables, $character_sets, $collations);
41		case 'COLUMN_PRIVILEGES': return array($schemata, $tables, $columns);
42		case 'TABLES': return array($schemata, array('source' => array('TABLE_COLLATION')) + $collations);
43		case 'SCHEMATA': return array(array('source' => array('DEFAULT_CHARACTER_SET_NAME')) + $character_sets, array('source' => array('DEFAULT_COLLATION_NAME')) + $collations);
44		case 'EVENTS': return array_merge(array(array('source' => array('EVENT_CATALOG', 'EVENT_SCHEMA')) + $schemata), $routine_charsets);
45		case 'FILES': return array($schemata, $tables);
46		case 'KEY_COLUMN_USAGE': return array(array('source' => array('CONSTRAINT_CATALOG', 'CONSTRAINT_SCHEMA')) + $schemata, $schemata, $tables, $columns, array('source' => array('TABLE_CATALOG', 'REFERENCED_TABLE_SCHEMA')) + $schemata, array(
47		'source' => array(
48		'TABLE_CATALOG',
49		'REFERENCED_TABLE_SCHEMA',
50		'REFERENCED_TABLE_NAME'
51		)) + $tables, array(
52		'source' => array(
53		'TABLE_CATALOG',
54		'REFERENCED_TABLE_SCHEMA',
55		'REFERENCED_TABLE_NAME',
56		'REFERENCED_COLUMN_NAME'
57		)) + $columns);
58		case 'PARTITIONS': return array($schemata, $tables);
59		case 'REFERENTIAL_CONSTRAINTS': return array(array('source' => array('CONSTRAINT_CATALOG', 'CONSTRAINT_SCHEMA')) + $schemata, array('source' => array('UNIQUE_CONSTRAINT_CATALOG', 'UNIQUE_CONSTRAINT_SCHEMA')) + $schemata, array(
60		'source' => array(
61		'CONSTRAINT_CATALOG',
62		'CONSTRAINT_SCHEMA',
63		'TABLE_NAME'
64		)) + $tables, array(
65		'source' => array(
66		'CONSTRAINT_CATALOG',
67		'CONSTRAINT_SCHEMA',
68		'REFERENCED_TABLE_NAME'
69		)) + $tables);
70		case 'ROUTINES': return array_merge(array(array('source' => array('ROUTINE_CATALOG', 'ROUTINE_SCHEMA')) + $schemata), $routine_charsets);
71		case 'SCHEMA_PRIVILEGES': return array($schemata);
72		case 'STATISTICS': return array($schemata, $tables, $columns, array('source' => array('TABLE_CATALOG', 'INDEX_SCHEMA')) + $schemata);
73		case 'TABLE_CONSTRAINTS': return array(array('source' => array('CONSTRAINT_CATALOG', 'CONSTRAINT_SCHEMA')) + $schemata, array('source' => array('CONSTRAINT_CATALOG', 'TABLE_SCHEMA')) + $schemata, array('source' => array('CONSTRAINT_CATALOG', 'TABLE_SCHEMA', 'TABLE_NAME')) + $tables);
74		case 'TABLE_PRIVILEGES': return array($schemata, $tables);
75		case 'TRIGGERS': return array_merge(array(array('source' => array('TRIGGER_CATALOG', 'TRIGGER_SCHEMA')) + $schemata, array('source' => array('EVENT_OBJECT_CATALOG', 'EVENT_OBJECT_SCHEMA')) + $schemata, array(
76		'source' => array(
77		'EVENT_OBJECT_CATALOG',
78		'EVENT_OBJECT_SCHEMA',
79		'EVENT_OBJECT_TABLE'
80		)) + $tables), $routine_charsets);
81		case 'VIEWS': return array($schemata);
82		}
83		}
84		}
85
86		}
87

XoopsModules25x / adminer

AdminerForeignSystem A last analyzed 2016-07-19 20:37 UTC

Complexity

Size/Duplication

Coupling/Cohesion

Importance

1 Method

How to fix Duplicated Code

Duplicated Code

Duplication Side-by-Side

Filter issues like

AdminerForeignSystem A
last analyzed 2016-07-19 20:37 UTC