net.windward.datasource.json

Class JsonQueryHelper

java.lang.Object

net.windward.datasource.json.JsonQueryHelper

All Implemented Interfaces:

IDataSourceQueryHelper

public class JsonQueryHelper
extends java.lang.Object
implements IDataSourceQueryHelper

Created by mattb on 2/16/2017.

Constructor Summary

Constructors

Constructor and Description
JsonQueryHelper(java.io.InputStream stream, java.lang.String encoding, JsonDataSource dsp)

Method Summary

Modifier and Type	Method and Description
JsonResultSet	createJsonResultSet(java.util.List<<any>> records, java.lang.String query, java.lang.String tagType)
JsonResultSet	createJsonResultSet(java.util.List resultList, java.util.List pathList, java.lang.String query, java.lang.String tagType)
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.

Methods inherited from class java.lang.Object

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

Constructor Detail

JsonQueryHelper

public JsonQueryHelper(java.io.InputStream stream,
                       java.lang.String encoding,
                       JsonDataSource dsp)
                throws DataConnectionException

Throws:

DataConnectionException

Method Detail

getQueryResults

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

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

Specified by:

getQueryResults in interface IDataSourceQueryHelper

Parameters:

query -

Returns:

Throws:

DataSourceException

substituteVariables

public 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'

Specified by:

substituteVariables in interface IDataSourceQueryHelper

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

public 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.

Specified by:

valueToString in interface IDataSourceQueryHelper

Parameters:

object - returned from getValue() call in AbstractDataSource

Returns:

object converted into a string value

Throws:

DataSourceException

selectNodes

public java.util.Iterator selectNodes(IDataSourceResultSet resultSet)

Specified by:

selectNodes in interface IDataSourceQueryHelper

Parameters:

resultSet -

Returns:

isValidSet

public boolean isValidSet(java.lang.Object value)

Specified by:

isValidSet in interface IDataSourceQueryHelper

getValueFromKey

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

Specified by:

getValueFromKey in interface IDataSourceQueryHelper

isValidQuery

public boolean isValidQuery(java.lang.String query)

Specified by:

isValidQuery in interface IDataSourceQueryHelper

fixQuery

public java.lang.String fixQuery(java.lang.String query,
                                 IDataSourceResultRow resultRow)

Specified by:

fixQuery in interface IDataSourceQueryHelper

resultSetToString

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

Specified by:

resultSetToString in interface IDataSourceQueryHelper

createJsonResultSet

public JsonResultSet createJsonResultSet(java.util.List resultList,
                                         java.util.List pathList,
                                         java.lang.String query,
                                         java.lang.String tagType)

createJsonResultSet

public JsonResultSet createJsonResultSet(java.util.List<<any>> records,
                                         java.lang.String query,
                                         java.lang.String tagType)