PopulateSkills::down() - Code Metrics - Inspection of "Merge branch 'dev' into task/file-cleanup" - GCTC-NTGC/TalentCloud - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — task/file-cleanup ( 35de75...35de75 )

by Grant

created 2019-02-22 23:08 UTC

PopulateSkills::down() B

↳ Parent: Project

Complexity

Conditions	1
Paths	1

Size

Total Lines	78
Code Lines	75

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
eloc	75
c	1
b	0
f	0
dl	0
loc	78
rs	8.5454
cc	1
nc	1
nop	0

How to fix Long Method

<?php

use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class PopulateSkills extends Migration
{
    /**
    * Run the migrations.
    *
    * @return void
    */
    public function up()
    {
        DB::table('skills')->insert([
            ['skill_type_id' => 2, 'name' => 'front_end_dev'],
            ['skill_type_id' => 2, 'name' => 'web_programming'],
            ['skill_type_id' => 2, 'name' => 'server_admin'],
            ['skill_type_id' => 2, 'name' => 'linux'],
            ['skill_type_id' => 2, 'name' => 'css'],
            ['skill_type_id' => 2, 'name' => 'javascript'],
            ['skill_type_id' => 2, 'name' => 'c_plus_plus'],
            ['skill_type_id' => 2, 'name' => 'sass'],
            ['skill_type_id' => 2, 'name' => 'python'],
            ['skill_type_id' => 2, 'name' => 'php'],
            ['skill_type_id' => 2, 'name' => 'git'],
            ['skill_type_id' => 2, 'name' => 'docker'],
            ['skill_type_id' => 2, 'name' => 'html'],
            ['skill_type_id' => 2, 'name' => 'sql'],
            ['skill_type_id' => 2, 'name' => 'open_source'],
            ['skill_type_id' => 2, 'name' => 'verbal_communication'],
            ['skill_type_id' => 2, 'name' => 'written_communication'],
            ['skill_type_id' => 2, 'name' => 'ability_distributed_team'],
            ['skill_type_id' => 1, 'name' => 'ability_learn'],
            ['skill_type_id' => 1, 'name' => 'integrity'],
            ['skill_type_id' => 1, 'name' => 'ability_collaborate'],
            ['skill_type_id' => 1, 'name' => 'initiative'],
            ['skill_type_id' => 1, 'name' => 'humility'],
            ['skill_type_id' => 1, 'name' => 'passion'],
            ['skill_type_id' => 1, 'name' => 'flexibility'],
            ['skill_type_id' => 1, 'name' => 'judgement'],
            ['skill_type_id' => 1, 'name' => 'adaptability'],
            ['skill_type_id' => 1, 'name' => 'accountability'],
            ['skill_type_id' => 1, 'name' => 'attention_detail'],
            ['skill_type_id' => 1, 'name' => 'complex_problem_solving'],
            ['skill_type_id' => 1, 'name' => 'courage'],
            ['skill_type_id' => 1, 'name' => 'originality'],
            ['skill_type_id' => 1, 'name' => 'critical_thinking'],
            ['skill_type_id' => 1, 'name' => 'curiosity'],
            ['skill_type_id' => 1, 'name' => 'dependability'],
            ['skill_type_id' => 1, 'name' => 'ability_follow_instructions'],
            ['skill_type_id' => 1, 'name' => 'persistence'],
            ['skill_type_id' => 1, 'name' => 'resilience'],
            ['skill_type_id' => 1, 'name' => 'service_orientation'],
            ['skill_type_id' => 1, 'name' => 'social_perceptiveness'],
            ['skill_type_id' => 1, 'name' => 'stress_management'],
            ['skill_type_id' => 1, 'name' => 'stress_tolerance'],
            ['skill_type_id' => 1, 'name' => 'time_management'],
            ['skill_type_id' => 1, 'name' => 'willingness_learn'],
            ['skill_type_id' => 2, 'name' => 'management_ability'],
            ['skill_type_id' => 2, 'name' => 'experience_design'],
            ['skill_type_id' => 2, 'name' => 'project_management'],
            ['skill_type_id' => 2, 'name' => 'stakeholder_relations'],
            ['skill_type_id' => 2, 'name' => 'dot_net'],
            ['skill_type_id' => 2, 'name' => 'geospacial_programming'],
            ['skill_type_id' => 2, 'name' => 'microsoft_dynamics'],
            ['skill_type_id' => 2, 'name' => 'facilitation'],
            ['skill_type_id' => 2, 'name' => 'systems_thinking'],
            ['skill_type_id' => 2, 'name' => 'web_architecture'],
            ['skill_type_id' => 2, 'name' => 'storytelling'],
            ['skill_type_id' => 2, 'name' => 'user_design'],
            ['skill_type_id' => 1, 'name' => 'empathy'],
            ['skill_type_id' => 2, 'name' => 'analysis'],
            ['skill_type_id' => 2, 'name' => 'data_science'],
            ['skill_type_id' => 1, 'name' => 'results_oriented'],
            ['skill_type_id' => 1, 'name' => 'relationship_management'],
            ['skill_type_id' => 2, 'name' => 'data_analysis'],
            ['skill_type_id' => 2, 'name' => 'data_mining'],
            ['skill_type_id' => 2, 'name' => 'r_programming'],
            ['skill_type_id' => 2, 'name' => 'database_design_and_management'],
            ['skill_type_id' => 2, 'name' => 'scrum'],
            ['skill_type_id' => 2, 'name' => 'team_foundation_server'],
            ['skill_type_id' => 2, 'name' => 'n_unit_testing'],
            ['skill_type_id' => 2, 'name' => 'asp_net_mvc'],
            ['skill_type_id' => 2, 'name' => 'ef6'],
            ['skill_type_id' => 2, 'name' => 'cloud_architecture_for_mobile_and_applications'],
            ['skill_type_id' => 2, 'name' => 'cloud_computing_platform_configuration'],
            ['skill_type_id' => 2, 'name' => 'strategy_development'],
        ]);
    }

    /**
    * Reverse the migrations.
    *
    * @return void
    */
    public function down()
    {
        DB::table('skills')->whereIn('name',
        [
            'front_end_dev',
            'web_programming',
            'server_admin',
            'linux',
            'css',
            'javascript',
            'c_plus_plus',
            'sass',
            'python',
            'php',
            'git',
            'docker',
            'html',
            'sql',
            'open_source',
            'verbal_communication',
            'written_communication',
            'ability_distributed_team',
            'ability_learn',
            'integrity',
            'ability_collaborate',
            'initiative',
            'humility',
            'passion',
            'flexibility',
            'judgement',
            'adaptability',
            'accountability',
            'attention_detail',
            'complex_problem_solving',
            'courage',
            'originality',
            'critical_thinking',
            'curiosity',
            'dependability',
            'ability_follow_instructions',
            'persistence',
            'resilience',
            'service_orientation',
            'social_perceptiveness',
            'stress_management',
            'stress_tolerance',
            'time_management',
            'willingness_learn',
            'management_ability',
            'experience_design',
            'project_management',
            'stakeholder_relations',
            'dot_net',
            'geospacial_programming',
            'microsoft_dynamics',
            'facilitation',
            'systems_thinking',
            'web_architecture',
            'storytelling',
            'user_design',
            'empathy',
            'analysis',
            'data_science',
            'results_oriented',
            'relationship_management',
            'data_analysis',
            'data_mining',
            'r_programming',
            'database_design_and_management',
            'scrum',
            'team_foundation_server',
            'n_unit_testing',
            'asp_net_mvc',
            'ef6',
            'cloud_architecture_for_mobile_and_applications',
            'cloud_computing_platform_configuration',
            'strategy_development',
        ])->delete();
    }
}


1			<?php
2
3			use Illuminate\Support\Facades\Schema;
4			use Illuminate\Database\Schema\Blueprint;
5			use Illuminate\Database\Migrations\Migration;
6
7			class PopulateSkills extends Migration
8			{
9			/**
10			* Run the migrations.
11			*
12			* @return void
13			*/
14			public function up()
15			{
16			DB::table('skills')->insert([
17			['skill_type_id' => 2, 'name' => 'front_end_dev'],
18			['skill_type_id' => 2, 'name' => 'web_programming'],
19			['skill_type_id' => 2, 'name' => 'server_admin'],
20			['skill_type_id' => 2, 'name' => 'linux'],
21			['skill_type_id' => 2, 'name' => 'css'],
22			['skill_type_id' => 2, 'name' => 'javascript'],
23			['skill_type_id' => 2, 'name' => 'c_plus_plus'],
24			['skill_type_id' => 2, 'name' => 'sass'],
25			['skill_type_id' => 2, 'name' => 'python'],
26			['skill_type_id' => 2, 'name' => 'php'],
27			['skill_type_id' => 2, 'name' => 'git'],
28			['skill_type_id' => 2, 'name' => 'docker'],
29			['skill_type_id' => 2, 'name' => 'html'],
30			['skill_type_id' => 2, 'name' => 'sql'],
31			['skill_type_id' => 2, 'name' => 'open_source'],
32			['skill_type_id' => 2, 'name' => 'verbal_communication'],
33			['skill_type_id' => 2, 'name' => 'written_communication'],
34			['skill_type_id' => 2, 'name' => 'ability_distributed_team'],
35			['skill_type_id' => 1, 'name' => 'ability_learn'],
36			['skill_type_id' => 1, 'name' => 'integrity'],
37			['skill_type_id' => 1, 'name' => 'ability_collaborate'],
38			['skill_type_id' => 1, 'name' => 'initiative'],
39			['skill_type_id' => 1, 'name' => 'humility'],
40			['skill_type_id' => 1, 'name' => 'passion'],
41			['skill_type_id' => 1, 'name' => 'flexibility'],
42			['skill_type_id' => 1, 'name' => 'judgement'],
43			['skill_type_id' => 1, 'name' => 'adaptability'],
44			['skill_type_id' => 1, 'name' => 'accountability'],
45			['skill_type_id' => 1, 'name' => 'attention_detail'],
46			['skill_type_id' => 1, 'name' => 'complex_problem_solving'],
47			['skill_type_id' => 1, 'name' => 'courage'],
48			['skill_type_id' => 1, 'name' => 'originality'],
49			['skill_type_id' => 1, 'name' => 'critical_thinking'],
50			['skill_type_id' => 1, 'name' => 'curiosity'],
51			['skill_type_id' => 1, 'name' => 'dependability'],
52			['skill_type_id' => 1, 'name' => 'ability_follow_instructions'],
53			['skill_type_id' => 1, 'name' => 'persistence'],
54			['skill_type_id' => 1, 'name' => 'resilience'],
55			['skill_type_id' => 1, 'name' => 'service_orientation'],
56			['skill_type_id' => 1, 'name' => 'social_perceptiveness'],
57			['skill_type_id' => 1, 'name' => 'stress_management'],
58			['skill_type_id' => 1, 'name' => 'stress_tolerance'],
59			['skill_type_id' => 1, 'name' => 'time_management'],
60			['skill_type_id' => 1, 'name' => 'willingness_learn'],
61			['skill_type_id' => 2, 'name' => 'management_ability'],
62			['skill_type_id' => 2, 'name' => 'experience_design'],
63			['skill_type_id' => 2, 'name' => 'project_management'],
64			['skill_type_id' => 2, 'name' => 'stakeholder_relations'],
65			['skill_type_id' => 2, 'name' => 'dot_net'],
66			['skill_type_id' => 2, 'name' => 'geospacial_programming'],
67			['skill_type_id' => 2, 'name' => 'microsoft_dynamics'],
68			['skill_type_id' => 2, 'name' => 'facilitation'],
69			['skill_type_id' => 2, 'name' => 'systems_thinking'],
70			['skill_type_id' => 2, 'name' => 'web_architecture'],
71			['skill_type_id' => 2, 'name' => 'storytelling'],
72			['skill_type_id' => 2, 'name' => 'user_design'],
73			['skill_type_id' => 1, 'name' => 'empathy'],
74			['skill_type_id' => 2, 'name' => 'analysis'],
75			['skill_type_id' => 2, 'name' => 'data_science'],
76			['skill_type_id' => 1, 'name' => 'results_oriented'],
77			['skill_type_id' => 1, 'name' => 'relationship_management'],
78			['skill_type_id' => 2, 'name' => 'data_analysis'],
79			['skill_type_id' => 2, 'name' => 'data_mining'],
80			['skill_type_id' => 2, 'name' => 'r_programming'],
81			['skill_type_id' => 2, 'name' => 'database_design_and_management'],
82			['skill_type_id' => 2, 'name' => 'scrum'],
83			['skill_type_id' => 2, 'name' => 'team_foundation_server'],
84			['skill_type_id' => 2, 'name' => 'n_unit_testing'],
85			['skill_type_id' => 2, 'name' => 'asp_net_mvc'],
86			['skill_type_id' => 2, 'name' => 'ef6'],
87			['skill_type_id' => 2, 'name' => 'cloud_architecture_for_mobile_and_applications'],
88			['skill_type_id' => 2, 'name' => 'cloud_computing_platform_configuration'],
89			['skill_type_id' => 2, 'name' => 'strategy_development'],
90			]);
91			}
92
93			/**
94			* Reverse the migrations.
95			*
96			* @return void
97			*/
98			public function down()
99			{
100			DB::table('skills')->whereIn('name',
101			[
102			'front_end_dev',
103			'web_programming',
104			'server_admin',
105			'linux',
106			'css',
107			'javascript',
108			'c_plus_plus',
109			'sass',
110			'python',
111			'php',
112			'git',
113			'docker',
114			'html',
115			'sql',
116			'open_source',
117			'verbal_communication',
118			'written_communication',
119			'ability_distributed_team',
120			'ability_learn',
121			'integrity',
122			'ability_collaborate',
123			'initiative',
124			'humility',
125			'passion',
126			'flexibility',
127			'judgement',
128			'adaptability',
129			'accountability',
130			'attention_detail',
131			'complex_problem_solving',
132			'courage',
133			'originality',
134			'critical_thinking',
135			'curiosity',
136			'dependability',
137			'ability_follow_instructions',
138			'persistence',
139			'resilience',
140			'service_orientation',
141			'social_perceptiveness',
142			'stress_management',
143			'stress_tolerance',
144			'time_management',
145			'willingness_learn',
146			'management_ability',
147			'experience_design',
148			'project_management',
149			'stakeholder_relations',
150			'dot_net',
151			'geospacial_programming',
152			'microsoft_dynamics',
153			'facilitation',
154			'systems_thinking',
155			'web_architecture',
156			'storytelling',
157			'user_design',
158			'empathy',
159			'analysis',
160			'data_science',
161			'results_oriented',
162			'relationship_management',
163			'data_analysis',
164			'data_mining',
165			'r_programming',
166			'database_design_and_management',
167			'scrum',
168			'team_foundation_server',
169			'n_unit_testing',
170			'asp_net_mvc',
171			'ef6',
172			'cloud_architecture_for_mobile_and_applications',
173			'cloud_computing_platform_configuration',
174			'strategy_development',
175			])->delete();
176			}
177			}
178

GCTC-NTGC / TalentCloud

Push — task/file-cleanup ( 35de75...35de75 )

PopulateSkills::down() B

Complexity

Size

Duplication

Importance

How to fix Long Method

Long Method

Duplication Side-by-Side

Filter issues like