hi this is my trigger to test duplicate between two email address which is working fine and also it allows duplicate if the checkbox "allow_duplicate__c" is selected, but there is a problem with test method

my trigger

trigger AccountDuplicatePreventer2 on Account
                               (before insert, before update) {

    Map<String, Account> AccountMap = new Map<String, Account>();
    for (Account Account : System.Trigger.new) {

        // Make sure we don't treat an Email__c address that  
        // isn't changing during an update as a duplicate.  

        if ((Account.Email__c != null) &&
                (System.Trigger.isInsert ||
                (Account.Email__c != 
                    System.Trigger.oldMap.get(Account.Id).Email__c))) {

            // Make sure another new Account isn't also a duplicate  

            if (AccountMap.containsKey(Account.Email__c)) {
                Account.Email__c.addError('Another new Account has the '
                                    + 'same Email address.');
            } else {
                AccountMap.put(Account.Email__c, Account);

       if ((Account.Email1__c != null) &&
                (System.Trigger.isInsert ||
                (Account.Email1__c != 
                    System.Trigger.oldMap.get(Account.Id).Email1__c))) {

            // Make sure another new Account isn't also a duplicate  

            if (AccountMap.containsKey(Account.Email1__c)) {
                Account.Email1__c.addError('Another new Account has the '
                                    + 'same Email address.');
            } else {
                AccountMap.put(Account.Email1__c, Account);

    // Using a single database query, find all the Accounts in  

    // the database that have the same Email__c address as any  

    // of the Accounts being inserted or updated.  

    for (Account Account : [SELECT Email__c FROM Account WHERE Email__c IN :AccountMap.KeySet()]) {

        Account newAccount = AccountMap.get(Account.Email__c);
        newAccount.Allow_Duplicate__c.addError('A Account with this Email aldready exists. '+ 'Select this checkbox to proceed.');

    for (Account Account : [SELECT Email1__c FROM Account WHERE Email1__c IN :AccountMap.KeySet()]) {

        Account newAccount = AccountMap.get(Account.Email1__c);
        newAccount.Allow_Duplicate__c.addError('A Account with this Email aldready exists. '+ 'Select this checkbox to proceed.');

this is my test class and one method to check email__c

private class email_dup1{

    static testmethod void ee_dup(){

      Set<String> testEmailAddress = new Set<String>();
      System.assert([SELECT count() FROM Account WHERE Email__c IN :testEmailAddress] == 0);

      Account Account1 = new Account(LastName='Test1', PersonMobilePhone='123',
      Account Account2 = new Account(LastName='Test2', PersonMobilePhone='123',
      Account Account3 = new Account(LastName='Test3', PersonMobilePhone='123',
      Account[] Accounts = new Account[] {Account1, Account2, Account3};
      insert Accounts;

      Account2.Email__c = 'test2@duptest.com';
      Account3.Email__c = 'test3@duptest.com';
      update Accounts;

       Account dup1 = new Account(LastName='Test1Dup',
                           PersonMobilePhone='Test1Dup Inc.',allow_duplicate__c = false,
      try {
         insert dup1;
      } catch (DmlException e) {
         System.assert(e.getNumDml() == 1);
         System.assert(e.getDmlIndex(0) == 0);
         System.assert(e.getDmlFields(0).size() == 1);
         System.assert(e.getDmlFields(0)[0].getDescribe().getName() == 'Email__c');
            'A Account with this Email aldready exists. '+ 'Select this checkbox to proceed.') > -1);


System.AssertException: Assertion Failed

this the error which i'm facing for this line of code

System.assert(e.getDmlFields(0)[0].getDescribe().getName() == 'Email__c');
  • for loop has been covered already. – Ganesh Bhosle Jan 30 '14 at 11:16

put Con_Email__pc field values same in all insert account statement. You have made the different.

  for (Account Account : [SELECT Con_Email__pc FROM Account WHERE Con_Email__pc IN :AccountMap.KeySet()]) 
          Account newAccount = AccountMap.get(Account.Con_Email__pc);
          newAccount.Con_Email__pc.addError('Email is already exist');

In this statement you are only checking duplicate for Con_Email__pc field and in test data you have not inserted any duplicate value in Con_Email__pc field.

acc.Con_Email__pc = 'ac@gmail.com';
insert acc;
acc1.Con_Email__pc = 'ac@gmail.com';
insert acc1;
acc2.Con_Email__pc = 'ac@gmail.com';
insert acc2;

Hope this will help.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.