In this project we were asked to create a Burger app that used Express and Handlebars. Below are the instructions on how I built the app as well as the instructions on how to run it.
Create a GitHub repo called burger and clone it to your computer. Make a package.json file by running npm init from the command line. Install the Express npm package: npm install express. Create a server.js file. Install the Handlebars npm package: npm install express-handlebars. Install the body-parser npm package: npm install body-parser. Install MySQL npm package: npm install mysql.
Require the following npm packages inside of the server.js file:
express body-parser
Inside your burger directory, create a folder named db. In the db folder, create a file named schema.sql. Write SQL queries this file that do the following:
Create the burgers_db. Switch to or use the burgers_db. Create a burgers table with these fields:
id: an auto incrementing int that serves as the primary key.
burger_name: a string.
devoured: a boolean.
Still in the db folder, create a seeds.sql file. In this file, write insert queries to populate the burgers table with at least three entries. Run the schema.sql and seeds.sql files into the mysql server from the command line Now you're going to run these SQL files.
Make sure you're in the db folder of your app. Start MySQL command line tool and login: mysql -u root -p. With the mysql> command line tool running, enter the command source schema.sql. This will run your schema file and all of the queries in it -- in other words, you'll be creating your database. Now insert the entries you defined in seeds.sql by running the file: source seeds.sql. Close out of the MySQL command line tool: exit.
Inside your burger directory, create a folder named config. Create a connection.js file inside config directory.
Inside the connection.js file, setup the code to connect Node to MySQL. Export the connection.
Create an orm.js file inside config directory.
Import (require) connection.js into orm.js
In the orm.js file, create the methods that will execute the necessary MySQL commands in the controllers. These are the methods you will need to use in order to retrieve and store data in your database.
selectAll() insertOne() updateOne()
Export the ORM object in module.exports.
Inside your burger directory, create a folder named models.
In models, make a burger.js file. Inside burger.js, import orm.js into burger.js
Also inside burger.js, create the code that will call the ORM functions using burger specific input for the ORM. Export at the end of the burger.js file.
Inside your burger directory, create a folder named controllers. In controllers, create the burgers_controller.js file. Inside the burgers_controller.js file, import the following:
Express burger.js
Create the router for the app, and export the router at the end of your file.
Inside your burger directory, create a folder named views.
Create the index.handlebars file inside views directory.
Create the layouts directory inside views directory.
Create the main.handlebars file inside layouts directory. Setup the main.handlebars file so it's able to be used by Handlebars. Setup the index.handlebars to have the template that Handlebars can render onto. Create a button in index.handlebars that will submit the user input into the database.
All the recommended files and directories from the steps above should look like the following structure:
. ├── config │ ├── connection.js │ └── orm.js │ ├── controllers │ └── burgers_controller.js │ ├── db │ ├── schema.sql │ └── seeds.sql │ ├── models │ └── burger.js │ ├── node_modules │ ├── package.json │ ├── public │ └── assets │ ├── css │ │ └── burger_style.css │ └── img │ └── burger.png │ │ ├── server.js │ └── views ├── index.handlebars └── layouts └── main.handlebars
In your terminal you will need to cd to the file/folder
Then install & run:
$ npm install $ npm install express $ npm install express-handlebars $ npm install body-parser $ npm start
- Express
- Handlebars
- Css
- Javascript
- MySqul
- Terminal (Bash)I enjoyed working on this assignment but found it to be very difficult since it was our first time working with so many files but I feel that it is something I will pick up as we practice more.
[Link to Project](https://github.com/OCGedeon/Burger)
[Heroku Project link] (https://burgerbruh.herokuapp.com/)