+ Start a Discussion
Patrick ConnerPatrick Conner 

Test Class for Schedulable Class with aggregate functions

The following is a class to be used to implement data retention ruleson tasks in our instance. Our own code is quite different than the code below, but using this outline, how would I get started with a test class? This type of class, and some of the functions used, are new to me. Thank you very much for any help.
global class TaskRetention implements Schedulable
    global void execute(SchedulableContext SC)
AggregateResult[] tasksWithin30Days = [Select whatId from task where createddate = Last_n_days:30 group by whatid];
AggregateResult[] noTask30Days = [Select whatId,max(createddate) maxdate from task group by  whatid having max(createddate) < Last_n_days:30 ];

Id[] hasTaskWithin30Days = new Id[]{};
Id[] noTasksIn30Days = new Id[]{};
String[] whatIdDateTimeList = new String[]{};

for(AggregateResult ar: tasksWithin30Days ){
for(AggregateResult ar: noTask30Days){

delete [ Select Id from Task where whatId in :hasTaskWithin30Days and createddate< last_n_days:30];
delete [Select Id from Task where whatId in :noTasksin30Days and whatId_createddate__c not in :whatIdDateTimeList];

Raj VakatiRaj Vakati
private class TaskRetention_Test {
    public static void  testschedule() {
        Opportunity opp =  new opportunity(
            name = 'test opp 1',
            StageName = 'Closed Lost',
            LeadSource = 'Weh',
            CloseDate = system.today());
        insert opp;
        List<Task> tasks = new List<Task>();
        for(Integer i=0 ;i <10 ; i++){
        Task u = new Task();
        u.Subject='Run Test Trigger';
        u.Status='Not Started';
        u.CreatedDate =System.today()-i;
        u.WhatId =opp.id; 
        insert tasks ;
        TaskRetention sh1 = new TaskRetention();      
        String sch = '0 0 23 * * ?';
        system.schedule('TaskRetention', sch, sh1);

Amit Chaudhary 8Amit Chaudhary 8
Please check below post how to write test class for scheduler class
1) http://amitsalesforce.blogspot.com/2017/07/how-to-write-test-class-for-scheduler.html
private class TaskRetentionTest

    static testmethod void schedulerTest() 
        String CRON_EXP = '0 0 0 15 3 ? *';
        // Create your test data
        Account acc = new Account();
        acc.name= 'test';
        insert acc;

		List<Task> tasks = new List<Task>();
        for(Integer i=0 ;i <10 ; i++)
			Task u = new Task();
			u.Subject='Run Test Trigger';
			u.Status='Not Started';
			u.CreatedDate =System.today()-i;
			u.WhatId =acc.id; 
        insert tasks ;

            String jobId = System.schedule('TaskRetentionTEst',  CRON_EXP, new TaskRetention() );
            CronTrigger ct = [SELECT Id, CronExpression, TimesTriggered, NextFireTime FROM CronTrigger WHERE id = :jobId];
            System.assertEquals(CRON_EXP, ct.CronExpression);
            System.assertEquals(0, ct.TimesTriggered);

        // Add assert here to validate result
Let us know if this will help you
Patrick ConnerPatrick Conner
Thank you both! Amit, thanks for the link as well. I will indeed spend some time learning more about writing test classes for schedular classes.
Amit Chaudhary 8Amit Chaudhary 8
Hi Patrick Conner

I will recommend you to start using trailhead to learn about test classes
1) https://trailhead.salesforce.com/modules/apex_testing

Also please check below post
1) https://developer.salesforce.com/docs/atlas.en-us.apexcode.meta/apexcode/apex_qs_test.htm
2) https://developer.salesforce.com/docs/atlas.en-us.apexcode.meta/apexcode/apex_testing_example.htm

Pleasse check below post sample test class
1) http://amitsalesforce.blogspot.com/2015/06/best-practice-for-test-classes-sample.html

Please follow below salesforce Best Practice for Test Classes :-

1. Test class must start with @isTest annotation if class class version is more than 25
2. Test environment support @testVisible , @testSetUp as well
3. Unit test is to test particular piece of code working properly or not .
4. Unit test method takes no argument ,commit no data to database ,send no email ,flagged with testMethod keyword .
5. To deploy to production at-least 75% code coverage is required
6. System.debug statement are not counted as a part of apex code limit.
7. Test method and test classes are not counted as a part of code limit
9. We should not focus on the  percentage of code coverage ,we should make sure that every use case should covered including positive, negative,bulk and single record .
Single Action -To verify that the the single record produces the correct an expected result .
Bulk action -Any apex record trigger ,class or extension must be invoked for 1-200 records .
Positive behavior : Test every expected behavior occurs through every expected permutation , i,e user filled out every correctly data and not go past the limit .
Negative Testcase :-Not to add future date , Not to specify negative amount.
Restricted User :-Test whether a user with restricted access used in your code .
10. Test class should be annotated with @isTest .
11 . @isTest annotation with test method  is equivalent to testMethod keyword .
12. Test method should static and no void return type .
13. Test class and method default access is private ,no matter to add access specifier .
14. classes with @isTest annotation can't be a interface or enum .
15. Test method code can't be invoked by non test request .
16. Stating with salesforce API 28.0 test method can not reside inside non test classes .
17. @Testvisible annotation to make visible private methods inside test classes.
18. Test method can not be used to test web-service call out . Please use call out mock .
19. You can't  send email from test method.
20.User, profile, organization, AsyncApexjob, Corntrigger, RecordType, ApexClass, ApexComponent ,ApexPage we can access without (seeAllData=true) .
21. SeeAllData=true will not work for API 23 version eailer .
22. Accessing static resource test records in test class e,g List<Account> accList=Test.loadData(Account,SobjectType,'ResourceName').
23. Create TestFactory class with @isTest annotation to exclude from organization code size limit .
24. @testSetup to create test records once in a method  and use in every test method in the test class .
25. We can run unit test by using Salesforce Standard UI,Force.com IDE ,Console ,API.
26. Maximum number of test classes run per 24 hour of period is  not grater of 500 or 10 multiplication of test classes of your organization.
27. As apex runs in system mode so the permission and record sharing are not taken into account . So we need to use system.runAs to enforce record sharing .
28. System.runAs will not enforce user permission or field level permission .
29. Every test to runAs count against the total number of DML issued in the process .

Please let us know if this post will help you