net.windward.datasource.abstract_datasource

Interface IDataSourceQueryHelper

All Known Implementing Classes:

JdbcQueryHelper, JsonQueryHelper

public interface IDataSourceQueryHelper

Method Summary

Modifier and Type	Method and Description
java.lang.String	fixQuery(java.lang.String query, IDataSourceResultRow resultRow)
IDataSourceResultSet	getQueryResults(java.lang.String query, java.lang.String tagType) Given a select statement.
java.lang.String	getValueFromKey(java.lang.Object o)
boolean	isValidQuery(java.lang.String query)
boolean	isValidSet(java.lang.Object value)
java.lang.Object	resultSetToString(java.lang.String query)
java.util.Iterator	selectNodes(IDataSourceResultSet resultSet)
java.lang.String	substituteVariables(java.lang.String[] queryParts, java.lang.Object[] toInsert, java.lang.String query, java.util.List<VarResults> parameters) Called by the AbstractDataSource to substitute values into a select statement.
java.lang.String	valueToString(java.lang.Object object) Called by AbstractDataSource to return string value of obj returned from getValue(tag, stack) method.

Method Detail

getQueryResults

IDataSourceResultSet getQueryResults(java.lang.String query,
                                     java.lang.String tagType)
                              throws DataSourceException

Given a select statement. We create a IDataSourceResultSet and return it.

Parameters:

query -

Returns:

Throws:

DataSourceException

substituteVariables

java.lang.String substituteVariables(java.lang.String[] queryParts,
                                     java.lang.Object[] toInsert,
                                     java.lang.String query,
                                     java.util.List<VarResults> parameters)
                              throws DataSourceException

Called by the AbstractDataSource to substitute values into a select statement. Given select: SELECT ${var1} FROM Accounts WHERE Name = ${var2} we create the query parts array: ["SELECT ", " FROM Accounts WHERE Name = ", ""] and the toInsert array: ["Id", "Frank"]

This function then returns: SELECT Id FROM Accounts WHERE name = 'Frank'

Parameters:

queryParts - - The query string broken up into parts such that between each element, an element of toInsert is inserted (possibly with formatting).

toInsert - - The array of items to insert. toInsert.length is equal to (queryParts.length - 2)

query -

parameters -

Returns:

Throws:

DataSourceException

valueToString

java.lang.String valueToString(java.lang.Object object)
                        throws DataSourceException

Called by AbstractDataSource to return string value of obj returned from getValue(tag, stack) method.

Parameters:

object - returned from getValue() call in AbstractDataSource

Returns:

object converted into a string value

Throws:

DataSourceException

selectNodes

java.util.Iterator selectNodes(IDataSourceResultSet resultSet)

isValidSet

boolean isValidSet(java.lang.Object value)

getValueFromKey

java.lang.String getValueFromKey(java.lang.Object o)

isValidQuery

boolean isValidQuery(java.lang.String query)

fixQuery

java.lang.String fixQuery(java.lang.String query,
                          IDataSourceResultRow resultRow)
                   throws DataSourceException

Throws:

DataSourceException

resultSetToString

java.lang.Object resultSetToString(java.lang.String query)