Live API URL

Follow the below process to setup locally:

1. Run npm i to install all the required packages.
2. Create .env file and initialize DATABASE_URL and declare its value.

  DATABASE_URL= Your PostreSQL database (Get a free one either from Supabase, Render, Vercel, etc.)

3. Run these following commands in the terminal

• npx prisma generate This auto-generates database client into the node_modules/.prisma/client folder. (Optional)
• npx prisma db push This executes the changes required to make our database schema reflect the state of our Prisma schema.
• npx prisma db seed This adds our custom row datas into the Organization, Item and Pricing tables.

4. Now since everything is setup, we can finally run npm run dev command in terminal to start the development server locally.

Send POST request on the https://localhost:5000/api/calculate-price route with JSON content:

• perishable food item

  {
    "zone": "central",
    "organization_id": "005",
    "total_distance": 12,
    "item_type": "perishable"
  }
  

  to get the response with status code 200

  {
    "success": true,
    "total_price": 20.5
  }
  

• non-perishable food item

  {
    "zone": "north",
    "organization_id": "004",
    "total_distance": 4,
    "item_type": "non-perishable"
  }
  

  to get the response with status code 200

  {
    "success": true,
    "total_price": 10
  }
  

Created price.test.js inside test directory. Run npm test in terminal to check if the test passed or not. List of total 10 test cases:

1. Return an error for missing required fields;
2. Return an error for incorrect zone;
3. Return an error for invalid organization_id;
4. Return an error for incorrect total_distance;
5. Return an error for invalid item_type;
6. Calculate total_price for perishable items within base distance;
7. Calculate total_price for non-perishable items within base distance;
8. Calculate total_price for perishable items beyond base distance;
9. Calculate total_price for non-perishable items beyond base distance.
10. Return an error for no pricing found for given parameters

{
  "zone": "central",
  "organization_id": "005",
  "total_distance": 12,
  "item_type": "non-perishable" // should have been "perishable"
}

1. Organization

2. Item

3. Pricing

Database schema design View here

Calculate price controller View here