qileilove

blog已经转移至github,大家请访问 http://qaseven.github.io/

Web service framework—SoapUI研究

  最近接触到web service的一些事情,是基于脚本的自动化的一个测试过程,主要用到的是SoapUI(groovy script)。
  SoapUI的在线文档是一个很好的资源,基于此,有一些简单的应用分享。
  有兴趣可以研究一下,自己也是一个在学习的过程,一点学习笔记分享给大家。
  Here is a sample presented that how to run test case in soapUI project and save data into DB
  Process:
  1.       Load properties file or DataSource so that fetch corresponding data
  2.       Set a request with parameters populated(data derive from properties or DataSource)
  3.       Through transfer property to save data into external files or DB
  4.       Using DataSink to export data to external files(such as excel,txt) or DB(need to connect DB)
  Screenshot of structure of one TestSuite:
  Step1: Load files( here I load file from properties file)
  PlaceName=Houston
  Step2: with data populated request
  (get data from properties under Form format)
  Step3: transfer data to target
  Also can transfer the designated data from original source to target( click on here)
 Step4: save data fetched into DB
  Need to connect database from DB list, here I select mysql as my db.
  Firstly you should download mysql-connector-java.zip from mysql website,after that, you should copy mysql-connector-java.jar to [JAVA_HOME]/ eviware/soapUI-Pro-3.5.1/jre/lib/ext, then configure connection and test it, if ok, you would fill in sql to insert data to table, as following:
  Step5: query mysql db and check if the data have been saved in DB

posted on 2014-11-17 10:23 顺其自然EVO 阅读(208) 评论(0)  编辑  收藏 所属分类: 测试学习专栏


只有注册用户登录后才能发表评论。


网站导航:
 
<2014年11月>
2627282930311
2345678
9101112131415
16171819202122
23242526272829
30123456

导航

统计

常用链接

留言簿(55)

随笔分类

随笔档案

文章分类

文章档案

搜索

最新评论

阅读排行榜

评论排行榜