tech.tablesaw.api

Class QueryHelper

java.lang.Object

tech.tablesaw.api.QueryHelper

public class QueryHelper
extends Object

A static utility class designed to take some of the work, and verbosity, out of making queries.

It is intended to be imported statically in any class that will run queries as it makes them easier to write - and read.

Constructor Summary

Constructors

Constructor and Description
QueryHelper()

Method Summary

Modifier and Type	Method and Description
static Filter	allOf(Collection<Filter> filters)
static Filter	allOf(Filter... filters)
static Filter	and(Collection<Filter> filters)
static Filter	and(Filter... filters)
static Filter	anyOf(Collection<Filter> filters)
static Filter	anyOf(Filter... filters)
static Filter	both(Filter a, Filter b)
static ColumnReference	column(String columnName) Returns a column reference for a column with the given name.
static Filter	either(Filter a, Filter b)
static Filter	isFalse(Filter filter)
static Filter	isTrue(Filter filter)
static Filter	not(Filter filter)
static Filter	or(Collection<Filter> filters)
static Filter	or(Filter... filters)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

QueryHelper

public QueryHelper()

Method Detail

column

public static ColumnReference column(String columnName)

Returns a column reference for a column with the given name. It will be resolved at query time by associating it with a table. At construction time, the columnType it will resolve to is unknown.

both

public static Filter both(Filter a,
                          Filter b)

allOf

public static Filter allOf(Filter... filters)

allOf

public static Filter allOf(Collection<Filter> filters)

and

public static Filter and(Filter... filters)

and

public static Filter and(Collection<Filter> filters)

not

public static Filter not(Filter filter)

isFalse

public static Filter isFalse(Filter filter)

isTrue

public static Filter isTrue(Filter filter)

either

public static Filter either(Filter a,
                            Filter b)

anyOf

public static Filter anyOf(Filter... filters)

anyOf

public static Filter anyOf(Collection<Filter> filters)

or

public static Filter or(Filter... filters)

or

public static Filter or(Collection<Filter> filters)