Recently, I had the opportunity to work with Salesforce’s external object while developing a BATCH class to process opportunity updates. As part of the development process, I needed to write a test class to ensure proper code coverage. Initially, I assumed this task would be simple, but I quickly realized that achieving full test coverage for an external object is more challenging than it seems.
While researching solutions, I found that many developers struggle with mocking data for external objects, as standard test methods do not work the same way they do for standard and custom objects. Without proper test data, ensuring that the batch process runs correctly in different scenarios becomes difficult.
To address this issue, I am sharing my approach to solving it. Below is my opportunity update batch, where I update opportunities based on specific business logic. This example demonstrates how to work with external objects efficiently in a batch process while ensuring proper test coverage.
//Batch Class - Main class that needs some kind of code coverage
global with sharing class opportunityUpdate_BATCH implements Database.Batchable<sObject>,Database.Stateful{ global String query; global List<ExternalObject__x> externalObjectList; global BATCH_Class (List<sObject> sfList){ init(sfList); } //create your desired query for batch private void init(List<sObject> sfList){ query = '<write your query here>'; //checks if the constructor list is null, list wont be empty in tests. if(sfList== null) { externalObjectList = new List<sObject>(SMT_ExternalObjectQuery.records([ SELECT OpportunityNumber__c FROM ExternalObject__x ])); } else{ externalObjectList= sfList; } }
//starts the batch here and goes through the query global Database.QueryLocator start(Database.BatchableContext BC){ return Database.getQueryLocator(query); } //description calls performBatchActions method.
//Saw some examples saying that if you create another method it will increase code coverage
//while this was true it was not enough. global void execute(Database.BatchableContext BC, List<Opportunity> opportunityList){ performBatchActions(opportunityList); } global void finish(Database.BatchableContext BC){ } //Checks if opportunity has child records for ExternalObject__x and updates the opportunity. //Method created to get more code coverage because of external object private void performBatchActions(Opportunity[] opportunityList){ List<Opportunity> updatedopportunityList = new List<Opportunity>(); List<String> opportunityNumberList = new List<String>(); Map<String,ExternalObject__x> extObjectMap = new Map<String,ExternalObject__x>();
//goes through the opportunity list and adds your specified field in the new list opportunityNumberList for(Opportunity opportunity : opportunityList){ opportunityNumberList.add(opportunity.<AnyField>); }
//goes through the external object list and puts your field as a key to the extObjectMap. for(ExternalObject__x extObject: externalObjectList){
//adds a condition if the field is not empty. if(extObject.<Anyfield> != null){ extObjectMap.put(extObject.<Anyfield>,extObject); } }
//adds a condition if the extObjectMap is not empty. if(extObjectMap.size() > 0){
//goes through the opportunityList for(Opportunity opportunity : opportunityList){ //add your logic here and update opportunity updatedOpportunityList.add(opportunity); } } update updatedOpportunityList; } }
// Description: Class created for creating mock records for External Objects public virtual inherited sharing class ExternalObjectQuery { public static List<SObject> records(List<SObject> records) { return instance.passThrough(records); } static ExternalObjectQuery instance = new ExternalObjectQuery(); @TestVisible static void setMock(ExternalObjectQuerymock) { instance = mock; } protected virtual List<SObject> passThrough(List<SObject> records) { return records; } }
// Description: Test class for opportunityUpdate_BATCH @isTest private class opportunityUpdate_BATCH_TEST extends TestFactory { //Overriding the passThrough method from ExternalObjectQuery class Mock extends ExternalObjectQuery { final List<ExternalObject__x > externalRecords; Mock(List<ExternalObject__x > externalRecords) { this.externalRecords = externalRecords; } protected override List<SObject> passThrough(List<SObject> records) { return externalRecords; } } @TestSetup private static void dataSetup()
{ //add what is needed in the TestSetup } @IsTest static void test_OppCustomerCalcValue_BATCH() { List<ExternalObject__x > mockRecords = new List<ExternalObject__x >(); //populate as desired Opportunity oppQuery = <write your query here>; //ExternalObject__x mock record 1 ExternalObject__x mock1 = new ExternalObject__x (); mock1.OpportunityNumber__c = oppQuery.<fieldFromQuery>; //add records to list mockRecords.add(mock1); ExternalObjectQuery.setMock(new Mock(mockRecords)); ExternalObjectQuery.records(mockRecords); Test.startTest(); opportunityUpdate_BATCH oppBatch = new opportunityUpdate_BATCH(mockRecords); Database.executeBatch(oppBatch,200); Test.stopTest(); //make assertions //write your assertion here
} //Test for code coverage of the records and passThrough methods from ExternalObjectQuery
//We're doing this because our usage of the records method in the above test method
//won't cover those methods because they are overridden @IsTest static void test_OppCustomerCalcValue_BATCH_protList() { List<ExternalObject__x > mockRecords = new List<ExternalObject__x >(); //populate as desired call the created opportunity from Test Setup Opportunity oppQuery = <write your query here>; //ExternalObject__x mock record 1 ExternalObject__x mock1 = new ExternalObject__x (); mock1.OpportunityNumber__c = oppQuery.<fieldFromQuery>; //add records to list mockRecords.add(mock1); Test.startTest(); ExternalObjectQuery.records(mockRecords); Test.stopTest(); } }
Want to learn more?
Learn about Difference between Abstract, Virtual and Interface in APEX
Read more about Apex Class Definition
Check out this trailhead about Get Started with Apex Unit Tests
Leave a Reply