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);
}
