Top Fields Constructors Methods
org.jooq.impl

pack-priv final Class DivideBy

extends Object
implements DivideByOnStep, DivideByOnConditionStep
Class Inheritance
All Implemented Interfaces
org.jooq.DivideByOnConditionStep, org.jooq.DivideByReturningStep, org.jooq.DivideByOnStep
Static Imports
org.jooq.impl.DSL.condition, .DSL.exists, .DSL.notExists, .DSL.selectDistinct, .DSL.selectOne
Author
Lukas Eder

Field Summary

Modifier and TypeField and Description
private final ConditionProviderImpl
condition

Deprecated as a consequence of ConditionProviderImpl being deprecated.
private final Table<?>
dividend

private final Table<?>
divisor

private final QueryPartList<Field<?>>
returning

Constructor Summary

AccessConstructor and Description
pack-priv
DivideBy(Table<?> dividend, Table<?> divisor)

Method Summary

Modifier and TypeMethod and Description
public final DivideByOnConditionStep
and(Condition c)

Implements org.jooq.DivideByOnConditionStep.and.

Deprecated as a consequence of Condition being deprecated.
Combine the currently assembled conditions with another one using the Operator#AND operator.
public final DivideByOnConditionStep
and(Field<Boolean> c)

Implements org.jooq.DivideByOnConditionStep.and.

Deprecated as a consequence of Field being deprecated.
Combine the currently assembled conditions with another one using the Operator#AND operator.
public final DivideByOnConditionStep
and(SQL sql)

Implements org.jooq.DivideByOnConditionStep.and.

Combine the currently assembled conditions with another one using the Operator#AND operator.
public final DivideByOnConditionStep
and(String sql)

Implements org.jooq.DivideByOnConditionStep.and.

Combine the currently assembled conditions with another one using the Operator#AND operator.
public final DivideByOnConditionStep
and(String sql, Object... bindings)

Implements org.jooq.DivideByOnConditionStep.and.

Combine the currently assembled conditions with another one using the Operator#AND operator.
public final DivideByOnConditionStep
and(String sql, QueryPart... parts)

Implements org.jooq.DivideByOnConditionStep.and.

Combine the currently assembled conditions with another one using the Operator#AND operator.
public final DivideByOnConditionStep
andExists(Select<?> select)

Implements org.jooq.DivideByOnConditionStep.andExists.

Combine the currently assembled conditions with an EXISTS clause using the Operator#AND operator.
public final DivideByOnConditionStep
andNot(Condition c)

Implements org.jooq.DivideByOnConditionStep.andNot.

Deprecated as a consequence of Condition being deprecated.
Combine the currently assembled conditions with a negated other one using the Operator#AND operator.
public final DivideByOnConditionStep
andNot(Field<Boolean> c)

Implements org.jooq.DivideByOnConditionStep.andNot.

Deprecated as a consequence of Field being deprecated.
Combine the currently assembled conditions with a negated other one using the Operator#AND operator.
public final DivideByOnConditionStep
andNotExists(Select<?> select)

Implements org.jooq.DivideByOnConditionStep.andNotExists.

Combine the currently assembled conditions with a NOT EXISTS clause using the Operator#AND operator.
public final DivideByOnConditionStep
on(Condition conditions)

Implements org.jooq.DivideByOnStep.on.

Deprecated as a consequence of Condition being deprecated.
Add a division condition to the DIVIDE BY clause, connecting them with each other with Operator#AND.
public final DivideByOnConditionStep
on(Condition... conditions)

Implements org.jooq.DivideByOnStep.on.

Deprecated as a consequence of Condition being deprecated.
Add a division condition to the DIVIDE BY clause, connecting them with each other with Operator#AND.
public final DivideByOnConditionStep
on(Field<Boolean> c)

Implements org.jooq.DivideByOnStep.on.

Deprecated as a consequence of Field being deprecated.
Add a division condition to the DIVIDE BY clause
public final DivideByOnConditionStep
on(SQL sql)

Implements org.jooq.DivideByOnStep.on.

Add a division condition to the DIVIDE BY clause

Note

When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity.

public final DivideByOnConditionStep
on(String sql)

Implements org.jooq.DivideByOnStep.on.

Add a division condition to the DIVIDE BY clause

Note

When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity.

public final DivideByOnConditionStep
on(String sql, Object... bindings)

Implements org.jooq.DivideByOnStep.on.

Add a division condition to the DIVIDE BY clause

Note

When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity.

public final DivideByOnConditionStep
on(String sql, QueryPart... parts)

Implements org.jooq.DivideByOnStep.on.

Add a division condition to the DIVIDE BY clause

Note

When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity.

public final DivideByOnConditionStep
or(Condition c)

Implements org.jooq.DivideByOnConditionStep.or.

Deprecated as a consequence of Condition being deprecated.
Combine the currently assembled conditions with another one using the Operator#OR operator.
public final DivideByOnConditionStep
or(Field<Boolean> c)

Implements org.jooq.DivideByOnConditionStep.or.

Deprecated as a consequence of Field being deprecated.
Combine the currently assembled conditions with another one using the Operator#OR operator.
public final DivideByOnConditionStep
or(SQL sql)

Implements org.jooq.DivideByOnConditionStep.or.

Combine the currently assembled conditions with another one using the Operator#OR operator.
public final DivideByOnConditionStep
or(String sql)

Implements org.jooq.DivideByOnConditionStep.or.

Combine the currently assembled conditions with another one using the Operator#OR operator.
public final DivideByOnConditionStep
or(String sql, Object... bindings)

Implements org.jooq.DivideByOnConditionStep.or.

Combine the currently assembled conditions with another one using the Operator#OR operator.
public final DivideByOnConditionStep
or(String sql, QueryPart... parts)

Implements org.jooq.DivideByOnConditionStep.or.

Combine the currently assembled conditions with another one using the Operator#OR operator.
public final DivideByOnConditionStep
orExists(Select<?> select)

Implements org.jooq.DivideByOnConditionStep.orExists.

Combine the currently assembled conditions with an EXISTS clause using the Operator#OR operator.
public final DivideByOnConditionStep
orNot(Condition c)

Implements org.jooq.DivideByOnConditionStep.orNot.

Deprecated as a consequence of Condition being deprecated.
Combine the currently assembled conditions with a negated other one using the Operator#OR operator.
public final DivideByOnConditionStep
orNot(Field<Boolean> c)

Implements org.jooq.DivideByOnConditionStep.orNot.

Deprecated as a consequence of Field being deprecated.
Combine the currently assembled conditions with a negated other one using the Operator#OR operator.
public final DivideByOnConditionStep
orNotExists(Select<?> select)

Implements org.jooq.DivideByOnConditionStep.orNotExists.

Combine the currently assembled conditions with a NOT EXISTS clause using the Operator#OR operator.
public final Table<Record>
returning(Field<?>... fields)

Implements org.jooq.DivideByReturningStep.returning.

Deprecated as a consequence of Field being deprecated.
Specify the fields that you want the division to return from the dividend
public final Table<Record>
returning(Collection<? extends Field<?>> fields)

Implements org.jooq.DivideByReturningStep.returning.

Specify the fields that you want the division to return from the dividend
private final <T> void
selfJoin(ConditionProvider selfJoin, Table<?> outer, Table<?> inner, Field<T> field)

Deprecated as a consequence of ConditionProvider and Field being deprecated.
Extracted method for type-safety
private final Table<Record>
table()

Transform the relational division operation into SQL.

Inherited from java.lang.Object:
cloneequalsfinalizegetClasshashCodenotifynotifyAlltoStringwaitwaitwait

Field Detail

conditionback to summary
private final ConditionProviderImpl condition

Deprecated

as a consequence of ConditionProviderImpl being deprecated. See corresponding docs for further information.

dividendback to summary
private final Table<?> dividend
divisorback to summary
private final Table<?> divisor
returningback to summary
private final QueryPartList<Field<?>> returning

Constructor Detail

DivideByback to summary
pack-priv DivideBy(Table<?> dividend, Table<?> divisor)

Method Detail

andback to summary
public final DivideByOnConditionStep and(Condition c)

Implements org.jooq.DivideByOnConditionStep.and.

Doc from org.jooq.DivideByOnConditionStep.and.

Deprecated

as a consequence of Condition being deprecated. See corresponding docs for further information.

Combine the currently assembled conditions with another one using the Operator#AND operator.

Annotations
@Override
andback to summary
public final DivideByOnConditionStep and(Field<Boolean> c)

Implements org.jooq.DivideByOnConditionStep.and.

Doc from org.jooq.DivideByOnConditionStep.and.

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

Combine the currently assembled conditions with another one using the Operator#AND operator.

Annotations
@Override
andback to summary
public final DivideByOnConditionStep and(SQL sql)

Implements org.jooq.DivideByOnConditionStep.and.

Doc from org.jooq.DivideByOnConditionStep.and.

Combine the currently assembled conditions with another one using the Operator#AND operator.

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!

Annotations
@Override
andback to summary
public final DivideByOnConditionStep and(String sql)

Implements org.jooq.DivideByOnConditionStep.and.

Doc from org.jooq.DivideByOnConditionStep.and.

Combine the currently assembled conditions with another one using the Operator#AND operator.

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!

Annotations
@Override
andback to summary
public final DivideByOnConditionStep and(String sql, Object... bindings)

Implements org.jooq.DivideByOnConditionStep.and.

Doc from org.jooq.DivideByOnConditionStep.and.

Combine the currently assembled conditions with another one using the Operator#AND operator.

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!

Annotations
@Override
andback to summary
public final DivideByOnConditionStep and(String sql, QueryPart... parts)

Implements org.jooq.DivideByOnConditionStep.and.

Doc from org.jooq.DivideByOnConditionStep.and.

Combine the currently assembled conditions with another one using the Operator#AND operator.

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!

Annotations
@Override
andExistsback to summary
public final DivideByOnConditionStep andExists(Select<?> select)

Implements org.jooq.DivideByOnConditionStep.andExists.

Doc from org.jooq.DivideByOnConditionStep.andExists.

Combine the currently assembled conditions with an EXISTS clause using the Operator#AND operator.

Annotations
@Override
andNotback to summary
public final DivideByOnConditionStep andNot(Condition c)

Implements org.jooq.DivideByOnConditionStep.andNot.

Doc from org.jooq.DivideByOnConditionStep.andNot.

Deprecated

as a consequence of Condition being deprecated. See corresponding docs for further information.

Combine the currently assembled conditions with a negated other one using the Operator#AND operator.

Annotations
@Override
andNotback to summary
public final DivideByOnConditionStep andNot(Field<Boolean> c)

Implements org.jooq.DivideByOnConditionStep.andNot.

Doc from org.jooq.DivideByOnConditionStep.andNot.

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

Combine the currently assembled conditions with a negated other one using the Operator#AND operator.

Annotations
@Override
andNotExistsback to summary
public final DivideByOnConditionStep andNotExists(Select<?> select)

Implements org.jooq.DivideByOnConditionStep.andNotExists.

Doc from org.jooq.DivideByOnConditionStep.andNotExists.

Combine the currently assembled conditions with a NOT EXISTS clause using the Operator#AND operator.

Annotations
@Override
onback to summary
public final DivideByOnConditionStep on(Condition conditions)

Implements org.jooq.DivideByOnStep.on.

Doc from org.jooq.DivideByOnStep.on.

Deprecated

as a consequence of Condition being deprecated. See corresponding docs for further information.

Add a division condition to the DIVIDE BY clause, connecting them with each other with Operator#AND.

Annotations
@Override
onback to summary
public final DivideByOnConditionStep on(Condition... conditions)

Implements org.jooq.DivideByOnStep.on.

Doc from org.jooq.DivideByOnStep.on.

Deprecated

as a consequence of Condition being deprecated. See corresponding docs for further information.

Add a division condition to the DIVIDE BY clause, connecting them with each other with Operator#AND.

Annotations
@Override
onback to summary
public final DivideByOnConditionStep on(Field<Boolean> c)

Implements org.jooq.DivideByOnStep.on.

Doc from org.jooq.DivideByOnStep.on.

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

Add a division condition to the DIVIDE BY clause

Annotations
@Override
onback to summary
public final DivideByOnConditionStep on(SQL sql)

Implements org.jooq.DivideByOnStep.on.

Doc from org.jooq.DivideByOnStep.on.

Add a division condition to the DIVIDE BY clause

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!

Annotations
@Override
onback to summary
public final DivideByOnConditionStep on(String sql)

Implements org.jooq.DivideByOnStep.on.

Doc from org.jooq.DivideByOnStep.on.

Add a division condition to the DIVIDE BY clause

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!

Annotations
@Override
onback to summary
public final DivideByOnConditionStep on(String sql, Object... bindings)

Implements org.jooq.DivideByOnStep.on.

Doc from org.jooq.DivideByOnStep.on.

Add a division condition to the DIVIDE BY clause

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!

Annotations
@Override
onback to summary
public final DivideByOnConditionStep on(String sql, QueryPart... parts)

Implements org.jooq.DivideByOnStep.on.

Doc from org.jooq.DivideByOnStep.on.

Add a division condition to the DIVIDE BY clause

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!

Annotations
@Override
orback to summary
public final DivideByOnConditionStep or(Condition c)

Implements org.jooq.DivideByOnConditionStep.or.

Doc from org.jooq.DivideByOnConditionStep.or.

Deprecated

as a consequence of Condition being deprecated. See corresponding docs for further information.

Combine the currently assembled conditions with another one using the Operator#OR operator.

Annotations
@Override
orback to summary
public final DivideByOnConditionStep or(Field<Boolean> c)

Implements org.jooq.DivideByOnConditionStep.or.

Doc from org.jooq.DivideByOnConditionStep.or.

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

Combine the currently assembled conditions with another one using the Operator#OR operator.

Annotations
@Override
orback to summary
public final DivideByOnConditionStep or(SQL sql)

Implements org.jooq.DivideByOnConditionStep.or.

Doc from org.jooq.DivideByOnConditionStep.or.

Combine the currently assembled conditions with another one using the Operator#OR operator.

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!

Annotations
@Override
orback to summary
public final DivideByOnConditionStep or(String sql)

Implements org.jooq.DivideByOnConditionStep.or.

Doc from org.jooq.DivideByOnConditionStep.or.

Combine the currently assembled conditions with another one using the Operator#OR operator.

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!

Annotations
@Override
orback to summary
public final DivideByOnConditionStep or(String sql, Object... bindings)

Implements org.jooq.DivideByOnConditionStep.or.

Doc from org.jooq.DivideByOnConditionStep.or.

Combine the currently assembled conditions with another one using the Operator#OR operator.

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!

Annotations
@Override
orback to summary
public final DivideByOnConditionStep or(String sql, QueryPart... parts)

Implements org.jooq.DivideByOnConditionStep.or.

Doc from org.jooq.DivideByOnConditionStep.or.

Combine the currently assembled conditions with another one using the Operator#OR operator.

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!

Annotations
@Override
orExistsback to summary
public final DivideByOnConditionStep orExists(Select<?> select)

Implements org.jooq.DivideByOnConditionStep.orExists.

Doc from org.jooq.DivideByOnConditionStep.orExists.

Combine the currently assembled conditions with an EXISTS clause using the Operator#OR operator.

Annotations
@Override
orNotback to summary
public final DivideByOnConditionStep orNot(Condition c)

Implements org.jooq.DivideByOnConditionStep.orNot.

Doc from org.jooq.DivideByOnConditionStep.orNot.

Deprecated

as a consequence of Condition being deprecated. See corresponding docs for further information.

Combine the currently assembled conditions with a negated other one using the Operator#OR operator.

Annotations
@Override
orNotback to summary
public final DivideByOnConditionStep orNot(Field<Boolean> c)

Implements org.jooq.DivideByOnConditionStep.orNot.

Doc from org.jooq.DivideByOnConditionStep.orNot.

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

Combine the currently assembled conditions with a negated other one using the Operator#OR operator.

Annotations
@Override
orNotExistsback to summary
public final DivideByOnConditionStep orNotExists(Select<?> select)

Implements org.jooq.DivideByOnConditionStep.orNotExists.

Doc from org.jooq.DivideByOnConditionStep.orNotExists.

Combine the currently assembled conditions with a NOT EXISTS clause using the Operator#OR operator.

Annotations
@Override
returningback to summary
public final Table<Record> returning(Field<?>... fields)

Implements org.jooq.DivideByReturningStep.returning.

Doc from org.jooq.DivideByReturningStep.returning.

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

Specify the fields that you want the division to return from the dividend

Annotations
@Override
returningback to summary
public final Table<Record> returning(Collection<? extends Field<?>> fields)

Implements org.jooq.DivideByReturningStep.returning.

Doc from org.jooq.DivideByReturningStep.returning.

Specify the fields that you want the division to return from the dividend

Annotations
@Override
selfJoinback to summary
private final <T> void selfJoin(ConditionProvider selfJoin, Table<?> outer, Table<?> inner, Field<T> field)

Deprecated

as a consequence of ConditionProvider and Field being deprecated. See corresponding docs for further information.

Extracted method for type-safety

tableback to summary
private final Table<Record> table()

Transform the relational division operation into SQL.

Various nice examples of how this can be achieved are found here: http://www.simple-talk.com/sql/t-sql-programming/divided-we-stand-the- sql-of-relational-division/