A simple app using Node.js, Express, Handlebars, and MySQL.
This is the main route that a user will interact with. When hit it renders
the index template (within the main layout). This template shows a list of
uneaten (with a button to devour) burgers and eaten (already devoured)
burgers. This utilizes a GET request to grab all of the burgers from the
database, separated into eaten and uneaten.
The user also has the ability to create a new burger. This utilizes a POST
request that creates the new burger in the database.
When the devour button is selected, the burger is updated in the database
using a PUT request.
A user can select the API Burgers List in the footer to view all of the burger
data in the database. This is done through a GET request. This route is
api/burgers.
A user can also type in the route api/burgers/:id where :id is the id of the
burger they would like to view data on. This will display the data for that
specific burger. This is also done through a GET request.
Each burger has an id, burger_name, devoured, and created_at. The id
is the primary key and is auto-incremented. You will notice that when a user
creates a new burger they are only submitting the name of the burger. This is
because the devoured and created_at attributes have default values. The
devoured attribute is defaulted to false and the created_at attribute is
defaulted to the timestamp of the creation of the burger.