Skip to content

DMLRecipes

Jump to bottom
pozil edited this page Nov 14, 2024 · 18 revisions

DMLRecipes

Demonstrates various ways of making Data Manipulation Language (DML) calls. Note that this class demonstrates both Database methods as well as DML Keywords.

Group Data Recipes

Methods

public static Account insertAccountViaInsertKeywordInSystemMode(String name)

Demonstrates how to use the insert keyword to persist a net-new record to the database in system mode

Parameters

Param Description
name name of the created account

Returns

Type Description
Account the inserted Account

Example

DMLRecipes.insertAccountViaInsertKeywordInSystemMode('Hello');

public static Account insertAccountViaInsertKeywordInUserMode(String name)

Demonstrates how to use the insert keyword to persist a net-new record to the database in user mode

Parameters

Param Description
name name of the created account

Returns

Type Description
Account the inserted Account

Example

DMLRecipes.insertAccountViaInsertKeywordInUserMode('Hello');

public static List<Account> insertAccountsViaDatabaseMethod(List<String> names, Boolean allOrNothing, System.AccessLevel accessLevel)

Demonstrates how to use the Database.insert() method to persist a net-new record to the database.

Parameters

Param Description
names names used for account creation
allOrNothing determines whether or not all accounts to be inserted must insert successfully

Returns

Type Description
List<Account> list of inserted accounts

Example

DMLRecipes.insertAccountsViaDatabaseMethod('Hello', false, AccessLevel.USER_MODE);

public static Account upsertAccountViaUpsertKeywordInSystemMode(Account acct)

Demonstrates the use of the upsert keyword to either insert or update a record in system mode

Parameters

Param Description
acct account to upsert

Returns

Type Description
Account Upserted Account record

Example

DMLRecipes.upsertAccountViaUpsertKeywordInSystemMode(new Account(name='Hello World'));

public static Account upsertAccountViaUpsertKeywordInUserMode(Account acct)

Demonstrates the use of the upsert keyword to either insert or update a record in user mode

Parameters

Param Description
acct account to upsert

Returns

Type Description
Account Upserted Account record

Example

DMLRecipes.upsertAccountViaUpsertKeywordInUserMode(new Account(name='Hello World'));

public static Database.UpsertResult upsertAccountViaDatabaseMethod(Account acct, Boolean allOrNothing, System.AccessLevel accessLevel)

Upserts an account with a potential of all or nothing, using the Database.upsert method

Parameters

Param Description
acct The account object to upsert
allOrNothing all or nothing flag

Returns

Type Description
Database.UpsertResult Upsert operation result

Example

DMLRecipes.upsertAccountViaDatabaseMethod(
           new Account(Name='Hello World'), false, AccessLevel.USER_MODE);

public static List<Account> updateAcccountViaKeywordInSystemMode(List<Account> accts)

Demonstrates how to Update a list of accounts via the update DML keyword in System Mode

Parameters

Param Description
accts List of accounts to update

Returns

Type Description
List<Account> List of updated records

Example

Account acct = new Account(name='Hello World');
insert acct;
DMLRecipes.updateAcccountViaKeywordInSystemMode(acct);

public static List<Account> updateAcccountViaKeywordInUserMode(List<Account> accts)

Demonstrates how to Update a list of accounts via the update DML keyword

Parameters

Param Description
accts List of accounts to update

Returns

Type Description
List<Account> List of updated records

Example

Account acct = new Account(name='Hello World');
insert acct;
DMLRecipes.updateAcccountViaKeyword(acct);

public static List<Account> updateAccountViaDatabaseMethod(List<Account> accts, System.AccessLevel accessLevel)

Demonstrates how to update a list of accounts via the Database.update() method

Parameters

Param Description
accts list of accounts to update

Returns

Type Description
List<Account> List of updated records

Example

List<Account> accounts = new List<Account>{new Account(name = 'Hello World')};
insert accounts;
List<Account> results = DMLRecipes.updateAccountViaDatabaseMethod(accounts, AccessLevel.USER_MODE);
System.debug(results);

public static void deleteAccountViaKeywordInSystemMode(List<Account> accts)

Deletes a list of accounts via the delete DML keyword

Parameters

Param Description
accts list of accounts to delete in system mode

Example

List<Account> accounts = new List<Account>{new Account(name = 'Hello World')};
insert accounts;
DMLRecipes.deleteAccountViaKeywordInSystemMode(accounts);

public static void deleteAccountViaKeywordInUserMode(List<Account> accts)

Deletes a list of accounts via the delete DML keyword

Parameters

Param Description
accts list of accounts to delete in user mode

Example

List<Account> accounts = new List<Account>{new Account(name = 'Hello World')};
insert accounts;
DMLRecipes.deleteAccountViaKeywordInUserMode(accounts);

public static void deleteAccountViaDatabaseMethod(List<Account> accts, System.AccessLevel accessLevel)

Deletes a list of accounts via the Database.delete method

Parameters

Param Description
accts List of Accounts to delete

Example

List<Account> accounts = new List<Account>{new Account(name = 'Hello World')};
insert accounts in user mode;
DMLRecipes.deleteAccountViaDatabaseMethod(accounts, AccessLevel.USER_MODE);

public static List<Account> undeleteAccountViaKeywordInSystemMode(List<Account> accts)

Undeletes a list of accounts via the undelete DML keyword

Parameters

Param Description
accts List of accounts to undelete in user mode

Returns

Type Description
List<Account> list of undeleted accounts

Example

List<Account> accounts = new List<Account>{new Account(name = 'Hello World')};
insert accounts;
delete accounts;
List<Account> results = DMLRecipes.undeleteAccountViaKeywordInSystemMode(accounts);
System.debug(results);

public static List<Account> undeleteAccountViaKeywordInUserMode(List<Account> accts)

Undeletes a list of accounts via the undelete DML keyword

Parameters

Param Description
accts List of accounts to undelete in user mode

Returns

Type Description
List<Account> list of undeleted accounts

Example

List<Account> accounts = new List<Account>{new Account(name = 'Hello World')};
insert accounts;
delete accounts;
List<Account> results = DMLRecipes.undeleteAccountViaKeywordInUserMode(accounts);
System.debug(results);

public static List<Account> undeleteAccountViaDatabaseMethod(List<Account> accts, System.AccessLevel accessLevel)

undeletes a list of accounts via the Database.undelete method.

Parameters

Param Description
accts list of accounts to undelete

Returns

Type Description
List<Account> list of undeleted accounts

Example

List<Account> accounts = new List<Account>{new Account(name = 'Hello World')};
insert accounts;
delete accounts;
List<Account> results = DMLRecipes.undeleteAccountViaDatabaseMethod(accounts, AccessLevel.USER_MODE);
System.debug(results);

Classes

CustomDMLException

This exception is for throwing a custom exception to highlight how negative tests operate.

Inheritance

CustomDMLException

Clone this wiki locally