Sequelized Burger

The purpose of this project was to highlight a Full Stack application setup using the MVC design pattern.

This project updates the Burger project to use sequelize as well as adding some additional functionality with associating customers to the flow.

• The MODEL establishes the the database tables using Sequelize via files in the models folder.
• The VIEW is handled using Express Handlebars to present the data from the database based on files in the views folder.
• The CONTROLLER determines the routing of the information, GET, POST, or PUT, based on the files in the controllers folder.

Author

Tim Shaffer

Contents

• Deployment
• Tech Used
• MVC Directory Structure
• Instructions

Deployment

The app is deployed to HEROKU at the following link: https://tim-shaffer-burger2.herokuapp.com/

Tech Used

• JavaScript
  • constructors
• Node.js
  • Express
    • get
    • post
    • use
    • engine
    • set
    • handlebars
  • mysql
  • sequelize
• HTML
• CSS
• Bootstrap
• jQuery
• MySQL
  • SQL
    • CREATE DATABASE
    • USE DATABASE
    • CREATE TABLE
    • INSERT INTO
    • ALTER TABLE
    • SELECT
    • UPDATE

MVC Directory Structure

├── sequelizedBurger
│   ├── config
│   │   └── config.js
│   ├── controllers
│   │   ├── burgers_controller.js
│   │   └── customers_controller.js
│   ├── db
│   │   └── schema.sql
│   ├── models
│   │   ├── burger.js
│   │   ├── customer.js
│   │   └── index.js
│   ├── public
│   │   └── assets
│   |       ├── css
│   │       |   └── burger_style.css
│   |       ├── img
│   │       |   └── Good_Burger.jpg
│   |       └── js
│   │           ├── burgers.js
│   │           └── customers.js
│   └── views
│       ├─── layouts
│       |       └── main.handlebars
│       ├─── partials
│       |       ├─── burgers
│       |       |    └── burger-block.handlebars
│       |       └─── customers
│       |            └── customer-block.handlebars
|       ├── cust_burger.handlebars
|       ├── customer.handlebars
│       └── index.handlebars
├── .gitignore
├── package.json
├── README.md
└── server.js

Instructions

1. Clicking the HEROKU link - - will take you to the Home Page.

   

2. From the Main Menu you can Mange Customers or Order Burgers. However, if you try to go to Order Burgers before adding any customers, it will take you to the Manage Customers view instead.

   

3. Add a Customer by entering it into the textbox.

   

4. Click the Submit button and the Customer will be added to a Customer table along with # of burgers, a direct link to Order Burgers for that Customer, and a Delete Customer link.

   

5. Now, burgers can be ordered for a customer!. Selecting Order next to the customer will take you to the Burger Ordering screen and default the Customer Name into the selection box.

   

6. Add a Burger that you would like to order for the customer by entering it into the textbox.

   

7. Click the Submit button and the burger will be added to the Burgers To Eat list with an associated Devour It! button.

   

8. Enter more burgers to eat in the same manner.

   

9. Click on a particular burgers Devour It! button and the burger will be updated as devoured and moved to the Burgers Already Eaten list.

   

10. Return to the Customer's View by selecting the Manage Customers button and the page will now show the total burgers processed per customer.

    

11. Add multiple customers and associate burgers in the same manner as above and the display will show all the customers and their burger totals on separate lines.

    

12. Return to the Home Page by clicking Go to Main Menu.

    

13. Selecting Order Burgers at this point will display all the burgers and the customers on the same screen.

    

14. More burgers can be added by selecting the customer from the list, entering a new burger, and then clicking Submit like the prior flow.

    

15. The burger is added with the associated Customer. The normal function of devouring a burger can also be done from this view.

    

16. Return to the Manage Customer display and it will show all the customers and their burger totals on separate lines.

    

17. To remove a Customer and all the burgers associated with them, select the Delete Customer option on the line of that customer.