/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
DB::statement("SET FOREIGN_KEY_CHECKS = 0");
Provider::truncate();
$fileName = '2016-02-25-providers';
$table_name = 'providers';
$fullFile = 'database/seeds/main/csv/' . $fileName . '.csv';
$query = sprintf("LOAD DATA local INFILE '%s' INTO TABLE {$table_name} FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\"' ESCAPED BY '\"' LINES TERMINATED BY '\\n'", addslashes($fullFile));
DB::connection()->getPdo()->exec($query);
DB::statement("SET FOREIGN_KEY_CHECKS = 1");
}
