Package io.github.torand.fastersql.statement

Class UpdateStatement

java.lang.Object

io.github.torand.fastersql.statement.UpdateStatement

All Implemented Interfaces:

Sql, PreparableStatement

public class UpdateStatement
extends Object
implements PreparableStatement

Implements an UPDATE statement.

Method Summary

Modifier and Type	Method	Description
Stream<Object>	params(Context context)	Gets the statement parameters introduced by this fragment.
UpdateStatement	set(Column column, Expression value)	Adds an expression value to be updated for a column.
UpdateStatement	set(Column column, Object value)	Adds a constant value to be updated for a column.
UpdateStatement	set(Column column, Optional<?> maybeValue)	Adds an optional value to be updated for a column.
String	sql(Context context)	Formats object as an SQL fragment.
String	toString()
final UpdateStatement	where(OptionalPredicate... maybePredicates)	Adds optional predicates to the WHERE clause if the wrapped predicates are present.
UpdateStatement	where(Predicate... predicates)	Adds one or more predicates to the WHERE clause.

Methods inherited from class java.lang.Object

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

Methods inherited from interface io.github.torand.fastersql.statement.PreparableStatement

aliasRefs, columnRefs, toString

Method Details

set

public UpdateStatement set(Column column,
 Expression value)

Adds an expression value to be updated for a column.

Parameters:

column - the column.

value - the value.

Returns:

the modified statement.

set

public UpdateStatement set(Column column,
 Object value)

Adds a constant value to be updated for a column.

Parameters:

column - the column.

value - the value.

Returns:

the modified statement.

set

public UpdateStatement set(Column column,
 Optional<?> maybeValue)

Adds an optional value to be updated for a column. The column is updated only if the optional value is present.

Parameters:

column - the column.

maybeValue - the optional value.

Returns:

the modified statement.

where

public UpdateStatement where(Predicate... predicates)

Adds one or more predicates to the WHERE clause.

Parameters:

predicates - the predicates.

Returns:

the modified statement.

where

public final UpdateStatement where(OptionalPredicate... maybePredicates)

Adds optional predicates to the WHERE clause if the wrapped predicates are present.

Parameters:

maybePredicates - the optional predicates.

Returns:

the modified statement.

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.

toString

public String toString()

Overrides:

toString in class Object