|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
public interface MergeOnConditionStep<R extends Record>
This type is used for the Merge
's DSL API.
Example:
Factory create = new Factory();
create.mergeInto(table)
.using(select)
.on(condition)
.whenMatchedThenUpdate()
.set(field1, value1)
.set(field2, value2)
.whenNotMatchedThenInsert(field1, field2)
.values(value1, value2)
.execute();
Method Summary | |
---|---|
MergeOnConditionStep<R> |
and(Condition condition)
Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step. |
MergeOnConditionStep<R> |
and(String sql)
Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step. |
MergeOnConditionStep<R> |
and(String sql,
Object... bindings)
Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step. |
MergeOnConditionStep<R> |
and(String sql,
QueryPart... parts)
Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step. |
MergeOnConditionStep<R> |
andExists(Select<?> select)
Combine the currently assembled conditions with an EXISTS clause using the Operator.AND operator and proceed to the next step. |
MergeOnConditionStep<R> |
andNot(Condition condition)
Combine the currently assembled conditions with a negated other one using the Operator.AND operator and proceed to the next step. |
MergeOnConditionStep<R> |
andNotExists(Select<?> select)
Combine the currently assembled conditions with a NOT EXISTS clause using the Operator.AND operator and proceed to the next step. |
MergeOnConditionStep<R> |
or(Condition condition)
Combine the currently assembled conditions with another one using the Operator.OR operator and proceed to the next step. |
MergeOnConditionStep<R> |
or(String sql)
Combine the currently assembled conditions with another one using the Operator.OR operator and proceed to the next step. |
MergeOnConditionStep<R> |
or(String sql,
Object... bindings)
Combine the currently assembled conditions with another one using the Operator.OR operator and proceed to the next step. |
MergeOnConditionStep<R> |
or(String sql,
QueryPart... parts)
Combine the currently assembled conditions with another one using the Operator.OR operator and proceed to the next step. |
MergeOnConditionStep<R> |
orExists(Select<?> select)
Combine the currently assembled conditions with an EXISTS clause using the Operator.OR operator and proceed to the next step. |
MergeOnConditionStep<R> |
orNot(Condition condition)
Combine the currently assembled conditions with a negated other one using the Operator.OR operator and proceed to the next step. |
MergeOnConditionStep<R> |
orNotExists(Select<?> select)
Combine the currently assembled conditions with a NOT EXISTS clause using the Operator.OR operator and proceed to the next step. |
Methods inherited from interface org.jooq.MergeMatchedStep |
---|
whenMatchedThenUpdate |
Methods inherited from interface org.jooq.MergeNotMatchedStep |
---|
whenNotMatchedThenInsert, whenNotMatchedThenInsert, whenNotMatchedThenInsert |
Methods inherited from interface org.jooq.Query |
---|
bind, bind, execute, getBindValues, getParam, getParams, getSQL, getSQL, isExecutable |
Methods inherited from interface org.jooq.QueryPart |
---|
attach |
Methods inherited from interface org.jooq.Adapter |
---|
internalAPI |
Method Detail |
---|
MergeOnConditionStep<R> and(Condition condition)
Operator.AND
operator and proceed to the next step.
MergeOnConditionStep<R> and(String sql)
Operator.AND
operator and proceed to the next step.
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
Factory.condition(String)
MergeOnConditionStep<R> and(String sql, Object... bindings)
Operator.AND
operator and proceed to the next step.
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
Factory.condition(String, Object...)
MergeOnConditionStep<R> and(String sql, QueryPart... parts)
Operator.AND
operator and proceed to the next step.
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
Factory.condition(String, QueryPart...)
MergeOnConditionStep<R> andNot(Condition condition)
Operator.AND
operator and proceed to the next step.
MergeOnConditionStep<R> andExists(Select<?> select)
Operator.AND
operator and proceed to the next step.
MergeOnConditionStep<R> andNotExists(Select<?> select)
Operator.AND
operator and proceed to the next step.
MergeOnConditionStep<R> or(Condition condition)
Operator.OR
operator and proceed to the next step.
MergeOnConditionStep<R> or(String sql)
Operator.OR
operator and proceed to the next step.
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
Factory.condition(String)
MergeOnConditionStep<R> or(String sql, Object... bindings)
Operator.OR
operator and proceed to the next step.
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
Factory.condition(String, Object...)
MergeOnConditionStep<R> or(String sql, QueryPart... parts)
Operator.OR
operator and proceed to the next step.
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
Factory.condition(String, QueryPart...)
MergeOnConditionStep<R> orNot(Condition condition)
Operator.OR
operator and proceed to the next step.
MergeOnConditionStep<R> orExists(Select<?> select)
Operator.OR
operator and proceed to the next step.
MergeOnConditionStep<R> orNotExists(Select<?> select)
Operator.OR
operator and proceed to the next step.
|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |