Package com.j_spaces.jdbc.parser.grammar

Class SqlParser

java.lang.Object

com.j_spaces.jdbc.parser.grammar.SqlParser

All Implemented Interfaces:

SqlParserConstants

public class SqlParser
extends Object
implements SqlParserConstants

Field Summary

Fields

Modifier and Type	Field	Description
Token	jj_nt	Next token.
Token	token	Current token.
SqlParserTokenManager	token_source	Generated Token Manager.

Fields inherited from interface com.j_spaces.jdbc.parser.grammar.SqlParserConstants

ADD, ALL, ALTER, AND, AS, ASC, ASSIGN, ASTERISK, AVG, BETWEEN, BIGINT, BIT, BLOB, BOOLEAN, BY, CALL, CHAR, CLOB, CLOSEBRACKET, CLOSEBRAKET, CLOSEPAREN, COLLECTION_CONTAINS, COMMIT, CONCAT, COUNT, CREATE, CURRENT_DATE, DATE, DATE_LITERAL, DATETIME, DECIMAL, DEFAULT, DEFAULT_NULL, DELETE, DESC, DIGIT, DISTINCT, DOT, DOUBLE, DROP, EMPTY_BLOB, EMPTY_CLOB, END, EOF, EQUAL, ESC_IDENTIFIER, EXCEPTION, EXPONENT, FALSE, FLOAT, FLOATING_POINT_LITERAL, FOR_UPDATE, FROM, FULL, GREATER, GREATEREQUAL, GROUP, IDENTIFIER, IN, INDEX, INNER, INSERT, INT, INTEGER, INTEGER_LITERAL, INTO, IS, JOIN, JOINPLUS, LEFT, LESS, LESSEQUAL, LETTER, LIKE, LOB, LONG, LONG_LITERAL, LONGVARCHAR, MAX, MIN, MINUS, NOT, NOTEQUAL, NOTEQUAL2, NULL, NULLS_FIRST, NULLS_LAST, NUMBER, NUMERIC, ON, OPENBRACKET, OPENBRAKET, OPENPAREN, OR, ORDER, PARTITION_BY, PLUS, PRIMARY_KEY, QUESTIONMARK, REAL, RELATION, RIGHT, RLIKE, ROLLBACK, ROWNUM, ROWTYPE, SELECT, SEMICOLON, SET, SLASH, SMALLINT, STRING_LITERAL, SUBSTR, SUM, SYSDATE, TABLE, TILDE, TIME, TIMESTAMP, TINYINT, tokenImage, TRUE, UID, UNION, UPDATE, USING, VALUES, VARCHAR, VARCHAR2, WHERE

Constructor Summary

Constructors

Constructor	Description
SqlParser(SqlParserTokenManager tm)	Constructor with generated Token Manager.
SqlParser(InputStream stream)	Constructor with InputStream.
SqlParser(InputStream stream, String encoding)	Constructor with InputStream and supplied encoding
SqlParser(Reader stream)	Constructor.

Method Summary

Modifier and Type	Method	Description
final Query	alterTable()
final AndNode	betweenNode(AbstractDMLQuery query, ColumnNode columnNode1)
final String	className()
final Object	classNameOrSelect()	Can be string for className or Query for select in select
final void	columnList(AbstractDMLQuery query)
final void	columnListWithValues(UpdateQuery query)
final Query	commit()
final ExpNode	condition(AbstractDMLQuery query)
final ExpNode	conditionNode(AbstractDMLQuery query, ColumnNode columnNode1)
final AndNode	containsBetweenItemNode(AbstractDMLQuery query, ColumnNode columnNode1, StringBuilder columnPath)
final AndNode	containsBetweenNode(AbstractDMLQuery query, ColumnNode columnNode1, String column)
final ExpNode	containsInItemNode(AbstractDMLQuery query, ColumnNode columnNode1, StringBuilder columnPath)
final ExpNode	containsInNode(AbstractDMLQuery query, ColumnNode columnNode1, String column)
final ExpNode	containsIsNotNullNode(AbstractDMLQuery query, ColumnNode columnNode1, String columnPath)
final ExpNode	containsIsNullNode(AbstractDMLQuery query, ColumnNode columnNode1, String columnPath)
final ExpNode	containsMultipleNode(AbstractDMLQuery query, ColumnNode columnNode1, String columnPath)
final ExpNode	containsNode(AbstractDMLQuery query, ColumnNode columnNode1)
final ExpNode	containsSimpleItemNode(AbstractDMLQuery query, ColumnNode columnNode1, StringBuilder columnPath, boolean insideInternalContains)
final ExpNode	containsSimpleNode(AbstractDMLQuery query, ColumnNode columnNode1, String column)
final ExpNode	containsSingleNode(AbstractDMLQuery query, ColumnNode columnNode1, String column)
final ExpNode	containtsItemSimpleCondition(AbstractDMLQuery query)
final ExpNode	containtsItemSimpleConditionImpl(AbstractDMLQuery query, StringBuilder columnPath, ColumnNode columnNode1, boolean insideInternalContains)
final SelectQuery	countSqlQuery()
final ColumnNode	createColumnNode(AbstractDMLQuery query, String columnFunc)
final List	createFunctionParams()
final OrderColumn	createOrderColumn(AbstractDMLQuery query)
final Query	createTable()
final Query	deleteSql()
final DeleteQuery	deleteSqlQuery()
final void	disable_tracing()	Disable tracing.
final Query	dropTable()
final void	enable_tracing()	Enable tracing.
final ProcedureQuery	executeProcedure()
final void	function(SelectQuery query)
ParseException	generateParseException()	Generate ParseException.
final ValueNode	getBetweenValueNode(AbstractDMLQuery query)
final Token	getNextToken()	Get the next Token.
final SelectColumn	getSelectColumn(AbstractDMLQuery query)
final SelectColumn	getSelectColumnOrFunction(String fname, AbstractDMLQuery query)
final Token	getToken(int index)	Get the specific Token.
final void	groupBy(SelectQuery query)
final Token	id()
final ExpNode	inExprOrList(AbstractDMLQuery query, boolean isNot)
final Query	insertSql()
final void	insertValuesList(InsertQuery insertQuery)
final HashSet<LiteralNode>	inValueList(AbstractDMLQuery query)
final ExpNode	isNullNode(AbstractDMLQuery query, ColumnNode columnNode1)
final Join	join()
final void	joins(SelectQuery query)
static void	main(String[] args)
final void	orderBy(SelectQuery query)
final Object	param()
final LiteralNode	parseInValue(AbstractDMLQuery query)
final Query	parseStatement()
final AbstractDMLQuery	readMultipleQuery()
void	ReInit(SqlParserTokenManager tm)	Reinitialise.
void	ReInit(InputStream stream)	Reinitialise.
void	ReInit(InputStream stream, String encoding)	Reinitialise.
void	ReInit(Reader stream)	Reinitialise.
final ExpNode	relationNode(AbstractDMLQuery query, ColumnNode columnNode)
void	reset(Reader reader)
final void	selectColumn(SelectQuery query)
final void	selectColumnList(SelectQuery query)
final SelectQuery	selectSql()
final SelectQuery	selectSqlQuery()
final void	selectTableList(SelectQuery query)
final void	setColumnValue(UpdateQuery updateQuery, ArrayList<LiteralNode> newValues)
final void	setQuantifier(SelectQuery query)
final ExpNode	SqlAndExpression(AbstractDMLQuery query)
final ExpNode	SqlContainsItemExpression(AbstractDMLQuery query)
final ExpNode	SqlContainsItemSimpleExpression(AbstractDMLQuery query)
final ExpNode	SqlExpression(AbstractDMLQuery query)
final ExpNode	SqlInClause(AbstractDMLQuery query)
final ExpNode	SqlSimpleExpression(AbstractDMLQuery query)
final String	sqlType()
final void	tableName(AbstractDMLQuery query)
final void	tableNameWithOptionalAlias(AbstractDMLQuery query)
final Query	updateSql()
final ValueNode	valueNode(AbstractDMLQuery query)
final FunctionCallColumn	varArgFunctionCall(String fname)

Methods inherited from class java.lang.Object

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

Field Details

token_source

public SqlParserTokenManager token_source

Generated Token Manager.

token

public Token token

Current token.

jj_nt

public Token jj_nt

Next token.

Constructor Details

SqlParser

public SqlParser(InputStream stream)

Constructor with InputStream.

SqlParser

public SqlParser(InputStream stream,
 String encoding)

Constructor with InputStream and supplied encoding

SqlParser

public SqlParser(Reader stream)

Constructor.

SqlParser

public SqlParser(SqlParserTokenManager tm)

Constructor with generated Token Manager.

Method Details

main

public static void main(String[] args)
                 throws ParseException

Throws:

ParseException

reset

public void reset(Reader reader)

parseStatement

public final Query parseStatement()
                           throws ParseException

Throws:

ParseException

selectSql

public final SelectQuery selectSql()
                            throws ParseException

Throws:

ParseException

joins

public final void joins(SelectQuery query)
                 throws ParseException

Throws:

ParseException

join

public final Join join()
                throws ParseException

Throws:

ParseException

readMultipleQuery

public final AbstractDMLQuery readMultipleQuery()
                                         throws ParseException

Throws:

ParseException

selectSqlQuery

public final SelectQuery selectSqlQuery()
                                 throws ParseException

Throws:

ParseException

deleteSqlQuery

public final DeleteQuery deleteSqlQuery()
                                 throws ParseException

Throws:

ParseException

countSqlQuery

public final SelectQuery countSqlQuery()
                                throws ParseException

Throws:

ParseException

deleteSql

public final Query deleteSql()
                      throws ParseException

Throws:

ParseException

updateSql

public final Query updateSql()
                      throws ParseException

Throws:

ParseException

insertSql

public final Query insertSql()
                      throws ParseException

Throws:

ParseException

createTable

public final Query createTable()
                        throws ParseException

Throws:

ParseException

dropTable

public final Query dropTable()
                      throws ParseException

Throws:

ParseException

alterTable

public final Query alterTable()
                       throws ParseException

Throws:

ParseException

commit

public final Query commit()
                   throws ParseException

Throws:

ParseException

executeProcedure

public final ProcedureQuery executeProcedure()
                                      throws ParseException

Throws:

ParseException

setQuantifier

public final void setQuantifier(SelectQuery query)
                         throws ParseException

Throws:

ParseException

columnList

public final void columnList(AbstractDMLQuery query)
                      throws ParseException

Throws:

ParseException

selectColumnList

public final void selectColumnList(SelectQuery query)
                            throws ParseException

Throws:

ParseException

selectColumn

public final void selectColumn(SelectQuery query)
                        throws ParseException

Throws:

ParseException

getSelectColumnOrFunction

public final SelectColumn getSelectColumnOrFunction(String fname,
 AbstractDMLQuery query)
                                             throws ParseException

Throws:

ParseException

varArgFunctionCall

public final FunctionCallColumn varArgFunctionCall(String fname)
                                            throws ParseException

Throws:

ParseException

getSelectColumn

public final SelectColumn getSelectColumn(AbstractDMLQuery query)
                                   throws ParseException

Throws:

ParseException

columnListWithValues

public final void columnListWithValues(UpdateQuery query)
                                throws ParseException

Throws:

ParseException

setColumnValue

public final void setColumnValue(UpdateQuery updateQuery,
 ArrayList<LiteralNode> newValues)
                          throws ParseException

Throws:

ParseException

function

public final void function(SelectQuery query)
                    throws ParseException

Throws:

ParseException

createColumnNode

public final ColumnNode createColumnNode(AbstractDMLQuery query,
 String columnFunc)
                                  throws ParseException

Throws:

ParseException

createFunctionParams

public final List createFunctionParams()
                                throws ParseException

Throws:

ParseException

param

public final Object param()
                   throws ParseException

Throws:

ParseException

selectTableList

public final void selectTableList(SelectQuery query)
                           throws ParseException

Throws:

ParseException

classNameOrSelect

public final Object classNameOrSelect()
                               throws ParseException

Can be string for className or Query for select in select

Throws:

ParseException

tableNameWithOptionalAlias

public final void tableNameWithOptionalAlias(AbstractDMLQuery query)
                                      throws ParseException

Throws:

ParseException

tableName

public final void tableName(AbstractDMLQuery query)
                     throws ParseException

Throws:

ParseException

insertValuesList

public final void insertValuesList(InsertQuery insertQuery)
                            throws ParseException

Throws:

ParseException

groupBy

public final void groupBy(SelectQuery query)
                   throws ParseException

Throws:

ParseException

orderBy

public final void orderBy(SelectQuery query)
                   throws ParseException

Throws:

ParseException

createOrderColumn

public final OrderColumn createOrderColumn(AbstractDMLQuery query)
                                    throws ParseException

Throws:

ParseException

SqlExpression

public final ExpNode SqlExpression(AbstractDMLQuery query)
                            throws ParseException

Throws:

ParseException

SqlAndExpression

public final ExpNode SqlAndExpression(AbstractDMLQuery query)
                               throws ParseException

Throws:

ParseException

SqlSimpleExpression

public final ExpNode SqlSimpleExpression(AbstractDMLQuery query)
                                  throws ParseException

Throws:

ParseException

SqlContainsItemExpression

public final ExpNode SqlContainsItemExpression(AbstractDMLQuery query)
                                        throws ParseException

Throws:

ParseException

SqlContainsItemSimpleExpression

public final ExpNode SqlContainsItemSimpleExpression(AbstractDMLQuery query)
                                              throws ParseException

Throws:

ParseException

containtsItemSimpleCondition

public final ExpNode containtsItemSimpleCondition(AbstractDMLQuery query)
                                           throws ParseException

Throws:

ParseException

containtsItemSimpleConditionImpl

public final ExpNode containtsItemSimpleConditionImpl(AbstractDMLQuery query,
 StringBuilder columnPath,
 ColumnNode columnNode1,
 boolean insideInternalContains)
                                               throws ParseException

Throws:

ParseException

SqlInClause

public final ExpNode SqlInClause(AbstractDMLQuery query)
                          throws ParseException

Throws:

ParseException

className

public final String className()
                       throws ParseException

Throws:

ParseException

sqlType

public final String sqlType()
                     throws ParseException

Throws:

ParseException

id

public final Token id()
               throws ParseException

Throws:

ParseException

condition

public final ExpNode condition(AbstractDMLQuery query)
                        throws ParseException

Throws:

ParseException

relationNode

public final ExpNode relationNode(AbstractDMLQuery query,
 ColumnNode columnNode)
                           throws ParseException

Throws:

ParseException

conditionNode

public final ExpNode conditionNode(AbstractDMLQuery query,
 ColumnNode columnNode1)
                            throws ParseException

Throws:

ParseException

isNullNode

public final ExpNode isNullNode(AbstractDMLQuery query,
 ColumnNode columnNode1)
                         throws ParseException

Throws:

ParseException

betweenNode

public final AndNode betweenNode(AbstractDMLQuery query,
 ColumnNode columnNode1)
                          throws ParseException

Throws:

ParseException

containsSimpleItemNode

public final ExpNode containsSimpleItemNode(AbstractDMLQuery query,
 ColumnNode columnNode1,
 StringBuilder columnPath,
 boolean insideInternalContains)
                                     throws ParseException

Throws:

ParseException

containsBetweenItemNode

public final AndNode containsBetweenItemNode(AbstractDMLQuery query,
 ColumnNode columnNode1,
 StringBuilder columnPath)
                                      throws ParseException

Throws:

ParseException

containsInItemNode

public final ExpNode containsInItemNode(AbstractDMLQuery query,
 ColumnNode columnNode1,
 StringBuilder columnPath)
                                 throws ParseException

Throws:

ParseException

containsBetweenNode

public final AndNode containsBetweenNode(AbstractDMLQuery query,
 ColumnNode columnNode1,
 String column)
                                  throws ParseException

Throws:

ParseException

containsSimpleNode

public final ExpNode containsSimpleNode(AbstractDMLQuery query,
 ColumnNode columnNode1,
 String column)
                                 throws ParseException

Throws:

ParseException

containsInNode

public final ExpNode containsInNode(AbstractDMLQuery query,
 ColumnNode columnNode1,
 String column)
                             throws ParseException

Throws:

ParseException

containsNode

public final ExpNode containsNode(AbstractDMLQuery query,
 ColumnNode columnNode1)
                           throws ParseException

Throws:

ParseException

containsIsNullNode

public final ExpNode containsIsNullNode(AbstractDMLQuery query,
 ColumnNode columnNode1,
 String columnPath)
                                 throws ParseException

Throws:

ParseException

containsIsNotNullNode

public final ExpNode containsIsNotNullNode(AbstractDMLQuery query,
 ColumnNode columnNode1,
 String columnPath)
                                    throws ParseException

Throws:

ParseException

containsMultipleNode

public final ExpNode containsMultipleNode(AbstractDMLQuery query,
 ColumnNode columnNode1,
 String columnPath)
                                   throws ParseException

Throws:

ParseException

containsSingleNode

public final ExpNode containsSingleNode(AbstractDMLQuery query,
 ColumnNode columnNode1,
 String column)
                                 throws ParseException

Throws:

ParseException

valueNode

public final ValueNode valueNode(AbstractDMLQuery query)
                          throws ParseException

Throws:

ParseException

inExprOrList

public final ExpNode inExprOrList(AbstractDMLQuery query,
 boolean isNot)
                           throws ParseException

Throws:

ParseException

parseInValue

public final LiteralNode parseInValue(AbstractDMLQuery query)
                               throws ParseException

Throws:

ParseException

inValueList

public final HashSet<LiteralNode> inValueList(AbstractDMLQuery query)
                                       throws ParseException

Throws:

ParseException

getBetweenValueNode

public final ValueNode getBetweenValueNode(AbstractDMLQuery query)
                                    throws ParseException

Throws:

ParseException

ReInit

public void ReInit(InputStream stream)

Reinitialise.

ReInit

public void ReInit(InputStream stream,
 String encoding)

Reinitialise.

ReInit

public void ReInit(Reader stream)

Reinitialise.

ReInit

public void ReInit(SqlParserTokenManager tm)

Reinitialise.

getNextToken

public final Token getNextToken()

Get the next Token.

getToken

public final Token getToken(int index)

Get the specific Token.

generateParseException

public ParseException generateParseException()

Generate ParseException.

enable_tracing

public final void enable_tracing()

Enable tracing.

disable_tracing

public final void disable_tracing()

Disable tracing.