Class AbstractSQLQuery

    • 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

      • 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"
         
      • 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)