# iswarya2025n/mysql-project01-python-mysql architecture

> Architecture diagram of the GitHub repository iswarya2025n/mysql-project01-python-mysql, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-10-03). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/iswarya2025n/mysql-project01-python-mysql
- Repository: https://github.com/iswarya2025n/mysql-project01-python-mysql

## Overview

This is a small command-line student management system. A user selects an operation in the menu; the corresponding handler prompts for student details, uses a MySQL connection to perform an insert, list, grade update, or delete, and prints the result. The single source file contains both the menu and handlers, so the graph separates their responsibilities without implying separate modules. Evidence is limited to the supplied ums.py excerpt; no README or other product capabilities were provided.

Main entry points: [`ums.py`](https://github.com/iswarya2025n/mysql-project01-python-mysql/blob/main/ums.py) (Operation menu)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_cli["Command-line workflow"]
  node_menu["Operation menu<br/>[ums.py]"]
  node_connection["Connection helper<br/>[ums.py]"]
end

subgraph group_records["Student records"]
  node_add["Add student<br/>[ums.py]"]
  node_view["View students<br/>[ums.py]"]
  node_update["Update grade<br/>[ums.py]"]
  node_delete["Delete student<br/>[ums.py]"]
end

node_user(("User"))
node_mysql[("MySQL database")]

node_user -->|"selects action"| node_menu
node_menu -->|"dispatches"| node_add
node_menu -->|"dispatches"| node_view
node_menu -->|"dispatches"| node_update
node_menu -->|"dispatches"| node_delete
node_add -->|"opens connection"| node_connection
node_view -->|"opens connection"| node_connection
node_update -->|"opens connection"| node_connection
node_delete -->|"opens connection"| node_connection
node_connection -->|"connects to"| node_mysql
node_add -->|"inserts record"| node_mysql
node_view -->|"reads records"| node_mysql
node_update -->|"updates grade"| node_mysql
node_delete -->|"deletes record"| node_mysql

click node_menu "https://github.com/iswarya2025n/mysql-project01-python-mysql/blob/main/ums.py"
click node_add "https://github.com/iswarya2025n/mysql-project01-python-mysql/blob/main/ums.py"
click node_view "https://github.com/iswarya2025n/mysql-project01-python-mysql/blob/main/ums.py"
click node_update "https://github.com/iswarya2025n/mysql-project01-python-mysql/blob/main/ums.py"
click node_delete "https://github.com/iswarya2025n/mysql-project01-python-mysql/blob/main/ums.py"
click node_connection "https://github.com/iswarya2025n/mysql-project01-python-mysql/blob/main/ums.py"

classDef toneNeutral fill:#f8fafc,stroke:#334155,stroke-width:1.5px,color:#0f172a
classDef toneBlue fill:#dbeafe,stroke:#2563eb,stroke-width:1.5px,color:#172554
classDef toneAmber fill:#fef3c7,stroke:#d97706,stroke-width:1.5px,color:#78350f
classDef toneMint fill:#dcfce7,stroke:#16a34a,stroke-width:1.5px,color:#14532d
classDef toneRose fill:#ffe4e6,stroke:#e11d48,stroke-width:1.5px,color:#881337
classDef toneIndigo fill:#e0e7ff,stroke:#4f46e5,stroke-width:1.5px,color:#312e81
classDef toneTeal fill:#ccfbf1,stroke:#0f766e,stroke-width:1.5px,color:#134e4a
class node_menu,node_connection,node_user toneBlue
class node_add,node_view,node_update,node_delete,node_mysql toneAmber
```

## Components

### Command-line workflow

- [Operation menu](https://github.com/iswarya2025n/mysql-project01-python-mysql/blob/main/ums.py): `ums.py`
- [Connection helper](https://github.com/iswarya2025n/mysql-project01-python-mysql/blob/main/ums.py): `ums.py`

### Student records

- [Add student](https://github.com/iswarya2025n/mysql-project01-python-mysql/blob/main/ums.py): `ums.py`
- [View students](https://github.com/iswarya2025n/mysql-project01-python-mysql/blob/main/ums.py): `ums.py`
- [Update grade](https://github.com/iswarya2025n/mysql-project01-python-mysql/blob/main/ums.py): `ums.py`
- [Delete student](https://github.com/iswarya2025n/mysql-project01-python-mysql/blob/main/ums.py): `ums.py`

### Other components

- **User**
- **MySQL database**

## Connections

- User → Operation menu: selects action (evidence: `ums.py`)
- Operation menu → Add student: dispatches (evidence: `ums.py`)
- Operation menu → View students: dispatches (evidence: `ums.py`)
- Operation menu → Update grade: dispatches (evidence: `ums.py`)
- Operation menu → Delete student: dispatches (evidence: `ums.py`)
- Add student → Connection helper: opens connection (evidence: `ums.py`)
- View students → Connection helper: opens connection (evidence: `ums.py`)
- Update grade → Connection helper: opens connection (evidence: `ums.py`)
- Delete student → Connection helper: opens connection (evidence: `ums.py`)
- Connection helper → MySQL database: connects to (evidence: `ums.py`)
- Add student → MySQL database: inserts record (evidence: `ums.py`)
- View students → MySQL database: reads records (evidence: `ums.py`)
- Update grade → MySQL database: updates grade (evidence: `ums.py`)
- Delete student → MySQL database: deletes record (evidence: `ums.py`)
