lfreeland

String idInClause = '(\'';

for (Id acctId : accountIds){

    idInClause += acctId + ‘\’,\’’;

}

idInClause  = idInClause.substring(0,idInClause.length()-2);
idInClause += ')';

lfreeland

Set<Id> accountIds = …

/* The accountIds variable is directly embedded in the accountQuery string and binded

   against in Database.query

*/

String accountQuery = ‘select id, name from Account where Id in :accountIds’;

lfreeland

String accountQuery = ‘Select id, name from Account where Id in :getAccountids()’;

lfreeland

Account acct = new Account(Id = ‘Some_Acct_Id_Here’);

String accountQuery = ‘Select id, name from Account where Id = :acct.Id’;

lfreeland

// Valid Dynamic SOQL from function
Set<Id> accountIds = getAccountids();
String accountQuery = ‘Select id, name from Account where Id in :accountIds’;

// Valid Dynamic SOQL from SObject
Account acct = new Account(Id = ‘Some_Acct_Id_Here’);
Id accountId = acct.Id;

String accountQuery = ‘Select id, name from Account where Id = :accountId’;

lfreeland

/**
 * @description Builder class for dealing with Account records.
 * Solely used for testing, NOT a data factory.
 **/
@isTest
public class AccountTestData extends SObjectTestData {

    /**
     * @description Overridden method to set up the default
     * Account state for AccountTestData.

lfreeland

String format = 'Select Id from Account where Id = \'{0}\'';
String Id = '<some_id>';

String query = String.format(format, new List<String>{ Id });


system.debug('   query is ' + query);

// Output: query is Select Id from Account where Id = {0}

lfreeland

String format = 'Select Id from Account where Id = {0}';
String Id = '<some_id>';

String query = String.format(format, new List<String>{ Id });

system.debug('   query is ' + query);

// Output: query is Select Id from Account where Id = <some_id>

lfreeland

String format = 'Select Id from Account where Id = \'\'{0}\'\'';
String Id = '<some_id>';

String query = String.format(format, new List<String>{ Id });

system.debug('   query is ' + query);

// Output: query is Select Id from Account where Id = '<some_id>'

lfreeland

    public static List<Database.UpsertResult> upsertListSObjectsWithExternalIdNoAllOrNothingErrorExample() {
        List<SObject> records = new List<SObject>();
        
        Account a = new Account(
            Name = 'Example Company',
            External_Id__c = 'ExampleCompany'
        );
        
        records.add(a);