public function run() { $row = 1; if (($handle = fopen(storage_path() . "/csvs/breweries.csv", "r")) !== FALSE) { while (($data = fgetcsv($handle)) !== FALSE) { $zip = $data[6]; // echo $zip . PHP_EOL; try { // echo Location::where('postalCode',$zip)->toSql(); $loc = Location::where('postalCode', $zip)->firstOrFail(); $locId = $loc->locId; $brewery = new Brewery(); $brewery->brewery_id = $data[0]; $brewery->name = $data[1]; $brewery->address = $data[2]; $brewery->phone = $data[8]; $brewery->website = $data[9]; $brewery->description = $data[11]; $brewery->locId = $locId; $brewery->save(); } catch (Exception $e) { // echo $e->getMessage(); // throw $e; } } fclose($handle); } else { echo 'false?'; } }
function test_deleteBeer() { //Arrange $name = "Yards Brewing Co."; $location = "Philthadone"; $link = "www.makebeer.com"; $test_brewery = new Brewery($name, $location, $link); $test_brewery->save(); $id = null; $name = "Lip Blaster"; $type = "IPA"; $abv = 4.2; $ibu = 10; $region = "Pacific Northwest"; $brewery_id = $test_brewery->getId(); $test_beer = new Beer($id, $name, $type, $abv, $ibu, $region, $brewery_id); $test_beer->save(); $name = "Hip Hops"; $type = "Pale Ale"; $abv = 3.2; $ibu = 4; $region = "South Central LA"; $brewery_id = $test_brewery->getId(); $test_beer2 = new Beer($id, $name, $type, $abv, $ibu, $region, $brewery_id); $test_beer2->save(); //Act $test_brewery->deleteBeer($test_beer); //Assert $result = $test_brewery->getBeers(); $this->assertEquals([$test_beer2], $result); }