org.brains2b.sql.meta

Class SelectDescriptor

java.lang.Object

org.brains2b.sql.meta.SelectDescriptor

Direct Known Subclasses:

SelectDescriptor.JoinDescriptor

public class SelectDescriptor
extends java.lang.Object

Describe a select statement in terms of the different keywords which makes it up

Version:

0.2[25-08-2016]

Author:

dennis@brains2b.nl

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static class	SelectDescriptor.JoinDescriptor Describes a join statement within a SelectDescriptor
static class	SelectDescriptor.Key All recognized Keys for a SELECT statement

Constructor Summary

Constructors

Constructor and Description
SelectDescriptor(java.lang.String sql) Create an SelectDescriptor on the basis of an select-statement

Method Summary

Modifier and Type	Method and Description
static int	findKeyWord(java.lang.String select, int pos, java.lang.String... words) find the first position of the keyword from words in SQL
java.lang.String	getAfter(SelectDescriptor.Key key) get the SQL statement after this SelectDescriptor.Key
java.lang.String	getBefore(SelectDescriptor.Key key) get the SQL statement before this SelectDescriptor.Key, not included
java.lang.String	getColumns() get a comma-seperated list of columns for this select statement
java.lang.String	getExcept() get the SelectDescriptor.Key.EXCEPT part of the select statement, null if it does not contain a union
java.lang.String	getFrom() get a comma-seperated list of tables from the FROM-part of this select statement
java.lang.String	getGroupBy() get a comma-seperated list of columns from the GROUP BY-part of this select statement
java.lang.String	getHaving() get the HAVING clause of this select statement
java.lang.String	getInBetween(SelectDescriptor.Key start, SelectDescriptor.Key end) get the SQL statement between SelectDescriptor.Key start and SelectDescriptor.Key end , not included
java.lang.String	getIntersect() get the SelectDescriptor.Key.INTERSECT part of the select statement, null if it does not contain a union
SelectDescriptor[]	getJoins() get a array of SelectDescriptor with all the joins in the Select statement
java.lang.String	getOrderBy() get a comma-seperated list of columns from the ORDER BY-part of this select statement
java.lang.String	getUnion() get the SelectDescriptor.Key.UNION part of the select statement, null if it does not contain a union
java.lang.String	getWhere() get the WHERE clause of this select statement
java.lang.String	toString() get the complete statement equals to the select statement which was passed in

Methods inherited from class java.lang.Object

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

Constructor Detail

SelectDescriptor

public SelectDescriptor(java.lang.String sql)

Create an SelectDescriptor on the basis of an select-statement

Parameters:

sql - String, a valid select statement

Method Detail

toString

public java.lang.String toString()

get the complete statement equals to the select statement which was passed in

Overrides:

toString in class java.lang.Object

See Also:

Object.toString()

getColumns

public java.lang.String getColumns()

get a comma-seperated list of columns for this select statement

Returns:

String, a comma-seperated list of columms. Could contain only * dependant on the select statement

getFrom

public java.lang.String getFrom()

get a comma-seperated list of tables from the FROM-part of this select statement

Returns:

String, a comma-seperated list of tables.

getJoins

public SelectDescriptor[] getJoins()

get a array of SelectDescriptor with all the joins in the Select statement

Returns:

an array of SelectDescriptor with joins

getWhere

public java.lang.String getWhere()

get the WHERE clause of this select statement

Returns:

String, the WHERE clause of this select statement without the keyword. Can be null if no WHERE-statement was defined

getGroupBy

public java.lang.String getGroupBy()

get a comma-seperated list of columns from the GROUP BY-part of this select statement

Returns:

String, a comma-seperated list of columms. Can be null if no GROUP BY-statement was defined

getHaving

public java.lang.String getHaving()

get the HAVING clause of this select statement

Returns:

String, the HAVING clause of this select statement without the keyword. Can be null if no HAVING-statement was defined

getOrderBy

public java.lang.String getOrderBy()

get a comma-seperated list of columns from the ORDER BY-part of this select statement

Returns:

String, a comma-seperated list of columms. Can be null if no ORDER BY-statement was defined

getUnion

public java.lang.String getUnion()

get the SelectDescriptor.Key.UNION part of the select statement, null if it does not contain a union

Returns:

the SelectDescriptor.Key.UNION part of the select statement

getIntersect

public java.lang.String getIntersect()

get the SelectDescriptor.Key.INTERSECT part of the select statement, null if it does not contain a union

Returns:

the SelectDescriptor.Key.INTERSECT part of the select statement

getExcept

public java.lang.String getExcept()

get the SelectDescriptor.Key.EXCEPT part of the select statement, null if it does not contain a union

Returns:

the SelectDescriptor.Key.EXCEPT part of the select statement

getInBetween

public java.lang.String getInBetween(SelectDescriptor.Key start,
                                     SelectDescriptor.Key end)

get the SQL statement between SelectDescriptor.Key start and SelectDescriptor.Key end , not included

Parameters:

start - SelectDescriptor.Key

end - SelectDescriptor.Key

Returns:

String the SQL statement between SelectDescriptor.Key start and SelectDescriptor.Key end

getBefore

public java.lang.String getBefore(SelectDescriptor.Key key)

get the SQL statement before this SelectDescriptor.Key, not included

Parameters:

key - SelectDescriptor.Key

Returns:

String the SQL statement before this SelectDescriptor.Key

getAfter

public java.lang.String getAfter(SelectDescriptor.Key key)

get the SQL statement after this SelectDescriptor.Key

Parameters:

key - SelectDescriptor.Key

Returns:

String the SQL statement after this SelectDescriptor.Key

findKeyWord

public static int findKeyWord(java.lang.String select,
                              int pos,
                              java.lang.String... words)

find the first position of the keyword from words in SQL

Parameters:

select - String

pos - integer

words - String[]

Returns:

position of the first keyword