|
1
5 package com.teamkonzept.webman.refsel.db.queries.postgresql;
6
7 import java.sql.*;
8
9 import com.teamkonzept.db.*;
10
11
16 public class TKWMDBRSMother extends TKPrepQuery {
17
18 public final static boolean IS_PREPARED =
19 true;
20
21 public final static String  [] PARAM_ORDER =
22 {SITE_NODE_ID, SITE_NODE_ID, SITE_NODE_ID};
23
24 public final static Object [][] PARAM_TYPES =
25 null;
26
27 public final static boolean[] SET_RELEVANTS =
28 { true };
29
30 public final static String SQL_STRING =
31 " SELECT INNER_QUERY.LEFT_NR AS LEFT_NR, INNER_QUERY.DOCUMENT_SHORTNAME AS DOCUMENT_SHORTNAME, OUTER_QUERY.DOCUMENT_NAME AS DOCUMENT_NAME "
32 + " FROM "
33 + " ( "
34 + " SELECT MAX(ST.LEFT_NR) AS LEFT_NR, SD.DOCUMENT_SHORTNAME "
35 + " FROM SITE_TREE ST, SITE_DOCUMENT SD "
36 + " WHERE "
37 + " ST.SITE_NODE_ID = SD.SITE_NODE_ID "
38 + " AND "
39 + " ( "
40 + " ST.LEFT_NR < (SELECT LEFT_NR FROM SITE_TREE WHERE SITE_NODE_ID = ?) "
41 + " AND "
42 + " ST.RIGHT_NR > (SELECT RIGHT_NR FROM SITE_TREE WHERE SITE_NODE_ID =?) "
43 + " ) "
44 + " AND "
45 + " ( "
46 + " SD.INHERITABLE = 1 "
47 + " OR "
48 + " SD.SITE_NODE_ID = (SELECT SITE_NODE_PARENT FROM SITE_TREE WHERE SITE_NODE_ID = ?) "
49 + " ) "
50 + " GROUP BY SD.DOCUMENT_SHORTNAME "
51 + " ) "
52 + " AS INNER_QUERY, SITE_DOCUMENT OUTER_QUERY "
53 + " WHERE "
54 + " INNER_QUERY.DOCUMENT_SHORTNAME = OUTER_QUERY.DOCUMENT_SHORTNAME "
55 + " ORDER BY LEFT_NR "
56 ;
57
58
59 public void initQuery(Connection con) {
60 super.initQuery(
61 con,
62 IS_PREPARED,
63 PARAM_ORDER,
64 PARAM_TYPES,
65 SET_RELEVANTS,
66 SQL_STRING );
67 }
68 }
69
70 |
Popular Tags |
Java API By Example, From Geeks To Geeks.