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

Class FromAdapter

java.lang.Object

com.ibm.fhir.database.utils.query.FromAdapter

public class FromAdapter
extends Object

Adapter for building the FROM clause of a SELECT statement

Constructor Summary

Constructors

Constructor	Description
FromAdapter(Select select)	Model the "from" part of the select statement

Method Summary

Modifier and Type	Method	Description
Select	build()	Provide the select statement we've been building
WhereClause	establishWhereClause()	Adds a where clause if one does not yet exist
FromAdapter	from(String tableName)	Add a table to the from clause returning this FromAdapter ready for the next item
FromAdapter	from(String tableName, Alias alias)	Add a table with an alias (tab AS foo) to the from clause returning this FromAdapter ready for the next item
GroupByAdapter	groupBy(String... expressions)	Start a group by expression
FromAdapter	innerJoin(String tableName, Alias alias, WhereFragment joinOnPredicate)	Add an INNER JOIN for the given table
FromAdapter	leftOuterJoin(String tableName, Alias alias, WhereFragment joinOnPredicate)	Add a LEFT OUTER JOIN for the given table
OrderByAdapter	orderBy(String... expressions)	Start an ORDER BY expression
FromSubQueryAdapter	subStart()	Start building a sub-query.
WhereAdapter	where()	Starts building a WHERE clause without any predicate nodes
WhereAdapter	where(ExpNode predicate)	Builds a WHERE clause starting with the given predicate node
WhereAdapter	where(String predicate)	Start building the "WHERE" clause for the statement
WhereAdapter	where(String tableAlias, String columnName)	Starts building a WHERE clause with the {tableAlias}.{columnName}

Methods inherited from class java.lang.Object

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

Constructor Detail

FromAdapter

public FromAdapter(Select select)

Model the "from" part of the select statement

Parameters:

select -

Method Detail

from

public FromAdapter from(String tableName)

Add a table to the from clause returning this FromAdapter ready for the next item

Parameters:

tableName -

Returns:

from

public FromAdapter from(String tableName,
                        Alias alias)

Add a table with an alias (tab AS foo) to the from clause returning this FromAdapter ready for the next item

Parameters:

tableName -

alias -

Returns:

innerJoin

public FromAdapter innerJoin(String tableName,
                             Alias alias,
                             WhereFragment joinOnPredicate)

Add an INNER JOIN for the given table

Parameters:

tableName -

alias -

joinOnPredicate -

Returns:

leftOuterJoin

public FromAdapter leftOuterJoin(String tableName,
                                 Alias alias,
                                 WhereFragment joinOnPredicate)

Add a LEFT OUTER JOIN for the given table

Parameters:

tableName -

alias -

joinOnPredicate -

Returns:

where

public WhereAdapter where(String predicate)

Start building the "WHERE" clause for the statement

Parameters:

predicate -

Returns:

where

public WhereAdapter where(String tableAlias,
                          String columnName)

Starts building a WHERE clause with the {tableAlias}.{columnName}

Parameters:

tableAlias -

columnName -

Returns:

where

public WhereAdapter where()

Starts building a WHERE clause without any predicate nodes

Returns:

where

public WhereAdapter where(ExpNode predicate)

Builds a WHERE clause starting with the given predicate node

Parameters:

predicate -

Returns:

establishWhereClause

public WhereClause establishWhereClause()

Adds a where clause if one does not yet exist

Returns:

subStart

public FromSubQueryAdapter subStart()

Start building a sub-query. This isn't added to the from until FromSubQueryAdapter.subEnd(String) is called

Returns:

build

public Select build()

Provide the select statement we've been building

Returns:

groupBy

public GroupByAdapter groupBy(String... expressions)

Start a group by expression

Parameters:

expressions -

Returns:

orderBy

public OrderByAdapter orderBy(String... expressions)

Start an ORDER BY expression

Parameters:

expressions -

Returns: