How caresle/microservice-employees-odoo works
Main Components
a) External Systems:
• Odoo ERP System (with PostgreSQL database)
• Client Applications (API consumers)
b) Microservice Components:
• API Layer (Express.js Server)
• Controller Layer
• Database Layer (ODBC Connection)
• Query Layer
Component Organization
[Client Applications] → [API Layer (Express.js)] → [Controller Layer] → [Query Layer] → [ODBC Layer] → [Odoo PostgreSQL Database]
Specific Implementation Details
• Rectangle with rounded corners: External systems (Clients, Odoo ERP)
• Rectangle: Internal service components
Component Details
API Layer:
• Port: 3005 (from README)
• Endpoint: GET /employees
• Query Parameters: id, name, email, company
Controller Layer:
• employees.controller.ts
• Request handling
• Response formatting
Query Layer:
• employees.queries.ts
• SQL query management
• Data transformation
Database Layer:
• postgresql.ts
• ODBC connection handling
• Database interaction
Additional Elements
{
• "status": 200,
• "msg": "success",
• "data": [
• {
• "id": 1,
• "name": "Administrator",
• // ... other fields
• }
• ]
}
Important Notes
• Environment variables connection points
• TypeScript compilation process
• Error handling flow
• Main configuration files (tsconfig.json, .env)
Technical Stack Indicators
Technology badges or labels for:
• TypeScript
• Node.js
• Express.js
• PostgreSQL
• ODBC
• Docker