Test Data Generation for Database Applications
| Autor: | Sundararajarao Sudarshan, Pooja Agrawal, Bikash Chandra, Neha Garg, K. Venkatesh Emani |
|---|---|
| Rok vydání: | 2018 |
| Předmět: |
SQL
Unit testing Correctness Database Java Test data generation Computer science InformationSystems_DATABASEMANAGEMENT 020207 software engineering Static program analysis 02 engineering and technology Database application computer.software_genre Program analysis 0202 electrical engineering electronic engineering information engineering Plug-in computer computer.programming_language |
| Zdroj: | ICDE |
| DOI: | 10.1109/icde.2018.00191 |
| Popis: | Unit test cases have become an essential tool to test application code. Several applications make use of SQL queries in order to retrieve or update information from a database. Database queries for these applications are written natively in SQL using JDBC or using ORM frameworks like Hibernate. Unit testing these applications is typically done by loading a fixed dataset and running unit tests. However with fixed datasets, errors in queries may be missed. In this demonstration, we present a system that takes as input a database application program, and generates datasets and unit tests using the datasets to test the correctness of function with queries in the application. Our techniques are based on static program analysis and mutation testing. We consider database applications written in Java using JDBC or Hibernate APIs. The front-end of our system is a plugin to the IntelliJ IDEA IDE. We believe that such a system would be of great value to application developers and testers. |
| Databáze: | OpenAIRE |
| Externí odkaz: |
|