# camillobia/blinsights architecture

> Architecture diagram of the GitHub repository camillobia/blinsights, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-11-16). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/camillobia/blinsights
- Repository: https://github.com/camillobia/blinsights

## Overview

Blinsights is a client-upload and analytics product: users upload spreadsheets in the Vue app, validated records pass through Spring to a Python ETL service, and persisted batch statistics return through Spring for dashboard display. The graph also includes login and consultant management as distinct capabilities. Edges are limited to README-documented flows and caller relationships visible in excerpts or the source index; unsampled internals are represented only where the tree supports them.

Main entry points: [`SYNAPSE/CienciaD/analytics-python/main.py`](https://github.com/camillobia/blinsights/blob/main/SYNAPSE/CienciaD/analytics-python/main.py) (Batch processing), [`SYNAPSE/BackEnd/src/main/java/CTI/BackEnd/controller/ClienteValidacaoController.java`](https://github.com/camillobia/blinsights/blob/main/SYNAPSE/BackEnd/src/main/java/CTI/BackEnd/controller/ClienteValidacaoController.java) (Upload endpoint), [`SYNAPSE/FrontEnd/src/router/index.js`](https://github.com/camillobia/blinsights/blob/main/SYNAPSE/FrontEnd/src/router/index.js) (View routing), [`SYNAPSE/BackEnd/src/main/java/CTI/BackEnd/service/DashboardService.java`](https://github.com/camillobia/blinsights/blob/main/SYNAPSE/BackEnd/src/main/java/CTI/BackEnd/service/DashboardService.java) (Dashboard queries)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_frontend["Vue application"]
  node_upload_ui["Spreadsheet upload<br/>[Upload.vue]"]
  node_upload_state["Upload processing<br/>[Uploadstore.js]"]
  node_api_client["API client<br/>[api.js]"]
  node_login_ui["Login<br/>[Login.vue]"]
  node_dashboard_ui["Dashboard<br/>[Dashboard.vue]"]
  node_shell["Navigation shell<br/>[InnerShell.vue]"]
  node_menu["Sidebar menu<br/>[Sidemenu.vue]"]
  node_home["Home mockup<br/>[Home.vue]"]
  node_mock_dashboard["Dashboard mockup"]
  node_router["View routing<br/>[index.js]"]
end

subgraph group_backend["Spring backend"]
  node_upload_controller["Upload endpoint"]
  node_client_validation["Client normalization"]
  node_client_dto["Client DTO<br/>[ClienteDTO.java]"]
  node_batch_service["Batch tracking"]
  node_python_client["ETL HTTP client"]
  node_dashboard_controller["Dashboard endpoint"]
  node_dashboard_service["Dashboard queries"]
  node_user_controller["User API"]
  node_user_service["User accounts"]
  node_token_service["JWT issuance<br/>[TokenService.java]"]
  node_consultant_api["Consultant API"]
  node_consultant_service["Consultant management"]
  node_consultant_repo["Consultant repository"]
  node_user_repo["User repository"]
end

subgraph group_etl["Python analytics"]
  node_etl_api["ETL API<br/>[api.py]"]
  node_etl_pipeline["Batch processing<br/>[main.py]"]
  node_cleaning["Data cleaning<br/>[limpeza.py]"]
  node_analysis["Statistics<br/>[analise.py]"]
  node_insights["Insight generation<br/>[insights.py]"]
  node_database_writer["ETL persistence<br/>[banco.py]"]
end

subgraph group_data["Persistence"]
  node_postgres[("PostgreSQL")]
end

node_user(("User"))

node_user -->|"uploads spreadsheet"| node_upload_ui
node_upload_ui -->|"submits rows"| node_upload_state
node_upload_state -->|"calls API"| node_api_client
node_api_client -->|"posts valid rows"| node_upload_controller
node_upload_controller -->|"validates records"| node_client_validation
node_upload_controller -->|"starts batch"| node_batch_service
node_upload_controller -->|"forwards batch"| node_python_client
node_client_validation -->|"normalizes fields"| node_client_dto
node_python_client -->|"posts ETL payload"| node_etl_api
node_etl_api -->|"dispatches batch"| node_etl_pipeline
node_etl_pipeline -->|"cleans records"| node_cleaning
node_etl_pipeline -->|"calculates statistics"| node_analysis
node_etl_pipeline -->|"generates insights"| node_insights
node_etl_pipeline -->|"saves batch"| node_database_writer
node_database_writer -->|"writes records"| node_postgres
node_user -->|"signs in"| node_login_ui
node_login_ui -.->|"requests login"| node_api_client
node_user_controller -->|"authenticates account"| node_user_service
node_user_controller -->|"issues token"| node_token_service
node_user_service -->|"loads accounts"| node_user_repo
node_consultant_api -->|"manages consultants"| node_consultant_service
node_consultant_service -->|"persists consultants"| node_consultant_repo
node_dashboard_controller -->|"loads dashboard"| node_dashboard_service
node_dashboard_service -->|"queries batches"| node_postgres
node_dashboard_service -->|"returns statistics"| node_dashboard_ui
node_user -->|"views results"| node_dashboard_ui
node_router -->|"routes to"| node_upload_ui
node_router -->|"routes to"| node_login_ui
node_router -->|"routes to"| node_dashboard_ui
node_shell -->|"renders menu"| node_menu
node_home -->|"renders mockup"| node_mock_dashboard

click node_upload_ui "https://github.com/camillobia/blinsights/blob/main/SYNAPSE/FrontEnd/src/views/Upload.vue"
click node_upload_state "https://github.com/camillobia/blinsights/blob/main/SYNAPSE/FrontEnd/src/store/Uploadstore.js"
click node_api_client "https://github.com/camillobia/blinsights/blob/main/SYNAPSE/FrontEnd/src/services/api.js"
click node_login_ui "https://github.com/camillobia/blinsights/blob/main/SYNAPSE/FrontEnd/src/views/Login.vue"
click node_dashboard_ui "https://github.com/camillobia/blinsights/blob/main/SYNAPSE/FrontEnd/src/views/Dashboard.vue"
click node_shell "https://github.com/camillobia/blinsights/blob/main/SYNAPSE/FrontEnd/src/components/InnerShell.vue"
click node_menu "https://github.com/camillobia/blinsights/blob/main/SYNAPSE/FrontEnd/src/components/Sidemenu.vue"
click node_home "https://github.com/camillobia/blinsights/blob/main/SYNAPSE/FrontEnd/src/views/Home.vue"
click node_mock_dashboard "https://github.com/camillobia/blinsights/blob/main/SYNAPSE/FrontEnd/src/components/DashboardMockup.vue"
click node_router "https://github.com/camillobia/blinsights/blob/main/SYNAPSE/FrontEnd/src/router/index.js"
click node_upload_controller "https://github.com/camillobia/blinsights/blob/main/SYNAPSE/BackEnd/src/main/java/CTI/BackEnd/controller/ClienteValidacaoController.java"
click node_client_validation "https://github.com/camillobia/blinsights/blob/main/SYNAPSE/BackEnd/src/main/java/CTI/BackEnd/service/ClienteValidacaoService.java"
click node_client_dto "https://github.com/camillobia/blinsights/blob/main/SYNAPSE/BackEnd/src/main/java/CTI/BackEnd/dto/ClienteDTO.java"
click node_batch_service "https://github.com/camillobia/blinsights/blob/main/SYNAPSE/BackEnd/src/main/java/CTI/BackEnd/service/UploadLoteService.java"
click node_python_client "https://github.com/camillobia/blinsights/blob/main/SYNAPSE/BackEnd/src/main/java/CTI/BackEnd/service/PythonEtlService.java"
click node_dashboard_controller "https://github.com/camillobia/blinsights/blob/main/SYNAPSE/BackEnd/src/main/java/CTI/BackEnd/controller/DashboardController.java"
click node_dashboard_service "https://github.com/camillobia/blinsights/blob/main/SYNAPSE/BackEnd/src/main/java/CTI/BackEnd/service/DashboardService.java"
click node_user_controller "https://github.com/camillobia/blinsights/blob/main/SYNAPSE/BackEnd/src/main/java/CTI/BackEnd/controller/UsuarioController.java"
click node_user_service "https://github.com/camillobia/blinsights/blob/main/SYNAPSE/BackEnd/src/main/java/CTI/BackEnd/service/UsuarioService.java"
click node_token_service "https://github.com/camillobia/blinsights/blob/main/SYNAPSE/BackEnd/src/main/java/CTI/BackEnd/service/TokenService.java"
click node_consultant_api "https://github.com/camillobia/blinsights/blob/main/SYNAPSE/BackEnd/src/main/java/CTI/BackEnd/controller/ConsultorController.java"
click node_consultant_service "https://github.com/camillobia/blinsights/blob/main/SYNAPSE/BackEnd/src/main/java/CTI/BackEnd/service/ConsultorService.java"
click node_etl_api "https://github.com/camillobia/blinsights/blob/main/SYNAPSE/CienciaD/analytics-python/api.py"
click node_etl_pipeline "https://github.com/camillobia/blinsights/blob/main/SYNAPSE/CienciaD/analytics-python/main.py"
click node_cleaning "https://github.com/camillobia/blinsights/blob/main/SYNAPSE/CienciaD/analytics-python/limpeza.py"
click node_analysis "https://github.com/camillobia/blinsights/blob/main/SYNAPSE/CienciaD/analytics-python/analise.py"
click node_insights "https://github.com/camillobia/blinsights/blob/main/SYNAPSE/CienciaD/analytics-python/insights.py"
click node_database_writer "https://github.com/camillobia/blinsights/blob/main/SYNAPSE/CienciaD/analytics-python/banco.py"
click node_consultant_repo "https://github.com/camillobia/blinsights/blob/main/SYNAPSE/BackEnd/src/main/java/CTI/BackEnd/repository/ConsultorRepository.java"
click node_user_repo "https://github.com/camillobia/blinsights/blob/main/SYNAPSE/BackEnd/src/main/java/CTI/BackEnd/repository/UsuarioRepository.java"

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_upload_ui,node_upload_state,node_api_client,node_login_ui,node_dashboard_ui,node_shell,node_menu,node_home,node_mock_dashboard,node_router,node_user toneBlue
class node_upload_controller,node_client_validation,node_client_dto,node_batch_service,node_python_client,node_dashboard_controller,node_dashboard_service,node_user_controller,node_user_service,node_token_service,node_consultant_api,node_consultant_service,node_consultant_repo,node_user_repo toneAmber
class node_etl_api,node_etl_pipeline,node_cleaning,node_analysis,node_insights,node_database_writer toneMint
class node_postgres toneRose
```

## Components

### Vue application

- [Spreadsheet upload](https://github.com/camillobia/blinsights/blob/main/SYNAPSE/FrontEnd/src/views/Upload.vue): `SYNAPSE/FrontEnd/src/views/Upload.vue`
- [Upload processing](https://github.com/camillobia/blinsights/blob/main/SYNAPSE/FrontEnd/src/store/Uploadstore.js): `SYNAPSE/FrontEnd/src/store/Uploadstore.js`
- [API client](https://github.com/camillobia/blinsights/blob/main/SYNAPSE/FrontEnd/src/services/api.js): `SYNAPSE/FrontEnd/src/services/api.js`
- [Login](https://github.com/camillobia/blinsights/blob/main/SYNAPSE/FrontEnd/src/views/Login.vue): `SYNAPSE/FrontEnd/src/views/Login.vue`
- [Dashboard](https://github.com/camillobia/blinsights/blob/main/SYNAPSE/FrontEnd/src/views/Dashboard.vue): `SYNAPSE/FrontEnd/src/views/Dashboard.vue`
- [Navigation shell](https://github.com/camillobia/blinsights/blob/main/SYNAPSE/FrontEnd/src/components/InnerShell.vue): `SYNAPSE/FrontEnd/src/components/InnerShell.vue`
- [Sidebar menu](https://github.com/camillobia/blinsights/blob/main/SYNAPSE/FrontEnd/src/components/Sidemenu.vue): `SYNAPSE/FrontEnd/src/components/Sidemenu.vue`
- [Home mockup](https://github.com/camillobia/blinsights/blob/main/SYNAPSE/FrontEnd/src/views/Home.vue): `SYNAPSE/FrontEnd/src/views/Home.vue`
- [Dashboard mockup](https://github.com/camillobia/blinsights/blob/main/SYNAPSE/FrontEnd/src/components/DashboardMockup.vue): `SYNAPSE/FrontEnd/src/components/DashboardMockup.vue`
- [View routing](https://github.com/camillobia/blinsights/blob/main/SYNAPSE/FrontEnd/src/router/index.js): `SYNAPSE/FrontEnd/src/router/index.js`

### Spring backend

- [Upload endpoint](https://github.com/camillobia/blinsights/blob/main/SYNAPSE/BackEnd/src/main/java/CTI/BackEnd/controller/ClienteValidacaoController.java): `SYNAPSE/BackEnd/src/main/java/CTI/BackEnd/controller/ClienteValidacaoController.java`
- [Client normalization](https://github.com/camillobia/blinsights/blob/main/SYNAPSE/BackEnd/src/main/java/CTI/BackEnd/service/ClienteValidacaoService.java): `SYNAPSE/BackEnd/src/main/java/CTI/BackEnd/service/ClienteValidacaoService.java`
- [Client DTO](https://github.com/camillobia/blinsights/blob/main/SYNAPSE/BackEnd/src/main/java/CTI/BackEnd/dto/ClienteDTO.java): `SYNAPSE/BackEnd/src/main/java/CTI/BackEnd/dto/ClienteDTO.java`
- [Batch tracking](https://github.com/camillobia/blinsights/blob/main/SYNAPSE/BackEnd/src/main/java/CTI/BackEnd/service/UploadLoteService.java): `SYNAPSE/BackEnd/src/main/java/CTI/BackEnd/service/UploadLoteService.java`
- [ETL HTTP client](https://github.com/camillobia/blinsights/blob/main/SYNAPSE/BackEnd/src/main/java/CTI/BackEnd/service/PythonEtlService.java): `SYNAPSE/BackEnd/src/main/java/CTI/BackEnd/service/PythonEtlService.java`
- [Dashboard endpoint](https://github.com/camillobia/blinsights/blob/main/SYNAPSE/BackEnd/src/main/java/CTI/BackEnd/controller/DashboardController.java): `SYNAPSE/BackEnd/src/main/java/CTI/BackEnd/controller/DashboardController.java`
- [Dashboard queries](https://github.com/camillobia/blinsights/blob/main/SYNAPSE/BackEnd/src/main/java/CTI/BackEnd/service/DashboardService.java): `SYNAPSE/BackEnd/src/main/java/CTI/BackEnd/service/DashboardService.java`
- [User API](https://github.com/camillobia/blinsights/blob/main/SYNAPSE/BackEnd/src/main/java/CTI/BackEnd/controller/UsuarioController.java): `SYNAPSE/BackEnd/src/main/java/CTI/BackEnd/controller/UsuarioController.java`
- [User accounts](https://github.com/camillobia/blinsights/blob/main/SYNAPSE/BackEnd/src/main/java/CTI/BackEnd/service/UsuarioService.java): `SYNAPSE/BackEnd/src/main/java/CTI/BackEnd/service/UsuarioService.java`
- [JWT issuance](https://github.com/camillobia/blinsights/blob/main/SYNAPSE/BackEnd/src/main/java/CTI/BackEnd/service/TokenService.java): `SYNAPSE/BackEnd/src/main/java/CTI/BackEnd/service/TokenService.java`
- [Consultant API](https://github.com/camillobia/blinsights/blob/main/SYNAPSE/BackEnd/src/main/java/CTI/BackEnd/controller/ConsultorController.java): `SYNAPSE/BackEnd/src/main/java/CTI/BackEnd/controller/ConsultorController.java`
- [Consultant management](https://github.com/camillobia/blinsights/blob/main/SYNAPSE/BackEnd/src/main/java/CTI/BackEnd/service/ConsultorService.java): `SYNAPSE/BackEnd/src/main/java/CTI/BackEnd/service/ConsultorService.java`
- [Consultant repository](https://github.com/camillobia/blinsights/blob/main/SYNAPSE/BackEnd/src/main/java/CTI/BackEnd/repository/ConsultorRepository.java): `SYNAPSE/BackEnd/src/main/java/CTI/BackEnd/repository/ConsultorRepository.java`
- [User repository](https://github.com/camillobia/blinsights/blob/main/SYNAPSE/BackEnd/src/main/java/CTI/BackEnd/repository/UsuarioRepository.java): `SYNAPSE/BackEnd/src/main/java/CTI/BackEnd/repository/UsuarioRepository.java`

### Python analytics

- [ETL API](https://github.com/camillobia/blinsights/blob/main/SYNAPSE/CienciaD/analytics-python/api.py): `SYNAPSE/CienciaD/analytics-python/api.py`
- [Batch processing](https://github.com/camillobia/blinsights/blob/main/SYNAPSE/CienciaD/analytics-python/main.py): `SYNAPSE/CienciaD/analytics-python/main.py`
- [Data cleaning](https://github.com/camillobia/blinsights/blob/main/SYNAPSE/CienciaD/analytics-python/limpeza.py): `SYNAPSE/CienciaD/analytics-python/limpeza.py`
- [Statistics](https://github.com/camillobia/blinsights/blob/main/SYNAPSE/CienciaD/analytics-python/analise.py): `SYNAPSE/CienciaD/analytics-python/analise.py`
- [Insight generation](https://github.com/camillobia/blinsights/blob/main/SYNAPSE/CienciaD/analytics-python/insights.py): `SYNAPSE/CienciaD/analytics-python/insights.py`
- [ETL persistence](https://github.com/camillobia/blinsights/blob/main/SYNAPSE/CienciaD/analytics-python/banco.py): `SYNAPSE/CienciaD/analytics-python/banco.py`

### Persistence

- **PostgreSQL**

### Other components

- **User**

## Connections

- User → Spreadsheet upload: uploads spreadsheet
- Spreadsheet upload → Upload processing: submits rows (evidence: `SYNAPSE/FrontEnd/src/views/Upload.vue`)
- Upload processing → API client: calls API (evidence: `SYNAPSE/FrontEnd/src/store/Uploadstore.js`)
- API client → Upload endpoint: posts valid rows
- Upload endpoint → Client normalization: validates records (evidence: `SYNAPSE/BackEnd/src/main/java/CTI/BackEnd/controller/ClienteValidacaoController.java`)
- Upload endpoint → Batch tracking: starts batch (evidence: `SYNAPSE/BackEnd/src/main/java/CTI/BackEnd/controller/ClienteValidacaoController.java`)
- Upload endpoint → ETL HTTP client: forwards batch (evidence: `SYNAPSE/BackEnd/src/main/java/CTI/BackEnd/controller/ClienteValidacaoController.java`)
- Client normalization → Client DTO: normalizes fields (evidence: `SYNAPSE/BackEnd/src/main/java/CTI/BackEnd/service/ClienteValidacaoService.java`)
- ETL HTTP client → ETL API: posts ETL payload (evidence: `SYNAPSE/BackEnd/src/main/java/CTI/BackEnd/service/PythonEtlService.java`)
- ETL API → Batch processing: dispatches batch (evidence: `SYNAPSE/CienciaD/analytics-python/api.py`)
- Batch processing → Data cleaning: cleans records (evidence: `SYNAPSE/CienciaD/analytics-python/main.py`)
- Batch processing → Statistics: calculates statistics (evidence: `SYNAPSE/CienciaD/analytics-python/main.py`)
- Batch processing → Insight generation: generates insights (evidence: `SYNAPSE/CienciaD/analytics-python/main.py`)
- Batch processing → ETL persistence: saves batch (evidence: `SYNAPSE/CienciaD/analytics-python/main.py`)
- ETL persistence → PostgreSQL: writes records
- User → Login: signs in
- Login → API client: requests login
- User API → User accounts: authenticates account (evidence: `SYNAPSE/BackEnd/src/main/java/CTI/BackEnd/controller/UsuarioController.java`)
- User API → JWT issuance: issues token (evidence: `SYNAPSE/BackEnd/src/main/java/CTI/BackEnd/controller/UsuarioController.java`)
- User accounts → User repository: loads accounts (evidence: `SYNAPSE/BackEnd/src/main/java/CTI/BackEnd/service/UsuarioService.java`)
- Consultant API → Consultant management: manages consultants (evidence: `SYNAPSE/BackEnd/src/main/java/CTI/BackEnd/controller/ConsultorController.java`)
- Consultant management → Consultant repository: persists consultants (evidence: `SYNAPSE/BackEnd/src/main/java/CTI/BackEnd/service/ConsultorService.java`)
- Dashboard endpoint → Dashboard queries: loads dashboard (evidence: `SYNAPSE/BackEnd/src/main/java/CTI/BackEnd/controller/DashboardController.java`)
- Dashboard queries → PostgreSQL: queries batches
- Dashboard queries → Dashboard: returns statistics
- User → Dashboard: views results
- View routing → Spreadsheet upload: routes to (evidence: `SYNAPSE/FrontEnd/src/router/index.js`)
- View routing → Login: routes to (evidence: `SYNAPSE/FrontEnd/src/router/index.js`)
- View routing → Dashboard: routes to (evidence: `SYNAPSE/FrontEnd/src/router/index.js`)
- Navigation shell → Sidebar menu: renders menu (evidence: `SYNAPSE/FrontEnd/src/components/InnerShell.vue`)
- Home mockup → Dashboard mockup: renders mockup (evidence: `SYNAPSE/FrontEnd/src/views/Home.vue`)
