psdi.iface.util

Class SQLConverter

java.lang.Object

psdi.iface.util.SQLConverter

public class SQLConverter
extends java.lang.Object

SQL Generator.

Version:

1.0 01/28/2008

Author:

Boris Dozortsev

Field Summary

Fields

Modifier and Type	Field and Description
static java.lang.String	END_POINT_DIR
static java.lang.String	ENTERPRICE_SERVICE_DIR
static java.lang.String	EXTERNAL_SYSTEM_DIR
static java.lang.String	INVOKE_CHANNEL_DIR
static java.lang.String	JSON_MAP_DIR
static java.lang.String	JSON_RESOURCE_DIR
static java.lang.String	MEA_DIR
static java.lang.String	OS_DIR
static java.lang.String	OSLC_RESOURCE_DIR
static java.lang.String	PUBLISH_CHANNEL_DIR
static java.lang.String	RECORD_DIR
static java.lang.String	SCRIPT_DIR
static java.lang.String	TABLE_DIR
static java.lang.String	TENANT_DIR
static java.lang.String	WORKCENTER_DIR
static java.lang.String	WS_REGISTRY_DIR

Constructor Summary

Constructors

Constructor and Description
SQLConverter()

Method Summary

Modifier and Type	Method and Description
byte[]	convert(java.util.Map<java.lang.String,java.lang.String[]> queryParams, UserInfo userInfo)
java.lang.String	convertArtifacts(java.lang.String data) Get parent tables name
java.lang.String	convertBYOSArtifacts(java.lang.String data) Get parent tables name
byte[]	convertData(java.lang.String data) Get parent tables name
byte[]	convertData(java.lang.String data, java.sql.Connection con, java.lang.String schemaOwner) Get parent tables name
byte[]	convertData(java.lang.String data, UserInfo userInfo) Get parent tables name
java.lang.String	convertInteraction(java.lang.String data) Get parent tables name
java.lang.String	convertJSONMap(java.lang.String data) Get parent tables name
java.lang.String	convertJSONResource(java.lang.String data) Get parent tables name
java.lang.String	convertMEAArtifacts(java.lang.String data) Get parent tables name
java.lang.String	convertTable(java.lang.String data) Get parent tables name
java.lang.String	convertTenant(java.lang.String data) Get parent tables name
java.lang.String	recordEnd(java.lang.String rest) Build where clases to set to DM packge
void	recordStart() Build where clases to set to DM packge
int	writeDBCEndPoint(java.io.PrintStream out, SQLConverterUtil util, int numLines, java.lang.String name) Build where clases to set to DM packge
int	writeDBCEnterpriseService(java.io.PrintStream out, SQLConverterUtil util, int numLines, java.lang.String name, java.lang.String extSystem) Build where clases to set to DM packge
int	writeDBCExternalSystem(java.io.PrintStream out, SQLConverterUtil util, int numLines, java.lang.String name) Build where clases to set to DM packge
void	writeDBCInteraction(java.io.PrintStream out, SQLConverterUtil util, int numLines, java.lang.String name) Build where clases to set to DM packge
int	writeDBCInteractionMap(java.io.PrintStream out, SQLConverterUtil util, int numLines, InteractionInfo interactionInfo) Build where clases to set to DM packge
int	writeDBCInvokeChannel(java.io.PrintStream out, SQLConverterUtil util, int numLines, java.lang.String name) Build where clases to set to DM packge
int	writeDBCJSONMap(java.io.PrintStream out, SQLConverterUtil util, int numLines) Build where clases to set to DM packge
int	writeDBCJSONResource(java.io.PrintStream out, SQLConverterUtil util, int numLines, java.lang.String whereClause, java.lang.String resourceType) Build where clases to set to DM packge
int	writeDBCObjects(java.io.PrintStream out, SQLConverterUtil util, int numLines, InteractionInfo interactionInfo) Build where clases to set to DM packge
int	writeDBCObjectStructure(java.io.PrintStream out, SQLConverterUtil util, int numLines, java.lang.String whereClause, java.lang.String grantApp) Build where clases to set to DM packge
int	writeDBCOslcResource(java.io.PrintStream out, SQLConverterUtil util, int numLines, java.lang.String whereClause) Build where clases to set to DM packge
void	writeDBCOSWorkCenter(java.lang.String input) Build where clases to set to DM packge
void	writeDBCOSWorkCenterAuth(java.lang.String osString, java.lang.String workCenter, java.lang.String groupName, java.lang.String dir, boolean addWCAuth) Build where clases to set to DM packge
int	writeDBCPublishChannel(java.io.PrintStream out, SQLConverterUtil util, int numLines, java.lang.String name, java.lang.String extSystem) Build where clases to set to DM packge
int	writeDBCRules(java.io.PrintStream out, SQLConverterUtil util, int numLines, java.lang.String name, java.lang.String useWith) Build where clases to set to DM packge
int	writeDBCScript(java.io.PrintStream out, SQLConverterUtil util, int numLines, java.lang.String whereClause) Build where clases to set to DM packge
int	writeDBCUI(java.io.PrintStream out, SQLConverterUtil util, int numLines, InteractionInfo interactionInfo, boolean addHeader) Build where clases to set to DM packge
java.lang.String	writeDBCWorkCenter(java.lang.String data) Get parent tables name
void	writeDBCWorkCenterAuth(java.lang.String workCenter, java.lang.String groupName, java.util.List<org.jdom.Element> groupData) Get parent tables name
void	writeDBCWorkCenterGroup(java.lang.String workCenter, java.lang.String groupName, java.lang.String description) Get parent tables name
void	writeDBCWorkCenterUser(java.lang.String workCenter, java.lang.String groupName, java.lang.String userId) Get parent tables name
int	writeDBCWSRegistry(java.io.PrintStream out, SQLConverterUtil util, int numLines, java.lang.String name) Build where clases to set to DM packge

Methods inherited from class java.lang.Object

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

Field Detail

OS_DIR

public static final java.lang.String OS_DIR

See Also:

Constant Field Values

WORKCENTER_DIR

public static final java.lang.String WORKCENTER_DIR

See Also:

Constant Field Values

MEA_DIR

public static final java.lang.String MEA_DIR

See Also:

Constant Field Values

TABLE_DIR

public static final java.lang.String TABLE_DIR

See Also:

Constant Field Values

PUBLISH_CHANNEL_DIR

public static final java.lang.String PUBLISH_CHANNEL_DIR

See Also:

Constant Field Values

SCRIPT_DIR

public static final java.lang.String SCRIPT_DIR

See Also:

Constant Field Values

INVOKE_CHANNEL_DIR

public static final java.lang.String INVOKE_CHANNEL_DIR

See Also:

Constant Field Values

ENTERPRICE_SERVICE_DIR

public static final java.lang.String ENTERPRICE_SERVICE_DIR

See Also:

Constant Field Values

END_POINT_DIR

public static final java.lang.String END_POINT_DIR

See Also:

Constant Field Values

WS_REGISTRY_DIR

public static final java.lang.String WS_REGISTRY_DIR

See Also:

Constant Field Values

EXTERNAL_SYSTEM_DIR

public static final java.lang.String EXTERNAL_SYSTEM_DIR

See Also:

Constant Field Values

OSLC_RESOURCE_DIR

public static final java.lang.String OSLC_RESOURCE_DIR

See Also:

Constant Field Values

JSON_RESOURCE_DIR

public static final java.lang.String JSON_RESOURCE_DIR

See Also:

Constant Field Values

JSON_MAP_DIR

public static final java.lang.String JSON_MAP_DIR

See Also:

Constant Field Values

RECORD_DIR

public static final java.lang.String RECORD_DIR

See Also:

Constant Field Values

TENANT_DIR

public static final java.lang.String TENANT_DIR

See Also:

Constant Field Values

Constructor Detail

SQLConverter

public SQLConverter()

Method Detail

convert

public byte[] convert(java.util.Map<java.lang.String,java.lang.String[]> queryParams,
                      UserInfo userInfo)
               throws MXException,
                      java.rmi.RemoteException

Throws:

MXException

java.rmi.RemoteException

convertData

public byte[] convertData(java.lang.String data)
                   throws MXException,
                          java.rmi.RemoteException

Get parent tables name

Returns:

name of the parent table

Throws:

MXException - Maximo Exception

java.rmi.RemoteException - Remote Exception

convertData

public byte[] convertData(java.lang.String data,
                          UserInfo userInfo)
                   throws MXException,
                          java.rmi.RemoteException

Get parent tables name

Returns:

name of the parent table

Throws:

MXException - Maximo Exception

java.rmi.RemoteException - Remote Exception

convertData

public byte[] convertData(java.lang.String data,
                          java.sql.Connection con,
                          java.lang.String schemaOwner)
                   throws MXException,
                          java.rmi.RemoteException

Get parent tables name

Returns:

name of the parent table

Throws:

MXException - Maximo Exception

java.rmi.RemoteException - Remote Exception

convertInteraction

public java.lang.String convertInteraction(java.lang.String data)
                                    throws java.lang.Exception

Get parent tables name

Returns:

name of the parent table

Throws:

MXException - Maximo Exception

java.rmi.RemoteException - Remote Exception

java.lang.Exception

convertJSONResource

public java.lang.String convertJSONResource(java.lang.String data)
                                     throws java.lang.Exception

Get parent tables name

Returns:

name of the parent table

Throws:

MXException - Maximo Exception

java.rmi.RemoteException - Remote Exception

java.lang.Exception

convertJSONMap

public java.lang.String convertJSONMap(java.lang.String data)
                                throws java.lang.Exception

Get parent tables name

Returns:

name of the parent table

Throws:

MXException - Maximo Exception

java.rmi.RemoteException - Remote Exception

java.lang.Exception

convertArtifacts

public java.lang.String convertArtifacts(java.lang.String data)
                                  throws MXException

Get parent tables name

Returns:

name of the parent table

Throws:

MXException - Maximo Exception

java.rmi.RemoteException - Remote Exception

convertMEAArtifacts

public java.lang.String convertMEAArtifacts(java.lang.String data)
                                     throws java.lang.Exception

Get parent tables name

Returns:

name of the parent table

Throws:

MXException - Maximo Exception

java.rmi.RemoteException - Remote Exception

java.lang.Exception

convertTable

public java.lang.String convertTable(java.lang.String data)
                              throws java.lang.Exception

Get parent tables name

Returns:

name of the parent table

Throws:

MXException - Maximo Exception

java.rmi.RemoteException - Remote Exception

java.lang.Exception

writeDBCObjects

public int writeDBCObjects(java.io.PrintStream out,
                           SQLConverterUtil util,
                           int numLines,
                           InteractionInfo interactionInfo)
                    throws java.lang.Exception

Build where clases to set to DM packge

Parameters:

out - print stream

Returns:

number of lines

Throws:

MXException - Maximo Exception

java.rmi.RemoteException - Remote Exception

java.lang.Exception

writeDBCUI

public int writeDBCUI(java.io.PrintStream out,
                      SQLConverterUtil util,
                      int numLines,
                      InteractionInfo interactionInfo,
                      boolean addHeader)
               throws java.lang.Exception

Build where clases to set to DM packge

Parameters:

out - print stream

Returns:

map of where clases

Throws:

MXException - Maximo Exception

java.rmi.RemoteException - Remote Exception

java.lang.Exception

writeDBCPublishChannel

public int writeDBCPublishChannel(java.io.PrintStream out,
                                  SQLConverterUtil util,
                                  int numLines,
                                  java.lang.String name,
                                  java.lang.String extSystem)
                           throws java.lang.Exception

Build where clases to set to DM packge

Parameters:

out - print stream

Returns:

map of where clases

Throws:

MXException - Maximo Exception

java.rmi.RemoteException - Remote Exception

java.lang.Exception

writeDBCEnterpriseService

public int writeDBCEnterpriseService(java.io.PrintStream out,
                                     SQLConverterUtil util,
                                     int numLines,
                                     java.lang.String name,
                                     java.lang.String extSystem)
                              throws java.lang.Exception

Build where clases to set to DM packge

Parameters:

out - print stream

Returns:

map of where clases

Throws:

MXException - Maximo Exception

java.rmi.RemoteException - Remote Exception

java.lang.Exception

writeDBCRules

public int writeDBCRules(java.io.PrintStream out,
                         SQLConverterUtil util,
                         int numLines,
                         java.lang.String name,
                         java.lang.String useWith)
                  throws java.lang.Exception

Build where clases to set to DM packge

Parameters:

out - print stream

Returns:

map of where clases

Throws:

MXException - Maximo Exception

java.rmi.RemoteException - Remote Exception

java.lang.Exception

writeDBCEndPoint

public int writeDBCEndPoint(java.io.PrintStream out,
                            SQLConverterUtil util,
                            int numLines,
                            java.lang.String name)
                     throws java.lang.Exception

Build where clases to set to DM packge

Parameters:

out - print stream

Returns:

map of where clases

Throws:

MXException - Maximo Exception

java.rmi.RemoteException - Remote Exception

java.lang.Exception

writeDBCInvokeChannel

public int writeDBCInvokeChannel(java.io.PrintStream out,
                                 SQLConverterUtil util,
                                 int numLines,
                                 java.lang.String name)
                          throws java.lang.Exception

Build where clases to set to DM packge

Parameters:

out - print stream

Returns:

map of where clases

Throws:

MXException - Maximo Exception

java.rmi.RemoteException - Remote Exception

java.lang.Exception

writeDBCExternalSystem

public int writeDBCExternalSystem(java.io.PrintStream out,
                                  SQLConverterUtil util,
                                  int numLines,
                                  java.lang.String name)
                           throws java.lang.Exception

Build where clases to set to DM packge

Parameters:

out - print stream

Returns:

map of where clases

Throws:

MXException - Maximo Exception

java.rmi.RemoteException - Remote Exception

java.lang.Exception

writeDBCWSRegistry

public int writeDBCWSRegistry(java.io.PrintStream out,
                              SQLConverterUtil util,
                              int numLines,
                              java.lang.String name)
                       throws java.lang.Exception

Build where clases to set to DM packge

Parameters:

out - print stream

Returns:

map of where clases

Throws:

MXException - Maximo Exception

java.rmi.RemoteException - Remote Exception

java.lang.Exception

writeDBCObjectStructure

public int writeDBCObjectStructure(java.io.PrintStream out,
                                   SQLConverterUtil util,
                                   int numLines,
                                   java.lang.String whereClause,
                                   java.lang.String grantApp)
                            throws java.lang.Exception

Build where clases to set to DM packge

Parameters:

out - print stream

Returns:

map of where clases

Throws:

MXException - Maximo Exception

java.rmi.RemoteException - Remote Exception

java.lang.Exception

writeDBCOslcResource

public int writeDBCOslcResource(java.io.PrintStream out,
                                SQLConverterUtil util,
                                int numLines,
                                java.lang.String whereClause)
                         throws java.lang.Exception

Build where clases to set to DM packge

Parameters:

out - print stream

Returns:

map of where clases

Throws:

MXException - Maximo Exception

java.rmi.RemoteException - Remote Exception

java.lang.Exception

writeDBCScript

public int writeDBCScript(java.io.PrintStream out,
                          SQLConverterUtil util,
                          int numLines,
                          java.lang.String whereClause)
                   throws java.lang.Exception

Build where clases to set to DM packge

Parameters:

out - print stream

Returns:

map of where clases

Throws:

MXException - Maximo Exception

java.rmi.RemoteException - Remote Exception

java.lang.Exception

writeDBCJSONResource

public int writeDBCJSONResource(java.io.PrintStream out,
                                SQLConverterUtil util,
                                int numLines,
                                java.lang.String whereClause,
                                java.lang.String resourceType)
                         throws java.lang.Exception

Build where clases to set to DM packge

Parameters:

out - print stream

Returns:

map of where clases

Throws:

MXException - Maximo Exception

java.rmi.RemoteException - Remote Exception

java.lang.Exception

writeDBCJSONMap

public int writeDBCJSONMap(java.io.PrintStream out,
                           SQLConverterUtil util,
                           int numLines)
                    throws java.lang.Exception

Build where clases to set to DM packge

Parameters:

out - print stream

Returns:

map of where clases

Throws:

MXException - Maximo Exception

java.rmi.RemoteException - Remote Exception

java.lang.Exception

convertBYOSArtifacts

public java.lang.String convertBYOSArtifacts(java.lang.String data)
                                      throws java.lang.Exception

Get parent tables name

Returns:

name of the parent table

Throws:

MXException - Maximo Exception

java.rmi.RemoteException - Remote Exception

java.lang.Exception

convertTenant

public java.lang.String convertTenant(java.lang.String data)
                               throws java.lang.Exception

Get parent tables name

Returns:

name of the parent table

Throws:

MXException - Maximo Exception

java.rmi.RemoteException - Remote Exception

java.lang.Exception

writeDBCInteractionMap

public int writeDBCInteractionMap(java.io.PrintStream out,
                                  SQLConverterUtil util,
                                  int numLines,
                                  InteractionInfo interactionInfo)
                           throws java.lang.Exception

Build where clases to set to DM packge

Parameters:

defName - DM package definition name

Returns:

number of lines

Throws:

MXException - Maximo Exception

java.rmi.RemoteException - Remote Exception

java.lang.Exception

writeDBCInteraction

public void writeDBCInteraction(java.io.PrintStream out,
                                SQLConverterUtil util,
                                int numLines,
                                java.lang.String name)
                         throws java.lang.Exception

Build where clases to set to DM packge

Parameters:

defName - DM package definition name

Throws:

MXException - Maximo Exception

java.rmi.RemoteException - Remote Exception

java.lang.Exception

writeDBCWorkCenter

public java.lang.String writeDBCWorkCenter(java.lang.String data)
                                    throws java.lang.Exception

Get parent tables name

Returns:

name of the parent table

Throws:

MXException - Maximo Exception

java.rmi.RemoteException - Remote Exception

java.lang.Exception

writeDBCOSWorkCenter

public void writeDBCOSWorkCenter(java.lang.String input)
                          throws java.lang.Exception

Build where clases to set to DM packge

Parameters:

defName - DM package definition name

Throws:

MXException - Maximo Exception

java.rmi.RemoteException - Remote Exception

java.lang.Exception

writeDBCOSWorkCenterAuth

public void writeDBCOSWorkCenterAuth(java.lang.String osString,
                                     java.lang.String workCenter,
                                     java.lang.String groupName,
                                     java.lang.String dir,
                                     boolean addWCAuth)
                              throws java.lang.Exception

Build where clases to set to DM packge

Parameters:

defName - DM package definition name

Throws:

MXException - Maximo Exception

java.rmi.RemoteException - Remote Exception

java.lang.Exception

writeDBCWorkCenterGroup

public void writeDBCWorkCenterGroup(java.lang.String workCenter,
                                    java.lang.String groupName,
                                    java.lang.String description)
                             throws java.lang.Exception

Get parent tables name

Throws:

MXException - Maximo Exception

java.rmi.RemoteException - Remote Exception

java.lang.Exception

writeDBCWorkCenterUser

public void writeDBCWorkCenterUser(java.lang.String workCenter,
                                   java.lang.String groupName,
                                   java.lang.String userId)
                            throws java.lang.Exception

Get parent tables name

Throws:

MXException - Maximo Exception

java.rmi.RemoteException - Remote Exception

java.lang.Exception

writeDBCWorkCenterAuth

public void writeDBCWorkCenterAuth(java.lang.String workCenter,
                                   java.lang.String groupName,
                                   java.util.List<org.jdom.Element> groupData)
                            throws java.lang.Exception

Get parent tables name

Throws:

MXException - Maximo Exception

java.rmi.RemoteException - Remote Exception

java.lang.Exception

recordStart

public void recordStart()
                 throws java.lang.Exception

Build where clases to set to DM packge

Parameters:

defName - DM package definition name

Throws:

MXException - Maximo Exception

java.rmi.RemoteException - Remote Exception

java.lang.Exception

recordEnd

public java.lang.String recordEnd(java.lang.String rest)
                           throws java.lang.Exception

Build where clases to set to DM packge

Parameters:

defName - DM package definition name

Throws:

MXException - Maximo Exception

java.rmi.RemoteException - Remote Exception

java.lang.Exception