This project is meant to simulate an inventory database management for real-time
- Pymongo - version 4.1.1
- MongoDB Compass - version 1.32.2
- Python - version 3.10
List of features ready and TODOs for future development
- Sanitized user inputs to reduce errors and improve database security
- Utilized unique indices to simulate the one-to-one relation of SKU numbers to consumer goods
- Allows users to perform CRUD operations on inventory databases through an easy-to-use command line menu
To-do list:
- Integrate machine learning algorithms to find the ideal stock level and alert management when they need to place an order
- Integrate with bar code scanners to allow real-time displays of inventory vs cyclical estimates
- Fully integrate cloud HDFS infrastructure to truly harness the power of the Spark ecosystem
gh repo clone jmyeary/Revature-Project-0-Inventory
Project utilizes MongoDB so it will only work with that technology. Not compatible with SQL or other RDBs.
- Ensure the following variables are adjusted for your particular database:
cluster = MongoClient("YOUR SERVER IP") db = cluster["YOUR CLUSTER NAME"]
collection1 = db["YOUR COLLECTION1"] #on-hand inventory
collection2 = db["YOUR COLLECTION2"] #master inventory
collection3 = db["YOUR COLLECTION3"] #inventory on-order
Simply run the project file on your machine, and follow the easy to understand prompts..
This project uses the following license: GPL-3.0.