# liavhv/apinodemssql architecture

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

- Interactive diagram: https://gitdiagram.com/liavhv/apinodemssql
- Repository: https://github.com/liavhv/apinodemssql

## Overview

This Node.js/Express Web API demonstrates user registration and JWT login alongside state and municipality catalog management backed by SQL Server. Clients submit JSON requests; registration validates and hashes credentials before storing a user, login verifies them and returns a token, and bearer-token middleware gates the catalog routes. Those routes read and modify states and municipalities through a shared SQL connection helper. The README also documents SQL Server setup and the main endpoint examples. Relationships below follow the sampled route mounting, middleware, and database calls; no separate SQL schema node is inferred from the tree.

Main entry points: [`src/index.js`](https://github.com/liavhv/apinodemssql/blob/main/src/index.js) (Express App), [`src/sqlCon.js`](https://github.com/liavhv/apinodemssql/blob/main/src/sqlCon.js) (SQL Connection), [`src/routes/registrarUsuario.route.js`](https://github.com/liavhv/apinodemssql/blob/main/src/routes/registrarUsuario.route.js) (User Registration), [`src/routes/login.route.js`](https://github.com/liavhv/apinodemssql/blob/main/src/routes/login.route.js) (User Login)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_api["API Runtime"]
  node_app["Express App<br/>[index.js]"]
end

subgraph group_identity["Identity"]
  node_register["User Registration"]
  node_login["User Login<br/>[login.route.js]"]
  node_token["JWT Guard<br/>[verificarToken.js]"]
end

subgraph group_catalog["Catalog Data"]
  node_states["State Routes<br/>[estados.route.js]"]
  node_municipalities["Municipality Routes"]
end

subgraph group_persistence["SQL Persistence"]
  node_connection["SQL Connection<br/>[sqlCon.js]"]
  node_sqlserver[("SQL Server")]
end

node_client(("API Client"))

node_client -->|"sends HTTP"| node_app
node_app -->|"mounts route"| node_register
node_app -->|"mounts route"| node_login
node_app -->|"guards catalog"| node_token
node_app -->|"mounts route"| node_states
node_app -->|"mounts route"| node_municipalities
node_register -->|"gets connection"| node_connection
node_login -->|"gets connection"| node_connection
node_states -->|"queries database"| node_connection
node_municipalities -->|"queries database"| node_connection
node_connection -->|"connects"| node_sqlserver

click node_app "https://github.com/liavhv/apinodemssql/blob/main/src/index.js"
click node_register "https://github.com/liavhv/apinodemssql/blob/main/src/routes/registrarUsuario.route.js"
click node_login "https://github.com/liavhv/apinodemssql/blob/main/src/routes/login.route.js"
click node_token "https://github.com/liavhv/apinodemssql/blob/main/src/verificarToken.js"
click node_states "https://github.com/liavhv/apinodemssql/blob/main/src/routes/estados.route.js"
click node_municipalities "https://github.com/liavhv/apinodemssql/blob/main/src/routes/municipios.route.js"
click node_connection "https://github.com/liavhv/apinodemssql/blob/main/src/sqlCon.js"

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_app,node_client toneBlue
class node_register,node_login,node_token toneAmber
class node_states,node_municipalities toneMint
class node_connection,node_sqlserver toneRose
```

## Components

### API Runtime

- [Express App](https://github.com/liavhv/apinodemssql/blob/main/src/index.js): `src/index.js`

### Identity

- [User Registration](https://github.com/liavhv/apinodemssql/blob/main/src/routes/registrarUsuario.route.js): `src/routes/registrarUsuario.route.js`
- [User Login](https://github.com/liavhv/apinodemssql/blob/main/src/routes/login.route.js): `src/routes/login.route.js`
- [JWT Guard](https://github.com/liavhv/apinodemssql/blob/main/src/verificarToken.js): `src/verificarToken.js`

### Catalog Data

- [State Routes](https://github.com/liavhv/apinodemssql/blob/main/src/routes/estados.route.js): `src/routes/estados.route.js`
- [Municipality Routes](https://github.com/liavhv/apinodemssql/blob/main/src/routes/municipios.route.js): `src/routes/municipios.route.js`

### SQL Persistence

- [SQL Connection](https://github.com/liavhv/apinodemssql/blob/main/src/sqlCon.js): `src/sqlCon.js`
- **SQL Server**

### Other components

- **API Client**

## Connections

- API Client → Express App: sends HTTP (evidence: `README.md`)
- Express App → User Registration: mounts route (evidence: `src/index.js`)
- Express App → User Login: mounts route (evidence: `src/index.js`)
- Express App → JWT Guard: guards catalog (evidence: `src/index.js`)
- Express App → State Routes: mounts route (evidence: `src/index.js`)
- Express App → Municipality Routes: mounts route (evidence: `src/index.js`)
- User Registration → SQL Connection: gets connection (evidence: `src/routes/registrarUsuario.route.js`)
- User Login → SQL Connection: gets connection (evidence: `src/routes/login.route.js`)
- State Routes → SQL Connection: queries database (evidence: `src/routes/estados.route.js`)
- Municipality Routes → SQL Connection: queries database (evidence: `src/routes/municipios.route.js`)
- SQL Connection → SQL Server: connects (evidence: `src/sqlCon.js`)
