TCS Loader - iOS Badges Load

Challenge Requirements

The task here is to update existing Java process to update user_achievement_rule and user_achievement_xref 

tables along with required SQL files for iOS badges. Please see the Java file

https://coder.topcoder.com/internal/web_module/trunk/src/main/com/topcoder/utilities/MemberAchievementUtility.java

As you can notice in the Javafile, the process does the following:

1) runUtility() which is the start point calls loadAchievementRules() functions, which creates a map indexed

by rule IDs containing all achievement SQLs and DB schemas.

2) Ater the map is created, for each rules entry in the map, we call filterUser function returns set of users that are qualified for the achievement rule. 

The table user_achievement_rule is read here.

3) Finally the achievement records are added into user_achievement_xref table.

The task here is to come up with new records in user_achievement_rule for iOS badges similar to that of the rules for other badges.

Using these rules (which point to set of SQL files), we need to finally assign the achievement records.

Code Base

• dwload: https://coder.topcoder.com/internal/web_module/trunk/src/main/com/topcoder/utilities/dwload/
• TCLoadTCS Loader: https://coder.topcoder.com/internal/web_module/trunk/src/main/com/topcoder/utilities/dwload/TCLoadTCS.java
• TopCoder Database Schema: https://coder.topcoder.com/internal/database/scripts/trunk 

Please send email to support@topcoder.com with challenge name / ID, your topcoder handle and the SVN addresses you want to access to request READ-only SVN access. The topcoder support team will read the emails and grant you access.

Testing

• Use the ant build file build_data_loader.xml to perform build, distibution and loader run tasks. You can read the build_data_load.xml to see how to use it.
• Setup the database in local - follow http://apps.topcoder.com/wiki/display/docs/TopCoder+Databases+Setup+Guide
• You need to prepare the test data for the load. After inserting the test data, run the corresponding loader to load OLTP data into DW to test. In this challenge, you will specifically make sure the test data contain iOS badges when you test.

Technologies

• Java
• SQL
• Informix 11

Final Submission Guidelines

• The updated source codes and configurations (if there is any config update)
• The deployment guide with verification details.