01: package de.webman.acl.db.queries.oracle;
02:
03: import java.sql.Connection;
04: import java.sql.*;
05: import com.teamkonzept.db.*;
06:
07: /**
08: * $Header: /cvsroot/webman-cms/source/webman/de/webman/acl/db/queries/oracle/PolicySelectByAtomicEventNullObject.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 PolicySelectByAtomicEventNullObject extends TKPrepQuery {
15:
16: // Constants
17:
18: public static final String[] ORDER = { "WM_USER_ID",
19: "WM_CONTEXT_ID", "WM_EVENT_ID" };
20:
21: public static final Object[][] TYPES = {
22: { "WM_USER_ID", new Integer(Types.INTEGER) },
23: { "WM_CONTEXT_ID", new Integer(Types.INTEGER) },
24: { "WM_EVENT_ID", new Integer(Types.INTEGER) } };
25:
26: public static final boolean[] RELEVANTS = { true };
27:
28: public static final String SQL = (new StringBuffer())
29: .append("SELECT DISTINCT WM_POLICY.WM_POLICY_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(
36: " WM_POLICY.OBJECT_REFERENCE "
37: + DBStringFactory.equalsNull() + " AND ")
38: .append(
39: " WM_POLICY.OBJECT_TYPE "
40: + DBStringFactory.equalsNull() + " 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: }
|