/**
* Execute the console command.
*
* @return mixed
*/
public function handle()
{
$raw = array_map('str_getcsv', file('data.csv'));
$data = array_slice($raw, 1);
foreach ($data as $row) {
$location = Location::firstOrCreate(['county' => $this->county($row[0]), 'city' => $this->city($row[1]), 'state' => $this->state($row[0])]);
$product = Product::create(['name' => $row[2], 'freight' => $this->float($row[4]), 'margin' => $this->float($row[5]), 'delivered_price' => $this->float($row[6]), 'location_id' => $location->id]);
}
$this->info(sprintf("Imported %d locations and %d products\r", Location::count(), Product::count()));
}
/**
* Execute the console command.
*
* @return mixed
*/
public function handle()
{
$this->comment(sprintf("Deleting %d products and %d locations", Product::count(), Location::count()));
Product::all()->each(function ($doc) {
$doc->delete();
});
Location::all()->each(function ($doc) {
$doc->delete();
});
}
