Package com.inductiveautomation.factorypmi.application.components.chart.easychart

Class AbstractSQLQuery

java.lang.Object

com.inductiveautomation.factorypmi.application.components.chart.easychart.AbstractChartQuery

com.inductiveautomation.factorypmi.application.components.chart.easychart.AbstractSQLQuery

All Implemented Interfaces:

IQueryResponseListener

Direct Known Subclasses:

HistogramQuery, PenSQLQuery

public abstract class AbstractSQLQuery
extends AbstractChartQuery

Nested Class Summary

Nested Classes

Modifier and Type	Class	Description
protected static class	AbstractSQLQuery.QueryInfo	Holds the query (a String), and a list of parameters and their types.

Field Summary

Fields

Modifier and Type	Field	Description
protected java.lang.String	datasource
protected IValue<java.util.Date>	endDate
protected java.lang.String	globalWhere
protected java.lang.String	groupName
protected java.lang.String	groupWhere
protected java.lang.String	penWhere
protected IValue<java.util.Date>	startDate
protected java.lang.String	tableName
protected java.lang.String	timeCol

Fields inherited from class com.inductiveautomation.factorypmi.application.components.chart.easychart.AbstractChartQuery

badQuality, chart, data, log, showWarnings

Constructor Summary

Constructors

Constructor	Description
AbstractSQLQuery(java.lang.String datasource, java.lang.String tableName, java.lang.String timeCol)

Method Summary

Modifier and Type	Method	Description
protected void	generateWhereAndOrder(java.lang.StringBuilder sb, java.util.List<IValue<? extends java.io.Serializable>> params, java.util.List<java.lang.Class<?>> paramTypes)	Appends the WHERE and ORDER BY clauses to a string buffer, like:
java.lang.String	getDatasource()
java.lang.String	getGroupName()
java.lang.String	getPenWhere()
protected java.lang.String	getQuasiPropertyName()	Generate a unique string for the query, independent of any values that may change (date ranges, for example.) Used as the "property key" for the quality system in case the query fails.
java.lang.String	getTableName()
java.lang.String	getTimeCol()
protected abstract AbstractSQLQuery.QueryInfo	getWholeQuery()	Construct the query and any parameters
protected java.lang.Object	registerQuery(int pollTime, boolean runOnce)	Register this query with the QueryManager.
protected void	setChart(PMIEasyChart chart)
void	setDatasource(java.lang.String datasource)
protected abstract void	setDates(PMIEasyChart chart)	Called in order to set the startDate and endDate fields with proper late-binding IValue implementations.
protected void	setGlobalWhere(java.lang.String globalWhere)
void	setGroupName(java.lang.String groupName)
protected void	setGroupWhere(java.lang.String groupWhere)
void	setPenWhere(java.lang.String penWhere)
void	setTableName(java.lang.String tName)
void	setTimeCol(java.lang.String timeCol)
java.lang.String	toString()

Methods inherited from class com.inductiveautomation.factorypmi.application.components.chart.easychart.AbstractChartQuery

getData, getTargetFullPath, handleQueryReturnedError, handleQueryReturnedNoRows, handleQueryReturnedValue, notifyQueryRunning, setData, shutdown, startup, warn

Methods inherited from class java.lang.Object

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

Field Detail

datasource

protected java.lang.String datasource

timeCol

protected java.lang.String timeCol

tableName

protected java.lang.String tableName

groupName

protected java.lang.String groupName

penWhere

protected java.lang.String penWhere

startDate

protected IValue<java.util.Date> startDate

endDate

protected IValue<java.util.Date> endDate

globalWhere

protected java.lang.String globalWhere

groupWhere

protected java.lang.String groupWhere

Constructor Detail

AbstractSQLQuery

public AbstractSQLQuery(java.lang.String datasource,
                        java.lang.String tableName,
                        java.lang.String timeCol)

Method Detail

registerQuery

protected java.lang.Object registerQuery(int pollTime,
                                         boolean runOnce)

Description copied from class: AbstractChartQuery

Register this query with the QueryManager. Called by AbstractchartQuery during AbstractChartQuery.startup(PMIEasyChart)

Specified by:

registerQuery in class AbstractChartQuery

Returns:

The key object that the query manager gave back.

setChart

protected void setChart(PMIEasyChart chart)

Overrides:

setChart in class AbstractChartQuery

setDates

protected abstract void setDates(PMIEasyChart chart)

Called in order to set the startDate and endDate fields with proper late-binding IValue implementations.

toString

public java.lang.String toString()

Overrides:

toString in class java.lang.Object

getQuasiPropertyName

protected java.lang.String getQuasiPropertyName()

Description copied from class: AbstractChartQuery

Generate a unique string for the query, independent of any values that may change (date ranges, for example.) Used as the "property key" for the quality system in case the query fails.

Specified by:

getQuasiPropertyName in class AbstractChartQuery

setTableName

public void setTableName(java.lang.String tName)

getTableName

public java.lang.String getTableName()

setTimeCol

public void setTimeCol(java.lang.String timeCol)

getTimeCol

public java.lang.String getTimeCol()

generateWhereAndOrder

protected void generateWhereAndOrder(java.lang.StringBuilder sb,
                                     java.util.List<IValue<? extends java.io.Serializable>> params,
                                     java.util.List<java.lang.Class<?>> paramTypes)

Appends the WHERE and ORDER BY clauses to a string buffer, like:

 " WHERE cond AND cond AND cond ORDER BY xval"
 

getWholeQuery

protected abstract AbstractSQLQuery.QueryInfo getWholeQuery()

Construct the query and any parameters

getDatasource

public java.lang.String getDatasource()

setDatasource

public void setDatasource(java.lang.String datasource)

setGlobalWhere

protected void setGlobalWhere(java.lang.String globalWhere)

setGroupWhere

protected void setGroupWhere(java.lang.String groupWhere)

getPenWhere

public java.lang.String getPenWhere()

setPenWhere

public void setPenWhere(java.lang.String penWhere)

getGroupName

public java.lang.String getGroupName()

setGroupName

public void setGroupName(java.lang.String groupName)