com.landawn.abacus.util

Class CQLBuilder

java.lang.Object

com.landawn.abacus.util.CQLBuilder

Direct Known Subclasses:

CQLBuilder.E, CQLBuilder.E2, CQLBuilder.E3, CQLBuilder.NE, CQLBuilder.NE2, CQLBuilder.NE3, CQLBuilder.RE, CQLBuilder.RE2, CQLBuilder.RE3

public abstract class CQLBuilder
extends java.lang.Object

It's easier to write/maintain the CQL by CQLBuilder and more efficient, comparing to write Cassandra CQL in plain text.
The cql() or pair() method must be called to release resources.
Here is a sample:

String cql = NE.insert("gui", "firstName", "lastName").into("account").cql();
// CQL: INSERT INTO account (gui, first_name, last_name) VALUES (:gui, :firstName, :lastName)

Since:

0.8

Author:

Haiyang Li

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static class	CQLBuilder.CP
static class	CQLBuilder.E All the property/column names in collection/map/entity/condition will be converted to lower case with underscore.
static class	CQLBuilder.E2 All the property/column names in collection/map/entity/condition will be converted to upper case with underscore.
static class	CQLBuilder.E3 All the property/column names in collection/map/entity/condition will be kept without any change.
static class	CQLBuilder.NE All the property/column names in collection/map/entity/condition will be converted to lower case with underscore and the cql will be parameterized with named parameter with Hibernate/JPA format :parameterName
static class	CQLBuilder.NE2 All the property/column names in collection/map/entity/condition will be converted to upper case with underscore and the cql will be parameterized with named parameter with Hibernate/JPA format :parameterName
static class	CQLBuilder.NE3 All the property/column names in collection/map/entity/condition will be kept without any change and the cql will be parameterized with named parameter with Hibernate/JPA format :parameterName
static class	CQLBuilder.RE All the property/column names in collection/map/entity/condition will be converted to lower case with underscore and the cql will be parameterized with question mark.
static class	CQLBuilder.RE2 All the property/column names in collection/map/entity/condition will be converted to upper case with underscore and the cql will be parameterized with question mark.
static class	CQLBuilder.RE3 All the property/column names in collection/map/entity/condition will be kept without any change and the cql will be parameterized with question mark.

Field Summary

Fields

Modifier and Type	Field and Description
static java.lang.String	COUNT_ALL
static java.lang.String	DISTINCT

Method Summary

Modifier and Type	Method and Description
<EX extends java.lang.Exception> void	accept(Try.Consumer<? super CQLBuilder.CP,EX> consumer)
CQLBuilder	allowFiltering()
<T,EX extends java.lang.Exception> T	apply(Try.Function<? super CQLBuilder.CP,T,EX> func)
java.lang.String	cql() This CQLBuilder will be closed after cql() is called.
CQLBuilder	from(java.lang.Class<?> entityClass)
CQLBuilder	from(java.util.Collection<java.lang.String> tableNames)
CQLBuilder	from(java.util.Map<java.lang.String,java.lang.String> tableAliases)
CQLBuilder	from(java.lang.String... tableNames)
CQLBuilder	from(java.lang.String expr)
CQLBuilder	ifExists()
CQLBuilder	iff(Condition cond)
CQLBuilder	iff(java.lang.String expr)
CQLBuilder	ifNotExists()
CQLBuilder	into(java.lang.Class<?> entityClass)
CQLBuilder	into(java.lang.String tableName)
CQLBuilder	limit(int count)
CQLBuilder	orderBy(java.util.Collection<java.lang.String> columnNames)
CQLBuilder	orderBy(java.util.Collection<java.lang.String> columnNames, com.landawn.abacus.util.SortDirection direction)
CQLBuilder	orderBy(java.util.Map<java.lang.String,com.landawn.abacus.util.SortDirection> orders)
CQLBuilder	orderBy(java.lang.String... columnNames)
CQLBuilder	orderBy(java.lang.String expr)
CQLBuilder	orderBy(java.lang.String columnName, com.landawn.abacus.util.SortDirection direction)
CQLBuilder.CP	pair() This CQLBuilder will be closed after pair() is called.
java.util.List<java.lang.Object>	parameters()
CQLBuilder	set(java.lang.Class<?> entityClass)
CQLBuilder	set(java.lang.Class<?> entityClass, java.util.Set<java.lang.String> excludedPropNames)
CQLBuilder	set(java.util.Collection<java.lang.String> columnNames)
CQLBuilder	set(java.util.Map<java.lang.String,java.lang.Object> props)
CQLBuilder	set(java.lang.Object entity) Only the dirty properties will be set into the result CQL if the specified entity is a dirty marker entity.
CQLBuilder	set(java.lang.Object entity, java.util.Set<java.lang.String> excludedPropNames) Only the dirty properties will be set into the result SQL if the specified entity is a dirty marker entity.
CQLBuilder	set(java.lang.String... columnNames)
CQLBuilder	set(java.lang.String expr)
java.lang.String	toString()
CQLBuilder	usingTimestamp(java.util.Date timestamp)
CQLBuilder	usingTimestamp(long timestamp)
CQLBuilder	usingTimestamp(java.lang.String timestamp)
CQLBuilder	usingTTL(long timestamp)
CQLBuilder	usingTTL(java.lang.String timestamp)
CQLBuilder	where(Condition cond)
CQLBuilder	where(java.lang.String expr)

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, wait, wait, wait

Field Detail

DISTINCT

public static final java.lang.String DISTINCT

See Also:

Constant Field Values

COUNT_ALL

public static final java.lang.String COUNT_ALL

See Also:

Constant Field Values

Method Detail

into

public CQLBuilder into(java.lang.String tableName)

into

public CQLBuilder into(java.lang.Class<?> entityClass)

from

public CQLBuilder from(java.lang.String expr)

from

@SafeVarargs
public final CQLBuilder from(java.lang.String... tableNames)

from

public CQLBuilder from(java.util.Collection<java.lang.String> tableNames)

from

public CQLBuilder from(java.util.Map<java.lang.String,java.lang.String> tableAliases)

from

public CQLBuilder from(java.lang.Class<?> entityClass)

where

public CQLBuilder where(java.lang.String expr)

where

public CQLBuilder where(Condition cond)

Parameters:

cond - any literal written in Expression condition won't be formalized

Returns:

orderBy

public CQLBuilder orderBy(java.lang.String expr)

orderBy

@SafeVarargs
public final CQLBuilder orderBy(java.lang.String... columnNames)

orderBy

public CQLBuilder orderBy(java.lang.String columnName,
                          com.landawn.abacus.util.SortDirection direction)

orderBy

public CQLBuilder orderBy(java.util.Collection<java.lang.String> columnNames)

orderBy

public CQLBuilder orderBy(java.util.Collection<java.lang.String> columnNames,
                          com.landawn.abacus.util.SortDirection direction)

orderBy

public CQLBuilder orderBy(java.util.Map<java.lang.String,com.landawn.abacus.util.SortDirection> orders)

limit

public CQLBuilder limit(int count)

set

public CQLBuilder set(java.lang.String expr)

set

@SafeVarargs
public final CQLBuilder set(java.lang.String... columnNames)

set

public CQLBuilder set(java.util.Collection<java.lang.String> columnNames)

set

public CQLBuilder set(java.util.Map<java.lang.String,java.lang.Object> props)

set

public CQLBuilder set(java.lang.Object entity)

Only the dirty properties will be set into the result CQL if the specified entity is a dirty marker entity.

Parameters:

entity -

Returns:

set

public CQLBuilder set(java.lang.Object entity,
                      java.util.Set<java.lang.String> excludedPropNames)

Only the dirty properties will be set into the result SQL if the specified entity is a dirty marker entity.

Parameters:

entity -

excludedPropNames -

Returns:

set

public CQLBuilder set(java.lang.Class<?> entityClass)

set

public CQLBuilder set(java.lang.Class<?> entityClass,
                      java.util.Set<java.lang.String> excludedPropNames)

usingTTL

public CQLBuilder usingTTL(long timestamp)

usingTTL

public CQLBuilder usingTTL(java.lang.String timestamp)

usingTimestamp

public CQLBuilder usingTimestamp(java.util.Date timestamp)

usingTimestamp

public CQLBuilder usingTimestamp(long timestamp)

usingTimestamp

public CQLBuilder usingTimestamp(java.lang.String timestamp)

iff

public CQLBuilder iff(java.lang.String expr)

iff

public CQLBuilder iff(Condition cond)

Parameters:

cond - any literal written in Expression condition won't be formalized

Returns:

ifExists

public CQLBuilder ifExists()

ifNotExists

public CQLBuilder ifNotExists()

allowFiltering

public CQLBuilder allowFiltering()

cql

public java.lang.String cql()

This CQLBuilder will be closed after cql() is called.

Returns:

parameters

public java.util.List<java.lang.Object> parameters()

pair

public CQLBuilder.CP pair()

This CQLBuilder will be closed after pair() is called.

Returns:

the pair of cql and parameters.

apply

public <T,EX extends java.lang.Exception> T apply(Try.Function<? super CQLBuilder.CP,T,EX> func)
                                           throws EX extends java.lang.Exception

Throws:

EX extends java.lang.Exception

accept

public <EX extends java.lang.Exception> void accept(Try.Consumer<? super CQLBuilder.CP,EX> consumer)
                                             throws EX extends java.lang.Exception

Throws:

EX extends java.lang.Exception

toString

public java.lang.String toString()

Overrides:

toString in class java.lang.Object