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 and 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, 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, GREATER, GREATEREQUAL, GROUP, IDENTIFIER, IN, INDEX, INSERT, INT, INTEGER, INTEGER_LITERAL, INTO, IS, JOINPLUS, LESS, LESSEQUAL, LETTER, LIKE, LOB, LONG, LONG_LITERAL, LONGVARCHAR, MAX, MIN, MINUS, NOT, NOTEQUAL, NOTEQUAL2, NULL, NULLS_FIRST, NULLS_LAST, NUMBER, NUMERIC, OPENBRACKET, OPENBRAKET, OPENPAREN, OR, ORDER, PARTITION_BY, PLUS, PRIMARY_KEY, QUESTIONMARK, REAL, RELATION, 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 and Description
SqlParser(InputStream stream) Constructor with InputStream.
SqlParser(InputStream stream, String encoding) Constructor with InputStream and supplied encoding
SqlParser(Reader stream) Constructor.
SqlParser(SqlParserTokenManager tm) Constructor with generated Token Manager.

Method Summary

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

Methods inherited from class java.lang.Object

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

Field Detail

token_source

public SqlParserTokenManager token_source

Generated Token Manager.

token

public Token token

Current token.

jj_nt

public Token jj_nt

Next token.

Constructor Detail

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 Detail

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 Query selectSql()
                      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

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

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

getSelectColumn

public final SelectColumn getSelectColumn(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.