com.basecmp.core.persistence.impl
Class QueryFactory

java.lang.Object
  com.basecmp.core.persistence.impl.QueryFactory

public class QueryFactory

extends java.lang.Object

Method Summary

static java.lang.String	captionOfBindingStatement(java.lang.Long sourceCid, java.lang.Long targetCid, java.lang.String referenceType, boolean targetIsChild) Delivers sql-statement select REF_CAPTION from ASSET_REF where [CHILD_FK|PARENT_FK]=$targetCid and [PARENT_FK|CHILD_FK]=$sourceCid and REF_TYPE=$referenceType
static java.lang.String	deleteAllReferencesStatement(java.lang.Long cid) Delivers sql-statement delete from ASSET_REF where PARENT_FK=$cid or CHILD_FK=$cid
static java.lang.String	deleteManagedReferencesStatement(java.lang.Long cid, java.lang.String referencesCsv, boolean areChilds) Delivers sql-statement delete from ASSET_REF where [CHILD_FK|PARENT_FK]=$targetCid and [PARENT_FK|CHILD_FK]=$sourceCid and REF_TYPE=$referenceType
static java.lang.String	getReadAttachedAssetsWithStateInfoStatement(java.lang.Long cid)
static java.lang.String	getReadChildReferencesWithStateInfoStatement(java.lang.Long cid, java.lang.String referencesCsv)
static java.lang.String	getReadReferencesStatement(java.lang.Long cid, java.lang.String referenceType, boolean isChild)
static java.lang.String	readAttachedAssetIdsStatement(java.lang.Long cid)
static java.lang.String	readAttachedValuesStatement(java.lang.Long cid)
static java.lang.String	readManagedReferencesStatement(java.lang.Long cid, java.lang.String referencesCsv, boolean areChilds)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Method Detail

captionOfBindingStatement

public static final java.lang.String captionOfBindingStatement(java.lang.Long sourceCid,
                                                               java.lang.Long targetCid,
                                                               java.lang.String referenceType,
                                                               boolean targetIsChild)

Delivers sql-statement select REF_CAPTION from ASSET_REF where [CHILD_FK|PARENT_FK]=$targetCid and [PARENT_FK|CHILD_FK]=$sourceCid and REF_TYPE=$referenceType

deleteAllReferencesStatement

public static final java.lang.String deleteAllReferencesStatement(java.lang.Long cid)

Delivers sql-statement delete from ASSET_REF where PARENT_FK=$cid or CHILD_FK=$cid

deleteManagedReferencesStatement

public static final java.lang.String deleteManagedReferencesStatement(java.lang.Long cid,
                                                                      java.lang.String referencesCsv,
                                                                      boolean areChilds)

Delivers sql-statement delete from ASSET_REF where [CHILD_FK|PARENT_FK]=$targetCid and [PARENT_FK|CHILD_FK]=$sourceCid and REF_TYPE=$referenceType

getReadAttachedAssetsWithStateInfoStatement

public static final java.lang.String getReadAttachedAssetsWithStateInfoStatement(java.lang.Long cid)

getReadChildReferencesWithStateInfoStatement

public static final java.lang.String getReadChildReferencesWithStateInfoStatement(java.lang.Long cid,
                                                                                  java.lang.String referencesCsv)

getReadReferencesStatement

public static final java.lang.String getReadReferencesStatement(java.lang.Long cid,
                                                                java.lang.String referenceType,
                                                                boolean isChild)

readAttachedAssetIdsStatement

public static java.lang.String readAttachedAssetIdsStatement(java.lang.Long cid)

readAttachedValuesStatement

public static java.lang.String readAttachedValuesStatement(java.lang.Long cid)

readManagedReferencesStatement

public static final java.lang.String readManagedReferencesStatement(java.lang.Long cid,
                                                                    java.lang.String referencesCsv,
                                                                    boolean areChilds)