# tonysk8cr/steamgamesdata architecture

> Architecture diagram of the GitHub repository tonysk8cr/steamgamesdata, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-10-03). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/tonysk8cr/steamgamesdata
- Repository: https://github.com/tonysk8cr/steamgamesdata

## Overview

SteamData is a small Python ETL application for Steam game data: its runtime entry point obtains a PostgreSQL connection, reads a CSV, filters invalid rows, and loads the cleaned data. The graph preserves each core ETL module and the SQL schema file. The README provides no capability details, and the SQL file was not excerpted, so its relationship to the runtime is left unverified.

Main entry points: [`SteamData/src/steamdata/main.py`](https://github.com/tonysk8cr/steamgamesdata/blob/main/SteamData/src/steamdata/main.py) (ETL entry point), [`SteamData/src/steamdata/Extract.py`](https://github.com/tonysk8cr/steamgamesdata/blob/main/SteamData/src/steamdata/Extract.py) (CSV extraction), [`SteamData/src/steamdata/Load.py`](https://github.com/tonysk8cr/steamgamesdata/blob/main/SteamData/src/steamdata/Load.py) (Row loading), [`SteamData/src/steamdata/DataBase.py`](https://github.com/tonysk8cr/steamgamesdata/blob/main/SteamData/src/steamdata/DataBase.py) (DB connection)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_runtime["ETL Runtime"]
  node_main["ETL entry point<br/>[main.py]"]
  node_extract["CSV extraction<br/>[Extract.py]"]
  node_transform["Data cleaning<br/>[Transform.py]"]
  node_load["Row loading<br/>[Load.py]"]
end

subgraph group_storage["Database"]
  node_connection["DB connection<br/>[DataBase.py]"]
  node_schema["Table schema<br/>[tablecreation.sql]"]
end

node_user(("Operator"))
node_csv["Games CSV"]
node_postgres[("PostgreSQL")]

node_user -->|"runs"| node_main
node_main -->|"opens connection"| node_connection
node_connection -->|"connects to"| node_postgres
node_main -->|"calls extraction"| node_extract
node_extract -->|"reads CSV"| node_csv
node_main -->|"cleans rows"| node_transform
node_main -->|"loads cleaned rows"| node_load
node_load -->|"inserts rows"| node_postgres
node_schema -.->|"defines table"| node_postgres

click node_main "https://github.com/tonysk8cr/steamgamesdata/blob/main/SteamData/src/steamdata/main.py"
click node_extract "https://github.com/tonysk8cr/steamgamesdata/blob/main/SteamData/src/steamdata/Extract.py"
click node_transform "https://github.com/tonysk8cr/steamgamesdata/blob/main/SteamData/src/steamdata/Transform.py"
click node_load "https://github.com/tonysk8cr/steamgamesdata/blob/main/SteamData/src/steamdata/Load.py"
click node_connection "https://github.com/tonysk8cr/steamgamesdata/blob/main/SteamData/src/steamdata/DataBase.py"
click node_schema "https://github.com/tonysk8cr/steamgamesdata/blob/main/SteamData/src/postgrequery/tablecreation.sql"

classDef toneNeutral fill:#f8fafc,stroke:#334155,stroke-width:1.5px,color:#0f172a
classDef toneBlue fill:#dbeafe,stroke:#2563eb,stroke-width:1.5px,color:#172554
classDef toneAmber fill:#fef3c7,stroke:#d97706,stroke-width:1.5px,color:#78350f
classDef toneMint fill:#dcfce7,stroke:#16a34a,stroke-width:1.5px,color:#14532d
classDef toneRose fill:#ffe4e6,stroke:#e11d48,stroke-width:1.5px,color:#881337
classDef toneIndigo fill:#e0e7ff,stroke:#4f46e5,stroke-width:1.5px,color:#312e81
classDef toneTeal fill:#ccfbf1,stroke:#0f766e,stroke-width:1.5px,color:#134e4a
class node_main,node_extract,node_transform,node_load toneBlue
class node_connection,node_schema,node_postgres toneAmber
class node_user,node_csv toneIndigo
```

## Components

### ETL Runtime

- [ETL entry point](https://github.com/tonysk8cr/steamgamesdata/blob/main/SteamData/src/steamdata/main.py): `SteamData/src/steamdata/main.py`
- [CSV extraction](https://github.com/tonysk8cr/steamgamesdata/blob/main/SteamData/src/steamdata/Extract.py): `SteamData/src/steamdata/Extract.py`
- [Data cleaning](https://github.com/tonysk8cr/steamgamesdata/blob/main/SteamData/src/steamdata/Transform.py): `SteamData/src/steamdata/Transform.py`
- [Row loading](https://github.com/tonysk8cr/steamgamesdata/blob/main/SteamData/src/steamdata/Load.py): `SteamData/src/steamdata/Load.py`

### Database

- [DB connection](https://github.com/tonysk8cr/steamgamesdata/blob/main/SteamData/src/steamdata/DataBase.py): `SteamData/src/steamdata/DataBase.py`
- [Table schema](https://github.com/tonysk8cr/steamgamesdata/blob/main/SteamData/src/postgrequery/tablecreation.sql): `SteamData/src/postgrequery/tablecreation.sql`

### Other components

- **Operator**
- **Games CSV**
- **PostgreSQL**

## Connections

- Operator → ETL entry point: runs
- ETL entry point → DB connection: opens connection (evidence: `SteamData/src/steamdata/main.py`)
- DB connection → PostgreSQL: connects to (evidence: `SteamData/src/steamdata/DataBase.py`)
- ETL entry point → CSV extraction: calls extraction (evidence: `SteamData/src/steamdata/main.py`)
- CSV extraction → Games CSV: reads CSV (evidence: `SteamData/src/steamdata/Extract.py`)
- ETL entry point → Data cleaning: cleans rows (evidence: `SteamData/src/steamdata/main.py`)
- ETL entry point → Row loading: loads cleaned rows (evidence: `SteamData/src/steamdata/main.py`)
- Row loading → PostgreSQL: inserts rows (evidence: `SteamData/src/steamdata/Load.py`)
- Table schema → PostgreSQL: defines table
