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

Copied to Clipboard!

How to use extractSqlFromH2PreparedStatement method of org.evomaster.client.java.instrumentation.coverage.methodreplacement.classes.PreparedStatementClassReplacement class

Best EvoMaster code snippet using org.evomaster.client.java.instrumentation.coverage.methodreplacement.classes.PreparedStatementClassReplacement.extractSqlFromH2PreparedStatement

Source:PreparedStatementClassReplacement.java

...22    @Override23    public Class<?> getTargetClass() {24        return PreparedStatement.class;25    }26    public static String extractSqlFromH2PreparedStatement(PreparedStatement stmt) {27        Class<?> klass = stmt.getClass();28        String className = klass.getName();29        if (!className.equals("org.h2.jdbc.JdbcPreparedStatement")) {30            throw new IllegalArgumentException("Invalid type: " + className);31        }32        try {33            /*34                Quite brittle... but easy to test on new H2 releases35             */36            Field cf = klass.getDeclaredField("command");37            cf.setAccessible(true);38            Object command = cf.get(stmt);39            Class<?> ck = command.getClass();40            if(! ck.getName().endsWith("CommandRemote")){41                /*42                    very brittle.. :(43                    based on the concrete class for the Command (there are 3...)44                    the location of the 'sql' private field is different :(45                 */46                ck = ck.getSuperclass();47            }48            Field sf = ck.getDeclaredField("sql");49            sf.setAccessible(true);50            String sql = (String) sf.get(command);51            Method pm = command.getClass().getDeclaredMethod("getParameters");52            pm.setAccessible(true);53            List<?> pv = (List<?>) pm.invoke(command);54            List<String> params = pv.stream()55                    .map(it -> {56                        try {57                            Method gpvm = it.getClass().getDeclaredMethod("getParamValue");58                            gpvm.setAccessible(true);59                            Object value =  gpvm.invoke(it);60                            if(value.getClass().getName().equals("org.h2.value.ValueLobDb")){61                                //FIXME this gives issues... not sure we can really handle it62                                return "LOB";63                            }64                            return value.toString();65                        } catch (Exception e) {66                            throw new RuntimeException(e);67                        }68                    })69                    .collect(Collectors.toList());70            return interpolateSqlStringWithJSqlParser(sql, params);71        } catch (Exception e) {72            throw new RuntimeException(e);73        }74    }75    // replaced by interpolateSqlStringWithJSqlParser76    @Deprecated77    public static String interpolateSqlString(String sql, List<String> params) {78        long replacements = sql.chars().filter(it -> it=='?').count();79        if(replacements != params.size()){80            SimpleLogger.error("EvoMaster ERROR. Mismatch of parameter count " + replacements+"!="+ params.size()81                    + " in SQL command: " + sql);82            return null;83        }84        for(String p : params){85            sql = sql.replaceFirst("\\?", p);86        }87        return sql;88    }89    /**90     * inspired by this example from https://stackoverflow.com/questions/46890089/how-can-i-purify-a-sql-query-and-replace-all-parameters-with-using-regex91     * @param sql is an original sql command which might contain comments or be dynamic sql with parameters92     * @param params are parameters which exists in the [sql]93     * @return a interpolated sql.94     * note that if the sql could not be handled, we return the original one since such info is still useful for e.g., industrial partner95     *          then we could record the execution info.96     * note that comments could also be removed with this function.97     *98     */99    public static String interpolateSqlStringWithJSqlParser(String sql, List<String> params) {100        StringBuilder sqlbuffer = new StringBuilder();101        try {102            ExpressionDeParser expDeParser = new ExpressionDeParser() {103                @Override104                public void visit(JdbcParameter parameter) {105                    int index = parameter.getIndex();106                    this.getBuffer().append(params.get(index-1));107                }108            };109            SelectDeParser selectDeparser = new SelectDeParser(expDeParser, sqlbuffer);110            expDeParser.setSelectVisitor(selectDeparser);111            expDeParser.setBuffer(sqlbuffer);112            StatementDeParser stmtDeparser = new StatementDeParser(expDeParser, selectDeparser, sqlbuffer);113            Statement stmt = CCJSqlParserUtil.parse(sql);114            stmt.accept(stmtDeparser);115            return stmtDeparser.getBuffer().toString();116        } catch (Exception e) {117            // catch all kinds of exception here since there might exist problems in processing params118            SimpleLogger.error("EvoMaster ERROR. Could not handle "+ sql + " with an error message :"+e.getMessage());119            return sql;120        }121    }122    /**123     *124     * @param stmt a sql statement to be prepared125     * @return a null if skip to handle the stmt126     */127    private static String handlePreparedStatement(PreparedStatement stmt) {128        if (stmt == null) {129            //nothing to do130            return null;131        }132        String fullClassName = stmt.getClass().getName();133        if (fullClassName.startsWith("com.zaxxer.hikari.pool") ||134                fullClassName.startsWith("org.apache.tomcat.jdbc.pool") ||135                fullClassName.startsWith("com.sun.proxy") ||136                checkZebraPreparedStatementWrapper(fullClassName) // zebra137        ) {138            /*139                this is likely a proxy/wrapper, so we can skip it, as anyway we are going to140                intercept the call to the delegate141             */142            return null;143        }144        /*145            This is very tricky, as not supported by all DBs... see for example:146            https://stackoverflow.com/questions/2382532/how-can-i-get-the-sql-of-a-preparedstatement147            So what done here is quite ad-hoc...148            There is no direct way to access the SQL command... but some drivers do print it149            when calling toString.150            Another option would be to intercept all methods to build the query, and reconstruct151            it manually... but it would be a LOT of work.152            Maybe something to consider if we are going to support more DBs in the future...153         */154        String sql = stmt.toString();155        //Postgres print the command as it is156        if (sql.startsWith("com.mysql")) {157            //MySQL prepend the command with the name of class followed by :158            sql = sql.substring(sql.indexOf(":") + 1);159        }160        if (stmt.getClass().getName().equals("org.h2.jdbc.JdbcPreparedStatement")) {161            /*162                Unfortunately H2 does not support it... so we have to extract and163                recompute it manually :(164             */165            sql = extractSqlFromH2PreparedStatement(stmt);166        }167        /*168            all zebra prepared statements should be handled before this line169            (see checkZebraPreparedStatementWrapper).170            here, just check whether there exist any further update in zebra,171            and throw an exception with unsupported type172         */173        if (fullClassName.startsWith("com.dianping.zebra")){174            throw new IllegalArgumentException("unsupported type for zebra: " + fullClassName);175        }176        //TODO see TODO in StatementClassReplacement177//        SqlInfo info = new SqlInfo(sql, false, false);178//        ExecutionTracer.addSqlInfo(info);179        return sql;...

Source:H2CheckPreparedStatementTest.java

...13        PreparedStatement stmt = connection.prepareStatement("SELECT * FROM Foo WHERE x=? AND y=? AND z=?");14        stmt.setBoolean(3, false);15        stmt.setInt(1, 42);16        stmt.setString(2, "BAR");17        String res = PreparedStatementClassReplacement.extractSqlFromH2PreparedStatement(stmt);18        assertEquals("SELECT * FROM Foo WHERE x = 42 AND y = 'BAR' AND z = FALSE", res);19    }20}...

extractSqlFromH2PreparedStatement

Using AI Code Generation

1import org.evomaster.client.java.instrumentation.coverage.methodreplacement.classes.PreparedStatementClassReplacement;2public class 2 {3    public static void main(String[] args) {4        String sql = PreparedStatementClassReplacement.extractSqlFromH2PreparedStatement("SELECT * FROM table WHERE id = ?");5        System.out.println(sql);6    }7}

extractSqlFromH2PreparedStatement

Using AI Code Generation

1package org.evomaster.client.java.instrumentation.coverage.methodreplacement.classes;2import java.sql.Connection;3import java.sql.PreparedStatement;4import java.sql.SQLException;5public class PreparedStatementClassReplacement {6    public static String extractSqlFromH2PreparedStatement(PreparedStatement ps) throws SQLException {7        Connection connection = ps.getConnection();8        String sql = connection.nativeSQL(ps.toString());9        return sql;10    }11}12package org.evomaster.client.java.instrumentation.coverage.methodreplacement.classes;13import java.sql.Connection;14import java.sql.PreparedStatement;15import java.sql.SQLException;16public class PreparedStatementClassReplacement {17    public static String extractSqlFromH2PreparedStatement(PreparedStatement ps) throws SQLException {18        Connection connection = ps.getConnection();19        String sql = connection.nativeSQL(ps.toString());20        return sql;21    }22}23package org.evomaster.client.java.instrumentation.coverage.methodreplacement.classes;24import java.sql.Connection;25import java.sql.PreparedStatement;26import java.sql.SQLException;27public class PreparedStatementClassReplacement {28    public static String extractSqlFromH2PreparedStatement(PreparedStatement ps) throws SQLException {29        Connection connection = ps.getConnection();30        String sql = connection.nativeSQL(ps.toString());31        return sql;32    }33}34package org.evomaster.client.java.instrumentation.coverage.methodreplacement.classes;35import java.sql.Connection;36import java.sql.PreparedStatement;37import java.sql.SQLException;38public class PreparedStatementClassReplacement {39    public static String extractSqlFromH2PreparedStatement(PreparedStatement ps) throws SQLException {40        Connection connection = ps.getConnection();41        String sql = connection.nativeSQL(ps.toString());42        return sql;43    }44}45package org.evomaster.client.java.instrumentation.coverage.methodreplacement.classes;46import java.sql.Connection;47import java.sql.PreparedStatement;48import java.sql.SQLException;49public class PreparedStatementClassReplacement {

extractSqlFromH2PreparedStatement

Using AI Code Generation

1import org.evomaster.client.java.instrumentation.coverage.methodreplacement.classes.PreparedStatementClassReplacement;2import java.sql.Connection;3import java.sql.DriverManager;4import java.sql.PreparedStatement;5import java.sql.SQLException;6public class 2 {7    public static void main(String[] args) throws SQLException {8        Connection conn = DriverManager.getConnection("jdbc:h2:mem:test;DB_CLOSE_DELAY=-1", "sa", "");9        PreparedStatement ps = conn.prepareStatement("SELECT * FROM table WHERE a = ? AND b = ?");10        ps.setString(1, "foo");11        ps.setString(2, "bar");12        String sql = PreparedStatementClassReplacement.extractSqlFromH2PreparedStatement(ps);13        System.out.println(sql);14    }15}

extractSqlFromH2PreparedStatement

Using AI Code Generation

1package org.evomaster.client.java.instrumentation.coverage.methodreplacement.classes;2import org.evomaster.client.java.instrumentation.coverage.methodreplacement.Replacement;3import org.evomaster.client.java.instrumentation.coverage.methodreplacement.ReplacementType;4import org.evomaster.client.java.instrumentation.shared.ReplacementTypeUtils;5import java.sql.PreparedStatement;6public class PreparedStatementClassReplacement {7    @Replacement(type = ReplacementType.EXCEPTION, replacingStatic = false)8    public static String extractSqlFromH2PreparedStatement(PreparedStatement ps) {9        return ReplacementTypeUtils.extractString(ps, "sql");10    }11}12package org.evomaster.client.java.instrumentation.coverage.methodreplacement.classes;13import org.evomaster.client.java.instrumentation.coverage.methodreplacement.Replacement;14import org.evomaster.client.java.instrumentation.coverage.methodreplacement.ReplacementType;15import org.evomaster.client.java.instrumentation.shared.ReplacementTypeUtils;16import java.sql.PreparedStatement;17public class PreparedStatementClassReplacement {18    @Replacement(type = ReplacementType.EXCEPTION, replacingStatic = false)19    public static String extractSqlFromH2PreparedStatement(PreparedStatement ps) {20        return ReplacementTypeUtils.extractString(ps, "sql");21    }22}23package org.evomaster.client.java.instrumentation.coverage.methodreplacement.classes;24import org.evomaster.client.java.instrumentation.coverage.methodreplacement.Replacement;25import org.evomaster.client.java.instrumentation.coverage.methodreplacement.ReplacementType;26import org.evomaster.client.java.instrumentation.shared.ReplacementTypeUtils;27import java.sql.PreparedStatement;28public class PreparedStatementClassReplacement {29    @Replacement(type = ReplacementType.EXCEPTION, replacingStatic = false)30    public static String extractSqlFromH2PreparedStatement(PreparedStatement ps) {31        return ReplacementTypeUtils.extractString(ps, "sql");32    }33}

extractSqlFromH2PreparedStatement

Using AI Code Generation

1import org.evomaster.client.java.instrumentation.coverage.methodreplacement.classes.PreparedStatementClassReplacement;2import java.sql.Connection;3import java.sql.DriverManager;4import java.sql.PreparedStatement;5import java.sql.SQLException;6public class 2 {7    public static void main(String[] args) throws SQLException {8        Connection connection = DriverManager.getConnection("jdbc:h2:mem:test;DB_CLOSE_DELAY=-1", "sa", "");9        PreparedStatement preparedStatement = connection.prepareStatement("SELECT * FROM MY_TABLE WHERE ID = ?");10        preparedStatement.setInt(1, 1);11        String sql = PreparedStatementClassReplacement.extractSqlFromH2PreparedStatement(preparedStatement);12        System.out.println(sql);13    }14}

extractSqlFromH2PreparedStatement

Using AI Code Generation

1    public String extractSqlFromH2PreparedStatement(PreparedStatement ps) {2        return PreparedStatementClassReplacement.extractSqlFromH2PreparedStatement(ps);3    }4}5    public String extractSqlFromH2PreparedStatement(PreparedStatement ps) {6        return PreparedStatementClassReplacement.extractSqlFromH2PreparedStatement(ps);7    }8}9    public String extractSqlFromH2PreparedStatement(PreparedStatement ps) {10        return PreparedStatementClassReplacement.extractSqlFromH2PreparedStatement(ps);11    }12}13    public String extractSqlFromH2PreparedStatement(PreparedStatement ps) {14        return PreparedStatementClassReplacement.extractSqlFromH2PreparedStatement(ps);15    }16}17    public String extractSqlFromH2PreparedStatement(PreparedStatement ps) {18        return PreparedStatementClassReplacement.extractSqlFromH2PreparedStatement(ps);19    }20}

extractSqlFromH2PreparedStatement

Using AI Code Generation

1import java.sql.Connection;2import java.sql.DriverManager;3import java.sql.PreparedStatement;4import java.sql.SQLException;5public class 2 {6    public static void main(String[] args) throws SQLException {7        Connection con = DriverManager.getConnection("jdbc:h2:mem:test;DB_CLOSE_DELAY=-1", "sa", "");8        PreparedStatement p = con.prepareStatement("select * from test where id=?");9        p.setString(1, "1");10        String sql = org.evomaster.client.java.instrumentation.coverage.methodreplacement.classes.PreparedStatementClassReplacement.extractSqlFromH2PreparedStatement(p);11        System.out.println(sql);12    }13}14import java.sql.Connection;15import java.sql.DriverManager;16import java.sql.PreparedStatement;17import java.sql.SQLException;18public class 3 {19    public static void main(String[] args) throws SQLException {20        Connection con = DriverManager.getConnection("jdbc:h2:mem:test;DB_CLOSE_DELAY=-1", "sa", "");21        PreparedStatement p = con.prepareStatement("select * from test where id=?");22        p.setString(1, "1 or 1=1");23        String sql = org.evomaster.client.java.instrumentation.coverage.methodreplacement.classes.PreparedStatementClassReplacement.extractSqlFromH2PreparedStatement(p);24        System.out.println(sql);25    }26}27import java.sql.Connection;28import java.sql.DriverManager;29import java.sql.PreparedStatement;30import java.sql.SQLException;31public class 4 {32    public static void main(String[] args) throws SQLException {33        Connection con = DriverManager.getConnection("jdbc:h2:mem:test;DB_CLOSE_DELAY=-1", "sa", "");34        PreparedStatement p = con.prepareStatement("select * from test where id=?");35        p.setString(

extractSqlFromH2PreparedStatement

Using AI Code Generation

1public class 2 {2    public static void main(String[] args) throws SQLException {3        Connection conn = DriverManager.getConnection("jdbc:h2:mem:test;DB_CLOSE_DELAY=-1", "sa", "");4        PreparedStatement ps = conn.prepareStatement("SELECT * FROM table WHERE a = ? AND b = ?");5        ps.setString(1, "foo");6        ps.setString(2, "bar");7        String sql = PreparedStatementClassReplacement.extractSqlFromH2PreparedStatement(ps);8        System.out.println(sql);9    }10}

extractSqlFromH2PreparedStatement

Using AI Code Generation

1    public String extractSqlFromH2PreparedStatement(PreparedStatement ps) {2        return PreparedStatementClassReplacement.extractSqlFromH2PreparedStatement(ps);3    }4}5    public String extractSqlFromH2PreparedStatement(PreparedStatement ps) {6        return PreparedStatementClassReplacement.extractSqlFromH2PreparedStatement(ps);7    }8}9    public String extractSqlFromH2PreparedStatement(PreparedStatement ps) {10        return PreparedStatementClassReplacement.extractSqlFromH2PreparedStatement(ps);11    }12}13    public String extractSqlFromH2PreparedStatement(PreparedStatement ps) {14        return PreparedStatementClassReplacement.extractSqlFromH2PreparedStatement(ps);15    }16}17    public String extractSqlFromH2PreparedStatement(PreparedStatement ps) {18        return PreparedStatementClassReplacement.extractSqlFromH2PreparedStatement(ps);19    }20}

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.