psdi.configure

Class SysDataElementSYNONYMDOMAIN

java.lang.Object

org.jdom.Content

org.jdom.Element

psdi.configure.SysDataElement

psdi.configure.SysDataElementSYNONYMDOMAIN

All Implemented Interfaces:

java.io.Serializable, java.lang.Cloneable, org.jdom.Parent, UpgConstants

public class SysDataElementSYNONYMDOMAIN
extends SysDataElement
implements UpgConstants

Element to represent the SynonymDomain table in the XML file that is output by BuildUpgMetadata and input to Upgrade. This is an extension of psdi.configure.SysDataElement.

SysDataElementSYNONYMDOMAIN is instanciated by the following:

• When writing XML (BuildUpgMetadata), instanciated from compareSystemData. The constructor will populate the SysDataElementSYNONYMDOMAIN object appropriately.
• When reading XML (Upgrade), instanciated from ConfigXMLFactory, via Upgrade. The SysDataElementSYNONYMDOMAIN method getSql returns sql statements for populating the data tables appropriately, after having run ConfigDB.

Multisite functionality is handled by the presence or absence of siteid/orgid in the primary unique index.

The default processing in SysDataElementSYNONYMDOMAIN presumes that the columns in the primary unique index have not changed from the old to the new database. If the index has changed, this class will have to be extended, with the new instance residing in the subdirectory with the old database name. For example, if the key to the table changed after 5.2, you will need a class psdi.configure.V520.SysDataElementSYNONYMDOMAIN. The extension can then perform the processing needed to support the key structure conversion between specific releases.

See Also:

SysDataElement, psdi.upgrade.BuildUpgMetadata, psdi.upgrade.Upgrade, Serialized Form

Field Summary

Fields inherited from class psdi.configure.SysDataElement

codeElements, con, doNotUpdateCols, keyCols, newCol, newData, newDataOldKeys, oldCol, oldData, orgidKey, orgs, siteidKey, sites, sNo, status, sYes, tbname, util

Fields inherited from interface psdi.configure.UpgConstants

DB2, doNotUpdateACTION, doNotUpdateALNDOMAIN, doNotUpdateAPPLICATIONAUTH, doNotUpdateAUTOKEY, doNotUpdateCONDITION, doNotUpdateCONTRACTPROPERTY, doNotUpdateCONTRACTTYPE, doNotUpdateCROSSOVERDOMAIN, doNotUpdateDOCTYPES, doNotUpdateLANGUAGE, doNotUpdateMAXAPPS, doNotUpdateMAXCONDDETAIL, doNotUpdateMAXCONTROLVALUE, doNotUpdateMAXDOMAIN, doNotUpdateMAXLOGAPPENDER, doNotUpdateMAXLOGGER, doNotUpdateMAXMENU, doNotUpdateMAXMESSAGES, doNotUpdateMAXMODULES, doNotUpdateMAXPROP, doNotUpdateMAXPROPVALUE, doNotUpdateMAXROLE, doNotUpdateMAXSEQUENCE, doNotUpdateMAXSERSECURITY, doNotUpdateMAXSERVICE, doNotUpdateMAXTABLEDOMAIN, doNotUpdateMAXVARS, doNotUpdateMAXVARTYPE, doNotUpdateMXCOLLAB, doNotUpdateMXCOLLABREF, doNotUpdateNUMERICDOMAIN, doNotUpdateNUMRANGEDOMAIN, doNotUpdatePORTLET, doNotUpdatePRICALC, doNotUpdateSECURITYRESTRICT, doNotUpdateSIGOPTION, doNotUpdateSYNONYMDOMAIN, doNotUpdateTAXTYPE, doNotUpdateWORKPRIORITY, doNotUpdateWORKTYPE, doNotUpdateWPEDITSETTING, messageCache, NEWONLY, OLDANDNEW, OLDONLY, ORACLE, SQLINET, SQLMICROSOFT, SQLSERVER, SYSDATATABLES, SYSTEMTABLES, UNKNOWN

Constructor Summary

Constructors

Constructor and Description
SysDataElementSYNONYMDOMAIN()
SysDataElementSYNONYMDOMAIN(java.lang.String name)
SysDataElementSYNONYMDOMAIN(java.lang.String name, org.jdom.Namespace namespace)
SysDataElementSYNONYMDOMAIN(java.lang.String name, java.lang.String uri)
SysDataElementSYNONYMDOMAIN(java.lang.String name, java.lang.String prefix, java.lang.String uri)
SysDataElementSYNONYMDOMAIN(java.lang.String tbname, java.util.TreeMap newCol, java.util.TreeMap oldCol, java.util.TreeMap newData, java.util.TreeMap oldData, java.util.TreeMap newDataOldKeys, java.util.TreeMap keyCols, java.io.File codefile) This constructor is used when creating a new Element for the purpose of writing out XML.

Method Summary

Modifier and Type	Method and Description
void	addOneRow(java.lang.String key, java.util.HashMap newVals) When generating XML, and the column exists only in the new database, this method is used to add its attributes.
void	buildFromHashMaps() When generating XML, given the TreeMaps newData and oldData, build the elements needed to be output from BuildUpgMetadata.
java.util.ArrayList	compareRows(org.jdom.Element row, java.util.TreeMap colsColno) When reading XML, this method determines what updates or inserts are needed.
void	compareRows(java.lang.String key, java.util.HashMap newVals, java.util.HashMap oldVals) When generating XML, and the key exists both the new and old database, this method is used to compare and add its attributes to this SysDataElementSYNONYMDOMAIN, when the values are different.
java.util.ArrayList	deleteRow(org.jdom.Element row) When reading XML, and the row needs to be deleted from the customer's database, return the sql statement for deleting the row.
java.util.ArrayList	getDeleteSql(java.lang.String tbname, java.sql.Connection con, Util util, java.util.TreeMap oldCol, java.util.TreeMap keyCols) When reading XML, return a series of sql statements to update the customer's database.
java.util.ArrayList	getSql(java.lang.String tbname, java.sql.Connection con, Util util, java.util.TreeMap oldCol, java.util.TreeMap keyCols) When reading XML, return a series of sql statements to update the customer's database.
java.lang.String	getWhereClause(org.jdom.Element row, boolean useSiteOrg, java.lang.String siteid, java.lang.String orgid) When reading XML, generate the Where clause to use in a Sql statement (for delete or update).
boolean	haveDup(org.jdom.Element checkEl) When generating XML, before adding an element, check to see if we already have a duplicate.
java.util.ArrayList	insertRow(org.jdom.Element row, java.lang.String siteid, java.lang.String orgid) When reading XML, and the row needs to be added to the customer's database, this method returns the Sql statement for inserting the row.
void	removeOneRow(java.lang.String key, java.util.HashMap oldVals) When generating XML, and the column exists only in the old database, this method is used to indicate its removal.
void	setKeyAttributes(org.jdom.Element row, java.util.HashMap rowValues) When generating XML, create attributes where name = column name and value = column value, for each column in the primary unique index.
java.util.ArrayList	updateRow(org.jdom.Element row, java.util.HashMap currentData, java.lang.String siteid, java.lang.String orgid) When reading XML, and the row needs to be updated on the customer's database, this method returns the Sql statement for updating the row.

Methods inherited from class psdi.configure.SysDataElement

addCodes, addCodesExtension, canUpdateColumn, deleteRowExtension, domainInUse, executeQuery, getAttribute, getChunkUpdates, getKeys, getMaxReserved, getNextVal, getSequenceName, getStatus, getTableName, getUpgCodesElement, initSequence, insertRowExtension, isUniqueColumnID, loadDoNotUpdateCols, scanKeyCols, setStatus, setTableName, setUpgCodes, updateRowExtension

Methods inherited from class org.jdom.Element

addContent, addContent, addContent, addContent, addContent, addNamespaceDeclaration, clone, cloneContent, getAdditionalNamespaces, getAttribute, getAttribute, getAttributes, getAttributeValue, getAttributeValue, getAttributeValue, getAttributeValue, getChild, getChild, getChildren, getChildren, getChildren, getChildText, getChildText, getChildTextNormalize, getChildTextNormalize, getChildTextTrim, getChildTextTrim, getContent, getContent, getContent, getContentSize, getDescendants, getDescendants, getName, getNamespace, getNamespace, getNamespacePrefix, getNamespaceURI, getQualifiedName, getText, getTextNormalize, getTextTrim, getValue, indexOf, isAncestor, isRootElement, removeAttribute, removeAttribute, removeAttribute, removeChild, removeChild, removeChildren, removeChildren, removeContent, removeContent, removeContent, removeContent, removeNamespaceDeclaration, setAttribute, setAttribute, setAttribute, setAttributes, setAttributes, setContent, setContent, setContent, setContent, setName, setNamespace, setText, toString

Methods inherited from class org.jdom.Content

detach, equals, getDocument, getParent, getParentElement, hashCode

Methods inherited from class java.lang.Object

getClass, notify, notifyAll, wait, wait, wait

Methods inherited from interface org.jdom.Parent

getDocument, getParent

Constructor Detail

SysDataElementSYNONYMDOMAIN

public SysDataElementSYNONYMDOMAIN()

SysDataElementSYNONYMDOMAIN

public SysDataElementSYNONYMDOMAIN(java.lang.String name,
                                   org.jdom.Namespace namespace)

SysDataElementSYNONYMDOMAIN

public SysDataElementSYNONYMDOMAIN(java.lang.String name)

SysDataElementSYNONYMDOMAIN

public SysDataElementSYNONYMDOMAIN(java.lang.String name,
                                   java.lang.String uri)

SysDataElementSYNONYMDOMAIN

public SysDataElementSYNONYMDOMAIN(java.lang.String name,
                                   java.lang.String prefix,
                                   java.lang.String uri)

SysDataElementSYNONYMDOMAIN

public SysDataElementSYNONYMDOMAIN(java.lang.String tbname,
                                   java.util.TreeMap newCol,
                                   java.util.TreeMap oldCol,
                                   java.util.TreeMap newData,
                                   java.util.TreeMap oldData,
                                   java.util.TreeMap newDataOldKeys,
                                   java.util.TreeMap keyCols,
                                   java.io.File codefile)
                            throws java.lang.Exception

This constructor is used when creating a new Element for the purpose of writing out XML. It calls buildFromHashMaps.

Parameters:

tbname - The name of the table. See tbname.

newCol - The column metadata on this table, from the new database. See newCol.

oldCol - The column metadata on this table, from the old database. See oldCol.

newData - The data from the new database. See newData.

oldData - The data from the old database. See oldData.

keyCols - Key columns for this table. See keyCols.

codeFile - The file UpgCodes.xml that may contain special codes for rows in the table. For SysDataElementSYNONYMDOMAIN this is null.

Throws:

java.lang.Exception

See Also:

SysDataElement.scanKeyCols(), buildFromHashMaps()

Method Detail

buildFromHashMaps

public void buildFromHashMaps()
                       throws java.lang.Exception

Description copied from class: SysDataElement

When generating XML, given the TreeMaps newData and oldData, build the elements needed to be output from BuildUpgMetadata.

Overrides:

buildFromHashMaps in class SysDataElement

Throws:

java.lang.Exception

See Also:

SysDataElement.addOneRow(java.lang.String, java.util.HashMap), SysDataElement.removeOneRow(java.lang.String, java.util.HashMap), SysDataElement.compareRows(String, HashMap, HashMap)

addOneRow

public void addOneRow(java.lang.String key,
                      java.util.HashMap newVals)
               throws java.lang.Exception

When generating XML, and the column exists only in the new database, this method is used to add its attributes.

Overrides:

addOneRow in class SysDataElement

Parameters:

key - The key to this row. Format is described in getData.

newVals - An entry from the newData TreeMap, which specifies the data for this row.

Throws:

java.lang.Exception

See Also:

setKeyAttributes(org.jdom.Element, java.util.HashMap), haveDup(org.jdom.Element), SysDataElement.addCodes(org.jdom.Element, java.lang.String)

removeOneRow

public void removeOneRow(java.lang.String key,
                         java.util.HashMap oldVals)
                  throws java.lang.Exception

When generating XML, and the column exists only in the old database, this method is used to indicate its removal.

Overrides:

removeOneRow in class SysDataElement

Parameters:

key - The key of the row being removed. Columns are delimited by "|". Format is described in getData.

oldVals - An entry from the oldData TreeMap, which specifies the data for this row.

Throws:

java.lang.Exception

See Also:

setKeyAttributes(org.jdom.Element, java.util.HashMap), haveDup(org.jdom.Element)

compareRows

public void compareRows(java.lang.String key,
                        java.util.HashMap newVals,
                        java.util.HashMap oldVals)
                 throws java.lang.Exception

When generating XML, and the key exists both the new and old database, this method is used to compare and add its attributes to this SysDataElementSYNONYMDOMAIN, when the values are different. It expects that both old and new will include the same attribute names (although the values may differ).

Overrides:

compareRows in class SysDataElement

Parameters:

key - The key of the row being compared. Columns are delimited by "|". Format is described in getData.

newVals - An entry from the newData TreeMap, which specifies the data for this row in the new database.

oldVals - An entry from the oldData TreeMap, which specifies the data for this row in the old database.

Throws:

java.lang.Exception

See Also:

SysDataElement.canUpdateColumn(java.lang.String), setKeyAttributes(org.jdom.Element, java.util.HashMap), haveDup(org.jdom.Element), SysDataElement.addCodes(org.jdom.Element, java.lang.String)

setKeyAttributes

public void setKeyAttributes(org.jdom.Element row,
                             java.util.HashMap rowValues)
                      throws java.lang.Exception

When generating XML, create attributes where name = column name and value = column value, for each column in the primary unique index. This uses keyCols.

Overrides:

setKeyAttributes in class SysDataElement

Parameters:

row - The Element representing a particular row in the table.

rowValues - The HashMap of the data values for this row.

Throws:

java.lang.Exception

haveDup

public boolean haveDup(org.jdom.Element checkEl)
                throws java.lang.Exception

When generating XML, before adding an element, check to see if we already have a duplicate. This could occur if we have a multisite database. For example, if we want to add SynonymDomain "ABC" our database may have it for site 1 and site 2. We would want to add only one element specifying to add SynonymDomain "ABC". Such duplicates may be found only when the key includes siteid or orgid.

Overrides:

haveDup in class SysDataElement

Parameters:

checkEl - The element that we've constructed but not yet added.

Returns:

True if this element is a duplicate, else False.

Throws:

java.lang.Exception

getSql

public java.util.ArrayList getSql(java.lang.String tbname,
                                  java.sql.Connection con,
                                  Util util,
                                  java.util.TreeMap oldCol,
                                  java.util.TreeMap keyCols)
                           throws java.lang.Exception

When reading XML, return a series of sql statements to update the customer's database.

• For any other XML status
  • If the row does not currently exist, it will be added.
  • If the row DOES exist, the values will be compared, and any old value not equal to the XML new value will be updated.

Overrides:

getSql in class SysDataElement

Parameters:

tbname - The table name. See tbname.

con - The connection to the database being upgraded. See con.

util - Reference to the Util class. See util.

oldCol - TreeMap of the data structure for the columns on this table (key = column name). (This is retrieved AFTER ConfigDB may have updated the format.) See oldCol.

keyCols - The key columns for this table. See keyCols.

Returns:

Series of sql statements

Throws:

java.lang.Exception

See Also:

SysDataElement.scanKeyCols(), compareRows(Element, TreeMap)

getDeleteSql

public java.util.ArrayList getDeleteSql(java.lang.String tbname,
                                        java.sql.Connection con,
                                        Util util,
                                        java.util.TreeMap oldCol,
                                        java.util.TreeMap keyCols)
                                 throws java.lang.Exception

When reading XML, return a series of sql statements to update the customer's database.

• If the XML status is OLDONLY, the sql will delete from table for that row.

Overrides:

getDeleteSql in class SysDataElement

Parameters:

tbname - The table name. See tbname.

con - The connection to the database being upgraded. See con.

util - Reference to the Util class. See util.

oldCol - TreeMap of the data structure for the columns on this table (key = column name). (This is retrieved AFTER ConfigDB may have updated the format.) See oldCol.

keyCols - The key columns for this table. See keyCols.

Returns:

Series of sql statements

Throws:

java.lang.Exception

See Also:

SysDataElement.scanKeyCols(), deleteRow(org.jdom.Element)

getWhereClause

public java.lang.String getWhereClause(org.jdom.Element row,
                                       boolean useSiteOrg,
                                       java.lang.String siteid,
                                       java.lang.String orgid)
                                throws java.lang.Exception

When reading XML, generate the Where clause to use in a Sql statement (for delete or update). This uses keyCols to identify the names of the key columns.

Overrides:

getWhereClause in class SysDataElement

Parameters:

row - The Element representing a row in the database.

useSiteOrg - If the primary key includes siteid and/or orgid, and this param is True, then the value or siteid/orgid will be included in the Where clause. If this param is False, or the primary key does not contain siteid/orgid, then the Where clause will not have any constraint for siteid/orgid.

siteid - If this is null, and the Where clause includes siteid, the method uses the siteid from the row Element, otherwise it uses the value of this param. If this equals the empty string (""), the Where clause will specify "siteid is null".

orgid - If this is null, and the Where clause includes orgid, the method uses the orgid from the row Element, otherwise it uses the value of this param. If this equals the empty string (""), the Where clause will specify "orgid is null".

Returns:

The Where clause (not including the word "where").

Throws:

java.lang.Exception

compareRows

public java.util.ArrayList compareRows(org.jdom.Element row,
                                       java.util.TreeMap colsColno)
                                throws java.lang.Exception

When reading XML, this method determines what updates or inserts are needed. Called from getSql. Where siteid or orgid exists in the table's key, this method will loop through the customer's sites/orgs and provide appropriate values, potentially generating more than one sql statement per XML row.

Overrides:

compareRows in class SysDataElement

Parameters:

row - The element from the input XML representing a row in the table.

colsColno - The metadata for the columns on the table, key = colno.

Returns:

The sql statements.

Throws:

java.lang.Exception

See Also:

getWhereClause(org.jdom.Element, boolean, java.lang.String, java.lang.String), Util.getData(java.lang.String, java.util.TreeMap, java.lang.String), updateRow(org.jdom.Element, java.util.HashMap, java.lang.String, java.lang.String), insertRow(org.jdom.Element, java.lang.String, java.lang.String)

deleteRow

public java.util.ArrayList deleteRow(org.jdom.Element row)
                              throws java.lang.Exception

When reading XML, and the row needs to be deleted from the customer's database, return the sql statement for deleting the row. Called from getSql.

Overrides:

deleteRow in class SysDataElement

Parameters:

row - The element from the input XML representing a row in this table. This is an ArrayList so that extensions of this class can provide more than one Sql statement if needed, e.g. for parent/child tables.

Returns:

A "delete from..." sql statement. There will be no siteid/orgid condition, so it may delete multiple rows.

Throws:

java.lang.Exception

See Also:

SysDataElement.deleteRowExtension(org.jdom.Element, java.util.ArrayList)

updateRow

public java.util.ArrayList updateRow(org.jdom.Element row,
                                     java.util.HashMap currentData,
                                     java.lang.String siteid,
                                     java.lang.String orgid)
                              throws java.lang.Exception

When reading XML, and the row needs to be updated on the customer's database, this method returns the Sql statement for updating the row. It does NOT update any value for SITEID or ORGID. Called from compareRows.

Overrides:

updateRow in class SysDataElement

Parameters:

row - The element from the input XML representing a row in the table.

currentData - The data currently on the customer's database (one row).

siteid - The siteid to use in the Where clause (if any).

orgid - The orgid to use in the Where clause (if any).

Returns:

An "update ..." sql statement for updating one row. If no columns need to be updated, this will be an empty string. This is an ArrayList so that extensions of this class can provide more than one Sql statement if needed, e.g. for parent/child tables.

Throws:

java.lang.Exception

See Also:

SysDataElement.canUpdateColumn(java.lang.String)

insertRow

public java.util.ArrayList insertRow(org.jdom.Element row,
                                     java.lang.String siteid,
                                     java.lang.String orgid)
                              throws java.lang.Exception

When reading XML, and the row needs to be added to the customer's database, this method returns the Sql statement for inserting the row. Called from compareRows.

Overrides:

insertRow in class SysDataElement

Parameters:

row - The element from the input XML representing a row in the table.

siteid - The siteid to use in the Insert statement (if any).

orgid - The orgid to use in the Insert statement (if any).

Returns:

An "insert into..." sql statement for inserting one row. This is an ArrayList so that extensions of this class can provide more than one Sql statement if needed, e.g. for parent/child tables.

Throws:

java.lang.Exception

See Also:

SysDataElement.insertRowExtension(org.jdom.Element, java.lang.String, java.lang.String, java.util.ArrayList)