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

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

public class CCMDBActualCISchema
extends java.lang.Object

An utility class for generating database specific SQL queries.

Field Summary

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

Constructor Summary

CCMDBActualCISchema()

Method Summary

static java.lang.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 java.lang.String	getAttrJavaClass(java.lang.String attrType)
static java.lang.String	getAttrValueColumn(java.lang.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 java.lang.String ATTR_NUM_VALUE

See Also:

Constant Field Values

ACTCI_ACTCINUM

public static final java.lang.String ACTCI_ACTCINUM

See Also:

Constant Field Values

ACTCI_ACTCINAME

public static final java.lang.String ACTCI_ACTCINAME

See Also:

Constant Field Values

ACTCI_GUID

public static final java.lang.String ACTCI_GUID

See Also:

Constant Field Values

ACTCI_ACTCIID

public static final java.lang.String ACTCI_ACTCIID

See Also:

Constant Field Values

ACTCI_CLASSSTRUCTUREID

public static final java.lang.String ACTCI_CLASSSTRUCTUREID

See Also:

Constant Field Values

ACTCI_CHANGEBY

public static final java.lang.String ACTCI_CHANGEBY

See Also:

Constant Field Values

ACTCI_CHANGEDATE

public static final java.lang.String ACTCI_CHANGEDATE

See Also:

Constant Field Values

ACTCI_LASTSCANDT

public static final java.lang.String ACTCI_LASTSCANDT

See Also:

Constant Field Values

ACTCI_LANGCODE

public static final java.lang.String ACTCI_LANGCODE

See Also:

Constant Field Values

ACTCI_HASLD

public static final java.lang.String ACTCI_HASLD

See Also:

Constant Field Values

ACTCI_DESCRIPTION

public static final java.lang.String ACTCI_DESCRIPTION

See Also:

Constant Field Values

ACTCI_PLUSPCUSTOMER

public static final java.lang.String ACTCI_PLUSPCUSTOMER

See Also:

Constant Field Values

ACTCISPEC_ACTCISPECID

public static final java.lang.String ACTCISPEC_ACTCISPECID

See Also:

Constant Field Values

ACTCISPEC_ASSETATTRID

public static final java.lang.String ACTCISPEC_ASSETATTRID

See Also:

Constant Field Values

ACTCISPEC_CHANGEBY

public static final java.lang.String ACTCISPEC_CHANGEBY

See Also:

Constant Field Values

ACTCISPEC_CHANGEDATE

public static final java.lang.String ACTCISPEC_CHANGEDATE

See Also:

Constant Field Values

ACTCISPEC_ACTCINUM

public static final java.lang.String ACTCISPEC_ACTCINUM

See Also:

Constant Field Values

ACTCISPEC_CLASSSTRUCTUREID

public static final java.lang.String ACTCISPEC_CLASSSTRUCTUREID

See Also:

Constant Field Values

ACTCIRELATION_ACTCIRELATIONID

public static final java.lang.String ACTCIRELATION_ACTCIRELATIONID

See Also:

Constant Field Values

ACTCIRELATION_RELATIONNUM

public static final java.lang.String ACTCIRELATION_RELATIONNUM

See Also:

Constant Field Values

ACTCIRELATION_ANCESTORCI

public static final java.lang.String ACTCIRELATION_ANCESTORCI

See Also:

Constant Field Values

ACTCIRELATION_SOURCECI

public static final java.lang.String ACTCIRELATION_SOURCECI

See Also:

Constant Field Values

ACTCIRELATION_SOURCECIGUID

public static final java.lang.String ACTCIRELATION_SOURCECIGUID

See Also:

Constant Field Values

ACTCIRELATION_TARGETCI

public static final java.lang.String ACTCIRELATION_TARGETCI

See Also:

Constant Field Values

ACTCIRELATION_TARGETCIGUID

public static final java.lang.String ACTCIRELATION_TARGETCIGUID

See Also:

Constant Field Values

ACTCIRELATION_CHANGEBY

public static final java.lang.String ACTCIRELATION_CHANGEBY

See Also:

Constant Field Values

ACTCIRELATION_CHANGEDATE

public static final java.lang.String ACTCIRELATION_CHANGEDATE

See Also:

Constant Field Values

ACTCIRELATION_SWAPPED

public static final java.lang.String ACTCIRELATION_SWAPPED

See Also:

Constant Field Values

OMPCIRLN_OMPCIRLNID

public static final java.lang.String OMPCIRLN_OMPCIRLNID

See Also:

Constant Field Values

OMPCIRLN_OMPGUID

public static final java.lang.String OMPCIRLN_OMPGUID

See Also:

Constant Field Values

OMP_OMPID

public static final java.lang.String OMP_OMPID

See Also:

Constant Field Values

OMP_OMPGUID

public static final java.lang.String OMP_OMPGUID

See Also:

Constant Field Values

OMP_VERSION

public static final java.lang.String OMP_VERSION

See Also:

Constant Field Values

OMP_CHANGEDATE

public static final java.lang.String OMP_CHANGEDATE

See Also:

Constant Field Values

OMP_DISPLAYLABEL

public static final java.lang.String OMP_DISPLAYLABEL

See Also:

Constant Field Values

OMP_CHANGEBY

public static final java.lang.String OMP_CHANGEBY

See Also:

Constant Field Values

OMP_NAME

public static final java.lang.String OMP_NAME

See Also:

Constant Field Values

OMP_PRODUCTNAME

public static final java.lang.String OMP_PRODUCTNAME

See Also:

Constant Field Values

MODELOBJECT_ADMINSTATE

public static final java.lang.String MODELOBJECT_ADMINSTATE

See Also:

Constant Field Values

MODELOBJECT_BIDIFLAG

public static final java.lang.String MODELOBJECT_BIDIFLAG

See Also:

Constant Field Values

MODELOBJECT_BIDIFORMAT

public static final java.lang.String MODELOBJECT_BIDIFORMAT

See Also:

Constant Field Values

MODELOBJECT_CDMSOURCE

public static final java.lang.String MODELOBJECT_CDMSOURCE

See Also:

Constant Field Values

MODELOBJECT_CONTEXTIP

public static final java.lang.String MODELOBJECT_CONTEXTIP

See Also:

Constant Field Values

MODELOBJECT_CREATEDBY

public static final java.lang.String MODELOBJECT_CREATEDBY

See Also:

Constant Field Values

MODELOBJECT_DESCRIPTION

public static final java.lang.String MODELOBJECT_DESCRIPTION

See Also:

Constant Field Values

MODELOBJECT_DISPLAYNAME

public static final java.lang.String MODELOBJECT_DISPLAYNAME

See Also:

Constant Field Values

MODELOBJECT_EXTENDEDATTRIBUTES

public static final java.lang.String MODELOBJECT_EXTENDEDATTRIBUTES

See Also:

Constant Field Values

MODELOBJECT_LABEL

public static final java.lang.String MODELOBJECT_LABEL

See Also:

Constant Field Values

MODELOBJECT_LASTMODIFIEDBY

public static final java.lang.String MODELOBJECT_LASTMODIFIEDBY

See Also:

Constant Field Values

MODELOBJECT_LASTMODIFIEDTIME

public static final java.lang.String MODELOBJECT_LASTMODIFIEDTIME

See Also:

Constant Field Values

MODELOBJECT_OBJECTTYPE

public static final java.lang.String MODELOBJECT_OBJECTTYPE

See Also:

Constant Field Values

MODELOBJECT_SOURCETOKEN

public static final java.lang.String MODELOBJECT_SOURCETOKEN

See Also:

Constant Field Values

Constructor Detail

CCMDBActualCISchema

public CCMDBActualCISchema()

Method Detail

getAttrJavaClass

public static java.lang.String getAttrJavaClass(java.lang.String attrType)

Parameters:

attrType -

Returns:

String

getAttrValueColumn

public static java.lang.String getAttrValueColumn(java.lang.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 java.lang.String createGuid(ActualCI item)
                                   throws CCMDBException

Parameters:

item -

Returns:

String

Throws:

CCMDBException