Demo console application written in Python using SQLAlchemy and SQLite.
This app uses my knowledge of CSV, File I/O, and database ORMs to create a product management inventory system which allows users to easily interact with a stores product data. The data is cleaned from the CSV file before it is added to an SQLite database. All interactions with the records use ORM methods for viewing records, creating records, and exporting a new CSV backup.
- Python Programming language that lets you work quickly and integrate systems more effectively. (docs)
- SQLAlchemy The Python SQL Toolkit and Object Relational Mapper (docs)
- SQLite The most used database engine in the world. (docs)
- CSV file format used for storing imported and exported data in a human readable including a header row of field names.
Clone this repo then cd product-inventory-management-system
.
Assuming you have Python3 installed on a MacOS, run these commands (or something similar):
python3 -m venv env
source env/bin/activate
pip install -r requirements.txt
python app.py
When done running the app, you can deactivate the virtual environment by running deactivate
.
Example showing "List All Products" feature (L) displaying list or products from the automatically generated inventory.db
database and the "Product Analysis" (X) feature: