Package overit.geocall.sql.code

Class CompoundSelect

java.lang.Object

overit.geocall.sql.code.fragment.Fragment

overit.geocall.sql.code.fragment.FragmentSequence

overit.geocall.sql.code.Sql

overit.geocall.sql.code.CompoundSelect

public class CompoundSelect
extends Sql

The class extends Sql and aims to create a string of sql code in which there are two select statements divided by a specific operation like UNION,UNION_ALL,EXCEPT ecc.
The entire statement will be enclosed between '(' and ')'.

Field Summary

Fields

Modifier and Type	Field	Description
protected FragmentSequence	_orderBys
protected FragmentSequence	_selects
static final String	EXCEPT	A Static constant that define the EXCEPT sql statement.
static final String	EXCEPT_ALL	A Static constant that define the EXCEPT ALL sql statement.
static final String	INTERSECT	A Static constant that define the INSTERSECT sql statement.
static final String	INTERSECT_ALL	A Static constant that define the INSTERSECT ALL sql statement.
static final String	MINUS	A Static constant that define the MINUS sql statement.
static final String	MINUS_ALL	A Static constant that define the MINUS ALL sql statement.
static final String	UNION	A Static constant that define the UNION sql statement.
static final String	UNION_ALL	A Static constant that define the UNION ALL sql statement.

Fields inherited from class overit.geocall.sql.code.fragment.FragmentSequence

_fragments, _prefix, _separator, _suffix

Fields inherited from class overit.geocall.sql.code.fragment.Fragment

_criterion

Constructor Summary

Constructors

Constructor	Description
CompoundSelect(String operation)	The class's constructor that define the entire statement based on the operation given by input. An example could be the statement "(SELECT FIELD1 FROM TABLE1 UNION ALL SELECT FIELD2 FROM TABLE2)".

Method Summary

Modifier and Type	Method	Description
FragmentSequence	orderBy()	Gets the current ORDER BY statemnt.
FragmentSequence	selects()	Gets the current SELECT statemnt.

Methods inherited from class overit.geocall.sql.code.Sql

main

Methods inherited from class overit.geocall.sql.code.fragment.FragmentSequence

add, add, appendTo, clear, get, size

Methods inherited from class overit.geocall.sql.code.fragment.Fragment

getCriterion, overlapCriterion, replaceCriterion, toString

Methods inherited from class java.lang.Object

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

Field Details

UNION

public static final String UNION

A Static constant that define the UNION sql statement.

See Also:

• Constant Field Values

UNION_ALL

public static final String UNION_ALL

A Static constant that define the UNION ALL sql statement.

See Also:

• Constant Field Values

INTERSECT

public static final String INTERSECT

A Static constant that define the INSTERSECT sql statement.

See Also:

• Constant Field Values

INTERSECT_ALL

public static final String INTERSECT_ALL

A Static constant that define the INSTERSECT ALL sql statement.

See Also:

• Constant Field Values

EXCEPT

public static final String EXCEPT

A Static constant that define the EXCEPT sql statement.

See Also:

• Constant Field Values

EXCEPT_ALL

public static final String EXCEPT_ALL

A Static constant that define the EXCEPT ALL sql statement.

See Also:

• Constant Field Values

MINUS

public static final String MINUS

A Static constant that define the MINUS sql statement.

See Also:

• Constant Field Values

MINUS_ALL

public static final String MINUS_ALL

A Static constant that define the MINUS ALL sql statement.

See Also:

• Constant Field Values

_selects

protected FragmentSequence _selects

_orderBys

protected FragmentSequence _orderBys

Constructor Details

CompoundSelect

public CompoundSelect(String operation)

The class's constructor that define the entire statement based on the operation given by input.
An example could be the statement "(SELECT FIELD1 FROM TABLE1 UNION ALL SELECT FIELD2 FROM TABLE2)".

Parameters:

operation - String containing the operation

Method Details

selects

public FragmentSequence selects()

Gets the current SELECT statemnt.

Returns:

A FragmentSequence that represent the current SELECT statement.

orderBy

public FragmentSequence orderBy()

Gets the current ORDER BY statemnt.

Returns:

A FragmentSequence that represent the current ORDER BY statement.