com.serotonin.mango.db

Class ScriptRunner

java.lang.Object

com.serotonin.mango.db.ScriptRunner

public class ScriptRunner
extends java.lang.Object

Tool to run database scripts

Field Summary

Fields

Modifier and Type	Field and Description
private boolean	autoCommit
private java.sql.Connection	connection
private static java.lang.String	DEFAULT_DELIMITER
private java.lang.String	delimiter
private static java.lang.String	DELIMITER_LINE_REGEX
private static java.lang.String	DELIMITER_LINE_SPLIT_REGEX
private java.io.PrintWriter	errorLogWriter
private boolean	fullLineDelimiter
private java.io.PrintWriter	logWriter
private boolean	stopOnError

Constructor Summary

Constructors

Constructor and Description
ScriptRunner(java.sql.Connection connection, boolean autoCommit, boolean stopOnError) Default constructor

Method Summary

Modifier and Type	Method and Description
private void	flush()
private java.lang.String	getDelimiter()
private void	print(java.lang.Object o)
private void	println(java.lang.Object o)
private void	printlnError(java.lang.Object o)
private void	runScript(java.sql.Connection conn, java.io.Reader reader) Runs an SQL script (read in using the Reader parameter) using the connection passed in
void	runScript(java.io.Reader reader) Runs an SQL script (read in using the Reader parameter)
void	setDelimiter(java.lang.String delimiter, boolean fullLineDelimiter)
void	setErrorLogWriter(java.io.PrintWriter errorLogWriter) Setter for errorLogWriter property
void	setLogWriter(java.io.PrintWriter logWriter) Setter for logWriter property

Methods inherited from class java.lang.Object

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

Field Detail

DEFAULT_DELIMITER

private static final java.lang.String DEFAULT_DELIMITER

See Also:

Constant Field Values

connection

private java.sql.Connection connection

stopOnError

private boolean stopOnError

autoCommit

private boolean autoCommit

logWriter

private java.io.PrintWriter logWriter

errorLogWriter

private java.io.PrintWriter errorLogWriter

delimiter

private java.lang.String delimiter

fullLineDelimiter

private boolean fullLineDelimiter

DELIMITER_LINE_REGEX

private static final java.lang.String DELIMITER_LINE_REGEX

See Also:

Constant Field Values

DELIMITER_LINE_SPLIT_REGEX

private static final java.lang.String DELIMITER_LINE_SPLIT_REGEX

See Also:

Constant Field Values

Constructor Detail

ScriptRunner

public ScriptRunner(java.sql.Connection connection,
                    boolean autoCommit,
                    boolean stopOnError)

Default constructor

Method Detail

setDelimiter

public void setDelimiter(java.lang.String delimiter,
                         boolean fullLineDelimiter)

setLogWriter

public void setLogWriter(java.io.PrintWriter logWriter)

Setter for logWriter property

Parameters:

logWriter - - the new value of the logWriter property

setErrorLogWriter

public void setErrorLogWriter(java.io.PrintWriter errorLogWriter)

Setter for errorLogWriter property

Parameters:

errorLogWriter - - the new value of the errorLogWriter property

runScript

public void runScript(java.io.Reader reader)
               throws java.io.IOException,
                      java.sql.SQLException

Runs an SQL script (read in using the Reader parameter)

Parameters:

reader - - the source of the script

Throws:

java.io.IOException

java.sql.SQLException

runScript

private void runScript(java.sql.Connection conn,
                       java.io.Reader reader)
                throws java.io.IOException,
                       java.sql.SQLException

Runs an SQL script (read in using the Reader parameter) using the connection passed in

Parameters:

conn - - the connection to use for the script

reader - - the source of the script

Throws:

java.sql.SQLException - if any SQL errors occur

java.io.IOException - if there is an error reading from the Reader

getDelimiter

private java.lang.String getDelimiter()

print

private void print(java.lang.Object o)

println

private void println(java.lang.Object o)

printlnError

private void printlnError(java.lang.Object o)

flush

private void flush()