Extending TPTP for database unit testing

Wei Liu (IBM Corp.), Der Ping Chou (IBM), Hong-Lee Yu (IBM Corp.), Don Clare (IBM)

Test And Performance · Long Talk
Presentation
Thursday, 13:30, 50 minutes | Theatre | Download in iCal Format

7
·
8
·
9
·
10
·
11
·
12
·
13
·
14
·
15
·
16
·
17
·
18
·
19

Der Ping Chou

Don Clare

Just like JUnit test for Java applications, database unit test provides structured and automated tests for database components. A unit test tests a particular method in a particular context. Database unit tests usually exercise on database objects, such as, stored procedures, user defined functions and triggers to make sure they work as designed and no regression is introduced during database development and maintenance lifecycle. Eclipse Test and Performance Tools Platform (TPTP) provides a comprehensive and highly extensible framework and set of services for developers to build tests. We are working on the design and development of a database unit test framework that facilitates the creation, management, deployment, execution and validation of unit tests on database objects. You will learn from this talk how the framework uses and extends TPTP and provides the following features that are unique and necessary for database unit tests: - Database connection management; - Database state management, including test setup and teardown; - Test data management, including using data-pools as test data; - Test automation, including automatic execution using scripts; - Test code generation using templates. You will also learn how to extend from the framework and generate test cases that meet your particular testing and validation requirements. We will provide a detailed feature comparison of our database unit test framework with dbunit (http://www.dbunit.org) to demonstrate what is unique with our framework.

Wei Liu is an Advisory Software Engineer for Information Management in IBM. She has more than ten years of software design and development experience in OO, UML, XML, data and business modeling. Mrs. Liu was the lead developer of Rational Rose Java/CORBA products and contributed to Rational XDE business and data modeling. She is currently responsible for the design and development of reporting, validation and naming standard components with IBM Rational Software Data Architect, as well as the database unit testing framework with IBM Data Studio.

Development manager with IBM Information Management Data Tools, WTP/DTP Committer, DTP ModelBase sub-project lead.

Hong-Lee Yu is a senior technical staff member at IBM and is a lead architect for data tooling products. He has over 20 years of experiences in software development with special interests in model-driven development and database design.

Don Clare is a software engineer involved in development of the IBM Data Studio and IBM Rational Data Architect products.

Floor Plan

Gold sponsors

BEA logo

IBM logo

Wind River logo

Replay Solutions logo

JBoss logo

SOPERA logo

Cloudsmith logo

BIRT Exchange logo

Skyway Software logo

Oracle

BlackBerry logo

AMD logo

Silver sponsors

Sybase

Google

Genuitec

Instantiations

Teamprise

Telelogic

Innoopract

Business Objects

LynuxWorks logo

Hardware sponsor

AMD logo

Media sponsors

Extension Media

Methods and Tools

ACM

Addison-Wesley logo

SD Times logo

Open Systems Publishing

Software Test & Performance logo

SDForum

Be a Sponsor