org.evomaster.client.java.controller.db

Class SqlScriptRunner

java.lang.Object

org.evomaster.client.java.controller.db.SqlScriptRunner

public class SqlScriptRunner
extends Object

Class used to execute SQL commands from a script file

Field Summary

Fields

Modifier and Type	Field and Description
static Pattern	delimP regex to detect delimiter.

Constructor Summary

Constructors

Constructor and Description
SqlScriptRunner() Default constructor

Method Summary

Modifier and Type	Method and Description
static QueryResult	execCommand(Connection conn, String command)
static Map<Long,Long>	execInsert(Connection conn, List<InsertionDto> insertions) Execute the different SQL insertions.
static Long	execInsert(Connection conn, String command)
List<String>	readCommands(Reader reader)
static void	runCommands(Connection connection, List<String> commands)
static void	runScript(Connection connection, Reader reader) Runs an SQL script (read in using the Reader parameter)
static void	runScriptFromResourceFile(Connection connection, String resourcePath)
void	setDelimiter(String delimiter, boolean fullLineDelimiter)

Methods inherited from class java.lang.Object

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

Field Detail

delimP

public static final Pattern delimP

regex to detect delimiter. ignores spaces, allows delimiter in comment, allows an equals-sign

Constructor Detail

SqlScriptRunner

public SqlScriptRunner()

Default constructor

Method Detail

setDelimiter

public void setDelimiter(String delimiter,
                         boolean fullLineDelimiter)

runScript

public static void runScript(Connection connection,
                             Reader reader)

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

Parameters:

reader - - the source of the script

runScriptFromResourceFile

public static void runScriptFromResourceFile(Connection connection,
                                             String resourcePath)

runCommands

public static void runCommands(Connection connection,
                               List<String> commands)

readCommands

public List<String> readCommands(Reader reader)

execInsert

public static Map<Long,Long> execInsert(Connection conn,
                                        List<InsertionDto> insertions)
                                 throws SQLException

Execute the different SQL insertions. Those can refer to each other via foreign keys, even in the case of auto-generated ids

Returns:

a map from InsertionDto id to id of auto-generated primary keys in the database (if any was generated)

Throws:

SQLException

execInsert

public static Long execInsert(Connection conn,
                              String command)
                       throws SQLException

Returns:

a single id for the new row, if any was automatically generated, null otherwise

Throws:

SQLException

execCommand

public static QueryResult execCommand(Connection conn,
                                      String command)
                               throws SQLException

Throws:

SQLException