AddTranslatedNameAndDescriptionToSkillsTable::down() - Code Metrics - Inspection of "Remove key column from Skills table" - GCTC-NTGC/TalentCloud - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — feature/backpack ( 16fb41...46736d )

by Chris

created 2019-02-05 16:23 UTC

down() A

↳ Parent: AddTranslatedNameAndDescriptionToSkillsTable

Complexity

Conditions	1
Paths	1

Size

Total Lines	4
Code Lines	2

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
eloc	2
dl	0
loc	4
rs	10
c	1
b	0
f	0
cc	1
nc	1
nop	0

<?php

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

use App\Models\Skill;

class AddTranslatedNameAndDescriptionToSkillsTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::table('skills', function (Blueprint $table) {
            $table->json('name')->nullable();
            $table->json('description')->nullable();
        });

        $skills = Skill::all();
        $langEn = Lang::get('common/skills.skills', [], 'en');
        $langFr = Lang::get('common/skills.skills', [], 'fr');

        foreach ($skills as $skill) {
            if (!array_key_exists($skill->key, $langEn) || !array_key_exists($skill->key, $langFr)) {
            if (!array_key_exists($skill->key, /** @scrutinizer ignore-type */ $langEn) || !array_key_exists($skill->key, $langFr)) {
                continue;
            }
            $skill
                ->setTranslation('name', 'en', $langEn[$skill->key]['name'])
                ->setTranslation('name', 'fr', $langFr[$skill->key]['name'])
                ->setTranslation('description', 'en', $langEn[$skill->key]['description'])
                ->setTranslation('description', 'fr', $langFr[$skill->key]['description'])
                ->save();
        }
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::table('skills', function (Blueprint $table) {
            $table->dropColumn(['name', 'description']);
        });
    }
}


GCTC-NTGC / TalentCloud

Push — feature/backpack ( 16fb41...46736d )

down() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like