Package com.google.visualization.datasource.query

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

1477
1478
1479
1480
1481
1482
1483
1484
1485
1486
1487
1488
    pivot.addColumn(new SimpleColumn("Songs"));
    query.setPivot(pivot);
    QueryLabels labels = new QueryLabels();
    labels.addLabel(selectedColumn, "foo");
    query.setLabels(labels);
    QueryFormat format = new QueryFormat();
    format.addPattern(selectedColumn, "'$'@@@");
    query.setUserFormatOptions(format);

    DataTable data = MockDataSource.getData(1);

    // Also tests different locale (note the commas in the numbers)
View Full Code Here
410
411
412
413
414
415
416
417
  // FORMAT clause tests

  public void testOneValidFormatWithDoubleQuotes() throws Exception {
    Query query = QueryBuilder.getInstance().parseQuery("select c1 Format c1 \"Format 1\" ");
    QueryFormat formats = query.getUserFormatOptions();
    assertEquals("Format 1", formats.getPattern(new SimpleColumn("c1")));
  }
View Full Code Here
416
417
418
419
420
421
422
423
    assertEquals("Format 1", formats.getPattern(new SimpleColumn("c1")));
  }

  public void testOneValidFormatWithSingleQuote() throws Exception {
    Query query = QueryBuilder.getInstance().parseQuery("select c1 Format c1 'Format 1' ");
    QueryFormat formats = query.getUserFormatOptions();
    assertEquals("Format 1", formats.getPattern(new SimpleColumn("c1")));
  }
View Full Code Here
423
424
425
426
427
428
429
430
431
  }

  public void testTwoValidFormats() throws Exception {
    Query query = QueryBuilder.getInstance().parseQuery(
        "select c1,c2 Format c1 'Format 1', c2 'Format 2' ");
    QueryFormat formats = query.getUserFormatOptions();
    assertEquals("Format 1", formats.getPattern(new SimpleColumn("c1")));
    assertEquals("Format 2", formats.getPattern(new SimpleColumn("c2")));
  }
View Full Code Here
249
250
251
252
253
254
255
256
257
258
259
260
261
262
          }
          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
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
      ColumnIndices columnIndices, ULocale locale) {
    if (!query.hasUserFormatOptions()) {
      return table;
    }

    QueryFormat queryFormat = query.getUserFormatOptions();
    List<ColumnDescription> columnDescriptions = table.getColumnDescriptions();
    Map<Integer, ValueFormatter> indexToFormatter = Maps.newHashMap();
    for (AbstractColumn col : queryFormat.getColumns()) {
      String pattern = queryFormat.getPattern(col);
      List<Integer> indices = columnIndices.getColumnIndices(col);
      boolean allSucceeded = true;
      for (int i : indices) {
        ColumnDescription colDesc = columnDescriptions.get(i);
        ValueFormatter f = ValueFormatter.createFromPattern(colDesc.getType(), pattern, locale);
View Full Code Here
73
74
75
76
77
78
79
80
81
82
83
84
    q.setRowLimit(7);
    q.setRowOffset(17);
    QueryLabels labels = new QueryLabels();
    labels.addLabel(new SimpleColumn("A"), "bar");
    q.setLabels(labels);
    QueryFormat format = new QueryFormat();
    format.addPattern(new SimpleColumn("A"), "foo");
    q.setUserFormatOptions(format);
    QueryOptions options = new QueryOptions();
    options.setNoFormat(true);
    q.setOptions(options);
    QueryGroup group = new QueryGroup();
View Full Code Here
243
244
245
246
247
248
249
250
251
252
253
254
255
256
                    }
                    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) {
View Full Code Here
238
239
240
241
242
243
244
245
246
247
248
249
250
251
          }
          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
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
    query.setLabels(labels);
  }

// The format clause (e.g., FORMAT c1 "#", c3 "dd-MM-YYYY")
  final public void formatClause(Query query) throws ParseException, InvalidQueryException {
  QueryFormat formats = new QueryFormat();
  AbstractColumn column;
  String pattern;
    jj_consume_token(KW_FORMAT);
    column = abstractColumnDescriptor();
    pattern = stringLiteral();
    formats.addPattern(column, pattern);
    label_6:
    while (true) {
      switch ((jj_ntk==-1)?jj_ntk():jj_ntk) {
      case OP_COMMA:
        ;
        break;
      default:
        jj_la1[16] = jj_gen;
        break label_6;
      }
      jj_consume_token(OP_COMMA);
      column = abstractColumnDescriptor();
      pattern = stringLiteral();
      formats.addPattern(column, pattern);
    }
    query.setUserFormatOptions(formats);
  }
View Full Code Here
TOP

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

  • com.google.visualization.datasource.query.engine.QueryEngine
  • com.google.visualization.datasource.query.engine.QueryEngineTest
  • com.google.visualization.datasource.query.parser.QueryBuilderTest
  • com.google.visualization.datasource.query.parser.QueryParser
  • com.google.visualization.datasource.QuerySplitter
  • com.google.visualization.datasource.QuerySplitterTest
  • org.apache.commons.lang.text.StrBuilder
  • org.apache.commons.lang3.text.StrBuilder
  • com.google.visualization.datasource.base.InvalidQueryException
    • 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.