larafoster / ecommerce-backend Goto Github PK

Internet retail, also known as e-commerce, is the largest sector of the electronics industry, generating an estimated $29 trillion in 2019. E-commerce platforms like Shopify and WooCommerce provide a suite of services to businesses of all sizes. This application is an example of the back end for an e-commerce site using Express, API routes, Postman and MySQL.

• Installation
• Project Links
• Contribute
• Credits
• License

Once you clone this repository, you will need to follow these steps:

1. Connect to your mysql server. Open the index file and change the db password.
2. In your terminal, you will need to cd into the database folder and source the sql files.
3. Cd back to the path containing the index file and install the node modules, by running npm install.
4. To start the app, type 'node index' in the terminal.
5. Use Postman or Insomnia to test the api's.

Project Links:

• Github Repo

View this app in motion:

• video of technical requirements
• video of GET All in Postman
• video of GET by ID in Postman - video of PUT by ID in Postman
• video of POST in Postman
• video of DELETE by ID in Postman

This project is created with the following technologies:

• Node.js
• Express.js
• sequelize
• Mysql

The code for this project was researched extensively. Here are a few of the tutorials I found helpful:

• database schema

• mysql JOIN

• mysql foreign key

• example using inquirer with mysql

• tips on using inquirer with mysql

          connection.query("INSERT INTO employee (first_name, last_name, manager) 
               VALUES ?", ('first_name', 'last_name', 'manager'), function (err, result) {
              if (err) throw err;
  })
  

  Contribute

  Please feel free to fork this project and create your own branch. Any suggestions for improvement are welcomed.

This project is licensed under the MIT License

Contact me if you have any questions about this project:

• Send me an email

You can find my projects on Github:

• Find me on Github