01: package de.webman.acl.db.queries.oracle;
02:
03: import java.sql.Connection;
04: import java.sql.Types;
05: import com.teamkonzept.db.TKPrepQuery;
06:
07: /**
08: * $Header: /cvsroot/webman-cms/source/webman/de/webman/acl/db/queries/oracle/EventSelectByGlobalPolicy.java,v 1.1 2001/08/20 08:25:09 mischa Exp $
09: *
10: * @version 0.10
11: * @since 0.10
12: * @author © 2000 Team-Konzept
13: */
14: public class EventSelectByGlobalPolicy extends TKPrepQuery {
15:
16: // Constants
17:
18: public static final String[] ORDER = { "WM_USER_ID",
19: "WM_CONTEXT_ID", "POLICY_ACCESS" };
20:
21: public static final Object[][] TYPES = {
22: { "WM_USER_ID", new Integer(Types.INTEGER) },
23: { "WM_CONTEXT_ID", new Integer(Types.INTEGER) },
24: { "POLICY_ACCESS", new Integer(Types.CHAR) } };
25:
26: public static final boolean[] RELEVANTS = { true };
27:
28: public static final String SQL = (new StringBuffer())
29: .append("SELECT DISTINCT WM_ACTION_EVENT.WM_EVENT_ID ")
30: .append(
31: "FROM WM_POLICY, WM_ROLE_TASK, WM_TASK, WM_TASK_ACTION, WM_ACTION_EVENT ")
32: .append("WHERE ")
33: .append(" WM_POLICY.WM_USER_ID = ? AND ")
34: .append(" WM_POLICY.WM_CONTEXT_ID = ? AND ")
35: .append(" WM_POLICY.OBJECT_REFERENCE IS NULL AND ")
36: .append(" WM_POLICY.OBJECT_TYPE IS NULL AND ")
37: .append(" WM_POLICY.POLICY_ACCESS = ? AND ")
38: .append(
39: " WM_POLICY.WM_ROLE_ID = WM_ROLE_TASK.WM_ROLE_ID AND ")
40: .append(
41: " WM_ROLE_TASK.WM_TASK_ID = WM_TASK.WM_TASK_ID AND ")
42: .append(
43: " WM_TASK.WM_CONTEXT_ID = WM_POLICY.WM_CONTEXT_ID AND ")
44: .append(
45: " WM_TASK.WM_TASK_ID = WM_TASK_ACTION.WM_TASK_ID AND ")
46: .append(
47: " WM_TASK_ACTION.WM_ACTION_ID = WM_ACTION_EVENT.WM_ACTION_ID")
48: .toString();
49:
50: // Method implementations
51:
52: public void initQuery(Connection connection) {
53: super .initQuery(connection, true, ORDER, TYPES, RELEVANTS, SQL);
54: }
55:
56: }
|