com.whitestein.lsps.stdlib.function.sqlparser

Class SqlFileLinesReader

java.lang.Object

com.whitestein.lsps.stdlib.function.sqlparser.SqlFileLinesReader

public class SqlFileLinesReader
extends Object

Sql file can be interpreted either in single line and multiline mode. Default is single line. In single line mode, each line is treated as separate sql statement. The line is read, and sent to RunSQL runner to be executed. In multiline mode, sql statements can have multiple lines and statements are separated by delimiter - usually semicolon ";". Multiline statements are excuted using Flyway parser and executer. Any line that starts with "-- MULTILINE" switches reader into multiline mode and any line that starts with "-- SINGLELINE" switches reader into singleline mode

Constructor Summary

Constructors

Constructor and Description
SqlFileLinesReader(ExecutionContext context, RunSQL runner, FlywaySqlRunner flywayRunner)

Method Summary

Modifier and Type	Method and Description
void	endCurrentSql(int lineNumber) Called when file ended, so that last statement can be executed in multiline mode.
void	processLine(String line, int lineNumber) Parse and run next input line.
protected void	runLikeSingleLine(String sql, int lineNumber)

Methods inherited from class java.lang.Object

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

Constructor Detail

SqlFileLinesReader

public SqlFileLinesReader(ExecutionContext context,
                          RunSQL runner,
                          FlywaySqlRunner flywayRunner)

Method Detail

processLine

public void processLine(String line,
                        int lineNumber)
                 throws ErrorException

Parse and run next input line.

Parameters:

line - - line to interpreted

lineNumber - - line number for error reporting

Throws:

ErrorException

endCurrentSql

public void endCurrentSql(int lineNumber)
                   throws ErrorException

Called when file ended, so that last statement can be executed in multiline mode.

Parameters:

lineNumber -

Throws:

ErrorException

runLikeSingleLine

protected void runLikeSingleLine(String sql,
                                 int lineNumber)
                          throws ErrorException

Throws:

ErrorException