SYSTEM TESTING USING NESTED TRANSACTIONS

• US 20160188447A1
• Filed: 12/26/2014
• Published: 06/30/2016
• Est. Priority Date: 12/26/2014
• Status: Active Grant

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Inventors: Prodan, Alex, Grubov, Soren Lindegaard, Graaf, Bastiaan Stephan, Lamego, Andre Filipe Pires de Carvalho D Aquino, Chu, Zhonghua, Lange, Joshua H.
• Granted Patent: US 9,501,386 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 11/1458 Management of the backup or restore process
• CPC Class Codes: G06F 11/1474 in transactions G06F16/20 takes precedence
• CPC Class Codes: G06F 11/3672 Test management
• CPC Class Codes: G06F 11/3688 for test execution, e.g. scheduling of test suites
• CPC Class Codes: G06F 2201/80 Database-specific techniques
• CPC Class Codes: G06F 2201/84 Using snapshots, i.e. a logical point-in-time copy of the data

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

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.