In-memory query engine over typed columns. Tables are filled row by row or loaded from sources (CSV files, folders, the program's own objects) and queried with SQL-like statements; aggregates, Describe() and Finder (file search) are included. Compile with -lib query.
Col
Starts a condition on a column
Example
p := Col->Of("value")->Gt(0.5)->AndAlso(Col->Of("grp")->Eq("g7"));Operations
Between #
Between two values, both included
method : public : Between(low:Compare, high:Compare) ~ PredicateParameters
| Name | Type | Description |
|---|---|---|
| low | Compare | lowest value |
| high | Compare | highest value |
Return
| Type | Description |
|---|---|
| Predicate | condition |
Between #
Between two Floats, both included
method : public : Between(low:Float, high:Float) ~ PredicateParameters
| Name | Type | Description |
|---|---|---|
| low | Float | lowest value |
| high | Float | highest value |
Return
| Type | Description |
|---|---|
| Predicate | condition |
Eq #
Equal to a value
method : public : Eq(value:Compare) ~ PredicateParameters
| Name | Type | Description |
|---|---|---|
| value | Compare | value |
Return
| Type | Description |
|---|---|
| Predicate | condition |
Eq #
Equal to an Int
method : public : Eq(value:Int) ~ PredicateParameters
| Name | Type | Description |
|---|---|---|
| value | Int | value |
Return
| Type | Description |
|---|---|
| Predicate | condition |
Eq #
Equal to a Float
method : public : Eq(value:Float) ~ PredicateParameters
| Name | Type | Description |
|---|---|---|
| value | Float | value |
Return
| Type | Description |
|---|---|
| Predicate | condition |
Eq #
Equal to a Bool
method : public : Eq(value:Bool) ~ PredicateParameters
| Name | Type | Description |
|---|---|---|
| value | Bool | value |
Return
| Type | Description |
|---|---|
| Predicate | condition |
Ge #
Greater than or equal to a value
method : public : Ge(value:Compare) ~ PredicateParameters
| Name | Type | Description |
|---|---|---|
| value | Compare | value |
Return
| Type | Description |
|---|---|
| Predicate | condition |
Ge #
Greater than or equal to an Int
method : public : Ge(value:Int) ~ PredicateParameters
| Name | Type | Description |
|---|---|---|
| value | Int | value |
Return
| Type | Description |
|---|---|
| Predicate | condition |
Ge #
Greater than or equal to a Float
method : public : Ge(value:Float) ~ PredicateParameters
| Name | Type | Description |
|---|---|---|
| value | Float | value |
Return
| Type | Description |
|---|---|
| Predicate | condition |
Gt #
Greater than a value
method : public : Gt(value:Compare) ~ PredicateParameters
| Name | Type | Description |
|---|---|---|
| value | Compare | value |
Return
| Type | Description |
|---|---|
| Predicate | condition |
Gt #
Greater than an Int
method : public : Gt(value:Int) ~ PredicateParameters
| Name | Type | Description |
|---|---|---|
| value | Int | value |
Return
| Type | Description |
|---|---|
| Predicate | condition |
Gt #
Greater than a Float
method : public : Gt(value:Float) ~ PredicateParameters
| Name | Type | Description |
|---|---|---|
| value | Float | value |
Return
| Type | Description |
|---|---|
| Predicate | condition |
In #
Equal to any of the values
method : public : In(values:Compare[]) ~ PredicateParameters
| Name | Type | Description |
|---|---|---|
| values | Compare | values |
Return
| Type | Description |
|---|---|
| Predicate | condition |
In #
Equal to any of the strings
method : public : In(values:String[]) ~ PredicateParameters
| Name | Type | Description |
|---|---|---|
| values | String | values |
Return
| Type | Description |
|---|---|
| Predicate | condition |
In #
Equal to any of the Ints
method : public : In(values:Int[]) ~ PredicateParameters
| Name | Type | Description |
|---|---|---|
| values | Int | values |
Return
| Type | Description |
|---|---|
| Predicate | condition |
In #
Equal to any of the Floats
method : public : In(values:Float[]) ~ PredicateParameters
| Name | Type | Description |
|---|---|---|
| values | Float | values |
Return
| Type | Description |
|---|---|
| Predicate | condition |
IsNotNull #
The cell is not empty
method : public : IsNotNull() ~ PredicateReturn
| Type | Description |
|---|---|
| Predicate | condition |
IsNull #
The cell is empty
method : public : IsNull() ~ PredicateReturn
| Type | Description |
|---|---|
| Predicate | condition |
Le #
Less than or equal to a value
method : public : Le(value:Compare) ~ PredicateParameters
| Name | Type | Description |
|---|---|---|
| value | Compare | value |
Return
| Type | Description |
|---|---|
| Predicate | condition |
Le #
Less than or equal to an Int
method : public : Le(value:Int) ~ PredicateParameters
| Name | Type | Description |
|---|---|---|
| value | Int | value |
Return
| Type | Description |
|---|---|
| Predicate | condition |
Le #
Less than or equal to a Float
method : public : Le(value:Float) ~ PredicateParameters
| Name | Type | Description |
|---|---|---|
| value | Float | value |
Return
| Type | Description |
|---|---|
| Predicate | condition |
Like #
Matches an SQL LIKE pattern: '%' any run of characters, '_' any one character
method : public : Like(pattern:String) ~ PredicateParameters
| Name | Type | Description |
|---|---|---|
| pattern | String | pattern |
Return
| Type | Description |
|---|---|
| Predicate | condition |
Lt #
Less than a value
method : public : Lt(value:Compare) ~ PredicateParameters
| Name | Type | Description |
|---|---|---|
| value | Compare | value |
Return
| Type | Description |
|---|---|
| Predicate | condition |
Lt #
Less than an Int
method : public : Lt(value:Int) ~ PredicateParameters
| Name | Type | Description |
|---|---|---|
| value | Int | value |
Return
| Type | Description |
|---|---|
| Predicate | condition |
Lt #
Less than a Float
method : public : Lt(value:Float) ~ PredicateParameters
| Name | Type | Description |
|---|---|---|
| value | Float | value |
Return
| Type | Description |
|---|---|
| Predicate | condition |
Matches #
The whole cell matches a regular expression (Query.RegEx); only text cells take part
method : public : Matches(pattern:String) ~ PredicateParameters
| Name | Type | Description |
|---|---|---|
| pattern | String | regular expression |
Return
| Type | Description |
|---|---|
| Predicate | condition |
Ne #
Not equal to a value; true for cells that cannot be compared with it
method : public : Ne(value:Compare) ~ PredicateParameters
| Name | Type | Description |
|---|---|---|
| value | Compare | value |
Return
| Type | Description |
|---|---|
| Predicate | condition |
Ne #
Not equal to an Int
method : public : Ne(value:Int) ~ PredicateParameters
| Name | Type | Description |
|---|---|---|
| value | Int | value |
Return
| Type | Description |
|---|---|
| Predicate | condition |
Ne #
Not equal to a Float
method : public : Ne(value:Float) ~ PredicateParameters
| Name | Type | Description |
|---|---|---|
| value | Float | value |
Return
| Type | Description |
|---|---|
| Predicate | condition |
NotLike #
Does not match an SQL LIKE pattern; only text cells take part
method : public : NotLike(pattern:String) ~ PredicateParameters
| Name | Type | Description |
|---|---|---|
| pattern | String | pattern |
Return
| Type | Description |
|---|---|
| Predicate | condition |