KaneAI - World’s First E2E Software Testing Agent.Signup for Private Beta 
How to use setExecutingInitSql method of org.evomaster.client.java.controller.internal.SutController class
Best EvoMaster code snippet using org.evomaster.client.java.controller.internal.SutController.setExecutingInitSql
Source:EMController.java 
...527 even if SqlScriptRunner.execCommand is not instrumented,528 it can refer to a proxy, and the proxy itself is likely529 going to be instrumented (as not in org.evomaster)530 */531 sutController.setExecutingInitSql(true);532 // collect info about tables to insert533 noKillSwitch(()-> sutController.addTableToInserted(dto.insertions.stream().map(x-> x.targetTable).collect(Collectors.toList())));534 SimpleLogger.debug("Received database command");535 Connection connection = noKillSwitch(() -> sutController.getConnectionIfExist());536 if (connection == null) {537 String msg = "No active database connection";538 SimpleLogger.warn(msg);539 return Response.status(400).entity(WrappedResponseDto.withError(msg)).build();540 }541 if (dto.command == null && (dto.insertions == null || dto.insertions.isEmpty())) {542 String msg = "No input command";543 SimpleLogger.warn(msg);544 return Response.status(400).entity(WrappedResponseDto.withError(msg)).build();545 }546 if (dto.command != null && dto.insertions != null && !dto.insertions.isEmpty()) {547 String msg = "Only 1 command can be specified";548 SimpleLogger.warn(msg);549 return Response.status(400).entity(WrappedResponseDto.withError(msg)).build();550 }551 if (dto.insertions != null) {552 if (dto.insertions.stream().anyMatch(i -> i.targetTable == null || i.targetTable.isEmpty())) {553 String msg = "Insertion with no target table";554 SimpleLogger.warn(msg);555 return Response.status(400).entity(WrappedResponseDto.withError(msg)).build();556 }557 }558 QueryResult queryResult = null;559 InsertionResultsDto insertionResultsDto = null;560 try {561 if (dto.command != null) {562 queryResult = SqlScriptRunner.execCommand(connection, dto.command);563 } else {564 insertionResultsDto = SqlScriptRunner.execInsert(connection, dto.insertions);565 }566 } catch (Exception e) {567 String msg = "Failed to execute database command: " + e.getMessage();568 SimpleLogger.warn(msg);569 return Response.status(400).entity(WrappedResponseDto.withError(msg)).build();570 }571 if (queryResult != null) {572 return Response.status(200).entity(WrappedResponseDto.withData(queryResult.toDto())).build();573 } else if (insertionResultsDto != null) {574 return Response.status(200).entity(WrappedResponseDto.withData(insertionResultsDto)).build();575 } else {576 return Response.status(204).entity(WrappedResponseDto.withNoData()).build();577 }578 } catch (RuntimeException e) {579 /*580 FIXME: ideally, would not need to do a try/catch on each single endpoint,581 as could configure Jetty/Jackson to log all errors.582 But even after spending hours googling it, haven't managed to configure it583 */584 String msg = "Thrown exception: " + e.getMessage();585 SimpleLogger.error(msg, e);586 return Response.status(500).entity(WrappedResponseDto.withError(msg)).build();587 } finally {588 sutController.setExecutingInitSql(false);589 }590 }591}...
Source:EmbeddedSutController.java
...61 public final void setKillSwitch(boolean b) {62 ExecutionTracer.setKillSwitch(b);63 }64 @Override65 public final void setExecutingInitSql(boolean executingInitSql) {66 ExecutionTracer.setExecutingInitSql(executingInitSql);67 }68 @Override69 public final void setExecutingAction(boolean executingAction){70 ExecutionTracer.setExecutingAction(executingAction);71 }72 @Override73 public BootTimeInfoDto getBootTimeInfoDto() {74 return getBootTimeInfoDto(InstrumentationController.getBootTimeObjectiveInfo());75 }76 @Override77 public final String getExecutableFullPath(){78 return null; //not needed for embedded79 }80}...
setExecutingInitSql
Using AI Code Generation
1import org.evomaster.client.java.controller.api.dto.database.operations.DatabaseCommandDto;2import org.evomaster.client.java.controller.api.dto.database.operations.SqlScriptDto;3import org.evomaster.client.java.controller.internal.SutController;4import org.evomaster.client.java.controller.internal.db.SqlScriptExecutor;5import org.evomaster.client.java.controller.internal.db.SqlScriptRunner;6import org.evomaster.client.java.controller.internal.db.schema.SqlScript;7import org.evomaster.client.java.controller.internal.db.schema.SqlScriptResult;8import java.sql.Connection;9import java.sql.SQLException;10import java.util.ArrayList;11import java.util.List;12public class SqlScriptExecutorImpl implements SqlScriptExecutor {13 private final Connection connection;14 public SqlScriptExecutorImpl(Connection connection) {15 this.connection = connection;16 }17 public SqlScriptResult execute(SqlScript script) throws SQLException {18 SqlScriptRunner runner = new SqlScriptRunner(connection);19 return runner.execute(script);20 }21 public List<SqlScriptResult> execute(List<SqlScript> scripts) throws SQLException {22 SqlScriptRunner runner = new SqlScriptRunner(connection);23 return runner.execute(scripts);24 }25 public List<SqlScriptResult> execute(List<SqlScript> scripts, List<SqlScript> initScripts) throws SQLException {26 SqlScriptRunner runner = new SqlScriptRunner(connection);27 return runner.execute(scripts, initScripts);28 }29 public SqlScriptResult execute(DatabaseCommandDto dto) throws SQLException {30 SqlScript script = new SqlScriptDto(dto).toSqlScript();31 return execute(script);32 }33 public List<SqlScriptResult> execute(List<DatabaseCommandDto> dtos) throws SQLException {34 List<SqlScript> scripts = new ArrayList<>();35 for (DatabaseCommandDto dto : dtos) {36 scripts.add(new SqlScriptDto(dto).toSqlScript());37 }38 return execute(scripts);39 }40 public List<SqlScriptResult> execute(List<DatabaseCommandDto> dtos, List<DatabaseCommandDto> initDtos) throws SQLException {41 List<SqlScript> scripts = new ArrayList<>();42 for (DatabaseCommandDto dto : dtos) {43 scripts.add(new SqlScriptDto(dto).toSqlScript());44 }45 List<SqlScript> initScripts = new ArrayList<>();46 for (DatabaseCommandDto dto : init
setExecutingInitSql
Using AI Code Generation
1package org.evomaster.client.java.controller.internal;2import org.evomaster.client.java.controller.api.dto.database.operations.DatabaseCommandDto;3import org.evomaster.client.java.controller.api.dto.database.operations.InsertionDto;4import org.evomaster.client.java.controller.api.dto.database.operations.SqlScriptDto;5import org.evomaster.client.java.controller.api.dto.database.schema.DbSchemaDto;6import org.evomaster.client.java.controller.api.dto.database.schema.TableDto;7import org.evomaster.client.java.controller.api.dto.database.schema.TableIndexDto;8import org.evomaster.client.java.controller.api.dto.database.schema.TableIndexType;9import org.evomaster.client.java.controller.api.dto.database.schema.TableType;10import org.evomaster.client.java.controller.api.dto.database.schema.ViewDto;11import org.evomaster.client.java.controller.api.dto.database.operations.InsertionDto;12import org.evomaster.client.java.controller.api.dto.database.schema.ColumnDto;13import org.evomaster.client.java.controller.api.dto.database.operations.SqlScriptDto;14import org.evomaster.client.java.controller.api.dto.database.operations.SqlScriptType;15import org.evomaster.client.java.controller.api.dto.database.operations.DatabaseCommandDto;16import org.evomaster.client.java.controller.api.dto.database.schema.ColumnDto;17import org.evomaster.client.java.controller.api.dto.database.schema.DbSchemaDto;18import org.evomaster.client.java.controller.api.dto.database.schema.TableDto;19import org.evomaster.client.java.controller.api.dto.database.schema.TableIndexDto;20import org.evomaster.client.java.controller.api.dto.database.schema.TableIndexType;21import org.evomaster.client.java.controller.api.dto.database.schema.TableType;22import org.evomaster.client.java.controller.api.dto.database.schema.ViewDto;23import org.evomaster.client.java.controller.internal.SutController;24import org.evomaster.client.java.controller.problem.ProblemInfo;25import org.evomaster.client.java.controller.problem.RestProblem;26import org.evomaster.client.java.controller.problem.graphql.GraphQLProblem;27import org.evomaster.client.java.controller.problem.graphql.GraphQLTestCase;28import org.evomaster.client.java.controller.problem.graphql.GraphQLTestTemplate;29import org.evomaster.client.java.controller.problem.rest.*;30import org.evomaster.client.java.controller.problem.sql.SqlScriptInd;31import org.evomaster.client.java.controller.problem.sql.SqlScriptTemplate;32import org.evomaster.client.java.controller.problem.sql.SqlScriptValues;33import org.evomaster.client.java.controller.problem.sql.SqlTable;34import org.evomaster.client.java.controller.problem.sql
setExecutingInitSql
Using AI Code Generation
1package org.evomaster.examples.javaee.controller;2import org.evomaster.client.java.controller.api.EMTestUtils;3import org.evomaster.client.java.controller.api.dto.SutInfoDto;4import org.evomaster.client.java.controller.api.dto.database.operations.QueryDto;5import org.evomaster.client.java.controller.internal.SutController;6import org.evomaster.client.java.controller.internal.db.SqlScriptRunner;7import org.evomaster.client.java.controller.internal.db.SqlScriptRunnerImpl;8import org.evomaster.client.java.controller.internal.db.SqlScriptRunnerImpl2;9import org.evomaster.client.java.controller.internal.db.SqlScriptRunnerImpl3;10import org.evomaster.client.java.controller.internal.db.SqlScriptRunnerImpl4;11import org.evomaster.client.java.controller.internal.db.SqlScriptRunnerImpl5;12import org.evomaster.client.java.controller.internal.db.SqlScriptRunnerImpl6;13import org.evomaster.client.java.controller.internal.db.SqlScriptRunnerImpl7;14import org.evomaster.client.java.controller.internal.db.SqlScriptRunnerImpl8;15import org.evomaster.client.java.controller.internal.db.SqlScriptRunnerImpl9;16import org.evomaster.client.java.controller.internal.db.SqlScriptRunnerImpl10;17import org.evomaster.client.java.controller.internal.db.SqlScriptRunnerImpl11;18import org.evomaster.client.java.controller.internal.db.SqlScriptRunnerImpl12;19import org.evomaster.client.java.controller.internal.db.SqlScriptRunnerImpl13;20import org.evomaster.client.java.controller.internal.db.SqlScriptRunnerImpl14;21import org.evomaster.client.java.controller.internal.db.SqlScriptRunnerImpl15;22import org.evomaster.client.java.controller.internal.db.SqlScriptRunnerImpl16;23import org.evomaster.client.java.controller.internal.db.SqlScriptRunnerImpl17;24import org.evomaster.client.java.controller.internal.db.SqlScriptRunnerImpl18;25import org.evomaster.client.java.controller.internal.db.SqlScriptRunnerImpl19;26import org.evomaster.client.java.controller.internal.db.SqlScriptRunnerImpl20;27import org.evomaster.client.java.controller.internal.db.SqlScriptRunnerImpl21;28import org.evomaster.client.java.controller.internal.db.SqlScriptRunnerImpl22;29import org.evomaster.client.java.controller.internal.db.SqlScriptRunnerImpl23;30import org.evomaster.client.java.controller.internal.db.SqlScriptRunnerImpl24;31import org.evomaster.client.java.controller.internal.db.SqlScriptRunnerImpl25;32import org.evomaster.client.java.controller.internal.db.SqlScriptRunnerImpl26;33import org
setExecutingInitSql
Using AI Code Generation
1import org.evomaster.client.java.controller.internal.SutController;2import org.evomaster.client.java.controller.api.dto.database.operations.DatabaseCommandDto;3public class 3 {4 public static void main(String[] args) {5 SutController controller = new SutController("localhost", 40100);6 controller.resetStateOfSUT();7 String sql = "SELECT * FROM EMPLOYEE WHERE ID = 1;";8 DatabaseCommandDto dto = new DatabaseCommandDto();9 dto.setSql(sql);10 controller.setExecutingInitSql(true);11 controller.addDatabaseCommand(dto);12 controller.setExecutingInitSql(false);13 controller.getDatabaseCommands();14 controller.getDatabaseExecutionResult();15 }16}17import org.evomaster.client.java.controller.internal.SutController;18import org.evomaster.client.java.controller.api.dto.database.operations.DatabaseCommandDto;19public class 4 {20 public static void main(String[] args) {21 SutController controller = new SutController("localhost", 40100);22 controller.resetStateOfSUT();23 String sql = "SELECT * FROM EMPLOYEE WHERE ID = 1;";24 DatabaseCommandDto dto = new DatabaseCommandDto();25 dto.setSql(sql);26 controller.setExecutingInitSql(true);27 controller.addDatabaseCommand(dto);28 controller.setExecutingInitSql(false);29 controller.getDatabaseCommands();30 controller.getDatabaseExecutionResult();31 }32}33import org.evomaster.client.java.controller.internal.SutController;34import org.evomaster.client.java.controller.api.dto.database.operations.DatabaseCommandDto;35public class 5 {36 public static void main(String[] args) {37 SutController controller = new SutController("localhost", 40100);38 controller.resetStateOfSUT();39 String sql = "SELECT * FROM EMPLOYEE WHERE ID = 1;";40 DatabaseCommandDto dto = new DatabaseCommandDto();41 dto.setSql(sql);42 controller.setExecutingInitSql(true);43 controller.addDatabaseCommand(dto);44 controller.setExecutingInitSql(false);45 controller.getDatabaseCommands();46 controller.getDatabaseExecutionResult();47 }48}
setExecutingInitSql
Using AI Code Generation
1package org.evomaster.client.java.controller.api.dto.database.operations;2import org.evomaster.client.java.controller.api.dto.database.schema.DatabaseType;3import java.util.List;4public class ExecuteSqlDto extends SqlOperationDto {5 private String sql;6 private List<SqlRowDto> values;7 private boolean executingInitSql;8 public ExecuteSqlDto() {9 super(SqlOperationType.EXECUTE_SQL);10 }11 public ExecuteSqlDto(String sql, List<SqlRowDto> values, DatabaseType databaseType, boolean executingInitSql) {12 super(SqlOperationType.EXECUTE_SQL, databaseType);13 this.sql = sql;14 this.values = values;15 this.executingInitSql = executingInitSql;16 }17 public String getSql() {18 return sql;19 }20 public void setSql(String sql) {21 this.sql = sql;22 }23 public List<SqlRowDto> getValues() {24 return values;25 }26 public void setValues(List<SqlRowDto> values) {27 this.values = values;28 }29 public boolean isExecutingInitSql() {30 return executingInitSql;31 }32 public void setExecutingInitSql(boolean executingInitSql) {33 this.executingInitSql = executingInitSql;34 }35}36package org.evomaster.client.java.controller.api.dto.database.operations;37import org.evomaster.client.java.controller.api.dto.database.schema.DatabaseType;38import java.util.List;39public class ExecuteSqlDto extends SqlOperationDto {40 private String sql;41 private List<SqlRowDto> values;42 private boolean executingInitSql;43 public ExecuteSqlDto() {44 super(SqlOperationType.EXECUTE_SQL);45 }46 public ExecuteSqlDto(String sql, List<SqlRowDto> values, DatabaseType databaseType, boolean executingInitSql) {47 super(SqlOperationType.EXECUTE_SQL, databaseType);48 this.sql = sql;49 this.values = values;50 this.executingInitSql = executingInitSql;51 }52 public String getSql() {53 return sql;54 }55 public void setSql(String sql) {56 this.sql = sql;57 }58 public List<SqlRowDto> getValues() {
setExecutingInitSql
Using AI Code Generation
1package org.evomaster.client.java.controller.internal;2import com.foo.rest.examples.spring.dbinit.DbInitController;3import com.foo.rest.examples.spring.dbinit.DbInitEMTest;4import com.foo.rest.examples.spring.dbinit.Person;5import org.evomaster.client.java.controller.api.dto.database.operations.DatabaseCommandDto;6import org.evomaster.client.java.controller.api.dto.database.operations.InsertionDto;7import org.evomaster.client.java.controller.api.dto.database.operations.SqlScriptDto;8import org.evomaster.client.java.controller.api.dto.database.schema.DbSchemaDto;9import org.evomaster.client.java.controller.api.dto.database.schema.TableDto;10import org.junit.jupiter.api.AfterAll;11import org.junit.jupiter.api.BeforeAll;12import org.junit.jupiter.api.Test;13import java.util.Arrays;14import java.util.Collections;15import java.util.List;16import static org.junit.jupiter.api.Assertions.assertEquals;17import static org.junit.jupiter.api.Assertions.assertTrue;18public class SutControllerTest {19 private static DbInitEMTest test;20 private static SutController controller;21 public static void initClass() throws Exception {22 test = new DbInitEMTest();23 test.initClass();24 controller = test.getController();25 }26 public static void tearDown() {27 test.tearDown();28 }29 public void testSetExecutingInitSql() throws Exception {30 DbInitController controller = test.getController().getSutController();31 List<DatabaseCommandDto> commands = Arrays.asList(32 new InsertionDto("person", Collections.singletonList(new Person(1, "foo", "bar"))),33 new SqlScriptDto("DELETE FROM person")34 );35 controller.setExecutingInitSql(true);36 controller.resetStateOfSUT();37 controller.initializeDatabaseState(commands);38 assertEquals(0, controller.getNumberOfRows("person"), "The table should be empty");39 controller.setExecutingInitSql(false);40 controller.resetStateOfSUT();41 controller.initializeDatabaseState(commands);42 assertEquals(1, controller.getNumberOfRows("person"), "The table should have 1 row");43 }44 public void testResetStateOfSUT() throws Exception {45 DbInitController controller = test.getController().getSutController();46 List<DatabaseCommandDto> commands = Arrays.asList(47 new InsertionDto("person", Collections.singletonList(new Person(1, "foo", "bar"))),48 new SqlScriptDto("
setExecutingInitSql
Using AI Code Generation
1package org.evomaster.client.java.controller.api.dto;2import java.util.List;3public class DatabaseExecutionDto {4 public boolean isExecutingInitSql() {5 return executingInitSql;6 }7 public void setExecutingInitSql(boolean executingInitSql) {8 this.executingInitSql = executingInitSql;9 }10 private boolean executingInitSql;11}12package org.evomaster.client.java.controller.internal;13import org.evomaster.client.java.controller.api.dto.DatabaseExecutionDto;14public class SutController {15 public void setExecutingInitSql(boolean executingInitSql) {16 this.executingInitSql = executingInitSql;17 }18 private boolean executingInitSql;19}20package org.evomaster.client.java.controller.internal;21import org.evomaster.client.java.controller.api.dto.DatabaseExecutionDto;22public class SutHandler {23 public void setExecutingInitSql(boolean executingInitSql) {24 sutController.setExecutingInitSql(executingInitSql);25 }26 private SutController sutController;27}28package org.evomaster.client.java.controller.internal;29import org.evomaster.client.java.controller.api.dto.DatabaseExecutionDto;30public class SutHandlerFactory {31 public void setExecutingInitSql(boolean executingInitSql) {32 sutHandler.setExecutingInitSql(executingInitSql);33 }34 private SutHandler sutHandler;35}36package org.evomaster.client.java.controller;37import org.evomaster.client.java.controller.api.dto.DatabaseExecutionDto;38import org.evomaster.client.java.controller.internal.SutHandlerFactory;39public class EMConfig {40 public void setExecutingInitSql(boolean executingInitSql) {41 sutHandlerFactory.setExecutingInitSql(executingInitSql);42 }43 private SutHandlerFactory sutHandlerFactory;44}
setExecutingInitSql
Using AI Code Generation
1package org.evomaster.client.java.controller.internal;2import org.evomaster.client.java.controller.api.dto.database.operations.DatabaseExecutionDto;3import org.evomaster.client.java.controller.api.dto.database.operations.SqlScriptDto;4import java.sql.SQLException;5import java.util.ArrayList;6import java.util.List;7public class SutController {8 private static SutController instance = null;9 private final SutHandler handler;10 private final List<DatabaseExecutionDto> executedSql = new ArrayList<>();11 private boolean executingInitSql = false;12 public static SutController getInstance() {13 if (instance == null) {14 instance = new SutController();15 }16 return instance;17 }18 private SutController() {19 handler = new SutHandler();20 }21 public void resetStateOfSUT() {22 executedSql.clear();23 handler.resetStateOfSUT();24 }25 public void setExecutingInitSql(boolean initSql) {26 executingInitSql = initSql;27 }28 public void addExecutedSql(String sql, String name, List<String> parameters, List<String> values) {29 executedSql.add(new DatabaseExecutionDto(30 new SqlScriptDto(sql, name, parameters, values)31 ));32 }33 public void addExecutedSql(String sql, String name, List<String> parameters, List<String> values, String result) {34 executedSql.add(new DatabaseExecutionDto(35 new SqlScriptDto(sql, name, parameters, values),36 ));37 }38 public List<DatabaseExecutionDto> getExecutedSql() {39 return executedSql;40 }41 public void killSut() {42 try {43 handler.killSut();44 } catch (Exception e) {45 throw new RuntimeException(e);46 }47 }48 public void startSut() {49 try {50 handler.startSut();51 } catch (Exception e) {
Automation Testing Tutorials
Learn to execute automation testing from scratch with LambdaTest Learning Hub. Right from setting up the prerequisites to run your first automation test, to following best practices and diving deeper into advanced test scenarios. LambdaTest Learning Hubs compile a list of step-by-step guides to help you be proficient with different test automation frameworks i.e. Selenium, Cypress, TestNG etc.
LambdaTest Learning Hubs:
- JUnit Tutorial
- TestNG Tutorial
- Webdriver Tutorial
- WebDriverIO Tutorial
- Protractor Tutorial
- Selenium 4 Tutorial
- Jenkins Tutorial
- NUnit Tutorial
- Jest Tutorial
- Playwright Tutorial
- Cypress Tutorial
- PyTest Tutorial
YouTube
You could also refer to video tutorials over LambdaTest YouTube channel to get step by step demonstration from industry experts.
Run EvoMaster automation tests on LambdaTest cloud grid
Perform automation testing on 3000+ real desktop and mobile devices online.
Most used method in SutController
- SqlHandler
- startTheControllerServer
- stopTheControllerServer
- getControllerServerPort
- getControllerPort
- setControllerPort
- getControllerHost
- setControllerHost
- execInsertionsIntoDatabase
- getActionIndex
- handleSql
- enableComputeSqlHeuristicsOrExtractExecution
- initSqlHandler
- getConnectionIfExist
- doEmploySmartDbClean
- resetExtraHeuristics
- getExtraHeuristics
- computeExtraHeuristics
- cleanAccessedTables
- handleInitSql
- addTableToInserted
- getTableToClean
- findInCollectionIgnoreCase
- findInMapIgnoreCase
- initSqlScriptAndGetInsertMap
- getSqlDatabaseSchema
- getRPCSchema
- getLocalAuthSetupSchemaMap
- extractRPCSchema
- handleSeededTests
- verifySqlConnection
- newSearch
- postSearchAction
- newTest
- newAction
- executeHandleLocalAuthenticationSetup
- executeAction
- executeRPCEndpoint
- executeRPCEndpointCatchTargetException
- getEndpointSchema
- getRPCType
- newTestSpecificHandler
- newActionSpecificHandler
- isInstrumentationActivated
- isSutRunning
- getPackagePrefixesToCover
- getInfoForAuthentication
- getConnection
- getDatabaseDriverName
- getTargetInfos
- getAdditionalInfoList
- getProblemInfo
- getPreferredOutputFormat
- getUnitsInfoDto
- setKillSwitch
- setExecutingInitSql
- setExecutingAction
- getBootTimeInfoDto
- getExecutableFullPath
- getRPCClient
- categorizeBasedOnResponse
- getCustomizedValueInRequests
- specifyCustomizedNotNullAnnotation
- seedRPCTests
- customizeRPCTestOutput
- customizeMockingRPCExternalService
- resetDatabase
Try LambdaTest Now !!
Get 100 minutes of automation test minutes FREE!!
Was this article helpful?
