# patry-smrnf/database_og architecture

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

- Interactive diagram: https://gitdiagram.com/patry-smrnf/database_og
- Repository: https://github.com/patry-smrnf/database_og

## Overview

##### Project type and purpose
- This is a standalone MySQL-like database engine written in C++ (per README: “own query language,” “own database structure,” “fully editable database”).
- It exposes a CLI (Misc/app.cpp + main.cpp) that reads user input and dispatches it to internal modules.

##### File structure
- Top-level:
– CMakeLists.txt → build config
– main.cpp + Misc/app.* → application entry point & CLI loop
- Language layers:
– DQL/… → Data Query Language (SELECT, WHERE, etc.)
– DML/… → Data Manipulation Language (INSERT, UPDATE, DELETE)
– DDL/… → Data Definition Language (CREATE/DROP tables)
- Storage layer:
– Databases/… → database_creator, reader, methods, core structures
- Utilities:
– Headers (`*_structures.h`) define in-memory representations

##### Extract README insights
– Custom SQL-like parser & executor
– On-disk storage format + in-memory data structures
– Full CRUD + schema evolution

##### Detailed callouts (optional for clarity)
- Inside DQL: show “Where_STATEMENT” submodule under DQL
- Inside Databases: group `database_creator`, `database_reader`, `database_methods` under “Storage Engine”
- Header-only struct definitions as data contracts between modules

## Diagram (Mermaid)

```mermaid
flowchart TD
    %% CLI Layer
    subgraph "CLI Front End"
        CLI_main["main.cpp"]:::frontend
        CLI_appcpp["app.cpp"]:::frontend
        CLI_apph["app.h"]:::frontend
    end

    %% Dispatcher
    Dispatcher["Query Dispatcher"]:::processor

    %% Query Processor Layer
    subgraph "Query Processor"
        subgraph "DDL Module"
            DDL_cpp["DDL.cpp"]:::module
            DDL_h["DDL.h"]:::module
            DDL_CREATE["DDL_CREATE.cpp"]:::module
            DDL_DROP["DDL_DROP.cpp"]:::module
            DDL_struct["DDL_structures.h"]:::module
        end
        subgraph "DML Module"
            DML_cpp["DML.cpp"]:::module
            DML_h["DML.h"]:::module
        end
        subgraph "DQL Module"
            DQL_cpp["DQL.cpp"]:::module
            DQL_h["DQL.h"]:::module
            DQL_struct["DQL_structures.h"]:::module
            Where_cpp["Where_STATEMENT.cpp"]:::module
            Where_h["Where_STATEMENT.h"]:::module
        end
    end

    %% Storage Layer
    subgraph "Storage Engine"
        DB_cpp["database.cpp"]:::storage
        DB_h["database.h"]:::storage
        Creator["database_creator.cpp"]:::storage
        Methods["database_methods.cpp"]:::storage
        Reader["database_reader.cpp"]:::storage
        DB_struct["database_structures.h"]:::storage
    end

    %% Disk Layer
    Disk["On-Disk Data Files"]:::disk

    %% Project Files
    subgraph "Project Files"
        CMake["CMakeLists.txt"]:::utility
        README["README.md"]:::utility
    end

    %% Data Flows
    CLI_main --> Dispatcher
    CLI_appcpp --> Dispatcher
    CLI_apph --> Dispatcher

    Dispatcher -->|"DDL queries"| DDL_cpp
    Dispatcher -->|"DML queries"| DML_cpp
    Dispatcher -->|"DQL queries"| DQL_cpp

    DDL_cpp --> DB_cpp
    DML_cpp --> Reader
    DML_cpp --> Methods
    DQL_cpp --> Reader

    DB_cpp --> Creator
    DB_cpp --> Methods
    DB_cpp --> Reader
    DB_cpp --> DB_h
    Creator --> Disk
    Methods --> Disk
    Reader --> Disk

    Disk -->|"results"| Dispatcher
    Dispatcher -->|"output"| CLI_appcpp

    %% Click Events
    click CLI_main "https://github.com/patry-smrnf/database_og/blob/master/main.cpp"
    click CLI_appcpp "https://github.com/patry-smrnf/database_og/blob/master/Misc/app.cpp"
    click CLI_apph "https://github.com/patry-smrnf/database_og/blob/master/Misc/app.h"
    click DDL_cpp "https://github.com/patry-smrnf/database_og/blob/master/DDL/DDL.cpp"
    click DDL_h "https://github.com/patry-smrnf/database_og/blob/master/DDL/DDL.h"
    click DDL_CREATE "https://github.com/patry-smrnf/database_og/blob/master/DDL/DDL_CREATE.cpp"
    click DDL_DROP "https://github.com/patry-smrnf/database_og/blob/master/DDL/DDL_DROP.cpp"
    click DDL_struct "https://github.com/patry-smrnf/database_og/blob/master/DDL/DDL_structures.h"
    click DML_cpp "https://github.com/patry-smrnf/database_og/blob/master/DML/DML.cpp"
    click DML_h "https://github.com/patry-smrnf/database_og/blob/master/DML/DML.h"
    click DQL_cpp "https://github.com/patry-smrnf/database_og/blob/master/DQL/DQL.cpp"
    click DQL_h "https://github.com/patry-smrnf/database_og/blob/master/DQL/DQL.h"
    click DQL_struct "https://github.com/patry-smrnf/database_og/blob/master/DQL/DQL_structures.h"
    click Where_cpp "https://github.com/patry-smrnf/database_og/blob/master/DQL/Misc/Where_STATEMENT.cpp"
    click Where_h "https://github.com/patry-smrnf/database_og/blob/master/DQL/Misc/Where_STATEMENT.h"
    click DB_cpp "https://github.com/patry-smrnf/database_og/blob/master/Databases/database.cpp"
    click DB_h "https://github.com/patry-smrnf/database_og/blob/master/Databases/database.h"
    click Creator "https://github.com/patry-smrnf/database_og/blob/master/Databases/database_creator.cpp"
    click Methods "https://github.com/patry-smrnf/database_og/blob/master/Databases/database_methods.cpp"
    click Reader "https://github.com/patry-smrnf/database_og/blob/master/Databases/database_reader.cpp"
    click DB_struct "https://github.com/patry-smrnf/database_og/blob/master/Databases/database_structures.h"
    click CMake "https://github.com/patry-smrnf/database_og/blob/master/CMakeLists.txt"
    click README "https://github.com/patry-smrnf/database_og/blob/master/README.md"

    %% Styles
    classDef frontend fill:#e0f7fa,stroke:#00796b,stroke-width:2px,shape:parallelogram
    classDef processor fill:#bbdefb,stroke:#0d47a1,stroke-width:2px
    classDef module fill:#e3f2fd,stroke:#1565c0,stroke-width:2px
    classDef storage fill:#e8f5e9,stroke:#2e7d32,stroke-width:2px
    classDef disk fill:#f0f4c3,stroke:#827717,stroke-width:2px,shape:cylinder
    classDef utility fill:#f5f5f5,stroke:#9e9e9e,stroke-width:2px,stroke-dasharray: 5 5
```
