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

Class SqlWriter

java.lang.Object

ch.tocco.nice2.persist.core.api.query.SqlWriterBase<SqlWriter>

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

public class SqlWriter
extends SqlWriterBase<SqlWriter>

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/interfaces inherited from class ch.tocco.nice2.persist.core.api.query.SqlWriterBase

SqlWriterBase.CasePolicy, SqlWriterBase.SqlWriterConfiguration

Field Summary

Fields inherited from class ch.tocco.nice2.persist.core.api.query.SqlWriterBase

configuration

Constructor Summary

Constructors

Constructor	Description
SqlWriter(SqlWriterBase.SqlWriterConfiguration configuration)

Method Summary

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

Methods inherited from class ch.tocco.nice2.persist.core.api.query.SqlWriterBase

and, closeParen, div, ge, keyword, le, minus, multiply, openParen, plus

Methods inherited from class java.lang.Object

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

Constructor Details

SqlWriter

public SqlWriter(SqlWriterBase.SqlWriterConfiguration configuration)

Method Details

self

protected SqlWriter self()

Specified by:

self in class SqlWriterBase<SqlWriter>

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()

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()

lt

public SqlWriter lt()

isNull

public SqlWriter isNull()

isNotNull

public SqlWriter isNotNull()

or

public SqlWriter or()

not

public SqlWriter not()

quoteIdentifier

protected SqlWriter quoteIdentifier(String token)

whitespace

public SqlWriter whitespace()

Overrides:

whitespace in class SqlWriterBase<SqlWriter>

append

public SqlWriter append(CharSequence s)

Specified by:

append in class SqlWriterBase<SqlWriter>

append

public SqlWriter append(char c)