de.hybris.platform.directpersistence.statement.sql

Class FluentSqlBuilder

java.lang.Object

de.hybris.platform.directpersistence.statement.sql.FluentSqlBuilder

public class FluentSqlBuilder
extends Object

Method Summary

Modifier and Type	Method and Description
FluentSqlBuilder	and()
FluentSqlBuilder	as(String as)
FluentSqlBuilder	ascending()
static FluentSqlBuilder	builder(Config.DatabaseName dbName)
FluentSqlBuilder	delete()
FluentSqlBuilder	descending()
FluentSqlBuilder	field(ServiceCol field)
FluentSqlBuilder	field(String field)
FluentSqlBuilder	from(FluentSqlBuilder subQuery)
FluentSqlBuilder	from(String tableName)
static FluentSqlBuilder	genericBuilder()
protected StringBuilder	getInternalStringBuilder()
FluentSqlBuilder	groupBy(String... columnNames)
FluentSqlBuilder	in(Iterable<? extends Object> values)
FluentSqlBuilder	in(Set<? extends Object> values)
FluentSqlBuilder	insert()
FluentSqlBuilder	into(String tableName)
FluentSqlBuilder	isEqual()
FluentSqlBuilder	isNotEqual()
FluentSqlBuilder	isNotNull()
FluentSqlBuilder	isNull()
FluentSqlBuilder	join(String tableName)
FluentSqlBuilder	left()
static String	max(String columnName)
FluentSqlBuilder	on(String onPhrase)
FluentSqlBuilder	or()
FluentSqlBuilder	orderBy(String... columnNames)
FluentSqlBuilder	outer()
FluentSqlBuilder	select(String... columnNames)
FluentSqlBuilder	selectAll()
FluentSqlBuilder	selectDistinct(String... columnNames)
FluentSqlBuilder	set(Iterable<String> columnNames)
FluentSqlBuilder	set(Set<String> columnNames)
FluentSqlBuilder	set(String... columnNames)
String	toSql()
FluentSqlBuilder	union(FluentSqlBuilder builder)
FluentSqlBuilder	unionAll(FluentSqlBuilder builder)
FluentSqlBuilder	update(String tableName)
FluentSqlBuilder	usingFields(Iterable<String> columnNames)
FluentSqlBuilder	usingFields(String... columnNames)
FluentSqlBuilder	values(Set<? extends Object> values)
FluentSqlBuilder	where()

Methods inherited from class java.lang.Object

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

Method Detail

genericBuilder

public static FluentSqlBuilder genericBuilder()

builder

public static FluentSqlBuilder builder(Config.DatabaseName dbName)

select

public FluentSqlBuilder select(String... columnNames)

selectAll

public FluentSqlBuilder selectAll()

selectDistinct

public FluentSqlBuilder selectDistinct(String... columnNames)

delete

public FluentSqlBuilder delete()

insert

public FluentSqlBuilder insert()

update

public FluentSqlBuilder update(String tableName)

set

public FluentSqlBuilder set(Set<String> columnNames)

set

public FluentSqlBuilder set(Iterable<String> columnNames)

set

public FluentSqlBuilder set(String... columnNames)

into

public FluentSqlBuilder into(String tableName)

values

public FluentSqlBuilder values(Set<? extends Object> values)

usingFields

public FluentSqlBuilder usingFields(String... columnNames)

usingFields

public FluentSqlBuilder usingFields(Iterable<String> columnNames)

from

public FluentSqlBuilder from(String tableName)

from

public FluentSqlBuilder from(FluentSqlBuilder subQuery)

as

public FluentSqlBuilder as(String as)

where

public FluentSqlBuilder where()

field

public FluentSqlBuilder field(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(Set<? extends Object> values)

in

public FluentSqlBuilder in(Iterable<? extends Object> values)

groupBy

public FluentSqlBuilder groupBy(String... columnNames)

orderBy

public FluentSqlBuilder orderBy(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 String max(String columnName)

join

public FluentSqlBuilder join(String tableName)

left

public FluentSqlBuilder left()

outer

public FluentSqlBuilder outer()

on

public FluentSqlBuilder on(String onPhrase)

toSql

public String toSql()

getInternalStringBuilder

protected StringBuilder getInternalStringBuilder()