Package org.nuxeo.ecm.core.storage.sql.jdbc.db

Class Join

java.lang.Object

org.nuxeo.ecm.core.storage.sql.jdbc.db.Join

All Implemented Interfaces:

Serializable, Comparable<Join>

public class Join
extends Object
implements Serializable, Comparable<Join>

A SQL JOIN.

See Also:

• Serialized Form

Field Summary

Fields

Modifier and Type	Field	Description
Column	column1	Left part of equijoin.
Column	column2	Right part of equijoin.
static final int	IMPLICIT
static final int	INNER
final int	kind	INNER / LEFT / RIGHT / IMPLICIT
static final int	LEFT
String	on1	Left part of equijoin.
String	on2	Right part of equijoin.
static final int	RIGHT
final String	table	Table name.
final String	tableAlias	Table alias, or null.
final String	tableParam	Parameter if table name is an expression that contains a "?"
final List<String>	whereClauses	Additional WHERE clauses.
final List<Serializable>	whereParams	Additional WHERE clauses parameters.

Constructor Summary

Constructors

Constructor	Description
Join(int kind, String table, String tableAlias, String tableParam, String on1, String on2)
Join(int kind, String table, String tableAlias, String tableParam, Column column1, Column column2)

Method Summary

Modifier and Type	Method	Description
void	addWhereClause(String whereClause, Serializable whereParam)
int	compareTo(Join other)
String	getClause(Dialect dialect)
String	getTable(Dialect dialect)
String	toSql(Dialect dialect)	Does not return the WHERE clause.
String	toString()

Methods inherited from class java.lang.Object

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

Field Details

INNER

public static final int INNER

See Also:

• Constant Field Values

LEFT

public static final int LEFT

See Also:

• Constant Field Values

RIGHT

public static final int RIGHT

See Also:

• Constant Field Values

IMPLICIT

public static final int IMPLICIT

See Also:

• Constant Field Values

kind

public final int kind

INNER / LEFT / RIGHT / IMPLICIT

table

public final String table

Table name.

tableAlias

public final String tableAlias

Table alias, or null.

tableParam

public final String tableParam

Parameter if table name is an expression that contains a "?", or null.

column1

public Column column1

Left part of equijoin.

column2

public Column column2

Right part of equijoin.

on1

public String on1

Left part of equijoin.

on2

public String on2

Right part of equijoin.

whereClauses

public final List<String> whereClauses

Additional WHERE clauses.

whereParams

public final List<Serializable> whereParams

Additional WHERE clauses parameters.

Constructor Details

Join

public Join(int kind,
 String table,
 String tableAlias,
 String tableParam,
 Column column1,
 Column column2)

Join

public Join(int kind,
 String table,
 String tableAlias,
 String tableParam,
 String on1,
 String on2)

Method Details

addWhereClause

public void addWhereClause(String whereClause,
 Serializable whereParam)

compareTo

public int compareTo(Join other)

Specified by:

compareTo in interface Comparable<Join>

getTable

public String getTable(Dialect dialect)

getClause

public String getClause(Dialect dialect)

toSql

public String toSql(Dialect dialect)

Does not return the WHERE clause.

toString

public String toString()

Overrides:

toString in class Object