Challenge

Thanks for applying for the Technical Support role at Outdoorsy. We've put together this challenge, which should take around 1-2 hours to complete.

Overview

This repository contains database file (sql) and application code that should be used to work through the assignment. Below you will find several questions that are issues that have been escalated. We'd like you to review each question and find a solution or next steps to the problem.

Question 1

The user, John Smith, called into support and reported that one of his listings in Portland does not show up in search results when searching in the area. The customer has 6 listings total (3 in California, 2 in Oregon and 1 in Washington). He says that the information for city and state look correct on the website but the vehicle continues to not appear when he tries to do a search for it.

When searching for vehicles the client makes a request to the rentals API (/rentals) with a near query param of the location.

Using the data provided and the application code, can you help us understand why the vehicle is not showing properly? What are the next steps?

NOTE: The rentals table contains the city, state and country.

Question 2

User, Tom Edision, has written into support asking why the weekly price on one of his vehicles (Ford Transit Campervan) is lower than he expects. He says he hasn't applied any discounts and his daily price is set to $239 and his weekly price is showing as $1,505.70. He expects his weekly price to be his daily price x 7 days which would be $1,673.

   {
      "id": 14,
      "name": "Ford Transit Campervan",
      "price": {
        "day": 23900,
        "week": 150570
      },
      "location": {
        "lat": 51.15,
        "lng": -113.98,
        "city": "Calgary",
        "state": "AB",
        "zip": "T3N 1N8",
        "country": "CA"
      },
      "owner_id": 4,
      "primary_image": "https://res.cloudinary.com/outdoorsy/image/upload/v1554872873/p/rentals/115462/images/qnsbiznxh9hxttrlmwuq.jpg"
    }

Using the application code and the data set provided, can you look into why his daily price wouldn't be set correctly? What are the next steps?

NOTE: The amount for price that is stored in the database is in cents.

Question 3

In the sql provided, you will see we have a bookings table and a transactions table. The transactions table holds both credit card charges to the customer (renter) and payouts to the host (owner of the vehicle). The booking status lifecycle goes from draft -> approved -> departed -> returned.

A charge will occur once the booking has been approved. So, for every booking that has been approved, departed or returned should have at least one associated charge. A charge in the transactions table will have type charge.

A payout will occur once the booking has departed. So, for every booking that has been departed or returned should have at least one associated payout. A payout in the transactions table will have type payout.

We had a host (owner of the vehicle) call in regarding a booking they said they were not paid for. The booking ID that is problematic is ID: 2.

Can you confirm that we did not issue a payout to this user? If we did not issue a payout for this booking, can we investigate if this issue has happened on other bookings? What are the next steps?

Bonus

For every booking, we store the total in the bookings table for the total cost of the booking. The collected charge amounts for the associated booking are stored in the transactions table. The charges have type charge in the transactions table.

Can you write a query to review the bookings that have charges and ensure that we have not overcharged any customers? If we have overcharged customers, what are the next steps?

Notes

• You will not need to run the project but if you'd like there are instructions found below.
• You can write queries easily using this DBFiddle - https://www.db-fiddle.com/f/mXKjSo1dUsfbDr9p1prG2g/0

What we're looking for

• An ability to dig into a problem and find a resolution.
• An ability to communicate what the problem was.
• An ability to describe what next steps would be.

Instructions to run project

• Prerequisites: You will need Docker and Go installed.
• Run docker compose up.
  • This will automatically generate a postgres database and some data to work with.
• Run go mod vendor
• Run go run ./main.go
• Visit http://127.0.0.1:3000/rentals

When complete, please send the answers and responses back for each question.

Thank you and please ask if you have any questions!