arrow
返回

Unit Tests for SQL

delete2024-01-01
delete2
delete
OA
AI
D
Diomidis Spinellis *
DOI:10.1109/MS.2023.3328788delete
delete原文链接
delete原文求助
delete分享
delete收藏
摘要

摘要

En 中文
RDBUnit is a unit testing framework designed to test relational database queries, created out of a need for unit testing them while working on software analytics tasks. It is available as a Python package on PyPI and open-source software on GitHub. RDBUnit tests consist of three parts: setup, query, and expected result, with the input and output defined as table contents. The framework utilizes a domain-specific language (DSL) for test specifications, employs a simple parsing mechanism, and uses a class hierarchy for managing database differences. It evaluates test results through SQL code generated and handled by the database engine. RDBUnit supports SQLite, mySQL, and PostgreSQL, and is implemented as a command-line tool suitable for diverse operating systems and continuous integration environments. It has proved beneficial in identifying subtle bugs and facilitating a focused and efficient approach to experimenting with SQL queries, especially in big data scenarios, signifying the assurance provided by unit testing in SQL-centric tasks.
Keyword:
Structured Query Language
Operating systems
Relational databases
Task analysis
Open source software
Engines
Testing

期刊

IEEE Software 封面图
IEEE Software
IF:
3
论文数:
3.2K
被引数:
3.6K

机构

D
Delft University of Technology
学者数:
2.6W
论文数: 2.5W
被引数: 3.8W
引用论文

引用论文