Completed
Push — feature/database_migrations ( 2f83fe...a05e95 )
by Grant
15:30
created

PopulateSkills   A

Complexity

Total Complexity 2

Size/Duplication

Total Lines 102
Duplicated Lines 0 %

Importance

Changes 1
Bugs 0 Features 0
Metric Value
wmc 2
eloc 84
c 1
b 0
f 0
dl 0
loc 102
rs 10

2 Methods

Rating   Name   Duplication   Size   Complexity  
A down() 0 11 1
B up() 0 76 1
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
            ['id' => 1, 'skill_type_id' => 2, 'name' => 'front_end_dev'],
18
            ['id' => 2, 'skill_type_id' => 2, 'name' => 'web_programming'],
19
            ['id' => 3, 'skill_type_id' => 2, 'name' => 'server_admin'],
20
            ['id' => 4, 'skill_type_id' => 2, 'name' => 'linux'],
21
            ['id' => 5, 'skill_type_id' => 2, 'name' => 'css'],
22
            ['id' => 6, 'skill_type_id' => 2, 'name' => 'javascript'],
23
            ['id' => 7, 'skill_type_id' => 2, 'name' => 'c_plus_plus'],
24
            ['id' => 8, 'skill_type_id' => 2, 'name' => 'sass'],
25
            ['id' => 9, 'skill_type_id' => 2, 'name' => 'python'],
26
            ['id' => 10, 'skill_type_id' => 2, 'name' => 'php'],
27
            ['id' => 11, 'skill_type_id' => 2, 'name' => 'git'],
28
            ['id' => 12, 'skill_type_id' => 2, 'name' => 'docker'],
29
            ['id' => 13, 'skill_type_id' => 2, 'name' => 'html'],
30
            ['id' => 14, 'skill_type_id' => 2, 'name' => 'sql'],
31
            ['id' => 15, 'skill_type_id' => 2, 'name' => 'open_source'],
32
            ['id' => 16, 'skill_type_id' => 2, 'name' => 'verbal_communication'],
33
            ['id' => 17, 'skill_type_id' => 2, 'name' => 'written_communication'],
34
            ['id' => 18, 'skill_type_id' => 2, 'name' => 'ability_distributed_team'],
35
            ['id' => 19, 'skill_type_id' => 1, 'name' => 'ability_learn'],
36
            ['id' => 20, 'skill_type_id' => 1, 'name' => 'integrity'],
37
            ['id' => 21, 'skill_type_id' => 1, 'name' => 'ability_collaborate'],
38
            ['id' => 22, 'skill_type_id' => 1, 'name' => 'initiative'],
39
            ['id' => 23, 'skill_type_id' => 1, 'name' => 'humility'],
40
            ['id' => 24, 'skill_type_id' => 1, 'name' => 'passion'],
41
            ['id' => 25, 'skill_type_id' => 1, 'name' => 'flexibility'],
42
            ['id' => 26, 'skill_type_id' => 1, 'name' => 'judgement'],
43
            ['id' => 27, 'skill_type_id' => 1, 'name' => 'adaptability'],
44
            ['id' => 28, 'skill_type_id' => 1, 'name' => 'accountability'],
45
            ['id' => 29, 'skill_type_id' => 1, 'name' => 'attention_detail'],
46
            ['id' => 30, 'skill_type_id' => 1, 'name' => 'complex_problem_solving'],
47
            ['id' => 31, 'skill_type_id' => 1, 'name' => 'courage'],
48
            ['id' => 32, 'skill_type_id' => 1, 'name' => 'originality'],
49
            ['id' => 33, 'skill_type_id' => 1, 'name' => 'critical_thinking'],
50
            ['id' => 34, 'skill_type_id' => 1, 'name' => 'curiosity'],
51
            ['id' => 35, 'skill_type_id' => 1, 'name' => 'dependability'],
52
            ['id' => 36, 'skill_type_id' => 1, 'name' => 'ability_follow_instructions'],
53
            ['id' => 37, 'skill_type_id' => 1, 'name' => 'persistence'],
54
            ['id' => 38, 'skill_type_id' => 1, 'name' => 'resilience'],
55
            ['id' => 39, 'skill_type_id' => 1, 'name' => 'service_orientation'],
56
            ['id' => 40, 'skill_type_id' => 1, 'name' => 'social_perceptiveness'],
57
            ['id' => 41, 'skill_type_id' => 1, 'name' => 'stress_management'],
58
            ['id' => 42, 'skill_type_id' => 1, 'name' => 'stress_tolerance'],
59
            ['id' => 43, 'skill_type_id' => 1, 'name' => 'time_management'],
60
            ['id' => 44, 'skill_type_id' => 1, 'name' => 'willingness_learn'],
61
            ['id' => 45, 'skill_type_id' => 2, 'name' => 'management_ability'],
62
            ['id' => 46, 'skill_type_id' => 2, 'name' => 'experience_design'],
63
            ['id' => 47, 'skill_type_id' => 2, 'name' => 'project_management'],
64
            ['id' => 48, 'skill_type_id' => 2, 'name' => 'stakeholder_relations'],
65
            ['id' => 49, 'skill_type_id' => 2, 'name' => 'dot_net'],
66
            ['id' => 50, 'skill_type_id' => 2, 'name' => 'geospacial_programming'],
67
            ['id' => 51, 'skill_type_id' => 2, 'name' => 'microsoft_dynamics'],
68
            ['id' => 52, 'skill_type_id' => 2, 'name' => 'facilitation'],
69
            ['id' => 53, 'skill_type_id' => 2, 'name' => 'systems_thinking'],
70
            ['id' => 54, 'skill_type_id' => 2, 'name' => 'web_architecture'],
71
            ['id' => 55, 'skill_type_id' => 2, 'name' => 'storytelling'],
72
            ['id' => 56, 'skill_type_id' => 2, 'name' => 'user_design'],
73
            ['id' => 57, 'skill_type_id' => 1, 'name' => 'empathy'],
74
            ['id' => 58, 'skill_type_id' => 2, 'name' => 'analysis'],
75
            ['id' => 59, 'skill_type_id' => 2, 'name' => 'data_science'],
76
            ['id' => 60, 'skill_type_id' => 1, 'name' => 'results_oriented'],
77
            ['id' => 61, 'skill_type_id' => 1, 'name' => 'relationship_management'],
78
            ['id' => 62, 'skill_type_id' => 2, 'name' => 'data_analysis'],
79
            ['id' => 63, 'skill_type_id' => 2, 'name' => 'data_mining'],
80
            ['id' => 64, 'skill_type_id' => 2, 'name' => 'r_programming'],
81
            ['id' => 65, 'skill_type_id' => 2, 'name' => 'database_design_and_management'],
82
            ['id' => 66, 'skill_type_id' => 2, 'name' => 'scrum'],
83
            ['id' => 67, 'skill_type_id' => 2, 'name' => 'team_foundation_server'],
84
            ['id' => 68, 'skill_type_id' => 2, 'name' => 'n_unit_testing'],
85
            ['id' => 69, 'skill_type_id' => 2, 'name' => 'asp_net_mvc'],
86
            ['id' => 70, 'skill_type_id' => 2, 'name' => 'ef6'],
87
            ['id' => 71, 'skill_type_id' => 2, 'name' => 'cloud_architecture_for_mobile_and_applications'],
88
            ['id' => 72, 'skill_type_id' => 2, 'name' => 'cloud_computing_platform_configuration'],
89
            ['id' => 73, '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('province_translations')->whereIn('id',
101
        [1, 2, 3, 4, 5, 6, 7, 8, 9, 10,
102
        11, 12, 13, 14, 15, 16, 17, 18, 19, 20,
103
        21, 22, 23, 24, 25, 26, 27, 28, 29, 30,
104
        31, 32, 33, 34, 35, 36, 37, 38, 39, 40,
105
        41, 42, 43, 44, 45, 46, 47, 48, 49, 50,
106
        51, 52, 53, 54, 55, 56, 57, 58, 59, 60,
107
        61, 62, 63, 64, 65, 66, 67, 68, 69, 70,
108
        71, 72, 73])->delete();
109
    }
110
}
111