Class FluentSqlBuilder
- java.lang.Object
-
- de.hybris.platform.directpersistence.statement.sql.FluentSqlBuilder
-
public class FluentSqlBuilder extends java.lang.Object
-
-
Method Summary
All Methods Static Methods Instance Methods Concrete Methods Modifier and Type Method Description FluentSqlBuilderand()FluentSqlBuilderas(java.lang.String as)FluentSqlBuilderascending()static FluentSqlBuilderbuilder(Config.DatabaseName dbName)FluentSqlBuilderdelete()FluentSqlBuilderdescending()FluentSqlBuilderfield(ServiceCol field)FluentSqlBuilderfield(java.lang.String field)FluentSqlBuilderfieldIsNullOr(java.lang.String columnName)FluentSqlBuilderfrom(FluentSqlBuilder subQuery)FluentSqlBuilderfrom(java.lang.String tableName)static FluentSqlBuildergenericBuilder()protected java.lang.StringBuildergetInternalStringBuilder()FluentSqlBuildergroupBy(java.lang.String... columnNames)FluentSqlBuilderin(java.lang.Iterable<? extends java.lang.Object> values)FluentSqlBuilderin(java.util.Set<? extends java.lang.Object> values)FluentSqlBuilderinsert()FluentSqlBuilderinto(java.lang.String tableName)FluentSqlBuilderisEqual()FluentSqlBuilderisNotEqual()FluentSqlBuilderisNotNull()FluentSqlBuilderisNull()FluentSqlBuilderjoin(java.lang.String tableName)FluentSqlBuilderleft()static java.lang.Stringmax(java.lang.String columnName)FluentSqlBuilderon(java.lang.String onPhrase)FluentSqlBuilderor()FluentSqlBuilderorderBy(java.lang.String... columnNames)FluentSqlBuilderouter()FluentSqlBuilderselect(java.lang.String... columnNames)FluentSqlBuilderselectAll()FluentSqlBuilderselectDistinct(java.lang.String... columnNames)FluentSqlBuilderset(java.lang.Iterable<java.lang.String> columnNames)FluentSqlBuilderset(java.lang.String... columnNames)FluentSqlBuilderset(java.util.Set<java.lang.String> columnNames)java.lang.StringtoSql()FluentSqlBuilderunion(FluentSqlBuilder builder)FluentSqlBuilderunionAll(FluentSqlBuilder builder)FluentSqlBuilderupdate(java.lang.String tableName)FluentSqlBuilderusingFields(java.lang.Iterable<java.lang.String> columnNames)FluentSqlBuilderusingFields(java.lang.String... columnNames)FluentSqlBuildervalues(java.util.Set<? extends java.lang.Object> values)FluentSqlBuilderwhere()
-
-
-
Method Detail
-
genericBuilder
public static FluentSqlBuilder genericBuilder()
-
builder
public static FluentSqlBuilder builder(Config.DatabaseName dbName)
-
select
public FluentSqlBuilder select(java.lang.String... columnNames)
-
selectAll
public FluentSqlBuilder selectAll()
-
selectDistinct
public FluentSqlBuilder selectDistinct(java.lang.String... columnNames)
-
delete
public FluentSqlBuilder delete()
-
insert
public FluentSqlBuilder insert()
-
update
public FluentSqlBuilder update(java.lang.String tableName)
-
set
public FluentSqlBuilder set(java.util.Set<java.lang.String> columnNames)
-
set
public FluentSqlBuilder set(java.lang.Iterable<java.lang.String> columnNames)
-
set
public FluentSqlBuilder set(java.lang.String... columnNames)
-
into
public FluentSqlBuilder into(java.lang.String tableName)
-
fieldIsNullOr
public FluentSqlBuilder fieldIsNullOr(java.lang.String columnName)
-
values
public FluentSqlBuilder values(java.util.Set<? extends java.lang.Object> values)
-
usingFields
public FluentSqlBuilder usingFields(java.lang.String... columnNames)
-
usingFields
public FluentSqlBuilder usingFields(java.lang.Iterable<java.lang.String> columnNames)
-
from
public FluentSqlBuilder from(java.lang.String tableName)
-
from
public FluentSqlBuilder from(FluentSqlBuilder subQuery)
-
as
public FluentSqlBuilder as(java.lang.String as)
-
where
public FluentSqlBuilder where()
-
field
public FluentSqlBuilder field(java.lang.String field)
-
field
public FluentSqlBuilder field(ServiceCol field)
-
isEqual
public FluentSqlBuilder isEqual()
-
isNotEqual
public FluentSqlBuilder isNotEqual()
-
isNull
public FluentSqlBuilder isNull()
-
isNotNull
public FluentSqlBuilder isNotNull()
-
and
public FluentSqlBuilder and()
-
or
public FluentSqlBuilder or()
-
in
public FluentSqlBuilder in(java.util.Set<? extends java.lang.Object> values)
-
in
public FluentSqlBuilder in(java.lang.Iterable<? extends java.lang.Object> values)
-
groupBy
public FluentSqlBuilder groupBy(java.lang.String... columnNames)
-
orderBy
public FluentSqlBuilder orderBy(java.lang.String... columnNames)
-
ascending
public FluentSqlBuilder ascending()
-
descending
public FluentSqlBuilder descending()
-
union
public FluentSqlBuilder union(FluentSqlBuilder builder)
-
unionAll
public FluentSqlBuilder unionAll(FluentSqlBuilder builder)
-
max
public static java.lang.String max(java.lang.String columnName)
-
join
public FluentSqlBuilder join(java.lang.String tableName)
-
left
public FluentSqlBuilder left()
-
outer
public FluentSqlBuilder outer()
-
on
public FluentSqlBuilder on(java.lang.String onPhrase)
-
toSql
public java.lang.String toSql()
-
getInternalStringBuilder
protected java.lang.StringBuilder getInternalStringBuilder()
-
-