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/EventSelectByLocalPolicy.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 EventSelectByLocalPolicy extends TKPrepQuery {
15:
16: // Constants
17:
18: public static final String[] ORDER = { "WM_USER_ID",
19: "WM_CONTEXT_ID", OBJECT_REFERENCE, OBJECT_TYPE,
20: "POLICY_ACCESS" };
21:
22: public static final Object[][] TYPES = {
23: { "WM_USER_ID", new Integer(Types.INTEGER) },
24: { "WM_CONTEXT_ID", new Integer(Types.INTEGER) },
25: { "OBJECT_REFERENCE", new Integer(Types.INTEGER) },
26: { "OBJECT_TYPE", new Integer(Types.INTEGER) },
27: { "POLICY_ACCESS", new Integer(Types.CHAR) } };
28:
29: public static final boolean[] RELEVANTS = { true };
30:
31: public static final String SQL = (new StringBuffer())
32: .append("SELECT DISTINCT WM_ACTION_EVENT.WM_EVENT_ID ")
33: .append(
34: "FROM WM_POLICY, WM_ROLE_TASK, WM_TASK, WM_TASK_ACTION, WM_ACTION_EVENT ")
35: .append("WHERE ")
36: .append(" WM_POLICY.WM_USER_ID = ? AND ")
37: .append(" WM_POLICY.WM_CONTEXT_ID = ? AND ")
38: .append(" WM_POLICY.OBJECT_REFERENCE = ? AND ")
39: .append(" WM_POLICY.OBJECT_TYPE = ? AND ")
40: .append(" WM_POLICY.POLICY_ACCESS = ? AND ")
41: .append(
42: " WM_POLICY.WM_ROLE_ID = WM_ROLE_TASK.WM_ROLE_ID AND ")
43: .append(
44: " WM_ROLE_TASK.WM_TASK_ID = WM_TASK.WM_TASK_ID AND ")
45: .append(
46: " WM_TASK.WM_CONTEXT_ID = WM_POLICY.WM_CONTEXT_ID AND ")
47: .append(
48: " WM_TASK.WM_TASK_ID = WM_TASK_ACTION.WM_TASK_ID AND ")
49: .append(
50: " WM_TASK_ACTION.WM_ACTION_ID = WM_ACTION_EVENT.WM_ACTION_ID")
51: .toString();
52:
53: // Method implementations
54:
55: public void initQuery(Connection connection) {
56: super .initQuery(connection, true, ORDER, TYPES, RELEVANTS, SQL);
57: }
58:
59: }
|