soapUI+groovy 接口测试之部分groovy使用记录
来源:互联网 发布:社交软件推荐算法 编辑:程序博客网 时间:2024/05/25 05:37
1, 写入值(30,31),更新到数据表的多条记录。
sqlStr ="select column_id from 1dcq_shop_column2 where shop_id = '"+ db_Shop_id + "'"
def dbSettings=[]
def db_sub_column_id =""
sqlResult = sql.eachRow(sqlStr)
{
dbSettings << it.toRowResult()
}
for (i=0;i< dbSettings.size;i++)
{
db_sub_column_id = db_sub_column_id.toString() + dbSettings[i].column_id.toString()
if (i < dbSettings.size-1)
{
db_sub_column_id=db_sub_column_id+","
}
}
assert subColumnId == db_sub_column_id
2,初始化数据
import groovy.sql.Sql
//import groovyx.net.http.ContentType
log.info("-------------------------------------------------The Test Step start ---------------------------------------------")
/*
* 1,获取数据库连接参数,连接数据库
*/
def tpProperties = testRunner.testCase.getProject()
def tsProperties = testRunner.testCase.getTestSuite()
def tcProperties = testRunner.getTestCase()
def service_ip= tpProperties.getPropertyValue( "YDGJ_IP" )
def refreshPath = tpProperties.getPropertyValue( "refreshPath" )
def db_url = tpProperties.getPropertyValue( "DB_Connection_URL" )
def db_user = tpProperties.getPropertyValue( "DB_loginname" )
def db_pwd = tpProperties.getPropertyValue( "DB_Password" )
def db_driver = tpProperties.getPropertyValue( "DB_Driver_Class" )
def sql = Sql.newInstance(db_url,db_user,db_pwd,db_driver)
log.info("------ 1,获取数据库连接参数,连接数据库 finished")
/*
* 2,初始化数据库表
*/
// begin 初始化数据
def sqlStr = "call sp_easydata_genAll()"
log.info("自动生成业务数据 : " + sqlStr)
sql.execute(sqlStr)
log.info("------ 2,初始化表基础数据 finished")
/*
* 3,设置补充用例所需表数据
*/
/*
def sqlStr = "select first 1 from "
log.info(sqlStr)
sql.execute(sqlStr);
*/
log.info("------ 3,设置补充用例所需表数据 finished, (请根据业务设置!)")
/*
* 4,设置 或 从数据表获取 用例参数值
*/
//设置数据-必填
def curTime = System.currentTimeMillis()
//log.info("curTime:" + curTime)
def shopName= "shopName"+curTime
log.info(shopName)
tcProperties.setPropertyValue( "shopName", shopName)
tcProperties.setPropertyValue( "userId", "2916011")
tcProperties.setPropertyValue( "shopkeeper","店主姓名呀")
tcProperties.setPropertyValue( "provinceId","360000")
3, 通过设置变量,获取变量完成值传递
def tpProperties = testRunner.testCase.getProject()
def tsProperties = testRunner.testCase.getTestSuite()
def tcProperties = testRunner.getTestCase()
def shopName = tcProperties.getPropertyValue("shopName" )
def userId = tcProperties.getPropertyValue("userId" )
def shopkeeper = tcProperties.getPropertyValue("shopkeeper" )
def provinceId = tcProperties.getPropertyValue("provinceId" )
三,string 用split 处理成数组
log.info("skillsCertificateNos: " + skillsCertificateNos)
String[] strAry = skillsCertificateNos.split(",");
log.info ("strAry.size():" + strAry.size())
for (i=0;i<strAry.size();i++)
{
sqlStr ="select count(*) as cnt from 1dcq_attachment where file_no = '"+ strAry[i] + "'"
log.info(sqlStr)
sqlResult = sql.firstRow(sqlStr)
log.info ("skillsCertificateNos,,,,,,,,sqlResult.cnt : " + sqlResult.cnt)
assert sqlResult.cnt == 1
}
- soapUI+groovy 接口测试之部分groovy使用记录
- soapui+groovy进行接口自动化测试浅谈
- soapui + groovy 接口自动化测试 第一章
- soapui + groovy 接口自动化测试 第二章
- SoapUI + Groovy 接口自动化
- 手把手教你接口自动化测试 – SoapUI & Groovy
- 手把手教你接口自动化测试 – SoapUI & Groovy
- SoapUI & Groovy接口自动化测试的简单扩展
- SOAPUI 使用groovy发送http请求 自动化测试
- SoapUI中使用Groovy脚本操作数据库 .
- SoapUI中使用Groovy脚本操作数据库
- SoapUI中使用Groovy脚本操作数据库
- 【备忘】SoapUI测试REST风格接口时的groovy script写法
- 带有时间戳和token验证的post接口的测试方法-基于soapUI+groovy
- 【SoapUI】在soapui中使用Groovy脚本常用方法
- Groovy and SoapUI
- SoapUI Groovy Script
- groovy 接口
- 《C编程习惯》读书笔记(1-6章)
- Jenkins和Sonar集成
- windows下python 安装mysqldb模块
- 安卓序列化的坑
- express 4.x, Socket.IO 1.x 共享session
- soapUI+groovy 接口测试之部分groovy使用记录
- 在win7中配置Python的scikit-learn包
- 嵌入式开发流程
- svn cleanup failed 的处理,亲测有效
- 4.20信息日常
- 使用JS监听键盘两个组合键触发的事件
- 在线文档管理系统
- 小米手机Attempt to invoke interface method 'boolean android.database.Cursor.moveToFirst()'
- You can't specify target table 'Person' for update in FROM clause