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

Package com.google.visualization.datasource.query

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

com.google.visualization.datasource.query.NegationFilter
A negation filter. Holds a sub-filter and negates its result, acting like the NOT operator. @author Yonatan B.Y.

    QueryFilter f3 = subFilters.get(2);
    QueryFilter f4 = subFilters.get(3);


    // f1: (!(c1 < c2))
    assertTrue(f1 instanceof NegationFilter);
    NegationFilter nf = (NegationFilter) f1;
    QueryFilter subFilter = nf.getSubFilter();
    assertTrue(subFilter instanceof ColumnColumnFilter);
    assertEquals(Sets.newHashSet("c1", "c2"), subFilter.getAllColumnIds());


    // f2: ((!(c3<c4)) && (!(c5<c6)))))
    assertTrue(f2 instanceof CompoundFilter);

View Full Code Here

  }


  public void testIsNotNull() throws Exception {
    Query query = QueryBuilder.getInstance().parseQuery("WHERE a iS NOt nULl");
    assertTrue(query.getFilter() instanceof NegationFilter);
    NegationFilter filter = (NegationFilter) query.getFilter();
    assertTrue(filter.getSubFilter() instanceof ColumnIsNullFilter);
    ColumnIsNullFilter filter2 = (ColumnIsNullFilter) filter.getSubFilter();
    assertEquals("a", filter2.getColumn().getId());
  }

View Full Code Here

    queryStringBuilder = new StrBuilder();
    SqlDataSourceHelper.appendWhereClause(query, queryStringBuilder);
    assertEquals("WHERE (`ID` IS NULL) ", queryStringBuilder.toString());


    // Check negation.
    NegationFilter negationFilter =
        new NegationFilter(new ColumnColumnFilter(new SimpleColumn("ID"),
        new SimpleColumn("Salary"), ComparisonFilter.Operator.EQ));
    query.setFilter(negationFilter);
    queryStringBuilder = new StrBuilder();
    SqlDataSourceHelper.appendWhereClause(query, queryStringBuilder);
    assertEquals("WHERE (NOT (`ID`=`Salary`)) ", queryStringBuilder.toString());

View Full Code Here


  public void testNegationFilter() throws Exception {
    Query query = QueryBuilder.getInstance().parseQuery(" WHERE not (c1 < c2) ");
    QueryFilter filter = query.getFilter();
    assertTrue(filter instanceof NegationFilter);
    NegationFilter f = (NegationFilter) filter;
    QueryFilter subFilter = f.getSubFilter();
    assertTrue(subFilter instanceof ColumnColumnFilter);
    ColumnColumnFilter ccf = (ColumnColumnFilter) subFilter;
    assertEquals("c1", ccf.getFirstColumn().getId());
    assertEquals("c2", ccf.getSecondColumn().getId());
    assertEquals(ComparisonFilter.Operator.LT, ccf.getOperator());

View Full Code Here

    QueryFilter f2 = subFilters.get(1);
    QueryFilter f3 = subFilters.get(2);


    // f1: (!((c1 < c2) || (!(c3 < c4)))
    assertTrue(f1 instanceof NegationFilter);
    NegationFilter nf = (NegationFilter) f1;
    QueryFilter subFilter = nf.getSubFilter();
    assertTrue(subFilter instanceof CompoundFilter);
    CompoundFilter cf = (CompoundFilter) subFilter;
    assertEquals(CompoundFilter.LogicalOperator.OR, cf.getOperator());
    subFilters = cf.getSubFilters();
    assertEquals(2, subFilters.size());
    assertTrue(subFilters.get(0) instanceof ColumnColumnFilter);
    assertEquals(Sets.newHashSet("c1", "c2"),
        subFilters.get(0).getAllColumnIds());
    assertTrue(subFilters.get(1) instanceof NegationFilter);
    nf = (NegationFilter) subFilters.get(1);
    assertTrue(nf.getSubFilter() instanceof ColumnColumnFilter);
    assertEquals(Sets.newHashSet("c3", "c4"),
        nf.getSubFilter().getAllColumnIds());


    //f2: (!((!(!(c5 < c6))) || (c7 < c8)))
    assertTrue(f2 instanceof NegationFilter);
    nf = (NegationFilter) f2;
    assertTrue(nf.getSubFilter() instanceof CompoundFilter);
    cf = (CompoundFilter) nf.getSubFilter();
    assertEquals(CompoundFilter.LogicalOperator.OR, cf.getOperator());
    subFilters = cf.getSubFilters();
    assertEquals(2, subFilters.size());
    assertTrue(subFilters.get(0) instanceof NegationFilter);
    assertTrue(subFilters.get(1) instanceof ColumnColumnFilter);
    assertEquals(Sets.newHashSet("c7", "c8"),
        subFilters.get(1).getAllColumnIds());
    nf = (NegationFilter) subFilters.get(0);
    assertTrue(nf.getSubFilter() instanceof NegationFilter);
    nf = (NegationFilter) nf.getSubFilter();
    assertTrue(nf.getSubFilter() instanceof ColumnColumnFilter);
    assertEquals(Sets.newHashSet("c5", "c6"),
        nf.getSubFilter().getAllColumnIds());


    //f3: ((c9 < c10) && ((c11 < c12)||((c13 < c14)&&(c15 < c16))))
    assertTrue(f3 instanceof CompoundFilter);
    cf = (CompoundFilter) f3;
    assertEquals(CompoundFilter.LogicalOperator.AND, cf.getOperator());

View Full Code Here

  QueryFilter filter;
    switch ((jj_ntk==-1)?jj_ntk():jj_ntk) {
    case KW_NOT:
      jj_consume_token(KW_NOT);
      subFilter = primaryExpression();
        filter = new NegationFilter(subFilter);
      break;
    case KW_TRUE:
    case KW_FALSE:
    case KW_DATE:
    case KW_TIMEOFDAY:

View Full Code Here

                filter = new ColumnIsNullFilter(col1);
            break;
          case KW_NOT:
            jj_consume_token(KW_NOT);
            jj_consume_token(KW_NULL);
                filter = new NegationFilter(new ColumnIsNullFilter(col1));
            break;
          default:
            jj_la1[22] = jj_gen;
            jj_consume_token(-1);
            throw new ParseException();

View Full Code Here

TOP

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

com.google.visualization.datasource.query.parser.QueryBuilderTest

com.google.visualization.datasource.query.parser.QueryParser

com.google.visualization.datasource.util.SqlDataSourceHelperTest

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.