Merging Records

1// Insert new accounts
2List<Account> ls = new List<Account>{
3    new Account(name='Acme Inc.'),
4        new Account(name='Acme')
5        };                                        
6insert ls;
7
8// Queries to get the inserted accounts 
9Account mainAcct = [SELECT Id, Name FROM Account WHERE Name = 'Acme Inc.' LIMIT 1];
10Account dupAcct = [SELECT Id, Name FROM Account WHERE Name = 'Acme' LIMIT 1];
11
12// Add a contact to the account to be merged
13Contact c = new Contact(FirstName='Joe',LastName='Merged');
14c.AccountId = dupAcct.Id;
15insert c;
16
17try {
18    merge mainAcct dupAcct;
19} catch (DmlException e) {
20    // Process exception
21    System.debug('An unexpected error has occurred: ' + e.getMessage()); 
22}
23
24// After the account is merged with the main account,
25// the related contact is moved to the main record.
26mainAcct = [SELECT Id, Name, (SELECT FirstName,LastName From Contacts) 
27              FROM Account WHERE Name = 'Acme Inc.' LIMIT 1];
28System.assert(mainAcct.getSObjects('Contacts').size() > 0);
29System.assertEquals('Joe', mainAcct.getSObjects('Contacts')[0].get('FirstName'));
30System.assertEquals('Merged', mainAcct.getSObjects('Contacts')[0].get('LastName'));
31
32// Verify that the duplicate record is deleted
33Account[] result = [SELECT Id, Name FROM Account WHERE Id=:dupAcct.Id];
34System.assertEquals(0, result.size());

1// Create main account
2Account main = new Account(Name='Account1');
3insert main;
4
5// Create duplicate accounts
6Account[] duplicates = new Account[]{
7    // Duplicate account 
8    new Account(Name='Account1, Inc.'),
9    // Second duplicate account
10    new Account(Name='Account 1')
11};
12insert duplicates;
13
14// Create child contact and associate it with first account
15Contact c = new Contact(firstname='Joe',lastname='Smith', accountId=duplicates[0].Id);
16insert c;
17
18
19
20// Get the account contact relation ID, which is created when a contact is created on "Account1, Inc." 
21AccountContactRelation resultAcrel = [SELECT Id FROM AccountContactRelation WHERE ContactId=:c.Id LIMIT 1];
22
23
24// Merge duplicate accounts into main account
25Database.MergeResult[] results = Database.merge(main, duplicates, false);
26
27for(Database.MergeResult res : results) {
28    if (res.isSuccess()) {
29        // Get the main record ID from the result and validate it
30        System.debug('Main record ID: ' + res.getId());
31        System.assertEquals(main.Id, res.getId());              
32        
33        // Get the IDs of the merged records and display them
34        List<Id> mergedIds = res.getMergedRecordIds();
35        System.debug('IDs of merged records: ' + mergedIds);                
36        
37        // Get the ID of the reparented record and 
38        // validate that this the contact ID.
39        System.debug('Reparented record ID: ' + res.getUpdatedRelatedIds());
40
41	 // Make sure there are two IDs (contact ID and account contact relation ID); the order isn't defined
42        System.assertEquals(2, res.getUpdatedRelatedIds().size() );    
43        boolean flag1 = false;
44	boolean flag2 = false;
45
46
47    	// Because the order of the IDs isn't defined, the ID can be at index 0 or 1 of the array	     
48        if (resultAcrel.id == res.getUpdatedRelatedIds()[0] || resultAcrel.id == res.getUpdatedRelatedIds()[1] )
49            	flag1 = true;
50        
51       if (c.id == res.getUpdatedRelatedIds()[0] || c.id == res.getUpdatedRelatedIds()[1] )
52            flag2 = true;
53            
54        System.assertEquals(flag1, true); 
55        System.assertEquals(flag2, true);  
56            
57    }
58    else {
59        for(Database.Error err : res.getErrors()) {
60            // Write each error to the debug output
61            System.debug(err.getMessage());
62        }
63    }
64}