GenContNodeConts_Part_2.java :  » Content-Management-System » webman » de » webman » generator » db » queries » Java Open Source

package de.webman.generator.db.queries;

import com.teamkonzept.db.*;
import java.sql.*;

/**
 * renders the second resultset of the query  DBGenContNodeConts
 *
 *  @see DBGenContNodeConts
 * @author  $Author: markus $
 * @version $Revision: 1.7 $
 */
public class GenContNodeConts_Part_2 extends TKPrepQuery {

  public static boolean isPrepared =
    true;

  public static String[] paramOrder =
    null;

  public static Object[][] paramTypes =
    null;

  public static boolean[] setRelevants =
    { true };

  public static String sqlString =



  " SELECT * FROM ( "
 + " SELECT CV.VERSION_ID, CV.INSTANCE_ID, CV.CONTENT_ID, CV.STATUS_ID, CV.VERSION_DATE, CV.INFO, CV.AUTHOR, CI.NAME, "
 + " CT.CONTENT_FORM, CT.CONTENT_NODE_ID, T.CONTENT_NODE_TYPE AS PARENT_TYPE, CT.CONTENT_NODE_NAME,   "
 + " CT.CONTENT_NODE_SHORTNAME, CT.CONTENT_NODE_PARENT, T.CONTENT_NODE_ID AS REF_NODE_ID   "
 + "  FROM CONTENT_TREE CT, CONTENT_INSTANCE CI, "
 + "   ( "
 + "   SELECT  DISTINCT "
 + "      CT.CONTENT_NODE_ID,   "
 + "      CT.CONTENT_NODE_SHORTNAME,   "
 + "      CT.CONTENT_NODE_NAME,   "
 + "      CT.CONTENT_NODE_TYPE,   "
 + "      CT.CONTENT_FORM  "
 + "     FROM   "
 + "      CONTENT_TREE CT, DOCUMENT_CONTENT DC, SITE_TREE ST "
 + "     WHERE   "
 + "      CT.CONTENT_NODE_ID = DC.CONTENT_NODE_ID "
 + "      OR "
 + "      CT.CONTENT_NODE_ID = ST.PG_CONTENT_NODE  "
 + "   ) T,  "
 + "   CONTENT_VERSION CV   "
 + " WHERE   "
 + "  ( CT.CONTENT_NODE_PARENT = T.CONTENT_NODE_ID OR   "
 + "    CT.CONTENT_NODE_ID = T.CONTENT_NODE_ID   "
 + "  ) AND  "
 + "  CT.CONTENT_NODE_ID = CI.CONTENT_NODE_ID AND   "
 + "  CI.INSTANCE_ID = CV.INSTANCE_ID   "
 + "  AND CV.CONTENT_ID " + DBStringFactory.notEqualsNull()
 + " UNION "
+ " SELECT CV.VERSION_ID, CV.INSTANCE_ID, -1, CV.STATUS_ID, CV.VERSION_DATE, CV.INFO, CV.AUTHOR, CI.NAME,"
 + " CT.CONTENT_FORM, CT.CONTENT_NODE_ID, T.CONTENT_NODE_TYPE AS PARENT_TYPE, CT.CONTENT_NODE_NAME,   "
 + " CT.CONTENT_NODE_SHORTNAME, CT.CONTENT_NODE_PARENT, T.CONTENT_NODE_ID AS REF_NODE_ID   "
 + "  FROM CONTENT_TREE CT, CONTENT_INSTANCE CI, "
 + "   ( "
 + "   SELECT  DISTINCT "
 + "      CT.CONTENT_NODE_ID,   "
 + "      CT.CONTENT_NODE_SHORTNAME,   "
 + "      CT.CONTENT_NODE_NAME,   "
 + "      CT.CONTENT_NODE_TYPE,   "
 + "      CT.CONTENT_FORM   "
 + "     FROM   "
 + "      CONTENT_TREE CT, DOCUMENT_CONTENT DC, SITE_TREE ST "
 + "     WHERE   "
 + "      CT.CONTENT_NODE_ID = DC.CONTENT_NODE_ID "
 + "      OR "
 + "      CT.CONTENT_NODE_ID = ST.PG_CONTENT_NODE  "
 + "   ) "
 + "   T,   "
 + "   CONTENT_VERSION CV   "
 + " WHERE   "
 + "  ( CT.CONTENT_NODE_PARENT = T.CONTENT_NODE_ID OR   "
 + "    CT.CONTENT_NODE_ID = T.CONTENT_NODE_ID   "
 + "  ) AND  "
 + "  CT.CONTENT_NODE_ID = CI.CONTENT_NODE_ID AND   "
 + "  CI.INSTANCE_ID = CV.INSTANCE_ID   "
 + "  AND CV.CONTENT_ID " + DBStringFactory.equalsNull()
 + " ) X "
 + " ORDER BY X.CONTENT_NODE_ID, X.INSTANCE_ID, X.CONTENT_ID, X.VERSION_ID   "
;

  public void initQuery(Connection con) {
    super.initQuery(
      con,
      isPrepared,
      paramOrder,
      paramTypes,
      setRelevants,
      sqlString );
  }
}