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

Package com.google.visualization.datasource.query

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

com.google.visualization.datasource.query.ColumnIsNullFilter
A filter that matches null values. Its isMatch function returns true if the value at the column is a null value (as defined by TableCell.isNull()). @author Yonatan B.Y.

    SqlDataSourceHelper.appendWhereClause(query, queryStringBuilder);
    assertEquals(queryStringBuilder.toString(), "WHERE ((`ID`=`Salary`)) ",
        queryStringBuilder.toString());
    
    // Check "is null".
    ColumnIsNullFilter isNullFilter = new ColumnIsNullFilter(new SimpleColumn("ID"));
    query.setFilter(isNullFilter);
    queryStringBuilder = new StrBuilder();
    SqlDataSourceHelper.appendWhereClause(query, queryStringBuilder);
    assertEquals("WHERE (`ID` IS NULL) ", queryStringBuilder.toString());

View Full Code Here

   * @param whereClause A string builder representing the WHERE clause of the SQL query.
   * @param queryFilter The query filter.
   */
  private static void buildWhereClauseForIsNullFilter(StrBuilder whereClause,
      QueryFilter queryFilter) {
    ColumnIsNullFilter filter = (ColumnIsNullFilter) queryFilter;
 
    whereClause.append("(").append(getColumnId(filter.getColumn())).append(" IS NULL)");
  }

View Full Code Here

  }


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

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

   * Tests the query splitter with a datasource with SQL/SORT_AND_PAGINATION
   * CapabilitySets, when the query contains a scalar function column.
   */
  public void testSplittingWithScalarFunctions() throws Exception {
    List<AbstractColumn> columnList = Lists.<AbstractColumn>newArrayList(new SimpleColumn("A"));
    q.setFilter(new ColumnIsNullFilter(new ScalarFunctionColumn(columnList,
        TimeComponentExtractor.getInstance(TimeComponentExtractor.TimeComponent.YEAR))));
    
    QueryPair split = QuerySplitter.splitQuery(q, Capabilities.SQL);
    Query dataSourceQuery = split.getDataSourceQuery();

View Full Code Here

   * @param whereClause A string builder representing the WHERE clause of the SQL query.
   * @param queryFilter The query filter.
   */
  private static void buildWhereClauseForIsNullFilter(StrBuilder whereClause,
      QueryFilter queryFilter) {
    ColumnIsNullFilter filter = (ColumnIsNullFilter) queryFilter;
 
    whereClause.append("(").append(filter.getColumn().getId()).append(" IS NULL)");
  }

View Full Code Here

        case KW_IS:
          jj_consume_token(KW_IS);
          switch ((jj_ntk==-1)?jj_ntk():jj_ntk) {
          case KW_NULL:
            jj_consume_token(KW_NULL);
                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.ColumnIsNullFilter

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

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

com.google.visualization.datasource.QuerySplitterTest

com.google.visualization.datasource.util.SqlDataSourceHelper

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.