1 /*2 * $Header: /cvsroot/webman-cms/source/webman/com/teamkonzept/webman/mainint/db/queries/postgresql/Attic/TKDBSiteDocClone.java,v 1.2 2001/11/30 18:05:20 markus Exp $3 *4 */5 package com.teamkonzept.webman.mainint.db.queries.postgresql;6 7 import java.sql.*;8 9 import com.teamkonzept.db.*;10 //import com.teamkonzept.webman.mainint.db.queries.sitetree.postgresql.CreateProcAdjustRefs;11 import com.teamkonzept.webman.mainint.db.queries.sitetree.SdNextIdx;12 import com.teamkonzept.webman.mainint.db.queries.sitetree.SdInsertNew;13 import com.teamkonzept.webman.mainint.db.queries.sitetree.DrCloneOnSd;14 import com.teamkonzept.webman.mainint.db.queries.sitetree.postgresql.DrUpdateRelRefs;15 import com.teamkonzept.webman.mainint.db.queries.sitetree.postgresql.DcCsCloneOnSd;16 import com.teamkonzept.webman.mainint.db.queries.sitetree.SdGet;17 18 /**19 * TKDBSiteDocClone20 * input -> PK: NODE_ID, NODE_DOC_IDX vom zu clonenden Document21 * input -> vom neuen SITE_NODE_ID, PRESENTATION_ID, DOCUMENT_NAME,22 * DOCUMENT_SHORTNAME, INHERITABLE23 * ouput neuer Datensatz24 *25 *26 * required parameters:27 * NODE_ID28 * NODE_DOC_IDX29 * SITE_NODE_ID30 * PRESENTATION_ID31 * DOCUMENT_NAME32 * DOCUMENT_SHORTNAME33 * DOCUMENT_TYPE34 * INHERITABLE35 *36 * optional parameters37 * EXTERNAL_URL38 * INHERIT_END_LEVEL,39 * INHERIT_BEGIN_LEVEL40 *41 * @author42 * @version43 */44 45 public class TKDBSiteDocClone extends CompositeQuery46 {47 protected void initConcreteCompositeQuery() throws SQLException48 {49 50 /* create procedure for adjusting relative references of a certain DOCUMENT_REFERENCE record */51 // registerQuery(CreateProcAdjustRefs.class);52 53 /* new idx */54 registerQuery(SdNextIdx.class);55 56 /* new SITE_DOCUMENT record */57 registerQuery(SdInsertNew.class);58 59 /* clone DOCUMENT_REFERENCE */60 registerQuery(DrCloneOnSd.class);61 62 /* updates references that belong to a certain site_document */63 registerQuery(DrUpdateRelRefs.class);64 65 66 /* clone DOCUMENT_CONTENT and CONTENT_SELECTION */67 registerQuery(DcCsCloneOnSd.class);68 69 /* select the new SITE_DOCUMENT */70 registerQuery(SdGet.class);71 72 setDefaultParameterPropagation();73 74 }75 }76