function delete() { $reviews = Review::getAll(); foreach ($reviews as $review) { if ($review->getRestaurantId() == $this->getId()) { $review->delete(); } } $GLOBALS['DB']->exec("DELETE FROM restaurants WHERE id = {$this->getId()};"); }
static function find($search_id) { $found_review = null; $reviews = Review::getAll(); foreach ($reviews as $review) { $review_id = $review->getId(); if ($review_id == $search_id) { $found_review = $review; } } return $found_review; }
function test_getAll() { //Arrange $review = "Pizza was dope"; $restaurant_id = 1; $test_review = new Review($review, $restaurant_id); $test_review->save(); $review2 = "DAMN DAT GRILLED CHEESE IS FIRE"; $restaurant_id2 = 2; $test_review2 = new Review($review2, $restaurant_id2); $test_review2->save(); //Act $result = Review::getAll(); //Assert $this->assertEquals([$test_review, $test_review2], $result); }
function test_save() { $restaurant = new Restaurant("Pok Pok", 2, "5", "1", "website", 2); $name = "Bob"; $id = null; $rating = 3; $review_text = "B"; $review_date = "2015-10-10"; $restaurant_id = $restaurant->getId(); $test_Review = new Review($name, $id, $rating, $review_text, $review_date, $restaurant_id); $test_Review->save(); $result = Review::getAll(); $this->assertEquals($test_Review, $result[0]); }
function test_deleteReviews() { $name = "Asian"; $id = null; $test_cuisine = new Cuisine($name, $id); $test_cuisine->save(); $restaurant_name = "The Golden Duck"; $location = "898 SW 5th Ave, Portland, OR"; $description = "A Chill Asian experince"; $price = "\$\$"; $cuisine_id = $test_cuisine->getId(); $test_restaurant = new Restaurant($restaurant_name, $location, $description, $price, $cuisine_id); $test_restaurant->save(); $restaurant_name2 = "The Red Dragon"; $location2 = "899 SW 5th Ave, Portland, OR"; $description2 = "A Intense Asian experince"; $price2 = "\$\$\$"; $cuisine_id2 = $test_cuisine->getId(); $test_restaurant2 = new Restaurant($restaurant_name2, $location2, $description2, $price2, $cuisine_id2); $test_restaurant2->save(); $user = "******"; $stars = 3; $headline = "It is aight."; $body = "Yeah, pretty aight bro"; $restaurant_id = $test_restaurant->getId(); $test_review = new Review($user, $stars, $headline, $body, $restaurant_id); $test_review->save(); $user2 = "6969babygirl"; $stars2 = 3; $headline2 = "XOXO"; $body2 = "I cant even"; $restaurant_id2 = $test_restaurant->getId(); $test_review2 = new Review($user2, $stars2, $headline2, $body2, $restaurant_id2); $test_review2->save(); $test_restaurant->delete(); $result = Review::getAll(); //var_dump($result); $this->assertEquals([], $result); }
function test_deleteAll() { //Arrange $beer_id = 1; $user_id = 1; $review = "Great beer"; $date = "2015-10-08"; $id = 3; $test_review = new Review($beer_id, $user_id, $review, $date, $id); $test_review->save(); //Act $test = Review::deleteAll(); $result = Review::getAll(); //Assert $this->assertEquals([], $result); }
function test_DeleteCuisineRestaurantsReviews() { //Arrange //cuisine $name = "Japanese"; $id = null; $test_cuisine = new Cuisine($name, $id); $test_cuisine->save(); //restaurant $name = "Good Fortune"; $cuisine_id = $test_cuisine->getId(); $description = "very tasty."; $address = "1111 SW 11th Ave"; $test_restaurant = new Restaurant($name, $id, $cuisine_id, $description, $address); $test_restaurant->save(); //review $username = "******"; $date = 00 - 00 - 00; $rating = 5; $comment = "good one."; $restaurant_id = $test_restaurant->getId(); $test_review = new Review($username, $date, $rating, $comment, $restaurant_id, $id); //Act $test_cuisine->delete(); //Assert $this->assertEquals([], Review::getAll()); }
function test_deleteAll() { //Arrange $rating = 1; $comment = "This place sucks!"; $id = null; $test_review = new Review($rating, $comment, $id); $test_review->save(); $rating2 = 2; $comment2 = "This place smells!"; $id2 = null; $test_review2 = new Review($rating2, $comment2, $id2); $test_review2->save(); //Act Review::deleteAll(); //Assert $result = Review::getAll(); $this->assertEquals([], $result); }
$restaurant->save(); $cuisine = Cuisine::find($cuisine_id); return $app['twig']->render('cuisine.html.twig', array('cuisine' => $cuisine, 'restaurants' => $cuisine->getRestaurants())); }); //Reviews page $app->get("/restaurants/{id}", function ($id) use($app) { $restaurant = Restaurant::find($id); return $app['twig']->render('restaurant.html.twig', array('restaurant' => $restaurant, 'reviews' => $restaurant->getReviews())); }); $app->post("/reviews", function () use($app) { $username = $_POST['username']; $date = $_POST['date']; $rating = $_POST['rating']; $comment = $_POST['comment']; $restaurant_id = $_POST['restaurant_id']; $review = new Review($username, $date, $rating, $comment, $restaurant_id, $id = null); $review->save(); $restaurant = Restaurant::find($restaurant_id); return $app['twig']->render('restaurant.html.twig', array('restaurant' => $restaurant, 'reviews' => Review::getAll())); }); //Cuisine_edit page $app->get("/cuisines/{id}/edit", function ($id) use($app) { $cuisine = Cuisine::find($id); return $app['twig']->render('cuisine_edit.html.twig', array('cuisine' => $cuisine)); }); //Search result page $app->get("/search", function () use($app) { $search = Restaurant::search($_GET['search']); return $app['twig']->render('search.html.twig', array('search' => $search, 'search_term' => $_GET['search'])); }); return $app;