your review query doesnt work check it

even though you are using some of them in tests make sure that you use what your are testing

I don't get it, The search doesn't seem to work, and reviews are not being added

I feel like I'm lost, I don't want to say that it is not working application, but that's how it looks like in my browser.
we can't code review any broken sites or not finished codes.

I think you should act like the clients are stupid people who you should explain everything to them, and don't let them suffer by cloning and adding some sentences so it works, please make our life easier

I think you just need to update the expectations to reflect your default data changes, and you'll be 💯

tape, supertest, tap-spec
nodemon

server.js, router.js, handlers.js

Looks wonderful on mobile. You should be able to make it responsive (i.e. look good on desktop) very easily, try removing grid-template-columns: 1fr 1fr 1fr; and adding a sensible max-width.

It seems like your server crashes when the user searches for a place that doesn't exist 💥

search query (with autocomplete if time allows)
add rating/review

CoffeeBros

- Places

 - ID
 - name
 - rating
 - address
 - google map

- Review

 - ID
 - place_id
 - comment
 - rating

- Address

 - ID
 - City
 - Street

- Pictures

 - ID
 - Place ID
 - PictureURL

accessibility check gives 63%

It's not clear that the first is a dropdown and the second is a button 🤷‍♀️

• handle endpoint | [ ] parse url to get place and city
• call handler for search | [ ] connect to the db
  👍 👍 | - [ ] get data and return it

This is a bit of a 🙀- you don't want to rely on an arbitrary number of milliseconds to know when an operation is finished.

You can rewrite this in a clever way using something like a parallel function, or you can use promises instead of callbacks (I know we haven't covered that yet).

But in your case it's actually quite inefficient to be looping through an array and making a database query for each of them. I'm pretty sure you can make use of the power of SQL here and do it all in one query using a clever little JOIN 😎

• get Reviews
• get Places
• get Address By ID
• get Places By Name
• get Latest Reviews
• get Review By Place ID
• get Pictures By Place ID
• get Place Details By ID
• get Map By Place ID
• get Top Places
• insert review

TypeError: Cannot read property 'address_id' of undefined
at selectQueries.getPlacesByName (/home/karam/Desktop/FACN5/Team-Projects/Week06/Review/CoffeeBros/src/handlers.js:65:50)
at databaseConnection.query (/home/karam/Desktop/FACN5/Team-Projects/Week06/Review/CoffeeBros/database/queries/selectquery.js:8:7)
at Query.client.query (/home/karam/Desktop/FACN5/Team-Projects/Week06/Review/CoffeeBros/node_modules/pg-pool/index.js:300:18)
at Query.handleReadyForQuery (/home/karam/Desktop/FACN5/Team-Projects/Week06/Review/CoffeeBros/node_modules/pg/lib/query.js:125:10)
at Connection. (/home/karam/Desktop/FACN5/Team-Projects/Week06/Review/CoffeeBros/node_modules/pg/lib/client.js:215:19)
at emitOne (events.js:116:13)
at Connection.emit (events.js:211:7)
at TLSSocket. (/home/karam/Desktop/FACN5/Team-Projects/Week06/Review/CoffeeBros/node_modules/pg/lib/connection.js:125:12)
at emitOne (events.js:116:13)
at TLSSocket.emit (events.js:211:7)
[nodemon] app crashed - waiting for file changes before starting...

🤓