System testing using nested transactions

Patent metadata

Field	Value
Publication number	US-9501386-B2
Application number	US-201414583360-A
Country	US
Kind code	B2
Filing date	Dec 26, 2014
Priority date	Dec 26, 2014
Publication date	Nov 22, 2016
Grant date	Nov 22, 2016

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 an application stored in the data store;
a test framework coupled to the processor and the data store, the test framework being configured to:
set up a first test class,
perform a test relative to a component of the computer system that interacts with a database,
perform a teardown function of the first test class; and

a savepoint manager configured to responsively execute a savepoint function in the database prior to the test and to execute a rollback function of the savepoint function after the 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 execute a plurality of savepoint functions and subsequently execute a rollback function relative to each executed savepoint function.

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

9. The computer system of claim 8 , wherein information relative to the nested savepoint functions is stored in a stack.

10. A computer-implemented test method comprising:
executing first and second savepoint functions in a database;
setting up a first test class;
performing a first system test after executing the first and second savepoint functions, wherein the first system test changes data in the database;
performing a teardown function of the first test class; and
executing a rollback function relative to one of the first and second savepoint functions after performing the first system test.

11. The computer-implemented test method of claim 10 , wherein the first and second savepoint functions are nested.

12. The computer-implemented test method of claim 11 , and further comprising performing a second system test after executing rollback function.

13. The computer-implemented test method of claim 12 , and further comprising executing a rollback function relative to the other of the first and second savepoint functions after completion of the second system test.

14. The computer-implemented test method of claim 13 , and further comprising executing a third savepoint after executing rollback functions relative to the first and second savepoint functions and performing a third system test after executing the third savepoint function.

15. The computer-implemented test method of claim 14 , and further comprising executing a rollback function relative to the third savepoint function after completion of the third system test.

16. A computer-implemented test method comprising:
causing a test framework to execute a first savepoint function in a database using a savepoint manager;
initiating a setup function in an application component;
causing the test framework to execute a second savepoint function in the database using the savepoint manager;
setting up a first test class;
performing a first test function on the first test class;
causing the test framework to execute a rollback function relative to the second savepoint function using the savepoint manager; and
invoking a teardown function of the first test class prior to causing the test framework to execute a rollback function relative to the second savepoint.

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

18. The computer-implemented method of claim 17 , and further comprising executing rollback functions relative to the first and second savepoint functions.

19. The computer-implemented test method of claim 18 , and further comprising:
causing the test framework to execute a third savepoint function in the database using the savepoint manager;
setting UP a second test class;
performing the first test function on the second test class; and
causing the test framework to execute a rollback function relative to the third savepoint function using the savepoint manager.

Assignees

• Microsoft Technology Licensing Llc

Inventors

• Lamego Andre Filipe Pires De Carvalho D Aquino Lamego
• 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/3672 Primary

  Test management · CPC title

• G06F11/1474

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