01: package com.teamkonzept.webman.mainint.db.queries.content;
02:
03: import java.sql.Connection;
04: import com.teamkonzept.db.*;
05:
06: public class InsertTempTableSiteNodeId extends TKPrepQuery {
07:
08: public static boolean prepared = true;
09: public static String[] order = {};
10: public static Object[][] types = null;
11: public static boolean[] relevants = { true };
12: public static String sqlString = "INSERT INTO WEBMAN_TEMP2 (SITE_NODE_ID, CONTENT_NODE_ID, CONTENT_NODE_SHORTNAME, CONTENT_NODE_TYPE, DC_SITE_NODE_ID, DC_SITE_NODE_DOC_IDX) "
13: + "SELECT ST.SITE_NODE_ID, CT.CONTENT_NODE_ID, CT.CONTENT_NODE_SHORTNAME, CT.CONTENT_NODE_TYPE, DC.SITE_NODE_ID, DC.SITE_NODE_DOC_IDX "
14: + "FROM SITE_TREE ST, DOCUMENT_CONTENT DC, CONTENT_TREE CT, WEBMAN_TEMP T "
15: + "WHERE "
16: + DBStringFactory.leftOuterJoin("T.CONTENT_NODE_ID",
17: "ST.PG_CONTENT_NODE")
18: + " AND "
19: + DBStringFactory.leftOuterJoin("T.CONTENT_NODE_ID",
20: "DC.CONTENT_NODE_ID")
21: + " AND "
22: + DBStringFactory.leftOuterJoin("T.CONTENT_NODE_ID",
23: "CT.CONTENT_NODE_ID");
24:
25: public void initQuery(Connection con) {
26: super.initQuery(con, prepared, order, types, relevants,
27: sqlString);
28: }
29:
30: }
|