Unlock 30% off on Manual Testing Annual Plans this Holiday Season.

Copied to Clipboard!

How to use configure method of com.consol.citrus.dsl.design.ExecuteSQLQueryTestDesignerTest class

Best Citrus code snippet using com.consol.citrus.dsl.design.ExecuteSQLQueryTestDesignerTest.configure

Source:ExecuteSQLQueryTestDesignerTest.java

...42    @Test43    public void testExecuteSQLQueryWithResource() throws IOException {44        MockTestDesigner builder = new MockTestDesigner(context) {45            @Override46            public void configure() {47                query(dataSource)48                    .sqlResource(resource)49                    .validate("COLUMN", "value")50                    .extract("COLUMN", "variable");51            }52        };53        reset(resource);54        when(resource.getFile()).thenReturn(Mockito.mock(File.class));55        when(resource.getInputStream()).thenReturn(new ByteArrayInputStream("SELECT * FROM DUAL;".getBytes()));56        builder.configure();57        TestCase test = builder.getTestCase();58        Assert.assertEquals(test.getActionCount(), 1);59        Assert.assertEquals(test.getActions().get(0).getClass(), ExecuteSQLQueryAction.class);60        ExecuteSQLQueryAction action = (ExecuteSQLQueryAction)test.getActions().get(0);61        Assert.assertEquals(action.getName(), "sql-query");62        Assert.assertEquals(action.getControlResultSet().size(), 1);63        Assert.assertEquals(action.getControlResultSet().entrySet().iterator().next().toString(), "COLUMN=[value]");64        Assert.assertEquals(action.getExtractVariables().size(), 1);65        Assert.assertEquals(action.getExtractVariables().entrySet().iterator().next().toString(), "COLUMN=variable");66        Assert.assertNull(action.getScriptValidationContext());67        Assert.assertEquals(action.getDataSource(), dataSource);68        Assert.assertEquals(action.getStatements().size(), 1);69        Assert.assertEquals(action.getStatements().get(0), "SELECT * FROM DUAL;");70        Assert.assertNull(action.getSqlResourcePath());71        Assert.assertNull(action.getValidator());72    }73    @Test74    public void testExecuteSQLQueryWithStatements() {75        MockTestDesigner builder = new MockTestDesigner(context) {76            @Override77            public void configure() {78                query(dataSource)79                    .statement("stmt1")80                    .statement("stmt2")81                    .statement("stmt3")82                    .validate("COLUMN", "value1", "value2")83                    .extract("COLUMN", "variable");84            }85        };86        builder.configure();87        TestCase test = builder.getTestCase();88        Assert.assertEquals(test.getActionCount(), 1);89        Assert.assertEquals(test.getActions().get(0).getClass(), ExecuteSQLQueryAction.class);90        ExecuteSQLQueryAction action = (ExecuteSQLQueryAction)test.getActions().get(0);91        Assert.assertEquals(action.getName(), "sql-query");92        Assert.assertEquals(action.getControlResultSet().size(), 1);93        Assert.assertEquals(action.getControlResultSet().entrySet().iterator().next().toString(), "COLUMN=[value1, value2]");94        Assert.assertEquals(action.getExtractVariables().size(), 1);95        Assert.assertEquals(action.getExtractVariables().entrySet().iterator().next().toString(), "COLUMN=variable");96        Assert.assertEquals(action.getStatements().size(), 3);97        Assert.assertEquals(action.getStatements().toString(), "[stmt1, stmt2, stmt3]");98        Assert.assertNull(action.getScriptValidationContext());99        Assert.assertEquals(action.getDataSource(), dataSource);100        Assert.assertNull(action.getValidator());101    }102    @Test103    public void testExecuteSQLQueryWithTransaction() {104        MockTestDesigner builder = new MockTestDesigner(context) {105            @Override106            public void configure() {107                query(dataSource)108                    .transactionManager(transactionManager)109                    .transactionTimeout(5000)110                    .transactionIsolationLevel("ISOLATION_READ_COMMITTED")111                    .statement("stmt1")112                    .statement("stmt2")113                    .statement("stmt3")114                    .validate("COLUMN", "value1", "value2")115                    .extract("COLUMN", "variable");116            }117        };118        builder.configure();119        TestCase test = builder.getTestCase();120        Assert.assertEquals(test.getActionCount(), 1);121        Assert.assertEquals(test.getActions().get(0).getClass(), ExecuteSQLQueryAction.class);122        ExecuteSQLQueryAction action = (ExecuteSQLQueryAction)test.getActions().get(0);123        Assert.assertEquals(action.getName(), "sql-query");124        Assert.assertEquals(action.getControlResultSet().size(), 1);125        Assert.assertEquals(action.getControlResultSet().entrySet().iterator().next().toString(), "COLUMN=[value1, value2]");126        Assert.assertEquals(action.getExtractVariables().size(), 1);127        Assert.assertEquals(action.getExtractVariables().entrySet().iterator().next().toString(), "COLUMN=variable");128        Assert.assertEquals(action.getStatements().size(), 3);129        Assert.assertEquals(action.getStatements().toString(), "[stmt1, stmt2, stmt3]");130        Assert.assertNull(action.getScriptValidationContext());131        Assert.assertEquals(action.getDataSource(), dataSource);132        Assert.assertNull(action.getValidator());133        Assert.assertEquals(action.getTransactionManager(), transactionManager);134        Assert.assertEquals(action.getTransactionTimeout(), "5000");135        Assert.assertEquals(action.getTransactionIsolationLevel(), "ISOLATION_READ_COMMITTED");136    }137    @Test138    public void testValidationScript() {139        MockTestDesigner builder = new MockTestDesigner(context) {140            @Override141            public void configure() {142                query(dataSource)143                    .statement("stmt")144                    .validateScript("assert rows[0].COLUMN == 'value1'", ScriptTypes.GROOVY);145            }146        };147        builder.configure();148        TestCase test = builder.getTestCase();149        Assert.assertEquals(test.getActionCount(), 1);150        Assert.assertEquals(test.getActions().get(0).getClass(), ExecuteSQLQueryAction.class);151        ExecuteSQLQueryAction action = (ExecuteSQLQueryAction)test.getActions().get(0);152        Assert.assertEquals(action.getName(), "sql-query");153        Assert.assertEquals(action.getControlResultSet().size(), 0);154        Assert.assertEquals(action.getExtractVariables().size(), 0);155        Assert.assertNotNull(action.getScriptValidationContext());156        Assert.assertEquals(action.getScriptValidationContext().getValidationScript(), "assert rows[0].COLUMN == 'value1'");157        Assert.assertNull(action.getScriptValidationContext().getValidationScriptResourcePath());158        Assert.assertEquals(action.getStatements().size(), 1);159        Assert.assertEquals(action.getStatements().toString(), "[stmt]");160        Assert.assertEquals(action.getDataSource(), dataSource);161    }162    @Test163    public void testValidationScriptResource() throws IOException {164        MockTestDesigner builder = new MockTestDesigner(context) {165            @Override166            public void configure() {167                query(dataSource)168                    .statement("stmt")169                    .validateScript(resource, ScriptTypes.GROOVY);170            }171        };172        reset(resource);173        when(resource.getInputStream()).thenReturn(new ByteArrayInputStream("someScript".getBytes()));174        builder.configure();175        TestCase test = builder.getTestCase();176        Assert.assertEquals(test.getActionCount(), 1);177        Assert.assertEquals(test.getActions().get(0).getClass(), ExecuteSQLQueryAction.class);178        ExecuteSQLQueryAction action = (ExecuteSQLQueryAction)test.getActions().get(0);179        Assert.assertEquals(action.getName(), "sql-query");180        Assert.assertEquals(action.getControlResultSet().size(), 0);181        Assert.assertEquals(action.getExtractVariables().size(), 0);182        Assert.assertNotNull(action.getScriptValidationContext());183        Assert.assertEquals(action.getScriptValidationContext().getValidationScript(), "someScript");184        Assert.assertNull(action.getScriptValidationContext().getValidationScriptResourcePath());185        Assert.assertEquals(action.getStatements().size(), 1);186        Assert.assertEquals(action.getStatements().toString(), "[stmt]");187        Assert.assertEquals(action.getDataSource(), dataSource);188    }189    @Test190    public void testGroovyValidationScript() {191        MockTestDesigner builder = new MockTestDesigner(context) {192            @Override193            public void configure() {194                query(dataSource)195                    .statement("stmt")196                    .groovy("assert rows[0].COLUMN == 'value1'");197            }198        };199        builder.configure();200        TestCase test = builder.getTestCase();201        Assert.assertEquals(test.getActionCount(), 1);202        Assert.assertEquals(test.getActions().get(0).getClass(), ExecuteSQLQueryAction.class);203        ExecuteSQLQueryAction action = (ExecuteSQLQueryAction)test.getActions().get(0);204        Assert.assertEquals(action.getName(), "sql-query");205        Assert.assertEquals(action.getControlResultSet().size(), 0);206        Assert.assertEquals(action.getExtractVariables().size(), 0);207        Assert.assertNotNull(action.getScriptValidationContext());208        Assert.assertEquals(action.getScriptValidationContext().getValidationScript(), "assert rows[0].COLUMN == 'value1'");209        Assert.assertNull(action.getScriptValidationContext().getValidationScriptResourcePath());210        Assert.assertEquals(action.getStatements().size(), 1);211        Assert.assertEquals(action.getStatements().toString(), "[stmt]");212        Assert.assertEquals(action.getDataSource(), dataSource);213    }214    @Test215    public void testGroovyValidationScriptResource() throws IOException {216        MockTestDesigner builder = new MockTestDesigner(context) {217            @Override218            public void configure() {219                query(dataSource)220                    .statement("stmt")221                    .groovy(resource);222            }223        };224        reset(resource);225        when(resource.getInputStream()).thenReturn(new ByteArrayInputStream("someScript".getBytes()));226        builder.configure();227        TestCase test = builder.getTestCase();228        Assert.assertEquals(test.getActionCount(), 1);229        Assert.assertEquals(test.getActions().get(0).getClass(), ExecuteSQLQueryAction.class);230        ExecuteSQLQueryAction action = (ExecuteSQLQueryAction)test.getActions().get(0);231        Assert.assertEquals(action.getName(), "sql-query");232        Assert.assertEquals(action.getControlResultSet().size(), 0);233        Assert.assertEquals(action.getExtractVariables().size(), 0);234        Assert.assertNotNull(action.getScriptValidationContext());235        Assert.assertEquals(action.getScriptValidationContext().getValidationScript(), "someScript");236        Assert.assertNull(action.getScriptValidationContext().getValidationScriptResourcePath());237        Assert.assertEquals(action.getStatements().size(), 1);238        Assert.assertEquals(action.getStatements().toString(), "[stmt]");239        Assert.assertEquals(action.getDataSource(), dataSource);240    }241    @Test242    public void testCustomScriptValidator() {243        MockTestDesigner builder = new MockTestDesigner(context) {244            @Override245            public void configure() {246                query(dataSource)247                        .statement("stmt")248                        .validateScript("assert something", ScriptTypes.GROOVY)249                        .validator(validator);250            }251        };252        builder.configure();253        TestCase test = builder.getTestCase();254        Assert.assertEquals(test.getActionCount(), 1);255        Assert.assertEquals(test.getActions().get(0).getClass(), ExecuteSQLQueryAction.class);256        ExecuteSQLQueryAction action = (ExecuteSQLQueryAction)test.getActions().get(0);257        Assert.assertEquals(action.getName(), "sql-query");258        Assert.assertEquals(action.getControlResultSet().size(), 0);259        Assert.assertEquals(action.getExtractVariables().size(), 0);260        Assert.assertNotNull(action.getScriptValidationContext());261        Assert.assertEquals(action.getScriptValidationContext().getValidationScript(), "assert something");262        Assert.assertNull(action.getScriptValidationContext().getValidationScriptResourcePath());263        Assert.assertEquals(action.getStatements().size(), 1);264        Assert.assertEquals(action.getStatements().toString(), "[stmt]");265        Assert.assertEquals(action.getDataSource(), dataSource);266        Assert.assertEquals(action.getValidator(), validator);...

configure

Using AI Code Generation

1package com.consol.citrus.dsl.design;2import com.consol.citrus.dsl.testng.TestNGCitrusTestDesigner;3import org.springframework.beans.factory.annotation.Autowired;4import org.springframework.jdbc.core.JdbcTemplate;5import org.springframework.jdbc.datasource.SingleConnectionDataSource;6import org.testng.annotations.Test;7import javax.sql.DataSource;8import java.util.List;9import java.util.Map;10import static org.testng.Assert.assertEquals;11public class ExecuteSQLQueryTestDesignerTest extends TestNGCitrusTestDesigner {12    private JdbcTemplate jdbcTemplate;13    public void testExecuteSQLQuery() {14        executeSQLQuery()15            .dataSource(new SingleConnectionD

configure

Using AI Code Generation

1package com.consol.citrus.dsl.design;2import com.consol.citrus.dsl.builder.ExecuteSQLQueryActionBuilder;3import com.consol.citrus.dsl.runner.TestRunner;4import com.consol.citrus.sql.message.*;5import com.consol.citrus.testng.AbstractTestNGUnitTest;6import org.mockito.Mockito;7import org.springframework.jdbc.core.JdbcTemplate;8import org.springframework.jdbc.datasource.SingleConnectionDataSource;9import org.testng.annotations.Test;10import javax.sql.DataSource;11import java.sql.Connection;12import java.sql.SQLException;13import java.util.*;14import static org.mockito.Mockito.*;15public class ExecuteSQLQueryTestDesignerTest extends AbstractTestNGUnitTest {16    private DataSource dataSource = Mockito.mock(DataSource.class);17    private Connection connection = Mockito.mock(Connection.class);18    private JdbcTemplate jdbcTemplate = Mockito.mock(JdbcTemplate.class);19    public void testExecuteSQLQueryBuilder() {20        reset(jdbcTemplate);21        when(dataSource.getConnection()).thenReturn(connection);22        when(jdbcTemplate.queryForList(anyString())).thenReturn(Collections.emptyList());23        MockTestRunner builder = new MockTestRunner(getClass().getSimpleName(), applicationContext, context) {24            public void execute() {25                executeSQL(builder -> builder26                        .sqlQuery("SELECT * FROM CITRUS")27                        .dataSource(dataSource)28                        .statement("SELECT * FROM CITRUS")29                        .validate("ID", "1")30                        .validate("NAME", "citrus:startsWith('CITRUS')")31                        .extract("ID", "id")32                        .extract("NAME", "name")33                        .extract("LASTNAME", "lastName")34                        .extract("EMAIL", "email"));35            }36        };37        builder.run();38        verify(jdbcTemplate).queryForList("SELECT * FROM CITRUS");39        builder.validate();40        builder.assertException();41    }42    public void testExecuteSQLQueryBuilderWithResult() {43        reset(jdbcTemplate);44        when(dataSource.getConnection()).thenReturn(connection);45        when(jdbcTemplate.queryForList(anyString())).thenReturn(Collections.singletonList(Collections.singletonMap("ID", 1)));46        MockTestRunner builder = new MockTestRunner(getClass().getSimpleName(), applicationContext, context) {47            public void execute() {48                executeSQL(builder -> builder49                        .sqlQuery("SELECT * FROM CITR

configure

Using AI Code Generation

1    public void testExecuteSQLQuery() {2        MockEndpoint mockEndpoint = getMockEndpoint("mock:result");3        mockEndpoint.expectedMessageCount(1);4        mockEndpoint.expectedMessagesMatches(new MessagePredicate() {5            public boolean apply(Message message) {6                return message.getPayload(String.class).contains("John Doe");7            }8        });9        run(new ExecuteSQLQueryTestDesignerTest() {10            protected void configure() {11                executeSQLQuery("select * from t_user where id = 1")12                        .validate("name", "John Doe");13            }14        });15        mockEndpoint.assertIsSatisfied();16    }17}

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.