-
Notifications
You must be signed in to change notification settings - Fork 519
DMLRecipes
Demonstrates various ways of making Data Manipulation Language (DML) calls. Note that this class demonstrates both Database.* methods as well as DML Keywords.
Deletes a list of accounts via the Database.delete method
| Param | Description |
|---|---|
accts |
List of Accounts to delete |
List<Account> accounts = new List<Account>{new Account(name = 'Hello World')};
insert accounts;
DMLRecipes.deleteAccountViaDatabaseMethod(accounts);Deletes a list of accounts via the delete DML keyword
| Param | Description |
|---|---|
accts |
list of accounts to delete |
List<Account> accounts = new List<Account>{new Account(name = 'Hello World')};
insert accounts;
DMLRecipes.deleteAccountViaDatabaseMethod(accounts);Demonstrates how to use the insert keyword to persist a net-new record to the database
| Param | Description |
|---|---|
name |
name passed through to the name of the created account |
DMLRecipes.insertAccountViaInsertKeyword('Hello');Demonstrates how to use the Database.insert() method to persist a net-new record to the database.
| Param | Description |
|---|---|
name |
name Passed through to the account created |
allOrNothing |
allOrNothing determines whether or not all accounts |
DMLRecipes.insertAccountsViaDatabaseMethod('Hello', false);undeletes a list of accounts via the Database.undelete method.
| Param | Description |
|---|---|
accts |
list of accounts to undelete |
Type
List<Account>
Description
List<Account>
List<Account> accounts = new List<Account>{new Account(name = 'Hello World')};
insert accounts;
delete accounts;
List<Account> results = DMLRecipes.undeleteAccountViaDatabaseMethod(accounts);
System.debug(results);Undeletes a list of accounts via the undelete DML keyword
| Param | Description |
|---|---|
accts |
List of accounts to undelete |
Type
List<Account>
Description
List<Account>
List<Account> accounts = new List<Account>{new Account(name = 'Hello World')};
insert accounts;
delete accounts;
List<Account> results = DMLRecipes.undeleteAccountViaKeyword(accounts);
System.debug(results);Demonstrates how to Update a list of accounts via the Update DML keyword
| Param | Description |
|---|---|
accts |
List of accounts to update |
Type
List<Account>
Description
List<Account>
Account acct = new Account(name='Hello World');
insert acct;
DMLRecipes.updateAcccountViaKeyword(acct);Demonstrates how to update a list of accounts via the Database.update() method
| Param | Description |
|---|---|
accts |
list of accounts to update |
Type
List<Account>
Description
List<Account>
List<Account> accounts = new List<Account>{new Account(name = 'Hello World')};
insert accounts;
List<Account> results = DMLRecipes.updateAccountViaDatabaseMethod(accounts);
System.debug(results);Upserts an account with a potential of all or nothing, using the Database.upsert method
| Param | Description |
|---|---|
acct |
The account object to upsert |
allOrNothing |
all or nothing flag |
Type
Database.UpsertResult
Description
UpsertResult
DMLRecipes.upsertAccountViaDatabaseMethod(
new Account(name='Hello World'), false);Demonstrates the use of the upsert keyword to either insert or update a record
| Param | Description |
|---|---|
acct |
account to upsert |
Type
Account
Description
Account
DMLRecipes.upsertAccountViaUpsertKeyword(new Account(name='Hello World'));This exception is for throwing a custom exception to highlight how negative tests operate.