Package org.gcube.accounting.analytics.persistence.postgresql

Class Query

java.lang.Object
org.gcube.accounting.utility.postgresql.PostgreSQLQuery
org.gcube.accounting.analytics.persistence.postgresql.Query
public class Query extends org.gcube.accounting.utility.postgresql.PostgreSQLQuery

  • Field Details

  • Constructor Details

    • Query

      public Query(Class<? extends org.gcube.documentstore.records.AggregatedRecord<?,?>> clz) throws Exception
      Throws:
      Exception

  • Method Details

    • getRequestedTableField

      public Set<String> getRequestedTableField()

    • setTemporalConstraint

      public void setTemporalConstraint(org.gcube.accounting.analytics.TemporalConstraint temporalConstraint)

    • setFilters

      public void setFilters(Collection<? extends org.gcube.accounting.analytics.Filter> filters)

    • setContexts

      public void setContexts(Set<String> contexts)

    • setTableFieldToRequest

      public void setTableFieldToRequest(String tableFieldToRequest)

    • setOrderByField

      public void setOrderByField(String orderByField)

    • setLimit

      public void setLimit(Integer limit)

    • addContext

      public void addContext(String context)

    • setRecordId

      public void setRecordId(String recordId)

    • getRecordToDBFields

      public org.gcube.accounting.utility.postgresql.RecordToDBFields getRecordToDBFields()

    • getTableField

      protected String getTableField(String fieldName)

    • appendTableField

      protected void appendTableField(String fieldName)

    • getFormattedDate

      public static String getFormattedDate(Calendar calendar)

    • addFilters

      protected void addFilters() throws SQLException
      Throws:
      SQLException

    • addOrConditions

      protected void addOrConditions(String key, Collection<String> values) throws SQLException
      Throws:
      SQLException

    • addContextFilter

      protected void addContextFilter() throws SQLException
      Throws:
      SQLException

    • addEmittedFields

      protected void addEmittedFields(boolean addNested) throws Exception
      Throws:
      Exception

    • getTimeBucketCalendarInterval

      protected String getTimeBucketCalendarInterval(org.gcube.accounting.analytics.TemporalConstraint.AggregationMode aggregationMode)

    • addTemporalConstraintToQuery

      protected void addTemporalConstraintToQuery() throws SQLException
      Throws:
      SQLException

    • addDateGroupBy

      protected void addDateGroupBy(boolean addNested)

    • addDateOrderBy

      protected void addDateOrderBy(boolean addNested)

    • addGroupAndOrderByForOrderByField

      protected void addGroupAndOrderByForOrderByField()

    • addLimit

      protected void addLimit()

    • addRequestedField

      protected void addRequestedField()

    • addRequestedDate

      protected void addRequestedDate()

    • getTimeSeriesQuery

      public String getTimeSeriesQuery() throws Exception
      Throws:
      Exception

    • getNextPossibleValueQuery

      public String getNextPossibleValueQuery() throws Exception
      Throws:
      Exception

    • getRecordQuery

      public String getRecordQuery()

    • getDinstinctValuesQuery

      public String getDinstinctValuesQuery()