What is a Database class?
A database class is a class that consists of methods that can help us to make changes in the database or to fetch data from the database.
What Is Database Class Method Result Object?
Database class methods returns the result of data operations. These result object contain useful information about data for each record such as whether the operation is successful or not and any other information.
Each type of operations returns a specific result object type, following are:
Operation | Result Class |
Insert, update | Save Result Class |
upsert | Upsert Result Class |
merge | Merge Result Class |
delete | Delete Result Class |
undelete | Undelete Result Class |
convertLead | Lead Convert Result Class |
emptyRecycleBin | Empty Recycle Bin Class Result |
Database Class Method Example
public static void main() {
List < Account > accList = new List < Account > ();
for (integer i = 0; i < 10; i++) {
accList.add(new Account(name = ’Result Test’ + i, numberOfEmployees = i));
accList.add(new Account());
insert accList;
}
System.debug(‘Total Accounts: ’+accList.size());
Database.SaveResult[] saveList = Database.insert(accList, false);
for (Database.SaveResult s: saveList) {
If(s.isSuccess())
System.debug(‘I was successful = ’+s.getID());
else {
System.debug(‘I was Unsuccessful = ’+s.getID + ’because of following errors’);
for (Database.error dr: s.getErrors()) {
System.debug(dr.getStatusCode() + ’’ +dr.getMessage());
System.debug(‘fields affected by insertion are: ’+dr.getFields);
}
}
}
}
