KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > com > teamkonzept > webman > mainint > db > queries > content > postgresql > InsertTempTableSiteNodeId


1 package com.teamkonzept.webman.mainint.db.queries.content.postgresql;
2
3 import java.sql.Connection JavaDoc;
4 import com.teamkonzept.db.*;
5
6 /**
7  * @author $Author: ralf $
8  * @version $Revision: 1.3 $
9  */
10 public class InsertTempTableSiteNodeId extends TKPrepQuery
11 {
12     public static final boolean PREPARED = true;
13     public static final String JavaDoc[] ORDER = {};
14     public static final Object JavaDoc[][] TYPES = null;
15     public static final boolean[] RELEVANTS = { true };
16
17     /**
18      * The SQL-Query to execute
19      */
20     public static final String JavaDoc SQLSTRING =
21
22         "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) " +
23         "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 " +
24         "FROM WEBMAN_TEMP T LEFT JOIN SITE_TREE ST ON ( T.CONTENT_NODE_ID = ST.PG_CONTENT_NODE ), " +
25         " WEBMAN_TEMP TMP LEFT JOIN DOCUMENT_CONTENT DC USING ( CONTENT_NODE_ID ), " +
26         " WEBMAN_TEMP TEMP LEFT JOIN CONTENT_TREE CT USING ( CONTENT_NODE_ID ) " +
27         " WHERE T.CONTENT_NODE_ID = TMP.CONTENT_NODE_ID AND T.CONTENT_NODE_ID = TEMP.CONTENT_NODE_ID ";
28
29     public void initQuery(Connection JavaDoc con) {
30         super.initQuery(
31             con,
32             PREPARED,
33             ORDER,
34             TYPES,
35             RELEVANTS,
36             SQLSTRING );
37     }
38
39 }
40
Popular Tags