function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Bryan JimenezBryan Jimenez 

SOQL query Apex test

I am new to apex testing and I am stuck on writing a test class for my production org. I had to write a custom controller for a visualforce page I created and now I have to test this code in order to transfer it to my production org. I have no idea what to do in order to test a soql query despite trying the salesforce examples. Any help is greatly appreciated.
public class LoanProspectsController {
    Public List<Prospect__c> getProspects() {
        List<Prospect__c> Prospects=[Select Name,Email__c
                                     From Prospect__c
                                     Where Loan_Amount__c = 9];
        return Prospects;
    }
}
This is my custom controller which I used to query loan prospects with a loan amount of 9.

How am i able to test this?

 
Best Answer chosen by Bryan Jimenez
Amit Chaudhary 8Amit Chaudhary 8
Sorry for typo. Please try below code.
 
@isTest
public class LoanProspectsControllerTest 
{ 
    public static testMethod void TestSOQL() 
	{
		Prospect__c pros = new Prospect__c();
		// Add all required field
		pros.Name='demo;
		pros.Loan_Amount__c = 9;
		insert pros;


		LoanProspectsController  testCont = new LoanProspectsController ();
		List<Prospect__c> lstProspect = testCont.getProspects();
		
		System.assert( lstProspect  != null);
		
	}
}

Let us know if this will help you

All Answers

Amit Chaudhary 8Amit Chaudhary 8
Please try below code.
@isTest
public class LoanProspectsControllerTest 
{ 
    public static testMethod void TestSOQL() 
	{
		Prospect__c pros = new Prospect__c();
		// Add all required field
		pros.Name='demo;
		pros.Loan_Amount__c = 9;
		insert pros;


		LoanProspectsController  testCont = new LoanProspectsController ();
		List<Prospect__c> lstProspect = testCont.getProspects();
		
		System.assert( lstProspect.entList  != null);
		
	}
}

Please check below post for test classes.
1) http://amitsalesforce.blogspot.in/search/label/Test%20Class
2) http://amitsalesforce.blogspot.in/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

 
Bryan JimenezBryan Jimenez
Hi Amit,
Thank you for you response.
I am getting an error on line 16.

User-added image
Amit Chaudhary 8Amit Chaudhary 8
Sorry for typo. Please try below code.
 
@isTest
public class LoanProspectsControllerTest 
{ 
    public static testMethod void TestSOQL() 
	{
		Prospect__c pros = new Prospect__c();
		// Add all required field
		pros.Name='demo;
		pros.Loan_Amount__c = 9;
		insert pros;


		LoanProspectsController  testCont = new LoanProspectsController ();
		List<Prospect__c> lstProspect = testCont.getProspects();
		
		System.assert( lstProspect  != null);
		
	}
}

Let us know if this will help you
This was selected as the best answer
Bryan JimenezBryan Jimenez
This worked great! Thanks a lot!
Bryan JimenezBryan Jimenez
Hi Amit,

I tried to write another test class with the example you gave me.
I am however getting an error. Why is that?

User-added image
Akanksha  PatelAkanksha Patel
Hi Bryan,

Please use 
pros.Created_Date__c = Date.Today().addDays(-1) ;
Bryan JimenezBryan Jimenez
After implementing this code I realized that I had to do another test class when changing the fields?

My new custom controller is this one.
public class LoanProspectControllerYesterday {
	Public List<Prospect__c> getProspects() {
        List<Prospect__c> Prospects=[Select Name,Email__c
                                     From Prospect__c 
                                     Where Created_Date__c = Yesterday
                                     And RecordType__c = 'Loan Prospect'];
        return Prospects;
    }
}

and my test class is this one.
 
@isTest
public class LoanProspectsControllerYesterdayTest 
{ 
    public static testMethod void TestSOQL() 
	{
		Prospect__c pros = new Prospect__c();
		// Add all required field
		pros.Name='demo';
		pros.Created_Date__c = System.today() -1;
		insert pros;


		LoanProspectsControllerYesterday  testCont = new LoanProspectsControllerYesterday ();
		List<Prospect__c> lstProspect = testCont.getProspects();
		
		System.assert( lstProspect != null);
		
	}
}

However I am getting an error on line 13.


User-added image
Akanksha  PatelAkanksha Patel
Hi Bryan,

There is a space in between between LoanProspectsControllerYesterday & (); Please remove that space and it will work fine.

Thanks
Akanksha
Akanksha  PatelAkanksha Patel
Copy this in Line13
LoanProspectsControllerYesterday  testCont = new LoanProspectsControllerYesterday();
Bryan JimenezBryan Jimenez
Thank you, This worked really well!