Package com.google.visualization.datasource.datatable.value

Examples of com.google.visualization.datasource.datatable.value.Value


        Query query = QueryBuilder.getInstance().parseQuery(" WHERE `selEct` = 'baba'");
        QueryFilter filter = query.getFilter();
        assertTrue(filter instanceof ColumnValueFilter);
        ColumnValueFilter f = (ColumnValueFilter) filter;
        assertEquals("selEct", f.getColumn().getId());
        Value val = f.getValue();
        assertTrue(val instanceof TextValue);
        TextValue v = (TextValue) val;
        assertEquals("baba", v.toString());
        assertEquals(ComparisonFilter.Operator.EQ, f.getOperator());
    }
View Full Code Here


        Query query = QueryBuilder.getInstance().parseQuery(" WHERE MiN <> \"baba\"");
        QueryFilter filter = query.getFilter();
        assertTrue(filter instanceof ColumnValueFilter);
        ColumnValueFilter f = (ColumnValueFilter) filter;
        assertEquals("MiN", f.getColumn().getId());
        Value val = f.getValue();
        assertTrue(val instanceof TextValue);
        TextValue v = (TextValue) val;
        assertEquals("baba", v.toString());
        assertEquals(ComparisonFilter.Operator.NE, f.getOperator());
    }
View Full Code Here

        Query query = QueryBuilder.getInstance().parseQuery(" WHERE c1 != trUe");
        QueryFilter filter = query.getFilter();
        assertTrue(filter instanceof ColumnValueFilter);
        ColumnValueFilter f = (ColumnValueFilter) filter;
        assertEquals("c1", f.getColumn().getId());
        Value val = f.getValue();
        assertTrue(val instanceof BooleanValue);
        BooleanValue v = (BooleanValue) val;
        assertEquals(true, v.getValue());
        assertEquals(ComparisonFilter.Operator.NE, f.getOperator());
    }
View Full Code Here

        Query query = QueryBuilder.getInstance().parseQuery(" WHERE `min` >= FalSe");
        QueryFilter filter = query.getFilter();
        assertTrue(filter instanceof ColumnValueFilter);
        ColumnValueFilter f = (ColumnValueFilter) filter;
        assertEquals("min", f.getColumn().getId());
        Value val = f.getValue();
        assertTrue(val instanceof BooleanValue);
        BooleanValue v = (BooleanValue) val;
        assertEquals(false, v.getValue());
        assertEquals(ComparisonFilter.Operator.GE, f.getOperator());
        assertEquals(false, f.isComparisonOrderReversed());
View Full Code Here

        Query query = QueryBuilder.getInstance().parseQuery(" WHERE -.3 < `ba ba`");
        QueryFilter filter = query.getFilter();
        assertTrue(filter instanceof ColumnValueFilter);
        ColumnValueFilter f = (ColumnValueFilter) filter;
        assertEquals("ba ba", f.getColumn().getId());
        Value val = f.getValue();
        assertTrue(val instanceof NumberValue);
        NumberValue v = (NumberValue) val;
        assertEquals(-0.3, v.getValue());
        assertEquals(ComparisonFilter.Operator.LT, f.getOperator());
        assertEquals(true, f.isComparisonOrderReversed());
View Full Code Here

        Query query = QueryBuilder.getInstance().parseQuery(" WHERE 'select' > count  ");
        QueryFilter filter = query.getFilter();
        assertTrue(filter instanceof ColumnValueFilter);
        ColumnValueFilter f = (ColumnValueFilter) filter;
        assertEquals("count", f.getColumn().getId());
        Value val = f.getValue();
        assertTrue(val instanceof TextValue);
        TextValue v = (TextValue) val;
        assertEquals("select", v.toString());
        assertEquals(ComparisonFilter.Operator.GT, f.getOperator());
        assertEquals(true, f.isComparisonOrderReversed());
View Full Code Here

        Query query = QueryBuilder.getInstance().parseQuery(" WHERE false <> `false`  ");
        QueryFilter filter = query.getFilter();
        assertTrue(filter instanceof ColumnValueFilter);
        ColumnValueFilter f = (ColumnValueFilter) filter;
        assertEquals("false", f.getColumn().getId());
        Value val = f.getValue();
        assertTrue(val instanceof BooleanValue);
        BooleanValue v = (BooleanValue) val;
        assertEquals(false, v.getValue());
        assertEquals(ComparisonFilter.Operator.NE, f.getOperator());
        assertEquals(true, f.isComparisonOrderReversed());
View Full Code Here

     *
     * @param values A list with the values that the scalar function is performed on them.
     * @return A date value with the appropriate date.
     */
    public Value evaluate(List<Value> values) {
        Value value = values.get(0);
        Date date;
        GregorianCalendar gc = new GregorianCalendar(TimeZone.getTimeZone("GMT"));

        // If the given value is null, return a null date value.
        if(value.isNull()) {
            return DateValue.getNullValue();
        }
        DateValue dateValue;
        switch(value.getType()) {
            case DATE:
                dateValue = (DateValue) value;
                break;
            case DATETIME:
                dateValue = new DateValue((GregorianCalendar)
                        (((DateTimeValue) value).getObjectToFormat()));
                break;
            case NUMBER:
                date = new Date((long) ((NumberValue) value).getValue());
                gc.setTime(date);
                dateValue = new DateValue(gc);
                break;
            default:// Should never get here.
                throw new RuntimeException("Value type was not found: " + value.getType());
        }
        return dateValue;
    }
View Full Code Here

     *
     * @param type The type of aggregation requested.
     * @return The requested value.
     */
    public Value getValue(AggregationType type) {
        Value v;
        switch(type) {
            case AVG:
                v = (count != 0) ? new NumberValue(getAverage()) : NumberValue.getNullValue();
                break;
            case COUNT:
                v = new NumberValue(count);
                break;
            case MAX:
                v = max;
                // If there are zero rows replace with the same type null value.
                if(count == 0) {
                    v = Value.getNullValueFromValueType(v.getType());
                }
                break;
            case MIN:
                v = min;
                // If there are zero rows replace with the same type null value.
                if(count == 0) {
                    v = Value.getNullValueFromValueType(v.getType());
                }
                break;
            case SUM:
                v = (count != 0) ? new NumberValue(getSum()) : NumberValue.getNullValue();
                break;
View Full Code Here

     *         constant value; false otherwise.
     */
    @Override
    public boolean isMatch(DataTable table, TableRow row) {
        DataTableColumnLookup lookup = new DataTableColumnLookup(table);
        Value columnValue = column.getValue(lookup, row);
        return isComparisonOrderReversed ? isOperatorMatch(value, columnValue) :
                isOperatorMatch(columnValue, value);
    }
View Full Code Here

TOP

Related Classes of com.google.visualization.datasource.datatable.value.Value

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.