public abstract class AbstractSQLQuery extends AbstractChartQuery
Modifier and Type | Class and Description |
---|---|
protected static class |
AbstractSQLQuery.QueryInfo
Holds the query (a String), and a list of parameters and their types.
|
Modifier and Type | Field and 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 |
badQuality, chart, data, log, showWarnings
Constructor and Description |
---|
AbstractSQLQuery(java.lang.String datasource,
java.lang.String tableName,
java.lang.String timeCol) |
Modifier and Type | Method and 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)
|
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() |
getData, getTargetFullPath, handleQueryReturnedError, handleQueryReturnedNoRows, handleQueryReturnedValue, notifyQueryRunning, setData, shutdown, startup, warn
protected java.lang.String datasource
protected java.lang.String timeCol
protected java.lang.String tableName
protected java.lang.String groupName
protected java.lang.String penWhere
protected IValue<java.util.Date> startDate
protected IValue<java.util.Date> endDate
protected java.lang.String globalWhere
protected java.lang.String groupWhere
public AbstractSQLQuery(java.lang.String datasource, java.lang.String tableName, java.lang.String timeCol)
protected java.lang.Object registerQuery(int pollTime, boolean runOnce)
AbstractChartQuery
AbstractChartQuery.startup(PMIEasyChart)
registerQuery
in class AbstractChartQuery
protected void setChart(PMIEasyChart chart)
setChart
in class AbstractChartQuery
protected abstract void setDates(PMIEasyChart chart)
public java.lang.String toString()
toString
in class java.lang.Object
protected java.lang.String getQuasiPropertyName()
AbstractChartQuery
getQuasiPropertyName
in class AbstractChartQuery
public void setTableName(java.lang.String tName)
public java.lang.String getTableName()
public void setTimeCol(java.lang.String timeCol)
public java.lang.String getTimeCol()
protected void generateWhereAndOrder(java.lang.StringBuilder sb, java.util.List<IValue<? extends java.io.Serializable>> params, java.util.List<java.lang.Class<?>> paramTypes)
" WHERE cond AND cond AND cond ORDER BY xval"
protected abstract AbstractSQLQuery.QueryInfo getWholeQuery()
public java.lang.String getDatasource()
public void setDatasource(java.lang.String datasource)
protected void setGlobalWhere(java.lang.String globalWhere)
protected void setGroupWhere(java.lang.String groupWhere)
public java.lang.String getPenWhere()
public void setPenWhere(java.lang.String penWhere)
public java.lang.String getGroupName()
public void setGroupName(java.lang.String groupName)