How natanbarboza08/oversight works
Oversight is a spreadsheet-based customer analytics application. A user uploads a spreadsheet through the Vue interface; the frontend validates rows, Java revalidates them and delegates valid rows to Python ETL, which cleans, analyzes, and persists results. Java serves persisted history and statistics for frontend reports and charts. Separate capabilities cover JWT authentication and administrator approval of accounts. The README documents cross-service and database flow; some internal wiring is supported by the source index, while unsampled modules are represented only where documented.
Main entry points: api.js API client · main.py ETL endpoint · AuthService.java Account authentication · UploadService.java Batch validation
Components 25
Vue application
- Upload screen
Frontend/src/views/Upload.vue - Sheet validation
Frontend/src/stores/uploadStore.js - Session state
Frontend/src/stores/auth.js - API client
Frontend/src/services/api.js - Reports and charts
Frontend/src/views/Relatorios.vue - Analytics charts
Frontend/src/views/Graficos.vue
Java API
- Authentication API
Backend/oversight/src/main/java/com/senai/oversight/controller/AuthController.java - Account authentication
Backend/oversight/src/main/java/com/senai/oversight/service/AuthService.java - JWT security
Backend/oversight/src/main/java/com/senai/oversight/config/JwtService.java - User administration
Backend/oversight/src/main/java/com/senai/oversight/controller/AdminUsuarioController.java - User management
Backend/oversight/src/main/java/com/senai/oversight/service/UsuarioService.java - Upload API
Backend/oversight/src/main/java/com/senai/oversight/controller/UploadController.java - Batch validation
Backend/oversight/src/main/java/com/senai/oversight/service/UploadService.java - Client row rules
Backend/oversight/src/main/java/com/senai/oversight/service/ClienteValidacaoService.java - ETL client
Backend/oversight/src/main/java/com/senai/oversight/service/PythonEtlService.java - Dashboard queries
Backend/oversight/src/main/java/com/senai/oversight/service/DashboardService.java - User repository
Backend/oversight/src/main/java/com/senai/oversight/repository/UsuarioRepository.java
Python analytics
- ETL endpoint
analytics-python/main.py - Data cleaning
analytics-python/limpeza.py - Metrics analysis
analytics-python/analise.py - Insights
analytics-python/insights.py - ETL persistence
analytics-python/banco.py
Persisted data
- PostgreSQL
Other components
- User
- Administrator
Connections 27
- User → Upload screen: uploads sheet
- Upload screen → Sheet validation: uses
Frontend/src/views/Upload.vue - Sheet validation → API client: sends valid rows
Frontend/src/stores/uploadStore.js - API client → Upload API: calls API
- Upload API → Batch validation: delegates
- Batch validation → Client row rules: validates rows
Backend/oversight/src/main/java/com/senai/oversight/service/UploadService.java - Batch validation → ETL client: forwards valid batch
Backend/oversight/src/main/java/com/senai/oversight/service/UploadService.java - ETL client → ETL endpoint: sends batch
- ETL endpoint → Data cleaning: cleans data
analytics-python/main.py - ETL endpoint → Metrics analysis: analyzes batch
analytics-python/main.py - Metrics analysis → Data cleaning: uses cleaning
analytics-python/analise.py - Metrics analysis → Insights: uses insights
analytics-python/analise.py - ETL endpoint → ETL persistence: persists results
analytics-python/main.py - ETL persistence → PostgreSQL: writes batch and metrics
- Dashboard queries → PostgreSQL: reads history and metrics
- API client → Reports and charts: serves reports
- API client → Analytics charts: serves statistics
- User → Session state: registers or signs in
- Session state → API client: requests authentication
Frontend/src/stores/auth.js - API client → Authentication API: calls API
- Authentication API → Account authentication: delegates
Backend/oversight/src/main/java/com/senai/oversight/controller/AuthController.java - Account authentication → JWT security: creates token
Backend/oversight/src/main/java/com/senai/oversight/service/AuthService.java - Account authentication → User repository: saves or finds users
Backend/oversight/src/main/java/com/senai/oversight/service/AuthService.java - User repository → PostgreSQL: stores accounts
- Administrator → User administration: manages accounts
- User administration → User management: delegates
Backend/oversight/src/main/java/com/senai/oversight/controller/AdminUsuarioController.java - User management → User repository: updates accounts
Backend/oversight/src/main/java/com/senai/oversight/service/UsuarioService.java