# jhonatas48/mysql_api_simples architecture

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

- Interactive diagram: https://gitdiagram.com/jhonatas48/mysql_api_simples
- Repository: https://github.com/jhonatas48/mysql_api_simples

## Overview

This is a Java API for integrating applications with MySQL and SQLite. The principal workflow is that callers configure a connection manager and submit create/CRUD operations through transactions; SQL builders select dialect-specific statements, and connections provide database access. The tree also documents annotation-driven foreign-key processing and asynchronous transaction support. Transaction execution and several CRUD implementations were not excerpted, so those components and their links are represented at the supported directory level; edges are limited to explicit README or source-index references.

Main entry points: [`src/main/java/api/connection/ConnectionManager.java`](https://github.com/jhonatas48/mysql_api_simples/blob/main/src/main/java/api/connection/ConnectionManager.java) (Connection manager), [`src/main/java/api/models/Transaction.java`](https://github.com/jhonatas48/mysql_api_simples/blob/main/src/main/java/api/models/Transaction.java) (Transaction execution), [`src/main/java/api/connection/sqlbuilder/SQLBuildManager.java`](https://github.com/jhonatas48/mysql_api_simples/blob/main/src/main/java/api/connection/sqlbuilder/SQLBuildManager.java) (SQL builder manager), [`src/main/java/api/models/annotations/processor/ForeiKeyProcessor.java`](https://github.com/jhonatas48/mysql_api_simples/blob/main/src/main/java/api/models/annotations/processor/ForeiKeyProcessor.java) (Foreign-key processor)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_connection["Connections"]
  node_manager["Connection manager"]
  node_connection_api["Connection contract<br/>[IConnection.java]"]
  node_sqlite_conn["SQLite connection"]
  node_mysql_conn["MySQL connection"]
  node_sqlite_db[("SQLite store")]
  node_mysql_db[("MySQL store")]
end

subgraph group_transaction["Transactions"]
  node_transaction_api["Transaction API<br/>[ITransaction.java]"]
  node_transaction["Transaction execution<br/>[Transaction.java]"]
  node_perform["Transaction performer"]
  node_commit["Commit actions"]
  node_crud["CRUD operations"]
end

subgraph group_sql["SQL statements"]
  node_create_model["Create statement<br/>[Create.java]"]
  node_row["Row values<br/>[Row.java]"]
  node_sql_manager["SQL builder manager"]
  node_sql_builders["Dialect builders"]
  node_sql_contract["SQL build contract<br/>[SQLBuild.java]"]
end

subgraph group_mapping["Mapping and async"]
  node_foreign_processor["Foreign-key processor"]
  node_table_processor["Table processor"]
  node_async["Async queue<br/>[AsyncManager.java]"]
  node_checks["Validation helpers<br/>[Checkers.java]"]
end

node_caller(("Application caller"))

node_caller -.->|"configures"| node_manager
node_caller -.->|"submits"| node_transaction_api
node_manager -->|"opens"| node_sqlite_conn
node_manager -->|"creates log schema"| node_transaction
node_sqlite_conn -->|"implements"| node_connection_api
node_mysql_conn -.->|"implements"| node_connection_api
node_sqlite_conn -.->|"connects"| node_sqlite_db
node_mysql_conn -.->|"connects"| node_mysql_db
node_transaction_api -.->|"implemented by"| node_transaction
node_transaction -.->|"delegates"| node_perform
node_transaction -.->|"provides"| node_crud
node_transaction -.->|"requests SQL"| node_sql_manager
node_sql_manager -->|"dispatches"| node_sql_builders
node_sql_manager -->|"selects by contract"| node_sql_contract
node_sql_builders -.->|"implements"| node_sql_contract
node_create_model -->|"stores columns in"| node_row
node_foreign_processor -->|"resolves table via"| node_table_processor
node_foreign_processor -->|"reads table fields"| node_manager
node_foreign_processor -->|"queries relation"| node_transaction
node_manager -->|"exposes"| node_async
node_manager -->|"validates inputs"| node_checks
node_sql_manager -->|"registers builders"| node_sql_builders

click node_manager "https://github.com/jhonatas48/mysql_api_simples/blob/main/src/main/java/api/connection/ConnectionManager.java"
click node_connection_api "https://github.com/jhonatas48/mysql_api_simples/blob/main/src/main/java/api/interfaces/connection/IConnection.java"
click node_sqlite_conn "https://github.com/jhonatas48/mysql_api_simples/blob/main/src/main/java/api/connection/impl/pools/SqliteConnection.java"
click node_mysql_conn "https://github.com/jhonatas48/mysql_api_simples/blob/main/src/main/java/api/connection/impl/pools/MysqlConnection.java"
click node_transaction_api "https://github.com/jhonatas48/mysql_api_simples/blob/main/src/main/java/api/interfaces/actions/ITransaction.java"
click node_transaction "https://github.com/jhonatas48/mysql_api_simples/blob/main/src/main/java/api/models/Transaction.java"
click node_perform "https://github.com/jhonatas48/mysql_api_simples/blob/main/src/main/java/api/models/PerformTransaction.java"
click node_commit "https://github.com/jhonatas48/mysql_api_simples/blob/main/src/main/java/api/models/CommitActionImpl.java"
click node_crud "https://github.com/jhonatas48/mysql_api_simples/tree/main/src/main/java/api/models"
click node_create_model "https://github.com/jhonatas48/mysql_api_simples/blob/main/src/main/java/api/models/statements/Create.java"
click node_row "https://github.com/jhonatas48/mysql_api_simples/blob/main/src/main/java/api/models/statements/Row.java"
click node_sql_manager "https://github.com/jhonatas48/mysql_api_simples/blob/main/src/main/java/api/connection/sqlbuilder/SQLBuildManager.java"
click node_sql_builders "https://github.com/jhonatas48/mysql_api_simples/tree/main/src/main/java/api/models/statements"
click node_sql_contract "https://github.com/jhonatas48/mysql_api_simples/blob/main/src/main/java/api/models/statements/interfaces/SQLBuild.java"
click node_foreign_processor "https://github.com/jhonatas48/mysql_api_simples/blob/main/src/main/java/api/models/annotations/processor/ForeiKeyProcessor.java"
click node_table_processor "https://github.com/jhonatas48/mysql_api_simples/blob/main/src/main/java/api/models/annotations/processor/TableProcessor.java"
click node_async "https://github.com/jhonatas48/mysql_api_simples/blob/main/src/main/java/api/core/AsyncManager.java"
click node_checks "https://github.com/jhonatas48/mysql_api_simples/blob/main/src/main/java/api/models/utils/Checkers.java"

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_manager,node_connection_api,node_sqlite_conn,node_mysql_conn,node_sqlite_db,node_mysql_db toneBlue
class node_transaction_api,node_transaction,node_perform,node_commit,node_crud toneAmber
class node_create_model,node_row,node_sql_manager,node_sql_builders,node_sql_contract toneMint
class node_foreign_processor,node_table_processor,node_async,node_checks toneRose
class node_caller toneIndigo
```

## Components

### Connections

- [Connection manager](https://github.com/jhonatas48/mysql_api_simples/blob/main/src/main/java/api/connection/ConnectionManager.java): `src/main/java/api/connection/ConnectionManager.java`
- [Connection contract](https://github.com/jhonatas48/mysql_api_simples/blob/main/src/main/java/api/interfaces/connection/IConnection.java): `src/main/java/api/interfaces/connection/IConnection.java`
- [SQLite connection](https://github.com/jhonatas48/mysql_api_simples/blob/main/src/main/java/api/connection/impl/pools/SqliteConnection.java): `src/main/java/api/connection/impl/pools/SqliteConnection.java`
- [MySQL connection](https://github.com/jhonatas48/mysql_api_simples/blob/main/src/main/java/api/connection/impl/pools/MysqlConnection.java): `src/main/java/api/connection/impl/pools/MysqlConnection.java`
- **SQLite store**
- **MySQL store**

### Transactions

- [Transaction API](https://github.com/jhonatas48/mysql_api_simples/blob/main/src/main/java/api/interfaces/actions/ITransaction.java): `src/main/java/api/interfaces/actions/ITransaction.java`
- [Transaction execution](https://github.com/jhonatas48/mysql_api_simples/blob/main/src/main/java/api/models/Transaction.java): `src/main/java/api/models/Transaction.java`
- [Transaction performer](https://github.com/jhonatas48/mysql_api_simples/blob/main/src/main/java/api/models/PerformTransaction.java): `src/main/java/api/models/PerformTransaction.java`
- [Commit actions](https://github.com/jhonatas48/mysql_api_simples/blob/main/src/main/java/api/models/CommitActionImpl.java): `src/main/java/api/models/CommitActionImpl.java`
- [CRUD operations](https://github.com/jhonatas48/mysql_api_simples/tree/main/src/main/java/api/models): `src/main/java/api/models`

### SQL statements

- [Create statement](https://github.com/jhonatas48/mysql_api_simples/blob/main/src/main/java/api/models/statements/Create.java): `src/main/java/api/models/statements/Create.java`
- [Row values](https://github.com/jhonatas48/mysql_api_simples/blob/main/src/main/java/api/models/statements/Row.java): `src/main/java/api/models/statements/Row.java`
- [SQL builder manager](https://github.com/jhonatas48/mysql_api_simples/blob/main/src/main/java/api/connection/sqlbuilder/SQLBuildManager.java): `src/main/java/api/connection/sqlbuilder/SQLBuildManager.java`
- [Dialect builders](https://github.com/jhonatas48/mysql_api_simples/tree/main/src/main/java/api/models/statements): `src/main/java/api/models/statements`
- [SQL build contract](https://github.com/jhonatas48/mysql_api_simples/blob/main/src/main/java/api/models/statements/interfaces/SQLBuild.java): `src/main/java/api/models/statements/interfaces/SQLBuild.java`

### Mapping and async

- [Foreign-key processor](https://github.com/jhonatas48/mysql_api_simples/blob/main/src/main/java/api/models/annotations/processor/ForeiKeyProcessor.java): `src/main/java/api/models/annotations/processor/ForeiKeyProcessor.java`
- [Table processor](https://github.com/jhonatas48/mysql_api_simples/blob/main/src/main/java/api/models/annotations/processor/TableProcessor.java): `src/main/java/api/models/annotations/processor/TableProcessor.java`
- [Async queue](https://github.com/jhonatas48/mysql_api_simples/blob/main/src/main/java/api/core/AsyncManager.java): `src/main/java/api/core/AsyncManager.java`
- [Validation helpers](https://github.com/jhonatas48/mysql_api_simples/blob/main/src/main/java/api/models/utils/Checkers.java): `src/main/java/api/models/utils/Checkers.java`

### Other components

- **Application caller**

## Connections

- Application caller → Connection manager: configures
- Application caller → Transaction API: submits
- Connection manager → SQLite connection: opens (evidence: `src/main/java/api/connection/ConnectionManager.java`)
- Connection manager → Transaction execution: creates log schema (evidence: `src/main/java/api/connection/ConnectionManager.java`)
- SQLite connection → Connection contract: implements (evidence: `src/main/java/api/connection/impl/pools/SqliteConnection.java`)
- MySQL connection → Connection contract: implements
- SQLite connection → SQLite store: connects
- MySQL connection → MySQL store: connects
- Transaction API → Transaction execution: implemented by (evidence: `src/main/java/api/models/Transaction.java`)
- Transaction execution → Transaction performer: delegates
- Transaction execution → CRUD operations: provides (evidence: `src/main/java/api/models/Transaction.java`)
- Transaction execution → SQL builder manager: requests SQL
- SQL builder manager → Dialect builders: dispatches (evidence: `src/main/java/api/connection/sqlbuilder/SQLBuildManager.java`)
- SQL builder manager → SQL build contract: selects by contract (evidence: `src/main/java/api/connection/sqlbuilder/SQLBuildManager.java`)
- Dialect builders → SQL build contract: implements (evidence: `src/main/java/api/models/statements/createtable/CreateTableSQLITE.java`)
- Create statement → Row values: stores columns in (evidence: `src/main/java/api/models/statements/Create.java`)
- Foreign-key processor → Table processor: resolves table via (evidence: `src/main/java/api/models/annotations/processor/ForeiKeyProcessor.java`)
- Foreign-key processor → Connection manager: reads table fields (evidence: `src/main/java/api/models/annotations/processor/ForeiKeyProcessor.java`)
- Foreign-key processor → Transaction execution: queries relation (evidence: `src/main/java/api/models/annotations/processor/ForeiKeyProcessor.java`)
- Connection manager → Async queue: exposes (evidence: `src/main/java/api/connection/ConnectionManager.java`)
- Connection manager → Validation helpers: validates inputs (evidence: `src/main/java/api/connection/ConnectionManager.java`)
- SQL builder manager → Dialect builders: registers builders (evidence: `src/main/java/api/connection/sqlbuilder/SQLBuildManager.java`)
