public Class TableImpl<R extends org.jooq.Record>

Implements org.jooq.QueryPartInternal.accept.

Doc from org.jooq.QueryPartInternal.accept.

This QueryPart can accept a Context object in order to render a SQL string or to bind its variables.

Annotations

@Override

Overrides org.jooq.impl.AbstractTable.as.

Implements org.jooq.Table.as.

Doc from org.jooq.Table.as.

Subclasses may override this method to provide custom aliasing implementations

Create an alias for this table.

Note that the case-sensitivity of the returned table depends on Settings#getRenderQuotedNames() and the Name. By default, table aliases are quoted, and thus case-sensitive in many SQL dialects - use DSL#unquotedName(String...) for case-insensitive aliases.

If the argument Name#getName() is qualified, then the Name#last() part will be used.

This method works both to alias the table as well as alias the table in its SelectField form via the SelectField#as(String) override. In order to alias only the projected table expression, use DSL#field(SelectField) to wrap this table into a Field

Parameters

as:Name

The alias name

Returns:Table<R>

The table alias

Annotations

@Override

Overrides org.jooq.impl.AbstractTable.as.

Implements org.jooq.Table.as.

Doc from org.jooq.Table.as.

Subclasses may override this method to provide custom aliasing implementations

Create an alias for this table and its fields.

Note that the case-sensitivity of the returned table depends on Settings#getRenderQuotedNames() and the Name. By default, table aliases are quoted, and thus case-sensitive in many SQL dialects - use DSL#unquotedName(String...) for case-insensitive aliases.

If the argument Name#getName() is qualified, then the Name#last() part will be used.

Derived column lists for table references

Note, not all databases support derived column lists for their table aliases. On the other hand, some databases do support derived column lists, but only for derived tables. jOOQ will try to turn table references into derived tables to make this syntax work. In other words, the following statements are equivalent:

-- Using derived column lists to rename columns (e.g. Postgres)
SELECT t.a, t.b
FROM my_table t(a, b)

-- Nesting table references within derived tables (e.g. SQL Server)
SELECT t.a, t.b
FROM (
  SELECT * FROM my_table
) t(a, b)

Derived column lists for derived tables

Other databases may not support derived column lists at all, but they do support common table expressions. The following statements are equivalent:

-- Using derived column lists to rename columns (e.g. Postgres)
SELECT t.a, t.b
FROM (
  SELECT 1, 2
) AS t(a, b)

-- Using UNION ALL to produce column names (e.g. MySQL)
SELECT t.a, t.b
FROM (
  SELECT null a, null b FROM DUAL WHERE 1 = 0
  UNION ALL
  SELECT 1, 2 FROM DUAL
) t

Parameters

as:Name

The alias name

fieldAliases:Name[]

The field aliases. Excess aliases are ignored, missing aliases will be substituted by this table's field names.

Returns:Table<R>

The table alias

Annotations

@Override

Overrides org.jooq.impl.AbstractTable.clauses.

Implements org.jooq.QueryPartInternal.clauses.

Doc from org.jooq.QueryPartInternal.clauses.

The Clauses that are represented by this query part.

QueryParts can specify several Clauses for which an event will be emitted before (in forward order) and after (in reverse order) visiting the the query part through Context#visit(QueryPart)

This method is for JOOQ INTERNAL USE only. Do not reference directly

Returns:Clause[]

The Clauses represented by this query part or null or an empty array if this query part does not represent a clause.

Annotations

@Override

Overrides org.jooq.impl.AbstractQueryPart.declaresTables.

Implements org.jooq.QueryPartInternal.declaresTables.

Doc from org.jooq.QueryPartInternal.declaresTables.

Check whether this QueryPart is able to declare tables in a FROM clause or JOIN clause.

This method can be used by any Context to check how a certain SQL clause should be rendered.

This method is for JOOQ INTERNAL USE only. Do not reference directly

Annotations

@Override

Overrides org.jooq.impl.AbstractNamed.equals.

Implements org.jooq.QueryPart.equals, org.jooq.Table.equals.

Doc from org.jooq.QueryPart.equals.

Check whether this QueryPart can be considered equal to another QueryPart.

In general, QueryPart equality is defined in terms of toString() equality. In other words, two query parts are considered equal if their rendered SQL (with inlined bind variables) is equal. This means that the two query parts do not necessarily have to be of the same type.

Some QueryPart implementations may choose to override this behaviour for improved performance, as toString() is an expensive operation, if called many times.

Parameters

that:Object

The other QueryPart

Returns:boolean

Whether the two query parts are equal

Annotations

@Override

Overrides default org.jooq.impl.FieldsTrait.field.

Implements org.jooq.Fields.field.

Doc from org.jooq.Fields.field.

Get a field known to this type by unqualified name, or null if no field is known to this type by this name.

If several fields have the same ambiguous name, the first one is returned and a warning is logged.

Parameters

name:String

The unqualified name of the field

Annotations

@Override

Overrides default org.jooq.impl.FieldsTrait.field.

Implements org.jooq.Fields.field.

Doc from org.jooq.Fields.field.

Get a field known to this type by unqualified name coerced to type, or null if no field is known to this type by this name.

If several fields have the same ambiguous name, the first one is returned and a warning is logged.

Parameters

name:String

The unqualified name of the field

type:Class<T>

The type to coerce the resulting field to

Annotations

@Override

Overrides default org.jooq.impl.FieldsTrait.field.

Implements org.jooq.Fields.field.

Doc from org.jooq.Fields.field.

Get a field known to this type by unqualified name coerced to dataType, or null if no field is known to this type by this name.

If several fields have the same ambiguous name, the first one is returned and a warning is logged.

Parameters

name:String

The unqualified name of the field

dataType:DataType<T>

The data type to coerce the resulting field to

Annotations

@Override

Overrides default org.jooq.impl.FieldsTrait.field.

Implements org.jooq.Fields.field.

Doc from org.jooq.Fields.field.

Get a field known to this type by qualified name, or null if no field is known to this type by this name.

This will return:

• A field whose name is equal to the argument field's name (exact matching fully qualified name).
• A field whose name is equal to the argument field's name (partially matching qualified name).
• A field whose name is equal to the unqualified name of the argument field.
• null otherwise.

If several fields have the same ambiguous name, the first one is returned and a warning is logged.

Parameters

name:Name

The qualified name of the field

Annotations

@Override

Overrides default org.jooq.impl.FieldsTrait.field.

Implements org.jooq.Fields.field.

Doc from org.jooq.Fields.field.

Get a field known to this type by qualified name coerced to type, or null if no field is known to this type by this name.

This will return:

• A field whose name is equal to the argument field's name (exact matching fully qualified name).
• A field whose name is equal to the argument field's name (partially matching qualified name).
• A field whose name is equal to the unqualified name of the argument field.
• null otherwise.

If several fields have the same ambiguous name, the first one is returned and a warning is logged.

Parameters

name:Name

The qualified name of the field

type:Class<T>

The type to coerce the resulting field to

Annotations

@Override

Overrides default org.jooq.impl.FieldsTrait.field.

Implements org.jooq.Fields.field.

Doc from org.jooq.Fields.field.

Get a field known to this type by qualified name coerced to dataType, or null if no field is known to this type by this name.

This will return:

• A field whose name is equal to the argument field's name (exact matching fully qualified name).
• A field whose name is equal to the argument field's name (partially matching qualified name).
• A field whose name is equal to the unqualified name of the argument field.
• null otherwise.

If several fields have the same ambiguous name, the first one is returned and a warning is logged.

Parameters

name:Name

The qualified name of the field

dataType:DataType<T>

The data type to coerce the resulting field to

Annotations

@Override

Overrides org.jooq.impl.AbstractTable.fieldsRow.

Implements org.jooq.Fields.fieldsRow.

Doc from org.jooq.Fields.fieldsRow.

Get all fields known to this type as a Row.

Annotations

@Override

Implements org.jooq.RecordQualifier.getRecordType.

Doc from org.jooq.RecordQualifier.getRecordType.

Subclasses must override this method if they use the generic type parameter R for other types than Record

The record type produced by this UDT or Table.

Annotations

@SuppressWarnings:unchecked

@Override

Overrides org.jooq.impl.AbstractNamed.hashCode.

Implements org.jooq.QueryPart.hashCode.

Doc from org.jooq.QueryPart.hashCode.

Generate a hash code from this QueryPart.

In general, QueryPart hash codes are the same as the hash codes generated from toString(). This guarantees consistent behaviour with equals(Object)

Some QueryPart implementations may choose to override this behaviour for improved performance, as toString() is an expensive operation, if called many times.

Returns:int

The QueryPart hash code

Annotations

@Override

Overrides default org.jooq.impl.SimpleCheckQueryPart.isSimple.

Doc from org.jooq.impl.SimpleCheckQueryPart.isSimple.

Whether the QueryPart really is simple.

e.g. an OrderField can be simple if its contents are also simple.

Annotations

@Override

@Internal

Overrides org.jooq.impl.AbstractTable.join.

Implements org.jooq.Table.join.

Doc from org.jooq.Table.join.

Join a table to this table using a JoinType

Depending on the JoinType, a subsequent TableOnStep#on(Condition) or TableOnStep#using(Field...) clause is required. If it is required but omitted, a DSL#trueCondition(), i.e. 1 = 1 condition will be rendered

Annotations

@Override