<?php

namespace Modules\Params\Database\Seeds;

use CodeIgniter\Database\Seeder;

class ProvinceSeeder extends Seeder
{
    public function run()
    {
        foreach ($this->provinces() as $province) {
            # code...
            $this->db->table("params_provinces")->insert($province);
        }
    }

    private function provinces() : Array {
        return [
            ['id' => 1, 'description' => 'BUBANZA', 'latitude' => '-3.08459', 'longitude' => '29.3948'],
            ['id' => 2, 'description' => 'BUJUMBURA', 'latitude' => '-3.34607', 'longitude' => '29.4835'],
            ['id' => 3, 'description' => 'BUJUMBURA MAIRIE', 'latitude' => '-3.3931005', 'longitude' => '29.3690935'],
            ['id' => 4, 'description' => 'BURURI', 'latitude' => '-3.94794', 'longitude' => '29.6169'],
            ['id' => 5, 'description' => 'CANKUZO', 'latitude' => '-3.14362', 'longitude' => '30.2973'],
            ['id' => 6, 'description' => 'CIBITOKE', 'latitude' => '-2.84977', 'longitude' => '28.9592'],
            ['id' => 7, 'description' => 'GITEGA', 'latitude' => '-3.43143', 'longitude' => '29.9079'],
            ['id' => 8, 'description' => 'KARUSI', 'latitude' => '-3.14937', 'longitude' => '29.8351'],
            ['id' => 9, 'description' => 'KAYANZA', 'latitude' => '-3.01417', 'longitude' => '29.3533'],
            ['id' => 10, 'description' => 'KIRUNDO', 'latitude' => '-2.55596', 'longitude' => '29.8933'],
            ['id' => 11, 'description' => 'MAKAMBA', 'latitude' => '-4.20607', 'longitude' => '29.5075'],
            ['id' => 12, 'description' => 'MURAMVYA', 'latitude' => '-3.26797', 'longitude' => '29.6152'],
            ['id' => 13, 'description' => 'MUYINGA', 'latitude' => '-2.84551', 'longitude' => '30.3337'],
            ['id' => 14, 'description' => 'MWARO', 'latitude' => '-3.51254', 'longitude' => '29.693'],
            ['id' => 15, 'description' => 'NGOZI', 'latitude' => '-2.90847', 'longitude' => '29.8057'],
            ['id' => 16, 'description' => 'RUMONGE', 'latitude' => '-3.97226', 'longitude' => '29.4305'],
            ['id' => 17, 'description' => 'RUTANA', 'latitude' => '-3.92546', 'longitude' => '29.9823'],
            ['id' => 18, 'description' => 'RUYIGI', 'latitude' => '-3.47421', 'longitude' => '30.2379']
        ];
    }
}
