Overview

This project is a Node.js application that connects to a PostgreSQL database using Sequelize ORM. It provides APIs for user management, including fetching user details, updating user balance, and resetting user balance. The application is designed for high performance and reliability, employing transactions and error handling to ensure data integrity. Additionally, the application uses Sequelize to perform database migrations and manage concurrency in database operations, ensuring consistent and efficient data access in a concurrent environment.

Features

• Fetch all users
• Update user balance with atomic transactions
• Reset user balance to a default value
• Error handling middleware for graceful error responses

Installation

1. Clone the repository:

   git clone https://github.com/yourusername/your-repo.git
   cd your-repo

2. Install dependencies:

   npm install

3. Create a .env file:

   DIALECT=postgres
   DB_HOST=**************
   DB_PORT=5432
   DB_USERNAME=**************
   DB_PASSWORD=**************
   DB_NAME=**************

4. Start the application:

   npm start

Usage

Fetch All Users

• Endpoint: /users
• Method: GET

Update User Balance

• Endpoint: /users/:userId/balance
• Method: PUT
• Body Parameters:
  • amount (number) - The amount to be added to the user's balance

Reset User Balance

• Endpoint: /reset
• Method: GET