System testing using nested transactions

Patent metadata

Field	Value
Publication number	US-2016188447-A1
Application number	US-201414583360-A
Country	US
Kind code	A1
Filing date	Dec 26, 2014
Priority date	Dec 26, 2014
Publication date	Jun 30, 2016
Grant date	—

Abstract

A computer system includes a processor and a data store coupled to the processor. An application component is operably coupled to the processor and the data store and is configured to run one or more applications stored in the data store. A test framework is coupled to the processor and the data store and is configured to perform at least one test relative to a component of the computer system that interacts with a database. A savepoint manager is configured to responsively generate at least one savepoint in the database prior to the at least one test and to roll back the at least one savepoint after the at least one test. Methods of testing the computer system are also provided.

First claim

What is claimed is:

1 . A computer system comprising:
a processor; a data store coupled to the processor; an application component operably coupled to the processor and the data store, the application component being configured to run one or more applications stored in the data store; a test framework coupled to the processor and the data store, the application component being configured to perform at least one test relative to a component of the computer system that interacts with a database; and a savepoint manager configured to responsively generate at least one savepoint in the database prior to the at least one test and to roll back the at least one savepoint after the at least one test.

2 . The computer system of claim 1 , wherein the database is a component of the computer system.

3 . The computer system of claim 1 , wherein the database is located remotely from the computer system and is communicatively coupled to the computer system.

4 . The computer system of claim 1 , wherein the component of the computer system is a user form.

5 . The computer system of claim 1 , wherein the component is a workflow.

6 . The computer system of claim 1 , wherein the component is a process.

7 . The computer system of claim 1 , and wherein the savepoint manager is configured to generate and subsequently roll back a plurality of savepoints.

8 . The computer system of claim 7 , wherein the plurality of savepoints are nested.

9 . The computer system of claim 8 , wherein the nested savepoints are stored in a stack.

10 . A computer-implemented test method comprising:
generating at least one savepoint in a database; performing at least one system test that changes data in the database; and rolling back the at least one savepoint after performing the at least one system test.

11 . The computer-implemented test method of claim 10 , wherein generating the at least one savepoint comprises generating first and second savepoints, wherein the first and second savepoints are nested.

12 . The computer-implemented test method of claim 11 , wherein performing at least one system test includes performing a first system test after generation of the first and second savepoints and performing a second system test after the second savepoint is rolled back, but before the first savepoint is rolled back.

13 . The computer-implemented test method of claim 12 , and further comprising rolling back the first savepoint after completion of the second system test.

14 . The computer-implemented test method of claim 13 , and further comprising generating a third savepoint after the first savepoint is rolled back and performing a third system test after the third savepoint is generated.

15 . The computer-implemented test method of claim 14 , wherein the third savepoint is rolled back after completion of the third system test.

16 . A computer-implemented test method comprising:
causing a test framework to generate a first savepoint in a database using a savepoint manager; initiating a setup function in an application component; causing the test framework to generate a second savepoint in the database using the savepoint manager; initiating a setup of a first test class; performing a first test function on the first test class; and causing the test framework to roll back to the second savepoint using the savepoint manager.

17 . The computer-implemented test method of claim 16 , and further comprising invoking a teardown function of the first test class prior to causing the test framework to roll back to the second savepoint.

18 . The computer-implemented test method of claim 17 , and further comprising initiating a setup of the first test class and performing a second test function on the first test class.

19 . The computer-implemented method of claim 18 , and further comprising rolling back the first and second savepoints.

20 . The computer-implemented test method of claim 19 , and further comprising:
causing the test framework to generate a third savepoint in the database using the savepoint manager; initiating a setup of a second test class; performing the first test function on the second test class; and causing the test framework to roll back to the third savepoint using the savepoint manager.

Assignees

• Microsoft Technology Licensing Llc

Inventors

• Lamego Andre Filipe Pires De Carvalho D Aquino
• Prodan Alex
• Grubov Soren Lindegaard
• Chu Zhonghua
• Lange Joshua H
• Graaf Bastiaan Stephan

Classifications

• G06F11/3688 Primary

  for test execution, e.g. scheduling of test suites · CPC title

• G06F11/1458

  Management of the backup or restore process · CPC title

• G06F2201/84

  Using snapshots, i.e. a logical point-in-time copy of the data · CPC title

• G06F11/1474

  in transactions (updating of structured data in databases G06F16/23) · CPC title

• G06F2201/80

  Database-specific techniques · CPC title