oracle.apps.fnd.applxdf.comp
Class TableFKObject

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

public class TableFKObject
extends DBObject

Contains methods to create the Table FK, compare existing Table FK with the defintition in the xml file and generate DDLs statements if possible to map the differences or throw errors

Author:

Guoqiang Su <Guoqiang.Su@oracle.com>, izhang <irene.zhang@oracle.com>

Field Summary

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

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

Constructor Summary

TableFKObject()
Constructor.

TableFKObject(Parameters theParam, XDFLogger theLogger)
Constructor with arguments.

Method Summary

boolean	checkTableExist() Check the table exists or not.
boolean	doCreateDDLConstraints(oracle.xml.parser.v2.XMLElement xElm) Get the create table add constraint DDLs and add to arraylist.
protected java.util.Hashtable	getAlterXMLParameters() Get the alter XML parameters.
protected java.lang.String	getAlterXMLXSLFile() Get the alter XML XSL file.
protected java.util.HashMap	getClauseTypeNotToEmit() Dummy Method.
protected java.util.Hashtable	getCreateDDLParameters() Dummy method.
protected java.lang.String	getCreateDDLXSLFile() Get the create DDL XSL file.
protected void	getDataFromSXML(oracle.xml.parser.v2.XMLElement xmlElm) Get the data from the XML Element.
protected void	getDataFromTargetDB(java.sql.ResultSet rset) Get the data from target db.
java.util.ArrayList	getFKAlterDDLArrayToExecute(oracle.xml.parser.v2.XMLDocumentFragment alterXML) Get multiple FK alter table DDLs to execute from the XML.
boolean	getFKMetaData(oracle.xml.parser.v2.XMLElement tableXmlElm) Get the ISLOGICAL value and Obsolete for FK constraint.
java.lang.String	getPhysicalTableName()
protected java.util.Hashtable	getRemapParameters() Get the remap parameters.
protected java.lang.String	getRemapXSLFile() Get the remap XSL file.
protected oracle.xml.parser.v2.XMLElement	getTableElement(oracle.xml.parser.v2.XMLElement xmlElm) Get the table element.
java.lang.String	getTableName() Get the table name
protected java.lang.String	prepareObjectQuery(java.util.ArrayList arguments) Prepare the query statement.
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, 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

TableFKObject

public TableFKObject()

Constructor.

TableFKObject

public TableFKObject(Parameters theParam,
                     XDFLogger theLogger)

Constructor with arguments.

Parameters:

theParam - Parameters instance

theLogger - XDFLogger instance

Method Detail

getTableElement

protected oracle.xml.parser.v2.XMLElement getTableElement(oracle.xml.parser.v2.XMLElement xmlElm)

Get the table element.

Parameters:

xmlElm - input XMLelement

Returns:

table element

getDataFromSXML

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

Get the data from the XML Element.

Specified by:

getDataFromSXML in class DBObject

Parameters:

xmlElm - XML Element

prepareObjectQuery

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

Prepare the query statement. Dummy method.

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)

Get the data from target db. Dummy method.

Specified by:

getDataFromTargetDB in class DBObject

Parameters:

rset - resultset from the query

getRemapXSLFile

protected java.lang.String getRemapXSLFile()

Get the remap XSL file.

Specified by:

getRemapXSLFile in class DBObject

Returns:

remap XSL file string

getRemapParameters

protected java.util.Hashtable getRemapParameters()

Get the remap parameters.

Specified by:

getRemapParameters in class DBObject

Returns:

remap parameters hashtable

getCreateDDLXSLFile

protected java.lang.String getCreateDDLXSLFile()

Get the create DDL XSL file. Dummy method.

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()

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

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

getFKAlterDDLArrayToExecute

public java.util.ArrayList getFKAlterDDLArrayToExecute(oracle.xml.parser.v2.XMLDocumentFragment alterXML)

Get multiple FK alter table DDLs to execute from the XML.

Parameters:

alterXML - XMLDocumentFragment to extract the alter DDLs

Returns:

the alter DDLs arraylist

getFKMetaData

public boolean getFKMetaData(oracle.xml.parser.v2.XMLElement tableXmlElm)

Get the ISLOGICAL value and Obsolete for FK constraint.

Parameters:

tableXmlElm - input XMLElment

Returns:

false if all the islogical flags for the FKs are Y

doCreateDDLConstraints

public boolean doCreateDDLConstraints(oracle.xml.parser.v2.XMLElement xElm)

Get the create table add constraint DDLs and add to arraylist.

Parameters:

xElm - xml element

Returns:

boolean - if no error return false otherwise true

getTableName

public java.lang.String getTableName()

Get the table name

Returns:

table name

checkTableExist

public boolean checkTableExist()

Check the table exists or not.

Returns:

true if the table exists.

getPhysicalTableName

public java.lang.String getPhysicalTableName()