How nikhil-r-parmar/student-management-system-python-mysql works
This command-line student manager takes menu choices from the user, dispatches CRUD actions, and reports results in the terminal. Feature handlers validate input and issue SQL through a shared MySQL connection and cursor; the README also documents name updates, whose implementation was not excerpted. The schema/setup is described in the README, but its SQL file was not sampled. Edges reflect calls and database operations visible in excerpts or documented capabilities.
Main entry points: database.py Connection and cursor · main.py Menu dispatcher · add_students.py Add student · all_students.py View students
Components 12
CLI workflow
- Menu dispatcher
main.py - Update submenu
main.py
Student operations
- Add student
features/add_students.py - View students
features/all_students.py - Search by ID
features/search.py - Update name
features/update_name.py - Update age
features/update_age.py - Update city
features/update_city.py - Delete student
features/delete.py
MySQL persistence
- Connection and cursor
database.py - MySQL database
Other components
- CLI user
Connections 17
- CLI user → Menu dispatcher: chooses action
main.py - Menu dispatcher → Add student: dispatches
main.py - Menu dispatcher → View students: dispatches
main.py - Menu dispatcher → Search by ID: dispatches
main.py - Menu dispatcher → Update submenu: opens submenu
main.py - Update submenu → Update name: dispatches
main.py - Update submenu → Update age: dispatches
main.py - Update submenu → Update city: dispatches
main.py - Menu dispatcher → Delete student: dispatches
main.py - Add student → Connection and cursor: executes SQL
features/add_students.py - View students → Connection and cursor: executes SQL
features/all_students.py - Search by ID → Connection and cursor: queries record
features/search.py - Delete student → Connection and cursor: queries and deletes
features/delete.py - Update age → Connection and cursor: queries and updates
features/update_age.py - Update city → Connection and cursor: queries and updates
features/update_city.py - Connection and cursor → MySQL database: connects
database.py - Update name → Connection and cursor: uses shared connection