Package com.github.mjeanroy.dbunit.core.sql

Class SqlScriptParser

java.lang.Object

com.github.mjeanroy.dbunit.core.sql.SqlScriptParser

public final class SqlScriptParser
extends Object

Run SQL scripts against SQL Connection.

Method Summary

Modifier and Type	Method	Description
static void	executeQueries(Connection connection, List<String> queries)
static void	executeScript(Connection connection, Resource sqlFile, SqlScriptParserConfiguration configuration)	Parse SQL scripts file and execute queries one by one (if a query failed, next queries are not executed).
static void	executeScript(Connection connection, InputStream stream, SqlScriptParserConfiguration configuration)	Parse SQL scripts and execute queries one by one (if a query failed, next queries are not executed).
static void	executeScript(Connection connection, String sqlFilePath, SqlScriptParserConfiguration configuration)	Parse SQL scripts file and execute queries one by one (if a query failed, next queries are not executed).
static List<String>	parseScript(Resource sqlFile, SqlScriptParserConfiguration configuration)	Parse SQL scripts file and return list of SQL query.
static List<String>	parseScript(InputStream stream, SqlScriptParserConfiguration configuration)	Parse SQL scripts and return list of SQL query.
static List<String>	parseScript(String path, SqlScriptParserConfiguration configuration)	Parse SQL scripts and return list of SQL query.

Methods inherited from class java.lang.Object

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

Method Details

parseScript

public static List<String> parseScript(InputStream stream,
 SqlScriptParserConfiguration configuration)

Parse SQL scripts and return list of SQL query.

Parameters:

stream - Stream input.

configuration - Parsing configuration.

Returns:

List of query parsed in given input.

Throws:

SqlParserException - If an error occurred during parsing.

parseScript

public static List<String> parseScript(String path,
 SqlScriptParserConfiguration configuration)

Parse SQL scripts and return list of SQL query.

Parameters:

path - SQL file path.

configuration - Parsing configuration.

Returns:

List of query parsed in given input.

Throws:

SqlParserException - If an error occurred during parsing.

parseScript

public static List<String> parseScript(Resource sqlFile,
 SqlScriptParserConfiguration configuration)

Parse SQL scripts file and return list of SQL query.

Parameters:

sqlFile - SQL File.

configuration - Parsing configuration.

Returns:

List of query parsed in given input.

Throws:

SqlParserException - If an error occurred during parsing.

executeScript

public static void executeScript(Connection connection,
 InputStream stream,
 SqlScriptParserConfiguration configuration)
                          throws SQLException

Parse SQL scripts and execute queries one by one (if a query failed, next queries are not executed).

Parameters:

connection - SQL Connection.

stream - Stream of SQL Script.

configuration - SQL parser configuration.

Throws:

SQLException - If a query failed.

executeScript

public static void executeScript(Connection connection,
 Resource sqlFile,
 SqlScriptParserConfiguration configuration)
                          throws SQLException

Parse SQL scripts file and execute queries one by one (if a query failed, next queries are not executed).

Parameters:

connection - SQL Connection.

sqlFile - SQL Script.

configuration - SQL parser configuration.

Throws:

SQLException - If a query failed.

executeScript

public static void executeScript(Connection connection,
 String sqlFilePath,
 SqlScriptParserConfiguration configuration)
                          throws SQLException

Parse SQL scripts file and execute queries one by one (if a query failed, next queries are not executed).

Parameters:

connection - SQL connection.

sqlFilePath - SQL scripts path.

configuration - SQL parser configuration.

Throws:

SQLException - If a query failed.

executeQueries

public static void executeQueries(Connection connection,
 List<String> queries)
                           throws SQLException

Throws:

SQLException