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

(Updated Nov. 4, 2024, 12:31 p.m.)


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 (updated)
-----

  
agents-common/src/main/java/org/apache/ranger/plugin/model/RangerPluginInfo.java
 8d46b99f7 
  security-admin/db/mysql/optimized/current/ranger_core_db_mysql.sql 5fb0d95db 
  security-admin/db/mysql/patches/076-add-columns-in-x_plugin_info.sql 
PRE-CREATION 
  security-admin/db/oracle/optimized/current/ranger_core_db_oracle.sql 
593cffe56 
  security-admin/db/oracle/patches/076-add-columns-in-x_plugin_info.sql 
PRE-CREATION 
  security-admin/db/postgres/optimized/current/ranger_core_db_postgres.sql 
16263a2d7 
  security-admin/db/postgres/patches/076-add-columns-in-x_plugin_info.sql 
PRE-CREATION 
  
security-admin/db/sqlanywhere/optimized/current/ranger_core_db_sqlanywhere.sql 
fa9832314 
  security-admin/db/sqlanywhere/patches/076-add-columns-in-x_plugin_info.sql 
PRE-CREATION 
  security-admin/db/sqlserver/optimized/current/ranger_core_db_sqlserver.sql 
a0e47004b 
  security-admin/db/sqlserver/patches/076-add-columns-in-x_plugin_info.sql 
PRE-CREATION 
  security-admin/src/main/java/org/apache/ranger/biz/AssetMgr.java 620d1e619 
  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/2/

Changes: https://reviews.apache.org/r/75238/diff/1-2/


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