This project is a sample supply chain management system built to demonstrate database integration, CRUD operations, QA testing (manual + automated), and documentation following the Systems Development Life Cycle (SDLC).
- Database integration with SQLite
- CRUD operations for orders and warehouse inventory
- Console interaction to place, check, and update orders
- Manual testing documented in Excel
- Automated testing with
pytest
The system uses two tables defined in schema.sql:
- orders → order ID, client name, product, SKU, quantity, status
- warehouse_inventory → SKU, product name, available stock
Run run-schema-sql.py to reset and seed the database.
See docs/manual-testing.xlsx for scenario-based test cases with preconditions, steps, expected/actual results.
- pytest: for lightweight tests (
testing/tests/)
Run tests:
pytest -q