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 String	datasource
protected IValue<Date>	endDate
protected String	globalWhere
protected String	groupName
protected String	groupWhere
protected String	penWhere
protected IValue<Date>	startDate
protected String	tableName
protected 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(String datasource, String tableName, String timeCol)

Method Summary

Modifier and Type	Method	Description
protected void	generateWhereAndOrder(StringBuilder sb, List<IValue<? extends Serializable>> params, List<Class<?>> paramTypes)	Appends the WHERE and ORDER BY clauses to a string buffer, like:
String	getDatasource()
String	getGroupName()
String	getPenWhere()
protected 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.
String	getTableName()
String	getTimeCol()
protected abstract AbstractSQLQuery.QueryInfo	getWholeQuery()	Construct the query and any parameters
protected Object	registerQuery(int pollTime, boolean runOnce)	Register this query with the QueryManager.
protected void	setChart(PMIEasyChart chart)
void	setDatasource(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(String globalWhere)
void	setGroupName(String groupName)
protected void	setGroupWhere(String groupWhere)
void	setPenWhere(String penWhere)
void	setTableName(String tName)
void	setTimeCol(String timeCol)
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 Details

datasource

protected String datasource

timeCol

protected String timeCol

tableName

protected String tableName

groupName

protected String groupName

penWhere

protected String penWhere

startDate

protected IValue<Date> startDate

endDate

protected IValue<Date> endDate

globalWhere

protected String globalWhere

groupWhere

protected String groupWhere

Constructor Details

AbstractSQLQuery

public AbstractSQLQuery(String datasource,
 String tableName,
 String timeCol)

Method Details

registerQuery

protected 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 String toString()

Overrides:

toString in class Object

getQuasiPropertyName

protected 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(String tName)

getTableName

public String getTableName()

setTimeCol

public void setTimeCol(String timeCol)

getTimeCol

public String getTimeCol()

generateWhereAndOrder

protected void generateWhereAndOrder(StringBuilder sb,
 List<IValue<? extends Serializable>> params,
 List<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 String getDatasource()

setDatasource

public void setDatasource(String datasource)

setGlobalWhere

protected void setGlobalWhere(String globalWhere)

setGroupWhere

protected void setGroupWhere(String groupWhere)

getPenWhere

public String getPenWhere()

setPenWhere

public void setPenWhere(String penWhere)

getGroupName

public String getGroupName()

setGroupName

public void setGroupName(String groupName)