[$700] Finish Legacy Resource Processor Informix Updates

[rootelement]

• Address the scorecard concerns from this challenge: https://www.topcoder.com/challenges/30142136
• Create a pull request against Develop

[rootelement]

@gaoziqiang007 please address as much as you can without the updated db. If I can't get that for you by the time you're done this task, you'll still get the full amount and I'll test the actual dev db. Then I'll let you know if I run into any issues.

[gaoziqiang007]

@rootelement
From https://github.com/appirio-tech/ap-challenge-microservice/blob/dev/src/main/resources/sql/sequences/resource_sequence.sql and https://github.com/appirio-tech/ap-challenge-microservice/blob/dev/src/main/resources/sql/sequences/comp_inquiry_sequence.sql , there should exist SEQUENCE_COMPONENT_INQUIRY_SEQ.nextval and SEQUENCE_RESOURCE_ID_SEQ.nextval, but in the DB container, I didn't find them.

[gaoziqiang007]

From https://github.com/appirio-tech/ap-challenge-microservice/blob/dev/src/main/resources/sql/challenge/register/get_component_info.sql, there is 'AND pi79.project_info_type_id = 79', but in my test db, no record match this restriction.

[gaoziqiang007]

There are some forum operations, I write a ForumWrapper.js but I'm not cleear how to implement method 'removeRole', 'removeUserPermission', and 'deleteCategoryWatch', I find forums.jar in https://github.com/appirio-tech/forums-wrapper/tree/master/build/lib , but I can't find which tables are operated.

[gaoziqiang007]

sendEmailNotification() in RegistrationManager.java is not implemented now

[gaoziqiang007]

In class com.appirio.service.challenge.clients.GroupServiceClient, there is a getGroups method, and it looks like it will call other service to get groups information.

[gaoziqiang007]

@rootelement

I have created a PR: topcoder-platform/legacy-challenge-resource-processor#14
Please let me know if there is something wrong.

[rootelement]

Sorry, just got to my desk. Please disregard the forums stuff. This processor will not handle any forums work going forward.

I will review your PR and check.

[ThomasKranitsas]

New PR: topcoder-platform/legacy-challenge-resource-processor#15

[rootelement]

Contest https://www.topcoder.com/challenges/30143356 has been created for this ticket.

This is an automated message for jcori via Topcoder X

[rootelement]

Contest https://www.topcoder.com/challenges/30143356 has been updated - it has been assigned to gaoziqiang.

This is an automated message for jcori via Topcoder X

[rootelement]

Thanks for your work on this @gaoziqiang007 !

[rootelement]

Payment failed: [500]: Failed to get challenge details by Id

This is an automated message for jcori via Topcoder X

[rootelement]

Trying again... If it doesn't work, i'll pay by task.

[rootelement]

Payment task has been updated: https://software.topcoder.com/review/actions/ViewProjectDetails?pid=30143356

This is an automated message for jcori via Topcoder X