sayex/amazon-like-store

amazon-like-store

Use CLI to run program

The SQL Statments and Inquirer

• I wanted to show how to join tables so I created a departments table and used the ID of that department in the products table. I then created a view to join the tables together. My CLI app uses this view instead of coding a join statment in my node.js server.

• I included a seeds.sql file that will create the database, tables, populate the tables and create the view nessesary for my CLI App to run.

• Instead of console.loging a table or using an NPM console.table, I present the user with a list of items they can buy.

• I then take the line number and use it for the ID since the ID I put as the line number when it was displayed in the CLI.

Project goals

The app should then prompt users with two messages.

• The first should ask them the ID of the product they would like to buy.
• The second message should ask how many units of the product they would like to buy.

1. Once the customer has placed the order, your application should check if your store has enough of the product to meet the customer's request.

   • If not, the app should log a phrase like Insufficient quantity!, and then prevent the order from going through.

2. However, if your store does have enough of the product, you should fulfill the customer's order.

   • This means updating the SQL database to reflect the remaining quantity.
   • Once the update goes through, show the customer the total cost of their purchase.