# shreyasmahajann/sql_in_cpp architecture

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

- Interactive diagram: https://gitdiagram.com/shreyasmahajann/sql_in_cpp
- Repository: https://github.com/shreyasmahajann/sql_in_cpp

## Overview

##### Project type and purpose
- This is a standalone, file-based Database Management System written in C++ (a monolithic backend application).
- It provides basic database and table operations, stores data in CSV files, and is invoked via a simple CLI entry point (`main.cpp`).

##### File structure
- Top-level C++ sources:
- `main.cpp` – application entry and initialization logic
- `database.cpp` / `database.h` – Database class handles DB creation, loading, and registry (`information_schema.csv`)
- `table.cpp` / `table.h` – Table class (inherits/uses Database) handles column definition (`columns.csv`), data insertion (`data.csv`), and display
- Build: `Makefile` for compilation and clean
- Storage directory: `Databases/`
- `information_schema.csv` – global registry of databases
- Per–database folders (e.g., `baseDb/`, `db1/`), each containing `tables.csv` plus subfolders per table
- Each table subfolder holds `columns.csv` and `data.csv`

##### README for additional insights
- Describes system initialization (`initializeDatabaseSystem()`), supported data types, core classes, file-storage layout, and example usage.
- No external services or networking—pure filesystem I/O and in-memory class logic.

- CLI / Application Layer (main.cpp)
- Initialization Module (`initializeDatabaseSystem()`)
- Database Manager (Database class)
- Table Manager (Table class)
- File System Storage (folder structure & CSV files)
- Registry Files:
– information_schema.csv (global DB registry)
– tables.csv (per-DB table registry)
– columns.csv & data.csv (per-table metadata & data)
1. CLI invokes Initialization Module → creates `Databases/` + `information_schema.csv`
2. User calls Database constructor → Database Manager reads/writes `information_schema.csv`, creates DB folder, writes `tables.csv`
3. User calls Table constructor → Table Manager calls Database Manager to verify DB, updates `tables.csv`, creates table folder, writes `columns.csv`
4. Table Manager.addRow() → writes to `data.csv`
5. Table Manager.displayTable() → reads `columns.csv` & `data.csv` → outputs to console
c. Architectural patterns & design principles:
- Monolithic layered architecture (CLI → Business logic classes → Persistence)
- Single Responsibility (Database vs. Table)
- File-based persistence abstraction behind the Database/Table API
d. Key technologies and libraries:
- C++11 filesystem & I/O (`<filesystem>`, `<fstream>`, `<iostream>`)
- Makefile for build orchestration
- CSV format for persistence

## Diagram (Mermaid)

```mermaid
flowchart TD
    %% Layers
    subgraph "CLI Layer"
        CLI["CLI / Application Layer\n(main.cpp)"]:::cli
    end

    subgraph "Business Logic"
        Initialization["initializeDatabaseSystem()\n(database.cpp)"]:::backend
        DatabaseMgr["Database Manager\n(database.cpp, database.h)"]:::backend
        TableMgr["Table Manager\n(table.cpp, table.h)"]:::backend
    end

    subgraph "Persistence Layer"
        subgraph "File System Storage"
            DirDBs["Databases/"]:::storage
            InfoSchema["information_schema.csv"]:::files
            subgraph "Per-Database Folders"
                baseDbDir["baseDb/"]:::storage
                db1Dir["db1/"]:::storage
            end
            subgraph "baseDb Tables"
                tablesCsvBase["tables.csv"]:::files
                subgraph "table1"
                    columnsCsv["columns.csv"]:::files
                    dataCsv["data.csv"]:::files
                end
            end
            subgraph "db1 Tables"
                tablesCsvDb1["tables.csv"]:::files
            end
        end
    end

    subgraph "Documentation & Build"
        README["Project Documentation\n(README.md)"]:::doc
        Build["Build Orchestration\n(Makefile)"]:::doc
    end

    %% Relationships
    CLI -->|"invoke initializeDatabaseSystem()"| Initialization
    Initialization -->|"creates storage root"| DirDBs
    Initialization -->|"writes global registry"| InfoSchema

    CLI -->|"createDatabase()"| DatabaseMgr
    DatabaseMgr -->|"read/write global registry"| InfoSchema
    DatabaseMgr -->|"create DB folder" | baseDbDir
    DatabaseMgr -->|"write per-DB registry"| tablesCsvBase
    DatabaseMgr -->|"create DB folder"| db1Dir
    DatabaseMgr -->|"write per-DB registry"| tablesCsvDb1

    CLI -->|"createTable()"| TableMgr
    TableMgr -->|"verify DB"| DatabaseMgr
    TableMgr -->|"update per-DB registry"| tablesCsvBase
    TableMgr -->|"create table folder"| columnsCsv
    TableMgr -->|"write table metadata"| columnsCsv
    TableMgr -->|"addRow() write data"| dataCsv
    TableMgr -->|"displayTable() read columns & data"| columnsCsv
    TableMgr -->|"displayTable() read columns & data"| dataCsv
    TableMgr -->|"output to console"| CLI

    %% Click Events
    click CLI "https://github.com/shreyasmahajann/sql_in_cpp/blob/main/main.cpp"
    click Initialization "https://github.com/shreyasmahajann/sql_in_cpp/blob/main/database.cpp"
    click DatabaseMgr "https://github.com/shreyasmahajann/sql_in_cpp/blob/main/database.cpp"
    click DatabaseMgr "https://github.com/shreyasmahajann/sql_in_cpp/blob/main/database.h"
    click TableMgr "https://github.com/shreyasmahajann/sql_in_cpp/blob/main/table.cpp"
    click TableMgr "https://github.com/shreyasmahajann/sql_in_cpp/blob/main/table.h"
    click DirDBs "https://github.com/shreyasmahajann/sql_in_cpp/tree/main/Databases/"
    click InfoSchema "https://github.com/shreyasmahajann/sql_in_cpp/blob/main/Databases/information_schema.csv"
    click tablesCsvBase "https://github.com/shreyasmahajann/sql_in_cpp/blob/main/Databases/baseDb/tables.csv"
    click tablesCsvDb1 "https://github.com/shreyasmahajann/sql_in_cpp/blob/main/Databases/db1/tables.csv"
    click columnsCsv "https://github.com/shreyasmahajann/sql_in_cpp/blob/main/Databases/baseDb/table1/columns.csv"
    click dataCsv "https://github.com/shreyasmahajann/sql_in_cpp/blob/main/Databases/baseDb/table1/data.csv"
    click Build "https://github.com/shreyasmahajann/sql_in_cpp/tree/main/Makefile"
    click README "https://github.com/shreyasmahajann/sql_in_cpp/blob/main/README.md"

    %% Styles
    classDef cli fill:#f9f,stroke:#333,stroke-width:1px
    classDef backend fill:#bbf,stroke:#333,stroke-width:1px
    classDef storage fill:#bfb,stroke:#333,stroke-width:1px
    classDef files fill:#afa,stroke:#333,stroke-width:1px
    classDef doc fill:#ffa,stroke:#333,stroke-width:1px
```
