com.technia.tvc.core.db

Class SelectUtils

java.lang.Object

com.technia.tvc.core.db.SelectUtils

public final class SelectUtils
extends java.lang.Object

Contains utility methods for retrieving selected data from a business object or a relationship.

Since:

5.0.2

Field Summary

Fields

Modifier and Type	Field and Description
static matrix.util.StringList	SELECT_ID

Method Summary

Modifier and Type	Method and Description
static int	getDataType(Statement statement)
static int	getDataType(java.lang.String statement)
static java.lang.String[]	getSelectData(matrix.db.BusinessObjectWithSelectList bowsl, Statement statement)
static java.lang.String	getSelectData(matrix.db.BusinessObjectWithSelect bows, Statement statement)
static java.lang.String	getSelectData(matrix.db.BusinessObjectWithSelect bows, java.lang.String statement)
static java.lang.String	getSelectData(matrix.db.RelationshipWithSelect rws, Statement statement)
static java.lang.String	getSelectData(matrix.db.RelationshipWithSelect rws, java.lang.String statement)
static matrix.util.StringList	getSelectDataList(matrix.db.BusinessObjectWithSelect bows, Statement statement) Convenience method for retrieving all the selected data that match the specified statement.
static matrix.util.StringList[]	getSelectDataList(matrix.db.BusinessObjectWithSelect bows, Statement[] statements) Convenience method for retrieving all the selected data that match the specified statements.
static matrix.util.StringList	getSelectDataList(matrix.db.BusinessObjectWithSelect bows, java.lang.String statement)
static matrix.util.StringList	getSelectDataList(matrix.db.RelationshipWithSelect rws, Statement statement)
static matrix.util.StringList	getSelectDataList(matrix.db.RelationshipWithSelect rws, java.lang.String statement)
static short	getSelectDataType(matrix.db.BusinessObjectWithSelect bows, Statement statement)
static short	getSelectDataType(matrix.db.BusinessObjectWithSelect bows, java.lang.String statement)
static short	getSelectDataType(matrix.db.RelationshipWithSelect rws, Statement statement)
static short	getSelectDataType(matrix.db.RelationshipWithSelect rws, java.lang.String statement)
static boolean	isAttributeSelect(java.lang.String statement)
static java.lang.String	parseAttributeName(java.lang.String expression) Returns the name of the attribute that an expression refers to.
static java.lang.String	parseOrResolveAttributeName(java.lang.String expression) Tries to parse or resolves expression with expression as default value.
static java.lang.String	removeWhereClause(java.lang.String select) Converts a select expression by removing any conditions (where clauses) from the select expression.
static java.lang.String	toAttributeSelect(java.lang.String attributeName) Returns the expression that can be used to select the attribute value from a businessobject or connection.
static java.lang.String	toAttributeSelect(SymbolicName name) Returns the expression that can be used to select the attribute value from a businessobject or connection.
static matrix.util.StringList	toStringList(java.util.List<Statement> statements)
static matrix.util.StringList	toStringList(Statement statement)
static matrix.util.StringList	toStringList(Statement[] statement)

Methods inherited from class java.lang.Object

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

Field Detail

SELECT_ID

public static final matrix.util.StringList SELECT_ID

Method Detail

removeWhereClause

public static java.lang.String removeWhereClause(java.lang.String select)

Converts a select expression by removing any conditions (where clauses) from the select expression.

Such condition (where clause) appears after a pipe character

Parameters:

select - The select expression

Returns:

The converted select expression without any where clauses.

Since:

2015.1.0

parseAttributeName

public static java.lang.String parseAttributeName(java.lang.String expression)

Returns the name of the attribute that an expression refers to.

Parameters:

expression - An expression.

Returns:

Returns the name of the attribute that the expression refers to.

Since:

6.0.1

parseOrResolveAttributeName

public static java.lang.String parseOrResolveAttributeName(java.lang.String expression)
                                                    throws TVCException

Tries to parse or resolves expression with expression as default value. If expression is symbolic name it will return the resolved attribute name otherwise it will return the expression itself.

Parameters:

expression -

Returns:

Returns the expression parsed and resolved

Throws:

TVCException

Since:

2018-09-03

toAttributeSelect

public static java.lang.String toAttributeSelect(SymbolicName name)

Returns the expression that can be used to select the attribute value from a businessobject or connection.

Parameters:

name - The symbolic name instance of the attribute

Returns:

The select expression used to select the attribute with the given name

Since:

2013.2.0

toAttributeSelect

public static java.lang.String toAttributeSelect(java.lang.String attributeName)

Returns the expression that can be used to select the attribute value from a businessobject or connection.

Parameters:

attributeName - The name of the attribute to select.

Returns:

The select expression used to select the attribute with the given name

Since:

6.4.2

getSelectData

public static java.lang.String[] getSelectData(matrix.db.BusinessObjectWithSelectList bowsl,
                                               Statement statement)

Parameters:

bowsl -

statement -

Returns:

A string array of the selected data

Since:

5.2.1

getSelectData

public static java.lang.String getSelectData(matrix.db.BusinessObjectWithSelect bows,
                                             Statement statement)

Parameters:

bows - A business object that contains selected data.

statement - A select statement.

Returns:

The first piece of selected data that match the specified statement.

getSelectData

public static java.lang.String getSelectData(matrix.db.BusinessObjectWithSelect bows,
                                             java.lang.String statement)

Parameters:

bows - A business object that contains selected data.

statement - A select statement.

Returns:

The first piece of selected data that match the specified statement.

getSelectDataType

public static short getSelectDataType(matrix.db.BusinessObjectWithSelect bows,
                                      Statement statement)

Parameters:

bows - A business object that contains selected data.

statement - A select statement.

Returns:

The data type of the select statements that match the given statement. Note that if more than one select statement in the business object match the given statement they must have the same type or else this method will return undefined.

Since:

5.2

getSelectDataType

public static short getSelectDataType(matrix.db.BusinessObjectWithSelect bows,
                                      java.lang.String statement)

Parameters:

bows - A business object that contains selected data.

statement - A select statement.

Returns:

The data type of the select statements that match the given statement. Note that if more than one select statement in the business object match the given statement they must have the same type or else this method will return undefined.

Since:

5.2

getSelectDataList

public static matrix.util.StringList getSelectDataList(matrix.db.BusinessObjectWithSelect bows,
                                                       Statement statement)

Convenience method for retrieving all the selected data that match the specified statement.

For example, if the statement is attribute.value this method will return all the selected information from all the selected keys that match this statement. Example of keys that match are:

• attribute.value (Data from a direct match will always be returned)
• attribute[Quantity].value
• attribute[Find Number].value
• attribute[Unit of Measure].value

However, if the select statement is more specific, such as attribute[Lead Time].value (i.e., a certain attribute is requested, not all attributes as in the previous example), less data will be returned.

Parameters:

bows - A business object that contains selected data.

statement - A select statement.

Returns:

All data for all keys that match the specified statement.

getSelectDataList

public static matrix.util.StringList[] getSelectDataList(matrix.db.BusinessObjectWithSelect bows,
                                                         Statement[] statements)

Convenience method for retrieving all the selected data that match the specified statements.

Parameters:

bows - A business object that contains selected data.

statements - An array of select statement.

Returns:

All data for all keys that match the specified statement.

Since:

6.0

getSelectDataList

public static matrix.util.StringList getSelectDataList(matrix.db.BusinessObjectWithSelect bows,
                                                       java.lang.String statement)

Parameters:

bows - A business object that contains selected data.

statement - A select statement.

Returns:

All data for all keys that match the specified statement.

getSelectData

public static java.lang.String getSelectData(matrix.db.RelationshipWithSelect rws,
                                             Statement statement)

Parameters:

rws - A relationship that contains selected data.

statement - A select statement.

Returns:

The first piece of selected data that match the specified statement.

getSelectData

public static java.lang.String getSelectData(matrix.db.RelationshipWithSelect rws,
                                             java.lang.String statement)

Parameters:

rws - A relationship that contains selected data.

statement - A select statement.

Returns:

The first piece of selected data that match the specified statement.

getSelectDataType

public static short getSelectDataType(matrix.db.RelationshipWithSelect rws,
                                      Statement statement)

Parameters:

rws - A relationship that contains selected data.

statement - A select statement.

Returns:

The data type of the select statements that match the given statement. Note that if more than one select statement in the relationship match the given statement they must have the same type or else this method will return undefined.

Since:

5.2

getSelectDataType

public static short getSelectDataType(matrix.db.RelationshipWithSelect rws,
                                      java.lang.String statement)

Parameters:

rws - A relationship that contains selected data.

statement - A select statement.

Returns:

The data type of the select statements that match the given statement. Note that if more than one select statement in the relationship match the given statement they must have the same type or else this method will return undefined.

Since:

5.2

getSelectDataList

public static matrix.util.StringList getSelectDataList(matrix.db.RelationshipWithSelect rws,
                                                       Statement statement)

Parameters:

rws - A relationship that contains selected data.

statement - A select statement.

Returns:

All data for all keys that match the specified statement.

getSelectDataList

public static matrix.util.StringList getSelectDataList(matrix.db.RelationshipWithSelect rws,
                                                       java.lang.String statement)

Parameters:

rws - A relationship that contains selected data.

statement - A select statement.

Returns:

All data for all keys that match the specified statement.

toStringList

public static matrix.util.StringList toStringList(Statement statement)

Parameters:

statement - A statement.

Returns:

A StringList that contains the single statement.

Since:

5.1

toStringList

public static matrix.util.StringList toStringList(Statement[] statement)

Parameters:

statement - An array of statements.

Returns:

A StringList that contains the statements.

Since:

5.1

toStringList

public static matrix.util.StringList toStringList(java.util.List<Statement> statements)

Parameters:

statements -

Returns:

A StringList that contains the statements (as strings)

Since:

2010.1.0

isAttributeSelect

public static boolean isAttributeSelect(java.lang.String statement)

getDataType

public static int getDataType(Statement statement)

Parameters:

statement -

Returns:

The expected data type returned by the select see AttributeConstants

Since:

2015.1.0

getDataType

public static int getDataType(java.lang.String statement)

Parameters:

statement -

Returns:

The expected data type returned by the select see AttributeConstants

Since:

2015.1.0