1 package de.webman.acl.db.queries.oracle; 2 3 import java.sql.Connection ; 4 import java.sql.Types ; 5 import com.teamkonzept.db.TKPrepQuery; 6 7 14 public class EventSelectByGlobalPolicy 15 extends TKPrepQuery 16 { 17 18 20 public static final String [] ORDER = 21 { 22 "WM_USER_ID", 23 "WM_CONTEXT_ID", 24 "POLICY_ACCESS" 25 }; 26 27 public static final Object [][] TYPES = 28 { 29 {"WM_USER_ID", new Integer (Types.INTEGER)}, 30 {"WM_CONTEXT_ID", new Integer (Types.INTEGER)}, 31 {"POLICY_ACCESS", new Integer (Types.CHAR)} 32 }; 33 34 public static final boolean[] RELEVANTS = 35 { 36 true 37 }; 38 39 public static final String SQL = (new StringBuffer ()).append("SELECT DISTINCT WM_ACTION_EVENT.WM_EVENT_ID ") 40 .append("FROM WM_POLICY, WM_ROLE_TASK, WM_TASK, WM_TASK_ACTION, WM_ACTION_EVENT ") 41 .append("WHERE ") 42 .append(" WM_POLICY.WM_USER_ID = ? AND ") 43 .append(" WM_POLICY.WM_CONTEXT_ID = ? AND ") 44 .append(" WM_POLICY.OBJECT_REFERENCE IS NULL AND ") 45 .append(" WM_POLICY.OBJECT_TYPE IS NULL AND ") 46 .append(" WM_POLICY.POLICY_ACCESS = ? AND ") 47 .append(" WM_POLICY.WM_ROLE_ID = WM_ROLE_TASK.WM_ROLE_ID AND ") 48 .append(" WM_ROLE_TASK.WM_TASK_ID = WM_TASK.WM_TASK_ID AND ") 49 .append(" WM_TASK.WM_CONTEXT_ID = WM_POLICY.WM_CONTEXT_ID AND ") 50 .append(" WM_TASK.WM_TASK_ID = WM_TASK_ACTION.WM_TASK_ID AND ") 51 .append(" WM_TASK_ACTION.WM_ACTION_ID = WM_ACTION_EVENT.WM_ACTION_ID") 52 .toString(); 53 54 55 57 public void initQuery (Connection connection) 58 { 59 super.initQuery(connection, 60 true, 61 ORDER, 62 TYPES, 63 RELEVANTS, 64 SQL); 65 } 66 67 } 68 | Popular Tags |