Welcome to Omakase, an application that curates food selection for you.
You can uncomment EnsureSchema() in the server/server.js file to create the database.
Backend: In the db.js file we create our schema for our mysql database. We have the following functions in place. ensureSchema() and deleteEverything().
In the server/server.js file you call ensureSchema() after the server.listen command so the database schema will be created.
If you wish to delete the current schema you must do so on the hosted website. Or you can call the DeleteEverything() function in the db.js file. In order to access the database you must follow the instructions outlined in the example.env file. The knexfile.js contains the required information to connect to the database, if you wish to use a different database you can do so by specifying your host, and database type there.
All api endpoints and schema information is documented in our google doc. See a link here.
Relationships: User - Dish (one to many) Location - Dish ( one to many w/ join table) Users - Dish (many to many)
API ENDPOINTS (Client side): /api/google: To retrieve restaurant results from google make an AXIOS POST request and include: data = { "location": "", "restaurant":"" }
/api/user/add: To add a user make an AXIOS GET request and include: params = { "id": "", "name": "" }
/api/user/check: To check if a user exists (for login) make an AXIOS GET request and include: params = { "id": "", "name": "" }
/api/search/restaurant: To retrieve the top restaurant make an AXIOS POST request and include: data = { "dish_name": "", "location_name": "" }
/api/dish/add: To add a dish make an AXIOS POST request and include: data = { "Dish" : { "dish_name" : "", "voteCount": 1 }, "Location": { "location_name" : "", }, "Restaurant": { "restaurant_name": "", "address": "
", "zipcode": "", "imageUrl": "" } }You can see our deployed application here