Testing environment for database server side logic
View Patent ↗A method for providing a test environment for database server-side objects persistently stores a profile for a plurality of test runs for database server-side objects, where the profile comprises persistently stored test parameter values, pre-execution scripts, and/or post-execution scripts. Once the profile is created, it can be selected for subsequent test runs for one or more objects. A plurality of profiles for the objects may also be created. The method eliminates the need for a manual set up or destruction of the test environment for each test run, improving efficiency in the development of database server-side objects significantly.
1. A method for providing a test environment for a database object, the method comprising the steps of:
(a) receiving a profile for a test run of the database object, the profile comprising:
at least one test value to be passed to the database object during the test run, and
at least one pre-execution script to be executed prior to execution of the database object in the test run; and
(b) persistently storing the profile across multiple test runs of the database object.
2. The method of claim 1 , wherein the profile defines a combination of values, commands, or other test settings that are to be used during the test run.
3. The method of claim 1 , wherein the at least one pre-execution script comprises at least one SQL statement.
4. The method of claim 1 , wherein the profile further comprises at least one post-execution script to be executed after execution of the database object in the test run.
5. The method of claim 4 , wherein the at least one post-execution script comprises at least one SQL statement.
6. The method of claim 4 , wherein the at least one post-execution script cleans up or destroys a test environment for the test run of the database object.
7. The method of claim 1 , further comprising:
(c) receiving a selection of the persistently stored profile for the test run; and
(d) executing the test run of the database object according to the selected profile.
8. The method of claim 7 , wherein the executing step (d) comprises:
(d1) executing the at least one pre-execution script of the selected profile; and
(d2) executing the database object.
9. The method of claim 7 , wherein the executing step (d) comprises:
(d1) inputting the at least one test value of the selected profile into the database object; and
(d2) executing the database object.
10. The method of claim 7 , wherein the executing step (d) comprises:
(d1) executing the database object; and
(d2) executing at least one post-execution script of the selected profile.
11. The system of claim 1 , wherein the at least one pre-execution script sets up a testing environment for the test run of the database object.
12. A method for providing a test environment for a database object, the method comprising the steps of:
(a) receiving at least one pre-execution script for a profile for a test run of the database object, the at least one pre-execution script to be executed prior to execution of the database object in the test run;
(b) receiving at least one test value for the profile, the at least one test value to be passed to the database object during the test run;
(c) receiving at least one post-execution script for the profile, the at least one post-execution script to be executed after execution of the database object in the test run; and
(d) persistently storing the profile across multiple test runs of the database object.
13. The method of claim 12 , further comprising:
(e) receiving a selection of the persistently stored profile for the test run; and
(f) executing the test run of the database object according to the selected profile.
14. The method of claim 13 , wherein the executing step (f) comprises:
(f1) executing the at least one pre-execution script of the selected profile;
(f2) inputting the at least one test value of the selected profile into the database object;
(f3) executing the database object; and
(f4) executing the at least one post-execution script of the selected profile.
15. The method of claim 12 , wherein the at least one pre-execution script sets up a testing environment for the test run of the database object.
16. The method of claim 12 , wherein the at least one post-execution script cleans up or destroys a test environment for the test run of the database object.
17. A method for performing a test run of a database object, the method comprising the steps of:
(a) receiving a selection of a profile for the test run of the database object, the selected profile comprising:
at least one test value to be passed to the database object during the test run, and
at least one pre-execution script to be executed prior to execution of the database object in the test run,
wherein the profile is persistently stored across multiple test runs of the database object; and
(b) executing the test run of the database object according to the selected profile.
18. The method of claim 17 , wherein the selected profile defines a combination of values, commands, or other test settings that are to be used during the test run.
19. The method of claim 17 , wherein the selected profile further comprises at least one post-execution script to be executed after execution of the database object in the test run.
20. The method of claim 19 , wherein the executing step (b) comprises:
(b1) executing the at least one pre-execution script of the selected profile;
(b2) inputting the at least one test value of the selected profile into the database object;
(b3) executing the database object; and
(b4) executing the at least one post-execution script of the selected profile.
21. The method of claim 19 , wherein the at least one post-execution script cleans up or destroys a test environment for the test run of the database object.
22. The medium of claim 17 , wherein the at least one pre-execution script sets up a testing environment for the test run of the database object.