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/Attic/PolicySelectByContentTree.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 PolicySelectByContentTree extends TKPrepQuery {
15:
16: // Constants
17:
18: public static final String[] ORDER = { "OBJECT_REFERENCE",
19: "WM_USER_ID", "WM_CONTEXT_ID", "OBJECT_TYPE" };
20:
21: public static final Object[][] TYPES = {
22: { "OBJECT_REFERENCE", new Integer(Types.INTEGER) },
23: { "WM_USER_ID", new Integer(Types.INTEGER) },
24: { "WM_CONTEXT_ID", new Integer(Types.INTEGER) },
25: { "OBJECT_TYPE", new Integer(Types.INTEGER) } };
26:
27: public static final boolean[] RELEVANTS = { true };
28:
29: public static final String SQL = (new StringBuffer())
30: .append("SELECT POLICY.WM_POLICY_ID ")
31: .append(
32: "FROM WM_POLICY POLICY, CONTENT_TREE CONTENT, CONTENT_TREE TREE ")
33: .append("WHERE ")
34: .append(" CONTENT.CONTENT_NODE_ID = ? AND ")
35: .append(" TREE.LEFT_NR <= CONTENT.LEFT_NR AND ")
36: .append(" TREE.RIGHT_NR >= CONTENT.RIGHT_NR AND ")
37: .append(
38: " TREE.CONTENT_NODE_ID = POLICY.OBJECT_REFERENCE AND ")
39: .append(" POLICY.WM_USER_ID = ? AND ").append(
40: " POLICY.WM_CONTEXT_ID = ? AND ").append(
41: " POLICY.OBJECT_TYPE = ? ").append(
42: "ORDER BY TREE.LEFT_NR ASC").toString();
43:
44: // Method implementations
45:
46: public void initQuery(Connection connection) {
47: super .initQuery(connection, true, ORDER, TYPES, RELEVANTS, SQL);
48: }
49:
50: }
|