# alphesterx1/bug_tracker architecture

> Architecture diagram of the GitHub repository alphesterx1/bug_tracker, 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/alphesterx1/bug_tracker
- Repository: https://github.com/alphesterx1/bug_tracker

## Overview

This is a MySQL-backed bug tracker operated through interactive command-line menus. The principal workflow is a user choosing a menu action, then the CLI reading or changing tracker records. The main CLI includes project, issue, user, comment, assignment, and deletion actions; separate files also implement insert, update, and delete workflows, but the shown source does not connect them to the main CLI. The SQL schema and population files are present, but their contents were not provided, so their roles and relationships are not inferred.

Main entry points: [`main.py`](https://github.com/alphesterx1/bug_tracker/blob/main/main.py) (Tracker Menu), [`Seperate Implementation/INSERT.py`](https://github.com/alphesterx1/bug_tracker/blob/main/Seperate%20Implementation/INSERT.py) (Insert Functions), [`Seperate Implementation/Update.py`](https://github.com/alphesterx1/bug_tracker/blob/main/Seperate%20Implementation/Update.py) (Issue Updates), [`Seperate Implementation/delete-functions.py`](https://github.com/alphesterx1/bug_tracker/blob/main/Seperate%20Implementation/delete-functions.py) (Delete Menu)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_cli["Main CLI"]
  node_main_cli["Tracker Menu<br/>[main.py]"]
  node_main_reads["Browse Records<br/>[main.py]"]
  node_main_inserts["Add Records<br/>[main.py]"]
  node_main_updates["Update Issues<br/>[main.py]"]
  node_main_deletes["Delete Records<br/>[main.py]"]
end

subgraph group_standalone["Separate Workflows"]
  node_insert_script["Insert Functions<br/>[INSERT.py]"]
  node_update_script["Issue Updates<br/>[Update.py]"]
  node_delete_script["Delete Menu"]
end

subgraph group_storage["Persistence"]
  node_mysql[("MySQL Database")]
  node_schema["Table Structure<br/>[tablestructure.txt]"]
  node_seed_data["Seed SQL<br/>[populate.sql]"]
end

node_user(("User"))

node_user -->|"chooses action"| node_main_cli
node_main_cli -->|"dispatches browse"| node_main_reads
node_main_cli -->|"dispatches add"| node_main_inserts
node_main_cli -->|"dispatches update"| node_main_updates
node_main_cli -->|"dispatches delete"| node_main_deletes
node_main_cli -->|"connects to"| node_mysql
node_main_reads -->|"queries records"| node_mysql
node_main_inserts -->|"inserts records"| node_mysql
node_main_updates -->|"updates issues"| node_mysql
node_main_deletes -->|"deletes records"| node_mysql
node_insert_script -->|"inserts records"| node_mysql
node_update_script -->|"updates issues"| node_mysql
node_delete_script -->|"deletes records"| node_mysql

click node_main_cli "https://github.com/alphesterx1/bug_tracker/blob/main/main.py"
click node_main_reads "https://github.com/alphesterx1/bug_tracker/blob/main/main.py"
click node_main_inserts "https://github.com/alphesterx1/bug_tracker/blob/main/main.py"
click node_main_updates "https://github.com/alphesterx1/bug_tracker/blob/main/main.py"
click node_main_deletes "https://github.com/alphesterx1/bug_tracker/blob/main/main.py"
click node_insert_script "https://github.com/alphesterx1/bug_tracker/blob/main/Seperate%20Implementation/INSERT.py"
click node_update_script "https://github.com/alphesterx1/bug_tracker/blob/main/Seperate%20Implementation/Update.py"
click node_delete_script "https://github.com/alphesterx1/bug_tracker/blob/main/Seperate%20Implementation/delete-functions.py"
click node_schema "https://github.com/alphesterx1/bug_tracker/blob/main/tablestructure.txt"
click node_seed_data "https://github.com/alphesterx1/bug_tracker/blob/main/populate.sql"

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_main_cli,node_main_reads,node_main_inserts,node_main_updates,node_main_deletes,node_user toneBlue
class node_insert_script,node_update_script,node_delete_script toneAmber
class node_mysql,node_schema,node_seed_data toneMint
```

## Components

### Main CLI

- [Tracker Menu](https://github.com/alphesterx1/bug_tracker/blob/main/main.py): `main.py`
- [Browse Records](https://github.com/alphesterx1/bug_tracker/blob/main/main.py): `main.py`
- [Add Records](https://github.com/alphesterx1/bug_tracker/blob/main/main.py): `main.py`
- [Update Issues](https://github.com/alphesterx1/bug_tracker/blob/main/main.py): `main.py`
- [Delete Records](https://github.com/alphesterx1/bug_tracker/blob/main/main.py): `main.py`

### Separate Workflows

- [Insert Functions](https://github.com/alphesterx1/bug_tracker/blob/main/Seperate%20Implementation/INSERT.py): `Seperate Implementation/INSERT.py`
- [Issue Updates](https://github.com/alphesterx1/bug_tracker/blob/main/Seperate%20Implementation/Update.py): `Seperate Implementation/Update.py`
- [Delete Menu](https://github.com/alphesterx1/bug_tracker/blob/main/Seperate%20Implementation/delete-functions.py): `Seperate Implementation/delete-functions.py`

### Persistence

- **MySQL Database**
- [Table Structure](https://github.com/alphesterx1/bug_tracker/blob/main/tablestructure.txt): `tablestructure.txt`
- [Seed SQL](https://github.com/alphesterx1/bug_tracker/blob/main/populate.sql): `populate.sql`

### Other components

- **User**

## Connections

- User → Tracker Menu: chooses action (evidence: `main.py`)
- Tracker Menu → Browse Records: dispatches browse (evidence: `main.py`)
- Tracker Menu → Add Records: dispatches add (evidence: `main.py`)
- Tracker Menu → Update Issues: dispatches update (evidence: `main.py`)
- Tracker Menu → Delete Records: dispatches delete (evidence: `main.py`)
- Tracker Menu → MySQL Database: connects to (evidence: `main.py`)
- Browse Records → MySQL Database: queries records (evidence: `main.py`)
- Add Records → MySQL Database: inserts records (evidence: `main.py`)
- Update Issues → MySQL Database: updates issues (evidence: `main.py`)
- Delete Records → MySQL Database: deletes records (evidence: `main.py`)
- Insert Functions → MySQL Database: inserts records (evidence: `Seperate Implementation/INSERT.py`)
- Issue Updates → MySQL Database: updates issues (evidence: `Seperate Implementation/Update.py`)
- Delete Menu → MySQL Database: deletes records (evidence: `Seperate Implementation/delete-functions.py`)
