-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/75238/
-----------------------------------------------------------

Review request for ranger, Dineshkumar Yadav, Kishor Gollapalliwar, Abhay 
Kulkarni, Madhan Neethiraj, Mehul Parikh, Pradeep Agrawal, Ramesh Mani, sanket 
shelar, Sailaja Polavarapu, and Velmurugan Periasamy.


Bugs: RANGER-4692
    https://issues.apache.org/jira/browse/RANGER-4692


Repository: ranger


Description
-------

Currently there are different type like (Policy, Role, Tag, UserStore and GDS) 
on plugin status.

when we have plugins(large enough to accommodate in single page), It will be 
helpful to identify any out-of-sync plugins based on download times, sorting 
them by policyDownloadTime, tagDownloadTime, roleDownloadTime, 
userstoreDownloadTime and gdsDownloadTime.


Diffs
-----

  
agents-common/src/main/java/org/apache/ranger/plugin/model/RangerPluginInfo.java
 8d46b99f7 
  security-admin/db/mysql/optimized/current/ranger_core_db_mysql.sql 6c48c49f4 
  security-admin/db/mysql/patches/075-add-columns-in-x_plugin_info.sql 
PRE-CREATION 
  security-admin/db/oracle/optimized/current/ranger_core_db_oracle.sql 
551660ab4 
  security-admin/db/oracle/patches/069-add-columns-in-x_plugin_info.sql 
PRE-CREATION 
  security-admin/db/postgres/optimized/current/ranger_core_db_postgres.sql 
34a092e89 
  security-admin/db/postgres/patches/075-add-columns-in-x_plugin_info.sql 
PRE-CREATION 
  
security-admin/db/sqlanywhere/optimized/current/ranger_core_db_sqlanywhere.sql 
792fffd8d 
  security-admin/db/sqlanywhere/patches/069-add-columns-in-x_plugin_info.sql 
PRE-CREATION 
  security-admin/db/sqlserver/optimized/current/ranger_core_db_sqlserver.sql 
eccf7f46f 
  security-admin/db/sqlserver/patches/069-add-columns-in-x_plugin_info.sql 
PRE-CREATION 
  security-admin/src/main/java/org/apache/ranger/biz/AssetMgr.java 00062f3e2 
  security-admin/src/main/java/org/apache/ranger/entity/XXPluginInfo.java 
a15d8d056 
  security-admin/src/main/java/org/apache/ranger/entity/view/VXXPluginInfo.java 
PRE-CREATION 
  
security-admin/src/main/java/org/apache/ranger/patch/PatchForPluginStatusEventSorting_J10064.java
 PRE-CREATION 
  
security-admin/src/main/java/org/apache/ranger/service/RangerPluginInfoService.java
 9dc26ceb7 


Diff: https://reviews.apache.org/r/75238/diff/1/


Testing
-------

Tested and verified that the plugins are correctly sorted by event type 
(Policy, Role, Tag, UserStore, GDS) using the following APIs:

/service/plugins/info?sortType=desc&sortBy=policyDownloadTime
/service/plugins/info?sortType=desc&sortBy=policyActivationTime
/service/plugins/info?sortType=desc&sortBy=lastPolicyUpdateTime
/service/plugins/info?sortType=desc&sortBy=tagDownloadTime
/service/plugins/info?sortType=desc&sortBy=tagActivationTime
/service/plugins/info?sortType=desc&sortBy=lasttagUpdateTime
/service/plugins/info?sortType=desc&sortBy=gdsDownloadTime
/service/plugins/info?sortType=desc&sortBy=gdsActivationTime
/service/plugins/info?sortType=desc&sortBy=lastgdsUpdateTime
/service/plugins/info?sortType=desc&sortBy=roleDownloadTime
/service/plugins/info?sortType=desc&sortBy=roleActivationTime
/service/plugins/info?sortType=desc&sortBy=lastroleUpdateTime
/service/plugins/info?sortType=desc&sortBy=userstoreDownloadTime
/service/plugins/info?sortType=desc&sortBy=userstoreActivationTime
/service/plugins/info?sortType=desc&sortBy=clusterName
/service/plugins/info?sortType=desc&sortBy=serviceType

Also tested filtering by:
/service/plugins/info?serviceType={serviceTypeName}
/service/plugins/info?clusterName={clusterName}


Thanks,

Rakesh Gupta

Reply via email to