/aspaara-backend-coding-challenge

Primary LanguagePython

Backend Coding Challenge

At aspaara a squad of superheroes works on giving superpowers to planning teams. Through our product dashboard, we give insights into data – a true super-vision superpower. Join forces with us and build a dashboard of the future!

How to run

Run all commands from the root directory of the project

Create a virtual environment and activate it

python3 -m venv venv
source venv/bin/activate

Install project dependencies

pip install -r requirements/local.txt

Create database tables and import provided data

This is a destructive action and any previous data will be lost.

make init

Start the project

make start

aspaara superhero

Goal

Create a simple backend application that provides an API for a dashboard which allows a planner to get insights into client and planning information.

You will find the corresponding data that needs to be imported into the database in planning.json, which contains around 10k records.

Requirements

  1. Create proper database tables that can fit the data model.
  2. Create a script that imports the data into the database (sqlite).
  3. Create REST APIs to get the planning data from the database.
    1. The APIs don't need to be complete, just create what you can in the available time.
    2. Please include at least one example on how to do each of the following:
      1. pagination
      2. sorting
      3. filtering / searching

Data Model

  • ID: integer (unique, required)
  • Original ID: string (unique, required)
  • Talent ID: string (optional)
  • Talent Name: string (optional)
  • Talent Grade: string (optional)
  • Booking Grade: string (optional)
  • Operating Unit: string (required)
  • Office City: string (optional)
  • Office Postal Code: string (required)
  • Job Manager Name: string (optional)
  • Job Manager ID: string (optional)
  • Total Hours: float (required)
  • Start Date: datetime (required)
  • End Date: datetime (required)
  • Client Name: string (optional)
  • Client ID: string (required)
  • Industry: string (optional)
  • Required Skills: array of key-value pair (optional)
  • Optional Skills: array of key-value pair (optional)
  • Is Unassigned: boolean

Preferred Tech Stack

  • Python 3.8+
  • FastAPI
  • SQLAlchemy

Submission

  • Please fork the project, commit and push your implementation and add sundara.amancharla@aspaara.com as a contributor.
  • Please update the README with any additional details or steps that are required to run your implementation.
  • We understand that there is a limited amount of time, so it does not have to be perfect or 100% finished. Plan to spend no more than 2-3 hours on it.

For any additional questions on the task please feel free to email sundara.amancharla@aspaara.com.