Package com.google.visualization.datasource.query

Examples of com.google.visualization.datasource.query.SimpleColumn


        Query dataSourceQuery = new Query();
        Query completionQuery = new Query();
        if(query.getSelection() != null) {
            QuerySelection selection = new QuerySelection();
            for(String simpleColumnId : query.getAllColumnIds()) {
                selection.addColumn(new SimpleColumn(simpleColumnId));
            }
            // Column selection can be empty. For example, for query "SELECT 1".
            dataSourceQuery.setSelection(selection);
        }
View Full Code Here


        DataTable table = new DataTable();
        table.addColumn(simpleColumnDescription);
        table.addColumn(aggreationColumnDescription);

        List<AbstractColumn> simpleColumns =
                Lists.newArrayList((AbstractColumn) new SimpleColumn("simpleColumn"));
        List<AbstractColumn> aggregationColumns =
                Lists.newArrayList((AbstractColumn) new AggregationColumn(
                        new SimpleColumn("simpleColumn"), AggregationType.MIN));
        ScalarFunctionColumnTitle titleYear =
                new ScalarFunctionColumnTitle(Lists.<Value>newArrayList(),
                        new ScalarFunctionColumn(simpleColumns,
                                TimeComponentExtractor.getInstance(
                                        TimeComponentExtractor.TimeComponent.YEAR)));
View Full Code Here

          // The id here is the id generated by the data source for the column containing
          // the aggregated data, e.g., max-B.
          String id = column.getId();
          // MIN is chosen arbitrarily, because there will be exactly one.
          completionSelection.addColumn(
              new AggregationColumn(new SimpleColumn(id), AggregationType.MIN));
        }
      }

      completionQuery.setSelection(completionSelection);
    } else {
      // When there is no pivoting, sql does everything (except options, labels, format).
      dataSourceQuery.copyFrom(query);
      dataSourceQuery.setOptions(null);
      completionQuery.setOptions(query.getOptions());
      try {
        if (query.hasLabels()) {
          dataSourceQuery.setLabels(null);
          QueryLabels labels = query.getLabels();
          QueryLabels newLabels = new QueryLabels();
          for (AbstractColumn column : labels.getColumns()) {
            newLabels.addLabel(new SimpleColumn(column.getId()), labels.getLabel(column));
          }
          completionQuery.setLabels(newLabels);
        }
        if (query.hasUserFormatOptions()) {
          dataSourceQuery.setUserFormatOptions(null);
          QueryFormat formats = query.getUserFormatOptions();
          QueryFormat newFormats = new QueryFormat();
          for (AbstractColumn column : formats.getColumns()) {
            newFormats.addPattern(new SimpleColumn(column.getId()), formats.getPattern(column));
          }
          completionQuery.setUserFormatOptions(newFormats);
        }
      } catch (InvalidQueryException e) {
        // Should not happen.
View Full Code Here

    Query dataSourceQuery = new Query();
    Query completionQuery = new Query();
    if (query.getSelection() != null) {
      QuerySelection selection = new QuerySelection();
      for (String simpleColumnId : query.getAllColumnIds()) {
        selection.addColumn(new SimpleColumn(simpleColumnId));
      }
      // Column selection can be empty. For example, for query "SELECT 1".
      dataSourceQuery.setSelection(selection);
    }
View Full Code Here

   */
  public static DataTable executeQuery(Query query, DataTable table, ULocale locale) {
    ColumnIndices columnIndices = new ColumnIndices();
    List<ColumnDescription> columnsDescription = table.getColumnDescriptions();
    for (int i = 0; i < columnsDescription.size(); i++) {
      columnIndices.put(new SimpleColumn(columnsDescription.get(i).getId()), i);
    }

    // A map of column lookups by their list of pivot values. This is utilized in
    // the grouping and pivoting queries.
    TreeMap<List<Value>, ColumnLookup> columnLookups =
View Full Code Here

    if (jj_2_5(2)) {
      aggregationType = aggregationFunction();
      jj_consume_token(OP_LPAREN);
      columnId = columnId();
      jj_consume_token(OP_RPAREN);
       result = new AggregationColumn(new SimpleColumn(columnId),
           aggregationType);
    } else if (jj_2_6(2)) {
      scalarFunction = scalarFunction();
      jj_consume_token(OP_LPAREN);
      switch ((jj_ntk==-1)?jj_ntk():jj_ntk) {
      case KW_TRUE:
      case KW_FALSE:
      case KW_DATE:
      case KW_TIMEOFDAY:
      case KW_DATETIME:
      case KW_TIMESTAMP:
      case KW_MIN:
      case KW_MAX:
      case KW_AVG:
      case KW_COUNT:
      case KW_SUM:
      case KW_NO_VALUES:
      case KW_NO_FORMAT:
      case KW_IS:
      case KW_NULL:
      case KW_YEAR:
      case KW_MONTH:
      case KW_DAY:
      case KW_HOUR:
      case KW_MINUTE:
      case KW_SECOND:
      case KW_MILLISECOND:
      case KW_WITH:
      case KW_CONTAINS:
      case KW_STARTS:
      case KW_ENDS:
      case KW_MATCHES:
      case KW_LIKE:
      case KW_NOW:
      case KW_DATEDIFF:
      case KW_QUARTER:
      case KW_LOWER:
      case KW_UPPER:
      case KW_DAYOFWEEK:
      case KW_TODATE:
      case ID:
      case INTEGER_LITERAL:
      case DECIMAL_LITERAL:
      case STRING_LITERAL:
      case QUOTED_ID:
      case OP_LPAREN:
      case OP_MINUS:
        column = abstractColumnDescriptor();
                                              columns.add(column);
        break;
      default:
        jj_la1[31] = jj_gen;
        ;
      }
      label_10:
      while (true) {
        switch ((jj_ntk==-1)?jj_ntk():jj_ntk) {
        case OP_COMMA:
          ;
          break;
        default:
          jj_la1[32] = jj_gen;
          break label_10;
        }
        jj_consume_token(OP_COMMA);
        column = abstractColumnDescriptor();
            columns.add(column);
      }
      jj_consume_token(OP_RPAREN);
            result = new ScalarFunctionColumn(
              GenericsHelper.makeTypedList(columns), scalarFunction);
    } else {
      switch ((jj_ntk==-1)?jj_ntk():jj_ntk) {
      case OP_LPAREN:
        jj_consume_token(OP_LPAREN);
        column = abstractColumnDescriptor();
        jj_consume_token(OP_RPAREN);
         result = column;
        break;
      case KW_TRUE:
      case KW_FALSE:
      case KW_DATE:
      case KW_TIMEOFDAY:
      case KW_DATETIME:
      case KW_TIMESTAMP:
      case INTEGER_LITERAL:
      case DECIMAL_LITERAL:
      case STRING_LITERAL:
      case OP_MINUS:
        value = literal();
         result = new ScalarFunctionColumn(new ArrayList(),
           new Constant(value));
        break;
      case KW_MIN:
      case KW_MAX:
      case KW_AVG:
      case KW_COUNT:
      case KW_SUM:
      case KW_NO_VALUES:
      case KW_NO_FORMAT:
      case KW_IS:
      case KW_NULL:
      case KW_YEAR:
      case KW_MONTH:
      case KW_DAY:
      case KW_HOUR:
      case KW_MINUTE:
      case KW_SECOND:
      case KW_MILLISECOND:
      case KW_WITH:
      case KW_CONTAINS:
      case KW_STARTS:
      case KW_ENDS:
      case KW_MATCHES:
      case KW_LIKE:
      case KW_NOW:
      case KW_DATEDIFF:
      case KW_QUARTER:
      case KW_LOWER:
      case KW_UPPER:
      case KW_DAYOFWEEK:
      case KW_TODATE:
      case ID:
      case QUOTED_ID:
        columnId = columnId();
                               result = new SimpleColumn(columnId);
        break;
      default:
        jj_la1[33] = jj_gen;
        jj_consume_token(-1);
        throw new ParseException();
View Full Code Here

TOP

Related Classes of com.google.visualization.datasource.query.SimpleColumn

Copyright © 2018 www.massapicom. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.