Name: MyCart

Description: Shopping cart implementation using React, NodeJs, MySQL, ExpressJs, axios, cors, sequelize, Babel, Webpack, and Electron. (MERN Stack)

NodeJS and MySQL Community Server should be installed.

git clone https://github.com/nishantsahoo/ShoppingCart-React-NodeJs.git

cd API_Node_Folder
npm install
cd ..
cd Front_End_React_Folder
npm install

Open the MySQL Command Line Client and execute the following code

create database shoppingcart

Note: Use "watch" with webpack to develop and deploy continuously

cd Front_End_React_Folder
.\node_modules\.bin\webpack --watch

Note: Express server hosted at localhost:9000

cd API_Node_Folder
npm start

Note: React server hosted at localhost:8000

cd Front_End_React_Folder
npm run webapp

cd API_Node_Folder
npm install
cd ..
cd Front_End_React_Folder
npm install

Open the MySQL Command Line Client and execute the following code

create database shoppingcart

Note: Use "watch" with webpack to develop and deploy continuously

cd Front_End_React_Folder
.\node_modules\.bin\webpack --watch

Note: Express server hosted at localhost:9000

cd API_Node_Folder
npm start

cd Front_End_React_Folder

npm start

or

npm run desktopapp

Database name: shoppingcart

Username: root

Password: root

const db = new Sequelize('shoppingcart', 'root', 'root', {
    host: 'localhost',
    dialect: 'mysql',
    pool: {
        max: 10,
        min: 0,
        idle: 1000
    }
});

1. Products

   id: {
       type: INTEGER,
       primaryKey: true,
   },
   name: STRING,
   price: INTEGER,
   quantity: INTEGER
   

2. Cart

   id: {
       type: INTEGER,
       primaryKey: true,
   },
   name: STRING,
   price: INTEGER,
   quantity: INTEGER,
   amount: INTEGER
   

/myapi/products/

1. /getproducts: To get all products from the products table
2. /addtoproducts: To add a product to the products table

/myapi/cart/

1. /getcart: To get all cart items from the cart table
2. /addtocart: To add a product to the cart
3. /checkout: To checkout from the cart (Removes all products from the cart)
4. /decrementCart: To decrease the quantity of a particular cart item
5. /incrementCart: To increase the quantity of a particular cart item
6. /delfromcart: To delete a particular cart item from the cart
7. /countproducts: To count the number of products in a cart
8. /totalamount: To calculate the total amount to be paid