Package net.sf.jsqlparser.parser
Class CCJSqlParserUtil
- java.lang.Object
-
- net.sf.jsqlparser.parser.CCJSqlParserUtil
-
public final class CCJSqlParserUtil extends java.lang.Object
Toolfunctions to start and use JSqlParser.
-
-
Field Summary
Fields Modifier and Type Field Description static int
ALLOWED_NESTING_DEPTH
static java.util.logging.Logger
LOGGER
-
Constructor Summary
Constructors Modifier Constructor Description private
CCJSqlParserUtil()
-
Method Summary
All Methods Static Methods Concrete Methods Modifier and Type Method Description static int
getNestingDepth(java.lang.String sql)
static int
getUnbalancedPosition(java.lang.String text)
static CCJSqlParser
newParser(java.io.InputStream is)
static CCJSqlParser
newParser(java.io.InputStream is, java.lang.String encoding)
static CCJSqlParser
newParser(java.lang.String sql)
static Statement
parse(java.io.InputStream is)
static Statement
parse(java.io.InputStream is, java.lang.String encoding)
static Statement
parse(java.io.Reader statementReader)
static Statement
parse(java.lang.String sql)
static Statement
parse(java.lang.String sql, java.util.concurrent.ExecutorService executorService, java.util.function.Consumer<CCJSqlParser> consumer)
static Statement
parse(java.lang.String sql, java.util.function.Consumer<CCJSqlParser> consumer)
Parses an sql statement while allowing via consumer to configure the used parser before.static Node
parseAST(java.lang.String sql)
static Expression
parseCondExpression(java.lang.String condExpr)
Parse an conditional expression.static Expression
parseCondExpression(java.lang.String condExpr, boolean allowPartialParse)
Parse an conditional expression.static Expression
parseCondExpression(java.lang.String conditionalExpressionStr, boolean allowPartialParse, java.util.function.Consumer<CCJSqlParser> consumer)
static Expression
parseExpression(java.lang.String expression)
static Expression
parseExpression(java.lang.String expression, boolean allowPartialParse)
static Expression
parseExpression(java.lang.String expressionStr, boolean allowPartialParse, java.util.function.Consumer<CCJSqlParser> consumer)
static Statement
parseStatement(CCJSqlParser parser, java.util.concurrent.ExecutorService executorService)
static Statements
parseStatements(java.lang.String sqls)
Parse a statement list.static Statements
parseStatements(java.lang.String sqls, java.util.concurrent.ExecutorService executorService, java.util.function.Consumer<CCJSqlParser> consumer)
Parse a statement list.static Statements
parseStatements(java.lang.String sqls, java.util.function.Consumer<CCJSqlParser> consumer)
static Statements
parseStatements(CCJSqlParser parser, java.util.concurrent.ExecutorService executorService)
static void
streamStatements(StatementListener listener, java.io.InputStream is, java.lang.String encoding)
-
-
-
Field Detail
-
LOGGER
public static final java.util.logging.Logger LOGGER
-
ALLOWED_NESTING_DEPTH
public static final int ALLOWED_NESTING_DEPTH
- See Also:
- Constant Field Values
-
-
Method Detail
-
parse
public static Statement parse(java.io.Reader statementReader) throws JSQLParserException
- Throws:
JSQLParserException
-
parse
public static Statement parse(java.lang.String sql) throws JSQLParserException
- Throws:
JSQLParserException
-
parse
public static Statement parse(java.lang.String sql, java.util.function.Consumer<CCJSqlParser> consumer) throws JSQLParserException
Parses an sql statement while allowing via consumer to configure the used parser before. For instance to activate SQLServer bracket quotation on could use:CCJSqlParserUtil.parse("select * from [mytable]", parser -> parser.withSquareBracketQuotation(true));
- Parameters:
sql
-consumer
-- Returns:
- Throws:
JSQLParserException
-
parse
public static Statement parse(java.lang.String sql, java.util.concurrent.ExecutorService executorService, java.util.function.Consumer<CCJSqlParser> consumer) throws JSQLParserException
- Throws:
JSQLParserException
-
newParser
public static CCJSqlParser newParser(java.lang.String sql)
-
newParser
public static CCJSqlParser newParser(java.io.InputStream is) throws java.io.IOException
- Throws:
java.io.IOException
-
newParser
public static CCJSqlParser newParser(java.io.InputStream is, java.lang.String encoding) throws java.io.IOException
- Throws:
java.io.IOException
-
parseAST
public static Node parseAST(java.lang.String sql) throws JSQLParserException
- Throws:
JSQLParserException
-
parse
public static Statement parse(java.io.InputStream is) throws JSQLParserException
- Throws:
JSQLParserException
-
parse
public static Statement parse(java.io.InputStream is, java.lang.String encoding) throws JSQLParserException
- Throws:
JSQLParserException
-
parseExpression
public static Expression parseExpression(java.lang.String expression) throws JSQLParserException
- Throws:
JSQLParserException
-
parseExpression
public static Expression parseExpression(java.lang.String expression, boolean allowPartialParse) throws JSQLParserException
- Throws:
JSQLParserException
-
parseExpression
public static Expression parseExpression(java.lang.String expressionStr, boolean allowPartialParse, java.util.function.Consumer<CCJSqlParser> consumer) throws JSQLParserException
- Throws:
JSQLParserException
-
parseCondExpression
public static Expression parseCondExpression(java.lang.String condExpr) throws JSQLParserException
Parse an conditional expression. This is the expression after a where clause. Partial parsing is enabled.- Parameters:
condExpr
-- Returns:
- the expression parsed
- Throws:
JSQLParserException
- See Also:
parseCondExpression(String, boolean)
-
parseCondExpression
public static Expression parseCondExpression(java.lang.String condExpr, boolean allowPartialParse) throws JSQLParserException
Parse an conditional expression. This is the expression after a where clause.- Parameters:
condExpr
-allowPartialParse
- false: needs the whole string to be processed.- Returns:
- the expression parsed
- Throws:
JSQLParserException
- See Also:
parseCondExpression(String)
-
parseCondExpression
public static Expression parseCondExpression(java.lang.String conditionalExpressionStr, boolean allowPartialParse, java.util.function.Consumer<CCJSqlParser> consumer) throws JSQLParserException
- Throws:
JSQLParserException
-
parseStatement
public static Statement parseStatement(CCJSqlParser parser, java.util.concurrent.ExecutorService executorService) throws JSQLParserException
- Parameters:
parser
- the Parser armed with a Statement textexecutorService
- the Executor Service for parsing within a Thread- Returns:
- the parsed Statement
- Throws:
JSQLParserException
- when either the Statement can't be parsed or the configured timeout is reached
-
parseStatements
public static Statements parseStatements(java.lang.String sqls) throws JSQLParserException
Parse a statement list.- Returns:
- the statements parsed
- Throws:
JSQLParserException
-
parseStatements
public static Statements parseStatements(java.lang.String sqls, java.util.function.Consumer<CCJSqlParser> consumer) throws JSQLParserException
- Throws:
JSQLParserException
-
parseStatements
public static Statements parseStatements(java.lang.String sqls, java.util.concurrent.ExecutorService executorService, java.util.function.Consumer<CCJSqlParser> consumer) throws JSQLParserException
Parse a statement list.- Returns:
- the statements parsed
- Throws:
JSQLParserException
-
parseStatements
public static Statements parseStatements(CCJSqlParser parser, java.util.concurrent.ExecutorService executorService) throws JSQLParserException
- Parameters:
parser
- the Parser armed with a Statement textexecutorService
- the Executor Service for parsing within a Thread- Returns:
- the Statements (representing a List of single statements)
- Throws:
JSQLParserException
- when either the Statement can't be parsed or the configured timeout is reached
-
streamStatements
public static void streamStatements(StatementListener listener, java.io.InputStream is, java.lang.String encoding) throws JSQLParserException
- Throws:
JSQLParserException
-
getNestingDepth
public static int getNestingDepth(java.lang.String sql)
-
getUnbalancedPosition
public static int getUnbalancedPosition(java.lang.String text)
-
-