✅ Blue Onion Labs Take Home Assignment

Features

• Extract data from a CSV file stored locally (not a Cloud Storage ATM)
• Look up journal entries by specifying the month and year
• Refresh functionality to re-fetch data in case of errors
• Export results as CSV or Excel files

Technologies

Backend

• Ruby v3.3.7 – Core programming language (Documentation)
• Rails v8.0.1 – Web application framework (Documentation)
• PostgreSQL – Relational database management system (Documentation)
• Docker – Containerization for consistent development and deployment (Documentation)
• RSpec – Testing framework (Documentation)

Frontend

• TypeScript v4.9.5 – Type-safe JavaScript alternative (Documentation)
• React v19 – JavaScript library for building user interfaces (Documentation)
• Material UI – UI components for a modern design system (Documentation)
• ESLint – Linting tool for maintaining code quality (Documentation)
• Prettier – Code formatter for consistent style (Documentation)

Setup and Installation

Environment Variables

Before running the application, set up the following environment variables for both the backend and frontend:

Backend Environment

Create a .env file and add the following variables:

RAILS_MAX_THREADS=5
CORS_ORIGIN=http://localhost:4000

# PostgreSQL
POSTGRES_HOST=localhost
POSTGRES_DB_DEV=blue_onion_labs
POSTGRES_DB_TEST=blue_onion_labs
POSTGRES_DB_PROD=blue_onion_labs
POSTGRES_USERNAME=postgres
POSTGRES_PASSWORD=12345678

⚠️ Note: Update these variables based on your environment settings.

Frontend Environment

Create a .env file and add the following variable:

PORT=4000

Running the Application

1. Start the Backend (Rails API)

Run the following command to build and start the Rails server:

sh backend-buildRun.sh

If the backend has already been built, use:

sh backend-run.sh

2. Start the Frontend (React App)

Run the following command to build and start the frontend:

sh frontend-buildRun.sh

If the frontend has already been built, use:

sh frontend-run.sh

3. Access the Web App

You will see the web page running on localhost:4000 and there we go! 🥳