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	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	TABLE_DIR
static java.lang.String	WS_REGISTRY_DIR

Constructor Summary

Constructors

Constructor and Description
SQLConverter()

Method Summary

Methods

Modifier and Type	Method and Description
java.lang.String	convertArtifacts(java.lang.String data) Get parent tables name
java.lang.String	convertBYOSArtifacts(java.lang.String data) Get parent tables name
void	convertData(java.lang.String data) Get parent tables name
java.lang.String	convertInteraction(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
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	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) 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
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	writeDBCUI(java.io.PrintStream out, SQLConverterUtil util, int numLines, InteractionInfo interactionInfo, boolean addHeader) Build where clases to set to DM packge
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

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

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

Constructor Detail

SQLConverter

public SQLConverter()

Method Detail

convertData

public void convertData(java.lang.String data)
                 throws MXException,
                        java.rmi.RemoteException

Get parent tables name

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

convertArtifacts

public java.lang.String convertArtifacts(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

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

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

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