com.ibm.di.connector.ccmdb.provider
Class CCMDBActualCISchema

java.lang.Object
  com.ibm.di.connector.ccmdb.provider.CCMDBActualCISchema

public class CCMDBActualCISchema
extends Object

An utility class for generating database specific SQL queries.

Field Summary

static String	ACTCI_ACTCIID
static String	ACTCI_ACTCINAME
static String	ACTCI_ACTCINUM
static String	ACTCI_CHANGEBY
static String	ACTCI_CHANGEDATE
static String	ACTCI_CLASSSTRUCTUREID
static String	ACTCI_DESCRIPTION
static String	ACTCI_GUID
static String	ACTCI_HASLD
static String	ACTCI_LANGCODE
static String	ACTCI_LASTSCANDT
static String	ACTCI_PLUSPCUSTOMER
static String	ACTCIRELATION_ACTCIRELATIONID
static String	ACTCIRELATION_ANCESTORCI
static String	ACTCIRELATION_CHANGEBY
static String	ACTCIRELATION_CHANGEDATE
static String	ACTCIRELATION_RELATIONNUM
static String	ACTCIRELATION_SOURCECI
static String	ACTCIRELATION_SOURCECIGUID
static String	ACTCIRELATION_SWAPPED
static String	ACTCIRELATION_TARGETCI
static String	ACTCIRELATION_TARGETCIGUID
static String	ACTCISPEC_ACTCINUM
static String	ACTCISPEC_ACTCISPECID
static String	ACTCISPEC_ASSETATTRID
static String	ACTCISPEC_CHANGEBY
static String	ACTCISPEC_CHANGEDATE
static String	ACTCISPEC_CLASSSTRUCTUREID
static String	ATTR_NUM_VALUE
static String	MODELOBJECT_ADMINSTATE
static String	MODELOBJECT_BIDIFLAG
static String	MODELOBJECT_BIDIFORMAT
static String	MODELOBJECT_CDMSOURCE
static String	MODELOBJECT_CONTEXTIP
static String	MODELOBJECT_CREATEDBY
static String	MODELOBJECT_DESCRIPTION
static String	MODELOBJECT_DISPLAYNAME
static String	MODELOBJECT_EXTENDEDATTRIBUTES
static String	MODELOBJECT_LABEL
static String	MODELOBJECT_LASTMODIFIEDBY
static String	MODELOBJECT_LASTMODIFIEDTIME
static String	MODELOBJECT_OBJECTTYPE
static String	MODELOBJECT_SOURCETOKEN
static String	OMP_CHANGEBY
static String	OMP_CHANGEDATE
static String	OMP_DISPLAYLABEL
static String	OMP_NAME
static String	OMP_OMPGUID
static String	OMP_OMPID
static String	OMP_PRODUCTNAME
static String	OMP_VERSION
static String	OMPCIRLN_OMPCIRLNID
static String	OMPCIRLN_OMPGUID

Constructor Summary

CCMDBActualCISchema()

Method Summary

static String	createGuid(ActualCI item)
static SQLQuery	createInsertQuery(ActualCI configItem, ActualCIDefinition definition)
static SQLQuery	createInsertQuery(AttributeDefinition attrDef, ClassAttribute attribute)
static SQLQuery	createInsertQuery(CIRelation relation, CIRelationDefinition definition)
static SQLQuery	createUpdateQuery(AttributeDefinition attrDef, ClassAttribute attribute)
static String	getAttrJavaClass(String attrType)
static String	getAttrValueColumn(String attrType)
static SQLQuery	getSearchQuery(ActualCI searchObject, ActualCIDefinition definition, boolean matchAny)
static SQLQuery	getSearchQuery(CIRelation searchObject, CIRelationDefinition definition, boolean matchAny)

Methods inherited from class java.lang.Object

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

Field Detail

ATTR_NUM_VALUE

public static final String ATTR_NUM_VALUE

See Also:

Constant Field Values

ACTCI_ACTCINUM

public static final String ACTCI_ACTCINUM

See Also:

Constant Field Values

ACTCI_ACTCINAME

public static final String ACTCI_ACTCINAME

See Also:

Constant Field Values

ACTCI_GUID

public static final String ACTCI_GUID

See Also:

Constant Field Values

ACTCI_ACTCIID

public static final String ACTCI_ACTCIID

See Also:

Constant Field Values

ACTCI_CLASSSTRUCTUREID

public static final String ACTCI_CLASSSTRUCTUREID

See Also:

Constant Field Values

ACTCI_CHANGEBY

public static final String ACTCI_CHANGEBY

See Also:

Constant Field Values

ACTCI_CHANGEDATE

public static final String ACTCI_CHANGEDATE

See Also:

Constant Field Values

ACTCI_LASTSCANDT

public static final String ACTCI_LASTSCANDT

See Also:

Constant Field Values

ACTCI_LANGCODE

public static final String ACTCI_LANGCODE

See Also:

Constant Field Values

ACTCI_HASLD

public static final String ACTCI_HASLD

See Also:

Constant Field Values

ACTCI_DESCRIPTION

public static final String ACTCI_DESCRIPTION

See Also:

Constant Field Values

ACTCI_PLUSPCUSTOMER

public static final String ACTCI_PLUSPCUSTOMER

See Also:

Constant Field Values

ACTCISPEC_ACTCISPECID

public static final String ACTCISPEC_ACTCISPECID

See Also:

Constant Field Values

ACTCISPEC_ASSETATTRID

public static final String ACTCISPEC_ASSETATTRID

See Also:

Constant Field Values

ACTCISPEC_CHANGEBY

public static final String ACTCISPEC_CHANGEBY

See Also:

Constant Field Values

ACTCISPEC_CHANGEDATE

public static final String ACTCISPEC_CHANGEDATE

See Also:

Constant Field Values

ACTCISPEC_ACTCINUM

public static final String ACTCISPEC_ACTCINUM

See Also:

Constant Field Values

ACTCISPEC_CLASSSTRUCTUREID

public static final String ACTCISPEC_CLASSSTRUCTUREID

See Also:

Constant Field Values

ACTCIRELATION_ACTCIRELATIONID

public static final String ACTCIRELATION_ACTCIRELATIONID

See Also:

Constant Field Values

ACTCIRELATION_RELATIONNUM

public static final String ACTCIRELATION_RELATIONNUM

See Also:

Constant Field Values

ACTCIRELATION_ANCESTORCI

public static final String ACTCIRELATION_ANCESTORCI

See Also:

Constant Field Values

ACTCIRELATION_SOURCECI

public static final String ACTCIRELATION_SOURCECI

See Also:

Constant Field Values

ACTCIRELATION_SOURCECIGUID

public static final String ACTCIRELATION_SOURCECIGUID

See Also:

Constant Field Values

ACTCIRELATION_TARGETCI

public static final String ACTCIRELATION_TARGETCI

See Also:

Constant Field Values

ACTCIRELATION_TARGETCIGUID

public static final String ACTCIRELATION_TARGETCIGUID

See Also:

Constant Field Values

ACTCIRELATION_CHANGEBY

public static final String ACTCIRELATION_CHANGEBY

See Also:

Constant Field Values

ACTCIRELATION_CHANGEDATE

public static final String ACTCIRELATION_CHANGEDATE

See Also:

Constant Field Values

ACTCIRELATION_SWAPPED

public static final String ACTCIRELATION_SWAPPED

See Also:

Constant Field Values

OMPCIRLN_OMPCIRLNID

public static final String OMPCIRLN_OMPCIRLNID

See Also:

Constant Field Values

OMPCIRLN_OMPGUID

public static final String OMPCIRLN_OMPGUID

See Also:

Constant Field Values

OMP_OMPID

public static final String OMP_OMPID

See Also:

Constant Field Values

OMP_OMPGUID

public static final String OMP_OMPGUID

See Also:

Constant Field Values

OMP_VERSION

public static final String OMP_VERSION

See Also:

Constant Field Values

OMP_CHANGEDATE

public static final String OMP_CHANGEDATE

See Also:

Constant Field Values

OMP_DISPLAYLABEL

public static final String OMP_DISPLAYLABEL

See Also:

Constant Field Values

OMP_CHANGEBY

public static final String OMP_CHANGEBY

See Also:

Constant Field Values

OMP_NAME

public static final String OMP_NAME

See Also:

Constant Field Values

OMP_PRODUCTNAME

public static final String OMP_PRODUCTNAME

See Also:

Constant Field Values

MODELOBJECT_ADMINSTATE

public static final String MODELOBJECT_ADMINSTATE

See Also:

Constant Field Values

MODELOBJECT_BIDIFLAG

public static final String MODELOBJECT_BIDIFLAG

See Also:

Constant Field Values

MODELOBJECT_BIDIFORMAT

public static final String MODELOBJECT_BIDIFORMAT

See Also:

Constant Field Values

MODELOBJECT_CDMSOURCE

public static final String MODELOBJECT_CDMSOURCE

See Also:

Constant Field Values

MODELOBJECT_CONTEXTIP

public static final String MODELOBJECT_CONTEXTIP

See Also:

Constant Field Values

MODELOBJECT_CREATEDBY

public static final String MODELOBJECT_CREATEDBY

See Also:

Constant Field Values

MODELOBJECT_DESCRIPTION

public static final String MODELOBJECT_DESCRIPTION

See Also:

Constant Field Values

MODELOBJECT_DISPLAYNAME

public static final String MODELOBJECT_DISPLAYNAME

See Also:

Constant Field Values

MODELOBJECT_EXTENDEDATTRIBUTES

public static final String MODELOBJECT_EXTENDEDATTRIBUTES

See Also:

Constant Field Values

MODELOBJECT_LABEL

public static final String MODELOBJECT_LABEL

See Also:

Constant Field Values

MODELOBJECT_LASTMODIFIEDBY

public static final String MODELOBJECT_LASTMODIFIEDBY

See Also:

Constant Field Values

MODELOBJECT_LASTMODIFIEDTIME

public static final String MODELOBJECT_LASTMODIFIEDTIME

See Also:

Constant Field Values

MODELOBJECT_OBJECTTYPE

public static final String MODELOBJECT_OBJECTTYPE

See Also:

Constant Field Values

MODELOBJECT_SOURCETOKEN

public static final String MODELOBJECT_SOURCETOKEN

See Also:

Constant Field Values

Constructor Detail

CCMDBActualCISchema

public CCMDBActualCISchema()

Method Detail

getAttrJavaClass

public static String getAttrJavaClass(String attrType)

Parameters:

attrType -

Returns:

String

getAttrValueColumn

public static String getAttrValueColumn(String attrType)

Parameters:

attrType -

Returns:

String

getSearchQuery

public static SQLQuery getSearchQuery(ActualCI searchObject,
                                      ActualCIDefinition definition,
                                      boolean matchAny)

Parameters:

searchObject -

definition -

matchAny -

Returns:

SQLQuery

getSearchQuery

public static SQLQuery getSearchQuery(CIRelation searchObject,
                                      CIRelationDefinition definition,
                                      boolean matchAny)

Parameters:

searchObject -

definition -

matchAny -

Returns:

SQLQuery

createInsertQuery

public static SQLQuery createInsertQuery(CIRelation relation,
                                         CIRelationDefinition definition)

Parameters:

relation -

definition -

Returns:

SQLQuery

createInsertQuery

public static SQLQuery createInsertQuery(ActualCI configItem,
                                         ActualCIDefinition definition)

Parameters:

configItem -

definition -

Returns:

SQLQuery

createInsertQuery

public static SQLQuery createInsertQuery(AttributeDefinition attrDef,
                                         ClassAttribute attribute)

Parameters:

attrDef -

attribute -

Returns:

SQLQuery

createUpdateQuery

public static SQLQuery createUpdateQuery(AttributeDefinition attrDef,
                                         ClassAttribute attribute)

Parameters:

attrDef -

attribute -

Returns:

SQLQuery

createGuid

public static String createGuid(ActualCI item)
                         throws CCMDBException

Parameters:

item -

Returns:

String

Throws:

CCMDBException