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

Constructor Summary

Constructors

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

Method Summary

Modifier and Type	Method and 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 Detail

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 Detail

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 Detail

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