Project
- Discipline
- Software
- Timeline
- 2026
- Role
- Solo developerDesign, implementation & testing
- Category
- Software engineeringDatabase design
Tools
- Python 3
- SQLite
- unittest
- Database design
- ANSI terminal UI
- Error handling
A banking system in plain Python
For the Elite 102 final project, I designed and built a terminal-based banking application in Python with no external libraries. The system runs on Python's built-in sqlite3 module, managing a relational database of accounts and transactions through a color-coded terminal interface.
The architecture is split across four modules: database.py handles the SQLite connection and schema initialization, accounts.py contains all business logic (deposits, withdrawals, transfers, interest), ui.py drives the ANSI color menu interface, and main.py ties it all together as the entry point.
I built the wire transfer system with atomic transactions — ensuring that if a debit succeeds but a credit fails, the database rolls back to its previous state rather than losing funds.
Key features
- Account creation and closure with persistent SQLite storage — accounts and transaction history survive across sessions.
- Deposits, withdrawals, and wire transfers with overdraft protection and atomic rollback on failure.
- Interest calculation applied per account, with the transaction logged to history.
- Color-coded terminal UI using ANSI escape codes, without any external UI library.
- 40 of 40
unittesttests passing, across nine test classes, covering account creation, balance operations, transfers, edge cases, and error handling — all in under 0.5 seconds. - Relational database schema with an
accountsandtransactionstable, using foreign keys and typed transaction records.
Completed