Examples of IsNull

com.j256.ormlite.stmt.query.IsNull
Internal class handling the SQL 'IS NULL' comparison query part. Used by {@link Where#isNull}. @author graywatson
com.vaadin.data.util.filter.IsNull
Simple container filter checking whether an item property value is null. This filter also directly supports in-memory filtering. @since 6.6
com.wagnerandade.coollection.matcher.custom.IsNull
org.apache.hadoop.hive.ql.exec.vector.expressions.IsNull
This expression evaluates to true if the given input columns is null. The boolean output is stored in the specified output column.
org.jmock.core.constraint.IsNull
Is the value null?
org.objectweb.medor.filter.lib.IsNull
org.teiid.language.IsNull
Represents an IS NULL predicate.

Examples of com.j256.ormlite.stmt.query.IsNull


  /**
   * Add a 'IS NULL' clause so the column must be null. '=' NULL does not work.
   */
  public Where<T, ID> isNull(String columnName) throws SQLException {
    addClause(new IsNull(columnName, findColumnFieldType(columnName)));
    return this;
  }

View Full Code Here

Examples of com.j256.ormlite.stmt.query.IsNull


  /**
   * Add a 'IS NULL' clause so the column must be null. '=' NULL does not work.
   */
  public Where<T, ID> isNull(String columnName) throws SQLException {
    addClause(new IsNull(columnName, findColumnFieldType(columnName)));
    return this;
  }

View Full Code Here

Examples of com.vaadin.data.util.filter.IsNull

    }


    @Test
    public void getWhereStringForFilters_isNull() {
        ArrayList<Filter> filters = new ArrayList<Filter>();
        filters.add(new IsNull("NAME"));
        Assert.assertEquals(" WHERE \"NAME\" IS NULL", QueryBuilder
                .getWhereStringForFilters(filters, new StatementHelper()));
    }

View Full Code Here

Examples of com.vaadin.data.util.filter.IsNull

    }


    @Test
    public void getWhereStringForFilters_isNotNull() {
        ArrayList<Filter> filters = new ArrayList<Filter>();
        filters.add(new Not(new IsNull("NAME")));
        Assert.assertEquals(" WHERE \"NAME\" IS NOT NULL", QueryBuilder
                .getWhereStringForFilters(filters, new StatementHelper()));
    }

View Full Code Here

Examples of com.vaadin.data.util.filter.IsNull


    @Test
    public void getWhereStringForFilters_customStringDecorator() {
        QueryBuilder.setStringDecorator(new StringDecorator("[", "]"));
        ArrayList<Filter> filters = new ArrayList<Filter>();
        filters.add(new Not(new IsNull("NAME")));
        Assert.assertEquals(" WHERE [NAME] IS NOT NULL", QueryBuilder
                .getWhereStringForFilters(filters, new StatementHelper()));
        // Reset the default string decorator
        QueryBuilder.setStringDecorator(new StringDecorator("\"", "\""));
    }

View Full Code Here

Examples of com.vaadin.data.util.filter.IsNull

        return filter instanceof IsNull;
    }


    @Override
    public String getWhereStringForFilter(Filter filter, StatementHelper sh) {
        IsNull in = (IsNull) filter;
        return QueryBuilder.quote(in.getPropertyId()) + " IS NULL";
    }

View Full Code Here

Examples of com.vaadin.data.util.filter.IsNull


    @Override
    public String getWhereStringForFilter(Filter filter, StatementHelper sh) {
        Not not = (Not) filter;
        if (not.getFilter() instanceof IsNull) {
            IsNull in = (IsNull) not.getFilter();
            return QueryBuilder.quote(in.getPropertyId()) + " IS NOT NULL";
        }
        return "NOT "
                + QueryBuilder.getWhereStringForFilter(not.getFilter(), sh);
    }

View Full Code Here

Examples of com.vaadin.data.util.filter.IsNull

    public boolean translatesFilter(Filter filter) {
        return filter instanceof IsNull;
    }


    public String getWhereStringForFilter(Filter filter, StatementHelper sh) {
        IsNull in = (IsNull) filter;
        return QueryBuilder.quote(in.getPropertyId()) + " IS NULL";
    }

View Full Code Here

Examples of com.vaadin.data.util.filter.IsNull

    }


    public String getWhereStringForFilter(Filter filter, StatementHelper sh) {
        Not not = (Not) filter;
        if (not.getFilter() instanceof IsNull) {
            IsNull in = (IsNull) not.getFilter();
            return QueryBuilder.quote(in.getPropertyId()) + " IS NOT NULL";
        }
        return "NOT "
                + QueryBuilder.getWhereStringForFilter(not.getFilter(), sh);
    }

View Full Code Here

Examples of com.vaadin.data.util.filter.IsNull

        return filter instanceof IsNull;
    }


    @Override
    public String getWhereStringForFilter(Filter filter, StatementHelper sh) {
        IsNull in = (IsNull) filter;
        return QueryBuilder.quote(in.getPropertyId()) + " IS NULL";
    }

View Full Code Here

0 1 2 3 4

TOP

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.