Package io.github.torand.fastersql.expression.cases

Class SimpleCase

java.lang.Object

io.github.torand.fastersql.expression.cases.SimpleCase

All Implemented Interfaces:

Expression, Projection, Sql

public class SimpleCase
extends Object
implements Expression

Implements a simple CASE expression.

Method Summary

Modifier and Type	Method	Description
Optional<ColumnAlias>	alias()	Gets the column alias (label) assigned for this projection.
Stream<ColumnAlias>	aliasRefs()	Gets the column aliases referenced by this fragment.
Projection	as(String alias)	Assigns a column alias (label) for this projection.
Stream<Column>	columnRefs()	Gets the columns referenced by this fragment.
Stream<Object>	params(Context context)	Gets the statement parameters introduced by this fragment.
String	sql(Context context)	Formats object as an SQL fragment.

Methods inherited from class java.lang.Object

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

Methods inherited from interface io.github.torand.fastersql.expression.Expression

dividedBy, dividedBy, minus, minus, mod, mod, plus, plus, times, times

Method Details

sql

public String sql(Context context)

Description copied from interface: Sql

Formats object as an SQL fragment.

Specified by:

sql in interface Sql

Parameters:

context - the context (incl. dialect).

Returns:

the formatted SQL fragment.

params

public Stream<Object> params(Context context)

Description copied from interface: Sql

Gets the statement parameters introduced by this fragment.

Specified by:

params in interface Sql

Parameters:

context - the context (incl. dialect).

Returns:

the statement parameters.

columnRefs

public Stream<Column> columnRefs()

Description copied from interface: Sql

Gets the columns referenced by this fragment. For validation purposes.

Specified by:

columnRefs in interface Sql

Returns:

the columns referenced by this fragment.

aliasRefs

public Stream<ColumnAlias> aliasRefs()

Description copied from interface: Sql

Gets the column aliases referenced by this fragment. For validation purposes.

Specified by:

aliasRefs in interface Sql

Returns:

the column aliases referenced by this fragment.

as

public Projection as(String alias)

Description copied from interface: Projection

Assigns a column alias (label) for this projection.

Specified by:

as in interface Projection

Parameters:

alias - the column alias or label.

Returns:

the projection with specified alias assigned.

alias

public Optional<ColumnAlias> alias()

Description copied from interface: Projection

Gets the column alias (label) assigned for this projection.

Specified by:

alias in interface Projection

Returns:

the column alias (label) assigned for this projection.