# anuragfrantic/pocker_tracker_backendmysql architecture

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

- Interactive diagram: https://gitdiagram.com/anuragfrantic/pocker_tracker_backendmysql
- Repository: https://github.com/anuragfrantic/pocker_tracker_backendmysql

## Overview

##### Project Type and Purpose
- This is a RESTful backend service built with Node.js/Express and MySQL.
- It manages poker game data (users, game sessions, transactions, chips) and provides authenticated API endpoints for CRUD operations and uploads.

##### File Structure
- Top-level:
- poker.js – entry point (Express app bootstrap)
- config/ – database (config/config.json, config/db.js) & environment
- controllers/ – route handlers implementing business logic
- routes/ – Express routers mapping endpoints to controllers
- middleware/ – Auth (JWT) & file-upload logic
- models/ – Sequelize or raw models defining tables & relations
- uploads/ – persistent storage for CSV uploads
- Patterns:
- MVC-style layering: routes → controllers → models
- Centralized config and env loading
- JWT-based stateless auth middleware
- Deployment:

##### README for Extra Context
- Technologies: Node.js, Express, MySQL, dotenv, bcryptjs, jsonwebtoken
- DB Schema: users, games, transactions, tables, chips and their relations
- Key API endpoints for users, games, transactions, chips

##### Main Components & Their Interactions
a. Client / External Consumer
- A frontend or third-party tool sends HTTP requests to your REST API.
b. Express API Server (Node.js)
- Entry Point (poker.js): loads .env, connects DB, mounts middleware, routes.
- Middleware Layer:
- Auth Middleware (verifies JWT)
- upload Middleware (handles CSV multipart requests)
- Routing Layer:
- authroutes.js, userRoutes.js, masterRoutes.js
- Controller Layer:
- Implements the logic per resource (UserController, GameController, etc.)
- Model Layer:
- ORM definitions (models/User.js, models/Games.js, etc.)
- index.js ties models and relations
c. MySQL Database
- Stores tables as defined in models.
- config/db.js manages the connection pool.
d. File Storage
- uploads/ folder holds CSV files; controllers reference these for bulk data import.
e. External Services
- bcryptjs for hashing passwords
- jsonwebtoken for JWT issuance/validation
- dotenv for config management

##### Architectural Patterns & Principles
- MVC separation for maintainability
- Layered architecture (HTTP → routing → auth/middleware → controllers → models → DB)
- Single responsibility per controller
- Stateless authentication (JWT)
- Config-driven environment management

## Diagram (Mermaid)

```mermaid
graph TD
    Client["Client / Frontend"]:::external

    subgraph "Express Application"
        subgraph "Entry Point"
            Entry["poker.js"]:::app
        end
        subgraph "Config & Environment"
            Env[".env"]:::config
            ConfigJson["config/config.json"]:::config
            DBConfig["config/db.js"]:::config
        end
        subgraph "Middleware Layer"
            AuthMW["Auth Middleware"]:::middleware
            UploadMW["Upload Middleware"]:::middleware
        end
        subgraph "Routing Layer"
            AuthRoutes["authroutes.js"]:::routing
            UserRoutes["userRoutes.js"]:::routing
            MasterRoutes["masterRoutes.js"]:::routing
        end
        subgraph "Controller Layer"
            AuthCtrl["authController.js"]:::controller
            UserCtrl["UserController.js"]:::controller
            GameCtrl["GameController.js"]:::controller
            GameTypesCtrl["GameTypesController.js"]:::controller
            PokerRoomCtrl["PokerRoomController.js"]:::controller
            SessionCtrl["SessionController.js"]:::controller
            SessionTypeCtrl["SessionTypeController.js"]:::controller
            SubCtrl["SubscriptionController.js"]:::controller
            PurchaseSubCtrl["PurchaseSubsriptionController.js"]:::controller
        end
        subgraph "Model Layer"
            IndexModel["index.js"]:::model
            UserModel["User.js"]:::model
            GamesModel["Games.js"]:::model
            GameTypesModel["GameTypes.js"]:::model
            SessionsModel["Sessions.js"]:::model
            SessionTypesModel["SessionTypes.js"]:::model
            PokerRoomModel["PokerRoom.js"]:::model
            SubscriptionModel["Subscription.js"]:::model
            PurchaseSubModel["PurchaseSubscription.js"]:::model
            PaymentModel["Payment.js"]:::model
        end
    end

    MySQL["MySQL Database"]:::db
    FileStorage["uploads/ (File Storage)"]:::storage
    Bcrypt["bcryptjs"]:::external
    JWTLib["jsonwebtoken"]:::external
    Dotenv["dotenv"]:::external

    Client -->|"HTTP Request"| Entry
    Entry -->|"loads .env"| Env
    Entry -->|"loads DB config"| ConfigJson
    Entry -->|"initializes pool"| DBConfig
    Entry -->|"uses dotenv"| Dotenv

    Entry -->|"mounts middleware"| AuthMW
    Entry -->|"mounts middleware"| UploadMW

    AuthMW -->|"validates JWT"| AuthCtrl
    UploadMW -->|"uploads CSV"| FileStorage

    Entry -->|"mounts routes"| AuthRoutes
    Entry -->|"mounts routes"| UserRoutes
    Entry -->|"mounts routes"| MasterRoutes

    AuthRoutes -->|"calls"| AuthCtrl
    UserRoutes -->|"calls"| UserCtrl
    MasterRoutes -->|"calls"| GameCtrl
    MasterRoutes -->|"calls"| GameTypesCtrl
    MasterRoutes -->|"calls"| PokerRoomCtrl
    MasterRoutes -->|"calls"| SessionCtrl
    MasterRoutes -->|"calls"| SessionTypeCtrl
    MasterRoutes -->|"calls"| SubCtrl
    MasterRoutes -->|"calls"| PurchaseSubCtrl

    AuthCtrl -->|"uses bcrypt"| Bcrypt
    AuthCtrl -->|"uses jsonwebtoken"| JWTLib

    AuthCtrl -->|"interacts with"| UserModel
    UserCtrl -->|"CRUD ops"| UserModel
    GameCtrl -->|"CRUD ops"| GamesModel
    GameTypesCtrl -->|"CRUD ops"| GameTypesModel
    PokerRoomCtrl -->|"CRUD ops"| PokerRoomModel
    SessionCtrl -->|"CRUD ops"| SessionsModel
    SessionTypeCtrl -->|"CRUD ops"| SessionTypesModel
    SubCtrl -->|"CRUD ops"| SubscriptionModel
    PurchaseSubCtrl -->|"CRUD ops"| PurchaseSubModel

    IndexModel -->|"aggregates models"| UserModel
    IndexModel -->|"aggregates models"| GamesModel
    IndexModel -->|"aggregates models"| GameTypesModel
    IndexModel -->|"aggregates models"| SessionsModel
    IndexModel -->|"aggregates models"| SessionTypesModel
    IndexModel -->|"aggregates models"| PokerRoomModel
    IndexModel -->|"aggregates models"| SubscriptionModel
    IndexModel -->|"aggregates models"| PurchaseSubModel
    IndexModel -->|"aggregates models"| PaymentModel

    UserModel -->|"reads/writes"| MySQL
    GamesModel -->|"reads/writes"| MySQL
    GameTypesModel -->|"reads/writes"| MySQL
    SessionsModel -->|"reads/writes"| MySQL
    SessionTypesModel -->|"reads/writes"| MySQL
    PokerRoomModel -->|"reads/writes"| MySQL
    SubscriptionModel -->|"reads/writes"| MySQL
    PurchaseSubModel -->|"reads/writes"| MySQL
    PaymentModel -->|"reads/writes"| MySQL

    classDef app fill:#D0E6FF,stroke:#0366d6
    classDef config fill:#F3F4F5,stroke:#999
    classDef middleware fill:#E0E0E0,stroke:#666
    classDef routing fill:#BBDEFB,stroke:#2196F3
    classDef controller fill:#C8E6C9,stroke:#388E3C
    classDef model fill:#FFE0B2,stroke:#FB8C00
    classDef db fill:#FFCC80,stroke:#E65100,stroke-width:2px
    classDef storage fill:#EEEEEE,stroke:#9E9E9E,stroke-dasharray: 5 5
    classDef external fill:#E1BEE7,stroke:#8E24AA,stroke-dasharray: 2 2

    click Entry "https://github.com/anuragfrantic/pocker_tracker_backendmysql/blob/main/poker.js"
    click Env "https://github.com/anuragfrantic/pocker_tracker_backendmysql/blob/main/.env"
    click ConfigJson "https://github.com/anuragfrantic/pocker_tracker_backendmysql/blob/main/config/config.json"
    click DBConfig "https://github.com/anuragfrantic/pocker_tracker_backendmysql/blob/main/config/db.js"
    click AuthMW "https://github.com/anuragfrantic/pocker_tracker_backendmysql/blob/main/middleware/Auth.js"
    click UploadMW "https://github.com/anuragfrantic/pocker_tracker_backendmysql/blob/main/middleware/upload.js"
    click AuthRoutes "https://github.com/anuragfrantic/pocker_tracker_backendmysql/blob/main/routes/authroutes.js"
    click UserRoutes "https://github.com/anuragfrantic/pocker_tracker_backendmysql/blob/main/routes/userRoutes.js"
    click MasterRoutes "https://github.com/anuragfrantic/pocker_tracker_backendmysql/blob/main/routes/masterRoutes.js"
    click AuthCtrl "https://github.com/anuragfrantic/pocker_tracker_backendmysql/blob/main/controllers/authController.js"
    click UserCtrl "https://github.com/anuragfrantic/pocker_tracker_backendmysql/blob/main/controllers/UserController.js"
    click GameCtrl "https://github.com/anuragfrantic/pocker_tracker_backendmysql/blob/main/controllers/GameController.js"
    click GameTypesCtrl "https://github.com/anuragfrantic/pocker_tracker_backendmysql/blob/main/controllers/GameTypesController.js"
    click PokerRoomCtrl "https://github.com/anuragfrantic/pocker_tracker_backendmysql/blob/main/controllers/PokerRoomController.js"
    click SessionCtrl "https://github.com/anuragfrantic/pocker_tracker_backendmysql/blob/main/controllers/SessionController.js"
    click SessionTypeCtrl "https://github.com/anuragfrantic/pocker_tracker_backendmysql/blob/main/controllers/SessionTypeController.js"
    click SubCtrl "https://github.com/anuragfrantic/pocker_tracker_backendmysql/blob/main/controllers/SubscriptionController.js"
    click PurchaseSubCtrl "https://github.com/anuragfrantic/pocker_tracker_backendmysql/blob/main/controllers/PurchaseSubsriptionController.js"
    click IndexModel "https://github.com/anuragfrantic/pocker_tracker_backendmysql/blob/main/models/index.js"
    click UserModel "https://github.com/anuragfrantic/pocker_tracker_backendmysql/blob/main/models/User.js"
    click GamesModel "https://github.com/anuragfrantic/pocker_tracker_backendmysql/blob/main/models/Games.js"
    click GameTypesModel "https://github.com/anuragfrantic/pocker_tracker_backendmysql/blob/main/models/GameTypes.js"
    click SessionsModel "https://github.com/anuragfrantic/pocker_tracker_backendmysql/blob/main/models/Sessions.js"
    click SessionTypesModel "https://github.com/anuragfrantic/pocker_tracker_backendmysql/blob/main/models/SessionTypes.js"
    click PokerRoomModel "https://github.com/anuragfrantic/pocker_tracker_backendmysql/blob/main/models/PokerRoom.js"
    click SubscriptionModel "https://github.com/anuragfrantic/pocker_tracker_backendmysql/blob/main/models/Subscription.js"
    click PurchaseSubModel "https://github.com/anuragfrantic/pocker_tracker_backendmysql/blob/main/models/PurchaseSubscription.js"
    click PaymentModel "https://github.com/anuragfrantic/pocker_tracker_backendmysql/blob/main/models/Payment.js"
```
