Task #3783

User Linking: webservice client

Added by Anonymous almost 11 years ago. Updated about 10 years ago.

Status:Closed - End of life cycleStart date:October 16, 2013
Priority:NormalDue date:October 23, 2013
Assignee:-% Done:

0%

Category:-Spent time:-
Target version:-

History

#1 Updated by Anonymous almost 11 years ago

  • Due date set to October 23, 2013
  • Assignee set to Anwar Khairul

to work with Boby on task 3539 and call the api for task 3539.

#2 Updated by Anwar Khairul almost 11 years ago

  • Status changed from New - Begin Life Cycle to Development / Work In Progress
  • % Done changed from 0 to 80

Completed:
1. Add web service client project, rcasws-client. This web service client configuration is configurable at upass.cfg. Basically, global site web service client should have BII web service connection configuration and vice versa.

2. Add new JPA entity model, UserGlobalEntity which maps to TB_AM_USER_GLOBAL table. Script table:

CREATE TABLE "RCAS_APP"."TB_AM_USER_GLOBAL"
(
G_ID decimal(20, 0) PRIMARY KEY NOT NULL,
G_GLOBAL_ID varchar2(40),
G_USER_ID varchar2(40),
G_COMPANY_ID varchar2(40),
G_STATUS varchar2(20),
G_ROLE varchar2(20),
G_CREATION_DATE timestamp,
G_CREATED_AT varchar2(20),
G_PROVIDER varchar2(64),
G_TOKEN varchar2(20),
G_USER_SYNC varchar2(1),
G_PRIVATE_KEY blob,
G_SHARED_KEY blob
)
;

3. Add methods at GlobalUserService.class, verifyRemoteUserAccess(), generateRemoteStaticPassword(), changeRemotePassword(). These method use for login purpose on remote site.

Incomplete
1. Add method syncRegisteredRemoteUser(). This method will be call by scheduler to run batch user linking. The method will get from DB for which local user that haven't sync before and send the list to remote web service. The remote web service then will update the remote DB and pass back the response with user list details. This method than will update the local DB according to web service response. Currently pending boby to provide wsdl file with method to update remote DB.

#3 Updated by Anwar Khairul almost 11 years ago

  • Assignee changed from Anwar Khairul to Yap Kah Yan
  • % Done changed from 80 to 100

1. syncRegisteredRemoteUser() is complete. This method will be called by scheduler. Once called, it will check TB_AM_USER_GLOBAL table and get whichever user that was created in local instance and that was not yet sync (status G_USER_SYNC == 1). List of user will be pass to remote web service using wsStoreUserLinking method and receive the response of global id and response code. The method then will update local db according to the response and set the G_USER_SYNC to 0.

2. syncCreateRemoteUser(UserGlobalList userGlobalList) is complete. This method will be called by web service (wsStoreUserLinking). Once called, it will update the remote db with data sent by syncRegisteredRemoteUser().

Web Service Testing:
1. wsCreateUserLinking - Tested partially working. Just the missing data on STATUS and USER_SYNC STATUS. Boby already informed to fix on this.

2. wsRemoveUserLinking - Tested working

3. wsEditUserLinking - Tested partially working. Error when STATUS content is in capital letter. Boby already informed to fix on this.

4. wsStoreUserLinking - Tested working for data by wsCreateUserLinking. Need to test on data that created by wsRemoveUserLinking and wsEditUserLinking

#4 Updated by Yap Kah Yan almost 11 years ago

  • Status changed from Development / Work In Progress to Finished Development

Checked code. Completed by Boby.

#5 Updated by Yap Kah Yan almost 11 years ago

  • Status changed from Finished Development to Internal Testing
  • % Done changed from 100 to 0

#6 Updated by Yap Kah Yan over 10 years ago

  • Status changed from Internal Testing to Pending UAT Deployment

#7 Updated by Yap Kah Yan about 10 years ago

  • Assignee changed from Yap Kah Yan to Anonymous

Already deployed to production. Please close this issue.

#8 Updated by Anonymous about 10 years ago

  • Status changed from Pending UAT Deployment to Closed - End of life cycle

Also available in: Atom PDF