/test_resadme

DWELLFI-ASSIGNMENT-logo

DWELLFI-ASSIGNMENT

Built with the tools and technologies:

Python Docker FastAPI


Table of Contents

Overview

This FastAPI application provides a RESTful API with various endpoints for performing database operations, health checks, and versioning. The application includes CORS middleware for handling cross-origin requests and uses API key-based authentication for security.

Features

  • FastAPI Based Authentication
  • Docker Image support

Repository Structure

└── Dwellfi-assignment/
    ├── Dockerfile
    ├── README.md
    ├── app
    │   ├── __init__.py
    │   ├── classes
    │   └── main.py
    └── requirements.txt

Getting Started

Prerequisites

Python: version 3.10.12

Installation

Build the project from source:

  1. Clone the Dwellfi-assignment repository:
❯ git clone https://github.com/mohit-217/Dwellfi-assignment
  1. Navigate to the project directory:
❯ cd Dwellfi-assignment

3.1 Install the required dependencies:

❯ pip install -r requirements.txt

3.2 Or build the docker image :

❯ docker image build -t dwellfi-app .

Environment Variables

Set the following environment variables before running the application:

  1. OPENAI_API_KEY: OpenAI API key (e.g., sk-XXXXXXXXXXXXXXXXXXXXXX)
  2. DB_Connection_url: Database connection URL (e.g., postgresql://user:password@localhost:5432/mydatabase)
  3. Dwellfi_key: Custom key for Dwellfi authentication (e.g., your_dwellfi_key_here)
  4. API_KEY: API key for authenticating requests (e.g., your_api_key_here)

Usage

To run the project using uvicorn change .classes to classes and run below command:

❯ uvicorn main:app

To run the project using Docker Run the below command

❯ docker container run --publish 8080:8080 --name dwellfi-app-container dwellfi-app

API Endpoints

1. Root Endpoint

  • Endpoint: /
  • Method: GET
  • Parameters:
    • api_key (string): The API key provided in the request header for authentication.
  • Description: Returns a welcome message if the provided API key is valid.
  • Response:
    • Success: Returns a JSON response with a welcome message. 
      {
  "message": "Welcome!"
}
    • Error: Returns an error message with status code 403 if the API key is invalid.

2. Health Check

  • Endpoint: /health
  • Method: GET
  • Parameters:
    • api_key (string): The API key provided in the request header for authentication.
  • Description: Returns the health status of the API.
  • Response:
    • Success: Returns a JSON response with the health status. 
      {
  "status": "healthy"
}
    • Error: Returns an error message with status code 403 if the API key is invalid.

3. Version

  • Endpoint: /version
  • Method: GET
  • Parameters:
    • api_key (string): The API key provided in the request header for authentication.
  • Description: Returns the current version of the API.
  • Response:
    • Success: Returns a JSON response with the API version. 
      {
  "version": "1.0.0"
}
    • Error: Returns an error message with status code 403 if the API key is invalid.

4. Perform Database Operation

  • Endpoint: /perform_db_operation
  • Method: POST
  • Parameters:
    • user_query (string, form data): The user query to be executed on the database.
    • api_key (string): The API key provided in the request header for authentication.
  • Description: Executes a database operation based on the provided user query.
  • Response:
    • Success: Returns the result of the database operation.(Read,Delete,Update or Insert record)
    • Error: "Error Encounterd View stacktrace for detailed Explanation

5. Check Latest Database Table Record

  • Endpoint: /check_database_table
  • Method: POST
  • Parameters:
    • api_key (string): The API key provided in the request header for authentication.
  • Description: Retrieves the latest record from the database table.
  • Response:
    • Success: Returns a JSON response with the latest record from the database.
    • Error: Error Encounterd View stacktrace for detailed Explanation