01: package de.webman.generator.db.queries.sybase;
02:
03: import com.teamkonzept.db.*;
04: import java.sql.*;
05:
06: /**
07: * DBGenContNodeConts_Part_2
08: * renders the second resultset of the query DBGenContNodeConts
09: *
10: * @see DBGenContNodeConts
11: * @author $Author: markus $
12: * @version $Revision: 1.1 $
13: */
14: public class GenContNodeConts_Part_2 extends TKPrepQuery {
15:
16: public static boolean isPrepared = true;
17:
18: public static String[] paramOrder = null;
19:
20: public static Object[][] paramTypes = null;
21:
22: public static boolean[] setRelevants = { true };
23:
24: public static String sqlString =
25:
26: "SELECT DISTINCT "
27: + " CONTENT_NODE_ID "
28: + "INTO "
29: + " #temp "
30: + "FROM "
31: + " DOCUMENT_CONTENT "
32: + "WHERE "
33: + " CONTENT_NODE_ID "
34: + DBStringFactory.notEqualsNull()
35: + "UNION "
36: + "SELECT DISTINCT "
37: + " PG_CONTENT_NODE "
38: + "FROM "
39: + " SITE_TREE "
40: + "WHERE "
41: + " PG_CONTENT_NODE "
42: + DBStringFactory.notEqualsNull()
43: +
44:
45: /* Alex - was soll das auch ?
46: "SELECT " +
47: " CT.CONTENT_NODE_ID, " +
48: " CT.CONTENT_NODE_SHORTNAME, " +
49: " CT.CONTENT_NODE_NAME, " +
50: " CT.CONTENT_NODE_TYPE, " +
51: " CT.CONTENT_FORM " +
52: "FROM " +
53: " CONTENT_TREE CT, #temp T " +
54: "WHERE " +
55: " CT.CONTENT_NODE_ID = T.CONTENT_NODE_ID " +
56: */
57: "SELECT CV.*, CI.NAME, CT.CONTENT_NODE_ID, CT.CONTENT_NODE_TYPE, CT.CONTENT_NODE_NAME, CT.CONTENT_FORM, "
58: + " CT.CONTENT_NODE_SHORTNAME, CT2.CONTENT_NODE_TYPE AS PARENT_TYPE, CT.CONTENT_NODE_PARENT, T.CONTENT_NODE_ID AS REF_NODE_ID "
59: + " FROM CONTENT_TREE CT, CONTENT_TREE CT2, CONTENT_INSTANCE CI, #temp T, CONTENT_VERSION CV "
60: + "WHERE " +
61:
62: " ( CT.CONTENT_NODE_PARENT = T.CONTENT_NODE_ID OR "
63: + " CT.CONTENT_NODE_ID = T.CONTENT_NODE_ID " + " ) AND " +
64:
65: " CT.CONTENT_NODE_ID = CI.CONTENT_NODE_ID AND "
66: + " CI.INSTANCE_ID = CV.INSTANCE_ID AND"
67: + " CT2.CONTENT_NODE_ID = CT.CONTENT_NODE_PARENT " +
68:
69: "ORDER BY T.CONTENT_NODE_ID, CV.INSTANCE_ID, CV.CONTENT_ID, CV.VERSION_ID "
70: +
71:
72: "DROP TABLE #temp ";
73:
74: public void initQuery(Connection con) {
75: super.initQuery(con, isPrepared, paramOrder, paramTypes,
76: setRelevants, sqlString);
77: }
78: }
|