com.retek.component.customer.impl.persistence.db.oracle
Class OracleCustomerDaoTest

java.lang.Object
  extended byjunit.framework.Assert
      extended byjunit.framework.TestCase
          extended bycom.retek.commons.util.RetekTestCase
              extended bycom.retek.commons.domain.core.persistence.db.oracle.OracleTestCase
                  extended bycom.retek.component.customer.impl.persistence.db.oracle.CustomerOracleTestCase
                      extended bycom.retek.component.customer.impl.persistence.db.oracle.OracleCustomerDaoTest
All Implemented Interfaces:
junit.framework.Test

public class OracleCustomerDaoTest
extends CustomerOracleTestCase


Field Summary
 
Fields inherited from class com.retek.commons.util.RetekTestCase
BEGIN_PROFILING, END_PROFILING
 
Constructor Summary
OracleCustomerDaoTest(java.lang.String name)
           
 
Method Summary
 void doSetUp()
           
 void doTearDown()
           
static junit.framework.TestSuite suite()
           
 void testCreateAndReadCustomer()
           
 void testCreateAndReadCustomerWithCreditCards()
           
 void testCreateAndReadCustomerWithoutSalutationAndSuffix()
           
 void testCreateCustomerAndUpdatePreferences()
           
 void testCreateCustomerWithAuditInfo()
           
 void testCreateCustomerWithoutEmailAddress()
           
 void testCreateReadAndUpdateStoredValueCardCashout()
           
 void testCreateReadUpdateCustomerCreditPreApproval()
           
 void testCreateReferenceCacheForCustomer()
           
 void testCreateReferenceCacheForCustomerAddress()
           
 void testCreateReferenceCacheForCustomerCreditCard()
           
 void testCreateReferenceCacheForCustomerCreditPreApproval()
           
 void testCreateReferenceCacheForCustomerEmailAddress()
           
 void testCreateReferenceCacheForCustomerPreference()
           
 void testCreateReferenceCacheForCustomerTelephonee()
           
 void testCreateReferenceCacheForStoredValueCardCashout()
           
 void testCreateWithPrimaryPhoneNumbers()
           
 void testCustomerCreditCardUpdate()
           
 void testCustomerImportProcessed()
           
 void testCustomerSubmitForAddresses()
           
 void testFindAllCustomerAddressChangeReason()
           
 void testFindAllCustomerInactiveReasons()
           
 void testFindByAddressWithFullPostalCode()
           
 void testFindByAddressWithoutPostalCode()
           
 void testFindByEmail()
           
 void testFindByEmailWithUnderscore()
           
 void testFindCustomerByAddressDate()
           
 void testFindCustomerByCustomerAddressDate()
           
 void testFindCustomerByDate()
           
 void testFindCustomerByDisplayNumberMatchesCustomerId()
           
 void testFindCustomerByDisplayNumberMatchesHouseholdNumber()
           
 void testFindCustomerByLastName()
           
 void testFindCustomerByLastNameWithPercent()
           
 void testFindCustomerByLastNameWithWildCardAndPercent()
           
 void testFindCustomerCreditPreApproval()
           
 void testFindCustomerReferences()
           
 void testFindCustomerReferencesForActiveFalse()
           
 void testFindCustomerReferencesForActiveTrue()
           
 void testFindCustomerReferencesForCreatedAfterDate()
           
 void testFindCustomerReferencesForCreatedOrUpdatedAfterDate()
           
 void testFindCustomerReferencesForCreditCardNumber()
           
 void testFindCustomerReferencesForLastNameAlphaRangeBToC()
           
 void testFindCustomerReferencesForPrimaryBillToStates()
           
 void testFindCustomersWithWildcardInPostalCode()
           
 void testFindCustomerWithAllFieldSet()
           
 void testFindIgnoreCase()
           
 void testFindMultipleCustomersByFirstName()
           
 void testFindMultipleCustomersByMiddleInitial()
           
 void testFindNoResults()
           
 void testFindOnlyActiveCustomers()
           
 void testFindPartialPostalCode()
           
 void testFindPhone()
           
 void testFindReadCustomerSalutations()
           
 void testFindReadCustomerSuffixes()
           
 void testFindSorting()
           
 void testFindStoredValueCardCashoutsForResaExport()
           
 void testGetNextCustomerId()
           
 void testGetRandomLastName()
           
 void testInsertRandomCustomers()
           
 void testNextAddressSequenceValue()
           
 void testOracleCustomerEmailReteriver()
           
 void testPrimaryTelephoneUpdatesCorrectly()
           
 void testRandomInt()
           
 void testReadAndDeleteCustomer()
           
 void testReadCustomerChangeReason()
           
 void testReadCustomerEmailAddress()
           
 void testReadCustomerInactiveReason()
           
 void testReadCustomers()
           
 void testReadCustomerTelephone()
           
 void testReadStoredValueCardCashoutWithInvalidRef()
           
 void testUpdateAddressOnlyForAudit()
           
 void testUpdateCreditCardWithInvalidId()
           
 void testUpdateCustomer()
           
 void testUpdateCustomerAddressForAudit()
           
 void testUpdateCustomerEmailForAudit()
           
 void testUpdateCustomerEmailWithInvalidId()
           
 void testUpdateCustomerHeaderWithAuditInfo()
           
 void testUpdateCustomerPreferenceForAudit()
           
 void testUpdateCustomerPreferenceWithInvalidId()
           
 void testUpdateCustomerTelephoneForAudit()
           
 void testUpdateCustomerTelephoneWithInvalidId()
           
 void testUpdateCustomerWithInvalidId()
           
 void testUpdateMatchRule()
           
 void testUpdateMatchRuleWithInvalidId()
           
 
Methods inherited from class com.retek.component.customer.impl.persistence.db.oracle.CustomerOracleTestCase
areEqualIgnoringPostalCode, assertActivityRequestDtosAreEqual, assertActivityRequestTypeDtosAreEqual, assertAllChildDtosArePersistedAsWell, assertCatalogRequestDtosAreEqual, assertCatalogTypeDtosAreEqual, assertCountryDtosAreEqual, assertCustomerAddressDtosEqual, assertCustomerAddressListEquals, assertCustomerCreditCardDtoEqual, assertCustomerCreditCardPreApprovalDtosAreEqual, assertCustomerDtosAreEqual, assertCustomerEmailAddressDtosAreEqual, assertCustomerInactiveReasonDtoEuqals, assertCustomerTelephoneDtosAreEqual, assertPreferencesEquals, assertStoredValueCardCashoutDtoEuqals, assertStoredValueCardCashoutsEuqals, containsAllEmails, containsEmail, getConnectionKey, modifyActivityRequestDto, modifyActivityRequestType, modifyAllFieldsOnCustomerPreferenceDto, modifyCatalogTypeDto, modifyCustomerAddress, modifyCustomerCreditPreApprovalDto, modifyCustomerDto, modifyCustomerEmailAddressDto, modifyCustomerTelephoneDto, modifyStoredValueCardCashoutDto, modifyStoredValueCardCashouts, modifySuffixDto
 
Methods inherited from class com.retek.commons.domain.core.persistence.db.oracle.OracleTestCase
doInitialSetUp, getConnection, getRetekPreparedStatement, getTestDbRDate, isOracleTestCase, setUp, tearDown, touch, touch
 
Methods inherited from class com.retek.commons.util.RetekTestCase
assertBusinessException, assertBusinessExceptionAttribute, assertContainsString, assertDateEqualsIgnoreTime, assertDateNotEqualsIgnoreTime, assertDateTimeEquals, assertEquals, assertEqualValuesDeep, assertEqualValuesDeep, assertEqualValuesDeep, assertFalse, assertFalse, assertNotEquals, assertNotNullAndEquals, assertNull, assertRetekEquals, assertStateEquals, assertStateNotEquals, assertXmlEquals, findDto, findDto, getContext, getReadBackContext, getReferences, getReferences, resetSystemRDateToBusinessDay, runTest, setSecurityEncryption, setTaxSimulate
 
Methods inherited from class junit.framework.TestCase
countTestCases, createResult, getName, name, run, run, runBare, setName, toString
 
Methods inherited from class junit.framework.Assert
assert, assert, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertNotNull, assertNotNull, assertNull, assertSame, assertSame, assertTrue, assertTrue, fail, fail
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait
 

Constructor Detail

OracleCustomerDaoTest

public OracleCustomerDaoTest(java.lang.String name)
Method Detail

suite

public static junit.framework.TestSuite suite()

doSetUp

public void doSetUp()
             throws java.lang.Exception
Specified by:
doSetUp in class RetekTestCase
Throws:
java.lang.Exception

doTearDown

public void doTearDown()
Specified by:
doTearDown in class RetekTestCase

testCreateReferenceCacheForCustomer

public void testCreateReferenceCacheForCustomer()
                                         throws java.lang.Exception
Throws:
java.lang.Exception

testCreateReferenceCacheForCustomerAddress

public void testCreateReferenceCacheForCustomerAddress()
                                                throws java.lang.Exception
Throws:
java.lang.Exception

testCreateReferenceCacheForCustomerCreditCard

public void testCreateReferenceCacheForCustomerCreditCard()
                                                   throws java.lang.Exception
Throws:
java.lang.Exception

testCreateReferenceCacheForCustomerCreditPreApproval

public void testCreateReferenceCacheForCustomerCreditPreApproval()
                                                          throws java.lang.Exception
Throws:
java.lang.Exception

testCreateReferenceCacheForCustomerEmailAddress

public void testCreateReferenceCacheForCustomerEmailAddress()
                                                     throws java.lang.Exception
Throws:
java.lang.Exception

testCreateReferenceCacheForCustomerPreference

public void testCreateReferenceCacheForCustomerPreference()
                                                   throws java.lang.Exception
Throws:
java.lang.Exception

testCreateReferenceCacheForCustomerTelephonee

public void testCreateReferenceCacheForCustomerTelephonee()
                                                   throws java.lang.Exception
Throws:
java.lang.Exception

testCreateReferenceCacheForStoredValueCardCashout

public void testCreateReferenceCacheForStoredValueCardCashout()
                                                       throws java.lang.Exception
Throws:
java.lang.Exception

testCreateAndReadCustomer

public void testCreateAndReadCustomer()
                               throws java.lang.Exception
Throws:
java.lang.Exception

testCreateCustomerWithAuditInfo

public void testCreateCustomerWithAuditInfo()
                                     throws java.lang.Exception
Throws:
java.lang.Exception

testCreateAndReadCustomerWithCreditCards

public void testCreateAndReadCustomerWithCreditCards()
                                              throws java.lang.Exception
Throws:
java.lang.Exception

testCustomerCreditCardUpdate

public void testCustomerCreditCardUpdate()
                                  throws java.lang.Exception
Throws:
java.lang.Exception

testCustomerSubmitForAddresses

public void testCustomerSubmitForAddresses()
                                    throws java.lang.Exception
Throws:
java.lang.Exception

testCreateCustomerAndUpdatePreferences

public void testCreateCustomerAndUpdatePreferences()
                                            throws java.lang.Exception
Throws:
java.lang.Exception

testUpdateCustomer

public void testUpdateCustomer()
                        throws java.lang.Exception
Throws:
java.lang.Exception

testCustomerImportProcessed

public void testCustomerImportProcessed()
                                 throws java.lang.Exception
Throws:
java.lang.Exception

testUpdateCustomerHeaderWithAuditInfo

public void testUpdateCustomerHeaderWithAuditInfo()
                                           throws java.lang.Exception
Throws:
java.lang.Exception

testUpdateCustomerEmailForAudit

public void testUpdateCustomerEmailForAudit()
                                     throws java.lang.Exception
Throws:
java.lang.Exception

testUpdateCustomerTelephoneForAudit

public void testUpdateCustomerTelephoneForAudit()
                                         throws java.lang.Exception
Throws:
java.lang.Exception

testUpdateCustomerPreferenceForAudit

public void testUpdateCustomerPreferenceForAudit()
                                          throws java.lang.Exception
Throws:
java.lang.Exception

testUpdateCustomerAddressForAudit

public void testUpdateCustomerAddressForAudit()
                                       throws java.lang.Exception
Throws:
java.lang.Exception

testUpdateAddressOnlyForAudit

public void testUpdateAddressOnlyForAudit()
                                   throws java.lang.Exception
Throws:
java.lang.Exception

testCreateWithPrimaryPhoneNumbers

public void testCreateWithPrimaryPhoneNumbers()
                                       throws java.lang.Exception
Throws:
java.lang.Exception

testCreateCustomerWithoutEmailAddress

public void testCreateCustomerWithoutEmailAddress()
                                           throws java.lang.Exception
Throws:
java.lang.Exception

testCreateAndReadCustomerWithoutSalutationAndSuffix

public void testCreateAndReadCustomerWithoutSalutationAndSuffix()
                                                         throws java.lang.Exception
Throws:
java.lang.Exception

testFindReadCustomerSalutations

public void testFindReadCustomerSalutations()
                                     throws java.lang.Exception
Throws:
java.lang.Exception

testFindReadCustomerSuffixes

public void testFindReadCustomerSuffixes()
                                  throws java.lang.Exception
Throws:
java.lang.Exception

testNextAddressSequenceValue

public void testNextAddressSequenceValue()
                                  throws java.lang.Exception
Throws:
java.lang.Exception

testFindMultipleCustomersByFirstName

public void testFindMultipleCustomersByFirstName()
                                          throws java.lang.Exception
Throws:
java.lang.Exception

testFindMultipleCustomersByMiddleInitial

public void testFindMultipleCustomersByMiddleInitial()
                                              throws java.lang.Exception
Throws:
java.lang.Exception

testFindCustomerByLastName

public void testFindCustomerByLastName()
                                throws java.lang.Exception
Throws:
java.lang.Exception

testFindCustomerByLastNameWithWildCardAndPercent

public void testFindCustomerByLastNameWithWildCardAndPercent()
                                                      throws java.lang.Exception
Throws:
java.lang.Exception

testFindCustomerByLastNameWithPercent

public void testFindCustomerByLastNameWithPercent()
                                           throws java.lang.Exception
Throws:
java.lang.Exception

testFindNoResults

public void testFindNoResults()
                       throws java.lang.Exception
Throws:
java.lang.Exception

testFindIgnoreCase

public void testFindIgnoreCase()
                        throws java.lang.Exception
Throws:
java.lang.Exception

testFindCustomerByDate

public void testFindCustomerByDate()
                            throws java.lang.Exception
Throws:
java.lang.Exception

testFindCustomerByCustomerAddressDate

public void testFindCustomerByCustomerAddressDate()
                                           throws java.lang.Exception
Throws:
java.lang.Exception

testFindCustomerByAddressDate

public void testFindCustomerByAddressDate()
                                   throws java.lang.Exception
Throws:
java.lang.Exception

testFindByEmail

public void testFindByEmail()
                     throws java.lang.Exception
Throws:
java.lang.Exception

testFindByEmailWithUnderscore

public void testFindByEmailWithUnderscore()
                                   throws java.lang.Exception
Throws:
java.lang.Exception

testFindPhone

public void testFindPhone()
                   throws java.lang.Exception
Throws:
java.lang.Exception

testFindByAddressWithoutPostalCode

public void testFindByAddressWithoutPostalCode()
                                        throws java.lang.Exception
Throws:
java.lang.Exception

testFindByAddressWithFullPostalCode

public void testFindByAddressWithFullPostalCode()
                                         throws java.lang.Exception
Throws:
java.lang.Exception

testFindPartialPostalCode

public void testFindPartialPostalCode()
                               throws java.lang.Exception
Throws:
java.lang.Exception

testFindCustomerWithAllFieldSet

public void testFindCustomerWithAllFieldSet()
                                     throws java.lang.Exception
Throws:
java.lang.Exception

testFindCustomersWithWildcardInPostalCode

public void testFindCustomersWithWildcardInPostalCode()
                                               throws java.lang.Exception
Throws:
java.lang.Exception

testFindSorting

public void testFindSorting()
                     throws java.lang.Exception
Throws:
java.lang.Exception

testPrimaryTelephoneUpdatesCorrectly

public void testPrimaryTelephoneUpdatesCorrectly()
                                          throws java.lang.Exception
Throws:
java.lang.Exception

testReadCustomerTelephone

public void testReadCustomerTelephone()
                               throws java.lang.Exception
Throws:
java.lang.Exception

testReadCustomerEmailAddress

public void testReadCustomerEmailAddress()
                                  throws java.lang.Exception
Throws:
java.lang.Exception

testUpdateMatchRule

public void testUpdateMatchRule()
                         throws java.lang.Exception
Throws:
java.lang.Exception

testUpdateCreditCardWithInvalidId

public void testUpdateCreditCardWithInvalidId()
                                       throws java.lang.Exception
Throws:
java.lang.Exception

testUpdateCustomerEmailWithInvalidId

public void testUpdateCustomerEmailWithInvalidId()
                                          throws java.lang.Exception
Throws:
java.lang.Exception

testUpdateCustomerPreferenceWithInvalidId

public void testUpdateCustomerPreferenceWithInvalidId()
                                               throws java.lang.Exception
Throws:
java.lang.Exception

testUpdateCustomerTelephoneWithInvalidId

public void testUpdateCustomerTelephoneWithInvalidId()
                                              throws java.lang.Exception
Throws:
java.lang.Exception

testUpdateCustomerWithInvalidId

public void testUpdateCustomerWithInvalidId()
                                     throws java.lang.Exception
Throws:
java.lang.Exception

testUpdateMatchRuleWithInvalidId

public void testUpdateMatchRuleWithInvalidId()
                                      throws java.lang.Exception
Throws:
java.lang.Exception

testGetNextCustomerId

public void testGetNextCustomerId()
                           throws java.lang.Exception
Throws:
java.lang.Exception

testFindAllCustomerAddressChangeReason

public void testFindAllCustomerAddressChangeReason()
                                            throws java.lang.Exception
Throws:
java.lang.Exception

testFindCustomerByDisplayNumberMatchesHouseholdNumber

public void testFindCustomerByDisplayNumberMatchesHouseholdNumber()
                                                           throws java.lang.Exception
Throws:
java.lang.Exception

testFindCustomerByDisplayNumberMatchesCustomerId

public void testFindCustomerByDisplayNumberMatchesCustomerId()
                                                      throws java.lang.Exception
Throws:
java.lang.Exception

testCreateReadUpdateCustomerCreditPreApproval

public void testCreateReadUpdateCustomerCreditPreApproval()
                                                   throws java.lang.Exception
Throws:
java.lang.Exception

testFindCustomerCreditPreApproval

public void testFindCustomerCreditPreApproval()
                                       throws java.lang.Exception
Throws:
java.lang.Exception

testCreateReadAndUpdateStoredValueCardCashout

public void testCreateReadAndUpdateStoredValueCardCashout()
                                                   throws java.lang.Exception
Throws:
java.lang.Exception

testReadStoredValueCardCashoutWithInvalidRef

public void testReadStoredValueCardCashoutWithInvalidRef()
                                                  throws java.lang.Exception
Throws:
java.lang.Exception

testFindStoredValueCardCashoutsForResaExport

public void testFindStoredValueCardCashoutsForResaExport()
                                                  throws java.lang.Exception
Throws:
java.lang.Exception

testFindAllCustomerInactiveReasons

public void testFindAllCustomerInactiveReasons()
                                        throws java.lang.Exception
Throws:
java.lang.Exception

testFindOnlyActiveCustomers

public void testFindOnlyActiveCustomers()
                                 throws java.lang.Exception
Throws:
java.lang.Exception

testFindCustomerReferences

public void testFindCustomerReferences()
                                throws java.lang.Exception
Throws:
java.lang.Exception

testFindCustomerReferencesForActiveTrue

public void testFindCustomerReferencesForActiveTrue()
                                             throws java.lang.Exception
Throws:
java.lang.Exception

testFindCustomerReferencesForActiveFalse

public void testFindCustomerReferencesForActiveFalse()
                                              throws java.lang.Exception
Throws:
java.lang.Exception

testFindCustomerReferencesForCreatedAfterDate

public void testFindCustomerReferencesForCreatedAfterDate()
                                                   throws java.lang.Exception
Throws:
java.lang.Exception

testFindCustomerReferencesForCreatedOrUpdatedAfterDate

public void testFindCustomerReferencesForCreatedOrUpdatedAfterDate()
                                                            throws java.lang.Exception
Throws:
java.lang.Exception

testFindCustomerReferencesForLastNameAlphaRangeBToC

public void testFindCustomerReferencesForLastNameAlphaRangeBToC()
                                                         throws java.lang.Exception
Throws:
java.lang.Exception

testFindCustomerReferencesForPrimaryBillToStates

public void testFindCustomerReferencesForPrimaryBillToStates()
                                                      throws java.lang.Exception
Throws:
java.lang.Exception

testReadCustomers

public void testReadCustomers()
                       throws java.lang.Exception
Throws:
java.lang.Exception

testRandomInt

public void testRandomInt()

testGetRandomLastName

public void testGetRandomLastName()

testReadAndDeleteCustomer

public void testReadAndDeleteCustomer()
                               throws java.lang.Exception
Throws:
java.lang.Exception

testInsertRandomCustomers

public void testInsertRandomCustomers()
                               throws java.lang.Exception
Throws:
java.lang.Exception

testOracleCustomerEmailReteriver

public void testOracleCustomerEmailReteriver()
                                      throws java.lang.Exception
Throws:
java.lang.Exception

testReadCustomerInactiveReason

public void testReadCustomerInactiveReason()
                                    throws java.lang.Exception
Throws:
java.lang.Exception

testReadCustomerChangeReason

public void testReadCustomerChangeReason()
                                  throws java.lang.Exception
Throws:
java.lang.Exception

testFindCustomerReferencesForCreditCardNumber

public void testFindCustomerReferencesForCreditCardNumber()
                                                   throws java.lang.Exception
Throws:
java.lang.Exception


Copyright © 2004 Retek Inc. All Rights Reserved. - Generated at Fri, 10/22/2004 07:28