Testing environment for database server side logic

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.

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.