Package com.ibm.fhir.database.utils.query

Class FromClause

java.lang.Object

com.ibm.fhir.database.utils.query.FromClause

public class FromClause
extends Object

The FromClause SQL definition

Constructor Summary

Constructors

Constructor	Description
FromClause()

Method Summary

Modifier and Type	Method	Description
void	addFrom(Select sub, Alias alias)	Add the sub-query as an item in the from list
void	addInnerJoin(String tableName, Alias alias, ExpNode joinOnPredicate)	Add an inner join clause to the FROM items list
void	addLeftOuterJoin(String tableName, Alias alias, ExpNode joinOnPredicate)	Add a left outer join clause to the FROM items list
void	addTable(String tableName)	Add a table to the FROM items list
void	addTable(String tableName, Alias alias)	Add a table to the FROM items list
void	addTable(String schemaName, String tableName)	Add a table without an alias.
void	addTable(String schemaName, String tableName, Alias alias)	Add a qualified schema.table with an alias.
<T> T	render(StatementRenderer<T> renderer)	Render this FROM clause using the given renderer
String	toString()

Methods inherited from class java.lang.Object

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

Constructor Detail

FromClause

public FromClause()

Method Detail

addTable

public void addTable(String schemaName,
                     String tableName)

Add a table without an alias. Tsk tsk.

Parameters:

schemaName - the schema qualifier for the table

tableName - the table name

addTable

public void addTable(String schemaName,
                     String tableName,
                     Alias alias)

Add a qualified schema.table with an alias.

Parameters:

schemaName - the schema qualifier for the table

tableName - the table name

alias - the alias to use in select expressions and join predicates

addTable

public void addTable(String tableName,
                     Alias alias)

Add a table to the FROM items list

Parameters:

tableName -

alias -

addTable

public void addTable(String tableName)

Add a table to the FROM items list

Parameters:

tableName -

alias -

addFrom

public void addFrom(Select sub,
                    Alias alias)

Add the sub-query as an item in the from list

Parameters:

sub -

alias -

toString

public String toString()

Overrides:

toString in class Object

render

public <T> T render(StatementRenderer<T> renderer)

Render this FROM clause using the given renderer

Type Parameters:

T -

Parameters:

renderer -

Returns:

addInnerJoin

public void addInnerJoin(String tableName,
                         Alias alias,
                         ExpNode joinOnPredicate)

Add an inner join clause to the FROM items list

Parameters:

tableName -

alias -

joinOnPredicate -

addLeftOuterJoin

public void addLeftOuterJoin(String tableName,
                             Alias alias,
                             ExpNode joinOnPredicate)

Add a left outer join clause to the FROM items list

Parameters:

tableName -

alias -

joinOnPredicate -