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 QueryResult	execCommand(Connection conn, String command, boolean instrumented)
static InsertionResultsDto	execInsert(Connection conn, List<InsertionDto> insertions, InsertionResultsDto... previous) Execute the different SQL insertions.
static Long	execInsert(Connection conn, String command)
static void	execScript(Connection conn, String script) this is used for mysql which cannot execute multiple statements at one time.
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 InsertionResultsDto execInsert(Connection conn,
                                             List<InsertionDto> insertions,
                                             InsertionResultsDto... previous)
                                      throws SQLException

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

Parameters:

conn - a JDBC connection to the database

insertions - the SQL insertions to execute

previous - the results of previously executed SQL insertions

Returns:

a map from InsertionDto id to id of auto-generated primary keys in the database (if any was generated). If an InsertionDto has no id, we will not keep track of any auto-generated value for it.

Throws:

SQLException

execInsert

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

Parameters:

conn - a JDBC connection to the database

command - the SQL insertion to execute

Returns:

a single id for the new row, if any was automatically generated, null otherwise. In other words, return the value of auto-generated primary key, if any was created.

Throws:

SQLException

execScript

public static void execScript(Connection conn,
                              String script)
                       throws SQLException

this is used for mysql which cannot execute multiple statements at one time.

Parameters:

conn - a connection to db

script - represents a sql script

Throws:

SQLException - if the execution of the command fails

execCommand

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

Throws:

SQLException

execCommand

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

Throws:

SQLException