IP Library Granted Patent US 9,501,386
Granted Patent B2
US 9,501,386 · App. 14/583,360 · Granted Nov 22, 2016

System testing using nested transactions

View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 9,501,386
App. No.
14/583,360
Granted
Nov 22, 2016
Kind
B2
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.

Claims (43)

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.

Assignments (2)
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Jan 27, 2015
From: MICROSOFT CORPORATION
To: MICROSOFT TECHNOLOGY LICENSING, LLC
Reel/Frame 034819/0001 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Dec 30, 2014
From: LAMEGO, ANDRE FILIPE PIRES DE CARVALHO D AQUINO; PRODAN, ALEX; GRUBOV, SOREN LINDEGAARD; CHU, ZHONGHUA; LANGE, JOSHUA H.; GRAAF, BASTIAAN STEPHAN
To: MICROSOFT TECHNOLOGY LICENSING, LLC.
Reel/Frame 034599/0571 →