How to use ExecutePLSQLAction method of com.consol.citrus.actions.ExecutePLSQLAction class

Best Citrus code snippet using com.consol.citrus.actions.ExecutePLSQLAction.ExecutePLSQLAction

Source:ExecutePLSQLTestRunnerTest.java

...14 * limitations under the License.15 */16package com.consol.citrus.dsl.runner;17import com.consol.citrus.TestCase;18import com.consol.citrus.actions.ExecutePLSQLAction;19import com.consol.citrus.testng.AbstractTestNGUnitTest;20import org.mockito.Mockito;21import org.springframework.core.io.Resource;22import org.springframework.jdbc.core.JdbcTemplate;23import org.springframework.transaction.PlatformTransactionManager;24import org.testng.Assert;25import org.testng.annotations.Test;26import java.io.ByteArrayInputStream;27import java.io.IOException;28import static org.mockito.Mockito.*;29/**30 * @author Christoph Deppisch31 * @since 2.332 */33public class ExecutePLSQLTestRunnerTest extends AbstractTestNGUnitTest {34    private JdbcTemplate jdbcTemplate = Mockito.mock(JdbcTemplate.class);35    private PlatformTransactionManager transactionManager = Mockito.mock(PlatformTransactionManager.class);36    private Resource sqlResource = Mockito.mock(Resource.class);37    38    @Test39    public void testExecutePLSQLBuilderWithStatement() {40        reset(jdbcTemplate);41        MockTestRunner builder = new MockTestRunner(getClass().getSimpleName(), applicationContext, context) {42            @Override43            public void execute() {44                plsql(builder -> builder.jdbcTemplate(jdbcTemplate)45                        .statement("TEST_STMT_1")46                        .statement("TEST_STMT_2")47                        .statement("TEST_STMT_3"));48            }49        };50        TestCase test = builder.getTestCase();51        Assert.assertEquals(test.getActionCount(), 1);52        Assert.assertEquals(test.getActions().get(0).getClass(), ExecutePLSQLAction.class);53        Assert.assertEquals(test.getActiveAction().getClass(), ExecutePLSQLAction.class);54        ExecutePLSQLAction action = (ExecutePLSQLAction)test.getActions().get(0);55        Assert.assertEquals(action.getName(), "plsql");56        Assert.assertEquals(action.isIgnoreErrors(), false);57        Assert.assertEquals(action.getStatements().toString(), "[TEST_STMT_1, TEST_STMT_2, TEST_STMT_3]");58        Assert.assertNull(action.getScript());59        Assert.assertNull(action.getSqlResourcePath());60        Assert.assertEquals(action.getJdbcTemplate(), jdbcTemplate);61        verify(jdbcTemplate).execute("TEST_STMT_1");62        verify(jdbcTemplate).execute("TEST_STMT_2");63        verify(jdbcTemplate).execute("TEST_STMT_3");64    }65    @Test66    public void testExecutePLSQLBuilderWithTransaction() {67        reset(jdbcTemplate, transactionManager);68        MockTestRunner builder = new MockTestRunner(getClass().getSimpleName(), applicationContext, context) {69            @Override70            public void execute() {71                plsql(builder -> builder.jdbcTemplate(jdbcTemplate)72                        .transactionManager(transactionManager)73                        .transactionTimeout(5000)74                        .transactionIsolationLevel("ISOLATION_READ_COMMITTED")75                        .statement("TEST_STMT_1")76                        .statement("TEST_STMT_2")77                        .statement("TEST_STMT_3"));78            }79        };80        TestCase test = builder.getTestCase();81        Assert.assertEquals(test.getActionCount(), 1);82        Assert.assertEquals(test.getActions().get(0).getClass(), ExecutePLSQLAction.class);83        Assert.assertEquals(test.getActiveAction().getClass(), ExecutePLSQLAction.class);84        ExecutePLSQLAction action = (ExecutePLSQLAction)test.getActions().get(0);85        Assert.assertEquals(action.getName(), "plsql");86        Assert.assertEquals(action.isIgnoreErrors(), false);87        Assert.assertEquals(action.getStatements().toString(), "[TEST_STMT_1, TEST_STMT_2, TEST_STMT_3]");88        Assert.assertNull(action.getScript());89        Assert.assertNull(action.getSqlResourcePath());90        Assert.assertEquals(action.getJdbcTemplate(), jdbcTemplate);91        Assert.assertEquals(action.getTransactionManager(), transactionManager);92        Assert.assertEquals(action.getTransactionTimeout(), "5000");93        Assert.assertEquals(action.getTransactionIsolationLevel(), "ISOLATION_READ_COMMITTED");94        verify(jdbcTemplate).execute("TEST_STMT_1");95        verify(jdbcTemplate).execute("TEST_STMT_2");96        verify(jdbcTemplate).execute("TEST_STMT_3");97    }98    @Test99    public void testExecutePLSQLBuilderWithSQLResource() throws IOException {100        reset(jdbcTemplate, sqlResource);101        when(sqlResource.getInputStream()).thenReturn(new ByteArrayInputStream(("TEST_STMT_1\n" +102                "/\n" +103                "TEST_STMT_2\n" +104                "/\n" +105                "TEST_STMT_3\n" +106                "/").getBytes()));107        MockTestRunner builder = new MockTestRunner(getClass().getSimpleName(), applicationContext, context) {108            @Override109            public void execute() {110                plsql(builder -> builder.jdbcTemplate(jdbcTemplate)111                        .sqlResource(sqlResource));112            }113        };114        TestCase test = builder.getTestCase();115        Assert.assertEquals(test.getActionCount(), 1);116        Assert.assertEquals(test.getActions().get(0).getClass(), ExecutePLSQLAction.class);117        Assert.assertEquals(test.getActiveAction().getClass(), ExecutePLSQLAction.class);118        ExecutePLSQLAction action = (ExecutePLSQLAction)test.getActions().get(0);119        Assert.assertEquals(action.getName(), "plsql");120        Assert.assertEquals(action.isIgnoreErrors(), false);121        Assert.assertEquals(action.getStatements().size(), 3L);122        Assert.assertEquals(action.getStatements().toString(), "[TEST_STMT_1, TEST_STMT_2, TEST_STMT_3]");123        Assert.assertEquals(action.getScript(), ("TEST_STMT_1\n" +124                "/\n" +125                "TEST_STMT_2\n" +126                "/\n" +127                "TEST_STMT_3\n" +128                "/"));129        Assert.assertEquals(action.getJdbcTemplate(), jdbcTemplate);130        verify(jdbcTemplate).execute("TEST_STMT_1");131        verify(jdbcTemplate).execute("TEST_STMT_2");132        verify(jdbcTemplate).execute("TEST_STMT_3");133    }134    @Test135    public void testExecutePLSQLBuilderWithSQLResourcePath() throws IOException {136        reset(jdbcTemplate);137        MockTestRunner builder = new MockTestRunner(getClass().getSimpleName(), applicationContext, context) {138            @Override139            public void execute() {140                plsql(builder -> builder.jdbcTemplate(jdbcTemplate)141                        .sqlResource("classpath:com/consol/citrus/dsl/runner/plsql.sql"));142            }143        };144        TestCase test = builder.getTestCase();145        Assert.assertEquals(test.getActionCount(), 1);146        Assert.assertEquals(test.getActions().get(0).getClass(), ExecutePLSQLAction.class);147        Assert.assertEquals(test.getActiveAction().getClass(), ExecutePLSQLAction.class);148        ExecutePLSQLAction action = (ExecutePLSQLAction)test.getActions().get(0);149        Assert.assertEquals(action.getName(), "plsql");150        Assert.assertEquals(action.isIgnoreErrors(), false);151        Assert.assertEquals(action.getStatements().size(), 3L);152        Assert.assertEquals(action.getStatements().toString(), "[TEST_STMT_1, TEST_STMT_2, TEST_STMT_3]");153        Assert.assertNull(action.getScript());154        Assert.assertEquals(action.getSqlResourcePath(), "classpath:com/consol/citrus/dsl/runner/plsql.sql");155        Assert.assertEquals(action.getJdbcTemplate(), jdbcTemplate);156        verify(jdbcTemplate).execute("TEST_STMT_1");157        verify(jdbcTemplate).execute("TEST_STMT_2");158        verify(jdbcTemplate).execute("TEST_STMT_3");159    }160    @Test161    public void testExecutePLSQLBuilderWithInlineScript() {162        reset(jdbcTemplate);163        MockTestRunner builder = new MockTestRunner(getClass().getSimpleName(), applicationContext, context) {164            @Override165            public void execute() {166                plsql(builder -> builder.jdbcTemplate(jdbcTemplate)167                        .ignoreErrors(true)168                        .sqlScript(("TEST_STMT_1\n" +169                                "/\n" +170                                "TEST_STMT_2\n" +171                                "/")));172            }173        };174        TestCase test = builder.getTestCase();175        Assert.assertEquals(test.getActionCount(), 1);176        Assert.assertEquals(test.getActions().get(0).getClass(), ExecutePLSQLAction.class);177        Assert.assertEquals(test.getActiveAction().getClass(), ExecutePLSQLAction.class);178        ExecutePLSQLAction action = (ExecutePLSQLAction)test.getActions().get(0);179        Assert.assertEquals(action.getName(), "plsql");180        Assert.assertEquals(action.isIgnoreErrors(), true);181        Assert.assertEquals(action.getStatements().size(), 2L);182        Assert.assertEquals(action.getStatements().toString(), "[TEST_STMT_1, TEST_STMT_2]");183        Assert.assertNull(action.getSqlResourcePath());184        Assert.assertEquals(action.getScript(), ("TEST_STMT_1\n" +185                "/\n" +186                "TEST_STMT_2\n" +187                "/"));188        Assert.assertEquals(action.getJdbcTemplate(), jdbcTemplate);189        verify(jdbcTemplate).execute("TEST_STMT_1");190        verify(jdbcTemplate).execute("TEST_STMT_2");191    }192}...

Source:ExecutePLSQLActionTest.java

...23import static org.mockito.Mockito.*;24/**25 * @author Christoph Deppisch26 */27public class ExecutePLSQLActionTest extends AbstractTestNGUnitTest {28	29    private ExecutePLSQLAction executePLSQLAction;30    31    private JdbcTemplate jdbcTemplate = Mockito.mock(JdbcTemplate.class);32    private PlatformTransactionManager transactionManager = Mockito.mock(PlatformTransactionManager.class);33    @BeforeMethod34    public void setUp() {35        executePLSQLAction  = new ExecutePLSQLAction();36        executePLSQLAction.setJdbcTemplate(jdbcTemplate);37    }38    39	@Test40	public void testPLSQLExecutionWithInlineScript() {41	    String stmt = "DECLARE " + 42                "Zahl1 number(2);" +43                "Text varchar(20) := 'Hello World!';" +44             "BEGIN" +45                "EXECUTE IMMEDIATE \"" +46                    "select number_of_greetings into Zahl1 from Greetings where text='Hello World!';\"" +47             "END;/";48	    49	    executePLSQLAction.setScript(stmt);...

Source:Actions.java

...20import java.util.Arrays;21import com.consol.citrus.TestActionBuilder;22import com.consol.citrus.actions.CreateVariablesAction;23import com.consol.citrus.actions.EchoAction;24import com.consol.citrus.actions.ExecutePLSQLAction;25import com.consol.citrus.actions.ExecuteSQLAction;26import com.consol.citrus.actions.ExecuteSQLQueryAction;27import com.consol.citrus.actions.FailAction;28import com.consol.citrus.actions.ReceiveMessageAction;29import com.consol.citrus.actions.SendMessageAction;30import com.consol.citrus.actions.SleepAction;31import com.consol.citrus.container.FinallySequence;32import com.consol.citrus.container.Iterate;33import com.consol.citrus.container.Parallel;34import com.consol.citrus.container.RepeatOnErrorUntilTrue;35import com.consol.citrus.container.RepeatUntilTrue;36import com.consol.citrus.container.Sequence;37import com.consol.citrus.container.Timer;38import groovy.lang.GroovyRuntimeException;39import org.springframework.util.ReflectionUtils;40/**41 * Set of supported test actions that can be used in a Groovy shell script.42 * @author Christoph Deppisch43 */44public enum Actions {45    ECHO("echo", EchoAction.Builder.class),46    SLEEP("sleep", SleepAction.Builder.class),47    SQL("sql", ExecuteSQLAction.Builder.class),48    PLSQL("plsql", ExecutePLSQLAction.Builder.class),49    QUERY("query", ExecuteSQLQueryAction.Builder.class),50    CREATE_VARIABLE("createVariable", CreateVariablesAction.Builder.class),51    CREATE_VARIABLES("createVariables", CreateVariablesAction.Builder.class),52    SEND("send",SendMessageAction.Builder.class),53    RECEIVE("receive", ReceiveMessageAction.Builder.class),54    FAIL("fail", FailAction.Builder.class),55    SEQUENCE("sequence", Sequence.Builder.class),56    ITERATE("iterate", Iterate.Builder.class),57    PARALLEL("parallel", Parallel.Builder.class),58    REPEAT("repeat", RepeatUntilTrue.Builder.class),59    REPEAT_ON_ERROR("repeatOnError", RepeatOnErrorUntilTrue.Builder.class),60    TIMER("timer", Timer.Builder.class),61    DO_FINALLY("doFinally", FinallySequence.Builder.class);62    private final String id;...

ExecutePLSQLAction

Using AI Code Generation

1package com.consol.citrus;2import java.sql.Connection;3import java.sql.DriverManager;4import java.sql.SQLException;5import org.testng.annotations.Test;6import com.consol.citrus.actions.ExecutePLSQLAction;7import com.consol.citrus.exceptions.CitrusRuntimeException;8import com.consol.citrus.testng.AbstractTestNGUnitTest;9public class ExecutePLSQLActionTest extends AbstractTestNGUnitTest {10    public void testExecutePLSQLAction() throws SQLException {11        Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe", "system", "oracle");12        ExecutePLSQLAction executePLSQLAction = new ExecutePLSQLAction();13        executePLSQLAction.setConnection(con);14        executePLSQLAction.setSql("insert into test values(1,'test1')");15        executePLSQLAction.execute(context);16        executePLSQLAction.setSql("insert into test values(2,'test2')");17        executePLSQLAction.execute(context);18        executePLSQLAction.setSql("insert into test values(3,'test3')");19        executePLSQLAction.execute(context);20        executePLSQLAction.setSql("insert into test values(4,'test4')");21        executePLSQLAction.execute(context);22        executePLSQLAction.setSql("insert into test values(5,'test5')");23        executePLSQLAction.execute(context);24        executePLSQLAction.setSql("insert into test values(6,'test6')");25        executePLSQLAction.execute(context);26        executePLSQLAction.setSql("insert into test values(7,'test7')");27        executePLSQLAction.execute(context);28        executePLSQLAction.setSql("insert into test values(8,'test8')");29        executePLSQLAction.execute(context);30        executePLSQLAction.setSql("insert into test values(9,'test9')");31        executePLSQLAction.execute(context);32        executePLSQLAction.setSql("insert into test values(10,'test10')");33        executePLSQLAction.execute(context);34        executePLSQLAction.setSql("insert into test values(11,'test11')");35        executePLSQLAction.execute(context);36        executePLSQLAction.setSql("insert into test values(12,'test12')");37        executePLSQLAction.execute(context);38        executePLSQLAction.setSql("insert into test values(13,'test13')");39        executePLSQLAction.execute(context);40        executePLSQLAction.setSql("insert into test values

ExecutePLSQLAction

Using AI Code Generation

1package com.consol.citrus.dsl.testng;2import com.consol.citrus.dsl.testng.TestNGCitrusTestDesigner;3import org.testng.annotations.Test;4public class ExecutePLSQLActionJavaITest extends TestNGCitrusTestDesigner {5public void executePLSQLActionJavaITest() {6executePLSQLAction(builder -> builder7.server("myOracleDBServer")8.statement("CREATE TABLE CUSTOMERS (ID NUMBER, NAME VARCHAR2(20));")9);10}11}12package com.consol.citrus.dsl.testng;13import com.consol.citrus.dsl.testng.TestNGCitrusTestDesigner;14import org.testng.annotations.Test;15public class ExecutePLSQLActionJavaITest extends TestNGCitrusTestDesigner {16public void executePLSQLActionJavaITest() {17executePLSQLAction(builder -> builder18.server("myOracleDBServer")19.statement("CREATE TABLE CUSTOMERS (ID NUMBER, NAME VARCHAR2(20));")20);21}22}23package com.consol.citrus.dsl.testng;24import com.consol.citrus.dsl.testng.TestNGCitrusTestDesigner;25import org.testng.annotations.Test;26public class ExecutePLSQLActionJavaITest extends TestNGCitrusTestDesigner {27public void executePLSQLActionJavaITest() {28executePLSQLAction(builder -> builder29.server("myOracleDBServer")30.statement("CREATE TABLE CUSTOMERS (ID NUMBER, NAME VARCHAR2(20));")31);32}33}34package com.consol.citrus.dsl.testng;35import com.consol.citrus.dsl.testng.TestNGCitrusTestDesigner;36import org.testng.annotations.Test;37public class ExecutePLSQLActionJavaITest extends TestNGCitrusTestDesigner {38public void executePLSQLActionJavaITest() {39executePLSQLAction(builder -> builder40.server("myOracleDBServer")41.statement("CREATE TABLE CUSTOMERS (ID NUMBER, NAME VARCHAR2(20));")42);43}44}

ExecutePLSQLAction

Using AI Code Generation

1package com.consol.citrus;2import java.util.HashMap;3import java.util.Map;4import org.testng.annotations.Test;5import com.consol.citrus.annotations.CitrusTest;6import com.consol.citrus.dsl.junit.JUnit4CitrusTestDesigner;7import com.consol.citrus.dsl.testng.TestNGCitrusTestDesigner;8import com.consol.citrus.exceptions.CitrusRuntimeException;9import com.consol.citrus.testng.CitrusParameters;10import com.consol.citrus.testng.CitrusXmlTest;11public class ExecutePLSQLActionTest extends TestNGCitrusTestDesigner {12    public void ExecutePLSQLAction() {13        variable("PLSQL", "select * from employee");14        variable("DBConnection", "jdbc:oracle:thin:@localhost:1521:XE");15        variable("DBDriver", "oracle.jdbc.driver.OracleDriver");16        variable("DBUsername", "system");17        variable("DBPassword", "oracle");18        variable("DBType", "oracle");19        variable("DBDialect", "Oracle");20        variable("DBSchema", "system");21        variable("DBSchemaPassword", "oracle");22        variable("DBSchema", "system");23        variable("DBSchemaPassword", "oracle");

ExecutePLSQLAction

Using AI Code Generation

1package com.consol.citrus.dsl.design;2import java.util.HashMap;3import java.util.Map;4import org.springframework.context.ApplicationContext;5import org.testng.annotations.Test;6import com.consol.citrus.dsl.testng.TestNGCitrusTestDesigner;7import com.consol.citrus.testng.CitrusParameters;8public class ExecutePLSQLActionJavaITest extends TestNGCitrusTestDesigner {9    @CitrusParameters("param1")10    @Test(dataProvider = "citrusDataProvider")11    public void executePLSQLActionJavaITest(ApplicationContext context, String param1) {12        Map<String, Object> params = new HashMap<String, Object>();13        params.put("param1", param1);14        executePLSQLAction(context)15            .statements("CREATE TABLE test (id NUMBER(10), name VARCHAR2(100));")16            .statements("INSERT INTO test VALUES (1, 'test');")17            .statements("SELECT * FROM test;")18            .statements("DROP TABLE test;")19            .parameters(params);20    }21}22package com.consol.citrus.dsl.design;23import java.util.HashMap;24import java.util.Map;25import org.springframework.context.ApplicationContext;26import org.testng.annotations.Test;27import com.consol.citrus.dsl.testng.TestNGCitrusTestDesigner;28import com.consol.citrus.testng.CitrusParameters;29public class ExecutePLSQLActionJavaITest extends TestNGCitrusTestDesigner {30    @CitrusParameters("param1")31    @Test(dataProvider = "citrusDataProvider")32    public void executePLSQLActionJavaITest(ApplicationContext context, String param1) {33        Map<String, Object> params = new HashMap<String, Object>();34        params.put("param1", param1);35        executePLSQLAction(context)36            .statements("CREATE TABLE test (id NUMBER(10), name VARCHAR2(100));")37            .statements("INSERT INTO test VALUES (1, 'test');")38            .statements("SELECT * FROM test;")39            .statements("DROP TABLE test;")40            .parameters(params)41            .sqlResource("classpath:com/consol/citrus/dsl/design/ExecutePLSQLActionJavaITest.sql");42    }43}

ExecutePLSQLAction

Using AI Code Generation

1package com.consol.citrus.dsl.testng;2import com.consol.citrus.dsl.runner.TestRunner;3import com.consol.citrus.testng.CitrusParameters;4import org.testng.annotations.Test;5public class ExecutePLSQLActionTestNGITest {6@CitrusParameters("4.java")7public void ExecutePLSQLActionTestNGITest(TestRunner runner) {8runner.variable("var1", "value1");9runner.variable("var2", "value2");10runner.variable("var3", "value3");11runner.variable("var4", "value4");12runner.variable("var5", "value5");13runner.variable("var6", "value6");14runner.variable("var7", "value7");15runner.variable("var8", "value8");16runner.variable("var9", "value9");17runner.variable("var10", "value10");18runner.variable("var11", "value11");19runner.variable("var12", "value12");20runner.variable("var13", "value13");21runner.variable("var14", "value14");22runner.variable("var15", "value15");23runner.variable("var16", "value16");24runner.variable("var17", "value17");25runner.variable("var18", "value18");26runner.variable("var19", "value19");27runner.variable("var20", "value20");28runner.variable("var21", "value21");29runner.variable("var22", "value22");30runner.variable("var23", "value23");31runner.variable("var24", "value24");32runner.variable("var25", "value25");33runner.variable("var26", "value26");34runner.variable("var27", "value27");35runner.variable("var28", "value28");36runner.variable("var29", "value29");37runner.variable("var30", "value30");38runner.variable("var31", "value31");39runner.variable("var32", "value32");40runner.variable("var33", "value33");41runner.variable("var34", "value34");42runner.variable("var35", "value35");43runner.variable("var36", "value36");44runner.variable("var37", "value37");45runner.variable("var38", "value38");46runner.variable("var39", "value39");47runner.variable("var40", "value40");48runner.variable("var41", "value41");49runner.variable("var42", "value42");

ExecutePLSQLAction

Using AI Code Generation

1package com.consol.citrus;2import org.testng.annotations.Test;3import org.testng.annotations.BeforeTest;4import org.testng.annotations.AfterTest;5import org.springframework.context.ApplicationContext;6import org.springframework.context.support.ClassPathXmlApplicationContext;7import org.testng.annotations.Test;8import org.testng.annotations.BeforeTest;9import org.testng.annotations.AfterTest;10import org.springframework.context.ApplicationContext;11import org.springframework.context.support.ClassPathXmlApplicationContext;12import com.consol.citrus.actions.ExecutePLSQLAction;13import com.consol.citrus.exceptions.CitrusRuntimeException;14import com.consol.citrus.testng.AbstractTestNGUnitTest;15import com.consol.citrus.context.TestContext;16import com.consol.citrus.context.TestContextFactory;17import com.consol.citrus.context.TestContextFactoryBean;18import com.consol.citrus.context.TestContextImpl;19import com.consol.citrus.context.TestContextFactoryBean;20import com.consol.citrus.context.TestContextImpl;21import com.consol.citrus.exceptions.CitrusRuntimeException;22import com.consol.citrus.message.MessageType;23import com.consol.citrus.testng.AbstractTestNGUnitTest;24import com.consol.citrus.context.TestContext;25import com.consol.citrus.context.TestContextFactory;26import com.consol.citrus.context.TestContextFactoryBean;27import com.consol.citrus.context.TestContextImpl;28import com.consol.citrus.exceptions.CitrusRuntimeException;29import com.consol.citrus.message.MessageType;30import com.consol.citrus.testng.AbstractTestNGUnitTest;31import com.consol.citrus.context.TestContext;32import com.consol.citrus.context.TestContextFactory;33import com.consol.citrus.context.TestContextFactoryBean;34import com.consol.citrus.context.TestContextImpl;35import com.consol.citrus.exceptions.CitrusRuntimeException;36import com.consol.citrus.message.MessageType;37import com.consol.citrus.testng.AbstractTestNGUnitTest;38import com.consol.citrus.context.TestContext;39import com.consol.citrus.context.TestContextFactory;40import com.consol.citrus.context.TestContextFactoryBean;41import com.consol.citrus.context.TestContextImpl;42import com.consol.citrus.exceptions.CitrusRuntimeException;43import com.consol.citrus.message.MessageType;44import com.consol.citrus.testng.AbstractTestNGUnitTest;45import com.consol.citrus.context.TestContext;46import

ExecutePLSQLAction

Using AI Code Generation

1package com.consol.citrus.actions;2import java.util.HashMap;3import java.util.Map;4import org.testng.annotations.Test;5import com.consol.citrus.testng.AbstractTestNGUnitTest;6import com.consol.citrus.util.FileUtils;7import com.consol.citrus.variable.GlobalVariables;8import static com.consol.citrus.actions.ExecutePLSQLAction.Builder;9public class ExecutePLSQLActionTest extends AbstractTestNGUnitTest {10public void testExecutePLSQLActionBuilder() {11Builder builder = new Builder();12builder.statement("select * from emp");13builder.database("oracle");14builder.dataSource("jdbc:oracle:thin:@localhost:1521:xe");15builder.driver("oracle.jdbc.driver.OracleDriver");16builder.username("hr");17builder.password("hr");18builder.variables("emp_id", "emp_name");19builder.variables("emp_sal", "emp_dept");20builder.variable("emp_id", "emp_id");21builder.variable("emp_name", "emp_name");

ExecutePLSQLAction

Using AI Code Generation

1package com.consol.citrus.dsl.design;2import com.consol.citrus.dsl.design.TestDesigner;3import com.consol.citrus.dsl.design.TestDesignerBeforeTestSupport;4import com.consol.citrus.dsl.testng.TestNGCitrusTestDesigner;5import com.consol.citrus.message.MessageType;6import org.springframework.beans.factory.annotation.Autowired;7import org.testng.annotations.Test;8import javax.sql.DataSource;9public class ExecutePLSQLActionJavaITest extends TestNGCitrusTestDesigner {10    private DataSource dataSource;11    public void executePLSQLActionJavaITest() {12        variable("var1", "value1");13        variable("var2", "value2");14        parallel(15            sequential(16                executePLSQLAction(dataSource)17                    .statement("DECLARE var1 VARCHAR2(10); var2 VARCHAR2(10); BEGIN var1 := '${var1}'; var2 := '${var2}'; END;")18            sequential(19                executePLSQLAction(dataSource)20                    .statement("DECLARE var1 VARCHAR2(10); var2 VARCHAR2(10); BEGIN var1 := '${var1}'; var2 := '${var2}'; END;")21        );22    }23}24package com.consol.citrus.dsl.testng;25import com.consol.citrus.dsl.testng.TestNGCitrusTestDesigner;26import com.consol.citrus.message.MessageType;27import org.springframework.beans.factory.annotation.Autowired;28import org.testng.annotations.Test;29import javax.sql.DataSource;30public class ExecutePLSQLActionJavaITest extends TestNGCitrusTestDesigner {31    private DataSource dataSource;32    public void executePLSQLActionJavaITest() {33        variable("var1", "value1");34        variable("var2", "value2");35        parallel(36            sequential(37                executePLSQLAction(dataSource)38                    .statement("DECLARE var1 VARCHAR2(10); var2 VARCHAR2(10); BEGIN var1 := '${var1}'; var2 := '${var2}'; END;")39            sequential(40                executePLSQLAction(dataSource)41                    .statement("DECLARE var1 VARCHAR2(

ExecutePLSQLAction

Using AI Code Generation

1package com.consol.citrus.dsl.testng;2import com.consol.citrus.dsl.testng.TestNGCitrusTestDesigner;3import org.testng.annotations.Test;4public class ExecutePLSQLActionJavaIT extends TestNGCitrusTestDesigner {5    public void executePLSQLActionJavaIT() {6        variable("plsqlFile", "classpath:com/consol/citrus/dsl/testng/plsql.sql");7        executePLSQLAction()8            .statement("${plsqlFile}")9            .statement("INSERT INTO CITRUS_TEST VALUES(1, 'Citrus', 'Test')")10            .statement("SELECT * FROM CITRUS_TEST WHERE ID=1")11            .statement("UPDATE CITRUS_TEST SET NAME='Citrus' WHERE ID=1")12            .statement("DELETE FROM CITRUS_TEST WHERE ID=1");13    }14}15package com.consol.citrus.dsl.testng;16import com.consol.citrus.dsl.testng.TestNGCitrusTestDesigner;17import org.testng.annotations.Test;18public class ExecutePLSQLActionJavaIT extends TestNGCitrusTestDesigner {19    public void executePLSQLActionJavaIT() {20        variable("plsqlFile", "classpath:com/consol/citrus/dsl/testng/plsql.sql");21        executePLSQLAction()22            .statement("${plsqlFile}")23            .statement("INSERT INTO CITRUS_TEST VALUES(1, 'Citrus', 'Test')")24            .statement("SELECT * FROM CITRUS_TEST WHERE ID=1")25            .statement("UPDATE CITRUS_TEST SET NAME='Citrus' WHERE ID=1")26            .statement("DELETE FROM CITRUS_TEST WHERE ID=1");27    }28}29package com.consol.citrus.dsl.testng;30import com.consol.citrus.dsl.testng.TestNGCitrusTestDesigner;31import org.testng.annotations.Test;32public class ExecutePLSQLActionJavaIT extends TestNGCitrusTestDesigner {

ExecutePLSQLAction

Using AI Code Generation

1package com.consol.citrus.samples;2import com.consol.citrus.dsl.testng.TestNGCitrusTest;3import org.springframework.beans.factory.annotation.Autowired;4import org.springframework.core.io.ClassPathResource;5import org.springframework.jdbc.core.JdbcTemplate;6import org.testng.annotations.Test;7public class ExecutePLSQLActionIT extends TestNGCitrusTest {8    private JdbcTemplate jdbcTemplate;9    public void testExecutePLSQLAction() {10        executePLSQLAction()11            .sqlResource(new ClassPathResource("create_table.sql"))12            .dataSource(jdbcTemplate.getDataSource());13        variable("query", "select * from CITRUS_TEST");14        executePLSQLAction()15            .sqlResource(new ClassPathResource("insert_into.sql"))16            .dataSource(jdbcTemplate.getDataSource());17        executePLSQLAction()18            .sqlResource(new ClassPathResource("select_from.sql"))19            .variable("query")20            .dataSource(jdbcTemplate.getDataSource())21            .result("result");22        echo("${result}");23    }24}25package com.consol.citrus.samples;26import com.consol.citrus.dsl.testng.TestNGCitrusTest;27import org.springframework.beans.factory.annotation.Autowired;28import org.springframework.core.io.ClassPathResource;29import org.springframework.jdbc.core.JdbcTemplate;30import org.testng.annotations.Test;31public class ExecuteSQLQueryActionIT extends TestNGCitrusTest {32    private JdbcTemplate jdbcTemplate;33    public void testExecuteSQLQueryAction() {34        executeSQLQueryAction()35            .sqlResource(new ClassPathResource("create_table.sql"))36            .dataSource(jdbcTemplate.getDataSource());37        executeSQLQueryAction()38            .sqlResource(new ClassPathResource("insert_into.sql"))39            .dataSource(jdbcTemplate.getDataSource());40        executeSQLQueryAction()41            .sqlResource(new ClassPathResource("select_from.sql"))42            .dataSource(jdbcTemplate.getDataSource())43            .result("result");44        echo("${result}");45    }46}

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.