APEX & SOQL & SOSL - astromechanic/cheat_sheets GitHub Wiki

for (ChildRelationship relation : SObjectType.ObjectName.getChildRelationships())
    System.debug(relation.getRelationshipName());

Account acct = new Account(
    Name='SFDC Computing',
    Phone='(415)555-1212',
    NumberOfEmployees=50,
    BillingCity='San Francisco');
insert acct;

select Name, Phone from Account where Name='Acme'
select fields(all) from OrderItem limit 200
select Name, Phone from Account where (Name='Acme' and NumberOfEmployees>50)
select Name from Account where Name like 'Acme%' 

List<Integer> listOfNumbers = new List<Integer>();
listOfNumbers.add(1);
listOfNumbers.add(2);

Map<Integer, String> mapOfStrings = new Map<Integer, String>();
mapOfStrings.put(1, 'cat');
mapOfStrings.put(2, 'dog');
mapOfStrings.put(3, 'fish');

Datetime currentDateTime = Datetime.now();

switch on expression{
   when value1 {
      ...
   }
   when value2 {
      ...
   }
}

@InvocableMethod(label='Change Price')
public static void changePrice(..) {
   ...
}

trigger TriggerName on ObjectName (trigger_events) {

}

List<String> caseTypeValues = new List<String>();
Schema.DescribeFieldResult fieldResult = Case.Type.getDescribe();
List<Schema.PicklistEntry> ple = fieldResult.getPicklistValues();
for( Schema.PicklistEntry pickListVal : ple){
  caseTypeValues.add(pickListVal.getLabel());
}

Http http = new Http();
HttpRequest request = new HttpRequest();
request.setEndpoint('https://th-apex-http-callout.herokuapp.com/animals');
request.setMethod('GET');
HttpResponse response = http.send(request);
// If the request is successful, parse the JSON response.
if(response.getStatusCode() == 200) {
    // Deserialize the JSON string into collections of primitive data types.
    Map<String, Object> results = (Map<String, Object>) JSON.deserializeUntyped(response.getBody());
    // Cast the values in the 'animals' key as a list
    List<Object> animals = (List<Object>) results.get('animals');
    System.debug('Received the following animals:');
    for(Object animal: animals) {
        System.debug(animal);
    }
}

@isTest
private class AnimalsCalloutsTest {
    @isTest static  void testGetCallout() {
        // Create the mock response based on a static resource
        StaticResourceCalloutMock mock = new StaticResourceCalloutMock();
        mock.setStaticResource('GetAnimalResource');
        mock.setStatusCode(200);
        mock.setHeader('Content-Type', 'application/json;charset=UTF-8');
        // Associate the callout with a mock response
        Test.setMock(HttpCalloutMock.class, mock);
        // Call method to test
        HttpResponse result = AnimalsCallouts.makeGetCallout();
        // Verify mock response is not null
        System.assertNotEquals(null,result, 'The callout returned a null response.');
        // Verify status code
        System.assertEquals(200,result.getStatusCode(), 'The status code is not 200.');
        // Verify content type   
        System.assertEquals('application/json;charset=UTF-8',
          result.getHeader('Content-Type'),
          'The content type value is not expected.');  
        // Verify the array contains 3 items     
        Map<String, Object> results = (Map<String, Object>) 
            JSON.deserializeUntyped(result.getBody());
        List<Object> animals = (List<Object>) results.get('animals');
        System.assertEquals(3, animals.size(), 'The array should only contain 3 items.');          
    }   
}

@IsTest
global class AnimalsHttpCalloutMock implements HttpCalloutMock {
    // Implement this interface method
    global HTTPResponse respond(HTTPRequest request) {
        // Create a fake response
        HttpResponse response = new HttpResponse();
        response.setHeader('Content-Type', 'application/json');
        response.setBody('{"animals": ["majestic badger", "fluffy bunny", "scary bear", "chicken", "mighty moose"]}');
        response.setStatusCode(200);
        return response; 
    }
}

@IsTest static void testPostCallout() {
        // Set mock callout class 
        Test.setMock(HttpCalloutMock.class, new AnimalsHttpCalloutMock()); 
        // This causes a fake response to be sent
        // from the class that implements HttpCalloutMock. 
        HttpResponse response = AnimalsCallouts.makePostCallout();
        // Verify that the response received contains fake values
        String contentType = response.getHeader('Content-Type');
        System.assert(contentType == 'application/json');
        String actualValue = response.getBody();
        System.debug(response.getBody());
        String expectedValue = '{"animals": ["majestic badger", "fluffy bunny", "scary bear", "chicken", "mighty moose"]}';
        System.assertEquals(expectedValue, actualValue);
        System.assertEquals(200, response.getStatusCode());
    }

Map<ID, Contact> m = new Map<ID, Contact>([SELECT Id, LastName FROM Contact]);

Map<Id,OBJ_TYPE> mapFromList = new Map<Id,OBJ_TYPE>(List_object_variable);

public static Map<String, String> getPicklistFieldValues() {
    Map<String, String> options = new Map<String, String>();
    Schema.DescribeFieldResult fr = ObjectName.FieldName.getDescribe();
    List<Schema.PicklistEntry> plValues = fr.getPicklistValues();
    for (Schema.PicklistEntry p : plValues) {
        options.put(p.getValue(), p.getLabel());
    }
    return options;
}