Challenge Objectives

• Fix existing issues and improve the provided legacy challenge migration script.

 

Tech Stack

• Node.js

• Swagger

• DynamoDB

• ElasticSearch

 

Project Background

In this series of challenges, we will build a migration script that will help us migrate all existing data from the legacy challenge API into our new DB so the new V5 API can consume.

 

Code Access

The existing code for the migration script will be attached to the challenge forum.
 

The services below are provided for reference and for your local set up.

Challenge API

Repo: https://github.com/topcoder-platform/challenge-api 

Branch: develop

Resources API

Repo: https://github.com/topcoder-platform/resources-api

Branch: develop

Legacy Challenge API

Repo: https://github.com/appirio-tech/ap-challenge-microservice

Branch: develop

 

Detailed requirements

As part of this challenge, we need your help to update our existing migration script. You need to make the following changes:

• Update the migration script to include the challenge resources.
• Resource should be a new table in DynamoDB. Data will come from the resource informix table.
• ResourceRole table should also be created with lookup values. The following roles should be added:
  • Submitter
  • Reviewer
  • Copilot
  • Manager
  • Observer
  • Iterative Reviewer
• The ResourceRole data should be loaded only once. So the script should check if the record exists and only insert when it doesn't.
• The DynamoDB tables schema will be provided in the forum.

 

Should you have any questions, feel free to ask on the challenge forum!
 

What to Submit

Submit a zip file containing the updated migration script.

Final Submission Guidelines

• See above