|
1 package de.webman.generator.db.queries.postgresql;
2
3 import com.teamkonzept.db.*;
4 import java.sql.*;
5
6
13 public class GenContNodeConts_Part_2 extends TKPrepQuery {
14
15 public static boolean isPrepared =
16 true;
17
18 public static String  [] paramOrder =
19 null;
20
21 public static Object [][] paramTypes =
22 null;
23
24 public static boolean[] setRelevants =
25 { true };
26
27 public static String sqlString =
28
29
30 "SELECT * FROM ("
31 + " SELECT CV.VERSION_ID, CV.INSTANCE_ID, CV.CONTENT_ID, CV.STATUS_ID, CV.VERSION_DATE, CV.INFO, CV.AUTHOR, CI.NAME, "
32 + " CT.CONTENT_FORM, CT.CONTENT_NODE_ID, CT2.CONTENT_NODE_TYPE AS PARENT_TYPE, CT.CONTENT_NODE_NAME, "
33 + " CT.CONTENT_NODE_SHORTNAME, CT.CONTENT_NODE_PARENT, T.CONTENT_NODE_ID AS REF_NODE_ID "
34 + " FROM CONTENT_TREE CT, CONTENT_TREE CT2, CONTENT_INSTANCE CI, "
35 + " ( "
36
37 + "SELECT DISTINCT "
38 + " CONTENT_NODE_ID "
39 + "FROM "
40 + " DOCUMENT_CONTENT "
41 + "WHERE "
42 + " CONTENT_NODE_ID " + DBStringFactory.notEqualsNull()
43 + "UNION "
44 + "SELECT DISTINCT "
45 + " PG_CONTENT_NODE "
46 + "FROM "
47 + " SITE_TREE "
48 + "WHERE "
49 + " PG_CONTENT_NODE " + DBStringFactory.notEqualsNull()
50 + " ) T, "
51 + " CONTENT_VERSION CV "
52 + " WHERE "
53 + " ( CT.CONTENT_NODE_PARENT = T.CONTENT_NODE_ID OR "
54 + " CT.CONTENT_NODE_ID = T.CONTENT_NODE_ID "
55 + " ) AND "
56 + " CT.CONTENT_NODE_ID = CI.CONTENT_NODE_ID AND "
57 + " CI.INSTANCE_ID = CV.INSTANCE_ID AND "
58
59 + " CT2.CONTENT_NODE_ID = CT.CONTENT_NODE_PARENT "
60 + " AND CV.CONTENT_ID " + DBStringFactory.notEqualsNull()
61
62 + "UNION "
63
64 + " SELECT CV.VERSION_ID, CV.INSTANCE_ID, -1, CV.STATUS_ID, CV.VERSION_DATE, CV.INFO, CV.AUTHOR, CI.NAME, "
65 + " CT.CONTENT_FORM, CT.CONTENT_NODE_ID, CT2.CONTENT_NODE_TYPE AS PARENT_TYPE, CT.CONTENT_NODE_NAME, "
66 + " CT.CONTENT_NODE_SHORTNAME, CT.CONTENT_NODE_PARENT, T.CONTENT_NODE_ID AS REF_NODE_ID "
67 + " FROM CONTENT_TREE CT, CONTENT_TREE CT2, CONTENT_INSTANCE CI, "
68 + " ( "
69
70 + "SELECT DISTINCT "
71 + " CONTENT_NODE_ID "
72 + "FROM "
73 + " DOCUMENT_CONTENT "
74 + "WHERE "
75 + " CONTENT_NODE_ID " + DBStringFactory.notEqualsNull()
76 + "UNION "
77 + "SELECT DISTINCT "
78 + " PG_CONTENT_NODE "
79 + "FROM "
80 + " SITE_TREE "
81 + "WHERE "
82 + " PG_CONTENT_NODE " + DBStringFactory.notEqualsNull()
83 + " ) T, "
84 + " CONTENT_VERSION CV "
85 + " WHERE "
86 + " ( CT.CONTENT_NODE_PARENT = T.CONTENT_NODE_ID OR "
87 + " CT.CONTENT_NODE_ID = T.CONTENT_NODE_ID "
88 + " ) AND "
89 + " CT.CONTENT_NODE_ID = CI.CONTENT_NODE_ID AND "
90 + " CI.INSTANCE_ID = CV.INSTANCE_ID AND "
91
92 + " CT2.CONTENT_NODE_ID = CT.CONTENT_NODE_PARENT "
93 + " AND CV.CONTENT_ID " + DBStringFactory.equalsNull()
94 + ") X "
95
96 + " ORDER BY X.CONTENT_NODE_ID, X.INSTANCE_ID, X.CONTENT_ID, X.VERSION_ID "
97 ;
98
99 public void initQuery(Connection con) {
100 super.initQuery(
101 con,
102 isPrepared,
103 paramOrder,
104 paramTypes,
105 setRelevants,
106 sqlString );
107 }
108 }
109 |
Popular Tags |
Java API By Example, From Geeks To Geeks.