<?php

namespace Database\Seeders;

use Illuminate\Database\Console\Seeds\WithoutModelEvents;
use Illuminate\Database\Seeder;
use Illuminate\Support\Facades\DB;

class ExpertiseWorkAreasSeeder extends Seeder
{
    /**
     * Run the database seeds.
     *
     * @return void
     */
    public function run()
    {

        // todo: determine which areas of work are assigned to which expertise, for now we are assigning based on ID

        DB::table('work_areas_expertise')->insert([
            'work_area_id' => 1,
            'expertise_id' => 1,
        ]);
        DB::table('work_areas_expertise')->insert([
            'work_area_id' => 2,
            'expertise_id' => 1,
        ]);
        DB::table('work_areas_expertise')->insert([
            'work_area_id' => 3,
            'expertise_id' => 1,
        ]);

        DB::table('work_areas_expertise')->insert([
            'work_area_id' => 4,
            'expertise_id' => 2,
        ]);
        DB::table('work_areas_expertise')->insert([
            'work_area_id' => 5,
            'expertise_id' => 2,
        ]);
        DB::table('work_areas_expertise')->insert([
            'work_area_id' => 6,
            'expertise_id' => 2,
        ]);

        DB::table('work_areas_expertise')->insert([
            'work_area_id' => 7,
            'expertise_id' => 3,
        ]);
        DB::table('work_areas_expertise')->insert([
            'work_area_id' => 8,
            'expertise_id' => 3,
        ]);
        DB::table('work_areas_expertise')->insert([
            'work_area_id' => 9,
            'expertise_id' => 3,
        ]);
    }
}