oracle.apps.fnd.applxdf.comp
Class CommentObject

java.lang.Object
  oracle.apps.fnd.applxdf.comp.DBObject
      oracle.apps.fnd.applxdf.comp.CommentObject

public class CommentObject
extends DBObject

Class definition

Field Summary

Fields inherited from class oracle.apps.fnd.applxdf.comp.DBObject

indexExists, logger, mapPartition, notToEmitAlterDDLArray, objDoc, objectName, objElm, param

Constructor Summary

CommentObject()
Constructor.

CommentObject(Parameters param, XDFLogger logger)
Constructor with arguments.

Method Summary

void	addToCommentBuffer(java.lang.String st) Add the statement to the comment buffer.
java.util.HashMap	compareColumnComments(java.lang.String tableName)
java.lang.String	compareTableComment(java.lang.String tableName)
boolean	executeCommentSt() Execute the comment PL/SQL statements.
java.lang.String	formComment(java.lang.String type, java.lang.String objectName, java.lang.String desc) Form the comment statement for either table or column.
protected java.util.Hashtable	getAlterXMLParameters() Get the alter XML parameters.
protected java.lang.String	getAlterXMLXSLFile() Dummy method.
protected java.util.HashMap	getClauseTypeNotToEmit() Dummy Method.
protected java.util.Hashtable	getCreateDDLParameters() Dummy method.
java.lang.String	getCreateDDLToExecute(oracle.xml.parser.v2.XMLDocumentFragment inXMLDocFrgmt) Get the create DDL to execute.
protected java.lang.String	getCreateDDLXSLFile() Dummy method.
protected void	getDataFromSXML(oracle.xml.parser.v2.XMLElement inXmlElm) Dummy method.
protected void	getDataFromTargetDB(java.sql.ResultSet rset) Dummy method.
protected java.util.Hashtable	getRemapParameters() Dummy method.
protected java.lang.String	getRemapXSLFile() Dummy method.
protected java.lang.String	prepareObjectQuery(java.util.ArrayList arguments) Prepare the query statement.
void	setLogger(XDFLogger logger) Set Logger if not set before
void	setParam(Parameters param) Set parameter if not set for this object before.
oracle.xml.parser.v2.XMLDocumentFragment	validateDDL(oracle.xml.parser.v2.XMLDocumentFragment alterXML) Dummy method.

Methods inherited from class oracle.apps.fnd.applxdf.comp.DBObject

checkTargetDBObjectExists, executeDDLStmt, getAlterDDLArrayToExecute, getAlterXML, getCreateDDLToExecute, getDependentDiffDocument, getDiffDocument, getObjectName, getTableSpaceType, getTargetTableSpaceName, isIndexExists, isObjectObsolete, readInputSXML, remapSXML, setObjDoc, setObjectName, setObjElm, stripRowTag

Methods inherited from class java.lang.Object

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

Constructor Detail

CommentObject

public CommentObject()

Constructor.

CommentObject

public CommentObject(Parameters param,
                     XDFLogger logger)

Constructor with arguments.

Parameters:

param - Parameters instance

logger - XDFLogger instance

Method Detail

setParam

public void setParam(Parameters param)

Set parameter if not set for this object before.

Parameters:

param -

setLogger

public void setLogger(XDFLogger logger)

Set Logger if not set before

Parameters:

logger -

getDataFromSXML

protected void getDataFromSXML(oracle.xml.parser.v2.XMLElement inXmlElm)

Dummy method. Get the data from the XML Element

Specified by:

getDataFromSXML in class DBObject

Parameters:

inXmlElm - XML Element

prepareObjectQuery

protected java.lang.String prepareObjectQuery(java.util.ArrayList arguments)

Prepare the query statement.

Specified by:

prepareObjectQuery in class DBObject

Parameters:

arguments - arguments associated with the query statement

Returns:

query statement

getDataFromTargetDB

protected void getDataFromTargetDB(java.sql.ResultSet rset)

Dummy method. Get the data from target db

Specified by:

getDataFromTargetDB in class DBObject

Parameters:

rset - resultset from the query

getRemapXSLFile

protected java.lang.String getRemapXSLFile()

Dummy method. Get the remap XSL file

Specified by:

getRemapXSLFile in class DBObject

Returns:

remap XSL file string

getRemapParameters

protected java.util.Hashtable getRemapParameters()

Dummy method. Get the remap parameters

Specified by:

getRemapParameters in class DBObject

Returns:

remap parameters hashtable

getCreateDDLXSLFile

protected java.lang.String getCreateDDLXSLFile()

Dummy method. Get the create DDL XSL file

Specified by:

getCreateDDLXSLFile in class DBObject

Returns:

create DDL XSL file string

getCreateDDLParameters

protected java.util.Hashtable getCreateDDLParameters()

Dummy method. Get the create DDL parameters

Specified by:

getCreateDDLParameters in class DBObject

Returns:

create DDL parameters hashtable

getAlterXMLXSLFile

protected java.lang.String getAlterXMLXSLFile()

Dummy method. Get the alter XML XSL file

Specified by:

getAlterXMLXSLFile in class DBObject

Returns:

alter XML XSL file string

getAlterXMLParameters

protected java.util.Hashtable getAlterXMLParameters()

Get the alter XML parameters.

Overrides:

getAlterXMLParameters in class DBObject

Returns:

alter XML parameters

validateDDL

public oracle.xml.parser.v2.XMLDocumentFragment validateDDL(oracle.xml.parser.v2.XMLDocumentFragment alterXML)

Dummy method. Validate DDL in the alter XMLDocumentFragment

Specified by:

validateDDL in class DBObject

Parameters:

alterXML - alter XMLDocumentFragment

Returns:

validated XMLDocumentFragment

getCreateDDLToExecute

public java.lang.String getCreateDDLToExecute(oracle.xml.parser.v2.XMLDocumentFragment inXMLDocFrgmt)

Get the create DDL to execute.

Overrides:

getCreateDDLToExecute in class DBObject

Parameters:

inXMLDocFrgmt - XML Document to extract the create DDL

Returns:

the create DDL string

getClauseTypeNotToEmit

protected java.util.HashMap getClauseTypeNotToEmit()

Dummy Method. Get the clause type not to emit

Specified by:

getClauseTypeNotToEmit in class DBObject

Returns:

cluase type hashmap not to emit

addToCommentBuffer

public void addToCommentBuffer(java.lang.String st)

Add the statement to the comment buffer.

Parameters:

st - statement string

formComment

public java.lang.String formComment(java.lang.String type,
                                    java.lang.String objectName,
                                    java.lang.String desc)

Form the comment statement for either table or column.

Parameters:

type - talbe or column

objectName - object name

desc - description

Returns:

the statement

executeCommentSt

public boolean executeCommentSt()
                         throws java.lang.Exception

Execute the comment PL/SQL statements.

Returns:

true if success

Throws:

java.lang.Exception - when closing the statement or connection

compareTableComment

public java.lang.String compareTableComment(java.lang.String tableName)
                                     throws java.lang.Exception

Throws:

java.lang.Exception

compareColumnComments

public java.util.HashMap compareColumnComments(java.lang.String tableName)
                                        throws java.lang.Exception

Throws:

java.lang.Exception