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/PolicySelectByAtomicEventObject.java,v 1.1 2001/08/20 08:25:09 mischa Exp $
09: *
10: * is identical to com.teamkonzept.webman.accesscontrol.db.queries.PolicySelectByAtomicEvent
11: * @version 0.10
12: * @since 0.10
13: * @author © 2000 Team-Konzept
14: */
15: public class PolicySelectByAtomicEventObject extends TKPrepQuery {
16:
17: // Constants
18:
19: public static final String[] ORDER = { "WM_USER_ID",
20: "WM_CONTEXT_ID", "OBJECT_REFERENCE", "OBJECT_TYPE",
21: "WM_EVENT_ID" };
22:
23: public static final Object[][] TYPES = {
24: { "WM_USER_ID", new Integer(Types.INTEGER) },
25: { "WM_CONTEXT_ID", new Integer(Types.INTEGER) },
26: { "OBJECT_REFERENCE", new Integer(Types.INTEGER) },
27: { "OBJECT_TYPE", new Integer(Types.INTEGER) },
28: { "WM_EVENT_ID", new Integer(Types.INTEGER) } };
29:
30: public static final boolean[] RELEVANTS = { true };
31:
32: public static final String SQL = (new StringBuffer())
33: .append("SELECT DISTINCT WM_POLICY.WM_POLICY_ID ")
34: .append(
35: "FROM WM_POLICY, WM_ROLE_TASK, WM_TASK, WM_TASK_ACTION, WM_ACTION_EVENT ")
36: .append("WHERE ")
37: .append(" WM_POLICY.WM_USER_ID = ? AND ")
38: .append(" WM_POLICY.WM_CONTEXT_ID = ? AND ")
39: .append(" WM_POLICY.OBJECT_REFERENCE = ? AND ")
40: .append(" WM_POLICY.OBJECT_TYPE = ? 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 AND ")
51: .append(" WM_ACTION_EVENT.WM_EVENT_ID = ? ").toString();
52:
53: // Method implementations
54:
55: public void initQuery(Connection connection) {
56: super .initQuery(connection, true, ORDER, TYPES, RELEVANTS, SQL);
57: }
58:
59: }
|