The primary purpose for this entirely Node terminal ran application was to create an online storefront type application, that is loosely based off of the conglomerate, Amazon, that would be able to be ran entirely from the terminal using Node JS, and linked to a MySQL database using MySQL Workbench through JavaScript. When the user starts the application they are able to see the current inventory of the products in the database, and then can place an order for a specific item. From there, the stock quantity of the item will be deducted from the database, and if no more items are available, the user will be notified of that. Screenshots of the SQL database is found below:
Screenshots for the JavaScript code and NodeJS terminal store are found below as well, and after past completed activities, this was the easier part of the application. The majority of bugs encountered were found when making sure that the correct callback functions were stored inside the correct parent functions so that every function would run smoothly. I had conferred with two colleagues briefly and was able to get everything in order.
.jpg)
.jpg)
.jpg)
.jpg)
That was the first part of the project, with an optional bonus level options to be added after. The additions were another JavaScript file for a 'Manager-Mode' of the terminal store, and the manager would have the ability to view all the products for sale, see products with a low inventory (under 5) with a simple search, add to any product inventory (stock quantity), and also, add new products to the database. Creating the 'view products for sale' and 'view low inventory' options was able to be done without too many issues, and going back to the bamazonCustomer.js code, as well as past activities such as the GreatBay and topSongs definitely helped out as well. I was able to also get the 'add to inventory' part of the project working, however, I will still need to figure out why the stock inventory was not being added to the stock in the database. For the last function, the 'add new product' function is working properly, where the Manager is able to add a new product, along with its price, department, and number of the product in the inventory to the original SQL database. Lastly, the only bugs that were still lingerling was with the 'add to inventory' function as I mentioned before, but I'm sure with a little more fine tuning it will be up and running (however I am running out of time here). Screenshots are found below, and more time will be put into the remaining function to get it working.
.jpg)
.jpg)
Lastly, two new variables were created that were trying to add the input of the new inventory to the database of the product name, however, both of those variables did not update the new total in the database. This project needed to be submitted, and in the future I will go back to finish all aspects of the project. Screenshots of the update is below:
.jpg)
- [Node JS]
- [MySQL]
- [JavaScript]
- Matt Williams - Initial work - M Williams Portfolio