# wwalery/dbseeder architecture

> Architecture diagram of the GitHub repository wwalery/dbseeder, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2024-12-27). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/wwalery/dbseeder
- Repository: https://github.com/wwalery/dbseeder

## Overview

##### Core Components
- Input Layer
- CSV File Reader
- File System Interface (for external files with @@ notation)
- Processing Layer
- Data Parser
- Reference Resolver
- SQL Generator
- Output Layer
- Database Writer
- Database Connectors (PostgreSQL, HSQL)

##### Data Flow Architecture

**[CSV Files] → [Reader Layer] → [Processing Layer] → [Writer Layer] → [Database]**

Detailed Component Breakdown:

A. Input Processing (Reader Layer):
- CSVReader component
- ReaderFactory for extensibility
- External file reader for @@ notation
- To IReader interface

B. Core Processing:
- DBSeeder as the central coordinator
- DBSSettings configuration component
- Data transformation components:
- DataRow processor
- ReferenceInfo resolver
- SeedInfo manager

C. Database Interface:
- SQLGenerator
- Database abstraction layer
- Specific database implementations
- Writer interface implementation

Visual Elements to Include:

Special Considerations:

##### Event listener system
- onRow
- onInsert
- onUpdate
- onAfterInsert

##### Configuration flow
- DBSSettings builder pattern
- Source type configuration
- Database connection settings

##### Reference resolution system
- How foreign key references are resolved
- Reference checking process

##### Data transformation pipeline
- CSV parsing
- Data type recognition
- Array handling (| delimiter)
- External file content inclusion

Key Relationships to Emphasize:

##### Event listener integration points

- Component types and their visual representations
- Special notations for listeners and hooks

## Diagram (Mermaid)

```mermaid
flowchart TB
    %% Styles and Classes
    classDef input fill:#b3d9ff,stroke:#333
    classDef process fill:#90EE90,stroke:#333
    classDef database fill:#ffb366,stroke:#333
    classDef interface fill:#e6e6e6,stroke:#333
    classDef external fill:#d3d3d3,stroke:#333

    %% Input Layer
    subgraph InputLayer
        CSV[("CSV Files")]:::external
        ExtFiles[("External Files")]:::external
        IReader["IReader Interface"]:::interface
        ReaderFactory["Reader Factory"]:::input
        CSVReader["CSV Reader"]:::input
        CSVSettings["CSV Settings"]:::input
        ExtReader["External File Reader"]:::input
    end

    %% Processing Layer
    subgraph ProcessingLayer
        DBSeeder["DB Seeder"]:::process
        DBSSettings["DBS Settings"]:::process
        DataRow["Data Row Processor"]:::process
        ReferenceInfo["Reference Resolver"]:::process
        SeedInfo["Seed Info Manager"]:::process
    end

    %% Database Layer
    subgraph DatabaseLayer
        SQLGen["SQL Generator"]:::database
        IWriter["IWriter Interface"]:::interface
        DBWriter["Database Writer"]:::database
        Database["Database Interface"]:::interface
        PostgreSQL["PostgreSQL Implementation"]:::database
        DB[("Database")]:::external
    end

    %% Connections
    CSV --> CSVReader
    ExtFiles --> ExtReader
    ReaderFactory --> CSVReader
    ReaderFactory --> ExtReader
    CSVReader --> IReader
    ExtReader --> IReader
    CSVSettings --> CSVReader
    
    IReader --> DBSeeder
    DBSSettings --> DBSeeder
    DBSeeder --> DataRow
    DataRow --> ReferenceInfo
    ReferenceInfo --> SeedInfo
    
    SeedInfo --> SQLGen
    SQLGen --> DBWriter
    DBWriter --> IWriter
    IWriter --> Database
    Database --> PostgreSQL
    PostgreSQL --> DB

    %% Click Events
    click CSVReader "https://github.com/wwalery/DBSeeder/blob/main/src/main/java/dev/walgo/dbseeder/reader/csv/CSVReader.java"
    click ReaderFactory "https://github.com/wwalery/DBSeeder/blob/main/src/main/java/dev/walgo/dbseeder/reader/ReaderFactory.java"
    click IReader "https://github.com/wwalery/DBSeeder/blob/main/src/main/java/dev/walgo/dbseeder/reader/IReader.java"
    click DataRow "https://github.com/wwalery/DBSeeder/blob/main/src/main/java/dev/walgo/dbseeder/data/DataRow.java"
    click ReferenceInfo "https://github.com/wwalery/DBSeeder/blob/main/src/main/java/dev/walgo/dbseeder/data/ReferenceInfo.java"
    click DBSeeder "https://github.com/wwalery/DBSeeder/blob/main/src/main/java/dev/walgo/dbseeder/DBSeeder.java"
    click DBSSettings "https://github.com/wwalery/DBSeeder/blob/main/src/main/java/dev/walgo/dbseeder/DBSSettings.java"
    click SQLGen "https://github.com/wwalery/DBSeeder/blob/main/src/main/java/dev/walgo/dbseeder/writer/SQLGenerator.java"
    click DBWriter "https://github.com/wwalery/DBSeeder/blob/main/src/main/java/dev/walgo/dbseeder/writer/DBWriter.java"
    click IWriter "https://github.com/wwalery/DBSeeder/blob/main/src/main/java/dev/walgo/dbseeder/writer/IWriter.java"
    click Database "https://github.com/wwalery/DBSeeder/blob/main/src/main/java/dev/walgo/dbseeder/db/Database.java"
    click PostgreSQL "https://github.com/wwalery/DBSeeder/blob/main/src/main/java/dev/walgo/dbseeder/db/PostgreSQLDatabase.java"
    click SeedInfo "https://github.com/wwalery/DBSeeder/blob/main/src/main/java/dev/walgo/dbseeder/data/SeedInfo.java"
    click CSVSettings "https://github.com/wwalery/DBSeeder/blob/main/src/main/java/dev/walgo/dbseeder/reader/csv/CSVSettings.java"

    %% Legend
    subgraph Legend
        L1["Input Component"]:::input
        L2["Processing Component"]:::process
        L3["Database Component"]:::database
        L4["Interface"]:::interface
        L5["External System"]:::external
    end
```
