使用AggregateResults函数为Salesforce自定义控制器编写单元测试

@isTest
public class MyControllerTest {
    @isTest
    static void testAggregateResults() {
        // 构造测试数据
        Account acc1 = new Account(Name='Test Account 1', Industry='Technology');
        Account acc2 = new Account(Name='Test Account 2', Industry='Finance');
        insert new List<Account>{acc1, acc2};
        
        Opportunity opp1 = new Opportunity(Name='Test Opportunity 1', StageName='Closed Won', Amount=1000, AccountId=acc1.Id);
        Opportunity opp2 = new Opportunity(Name='Test Opportunity 2', StageName='Closed Lost', Amount=2000, AccountId=acc1.Id);
        Opportunity opp3 = new Opportunity(Name='Test Opportunity 3', StageName='Closed Won', Amount=3000, AccountId=acc2.Id);
        insert new List<Opportunity>{opp1, opp2, opp3};
        
        // 执行自定义控制器
        MyController controller = new MyController();
        List<AggregateResult> results = controller.getAggregateResults();
        
        // 验证结果
        System.assertEquals(2, results.size(), 'Expected 2 groups');
        
        for (AggregateResult result : results) {
            String industry = (String)result.get('Industry');
            Integer count = (Integer)result.get('expr0');
            Decimal sum = (Decimal)result.get('expr1');
            
            if (industry == 'Technology') {
                System.assertEquals(2, count, 'Expected 2 opportunities for Technology industry');
                System.assertEquals(3000, sum.intValue(), 'Expected total amount of 3000 for Technology industry');
            } else if (industry == 'Finance') {
                System.assertEquals(1, count, 'Expected 1 opportunity for Finance industry');
                System.assertEquals(3000, sum.intValue(), 'Expected total amount of 3000 for Finance industry');
            }
        }
    }
}