PopulateAssessmentTypeTranslations::up() - Code Metrics - Inspection of "Merge branch 'dev' into feature/unique_email_valid..." - GCTC-NTGC/TalentCloud - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — feature/unique_email_validatio... ( fb8415...5390cf )

by Tristan

created 2019-01-21 21:06 UTC

PopulateAssessmentTypeTranslations::up() B

↳ Parent: PopulateAssessmentTypeTranslations

Complexity

Conditions	1
Paths	1

Size

Total Lines	73
Code Lines	55

Duplication

Lines	0
Ratio	0 %

Importance

Changes	2
Bugs	0	Features	0

Metric	Value
eloc	55
c	2
b	0
f	0
dl	0
loc	73
rs	8.9818
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 PopulateAssessmentTypeTranslations extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        /**
         * Narrative assessment
         * Take home exam – Scenario
         * Take home exam – Technical
         * Take home exam – Behavioural
         * Portfolio review
         * Portfolio review with candidate
         * Interview question – Technical
         * Interview question – Scenario
         * Interview question – Behaviour
         * Interview – Overall performance
         * Group test
         * Reference check – Traditional
         * Reference check – Micro
         * Certificate or formal credential
        */
        DB::table('assessment_type_translations')->insert([
            ['id' => 1, 'assessment_type_id' => 1, 'locale' => 'en', 'name' => 'Narrative Assessment'],
            ['id' => 2, 'assessment_type_id' => 1, 'locale' => 'fr', 'name' => 'Évaluation narrative'],
            ['id' => 3, 'assessment_type_id' => 2, 'locale' => 'en', 'name' => 'Take home exam – Scenario-based (behaviour)'],
            ['id' => 4, 'assessment_type_id' => 2, 'locale' => 'fr', 'name' => 'Examen à la maison - basé sur un scénario (comportement)'],
            ['id' => 5, 'assessment_type_id' => 3, 'locale' => 'en', 'name' => 'Take home exam – Problem-based (analysis)'],
            ['id' => 6, 'assessment_type_id' => 3, 'locale' => 'fr', 'name' => 'Examen à la maison - basé sur le problème (analyse)'],
            ['id' => 7, 'assessment_type_id' => 4, 'locale' => 'en', 'name' => 'Take home exam – Technical skills'],
            ['id' => 8, 'assessment_type_id' => 4, 'locale' => 'fr', 'name' => 'Examen à la maison - Compétences techniques'],
            ['id' => 9, 'assessment_type_id' => 5, 'locale' => 'en', 'name' => 'Take home exam – Research'],
            ['id' => 10, 'assessment_type_id' => 5, 'locale' => 'fr', 'name' => 'Examen à la maison - Recherche'],
            ['id' => 11, 'assessment_type_id' => 6, 'locale' => 'en', 'name' => 'Take home exam – self-assessment'],
            ['id' => 12, 'assessment_type_id' => 6, 'locale' => 'fr', 'name' => 'Examen à domicile - auto-évaluation'],
            ['id' => 13, 'assessment_type_id' => 7, 'locale' => 'en', 'name' => 'On site exam – Technical skills'],
            ['id' => 14, 'assessment_type_id' => 7, 'locale' => 'fr', 'name' => 'Examen sur site - Compétences techniques'],
            ['id' => 15, 'assessment_type_id' => 8, 'locale' => 'en', 'name' => 'On site exam – Self-assessment'],
            ['id' => 16, 'assessment_type_id' => 8, 'locale' => 'fr', 'name' => 'Examen sur site - Auto-évaluation'],
            ['id' => 17, 'assessment_type_id' => 9, 'locale' => 'en', 'name' => 'Online exam – Technical skills'],
            ['id' => 18, 'assessment_type_id' => 9, 'locale' => 'fr', 'name' => 'Examen en ligne - Compétences techniques'],
            ['id' => 19, 'assessment_type_id' => 10, 'locale' => 'en', 'name' => 'Online exam – Psychometric (PSC)'],
            ['id' => 20, 'assessment_type_id' => 10, 'locale' => 'fr', 'name' => 'Examen en ligne - Psychométrique (PSC)'],
            ['id' => 21, 'assessment_type_id' => 11, 'locale' => 'en', 'name' => 'Online exam – Cognitive abilities test (PSC)'],
            ['id' => 22, 'assessment_type_id' => 11, 'locale' => 'fr', 'name' => 'Examen en ligne - Test d\' aptitudes cognitives(PSC)'],
            ['id' => 23, 'assessment_type_id' => 12, 'locale' => 'en', 'name' => 'Interview question – Technical skills'],
            ['id' => 24, 'assessment_type_id' => 12, 'locale' => 'fr', 'name' => 'Question d\' entretien - Compétences techniques '],
            ['id' => 25, 'assessment_type_id' => 13, 'locale' => 'en', 'name' => 'Interview question – Scenario-based (behaviour)'],
            ['id' => 26, 'assessment_type_id' => 13, 'locale' => 'fr', 'name' => 'Question d\' entretien - Basé sur un scénario(comportement)'],
            ['id' => 27, 'assessment_type_id' => 14, 'locale' => 'en', 'name' => 'Interview question – Problem-based (analysis)'],
            ['id' => 28, 'assessment_type_id' => 14, 'locale' => 'fr', 'name' => 'Question d\' entretien - Fondée sur le problème(analyse)'],
            ['id' => 29, 'assessment_type_id' => 15, 'locale' => 'en', 'name' => 'Interview question – Past experience'],
            ['id' => 30, 'assessment_type_id' => 15, 'locale' => 'fr', 'name' => 'Question d\' entrevue - Expérience antérieure'],
            ['id' => 31, 'assessment_type_id' => 16, 'locale' => 'en', 'name' => 'Interview question – Self-assessment'],
            ['id' => 32, 'assessment_type_id' => 16, 'locale' => 'fr', 'name' => 'Question d\' entrevue - Auto - évaluation'],
            ['id' => 33, 'assessment_type_id' => 17, 'locale' => 'en', 'name' => 'Interview – Overall performance'],
            ['id' => 34, 'assessment_type_id' => 17, 'locale' => 'fr', 'name' => 'Entretien - Performance globale'],
            ['id' => 35, 'assessment_type_id' => 18, 'locale' => 'en', 'name' => 'Informal phone conversation'],
            ['id' => 36, 'assessment_type_id' => 18, 'locale' => 'fr', 'name' => 'Conversation téléphonique informelle'],
            ['id' => 37, 'assessment_type_id' => 19, 'locale' => 'en', 'name' => 'Portfolio review (online submission)'],
            ['id' => 38, 'assessment_type_id' => 19, 'locale' => 'fr', 'name' => 'Examen du portefeuille (soumission en ligne)'],
            ['id' => 39, 'assessment_type_id' => 20, 'locale' => 'en', 'name' => 'Portfolio review with candidate'],
            ['id' => 40, 'assessment_type_id' => 20, 'locale' => 'fr', 'name' => 'Examen du portefeuille avec le candidat'],
            ['id' => 41, 'assessment_type_id' => 21, 'locale' => 'en', 'name' => 'Group test – Problem-based (analysis)'],
            ['id' => 42, 'assessment_type_id' => 21, 'locale' => 'fr', 'name' => 'Test de groupe - Fondé sur un problème (analyse)'],
            ['id' => 43, 'assessment_type_id' => 22, 'locale' => 'en', 'name' => 'Group test – Behavioural interaction'],
            ['id' => 44, 'assessment_type_id' => 22, 'locale' => 'fr', 'name' => 'Test de groupe - Interaction comportementale'],
            ['id' => 45, 'assessment_type_id' => 23, 'locale' => 'en', 'name' => 'Serious games – Behavioural interaction'],
            ['id' => 46, 'assessment_type_id' => 23, 'locale' => 'fr', 'name' => 'Jeux sérieux - Interaction comportementale'],
            ['id' => 47, 'assessment_type_id' => 24, 'locale' => 'en', 'name' => 'Serious games – Ability to learn'],
            ['id' => 48, 'assessment_type_id' => 24, 'locale' => 'fr', 'name' => 'Jeux sérieux - Capacité d\'apprendre'],
            ['id' => 49, 'assessment_type_id' => 25, 'locale' => 'en', 'name' => 'Serious games – Analytical'],
            ['id' => 50, 'assessment_type_id' => 25, 'locale' => 'fr', 'name' => 'Jeux sérieux - Analytical'],
            ['id' => 51, 'assessment_type_id' => 26, 'locale' => 'en', 'name' => 'Reference check – Micro-reference'],
            ['id' => 52, 'assessment_type_id' => 26, 'locale' => 'fr', 'name' => 'Vérification de référence - Micro-référence'],
            ['id' => 53, 'assessment_type_id' => 27, 'locale' => 'en', 'name' => 'Reference check – Conversation with reference'],
            ['id' => 54, 'assessment_type_id' => 27, 'locale' => 'fr', 'name' => 'Vérification de référence - Conversation avec référence']
        ]);
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        DB::table('assessment_type_translations')->whereIn('id', [
            1, 2, 3, 4, 5, 6, 7, 8, 9, 10,
            11, 12, 13, 14, 15, 16, 17, 18, 19, 20,
            21, 22, 23, 24, 25, 26, 27, 28, 29, 30,
            31, 32, 33, 34, 35, 36, 37, 38, 39, 40,
            41, 42, 43, 44, 45, 46, 47, 48, 49, 50,
            51, 52, 53, 54,
        ])->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 PopulateAssessmentTypeTranslations extends Migration
8			{
9			/**
10			* Run the migrations.
11			*
12			* @return void
13			*/
14			public function up()
15			{
16			/**
17			* Narrative assessment
18			* Take home exam – Scenario
19			* Take home exam – Technical
20			* Take home exam – Behavioural
21			* Portfolio review
22			* Portfolio review with candidate
23			* Interview question – Technical
24			* Interview question – Scenario
25			* Interview question – Behaviour
26			* Interview – Overall performance
27			* Group test
28			* Reference check – Traditional
29			* Reference check – Micro
30			* Certificate or formal credential
31			*/
32			DB::table('assessment_type_translations')->insert([
33			['id' => 1, 'assessment_type_id' => 1, 'locale' => 'en', 'name' => 'Narrative Assessment'],
34			['id' => 2, 'assessment_type_id' => 1, 'locale' => 'fr', 'name' => 'Évaluation narrative'],
35			['id' => 3, 'assessment_type_id' => 2, 'locale' => 'en', 'name' => 'Take home exam – Scenario-based (behaviour)'],
36			['id' => 4, 'assessment_type_id' => 2, 'locale' => 'fr', 'name' => 'Examen à la maison - basé sur un scénario (comportement)'],
37			['id' => 5, 'assessment_type_id' => 3, 'locale' => 'en', 'name' => 'Take home exam – Problem-based (analysis)'],
38			['id' => 6, 'assessment_type_id' => 3, 'locale' => 'fr', 'name' => 'Examen à la maison - basé sur le problème (analyse)'],
39			['id' => 7, 'assessment_type_id' => 4, 'locale' => 'en', 'name' => 'Take home exam – Technical skills'],
40			['id' => 8, 'assessment_type_id' => 4, 'locale' => 'fr', 'name' => 'Examen à la maison - Compétences techniques'],
41			['id' => 9, 'assessment_type_id' => 5, 'locale' => 'en', 'name' => 'Take home exam – Research'],
42			['id' => 10, 'assessment_type_id' => 5, 'locale' => 'fr', 'name' => 'Examen à la maison - Recherche'],
43			['id' => 11, 'assessment_type_id' => 6, 'locale' => 'en', 'name' => 'Take home exam – self-assessment'],
44			['id' => 12, 'assessment_type_id' => 6, 'locale' => 'fr', 'name' => 'Examen à domicile - auto-évaluation'],
45			['id' => 13, 'assessment_type_id' => 7, 'locale' => 'en', 'name' => 'On site exam – Technical skills'],
46			['id' => 14, 'assessment_type_id' => 7, 'locale' => 'fr', 'name' => 'Examen sur site - Compétences techniques'],
47			['id' => 15, 'assessment_type_id' => 8, 'locale' => 'en', 'name' => 'On site exam – Self-assessment'],
48			['id' => 16, 'assessment_type_id' => 8, 'locale' => 'fr', 'name' => 'Examen sur site - Auto-évaluation'],
49			['id' => 17, 'assessment_type_id' => 9, 'locale' => 'en', 'name' => 'Online exam – Technical skills'],
50			['id' => 18, 'assessment_type_id' => 9, 'locale' => 'fr', 'name' => 'Examen en ligne - Compétences techniques'],
51			['id' => 19, 'assessment_type_id' => 10, 'locale' => 'en', 'name' => 'Online exam – Psychometric (PSC)'],
52			['id' => 20, 'assessment_type_id' => 10, 'locale' => 'fr', 'name' => 'Examen en ligne - Psychométrique (PSC)'],
53			['id' => 21, 'assessment_type_id' => 11, 'locale' => 'en', 'name' => 'Online exam – Cognitive abilities test (PSC)'],
54			['id' => 22, 'assessment_type_id' => 11, 'locale' => 'fr', 'name' => 'Examen en ligne - Test d\' aptitudes cognitives(PSC)'],
55			['id' => 23, 'assessment_type_id' => 12, 'locale' => 'en', 'name' => 'Interview question – Technical skills'],
56			['id' => 24, 'assessment_type_id' => 12, 'locale' => 'fr', 'name' => 'Question d\' entretien - Compétences techniques '],
57			['id' => 25, 'assessment_type_id' => 13, 'locale' => 'en', 'name' => 'Interview question – Scenario-based (behaviour)'],
58			['id' => 26, 'assessment_type_id' => 13, 'locale' => 'fr', 'name' => 'Question d\' entretien - Basé sur un scénario(comportement)'],
59			['id' => 27, 'assessment_type_id' => 14, 'locale' => 'en', 'name' => 'Interview question – Problem-based (analysis)'],
60			['id' => 28, 'assessment_type_id' => 14, 'locale' => 'fr', 'name' => 'Question d\' entretien - Fondée sur le problème(analyse)'],
61			['id' => 29, 'assessment_type_id' => 15, 'locale' => 'en', 'name' => 'Interview question – Past experience'],
62			['id' => 30, 'assessment_type_id' => 15, 'locale' => 'fr', 'name' => 'Question d\' entrevue - Expérience antérieure'],
63			['id' => 31, 'assessment_type_id' => 16, 'locale' => 'en', 'name' => 'Interview question – Self-assessment'],
64			['id' => 32, 'assessment_type_id' => 16, 'locale' => 'fr', 'name' => 'Question d\' entrevue - Auto - évaluation'],
65			['id' => 33, 'assessment_type_id' => 17, 'locale' => 'en', 'name' => 'Interview – Overall performance'],
66			['id' => 34, 'assessment_type_id' => 17, 'locale' => 'fr', 'name' => 'Entretien - Performance globale'],
67			['id' => 35, 'assessment_type_id' => 18, 'locale' => 'en', 'name' => 'Informal phone conversation'],
68			['id' => 36, 'assessment_type_id' => 18, 'locale' => 'fr', 'name' => 'Conversation téléphonique informelle'],
69			['id' => 37, 'assessment_type_id' => 19, 'locale' => 'en', 'name' => 'Portfolio review (online submission)'],
70			['id' => 38, 'assessment_type_id' => 19, 'locale' => 'fr', 'name' => 'Examen du portefeuille (soumission en ligne)'],
71			['id' => 39, 'assessment_type_id' => 20, 'locale' => 'en', 'name' => 'Portfolio review with candidate'],
72			['id' => 40, 'assessment_type_id' => 20, 'locale' => 'fr', 'name' => 'Examen du portefeuille avec le candidat'],
73			['id' => 41, 'assessment_type_id' => 21, 'locale' => 'en', 'name' => 'Group test – Problem-based (analysis)'],
74			['id' => 42, 'assessment_type_id' => 21, 'locale' => 'fr', 'name' => 'Test de groupe - Fondé sur un problème (analyse)'],
75			['id' => 43, 'assessment_type_id' => 22, 'locale' => 'en', 'name' => 'Group test – Behavioural interaction'],
76			['id' => 44, 'assessment_type_id' => 22, 'locale' => 'fr', 'name' => 'Test de groupe - Interaction comportementale'],
77			['id' => 45, 'assessment_type_id' => 23, 'locale' => 'en', 'name' => 'Serious games – Behavioural interaction'],
78			['id' => 46, 'assessment_type_id' => 23, 'locale' => 'fr', 'name' => 'Jeux sérieux - Interaction comportementale'],
79			['id' => 47, 'assessment_type_id' => 24, 'locale' => 'en', 'name' => 'Serious games – Ability to learn'],
80			['id' => 48, 'assessment_type_id' => 24, 'locale' => 'fr', 'name' => 'Jeux sérieux - Capacité d\'apprendre'],
81			['id' => 49, 'assessment_type_id' => 25, 'locale' => 'en', 'name' => 'Serious games – Analytical'],
82			['id' => 50, 'assessment_type_id' => 25, 'locale' => 'fr', 'name' => 'Jeux sérieux - Analytical'],
83			['id' => 51, 'assessment_type_id' => 26, 'locale' => 'en', 'name' => 'Reference check – Micro-reference'],
84			['id' => 52, 'assessment_type_id' => 26, 'locale' => 'fr', 'name' => 'Vérification de référence - Micro-référence'],
85			['id' => 53, 'assessment_type_id' => 27, 'locale' => 'en', 'name' => 'Reference check – Conversation with reference'],
86			['id' => 54, 'assessment_type_id' => 27, 'locale' => 'fr', 'name' => 'Vérification de référence - Conversation avec référence']
87			]);
88			}
89
90			/**
91			* Reverse the migrations.
92			*
93			* @return void
94			*/
95			public function down()
96			{
97			DB::table('assessment_type_translations')->whereIn('id', [
98			1, 2, 3, 4, 5, 6, 7, 8, 9, 10,
99			11, 12, 13, 14, 15, 16, 17, 18, 19, 20,
100			21, 22, 23, 24, 25, 26, 27, 28, 29, 30,
101			31, 32, 33, 34, 35, 36, 37, 38, 39, 40,
102			41, 42, 43, 44, 45, 46, 47, 48, 49, 50,
103			51, 52, 53, 54,
104			])->delete();
105			}
106			}
107

GCTC-NTGC / TalentCloud

Push — feature/unique_email_validatio... ( fb8415...5390cf )

PopulateAssessmentTypeTranslations::up() B

Complexity

Size

Duplication

Importance

How to fix Long Method

Long Method

Duplication Side-by-Side

Filter issues like