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
All Methods Instance Methods Abstract Methods Concrete Methods 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 parametersprotected 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)
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
-
-
-
-
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
-
-
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 duringAbstractChartQuery.startup(PMIEasyChart)
- Specified by:
registerQuery
in classAbstractChartQuery
- Returns:
- The key object that the query manager gave back.
-
setChart
protected void setChart(PMIEasyChart chart)
- Overrides:
setChart
in classAbstractChartQuery
-
setDates
protected abstract void setDates(PMIEasyChart chart)
-
toString
public java.lang.String toString()
- Overrides:
toString
in classjava.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 classAbstractChartQuery
-
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)
-
-