Package com.google.visualization.datasource.datatable

Examples of com.google.visualization.datasource.datatable.ColumnDescription


        row.addCell(new TableCell("a"));
        row.addCell(new TableCell(123));
        row.addCell(new TableCell("a"));

        DataTable table = new DataTable();
        table.addColumn(new ColumnDescription("c1", ValueType.TEXT, "c1"));
        table.addColumn(new ColumnDescription("c2", ValueType.TEXT, "c2"));
        table.addColumn(new ColumnDescription("c3", ValueType.TEXT, "c3"));

        ColumnColumnFilter filter = new ColumnColumnFilter(new SimpleColumn("c3"),
                new SimpleColumn("c1"), ComparisonFilter.Operator.NE);
        assertFalse(filter.isMatch(table, row));
    }
View Full Code Here


    public void testSimpleDataTableToCsv() throws DataSourceException {
        List<TableRow> rows;

        DataTable testData = new DataTable();
        ColumnDescription c0 = new ColumnDescription("A", ValueType.TEXT, "col0");
        ColumnDescription c1 = new ColumnDescription("B", ValueType.NUMBER, "col1");
        ColumnDescription c2 = new ColumnDescription("C", ValueType.BOOLEAN, "col2");

        testData.addColumn(c0);
        testData.addColumn(c1);
        testData.addColumn(c2);
View Full Code Here

    public void testCustomPropertiesToCsv() throws DataSourceException {
        List<TableRow> rows;

        DataTable testData;
        testData = new DataTable();
        ColumnDescription c0 = new ColumnDescription("A", ValueType.TEXT, "col0");
        ColumnDescription c1 = new ColumnDescription("B", ValueType.NUMBER, "col1");
        c1.setCustomProperty("arak", "elit");

        testData.addColumn(c0);
        testData.addColumn(c1);

        rows = Lists.newArrayList();
View Full Code Here

        // For each column in the table, create the column description. SQL indexes
        // are 1-based.
        for(int i = 1; i <= numOfCols; i++) {
            String id = (columnIdsList == null) ? metaData.getColumnLabel(i) :
                    columnIdsList.get(i - 1);
            ColumnDescription columnDescription =
                    new ColumnDescription(id,
                            sqlTypeToValueType(metaData.getColumnType(i)),
                            metaData.getColumnLabel(i));
            result.addColumn(columnDescription);
        }
        return result;
View Full Code Here

                // Fill the defaults in the tableDescription.
                // This allows easy-to-write table descriptions
                // (or even null table descriptions).
                for(int i = 0; i < line.length; i++) {
                    ColumnDescription tempColumnDescription =
                            (columnDescriptions.isEmpty() || columnDescriptions.get(i) == null)
                                    ? null
                                    : columnDescriptions.get(i);

                    String id =
                            ((tempColumnDescription == null) || (tempColumnDescription.getId() == null))
                                    ? "Col" + (i) : tempColumnDescription.getId();
                    ValueType type =
                            ((tempColumnDescription == null) || (tempColumnDescription.getType() == null))
                                    ? ValueType.TEXT : tempColumnDescription.getType();
                    String label =
                            ((tempColumnDescription == null) || (tempColumnDescription.getLabel() == null))
                                    ? "Column" + i : tempColumnDescription.getLabel();
                    String pattern =
                            ((tempColumnDescription == null) || (tempColumnDescription.getPattern() == null))
                                    ? "" : tempColumnDescription.getPattern();

                    tempColumnDescription = new ColumnDescription(id, type, label);
                    tempColumnDescription.setPattern(pattern);
                    tempColumnDescriptions.add(tempColumnDescription);
                }

                // Deal with header rows.
                if(headerRow) {
                    for(int i = 0; i < line.length; i++) {
                        String string = line[i];
                        if(string == null) {
                            tempColumnDescriptions.get(i).setLabel("");
                        }
                        else {
                            tempColumnDescriptions.get(i).setLabel(line[i].trim());
                        }
                    }
                }

                columnDescriptions = tempColumnDescriptions;
                dataTable = new DataTable();
                dataTable.addColumns(columnDescriptions);
            }
            if(!(firstLine && headerRow)) {
                // Need to parse the first line as a regular row.
                TableRow tableRow = new TableRow();
                for(int i = 0; i < line.length; i++) {
                    ColumnDescription columnDescription = columnDescriptions.get(i);
                    ValueType valueType = columnDescription.getType();
                    String string = line[i];
                    if(string != null) {
                        string = string.trim();
                    }
                    String pattern = columnDescription.getPattern();
                    ValueFormatter valueFormatter;
                    if(pattern == null || pattern.equals("")) {
                        valueFormatter = defaultFormatters.get(valueType);
                    }
                    else {
View Full Code Here

                        true, true).toString());
    }

    public void testAppendColumnDescriptionJson() {
        JsonRenderer r = new JsonpRenderer();
        ColumnDescription columnDescription = new ColumnDescription("ID", ValueType.BOOLEAN, "LABEL");
        assertEquals("{\"id\":\"ID\",\"label\":\"LABEL\",\"type\":\"boolean\",\"pattern\":\"\"}",
                r.appendColumnDescriptionJson(
                        columnDescription, new StringBuilder()).toString());

        columnDescription.setPattern("%%%.@@");

        assertEquals("{\"id\":\"ID\",\"label\":\"LABEL\",\"type\":\"boolean\",\"pattern\":\"%%%.@@\"}",
                r.appendColumnDescriptionJson(
                        columnDescription, new StringBuilder()).toString());
    }
View Full Code Here

    public void testSimpleDataTableToJson() throws DataSourceException {
        DataTable testData;
        List<TableRow> rows;

        testData = new DataTable();
        ColumnDescription c0 = new ColumnDescription("A", ValueType.TEXT, "col0");
        ColumnDescription c1 = new ColumnDescription("B", ValueType.NUMBER, "col1");
        ColumnDescription c2 = new ColumnDescription("C", ValueType.BOOLEAN, "col2");

        testData.addColumn(c0);
        testData.addColumn(c1);
        testData.addColumn(c2);
View Full Code Here

    public void testSimpleDataTableWithDatesInJson() throws DataSourceException {
        DataTable testData;
        List<TableRow> rows;

        testData = new DataTable();
        ColumnDescription c0 = new ColumnDescription("DateA", ValueType.DATE, "col0");
        ColumnDescription c1 = new ColumnDescription("DateTimeA", ValueType.DATETIME, "col1");
        ColumnDescription c2 = new ColumnDescription("ValueA", ValueType.NUMBER, "col2");

        testData.addColumn(c0);
        testData.addColumn(c1);
        testData.addColumn(c2);
View Full Code Here

    public void testEntireResponseWithWarnings() throws DataSourceException {
        DataTable testData;
        List<TableRow> rows;

        testData = new DataTable();
        ColumnDescription c0 = new ColumnDescription("A", ValueType.TEXT, "col0");
        ColumnDescription c1 = new ColumnDescription("B", ValueType.NUMBER, "col1");

        testData.addColumn(c0);
        testData.addColumn(c1);

        rows = Lists.newArrayList();
View Full Code Here

    public void testCustomPropertiesToJson() throws DataSourceException {
        DataTable testData;
        List<TableRow> rows;

        testData = new DataTable();
        ColumnDescription c0 = new ColumnDescription("A", ValueType.TEXT, "col0");
        ColumnDescription c1 = new ColumnDescription("B", ValueType.NUMBER, "col1");
        c1.setCustomProperty("arak", "elit");

        testData.addColumn(c0);
        testData.addColumn(c1);

        rows = Lists.newArrayList();
View Full Code Here

TOP

Related Classes of com.google.visualization.datasource.datatable.ColumnDescription

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.