com.highqsoft.odsx.hql

Class OdsxSelectConvert

java.lang.Object

com.highqsoft.odsx.hql.OdsxSelectConvert

public class OdsxSelectConvert
extends java.lang.Object

A test to parse select statments.

Author:

Andreas Hofmann $Revision: 1.13 $ $Date: 2017/04/06 13:29:55 $

Field Summary

Fields

Modifier and Type	Field and Description
protected static java.lang.String	braces
protected static java.lang.String	delimiter
static java.lang.String	FROM The keyword for the from clause.
protected java.lang.String	lastToken
protected static java.util.HashMap	operatorInvList
protected static java.util.HashMap	operatorList
protected static java.lang.String	operators
static java.lang.String	SELECT The keyword for the select clause.
protected static java.lang.String	SPACES
protected java.lang.String	upperToken
static java.lang.String	WHERE The keyword for the where clause.

Constructor Summary

Constructors

Constructor and Description
OdsxSelectConvert() The constructor.

Method Summary

Methods

Modifier and Type	Method and Description
protected AIDNameUnitId[]	getAIDNameUnitId(ApplicationElement[] aeObj, java.lang.String spec) Get the AIDNameUnitId structure.
protected AIDNameUnitId[]	getAIDNameUnitId(ApplicationElement[] aeObj, java.util.Vector colSpec) Get the AIDNameUnitId structure.
protected ApplicationAttribute[]	getApplicationAttributes(ApplicationElement aeObj, java.lang.String spec) Get the application attributes belongs to the given string specification.
protected ApplicationElement[]	getApplicationElements(ApplicationStructure asObj, java.lang.String spec) Get the application elements belongs to the given string specification.
protected ApplicationAttribute[][]	getAttributes(ApplicationElement[] aeObj, java.lang.String spec) Get the application attributes belongs to the given string specification.
protected ApplicationAttribute[][]	getAttributes(InstanceElement[] ieObj, java.lang.String spec) Get the application attributes belongs to the given string specification.
java.lang.String	getConditionString(ApplicationStructure asObj, SelValue selValue) Get the string presentation of the given condition.
QueryStructure	getQueryStructure(AoSession session, java.util.HashMap map) Get the ods query structure.
java.lang.String	getSelectStatement(AoSession session, QueryStructure query) Get the select statement for the given query structure.
protected SelValue	getSelValue(ApplicationElement[] aeObj, java.lang.String field, java.lang.String op, java.lang.String val) Get the SelValue structure.
protected java.util.Vector	getSelValue(ApplicationElement[] aeObj, java.util.Vector where, java.util.Vector selVal, java.util.Vector selOp) Get the selection value.
protected java.lang.String	getToken(java.util.StringTokenizer st) Internal method to get a token.
boolean	handleParsedOperator(java.util.Vector vec, java.lang.String upperToken) Handle found operants.
static void	main(java.lang.String[] args) The main testing method.
java.util.HashMap	parse(java.lang.String statement) Parse a statement.
java.util.Vector	parseConditions(java.util.StringTokenizer st) Parse the conditions of a where clause.
protected void	parseFrom(java.util.StringTokenizer st, java.util.HashMap map) Parse the from clause.
protected void	parseSelect(java.util.StringTokenizer st, java.util.HashMap map) Parse the select clause.
protected java.lang.String	parseString(java.util.StringTokenizer st) Parse the string literal.
protected void	parseWhere(java.util.StringTokenizer st, java.util.HashMap map) Parse the where clause.
static void	printCols(java.io.PrintStream out, ResultColumn[] cols)
static void	printElemResultSet(java.io.PrintStream out, ElemResultSet[] elemRes) Print out the selection result.
static void	showElemResultSet(ElemResultSet[] elemRes) Print the given result sets to the standard output stream.

Methods inherited from class java.lang.Object

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

Field Detail

SPACES

protected static final java.lang.String SPACES

SELECT

public static final java.lang.String SELECT

The keyword for the select clause.

See Also:

Constant Field Values

FROM

public static final java.lang.String FROM

The keyword for the from clause.

See Also:

Constant Field Values

WHERE

public static final java.lang.String WHERE

The keyword for the where clause.

See Also:

Constant Field Values

braces

protected static final java.lang.String braces

See Also:

Constant Field Values

operators

protected static final java.lang.String operators

See Also:

Constant Field Values

operatorList

protected static final java.util.HashMap operatorList

operatorInvList

protected static final java.util.HashMap operatorInvList

delimiter

protected static final java.lang.String delimiter

See Also:

Constant Field Values

lastToken

protected java.lang.String lastToken

upperToken

protected java.lang.String upperToken

Constructor Detail

OdsxSelectConvert

public OdsxSelectConvert()

The constructor.

Method Detail

getToken

protected java.lang.String getToken(java.util.StringTokenizer st)

Internal method to get a token.

parse

public java.util.HashMap parse(java.lang.String statement)

Parse a statement. The result is a hashmap that has entries for the SELECT, FROM and WHERE keywords (if any). Use the predefined constants to get the specific information. The syntax is similar to an SQL statement. The parser is case insensitive on the keyword SELECT, FROM and WHERE. The problem is to specify the model (BaseModel or ApplicationStructure). Therefore the field can have a prefix.

Prefix	Description
BA.	Request a BaseAttribute.
BE.	Request a BaseElement.
AA.	Request a ApplicationAttribute.
AE.	Request a ApplicationElement.

If no prefix is specified, the interpretation depends on the consumer of this result.

Keyword	Datatype	Description
SELECT	java.util.Vector	The strings describing the elements to be selected.
FROM	java.util.Vector	The strings describing the elements of the from clause.
WHERE	java.util.Vector	The strings describing the condition. Each element could be a vector that contains a subcondition.

Example:
select (BA.Id, Ba.N\\/ame) from (BE.AoTest, AE.Measurement) where ((BA.id < 10) && (BA.name == SG*))

Parameters:

statement - the statement to be parsed.

Returns:

the described hashmap.

parseSelect

protected void parseSelect(java.util.StringTokenizer st,
               java.util.HashMap map)

Parse the select clause.

Parameters:

st - the tokenizer.

map - the parser result map.

parseFrom

protected void parseFrom(java.util.StringTokenizer st,
             java.util.HashMap map)

Parse the from clause.

Parameters:

st - the tokenizer.

map - the parser result map.

parseWhere

protected void parseWhere(java.util.StringTokenizer st,
              java.util.HashMap map)

Parse the where clause.

Parameters:

st - the tokenizer.

map - the parser result map.

parseConditions

public java.util.Vector parseConditions(java.util.StringTokenizer st)

Parse the conditions of a where clause.

Parameters:

st - the tokenizer.

Returns:

A vector containing the conditions.

parseString

protected java.lang.String parseString(java.util.StringTokenizer st)

Parse the string literal.

Parameters:

st - the tokenizer.

Returns:

The result string.

handleParsedOperator

public boolean handleParsedOperator(java.util.Vector vec,
                           java.lang.String upperToken)

Handle found operants.

Parameters:

vec - the resulting vector.

upperToken - the current operant.

getQueryStructure

public QueryStructure getQueryStructure(AoSession session,
                               java.util.HashMap map)
                                 throws AoException

Get the ods query structure.

Parameters:

session - the session to be used for query.

map - the result map of the parser

Returns:

the querystructure of null if not successful.

Throws:

AoException

See Also:

AoSession

getSelValue

protected java.util.Vector getSelValue(ApplicationElement[] aeObj,
                           java.util.Vector where,
                           java.util.Vector selVal,
                           java.util.Vector selOp)

Get the selection value.

Parameters:

aeObj - An array containing the selected application elements.

where - The vector containing the where clause coming from parser.

selVal - The vector into the method can save the result. May be null

selOp - The operations of the selection.

Returns:

a vector containing the SelValue structures.

getSelValue

protected SelValue getSelValue(ApplicationElement[] aeObj,
                   java.lang.String field,
                   java.lang.String op,
                   java.lang.String val)

Get the SelValue structure.

Parameters:

aeObj - An array containing the application elements.

field - The field name or pattern.

op - the operation string.

val - The value string.

Returns:

the SelValue structure.

getAIDNameUnitId

protected AIDNameUnitId[] getAIDNameUnitId(ApplicationElement[] aeObj,
                               java.util.Vector colSpec)

Get the AIDNameUnitId structure.

Parameters:

aeObj - An array containing the application elements.

colSpec - The vector containing the column specification from select statement.

Returns:

the AIDNameUnitId structure array (one for each column).

getAIDNameUnitId

protected AIDNameUnitId[] getAIDNameUnitId(ApplicationElement[] aeObj,
                               java.lang.String spec)

Get the AIDNameUnitId structure.

Parameters:

aeObj - An array containing the application elements.

spec - The column specification from select statement.

Returns:

the AIDNameUnitId structure array (one for each column).

getAttributes

protected ApplicationAttribute[][] getAttributes(InstanceElement[] ieObj,
                                     java.lang.String spec)
                                          throws AoException

Get the application attributes belongs to the given string specification.

Parameters:

ieObj - the instance elements.

spec - The string specification.

Returns:

the found application attributes.

Throws:

AoException

getAttributes

protected ApplicationAttribute[][] getAttributes(ApplicationElement[] aeObj,
                                     java.lang.String spec)
                                          throws AoException

Get the application attributes belongs to the given string specification.

Parameters:

aeObj - the application elements.

spec - The string specification.

Returns:

the found application attributes.

Throws:

AoException

getApplicationAttributes

protected ApplicationAttribute[] getApplicationAttributes(ApplicationElement aeObj,
                                              java.lang.String spec)
                                                   throws AoException

Get the application attributes belongs to the given string specification.

Parameters:

aeObj - the application element.

spec - The string specification.

Returns:

the found application attributes.

Throws:

AoException

getApplicationElements

protected ApplicationElement[] getApplicationElements(ApplicationStructure asObj,
                                          java.lang.String spec)
                                               throws AoException

Get the application elements belongs to the given string specification.

Parameters:

asObj - the application structure.

spec - The string specification.

Returns:

the found application elements or null.

Throws:

AoException

getSelectStatement

public java.lang.String getSelectStatement(AoSession session,
                                  QueryStructure query)
                                    throws AoException

Get the select statement for the given query structure.

Parameters:

session - The session to be used.

query - The query structure.

Returns:

the select statement belongs to the given structure.

Throws:

AoException

See Also:

AoSession

getConditionString

public java.lang.String getConditionString(ApplicationStructure asObj,
                                  SelValue selValue)

Get the string presentation of the given condition.

Returns:

the string

printElemResultSet

public static void printElemResultSet(java.io.PrintStream out,
                      ElemResultSet[] elemRes)

Print out the selection result.

Parameters:

out - the the print stream to use.

elemRes - An array containing the result sets.

org.asam.ods.ElemResultSet -

showElemResultSet

public static void showElemResultSet(ElemResultSet[] elemRes)

Print the given result sets to the standard output stream.

Parameters:

elemRes - An array containing the result set.

See Also:

ElemResultSet

printCols

public static void printCols(java.io.PrintStream out,
             ResultColumn[] cols)

main

public static void main(java.lang.String[] args)

The main testing method.