org.pentaho.di.core.database

Class SqlScriptParser

java.lang.Object

org.pentaho.di.core.database.SqlScriptParser

public class SqlScriptParser
extends Object

This class represents a splitter of SQL script into separate statements. It respects the notion of a string literal and comments, such that if a separator appears in a string literal or comment, it is treated as part of the string or comment instead of a separator.

Author:

Alexander Buloichik

Method Summary

Methods

Modifier and Type	Method and Description
static SqlScriptParser	getInstance()
String	removeComments(String script) This method removes comments from one statement.
List<String>	split(String script) This method splits script into separate statements.

Methods inherited from class java.lang.Object

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

Method Detail

getInstance

public static SqlScriptParser getInstance()

split

public List<String> split(String script)

This method splits script into separate statements.

Parameters:

script - a string representing the SQL script to parse

Returns:

the list of statements

removeComments

public String removeComments(String script)

This method removes comments from one statement.

Parameters:

script - a string representing the SQL script to parse

Returns:

script without comments