Package ch.tocco.nice2.persist.core.api.query

Class SqlWriter

java.lang.Object

ch.tocco.nice2.persist.core.api.query.SqlWriter

public class SqlWriter
extends Object

Helper class for manually writing SQL queries. An instance should be obtained from Context.createSqlWriter() to make sure that dialect specific configuration is applied.

Nested Class Summary

Nested Classes

Modifier and Type	Class	Description
static enum	SqlWriter.CasePolicy
static class	SqlWriter.SqlWriterConfiguration

Constructor Summary

Constructors

Constructor	Description
SqlWriter(SqlWriter.SqlWriterConfiguration configuration)

Method Summary

Modifier and Type	Method	Description
SqlWriter	alias(String alias)
SqlWriter	and()
SqlWriter	append(char c)
SqlWriter	append(String s)
SqlWriter	ascending()
SqlWriter	ascending(String path)
SqlWriter	assign(String path)
SqlWriter	closeParen()
SqlWriter	count()
SqlWriter	delete(String table)
SqlWriter	descending()
SqlWriter	descending(String path)
SqlWriter	distinct()
SqlWriter	div()
SqlWriter	endCount()
SqlWriter	eq()
SqlWriter	from()
SqlWriter	ge()
SqlWriter	gt()
SqlWriter	inEnd()
SqlWriter	insert(String table)
SqlWriter	inStart()
SqlWriter	isNotNull()
SqlWriter	isNull()
SqlWriter	keyword(String keyword)
SqlWriter	le()
SqlWriter	lt()
SqlWriter	minus()
SqlWriter	multiply()
SqlWriter	ne()
SqlWriter	not()
SqlWriter	openParen()
SqlWriter	or()
SqlWriter	orderBy()
SqlWriter	path(String path)
SqlWriter	plus()
protected SqlWriter	quoteIdentifier(String token)
SqlWriter	select()
SqlWriter	separator()
SqlWriter	set()
SqlWriter	startCount()
String	toSql()
SqlWriter	update(String table)
SqlWriter	values()
SqlWriter	where()
SqlWriter	whitespace()
SqlWriter	wildcard()

Methods inherited from class java.lang.Object

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

Constructor Details

SqlWriter

public SqlWriter(SqlWriter.SqlWriterConfiguration configuration)

Method Details

toSql

public String toSql()

select

public SqlWriter select()

count

public SqlWriter count()

update

public SqlWriter update(String table)

delete

public SqlWriter delete(String table)

insert

public SqlWriter insert(String table)

from

public SqlWriter from()

where

public SqlWriter where()

distinct

public SqlWriter distinct()

orderBy

public SqlWriter orderBy()

ascending

public SqlWriter ascending()

descending

public SqlWriter descending()

ascending

public SqlWriter ascending(String path)

descending

public SqlWriter descending(String path)

startCount

public SqlWriter startCount()

endCount

public SqlWriter endCount()

openParen

public SqlWriter openParen()

closeParen

public SqlWriter closeParen()

wildcard

public SqlWriter wildcard()

path

public SqlWriter path(String path)

alias

public SqlWriter alias(String alias)

separator

public SqlWriter separator()

inStart

public SqlWriter inStart()

inEnd

public SqlWriter inEnd()

set

public SqlWriter set()

assign

public SqlWriter assign(String path)

values

public SqlWriter values()

eq

public SqlWriter eq()

ne

public SqlWriter ne()

gt

public SqlWriter gt()

ge

public SqlWriter ge()

lt

public SqlWriter lt()

le

public SqlWriter le()

isNull

public SqlWriter isNull()

isNotNull

public SqlWriter isNotNull()

and

public SqlWriter and()

or

public SqlWriter or()

not

public SqlWriter not()

keyword

public SqlWriter keyword(String keyword)

quoteIdentifier

protected SqlWriter quoteIdentifier(String token)

whitespace

public SqlWriter whitespace()

append

public SqlWriter append(String s)

append

public SqlWriter append(char c)

plus

public SqlWriter plus()

minus

public SqlWriter minus()

div

public SqlWriter div()

multiply

public SqlWriter multiply()