<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
use Symfony\Component\Process\Exception\ProcessFailedException;
use Symfony\Component\Process\Process;

class RefillSuperfectaconfigTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        $rand_mysql_password    = md5(rand().rand());
        $superfecta_db_user     = 'fectadbuser';
        $process = new Process(['mysql','-u','root','-e',"CREATE USER '".$superfecta_db_user."'@'localhost' IDENTIFIED BY '".$rand_mysql_password."';"]);
        $process->run();
        $process = new Process(['mysql','-u','root','-e',"GRANT CREATE,INSERT,SELECT on pbx_db_5c188f.leads TO '".$superfecta_db_user."'@'localhost' WITH GRANT OPTION;"]);
        $process->run();
        DB::table('asterisk.superfectaconfig')->delete();
        DB::table('asterisk.superfectaconfig')->insert([
            ['source' => 'base_Default','field' => 'Curl_Timeout','value' => '3'],
            ['source' => 'base_Default','field' => 'order','value' => '0'],
            ['source' => 'base_Default','field' => 'sources','value' => 'Superfecta_Cache,SFDatabase'],
            ['source' => 'base_Default','field' => 'SPAM_Text','value' => 'SPAM'],
            ['source' => 'Default_SFDatabase','field' => 'DB_Driver','value' => 'mysql'],
            ['source' => 'Default_SFDatabase','field' => 'DB_Host','value' => 'localhost'],
            ['source' => 'Default_SFDatabase','field' => 'DB_Name','value' => 'pbx'],
            ['source' => 'Default_SFDatabase','field' => 'DB_Password','value' => $rand_mysql_password],
            ['source' => 'Default_SFDatabase','field' => 'DB_Port','value' => '3306'],
            ['source' => 'Default_SFDatabase','field' => 'DB_User','value' => $superfecta_db_user],
            ['source' => 'Default_SFDatabase','field' => 'Post_Processing_SQL_Query','value' => ''],
            ['source' => 'Default_SFDatabase','field' => 'SQL_Query','value' => 'SELECT CONCAT(first_name,"" "",last_name) FROM leads WHERE phone = :thenumber OR mobile = :thenumber LIMIT 1'],
            ['source' => 'PhoneSpamFilter','field' => 'SPAM_Threshold','value' => '5'],
            ['source' => 'Superfecta_Cache','field' => 'Cache_Timeout','value' => '120'],
            ['source' => 'Trunk_Provided','field' => 'Ignore_Keywords','value' => 'unknown, wireless, toll free, unlisted'],
        ]);
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        $process = new Process(['mysql','-u','root','-e',"DROP user fectadbuser@localhost"]);
        $process->run();
        
        DB::table('asterisk.superfectaconfig')->truncate();
    }
}