# santucho12/sistema-boston architecture

> Architecture diagram of the GitHub repository santucho12/sistema-boston, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2025-08-26). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/santucho12/sistema-boston
- Repository: https://github.com/santucho12/sistema-boston

## Overview

##### Project type and purpose
- This is a full-stack Flask web application (“Sistema de Gestión de CV”) whose goal is to let job seekers upload CVs and photos, and let administrators manage those records via a web panel.

##### File structure
- Top-level application entry:
- app.py – wires up Flask, loads config, registers blueprints/routes.
- config.py – application configuration (DB URIs, upload paths, secrets).
- auth.py – user authentication, session management.
- db.py – initializes and provides database connection (MySQL).
- utils.py – shared helper functions (e.g., file validation, image resizing).
- URL routing separated into “routes/”:
- routes/main.py – public-facing endpoints (CV upload form, index).
- routes/admin.py – admin panel endpoints (view/delete applicants).
- Static / templates / uploads:
- static/ – CSS and JS files for “index” and “admin” views.
- templates/ – Jinja2 HTML templates for main and admin.
- uploads/ – file system storage for received CVs and photos.
- Ancillary files: requirements.txt, install_deps.py, render.yaml (CI/deployment), .gitignore, venv.zip

##### Key insights from README
- Built on Flask with a MySQL backend.
- Uses a .env file for private credentials.
- Typical launch via “python app.py” after installing requirements.
- Secure, efficient file handling and admin control.

##### Main components & interactions
a. User Clients (Browser)
- Public user interface (submit CV + photo)
- Admin interface (login, manage candidates)
b. Web Server (Flask Application)
- app.py orchestrator
- auth.py handles login sessions
- routes/main.py & routes/admin.py handle HTTP requests
- utils.py for validation, file processing
c. Database (MySQL)
- db.py manages connections, runs queries (applicant records)
d. File Storage (Local FS under “uploads/”)
- Holds uploaded CVs and images
e. Configuration & Environment
- config.py reads settings, integrates with .env (secrets, DB URI)

##### Relationships & data flow
- Browser → HTTP(S) → Flask routes
- Public “/” GET → templates/index.html
- Public “/upload” POST → routes/main.py → utils.save_file → uploads/ + db.py insert record
- Admin “/login” → auth.py → session cookie
- Admin “/applicants” → db.py SELECT → templates/admin.html
- Admin “/applicants/delete” → db.py DELETE + file removal via utils
- Flask → Database (via db.py)
- Flask → File system (via utils.py)
- config.py provides DB credentials, upload paths

##### Architectural patterns & design principles
- MVC‐ish separation:
- Models: db.py data access
- Views: Jinja2 templates in /templates
- Controllers: route handlers in routes/
- Blueprint pattern: grouping of route modules (main vs admin)
- Single-process synchronous Flask app (no microservices)
- Local file storage for uploads (could be replaced by S3 in future)

## Diagram (Mermaid)

```mermaid
flowchart TD
    %% Clients
    subgraph "Browser (Client)"
        direction TB
        User("Public User"):::external
        Admin("Admin User"):::external
    end

    %% Flask Application
    subgraph "Flask App"
        direction TB
        AppEntry["app.py"]:::app
        Config["config.py"]:::app
        Auth["auth.py"]:::app
        subgraph "Routes"
            direction TB
            MainRoute["routes/main.py"]:::app
            AdminRoute["routes/admin.py"]:::app
        end
        Utils["utils.py"]:::app
        DBConnect["db.py"]:::app
        subgraph "Templates"
            direction TB
            TemplatesIndex["templates/index.html"]:::app
            TemplatesAdmin["templates/admin.html"]:::app
        end
        subgraph "Static Assets"
            direction TB
            JSIndex["static/javascript/index.js"]:::app
            JSAdmin["static/javascript/admin.js"]:::app
            CSSGlobal["static/styles.css"]:::app
            CSSIndex["static/stylesIndex.css"]:::app
            CSSAdmin["static/stylesAdmin.css"]:::app
        end
    end

    %% External Systems
    DB["MySQL Database"]:::db
    FileStorage["uploads/"]:::storage

    %% Client to Flask
    User -->|GET /| AppEntry
    User -->|POST /upload| MainRoute
    Admin -->|GET /login| Auth
    Admin -->|GET /applicants| AdminRoute
    Admin -->|POST /applicants/delete| AdminRoute

    %% Internal Flask interactions
    AppEntry --> Config
    AppEntry --> Auth
    AppEntry --> MainRoute
    AppEntry --> AdminRoute
    MainRoute --> Utils
    MainRoute --> DBConnect
    AdminRoute --> Auth
    AdminRoute --> DBConnect
    AdminRoute --> Utils
    Config --> DBConnect
    Config --> Utils
    DBConnect -->|SQL queries| DB
    Utils -->|File operations| FileStorage

    %% Click Events
    click AppEntry "https://github.com/santucho12/sistema-boston/blob/master/app.py"
    click Config "https://github.com/santucho12/sistema-boston/blob/master/config.py"
    click Auth "https://github.com/santucho12/sistema-boston/blob/master/auth.py"
    click DBConnect "https://github.com/santucho12/sistema-boston/blob/master/db.py"
    click Utils "https://github.com/santucho12/sistema-boston/blob/master/utils.py"
    click MainRoute "https://github.com/santucho12/sistema-boston/blob/master/routes/main.py"
    click AdminRoute "https://github.com/santucho12/sistema-boston/blob/master/routes/admin.py"
    click TemplatesIndex "https://github.com/santucho12/sistema-boston/blob/master/templates/index.html"
    click TemplatesAdmin "https://github.com/santucho12/sistema-boston/blob/master/templates/admin.html"
    click JSIndex "https://github.com/santucho12/sistema-boston/blob/master/static/javascript/index.js"
    click JSAdmin "https://github.com/santucho12/sistema-boston/blob/master/static/javascript/admin.js"
    click CSSGlobal "https://github.com/santucho12/sistema-boston/blob/master/static/styles.css"
    click CSSIndex "https://github.com/santucho12/sistema-boston/blob/master/static/stylesIndex.css"
    click CSSAdmin "https://github.com/santucho12/sistema-boston/blob/master/static/stylesAdmin.css"
    click FileStorage "https://github.com/santucho12/sistema-boston/tree/master/uploads/"
    click requirements["requirements.txt"] "requirements.txt"
    click installDeps["install_deps.py"] "install_deps.py"
    click CIConfig["render.yaml"] "render.yaml"

    %% Styles
    classDef external fill:#ccffcc,stroke:#333,stroke-width:1px
    classDef app fill:#cce5ff,stroke:#333,stroke-width:1px
    classDef db fill:#ffffcc,stroke:#333,stroke-width:1px,shape:cylinder
    classDef storage fill:#e6e6e6,stroke:#333,stroke-width:1px
    class requirements,installDeps,CIConfig app
    class DB db
    class FileStorage storage
```
