Package com.google.visualization.datasource.query.scalarfunction

Examples of com.google.visualization.datasource.query.scalarfunction.Constant


    // selection with modulo ('weight' is a column id): "select weight, weight % 10"
    Query q = new Query();

    AbstractColumn col1 = new ScalarFunctionColumn(
        Lists.<AbstractColumn>newArrayList(), new Constant(new NumberValue(10)));
    AbstractColumn col2 = new ScalarFunctionColumn(
        Lists.<AbstractColumn>newArrayList(new SimpleColumn("weight"), col1),
        Modulo.getInstance());

    // Add selection
View Full Code Here


    selection.addColumn(new SimpleColumn("name"));
    selection.addColumn(new SimpleColumn("weight"));
    q.setSelection(selection);

    AbstractColumn col1 = new ScalarFunctionColumn(
      Lists.<AbstractColumn>newArrayList(), new Constant(new NumberValue(2)));
    AbstractColumn col2 = new ScalarFunctionColumn(
      Lists.<AbstractColumn>newArrayList(new SimpleColumn("weight"), col1),
      Modulo.getInstance());

    QueryFilter filter = new ColumnValueFilter(col2,
View Full Code Here

    Query query = new Query();
    QuerySelection selection = new QuerySelection(); // SELECT (sum(sales) / 7)
    List<AbstractColumn> columns = Lists.newArrayList();
    columns.add(new AggregationColumn(new SimpleColumn("Sales"), AggregationType.SUM));
    columns.add(new ScalarFunctionColumn(Lists.<AbstractColumn>newArrayList(),
        new Constant(new NumberValue(7))));
    AbstractColumn selectedColumn = new ScalarFunctionColumn(columns, Quotient.getInstance());
    selection.addColumn(selectedColumn);

    query.setSelection(selection);
    QueryGroup group = new QueryGroup();
View Full Code Here

        // selection with modulo ('weight' is a column id): "select weight, weight % 10"
        Query q = new Query();

        AbstractColumn col1 = new ScalarFunctionColumn(
                Lists.<AbstractColumn>newArrayList(), new Constant(new NumberValue(10)));
        AbstractColumn col2 = new ScalarFunctionColumn(
                Lists.<AbstractColumn>newArrayList(new SimpleColumn("weight"), col1),
                Modulo.getInstance());

        // Add selection
View Full Code Here

        selection.addColumn(new SimpleColumn("name"));
        selection.addColumn(new SimpleColumn("weight"));
        q.setSelection(selection);

        AbstractColumn col1 = new ScalarFunctionColumn(
                Lists.<AbstractColumn>newArrayList(), new Constant(new NumberValue(2)));
        AbstractColumn col2 = new ScalarFunctionColumn(
                Lists.<AbstractColumn>newArrayList(new SimpleColumn("weight"), col1),
                Modulo.getInstance());

        QueryFilter filter = new ColumnValueFilter(col2,
View Full Code Here

        Query query = new Query();
        QuerySelection selection = new QuerySelection(); // SELECT (sum(sales) / 7)
        List<AbstractColumn> columns = Lists.newArrayList();
        columns.add(new AggregationColumn(new SimpleColumn("Sales"), AggregationType.SUM));
        columns.add(new ScalarFunctionColumn(Lists.<AbstractColumn>newArrayList(),
                new Constant(new NumberValue(7))));
        AbstractColumn selectedColumn = new ScalarFunctionColumn(columns, Quotient.getInstance());
        selection.addColumn(selectedColumn);

        query.setSelection(selection);
        QueryGroup group = new QueryGroup();
View Full Code Here

      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:
View Full Code Here

TOP

Related Classes of com.google.visualization.datasource.query.scalarfunction.Constant

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.