com.landawn.abacus.condition

Class ConditionFactory

java.lang.Object

com.landawn.abacus.condition.ConditionFactory

Direct Known Subclasses:

ConditionFactory.L

public class ConditionFactory
extends java.lang.Object

Since:

0.8

Author:

Haiyang Li

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static class	ConditionFactory.L

Field Summary

Fields

Modifier and Type	Field and Description
static com.landawn.abacus.util.SortDirection	ASC
static com.landawn.abacus.util.SortDirection	DESC
static Expression	QME Expression with question mark literal: "?".

Method Summary

Modifier and Type	Method and Description
static All	all(SubQuery condition)
static And	and(java.util.Collection<? extends Condition> conditions)
static And	and(Condition... conditions)
static Any	any(SubQuery condition)
static Between	between(java.lang.String propName)
static Between	between(java.lang.String propName, java.lang.Object minValue, java.lang.Object maxValue)
static Binary	binary(java.lang.String propName, Operator operator, java.lang.Object propValue)
static Between	bt(java.lang.String propName)
static Between	bt(java.lang.String propName, java.lang.Object minValue, java.lang.Object maxValue)
static Cell	cell(Operator operator, Condition condition)
static Like	contains(java.lang.String propName, java.lang.Object propValue)
static Criteria	criteria()
static CrossJoin	crossJoin(java.util.Collection<java.lang.String> joinEntities, Condition condition)
static CrossJoin	crossJoin(java.lang.String joinEntity)
static CrossJoin	crossJoin(java.lang.String joinEntity, Condition condition)
static Like	endsWith(java.lang.String propName, java.lang.Object propValue)
static Equal	eq(java.lang.String propName) It's for parameterized SQL with question mark or named parameters.
static Equal	eq(java.lang.String propName, java.lang.Object propValue)
static And	eqAnd(java.util.Map<java.lang.String,java.lang.Object> props)
static And	eqAnd(java.lang.Object entity)
static Or	eqOr(java.util.Map<java.lang.String,java.lang.Object> props)
static Or	eqOr(java.lang.Object entity)
static Or	eqOr(java.lang.String propName, java.util.Collection<?> propValues)
static Or	eqOr(java.lang.String propName, java.lang.Object... propValues)
static Equal	equal(java.lang.String propName) It's for parameterized SQL with question mark or named parameters.
static Equal	equal(java.lang.String propName, java.lang.Object propValue)
static Except	except(SubQuery condition)
static Exists	exists(SubQuery condition)
static Expression	expr(java.lang.String literal)
static FullJoin	fullJoin(java.util.Collection<java.lang.String> joinEntities, Condition condition)
static FullJoin	fullJoin(java.lang.String joinEntity)
static FullJoin	fullJoin(java.lang.String joinEntity, Condition condition)
static GreaterEqual	ge(java.lang.String propName) It's for parameterized SQL with question mark or named parameters.
static GreaterEqual	ge(java.lang.String propName, java.lang.Object propValue)
static GreaterEqual	greaterEqual(java.lang.String propName) It's for parameterized SQL with question mark or named parameters.
static GreaterEqual	greaterEqual(java.lang.String propName, java.lang.Object propValue)
static GreaterThan	greaterThan(java.lang.String propName) It's for parameterized SQL with question mark or named parameters.
static GreaterThan	greaterThan(java.lang.String propName, java.lang.Object propValue)
static GroupBy	groupBy(java.util.Collection<java.lang.String> propNames)
static GroupBy	groupBy(java.util.Collection<java.lang.String> propNames, com.landawn.abacus.util.SortDirection direction)
static GroupBy	groupBy(Condition condition)
static GroupBy	groupBy(java.util.Map<java.lang.String,com.landawn.abacus.util.SortDirection> orders)
static GroupBy	groupBy(java.lang.String... propNames)
static GroupBy	groupBy(java.lang.String propName, com.landawn.abacus.util.SortDirection direction)
static GreaterThan	gt(java.lang.String propName) It's for parameterized SQL with question mark or named parameters.
static GreaterThan	gt(java.lang.String propName, java.lang.Object propValue)
static Having	having(Condition condition)
static Having	having(java.lang.String condition)
static In	in(java.lang.String propName, java.util.Collection<?> values)
static In	in(java.lang.String propName, java.lang.Object[] values)
static InnerJoin	innerJoin(java.util.Collection<java.lang.String> joinEntities, Condition condition)
static InnerJoin	innerJoin(java.lang.String joinEntity)
static InnerJoin	innerJoin(java.lang.String joinEntity, Condition condition)
static Intersect	intersect(SubQuery condition)
static Is	is(java.lang.String propName, java.lang.Object propValue)
static IsInfinite	isInfinite(java.lang.String propName)
static IsNaN	isNaN(java.lang.String propName)
static IsNot	isNot(java.lang.String propName, java.lang.Object propValue)
static IsNotInfinite	isNotInfinite(java.lang.String propName)
static IsNotNaN	isNotNaN(java.lang.String propName)
static IsNotNull	isNotNull(java.lang.String propName)
static IsNull	isNull(java.lang.String propName)
static Join	join(java.util.Collection<java.lang.String> joinEntities, Condition condition)
static Join	join(java.lang.String joinEntity)
static Join	join(java.lang.String joinEntity, Condition condition)
static Junction	junction(Operator operator, java.util.Collection<? extends Condition> conditions)
static Junction	junction(Operator operator, Condition... conditions)
static LessEqual	le(java.lang.String propName) It's for parameterized SQL with question mark or named parameters.
static LessEqual	le(java.lang.String propName, java.lang.Object propValue)
static LeftJoin	leftJoin(java.util.Collection<java.lang.String> joinEntities, Condition condition)
static LeftJoin	leftJoin(java.lang.String joinEntity)
static LeftJoin	leftJoin(java.lang.String joinEntity, Condition condition)
static LessEqual	lessEqual(java.lang.String propName) It's for parameterized SQL with question mark or named parameters.
static LessEqual	lessEqual(java.lang.String propName, java.lang.Object propValue)
static LessThan	lessThan(java.lang.String propName) It's for parameterized SQL with question mark or named parameters.
static LessThan	lessThan(java.lang.String propName, java.lang.Object propValue)
static Like	like(java.lang.String propName)
static Like	like(java.lang.String propName, java.lang.Object propValue)
static Limit	limit(int count)
static Limit	limit(int offset, int count)
static LessThan	lt(java.lang.String propName) It's for parameterized SQL with question mark or named parameters.
static LessThan	lt(java.lang.String propName, java.lang.Object propValue)
static Minus	minus(SubQuery condition)
static NamedProperty	namedProperty(java.lang.String propName)
static NaturalJoin	naturalJoin(java.util.Collection<java.lang.String> joinEntities, Condition condition)
static NaturalJoin	naturalJoin(java.lang.String joinEntity)
static NaturalJoin	naturalJoin(java.lang.String joinEntity, Condition condition)
static NotEqual	ne(java.lang.String propName) It's for parameterized SQL with question mark or named parameters.
static NotEqual	ne(java.lang.String propName, java.lang.Object propValue)
static NotEqual	notEqual(java.lang.String propName) It's for parameterized SQL with question mark or named parameters.
static NotEqual	notEqual(java.lang.String propName, java.lang.Object propValue)
static Not	notExists(SubQuery condition)
static Not	notLike(java.lang.String propName)
static Not	notLike(java.lang.String propName, java.lang.Object propValue)
static On	on(Condition condition)
static On	on(java.util.Map<java.lang.String,java.lang.String> propNamePair)
static On	on(java.lang.String condition)
static On	on(java.lang.String propName, java.lang.String anoPropName)
static Or	or(java.util.Collection<? extends Condition> conditions)
static Or	or(Condition... conditions)
static OrderBy	orderBy(java.util.Collection<java.lang.String> propNames)
static OrderBy	orderBy(java.util.Collection<java.lang.String> propNames, com.landawn.abacus.util.SortDirection direction)
static OrderBy	orderBy(Condition condition)
static OrderBy	orderBy(java.util.Map<java.lang.String,com.landawn.abacus.util.SortDirection> orders)
static OrderBy	orderBy(java.lang.String... propNames)
static OrderBy	orderBy(java.lang.String propName, com.landawn.abacus.util.SortDirection direction)
static RightJoin	rightJoin(java.util.Collection<java.lang.String> joinEntities, Condition condition)
static RightJoin	rightJoin(java.lang.String joinEntity)
static RightJoin	rightJoin(java.lang.String joinEntity, Condition condition)
static Some	some(SubQuery condition)
static Like	startsWith(java.lang.String propName, java.lang.Object propValue)
static SubQuery	subQuery(java.lang.String entityName, java.util.Collection<java.lang.String> propNames, Condition condition)
static SubQuery	subQuery(java.lang.String entityName, java.util.Collection<java.lang.String> propNames, java.lang.String condition)
static SubQuery	subQuery(java.lang.String entityName, java.lang.String sql)
static Union	union(SubQuery condition)
static UnionAll	unionAll(SubQuery condition)
static Using	using(java.util.Collection<java.lang.String> columnNames) Deprecated.
static Using	using(java.lang.String... columnNames) Deprecated.
static Where	where(Condition condition)
static Where	where(java.lang.String condition)
static XOR	xor(java.lang.String propName, java.lang.Object propValue)

Methods inherited from class java.lang.Object

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

Field Detail

QME

public static final Expression QME

Expression with question mark literal: "?".

ASC

public static final com.landawn.abacus.util.SortDirection ASC

DESC

public static final com.landawn.abacus.util.SortDirection DESC

Method Detail

namedProperty

public static NamedProperty namedProperty(java.lang.String propName)

expr

public static Expression expr(java.lang.String literal)

binary

public static Binary binary(java.lang.String propName,
                            Operator operator,
                            java.lang.Object propValue)

equal

public static Equal equal(java.lang.String propName,
                          java.lang.Object propValue)

equal

public static Equal equal(java.lang.String propName)

It's for parameterized SQL with question mark or named parameters.

Parameters:

propName -

Returns:

See Also:

SQLBuilder

eq

public static Equal eq(java.lang.String propName,
                       java.lang.Object propValue)

eq

public static Equal eq(java.lang.String propName)

It's for parameterized SQL with question mark or named parameters.

Parameters:

propName -

Returns:

See Also:

SQLBuilder

eqOr

@SafeVarargs
public static Or eqOr(java.lang.String propName,
                                    java.lang.Object... propValues)

eqOr

public static Or eqOr(java.lang.String propName,
                      java.util.Collection<?> propValues)

eqOr

public static Or eqOr(java.util.Map<java.lang.String,java.lang.Object> props)

eqOr

public static Or eqOr(java.lang.Object entity)

eqAnd

public static And eqAnd(java.util.Map<java.lang.String,java.lang.Object> props)

eqAnd

public static And eqAnd(java.lang.Object entity)

notEqual

public static NotEqual notEqual(java.lang.String propName,
                                java.lang.Object propValue)

notEqual

public static NotEqual notEqual(java.lang.String propName)

It's for parameterized SQL with question mark or named parameters.

Parameters:

propName -

Returns:

See Also:

SQLBuilder

ne

public static NotEqual ne(java.lang.String propName,
                          java.lang.Object propValue)

ne

public static NotEqual ne(java.lang.String propName)

It's for parameterized SQL with question mark or named parameters.

Parameters:

propName -

Returns:

See Also:

SQLBuilder

greaterThan

public static GreaterThan greaterThan(java.lang.String propName,
                                      java.lang.Object propValue)

greaterThan

public static GreaterThan greaterThan(java.lang.String propName)

It's for parameterized SQL with question mark or named parameters.

Parameters:

propName -

Returns:

See Also:

SQLBuilder

gt

public static GreaterThan gt(java.lang.String propName,
                             java.lang.Object propValue)

gt

public static GreaterThan gt(java.lang.String propName)

It's for parameterized SQL with question mark or named parameters.

Parameters:

propName -

Returns:

See Also:

SQLBuilder

greaterEqual

public static GreaterEqual greaterEqual(java.lang.String propName,
                                        java.lang.Object propValue)

greaterEqual

public static GreaterEqual greaterEqual(java.lang.String propName)

It's for parameterized SQL with question mark or named parameters.

Parameters:

propName -

Returns:

See Also:

SQLBuilder

ge

public static GreaterEqual ge(java.lang.String propName,
                              java.lang.Object propValue)

ge

public static GreaterEqual ge(java.lang.String propName)

It's for parameterized SQL with question mark or named parameters.

Parameters:

propName -

Returns:

See Also:

SQLBuilder

lessThan

public static LessThan lessThan(java.lang.String propName,
                                java.lang.Object propValue)

lessThan

public static LessThan lessThan(java.lang.String propName)

It's for parameterized SQL with question mark or named parameters.

Parameters:

propName -

Returns:

See Also:

SQLBuilder

lt

public static LessThan lt(java.lang.String propName,
                          java.lang.Object propValue)

lt

public static LessThan lt(java.lang.String propName)

It's for parameterized SQL with question mark or named parameters.

Parameters:

propName -

Returns:

See Also:

SQLBuilder

lessEqual

public static LessEqual lessEqual(java.lang.String propName,
                                  java.lang.Object propValue)

lessEqual

public static LessEqual lessEqual(java.lang.String propName)

It's for parameterized SQL with question mark or named parameters.

Parameters:

propName -

Returns:

See Also:

SQLBuilder

le

public static LessEqual le(java.lang.String propName,
                           java.lang.Object propValue)

le

public static LessEqual le(java.lang.String propName)

It's for parameterized SQL with question mark or named parameters.

Parameters:

propName -

Returns:

See Also:

SQLBuilder

between

public static Between between(java.lang.String propName,
                              java.lang.Object minValue,
                              java.lang.Object maxValue)

between

public static Between between(java.lang.String propName)

bt

public static Between bt(java.lang.String propName,
                         java.lang.Object minValue,
                         java.lang.Object maxValue)

bt

public static Between bt(java.lang.String propName)

like

public static Like like(java.lang.String propName,
                        java.lang.Object propValue)

like

public static Like like(java.lang.String propName)

notLike

public static Not notLike(java.lang.String propName,
                          java.lang.Object propValue)

notLike

public static Not notLike(java.lang.String propName)

contains

public static Like contains(java.lang.String propName,
                            java.lang.Object propValue)

startsWith

public static Like startsWith(java.lang.String propName,
                              java.lang.Object propValue)

endsWith

public static Like endsWith(java.lang.String propName,
                            java.lang.Object propValue)

isNull

public static IsNull isNull(java.lang.String propName)

isNotNull

public static IsNotNull isNotNull(java.lang.String propName)

isNaN

public static IsNaN isNaN(java.lang.String propName)

isNotNaN

public static IsNotNaN isNotNaN(java.lang.String propName)

isInfinite

public static IsInfinite isInfinite(java.lang.String propName)

isNotInfinite

public static IsNotInfinite isNotInfinite(java.lang.String propName)

is

public static Is is(java.lang.String propName,
                    java.lang.Object propValue)

isNot

public static IsNot isNot(java.lang.String propName,
                          java.lang.Object propValue)

xor

public static XOR xor(java.lang.String propName,
                      java.lang.Object propValue)

or

@SafeVarargs
public static Or or(Condition... conditions)

or

public static Or or(java.util.Collection<? extends Condition> conditions)

and

@SafeVarargs
public static And and(Condition... conditions)

and

public static And and(java.util.Collection<? extends Condition> conditions)

junction

@SafeVarargs
public static Junction junction(Operator operator,
                                              Condition... conditions)

junction

public static Junction junction(Operator operator,
                                java.util.Collection<? extends Condition> conditions)

where

public static Where where(Condition condition)

where

public static Where where(java.lang.String condition)

groupBy

@SafeVarargs
public static GroupBy groupBy(java.lang.String... propNames)

groupBy

public static GroupBy groupBy(java.lang.String propName,
                              com.landawn.abacus.util.SortDirection direction)

groupBy

public static GroupBy groupBy(java.util.Collection<java.lang.String> propNames)

groupBy

public static GroupBy groupBy(java.util.Collection<java.lang.String> propNames,
                              com.landawn.abacus.util.SortDirection direction)

groupBy

public static GroupBy groupBy(java.util.Map<java.lang.String,com.landawn.abacus.util.SortDirection> orders)

groupBy

public static GroupBy groupBy(Condition condition)

having

public static Having having(Condition condition)

having

public static Having having(java.lang.String condition)

orderBy

@SafeVarargs
public static OrderBy orderBy(java.lang.String... propNames)

orderBy

public static OrderBy orderBy(java.lang.String propName,
                              com.landawn.abacus.util.SortDirection direction)

orderBy

public static OrderBy orderBy(java.util.Collection<java.lang.String> propNames)

orderBy

public static OrderBy orderBy(java.util.Collection<java.lang.String> propNames,
                              com.landawn.abacus.util.SortDirection direction)

orderBy

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

orderBy

public static OrderBy orderBy(Condition condition)

on

public static On on(Condition condition)

on

public static On on(java.lang.String condition)

on

public static On on(java.lang.String propName,
                    java.lang.String anoPropName)

on

public static On on(java.util.Map<java.lang.String,java.lang.String> propNamePair)

using

@Deprecated
 @SafeVarargs
public static Using using(java.lang.String... columnNames)

Deprecated.

It's recommended to use On, instead of Using.

Parameters:

columnNames -

Returns:

using

@Deprecated
public static Using using(java.util.Collection<java.lang.String> columnNames)

Deprecated.

It's recommended to use On, instead of Using.

Parameters:

columnNames -

Returns:

join

public static Join join(java.lang.String joinEntity)

join

public static Join join(java.lang.String joinEntity,
                        Condition condition)

join

public static Join join(java.util.Collection<java.lang.String> joinEntities,
                        Condition condition)

leftJoin

public static LeftJoin leftJoin(java.lang.String joinEntity)

leftJoin

public static LeftJoin leftJoin(java.lang.String joinEntity,
                                Condition condition)

leftJoin

public static LeftJoin leftJoin(java.util.Collection<java.lang.String> joinEntities,
                                Condition condition)

rightJoin

public static RightJoin rightJoin(java.lang.String joinEntity)

rightJoin

public static RightJoin rightJoin(java.lang.String joinEntity,
                                  Condition condition)

rightJoin

public static RightJoin rightJoin(java.util.Collection<java.lang.String> joinEntities,
                                  Condition condition)

crossJoin

public static CrossJoin crossJoin(java.lang.String joinEntity)

crossJoin

public static CrossJoin crossJoin(java.lang.String joinEntity,
                                  Condition condition)

crossJoin

public static CrossJoin crossJoin(java.util.Collection<java.lang.String> joinEntities,
                                  Condition condition)

fullJoin

public static FullJoin fullJoin(java.lang.String joinEntity)

fullJoin

public static FullJoin fullJoin(java.lang.String joinEntity,
                                Condition condition)

fullJoin

public static FullJoin fullJoin(java.util.Collection<java.lang.String> joinEntities,
                                Condition condition)

innerJoin

public static InnerJoin innerJoin(java.lang.String joinEntity)

innerJoin

public static InnerJoin innerJoin(java.lang.String joinEntity,
                                  Condition condition)

innerJoin

public static InnerJoin innerJoin(java.util.Collection<java.lang.String> joinEntities,
                                  Condition condition)

naturalJoin

public static NaturalJoin naturalJoin(java.lang.String joinEntity)

naturalJoin

public static NaturalJoin naturalJoin(java.lang.String joinEntity,
                                      Condition condition)

naturalJoin

public static NaturalJoin naturalJoin(java.util.Collection<java.lang.String> joinEntities,
                                      Condition condition)

in

public static In in(java.lang.String propName,
                    java.lang.Object[] values)

in

public static In in(java.lang.String propName,
                    java.util.Collection<?> values)

all

public static All all(SubQuery condition)

any

public static Any any(SubQuery condition)

some

public static Some some(SubQuery condition)

exists

public static Exists exists(SubQuery condition)

notExists

public static Not notExists(SubQuery condition)

union

public static Union union(SubQuery condition)

unionAll

public static UnionAll unionAll(SubQuery condition)

except

public static Except except(SubQuery condition)

intersect

public static Intersect intersect(SubQuery condition)

minus

public static Minus minus(SubQuery condition)

cell

public static Cell cell(Operator operator,
                        Condition condition)

subQuery

public static SubQuery subQuery(java.lang.String entityName,
                                java.util.Collection<java.lang.String> propNames,
                                Condition condition)

subQuery

public static SubQuery subQuery(java.lang.String entityName,
                                java.util.Collection<java.lang.String> propNames,
                                java.lang.String condition)

subQuery

public static SubQuery subQuery(java.lang.String entityName,
                                java.lang.String sql)

limit

public static Limit limit(int count)

limit

public static Limit limit(int offset,
                          int count)

criteria

public static Criteria criteria()