Methods and systems for testing methods in a multi-tenant database environment

• US 8,707,264 B2
• Filed: 12/20/2010
• Issued: 04/22/2014
• Est. Priority Date: 05/18/2010
• Status: Active Grant

• Current Assignee: Salesforce.com, Inc.
• Original Assignee: Salesforce.com, Inc.
• Inventors: Hossain, Fiaz, Unger, Richard
• Primary Examiner(s): Wong, Don
• Assistant Examiner(s): MORSHED, HOSSAIN M
• Application Number:
  US12/973,660
• Publication Number:
  US 20110289356A1
• Time in Patent Office: 1,219 Days
• Field of Search: None
• US Class Current: 717/124
• CPC Class Codes: G06F 11/3672 Test management

Abstract

In accordance with embodiments disclosed herein, there are provided systems, devices, and methods for testing methods in a multi-tenant database environment, including, for example, hosting a plurality of customer codebases within a host organization, where each of the plurality of customer codebases includes a plurality of operational statements and one or more test methods. Such a method further includes generating a first test result set by executing the one or more test methods associated with each of the plurality of customer codebases against a production release codebase of the host organization; generating a second test result set by executing the one or more test methods associated with each of the plurality of customer codebases against a pre-release codebase of the host organization; and identifying errors associated with the pre-release codebase based on a comparison of the first test result set and the second test result set.

Claims

1. A method in a host organization, wherein the method comprises:

hosting a plurality of customer codebases within the host organization, each of the plurality of customer codebases having a plurality of operational statements and one or more test methods, the plurality of customer codebases belonging to customer organizations and executable under the direction and control of the customer organizations;

the host organization performing regression testing by;

(i) the host organization executing the one or more test methods belonging to the customer organizations against a production release codebase of the host organization to generate a first test result set;

(ii) the host organization again executing the one or more test methods belonging to the customer organizations against a pre-release codebase of the host organization to generate a second test result; and

(iii) the host organization identifying errors associated with the pre-release codebase based on a comparison of the first test result set and the second test result set.

2. The method of claim 1, further comprising:

providing on-demand database services to a plurality of customer organizations via a multi-tenant database system of the host organization, wherein the multi-tenant database system operates in conjunction with the production release codebase of the host organization; and

wherein each of the plurality of customer codebases hosted within the host organization are associated with a corresponding one of the plurality of customer organizations.

3. The method of claim 2, wherein the multi-tenant database system comprises elements of hardware and software that are shared by the plurality of customer organizations, each customer organization being a remotely located separate and distinct entity from the host organization having the multi-tenant database system and the production release codebase executing therein.

4. The method of claim 1:

wherein the production release codebase of the host organization is maintained and controlled by the host organization; and

wherein each of the plurality of customer codebases hosted by the host organization are maintained and controlled by a corresponding customer organization which subscribes to on-demand database services provided by the host organization.

5. The method of claim 4:

wherein each of the customer organizations have authority to view, alter, and execute a corresponding one of the plurality of customer codebases;

wherein the host organization has authority to view, alter, and execute the production release codebase of the host organization; and

wherein the host organization has further authority execute the one or more test methods associated with each of the plurality of customer codebases.

6. The method of claim 1, further comprising:

receiving each of the plurality of customer codebases from one of the plurality of customer organizations;

uniquely associating each of the plurality of customer codebases with one of the plurality of customer organizations based on an Organizational Identifier (OrgID) and/or User Identifier (UserID); and

storing each of the plurality of customer codebases received within a datastore of the host organization.

7. The method of claim 1, further comprising performing code coverage validation on each of the plurality of customer codebases, wherein performing the code coverage validation for each customer codebase comprises:

generating a statement count by identifying each of the plurality of operational statements within the customer codebase;

generating a tested statement count by executing the one or more test methods within the customer codebase and identifying which of the plurality of operational statements are invoked via the one or more test methods;

calculating a test coverage percentage based on a comparison of the statement count and the tested statement count; and

comparing the test coverage percentage against a minimum test coverage ratio specified by the host organization.

8. The method of claim 1, further comprising generating a regression test suite having the one or more test methods associated with each of the plurality of customer codebases specified therein by recursively searching each of the plurality customer codebases for units of operation self labeled as test methods and registering each test method with the regression test suite.

9. The method of claim 8:

wherein generating the first test result set comprises executing the regression test suite against the production release codebase of the host organization and capturing output from the execution of the regression test suite as the first test result set; and

wherein generating the second test result set comprises re-executing the regression test suite against the pre-release codebase of the host organization and capturing output from the re-execution of the regression test suite as the second test result set.

10. The method of claim 1:

wherein the production release codebase of the host organization comprises currently released and currently operating implementation logic to support on-demand services provided by the host organization; and

wherein the pre-release codebase of the host organization comprises an upgraded variant of the production release codebase having functionality which requires regression testing against available test methods to ensure backward compatibility between the pre-release codebase of the host organization and the plurality of customer codebases hosted by the host organization.

11. The method of claim 1:

wherein the plurality of operational statements within each of the customer codebases syntactically adhere to an Apex On-Demand compatible programming language;

wherein a plurality of customer organizations create customer specific applications in the Apex On-Demand compatible programming language via the plurality of operational statements within each of the customer codebases; and

wherein the production release codebase of the host organization provides Application Programming Interfaces (APIs) to the customer specific applications, the APIs enabling the customer specific applications to perform operations against a multi-tenant database system executing within the host organization that operates in conjunction with the production release codebase.

12. The method of claim 11, wherein identifying errors associated the pre-release codebase based on the comparison of the first test result set and the second test result set comprises identifying one or more incompatibilities between the customer specific applications and the pre-release codebase of the host organization.

13. The method of claim 1, wherein identifying errors associated with the pre-release codebase based on a comparison of the first test result set and the second test result set comprises eliminating output from each of the first test result set and the second test result set based on the following criteria:

where corresponding test method outputs in the first test result set and the second test result set each indicate a successful result;

where a test method output in the first test result set indicates failure and a corresponding test method output in the second test result set indicates success;

where corresponding test method outputs in the first test result set and the second test result set indicate identical failure modes;

where corresponding test method outputs in the first test result set and the second test result set indicate identical compilation error; and

where a test method output in the first test result set and/or a corresponding test method output in the second test result set matches one or more regular expressions set forth in an enumerated list of elimination patterns.

14. The method of claim 1, wherein generating the first test result set by executing the one or more test methods associated with each of the plurality of customer codebases against the production release codebase of the host organization and generating the second test result set by executing the one or more test methods associated with each of the plurality of customer codebases against the pre-release codebase of the host organization comprises generating the first test result set and the second test result set within a development sandbox having an execution environment within the host organization that is populated with replicated data mirrored from a live production multi-tenant database system of the host organization, wherein execution of test methods within the development sandbox are prevented from having any affect upon data within the live production multi-tenant database system of the host organization.

15. The method of claim 1, further comprising:

instantiating a development sandbox within the host organization;

replicating a live production multi-tenant database system of the host organization to a mirrored development multi-tenant database system within the development sandbox;

instantiating the production release codebase within the development sandbox upon the mirrored development multi-tenant database system; and

wherein generating the first test result set by executing the one or more test methods associated with each of the plurality of customer codebases against the production release codebase of the host organization comprises executing the one or more test methods associated with each of the plurality of customer codebases within the development sandbox.

16. The method of claim 15, further comprising:

rolling back any change to the mirrored development multi-tenant database system within the development sandbox resulting from execution of the one or more test methods associated with each of the plurality of customer codebases;

terminating the instantiated instance of the production release codebase within the development sandbox;

upgrading to the pre-release codebase within the development sandbox;

instantiating the pre-release codebase within the development sandbox upon the mirrored development multi-tenant database system; and

wherein generating the second test result set by executing the one or more test methods associated with each of the plurality of customer codebases against the pre-release codebase of the host organization comprises executing the one or more test methods associated with each of the plurality of customer codebases within the development sandbox.

17. The method of claim 1, further comprising implementing live production data safeguards comprising:

replicating the production release codebase of the host organization and a multi-tenant database system operating in conjunction with the production release codebase to a development sandbox;

terminating Simple Network Management Protocol (SNMP) capabilities within the development sandbox to prevent remote execution of functionality external to the development sandbox by executing functionality within the development sandbox;

configuring datastores within the host organization to be read-only from within the development sandbox;

creating a temporary writable datastore to accept any write attempts invoked by executing functionality within the development sandbox; and

configuring the replicated multi-tenant database system within the development sandbox to implement a policy to accept but not commit database transactions, wherein the policy enables rollback of all transactions performed against the replicated multi-tenant database system.

18. Non-transitory computer readable storage media having instructions stored thereupon that, when executed by a processor of a host organization, the processor causes the host organization to perform operations comprising:

hosting a plurality of customer codebases within the host organization, each of the plurality of customer codebases having a plurality of operational statements and one or more test methods, the plurality of customer codebases belonging to customer organizations and executable under the direction and control of the customer organizations;

the host organization performing regression testing by;

(i) the host organization executing the one or more test methods belonging to the customer organizations against a production release codebase of the host organization to generate a first test result set;

(ii) the host organization again executing the one or more test methods belonging to the customer organizations against a pre-release codebase of the host organization to generate a second test result; and

(iii) the host organization identifying errors associated with the pre-release codebase based on a comparison of the first test result set and the second test result set.

19. The non-transitory computer readable storage media of claim 18, wherein the method further comprises:

providing on-demand database services to a plurality of customer organizations via a multi-tenant database system of the host organization, wherein the multi-tenant database system operates in conjunction with the production release codebase of the host organization; and

wherein each of the plurality of customer codebases hosted within the host organization are associated with a corresponding one of the plurality of customer organizations.

20. A host organization comprising:

a processor and a memory;

a datastore to store a plurality of customer codebases within the host organization, each of the plurality of customer codebases having a plurality of operational statements and one or more test methods, the plurality of customer codebases belonging to customer organizations and executable under the direction and control of the customer organizations;

the host organization to execute, via a test executor, the one or more test methods belonging to the customer organizations against a production release codebase of the host organization to generate a first test result set;

the host organization to again execute, via the test executor, the one or more test methods belonging to the customer organizations against a pre-release codebase of the host organization to generate a second test result set;

the host organization to identify, via a results analyzer errors associated with the pre-release codebase based on a comparison of the first test result set and the second test result set.