Oh!Bad Burger APP

PROJECT13: 25TH MAY 2020
https://aqueous-wildwood-59065.herokuapp.com/#

Aim

This week we focus on using Handlebars, MySQL and Express within Node.JS to make an app which allows the user to devour burgers. This will then be uploaded to Heroku for marking. However, for flare I wanted to also allow the option to customize your burger...

User Story

As a CUSTOMER, I want to be able to order a custom burger. I WANT to be able to delete and update orders SO THAT I can keep a history of my purchases.

Key Concepts

Handlebars, MySQL Cascade property, ORMs, Async and MVC

Contents

• Build Process
• Project Issues
• Future Plans
• Installation
• Usuage
• Tests
• Additional_Information

Build Process

This week was maybe about MVC's and really organising mySQL tables, your folders and views to follow those core concepts. This is easily visible in how apiController.js, burgers.js, orm.js and 'script.js' files interacted with one another. Folder locations like public and how information was passed via callbacks litered this project.

When I started I heard there was a cat project that was very similiar to our homework assignment. Whilst in theory this was true, in reality I should have never taken this as a cue to do what I done... make a custom burger app. As I was doing this, I began with Photoshop and started designing my assets.

After the assets was complete I started using the code from day3/17-CatsApp as a baseline of how to organise my code and change what was needed. Next I made my template tables with mySQL and then started hammering away.

Unfortunately, for time restrictions... I used bootstrap. This will be changed!~~~

Core things I learnt.

1. Nesting, though ugly is sometimes the best approach to problem.
2. When requesting information from mySQL make sure your capital and uppercase checks out
3. Don't rely on things like CatsApp to help you... i don't understand so many things in there
4. Ambition is great.... but its expensive
5. parseInt, JSON.stringfy and other tools are your friend
6. script.js and AJAX plays a major part in your req.body and req.params search
7. Loops are your friend but make sure they end
8. Remember to do something with your responses.
9. MySQL reference tables, Delete and Update cascades
10. How to validate forms with script.js and regEx

I learnt alot with this project but it was taxing.

Project Issues

How do you do forms correctly? How do you find their values correctly? If you are using handlebars, how will you grab a value and change it after the page loads.

Honestly, there was so many things to learn this time around. Besides trying to push multiple MySQL requests to different tables at the same time (Thank you Luke... your AMAZING!)... the issues were never ending. The biggest problem with MVC is an issue within 1 file can affect all the others. So instead of fixing 1 line of code, you might be fixing ever folder that interacts with that line of code. There was a lot of these issues.

Core problems

1. I don't understand querystrings from the CatsApp example
2. I still not 100% about how forms work and validation is painful
3. Interacting with multiple tables and getting errors "Header issues" though educational is painful
4. I don't like bootstrap... but sometimes its a godsend
5. There has to be a method to edit handlebars output...
6. I did not use the ORM file correctly as I had issues passing data. This is most likely to not using query string or the question function. I did not understand their usuage as code and thus tried to work around it.
7. Using script.js to make buttons work correctly and the relationship to req.body is still alien to me
8. MySQL requests of VALUE vs BY was annoying. Had to fall back on the VALUE tag to sure things would work
9. Join request should not be in the ORM
10. Still not confident about the entire / get process

Happy its done and leason learnt

Future plans

Currently outstanding issues

1. Should be able to order Burger without Sauce, Topping or patty
2. Price should be correctly formated
3. Tables should be correctly marginalised
4. Bootstrap removed
5. Clean up my code
6. Double click still appears to be an issue.
7. Replace all validation alerts with custom pop up boxes

26/05/20202 Fixed issue with Date by using Handlebars-helper Double click is still an issue but added an alert to avoid additional clicks Updated both Heroku and MySQL time zones but appears to have no affect on the displayed time

Installation

1. Copy project from GitHub page. Open terminal,

$ cd homeworkW13
$ npm install
$ node server.js

2. Setup MySQL with seeds. Seeds are located in the ./db folder. Copy the text from the;

• schema.sql Contains the database and table commands
• seeds.sql Contains the seeds for the tables

OR go to https://aqueous-wildwood-59065.herokuapp.com/#

Usuage

Show an example of a burger ordering website

Tests

No time to make notes :(
Some validators have been installed

Additional Information

Licenses: MIT

Resources

• NPMJS.com
• W3 Schools
• Medium
• Developer.mozilla.org
• Stackoverflow.com
• Resources provided in Slack
• Youtube tutorials
• Dillinger.io
• Handlebars-Helper

Technology

• Heroku
• Node.JS
• Javascript
• Inquirer
• Visual Studio Code
• GitHub
• Google Chrome
• mySQL
• Chalk
• Sequel Pro
• JawsDB
• ZOOM

Source

Code was originally supplied in the WAUS-CRAW-FSF-PT-02-2020-U-C-MW / Week 13 / Homework repository on GitLab https://waustralia.bootcampcontent.com/the-university-of-western-australia/WAUS-CRAW-FSF-PT-02-2020-U-C-MW/tree/master/Week%2013/Homework/Instructions

Joshua K Bader // Ryuku72 // jaybshinsen@hotmail.com

Made with ReadMe.Md Generator