psdi.app.report

Class ExpressionHelper

java.lang.Object

psdi.app.report.ExpressionHelper

All Implemented Interfaces:

ReportConstants

public class ExpressionHelper
extends java.lang.Object
implements ReportConstants

Nested Class Summary

Nested classes/interfaces inherited from interface psdi.app.report.ReportConstants

ReportConstants.EmailFileTypes, ReportConstants.EmailType, ReportConstants.ReportTypes, ReportConstants.ScheduleType

Field Summary

Fields

Modifier and Type	Field and Description
static java.lang.String[]	MX_DATE_TYPES
static java.lang.String[]	MX_NUMERIC_TYPES

Fields inherited from interface psdi.app.report.ReportConstants

APPHIERARCHY, ATTR_BOUNDARY_CHARS_PATTERN, ATTRIBUTE_BOUNDARY_CHARS, ATTRIBUTENAME, BIRTCTRLTYPE_TEXTBOX, BIRTDATATYPE_DATETIME, BIRTDATATYPE_STRING, DATA_TYPE_DATE_BIRT, DATA_TYPE_DATETIME_BIRT, DATA_TYPE_DECIMAL_BIRT, DATA_TYPE_FLOAT_BIRT, DATA_TYPE_INTEGER_BIRT, DATA_TYPE_STRING_BIRT, DATA_TYPE_TIME_BIRT, DEFAULTVALUE, DISPLAYWHERE, EXPORT_ACTION, EXPORT_ACTION_ALL_REPORTS, EXPORT_ACTION_LIBRARY, EXPORT_ACTION_REPORT, EXPORT_APPNAME, EXPORT_FILENAME, FILTER, GROUP, HIDDEN, INVALID_CHARS, INVALID_CHARS_PATTERN, JDBC_DATE, JDBC_DATETIME, JOIN_RELATION, LABELOVERRIDE, LINK_RELATION, LOOKUP_DATELOOKUP, LOOKUP_YORNLOOKUPLIST, LOOKUPNAME, MULTILOOKUP, OVERLOADED, PARAMDELIMITER, PARAMETERNAME, RELATION_NOT_USED, REPORT_APP_LOGGER, REPORT_CONTEXT_USER_STOPLIMIT, REQUIRED, RPT_STATUS_CANCELLED, RPT_STATUS_FAILED, RPT_STATUS_OK, RPT_STATUS_RECLIMIT, SEQUENCE, SORT, SUPPORTED_EXP_TYPES, THREAD_AVAILABLE, ZERO_CONCURRENT_RUN

Constructor Summary

Constructors

Constructor and Description
ExpressionHelper()

Method Summary

Methods

Modifier and Type	Method and Description
static java.lang.Integer	getExpressionDataType(java.lang.String expression, java.lang.String objectName) Validates the passed expression by executing a JDBC query against the passed object, Returns the resulting data type obtained from the ResultSetMetaData.
static boolean	isCompatibleDataType(java.lang.String mxDataType, int jdbcDataType) Evaluates whether the specified Maximo data type is compatible with the specified type provided by the JDBC driver.
static boolean	isCompatiblePrecision(java.lang.String mxDataType, int jdbcDataType) Determines if the mxDataType that is selected is less precise than the JDBC type.
static boolean	isJDBCDate(int type) Determines whether the passed SQL data type from ResultSetMetaData is a date type.
static boolean	isJDBCNumeric(int type) Determines whether the passed SQL data type from ResultSetMetaData is numeric.
static boolean	isJDBCPrecise(int type) Determines whether the JDBC type is a type with a large precision.
static boolean	isMxDate(java.lang.String type) Determines whether the passed Maximo data type is a date type.
static boolean	isMxNumeric(java.lang.String type) Determines whether the passed Maximo data type is numeric.

Methods inherited from class java.lang.Object

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

Field Detail

MX_NUMERIC_TYPES

public static final java.lang.String[] MX_NUMERIC_TYPES

MX_DATE_TYPES

public static final java.lang.String[] MX_DATE_TYPES

Constructor Detail

ExpressionHelper

public ExpressionHelper()

Method Detail

isCompatibleDataType

public static boolean isCompatibleDataType(java.lang.String mxDataType,
                           int jdbcDataType)

Evaluates whether the specified Maximo data type is compatible with the specified type provided by the JDBC driver.

Parameters:

String - mxDataType the Maximo data type selected for the expression

int - jdbcDataType the data type returned by the JDBC ResultSetMetaData for the calculated column

Returns:

true if the data types are compatible, false if not.

isCompatiblePrecision

public static boolean isCompatiblePrecision(java.lang.String mxDataType,
                            int jdbcDataType)

Determines if the mxDataType that is selected is less precise than the JDBC type.

Parameters:

mxDataType -

jdbcDataType -

Returns:

getExpressionDataType

public static java.lang.Integer getExpressionDataType(java.lang.String expression,
                                      java.lang.String objectName)
                                               throws java.lang.Exception

Validates the passed expression by executing a JDBC query against the passed object, Returns the resulting data type obtained from the ResultSetMetaData.

Parameters:

expression - the test expression

objectName - the object to test the expression string against

Throws:

MXException

java.rmi.RemoteException

java.lang.Exception

isJDBCNumeric

public static boolean isJDBCNumeric(int type)

Determines whether the passed SQL data type from ResultSetMetaData is numeric.

Parameters:

type - the SQL data type

Returns:

true if the data type is numeric

isMxNumeric

public static boolean isMxNumeric(java.lang.String type)

Determines whether the passed Maximo data type is numeric.

Parameters:

type - the Maximo data type

Returns:

true if the data type is numeric

isJDBCDate

public static boolean isJDBCDate(int type)

Determines whether the passed SQL data type from ResultSetMetaData is a date type.

Parameters:

type - the SQL data type

Returns:

true if the data type is date, timestamp, or time

isMxDate

public static boolean isMxDate(java.lang.String type)

Determines whether the passed Maximo data type is a date type.

Parameters:

type - the Maximo data type

Returns:

true if the data type is date, timestamp, or time

isJDBCPrecise

public static boolean isJDBCPrecise(int type)

Determines whether the JDBC type is a type with a large precision.

Parameters:

type -

Returns: