arrow
返回

Handling SQL Databases in Automated System Test Generation

delete2020-07-06
delete34
PRE
AI
A
Andrea Arcuri *
J
Juan Pablo Galeotti
DOI:10.1145/3391533delete
delete原文链接
delete原文求助
delete分享
delete收藏
摘要

摘要

En 中文
Automated system test generation for web/enterprise systems requires either a sequence of actions on a GUI (e.g., clicking on HTML links and form buttons) or direct HTTP calls when dealing with web services (e.g., REST and SOAP). When doing white-box testing of such systems, their code can be analyzed, and the same type of heuristics (e.g., the branch distance) used in search-based unit testing can be employed to improve performance. However, web/enterprise systems do often interact with a database. To obtain higher coverage and find new faults, the state of the databases needs to be taken into account when generating white-box tests. In this work, we present a novel heuristic to enhance search-based software testing of web/enterprise systems, which takes into account the state of the accessed databases. Furthermore, we enable the generation of SQL data directly from the test cases. This is useful when it is too difficult or time consuming to generate the right sequence of events to put the database in the right state. Also, it is useful when dealing with databases that are read-only for the system under test, and the actual data are generated by other services. We implemented our technique as an extension of EvoMaster, where system tests are generated in the JUnit format. Experiments on six RESTful APIs (five open-source and one industrial) show that our novel techniques improve coverage significantly (up to +16.5%), finding seven new faults in those systems.
Keyword:
SQL
database
SBST
automated test generation
system testing
REST
web service
AI总结

AI总结

对已上传原文的论文进行重点信息的提取,主要内容包括:简要概述、研究摘要、背景介绍、关键亮点、图文解析、展望与总结。

期刊

A
ACM Transactions on Software Engineering and Methodology
IF:
6.2
论文数:
1.2K
被引数:
3.4K

机构

U
University of Buenos Aires
学者数:
2.2W
论文数: 1.3W
被引数: 14
K
kristiania university college
学者数:
286
论文数: 354
被引数: 2
引用论文

引用论文

A Systematic Review of the Application and Empirical Investigation of Search-Based Test Case Generation
err2010-11-01
err284
errOAAI
errAli, Shaukat; Briand, Lionel C.; Hemmati, Hadi; Panesar-Walawege, Rajwinder K.
err分享
err收藏
err分享
err收藏
err分享
err收藏
学者 查看更多内容