How to use executeStatements method of com.consol.citrus.actions.ExecuteSQLQueryAction class

Best Citrus code snippet using com.consol.citrus.actions.ExecuteSQLQueryAction.executeStatements

Source:ExecuteSQLQueryAction.java

...76                TransactionTemplate transactionTemplate = new TransactionTemplate(getTransactionManager());77                transactionTemplate.setTimeout(Integer.valueOf(context.replaceDynamicContentInString(getTransactionTimeout())));78                transactionTemplate.setIsolationLevelName(context.replaceDynamicContentInString(getTransactionIsolationLevel()));79                transactionTemplate.execute(status -> {80                    executeStatements(allResultRows, columnValuesMap, context);81                    return null;82                });83            } else {84                executeStatements(allResultRows, columnValuesMap, context);85            }86            // perform validation87            performValidation(columnValuesMap, allResultRows, context);88            // fill the request test context variables (extract tag)89            fillContextVariables(columnValuesMap, context);90            // legacy: save all columns as variables TODO: remove in major version upgrade91            for (Entry<String, List<String>> column : columnValuesMap.entrySet()) {92                List<String> columnValues = column.getValue();93                context.setVariable(column.getKey().toUpperCase(), columnValues.get(0) == null ? NULL_VALUE : columnValues.get(0));94            }95        } catch (DataAccessException e) {96            log.error("Failed to execute SQL statement", e);97            throw new CitrusRuntimeException(e);98        }99    }100    protected void executeStatements(List<Map<String, Object>> allResultRows, Map<String, List<String>> columnValuesMap, TestContext context) {101        for (String stmt : statements) {102            validateSqlStatement(stmt);103            final String toExecute;104            if (stmt.trim().endsWith(";")) {105                toExecute = context.replaceDynamicContentInString(stmt.trim().substring(0, stmt.trim().length()-1));106            } else {107                toExecute = context.replaceDynamicContentInString(stmt.trim());108            }109            if (log.isDebugEnabled()) {110                log.debug("Executing SQL query: " + toExecute);111            }112            List<Map<String, Object>> results = getJdbcTemplate().queryForList(toExecute);113            log.info("SQL query execution successful");114            allResultRows.addAll(results);...

Source:ExecuteSQLAction.java

...48            TransactionTemplate transactionTemplate = new TransactionTemplate(getTransactionManager());49            transactionTemplate.setTimeout(Integer.valueOf(context.replaceDynamicContentInString(getTransactionTimeout())));50            transactionTemplate.setIsolationLevelName(context.replaceDynamicContentInString(getTransactionIsolationLevel()));51            transactionTemplate.execute(status -> {52                executeStatements(context);53                return null;54            });55        } else {56            executeStatements(context);57        }58    }59    /**60     * Run all SQL statements.61     * @param context62     */63    protected void executeStatements(TestContext context) {64        for (String stmt : statements)  {65            try {66                final String toExecute;67                if (stmt.trim().endsWith(";")) {68                    toExecute = context.replaceDynamicContentInString(stmt.trim().substring(0, stmt.trim().length()-1));69                } else {70                    toExecute = context.replaceDynamicContentInString(stmt.trim());71                }72                if (log.isDebugEnabled()) {73                    log.debug("Executing SQL statement: " + toExecute);74                }75                getJdbcTemplate().execute(toExecute);76                log.info("SQL statement execution successful");77            } catch (Exception e) {...

executeStatements

Using AI Code Generation

1package com.consol.citrus.dsl.testng;2import com.consol.citrus.dsl.testng.TestNGCitrusTestDesigner;3import org.springframework.beans.factory.annotation.Autowired;4import org.springframework.jdbc.core.JdbcTemplate;5import org.testng.annotations.Test;6import javax.sql.DataSource;7public class ExecuteStatementsIT extends TestNGCitrusTestDesigner {8    private DataSource dataSource;9    public void executeStatements() {10        executeSQL(dataSource)11                .statements("CREATE TABLE IF NOT EXISTS CUSTOMERS (ID INT, NAME VARCHAR(255));")12                .statements("INSERT INTO CUSTOMERS VALUES (1, 'John Doe'), (2, 'Jane Doe');")13                .statements("UPDATE CUSTOMERS SET NAME = 'John Smith' WHERE ID = 1;")14                .statements("DELETE FROM CUSTOMERS WHERE ID = 2;")15                .statements("DROP TABLE CUSTOMERS;")16                .execute();17    }18}19package com.consol.citrus.dsl.testng;20import com.consol.citrus.dsl.testng.TestNGCitrusTestDesigner;21import org.springframework.beans.factory.annotation.Autowired;22import org.springframework.jdbc.core.JdbcTemplate;23import org.testng.annotations.Test;24import javax.sql.DataSource;25public class ExecuteStatementsIT extends TestNGCitrusTestDesigner {26    private DataSource dataSource;27    public void executeStatements() {28        executeSQL(dataSource)29                .statements("CREATE TABLE IF NOT EXISTS CUSTOMERS (ID INT, NAME VARCHAR(255));")30                .statements("INSERT INTO CUSTOMERS VALUES (1, 'John Doe'), (2, 'Jane Doe');")31                .statements("UPDATE CUSTOMERS SET NAME = 'John Smith' WHERE ID = 1;")32                .statements("DELETE FROM CUSTOMERS WHERE ID = 2;")33                .statements("DROP TABLE CUSTOMERS;")34                .execute();35    }36}37package com.consol.citrus.dsl.testng;38import com.consol.citrus.dsl.testng.TestNGCitrusTestDesigner;39import org.springframework.beans.factory.annotation.Autowired;40import org.springframework.jdbc.core.JdbcTemplate;41import org.testng.annotations.Test;42import javax.sql.DataSource;43public class ExecuteStatementsIT extends TestNGCitrusTestDesigner {

executeStatements

Using AI Code Generation

1package com.consol.citrus;2import com.consol.citrus.dsl.testng.TestNGCitrusTestDesigner;3import org.springframework.beans.factory.annotation.Autowired;4import org.springframework.jdbc.core.JdbcTemplate;5import org.testng.annotations.Test;6import javax.sql.DataSource;7public class ExecuteSQLQueryActionIT extends TestNGCitrusTestDesigner {8    private DataSource dataSource;9    public void executeSQLQueryAction() {10        JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);11        execute(sql(jdbcTemplate)12                .statements("SELECT * FROM PERSON WHERE NAME = 'John Doe'")13                .validate("ID", "1")14                .validate("NAME", "John Doe")15                .validate("AGE", "25"));16    }17}18package com.consol.citrus;19import com.consol.citrus.dsl.testng.TestNGCitrusTestDesigner;20import org.springframework.beans.factory.annotation.Autowired;21import org.springframework.jdbc.core.JdbcTemplate;22import org.testng.annotations.Test;23import javax.sql.DataSource;24public class ExecuteSQLQueryActionIT extends TestNGCitrusTestDesigner {25    private DataSource dataSource;26    public void executeSQLQueryAction() {27        JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);28        execute(sql(jdbcTemplate)29                .statements("SELECT * FROM PERSON WHERE NAME = 'John Doe'")30                .validate("ID", "1")31                .validate("NAME", "John Doe")32                .validate("AGE", "25"));33    }34}35package com.consol.citrus;36import com.consol.citrus.dsl.testng.TestNGCitrusTestDesigner;37import org.springframework.beans.factory.annotation.Autowired;38import org.springframework.jdbc.core.JdbcTemplate;39import org.testng.annotations.Test;40import javax.sql.DataSource;41public class ExecuteSQLQueryActionIT extends TestNGCitrusTestDesigner {42    private DataSource dataSource;43    public void executeSQLQueryAction() {44        JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);45        execute(sql(jdbcTemplate)46                .statements("SELECT * FROM PERSON WHERE NAME = 'John Doe'")47                .validate("ID", "1")48                .validate("NAME", "John Doe")49                .validate("

executeStatements

Using AI Code Generation

1package com.consol.citrus.dsl.actions;2import com.consol.citrus.actions.ExecuteSQLQueryAction;3import com.consol.citrus.dsl.UnitTestSupport;4import com.consol.citrus.testng.TestNGCitrusSupport;5import org.springframework.jdbc.datasource.DriverManagerDataSource;6import org.testng.annotations.Test;7import javax.sql.DataSource;8public class ExecuteSQLQueryActionJavaITest extends TestNGCitrusSupport {9    public void executeSQLQueryAction() {10        DataSource dataSource = new DriverManagerDataSource("jdbc:hsqldb:mem:testdb", "sa", "");11        variable("id", "citrus:randomNumber(10)");12        variable("name", "Citrus");13        ExecuteSQLQueryAction.Builder builder = new ExecuteSQLQueryAction.Builder();14        builder.dataSource(dataSource);15        builder.statement("INSERT INTO TEST_TABLE (ID, NAME) VALUES (${id}, '${name}')");16        builder.statement("INSERT INTO TEST_TABLE (ID, NAME) VALUES (${id}, '${name}')");17        builder.statement("INSERT INTO TEST_TABLE (ID, NAME) VALUES (${id}, '${name}')");18        builder.statement("INSERT INTO TEST_TABLE (ID, NAME) VALUES (${id}, '${name}')");19        builder.statement("INSERT INTO TEST_TABLE (ID, NAME) VALUES (${id}, '${name}')");20        builder.statement("INSERT INTO TEST_TABLE (ID, NAME) VALUES (${id}, '${name}')");21        builder.statement("INSERT INTO TEST_TABLE (ID, NAME) VALUES (${id}, '${name}')");22        builder.statement("INSERT INTO TEST_TABLE (ID, NAME) VALUES (${id}, '${name}')");23        builder.statement("INSERT INTO TEST_TABLE (ID, NAME) VALUES (${id}, '${name}')");24        builder.statement("INSERT INTO TEST_TABLE (ID, NAME) VALUES (${id}, '${name}')");25        builder.statement("INSERT INTO TEST_TABLE (ID, NAME) VALUES (${id}, '${name}')");26        execute(builder.build());27    }28}

executeStatements

Using AI Code Generation

1package com.consol.citrus;2import java.sql.Connection;3import java.sql.DriverManager;4import java.sql.SQLException;5import java.util.ArrayList;6import java.util.HashMap;7import java.util.List;8import java.util.Map;9import org.springframework.jdbc.core.JdbcTemplate;10import org.springframework.jdbc.datasource.SingleConnectionDataSource;11import org.testng.annotations.BeforeClass;12import org.testng.annotations.Test;13import com.consol.citrus.actions.ExecuteSQLQueryAction;14import com.consol.citrus.exceptions.CitrusRuntimeException;15import com.consol.citrus.jdbc.message.JdbcMessageHeaders;16public class TestExecuteSQLQueryAction {17    private Connection connection;18    public void setUp() throws SQLException {19        connection = DriverManager.getConnection("jdbc:h2:mem:test", "sa", "");20    }21    public void testExecuteStatements() {22        ExecuteSQLQueryAction action = new ExecuteSQLQueryAction();23        action.setDataSource(new SingleConnectionDataSource(connection, true));24        action.setJdbcTemplate(new JdbcTemplate(new SingleConnectionDataSource(connection, true)));25        List<Map<String, Object>> rows = new ArrayList<Map<String, Object>>();26        Map<String, Object> row1 = new HashMap<String, Object>();27        row1.put("ID", 1);28        row1.put("NAME", "John");29        rows.add(row1);30        Map<String, Object> row2 = new HashMap<String, Object>();31        row2.put("ID", 2);32        row2.put("NAME", "Jane");33        rows.add(row2);34        action.setRows(rows);35        action.setSql("SELECT * FROM PERSON");36        action.execute(context);37    }38    public void testExecuteStatementsWithParameters() {39        ExecuteSQLQueryAction action = new ExecuteSQLQueryAction();40        action.setDataSource(new SingleConnectionDataSource(connection, true));41        action.setJdbcTemplate(new JdbcTemplate(new SingleConnectionDataSource(connection, true)));42        List<Map<String, Object>> rows = new ArrayList<Map<String, Object>>();43        Map<String, Object> row1 = new HashMap<String, Object>();44        row1.put("ID", 1);45        row1.put("NAME", "John");46        rows.add(row1);47        Map<String, Object> row2 = new HashMap<String, Object>();48        row2.put("ID", 2);49        row2.put("NAME", "Jane");50        rows.add(row2);51        action.setRows(rows);52        action.setSql("SELECT *

executeStatements

Using AI Code Generation

1import com.consol.citrus.actions.ExecuteSQLQueryAction;2import com.consol.citrus.dsl.runner.TestRunner;3import com.consol.citrus.dsl.builder.ExecuteSQLQueryBuilder;4import com.consol.citrus.dsl.builder.BuilderSupport;5import com.consol.citrus.dsl.builder.BuilderSupport;6import com.consol.citrus.dsl.builder.ExecuteSQLQueryBuilder;7import com.conso

executeStatements

Using AI Code Generation

1package com.consol.citrus.dsl.actions;2import java.util.ArrayList;3import java.util.List;4import org.springframework.context.ApplicationContext;5import com.consol.citrus.actions.ExecuteSQLQueryAction;6import com.consol.citrus.context.TestContext;7import com.consol.citrus.dsl.builder.BuilderSupport;8import com.consol.citrus.dsl.builder.ExecuteSQLQueryActionBuilder;9import com.consol.citrus.dsl.builder.VariableBuilderSupport;10import com.consol.citrus.dsl.runner.TestRunner;11        ExecuteSQLQueryActionBuilder<ExecuteSQLQueryAction, ExecuteSQLQueryActionBuilderSupport> {12    private final ExecuteSQLQueryAction action;13    public ExecuteSQLQueryActionBuilderSupport(TestRunner runner) {14        super(runner);15        this.action = new ExecuteSQLQueryAction();16    }17    public ExecuteSQLQueryActionBuilderSupport dataSource(String dataSource) {18        action.setDataSource(dataSource);19        return this;20    }21    public ExecuteSQLQueryActionBuilderSupport dataSource(ApplicationContext applicationContext, String dataSource) {22        action.setApplicationContext(applicationContext);23        action.setDataSource(dataSource);24        return this;25    }26    public ExecuteSQLQueryActionBuilderSupport sqlResource(String sqlResource) {27        action.setSqlResource(sqlResource);28        return this;29    }30    public ExecuteSQLQueryActionBuilderSupport sqlResource(String sqlResource, TestContext context) {31        action.setSqlResource(sqlResource);32        action.setTestContext(context);33        return this;34    }35    public ExecuteSQLQueryActionBuilderSupport sql(String sql) {36        action.setSql(sql);37        return this;38    }39    public ExecuteSQLQueryActionBuilderSupport sql(String sql, TestContext context) {40        action.setSql(sql);41        action.setTestContext(context);42        return this;43    }44    public ExecuteSQLQueryActionBuilderSupport statements(List<String> statements) {45        action.setStatements(statements);46        return this;47    }48    public ExecuteSQLQueryActionBuilderSupport statement(String statement) {49        if (action.getStatements() == null) {50            action.setStatements(new ArrayList<>());51        }52        action.getStatements().add(statement);53        return this;54    }

executeStatements

Using AI Code Generation

1package com.consol.citrus;2import org.springframework.jdbc.datasource.DriverManagerDataSource;3import org.springframework.jdbc.core.JdbcTemplate;4import org.springframework.jdbc.core.RowMapper;5import org.springframework.jdbc.datasource.DataSourceTransactionManager;6import org.springframework.transaction.support.TransactionTemplate;7import org.springframework.transaction.TransactionDefinition;8import org.springframework.transaction.TransactionStatus;9import org.springframework.transaction.support.DefaultTransactionDefinition;10import org.springframework.jdbc.datasource.DataSourceUtils;11import java.sql.Connection;12import java.sql.PreparedStatement;13import java.sql.ResultSet;14import java.sql.SQLException;15import java.util.ArrayList;16import java.util.List;17import java.util.Map;18import java.util.HashMap;19import java.util.Iterator;20import java.util.Set;21import java.util.HashSet;22import java.util.regex.Matcher;23import java.util.regex.Pattern;24import java.util.regex.PatternSyntaxException;25import java.util.Arrays;26import java.util.Properties;27import java.io.File;28import java.io.FileInputStream;29import java.io.IOException;30import java.io.InputStream;31import java.io.FileNotFoundException;32import java.io.BufferedReader;33import java.io.FileReader;34import java.io.InputStreamReader;35import java.io.UnsupportedEncodingException;36import java.io.Reader;37import java.io.StringReader;38import java.io.ByteArrayInputStream;39import java.io.ByteArrayOutputStream;40import java.io.ObjectInputStream;41import java.io.ObjectOutputStream;42import java.io.ObjectStreamClass;43import java.io.Serializable;44import java.lang.reflect.Method;45import java.lang.reflect.InvocationTargetException;46import java.lang.reflect.Field;47import java.lang.ClassNotFoundException;48import java.lang.ClassCastException;49import java.lang.reflect.Modifier;50import java.lang.reflect.Constructor;51import java.lang.reflect.Array;52import java.lang.reflect.Type;53import java.lang.reflect.TypeVariable;54import java.lang.reflect.ParameterizedType;55import java.lang.reflect.WildcardType;56import java.lang.reflect.GenericArrayType;57import java.lang.reflect.UndeclaredThrowableException;58import java.lang.reflect.Proxy;59import java.lang.reflect.InvocationHandler;60import java.lang.reflect.InvocationTargetException;61import java.lang.reflect.Field;62import java.lang.reflect.Constructor;63import java.lang.reflect.Method;64import java.lang.reflect.Modifier;65import java.lang.reflect.Type;66import java.lang.reflect.TypeVariable;67import java.lang.reflect.ParameterizedType;68import java.lang.reflect.WildcardType;69import java.lang.reflect.GenericArrayType;70import java.lang.reflect.UndeclaredThrowableException;71import java.lang.reflect.Proxy;72import java.lang.reflect.InvocationHandler;73import java.lang.reflect.InvocationTargetException;74import java.lang.reflect.Field;75import java.lang.reflect.Constructor;76import java.lang.reflect.Method;77import java.lang.reflect.Mod

executeStatements

Using AI Code Generation

1public class 4 {2    public static void main(String[] args) {3        Citrus citrus = Citrus.newInstance();4        citrus.run(new TestCase() {5            public void execute() {6                variable("sqlQuery", "select * from myTable");7                execute(new ExecuteSQLQueryAction()8                        .statements("${sqlQuery}")9                        .dataSource("${myDataSource}")10                        .validate("${sqlQuery}"));11            }12        });13    }14}15public class 5 {16    public static void main(String[] args) {17        Citrus citrus = Citrus.newInstance();18        citrus.run(new TestCase() {19            public void execute() {20                variable("sqlQuery", "select * from myTable");21                execute(new ExecuteSQLQueryAction()22                        .statements("${sqlQuery}")23                        .dataSource("${myDataSource}")24                        .validate("${sqlQuery}"));25            }26        });27    }28}29public class 6 {30    public static void main(String[] args) {31        Citrus citrus = Citrus.newInstance();32        citrus.run(new TestCase() {33            public void execute() {34                variable("sqlQuery", "select * from myTable");35                execute(new ExecuteSQLQueryAction()36                        .statements("${sqlQuery}")37                        .dataSource("${myDataSource}")38                        .validate("${sqlQuery}"));39            }40        });41    }42}43public class 7 {44    public static void main(String[] args) {45        Citrus citrus = Citrus.newInstance();46        citrus.run(new TestCase() {47            public void execute() {48                variable("sqlQuery", "select * from myTable");49                execute(new ExecuteSQLQueryAction()50                        .statements("${sqlQuery}")51                        .dataSource("${myDataSource}")52                        .validate("${sqlQuery}"));53            }54        });55    }56}57public class 8 {58    public static void main(String[] args) {59        return this;60    }

executeStatements

Using AI Code Generation

1package com.consol.citrus;2import org.springframework.jdbc.datasource.DriverManagerDataSource;3import org.springframework.jdbc.core.JdbcTemplate;4import org.springframework.jdbc.core.RowMapper;5import org.springframework.jdbc.datasource.DataSourceTransactionManager;6import org.springframework.transaction.support.TransactionTemplate;7import org.springframework.transaction.TransactionDefinition;8import org.springframework.transaction.TransactionStatus;9import org.springframework.transaction.support.DefaultTransactionDefinition;10import org.springframework.jdbc.datasource.DataSourceUtils;11import java.sql.Connection;12import java.sql.PreparedStatement;13import java.sql.ResultSet;14import java.sql.SQLException;15import java.util.ArrayList;16import java.util.List;17import java.util.Map;18import java.util.HashMap;19import java.util.Iterator;20import java.util.Set;21import java.util.HashSet;22import java.util.regex.Matcher;23import java.util.regex.Pattern;24import java.util.regex.PatternSyntaxException;25import java.util.Arrays;26import java.util.Properties;27import java.io.File;28import java.io.FileInputStream;29import java.io.IOException;30import java.io.InputStream;31import java.io.FileNotFoundException;32import java.io.BufferedReader;33import java.io.FileReader;34import java.io.InputStreamReader;35import java.io.UnsupportedEncodingException;36import java.io.Reader;37import java.io.StringReader;38import java.io.ByteArrayInputStream;39import java.io.ByteArrayOutputStream;40import java.io.ObjectInputStream;41import java.io.ObjectOutputStream;42import java.io.ObjectStreamClass;43import java.io.Serializable;44import java.lang.reflect.Method;45import java.lang.reflect.InvocationTargetException;46import java.lang.reflect.Field;47import java.lang.ClassNotFoundException;48import java.lang.ClassCastException;49import java.lang.reflect.Modifier;50import java.lang.reflect.Constructor;51import java.lang.reflect.Array;52import java.lang.reflect.Type;53import java.lang.reflect.TypeVariable;54import java.lang.reflect.ParameterizedType;55import java.lang.reflect.WildcardType;56import java.lang.reflect.GenericArrayType;57import java.lang.reflect.UndeclaredThrowableException;58import java.lang.reflect.Proxy;59import java.lang.reflect.InvocationHandler;60import java.lang.reflect.InvocationTargetException;61import java.lang.reflect.Field;62import java.lang.reflect.Constructor;63import java.lang.reflect.Method;64import java.lang.reflect.Modifier;65import java.lang.reflect.Type;66import java.lang.reflect.TypeVariable;67import java.lang.reflect.ParameterizedType;68import java.lang.reflect.WildcardType;69import java.lang.reflect.GenericArrayType;70import java.lang.reflect.UndeclaredThrowableException;71import java.lang.reflect.Proxy;72import java.lang.reflect.InvocationHandler;73import java.lang.reflect.InvocationTargetException;74import java.lang.reflect.Field;75import java.lang.reflect.Constructor;76import java.lang.reflect.Method;77import java.lang.reflect.Mod

executeStatements

Using AI Code Generation

1public class 4 {2    public static void main(String[] args) {3        Citrus citrus = Citrus.newInstance();4        citrus.run(new TestCase() {5            public void execute() {6                variable("sqlQuery", "select * from myTable");7                execute(new ExecuteSQLQueryAction()8                        .statements("${sqlQuery}")9                        .dataSource("${myDataSource}")10                        .validate("${sqlQuery}"));11            }12        });13    }14}15public class 5 {16    public static void main(String[] args) {17        Citrus citrus = Citrus.newInstance();18        citrus.run(new TestCase() {19            public void execute() {20                variable("sqlQuery", "select * from myTable");21                execute(new ExecuteSQLQueryAction()22                        .statements("${sqlQuery}")23                        .dataSource("${myDataSource}")24                        .validate("${sqlQuery}"));25            }26        });27    }28}29public class 6 {30    public static void main(String[] args) {31        Citrus citrus = Citrus.newInstance();32        citrus.run(new TestCase() {33            public void execute() {34                variable("sqlQuery", "select * from myTable");35                execute(new ExecuteSQLQueryAction()36                        .statements("${sqlQuery}")37                        .dataSource("${myDataSource}")38                        .validate("${sqlQuery}"));39            }40        });41    }42}43public class 7 {44    public static void main(String[] args) {45        Citrus citrus = Citrus.newInstance();46        citrus.run(new TestCase() {47            public void execute() {48                variable("sqlQuery", "select * from myTable");49                execute(new ExecuteSQLQueryAction()50                        .statements("${sqlQuery}")51                        .dataSource("${myDataSource}")52                        .validate("${sqlQuery}"));53            }54        });55    }56}57public class 8 {58    public static void main(String[] args) {

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.