heloflier / bamazon

a node application to replicate a customer order and inventory process with SQL

bamazon

A node application to replicate a customer order and inventory process with SQL

Completed 3 node modules:

• BAMAZONCUSTOMER.JS
• BAMAZONMANAGER.JS
• BAMAZONSUPERVISOR.JS

The modules are developed in a logical and progressive manner to introduce a user to our node application.

It starts with a simple interface which shows the current table of products for sale and prompts the user for a purchase. Afterwards it shows the total spent; after a short delay, the same table with the change in stock quantity reflected.

The following module has more choices: the basic two show the current stock and the low-quantity items, which we can replenish with the third choice. We can also add a new product by digiting a name and a price.

The last module includes a view of the departments, with data relative to sales and profits. We can also create a new department. This involved creating a new MySQL table and constructing a more elaborate query to interact with both tables to interpolate new values.

Technology used:

• Cli-table npm module

• Created package.json for easy download and use

• Used a separate 'keys' module for privacy, to be sent directly to recipient before use

• Except for bamazoncustomer.js, introduced the query selections and their arguments separately for ease of maintenance and future development

• Grouped tasks in reusable functions

• Video demo at https://www.youtube.com/watch?v=HwBG5vUa4W0&feature=youtu.be

FUTURE IMPROVEMENTS:

• It should be possible to further consolidate the code
• Parts common to all modules can be taken out and put into their own module to avoid repetition
• A main module can be developed to group all 3 modules into one easy to use program by using inquirer to select one of 3 users at the beginning