include/plugins/foreign-system.php
Method foreignKeys
has 72 lines of code (exceeds 25 allowed). Consider refactoring. Open
Open
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')));
Avoid too many return
statements within this method. Open
Open
case 'CHARACTER_SETS': return array(array('source' => array('DEFAULT_COLLATE_NAME')) + $collations);
Avoid too many return
statements within this method. Open
Open
case 'ROUTINES': return array_merge(array(array('source' => array('ROUTINE_CATALOG', 'ROUTINE_SCHEMA')) + $schemata), $routine_charsets);
Avoid too many return
statements within this method. Open
Open
case 'FILES': return array($schemata, $tables);
Avoid too many return
statements within this method. Open
Open
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'
Avoid too many return
statements within this method. Open
Open
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')));
Avoid too many return
statements within this method. Open
Open
case 'time_zone_name': return array(array('table' => 'time_zone', 'source' => array('Time_zone_id'), 'target' => array('Time_zone_id')));
Avoid too many return
statements within this method. Open
Open
case 'tables_priv': return array(array('table' => 'user', 'source' => array('Host', 'User'), 'target' => array('Host', 'User')));
Avoid too many return
statements within this method. Open
Open
case 'SCHEMA_PRIVILEGES': return array($schemata);
Avoid too many return
statements within this method. Open
Open
case 'EVENTS': return array_merge(array(array('source' => array('EVENT_CATALOG', 'EVENT_SCHEMA')) + $schemata), $routine_charsets);
Avoid too many return
statements within this method. Open
Open
case 'PARTITIONS': return array($schemata, $tables);
Avoid too many return
statements within this method. Open
Open
case 'SCHEMATA': return array(array('source' => array('DEFAULT_CHARACTER_SET_NAME')) + $character_sets, array('source' => array('DEFAULT_COLLATION_NAME')) + $collations);
Avoid too many return
statements within this method. Open
Open
case 'help_topic': return array(array('table' => 'help_category', 'source' => array('help_category_id'), 'target' => array('help_category_id')));
Avoid too many return
statements within this method. Open
Open
case 'COLLATIONS': return array($character_sets);
Avoid too many return
statements within this method. Open
Open
case 'TABLES': return array($schemata, array('source' => array('TABLE_COLLATION')) + $collations);
Avoid too many return
statements within this method. Open
Open
case 'TABLE_PRIVILEGES': return array($schemata, $tables);
Avoid too many return
statements within this method. Open
Open
case 'COLUMN_PRIVILEGES': return array($schemata, $tables, $columns);
Avoid too many return
statements within this method. Open
Open
case 'COLLATION_CHARACTER_SET_APPLICABILITY': return array($collations, $character_sets);
Avoid too many return
statements within this method. Open
Open
case 'COLUMNS': return array($schemata, $tables, $character_sets, $collations);
Avoid too many return
statements within this method. Open
Open
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'
Avoid too many return
statements within this method. Open
Open
case 'STATISTICS': return array($schemata, $tables, $columns, array('source' => array('TABLE_CATALOG', 'INDEX_SCHEMA')) + $schemata);
Avoid too many return
statements within this method. Open
Open
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);
Avoid too many return
statements within this method. Open
Open
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'
Avoid too many return
statements within this method. Open
Open
case 'time_zone_transition_type': return array(array('table' => 'time_zone', 'source' => array('Time_zone_id'), 'target' => array('Time_zone_id')));
Avoid too many return
statements within this method. Open
Open
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'
)));
Avoid too many return
statements within this method. Open
Open
case 'VIEWS': return array($schemata);