samybm / cli_app-sql Goto Github PK

1-I crashed my REPO SERVER on GITHUB- AFTER many hours of trying to resolve all sorts of errors codes. I found from my research that the best course of actions was to delete my repo entinterly and reclone and posting to gthub etc

2- figured out as well from problem stated above that- after attemped fixed and program updates - I had a package.lock npm uncapatablity dependices issues.

NOTES

• Boot leg Amazon

1- create users 2- create order process 3-create inventory

bonus- create tab/display of "Most order' from inventory

+++++++++(COMPLETE)++++++JSON package-npm packages= Data input and storage 1-mysql 2-inquirer

1.CHECK MySQL Database = samazon.

2. Table in 'samazon' products.

3. table- columns:

1-item_id (unique id for each product)

 2- product_name (Name of product)

     3- department_name

        4- price (cost to customer)

            5- stock_quantity (how much of the product is available in stores)

4 TABLE= 10 different products. (i.e. Insert "mock" data rows into this database and table).

NODE - ...>>>>>?>

CHECK* 1- Node application called samazonCustomer.js.

2- application will first display all of the items available for sale. Include the ids, names, and prices of products for sale.

3- The app should then prompt users with two messages. 1- The first should ask them the ID of the product they would like to buy. 2-The second message should ask how many units of the product they would like to buy.

4- placed order, application should check check "If else inventory" FALSE= ...>>>>> If not, the app should log a phrase like Insufficient quantity!, = NO ORDER!!!!

        TRUE=.>>>>.  you should fulfill the customer's order.

4.5 -----------UPDATE #### 4 --- This means updating the SQL database to reflect the remaining quantity.

4.5 *update______ show the customer the total cost of their purchase.

DONE WITH LEVEL 1(expected 8-10 hour of coding) - IF YOU HAVE MORE TIME_ TRY THE NEXT LEVEL_ THERE ARE THREE IN TOTAL

SUBMISSION GUIDELINES-

CREATE ZOOM OF USER EXP-

• Include screenshots (or a video) of typical user flows through your application (for the customer and if relevant the manager/supervisor). This includes views of the prompts and the responses after their selection (for the different selection options).

• Include any other screenshots you deem necessary to help someone who has never been introduced to your application understand the purpose and function of it. This is how you will communicate to potential employers/other developers in the future what you built and why, and to show how it works.

• Because screenshots (and well-written READMEs) are extremely important in the context of GitHub, this will be part of the grading.

If you haven't written a markdown file yet, click here for a rundown