GET | /search

[Israa91]

Issues Template

relates #5

Route: GET api/v1/search?q=&location=&minPrice=&maxPrice=&rating=&maxResults

Acceptance Criteria

• DB query
• Response
• Testing

---

DB query

SELECT 
kindergarten.kindergarten_name,kindergarten.cover_image,kindergarten.description, 
kindergarten.phone_number,kindergarten.min_price,kindergarten.max_price,
kindergarten.periods,kindergarten.images_gallery,location.location_name,
comments.comment ,comments.rating
FROM 
kindergarten ,location,comments
WHERE
kindergarten_name = q OR min_price = min_price OR max_price=max_price OR location 
IN
(SELECT location_name FROM location WHERE kindergarten.location_id =location.location_id ) OR rating
IN
(SELECT rating FROM comments WHERE kindergarten.kindergarten_id = comments.kindergarten_id);

Response

• Success

{ StatusCode: 200,
  data: [{
          id,
          kindergarten_name,
          cover_image,
          description,
          phone_number,
          latitude,ND
          longitude,
          min_price,
          max_price,
          periods,
          images_gallery,
          create_at
        }]
}

ND

• Failed

{statusCode:400, message:"Bad Request"}

Testing

to be a successful test

• status === 200
• typeof(data) === "array"
• data.length !== 0