com.outworkers.phantom.builder.QueryBuilder
Select
Related Doc:
package QueryBuilder
Creates a select count query builder from a table name, a keyspace, and a list of names.
Creates a select count query builder from a table name, a keyspace, and a list of names. The result of a count returns the number of matches, so the argument to count is fixed. It can either be the ALL symbol(*) or 1, as per the CQL spec.
Will return a query in the following format:
SELECT COUNT(*) FROM $keyspace.$tableName
The name of the table.
The name of the keyspace.
Creates a select clause chaining the "dateOf" operator.
Creates a select clause chaining the "dateOf" operator.
Example output:
dateOf("columnName")The name of the column to apply the operation to.
A CQL query wrapping the "dateOf" clause and the column.
Creates a select distinct query builder from a table name, a keyspace, and a list of names.
Creates a select distinct query builder from a table name, a keyspace, and a list of names. Will return a query in the following format:
SELECT DISTINCT ($name1, $name2, ..) FROM $keyspace.$tableName
The name of the table.
The name of the keyspace.
The names of the columns to include in the select.
Creates a select query builder from a table name, a keyspace, and an arbitrary clause.
Creates a select query builder from a table name, a keyspace, and an arbitrary clause. This is used to serialise SELECT functions, such as WRITETIME or other valid expressions. Will return a query in the following format:
SELECT $clause FROM $keyspace.$tableName
The name of the table.
The name of the keyspace.
The CQL clause to use as the select list value.
Selects an arbitrary number of columns given a table name and a keyspace.
Selects an arbitrary number of columns given a table name and a keyspace. Will return a query in the following format:
SELECT ($name1, $name2, ..) FROM $keyspace.$tableName
The name of the table.
The name of the keyspace.
The names of the columns to include in the select.
A CQLQuery matching the described pattern.
Creates a select all query from a table name and a keyspace.
Creates a select all query from a table name and a keyspace. Will return a query in the following format:
SELECT * FROM keyspace.tableName
The name of the table.
The name of the keyspace.
A CQLQuery matching the described pattern.
Selects an arbitrary number of columns given a table name and a keyspace.
Selects an arbitrary number of columns given a table name and a keyspace. Return all the columns as JSON. Will return a query in the following format:
SELECT JSON ($name1, $name2, ..) FROM $keyspace.$tableName
The name of the table.
The name of the keyspace.
The names of the columns to include in the select.
A CQLQuery matching the described pattern.
Creates a select JSON query builder from a table name, a keyspace, and an arbitrary clause.
Creates a select JSON query builder from a table name, a keyspace, and an arbitrary clause. This is used to serialise SELECT functions, such as WRITETIME or other valid expressions. Will return a query in the following format:
SELECT JSON $clause FROM $keyspace.$tableName
The name of the table.
The name of the keyspace.
The CQL clause to use as the select list value.