SoapUI Pro Project Solution Collection-change the JDBC Request behavior-阿里云开发者社区

SoapUI Pro Project Solution Collection-change the JDBC Request behavior

2017-09-07 992

版权

本文内容由阿里云实名注册用户自发贡献，版权归原作者所有，阿里云开发者社区不拥有其著作权，亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容，填写侵权投诉表单进行举报，一经查实，本社区将立刻删除涉嫌侵权内容。

简介：

change the jdbc request :

1.change the driver name,connection string,query string or assert.

the object we will use here is : JdbcRequestTestStep

        TestCase newcase=testRunner.getTestCase();
        JdbcRequestTestStep step1=(JdbcRequestTestStep) newcase.getTestStepByName("");
        
        String driver=step1.getDriver();
        String constr=step1.getConnectionString();
        String password=step1.getPassword();
        
        step1.setDriver(""); //if there's no driver should set as  step1.setDriver(null)        
        step1.setConnectionString("");
        step1.setPassword("");

change the jdbc sql statement:

        step1.setQuery("");
        step1.setQueryTimeout("");

change the assertion behavior(like xpath string,jquery string):

http://www.soapui.org/apidocs/com/eviware/soapui/model/testsuite/TestAssertion.html

http://www.soapui.org/apidocs/com/eviware/soapui/impl/wsdl/teststeps/assertions/basic/XPathContainsAssertion.html

http://www.soapui.org/apidocs/com/eviware/soapui/impl/wsdl/teststeps/assertions/basic/GroovyScriptAssertion.html

        int totalassert=step1.getAssertionCount();
        for(int k=0;k<totalassert;k++){
            TestAssertion asserts=step1.getAssertionAt(k);
            if(asserts instanceof XPathContainsAssertion ){
                if(asserts.getName().contains("Check count")){
                    String originalxpath=((XPathContainsAssertion) asserts).getPath();
                    String newxpath=originalxpath.replaceAll("Row", "Row2");
                    ((XPathContainsAssertion) asserts).setPath(newxpath);
                }
            }
        }