autorenew功能测试案例.docx

Autorenew功能测试一、案例分享1. 功能概述在做印度项目的时候，遇到客户有这样的需求，就是用户订购产品到期后能通过短信的方式续订产品，这个需求涉及到了crm,信管，帐处和信控。帐处这边要关注的地方就是产品扣费提醒这一块。分为产品扣费成功提醒，产品扣费失败提醒和产品扣费前提醒。2. 测试案例设计测试要点罗列：在设计测试场景和编写测试用例的时候，为了不遗漏我们的测试要点，我们可以把我们要测试的点用表格或则列表的方式列出来，这样可以清楚知道我们要覆盖的测试点。测试点枚举值账户类型预付费后付费产品类型autorenew非autorenew提醒类型扣费成功扣费失败扣费前测试场景和测试用例设计:按照上面罗列出来的测试点进行单个覆盖，设计测试场景如下编号测试场景测试用例1预付费用户订购非autorenew产品，产品到期，发送扣费前提醒2预付费用户订购非autorenew产品，产品扣费成功，发送提醒3预付费用户订购非autorenew产品，产品扣费失败，发送提醒4预付费用户订购autorenew产品，产品到期，发送扣费前提醒5预付费用户订购autorenew产品，产品扣费成功，发送提醒6预付费用户订购autorenew产品，产品扣费失败，发送提醒7后付费用户订购非autorenew产品，产品到期，发送扣费前提醒8后付费用户订购非autorenew产品，产品扣费成功，发送提醒9预付费用户订购非autorenew产品，产品扣费失败，发送提醒10后付费用户订购autorenew产品，产品到期，发送扣费前提醒11后付费用户订购autorenew产品，产品扣费成功，发送提醒12后付费用户订购autorenew产品，产品扣费失败，发送提醒这样场景设计出来后，发现要设计出来的测试用例至少有12个。如果再包含异常场景的话，那就会变得更多。由于当时项目很紧，测试时间有限。如果用例太多的话可能会影响测试进度，最后导致功能测试不完整，于是我就压缩了下测试用例的数目，但为了又能完全覆盖测试要点，于是采用了交叉覆盖的方式设计了测试用例。交叉覆盖就是一个用例覆盖多个测试点，同时相同的测试场景和相似的测试用例，可以进行不同点的覆盖。下面是设计的交叉覆盖用例：编号测试场景测试用例1预付费用户订购非autorenew产品，产品到期，发送扣费前提醒2预付费用户订购非autorenew产品，产品扣费成功，发送提醒3后付费用户订购非autorenew产品，产品扣费失败，发送提醒4后付费用户订购autorenew产品，产品到期，发送扣费前提醒5后付费用户订购autorenew产品，产品扣费成功，发送提醒6预付费用户订购autorenew产品，产品扣费失败，发送提醒主要测试步骤：1) 信管开户，查看账户信息2) 跑日帐，查看日志3) 查看提醒数据，有相应数据生成3. 测试用例执行测试执行的主要过程是信管开户和产品扣费，产品首次扣费通过产品订购来实现，之后的扣费是通过帐处的日帐扣费来实现。由于每个测试用例都有信管开户是第一步，这时候我就想到了，如果每个测试用例都要新开户，这样的话垃圾账户数据可能太多，于是我就想到能不能减少开户数据。这样有两个好处，一个是减少垃圾数据，另外也可以提高我们的测试效率。后来我发现在正常的情况下，我们开户出来就可以验证扣费成功这个提醒，然后在生成下次扣费时间的时候，可以验证产品的到期提醒也就是扣费前的提醒。最后我们在构造余额不足的情况下，即可以验证扣费失败的提醒。由于我们是有两种账户，一个预付费和一个后付费，这样我们只要开出来两个账户就可以验证完所有的测试用例。主要测试数据按照上面的测试计划，我们预后付费的测试用例的执行顺序是：验证扣费成功提醒-验证扣费前提醒-验证扣费失败提醒下面是后付费测试的相关数据1) 后付费扣费成功提醒U2P_AR_BI_001_008帐处扣费，发送提醒业务需求Autorenew= Y产品，扣费成功目标帐处扣费成功，提醒发出Pre-requisites1.后付费产品：70005892.账户：104115Post-requisitesnone测试参数Step 1: 开户，查看三户信息v_SO_NBR=256487serv_id=4114acct_id=104115cust_id=20004116mdb select * from CPromCharValue where m_llObjectId = 4114;_oid, m_llObjectId m_llPromNo m_nObjectType m_nSpecCharId m_szValue m_llGroupId m_dValidDate m_dExpireDate 645, 4114, 40000256487, 0, 22, 1, 6282, 20151014203134, 20180710203134Step 2: 查看开户扣费日志，有相应打印product_offering_id = 7000589 ,notify_type = 4 ,notify_mode = 0 ,offset_cycle_type = 0 ,offset_cycle_unit = 0 ,cycle_count = 0 ,cycle_unit = 0 ,cycle_type = 0 ,notification_id = 0 ,mode_type = 0 ,billing_type = 1,channel_id = 42015-10-16 13:26:19.793581 0 47202228762368 -2608996366028145610 trace loaddbinfo.cpp 127=prodOfferNotifyInner=product_offering_id = 7000589 ,notify_type = 4 ,notify_mode = 1 ,offset_cycle_type = 0 ,offset_cycle_unit = 0 ,cycle_count = 0 ,cycle_unit = 0 ,cycle_type = 0 ,notification_id = 2050104 ,mode_type = 1 ,billing_type = 1,channel_id = -12015-10-16 13:26:19.794077 0 47202228762368 -2608996366028145610 trace recurringnotify.cpp 927=recurring prod deducted notify in para=sNotifyIntfList notification_id = 2050104, region_code = 0, so_nbr = 0, so_date = 00000000000000+0000, cust_id = 0, acct_id = 104115, serv_id = 4114, teland_id = 1list_param param_id = 8010, param_value = 7000589, measure_id = 0 param_id = 3042, param_value = 100000, measure_id = 12903 param_id = 9010, param_value = 200000, measure_id = 12903 param_id = 1081, param_value = 31, measure_id = 0 param_id = 8002, param_value = 20160114, measure_id = 0 param_id = 7000, param_value = 0, measure_id = 0 param_id = 3054, param_value = 104115, measure_id = 0 param_id = 3004, param_value = 7303004114, measure_id = 0 param_id = 9002, param_value = postpaid4114, measure_id = 0 param_id = 3043, param_value = 20151214000000, measure_id = 0 param_id = 9015, param_value = 1, measure_id = 0list_phoneobbs:J:1.3: list_0_MNotificationDef:SPhoneIntfList_size : 0, Step 3: 查看提醒工单和短信表，有数据生成Test ResultPassTester: yangshankunDate: 2015/10/202) 后付费到期提醒U2P_AR_BI_001_009帐处扣费，发送提醒业务需求Autorenew= Y产品，不扣费目标帐处不扣费，扣费前提醒发出Pre-requisites1.后付费stack产品：70005892.账户：104115Post-requisitesnone测试参数Step 1: 开户，查看三户信息v_SO_NBR=256487serv_id=4114acct_id=104115cust_id=20004116mdb select * from CPromCharValue where m_llObjectId = 4114;_oid, m_llObjectId m_llPromNo m_nObjectType m_nSpecCharId m_szValue m_llGroupId m_dValidDate m_dExpireDate 645, 4114, 40000256487, 0, 22, 1, 6282, 20151014203134, 20180710203134Step 2: 跑下次扣费前3天日帐（可配置）查看日志，有相应打印2015-10-14 21:31:43.666131 0 47379261957888 -1901616020072943109 trace loaddbinfo.cpp 108=prodOfferNoti=product_offering_id = 7000589 ,notify_type = 6 ,notify_mode = 0 ,offset_cycle_type = 0 ,offset_cycle_unit = 0 ,cycle_count = 0 ,cycle_unit = 0 ,cycle_type = 0 ,notification_id = 0 ,mode_type = 0 ,billing_type = 0,channel_id = 02015-10-14 21:31:43.666196 0 47379261957888 -1901616020072943109 trace loaddbinfo.cpp 127=prodOfferNotifyInner=product_offering_id = 7000589 ,notify_type = 4 ,notify_mode = 1 ,offset_cycle_type = 0 ,offset_cycle_unit = 0 ,cycle_count = 0 ,cycle_unit = 0 ,cycle_type = 0 ,notification_id = 2050104 ,mode_type = 1 ,billing_type = 1,channel_id = -12015-10-14 21:31:43.666282 0 47379261957888 -1901616020072943109 trace loaddbinfo.cpp 127=prodOfferNotifyInner=product_offering_id = 7000589 ,notify_type = 5 ,notify_mode = 1 ,offset_cycle_type = 0 ,offset_cycle_unit = 0 ,cycle_count = 0 ,cycle_unit = 0 ,cycle_type = 0 ,notification_id = 2050106 ,mode_type = 1 ,billing_type = 1,channel_id = -12015-10-14 21:31:43.666330 0 47379261957888 -1901616020072943109 trace loaddbinfo.cpp 127=prodOfferNotifyInner=product_offering_id = 7000589 ,notify_type = 6 ,notify_mode = 1 ,offset_cycle_type = 1 ,offset_cycle_unit = 3 ,cycle_count = 0 ,cycle_unit = 0 ,cycle_type = 0 ,notification_id = 2060101 ,mode_type = 1 ,billing_type = 1,channel_id = -12015-10-14 21:31:43.666353 0 47379261957888 -1901616020072943109 trace recurringnotify.cpp 467 proc_prodDeductNotify llProdId=400002564872015-10-14 21:31:43.666373 0 47379261957888 -1901616020072943109 trace recurringnotify.cpp 468 get_prodNotify iRet=02015-10-14 21:31:43.666392 0 47379261957888 -1901616020072943109 trace recurringnotify.cpp 469 get_prodNotify bExist=12015-10-14 21:31:43.666469 0 47379261957888 -1901616020072943109 trace recurringnotify.cpp 482 dealTime = 20151111000000+0800,end_date = 20151114000000,iSpanDay = 32015-10-14 21:31:43.667017 0 47379261957888 -1901616020072943109 trace recurringnotify.cpp 934=recurring prod deduct notify in para=sNotifyIntfList_date = 20151114000000,iSpanDay = 32015-10-14 21:31:43.667017 0 47379261957888 -1901616020072943109 trace recurringnotify.cpp 934=recurring prod deduct notify in para=sNotifyIntfList notification_id = 2060101, region_code = 0, so_nbr = 0, so_date = 20151111000000+0800, cust_id = 0, acct_id = 104115, serv_id = 4114, teland_id = 1list_param param_id = 1072, param_value = 3, measure_id = 0 param_id = 8010, param_value = 7000589, measure_id = 0 param_id = 9015, param_value = 1, measure_id = 0 param_id = 9014, param_value = 1, measure_id = 0 param_id = 8004, param_value = 20180710203134, measure_id = 0list_phoneobbs:J:1.3: list_0_MNotificationDef:SPhoneIntfList_size : 0, list_0_MNotificationDef:SPhoneIntfList : nulllist_emailobbs:J:1.3: list_0_MNotificationDef:SEmailIntfList_size : 0, list_0_MNotificationDef:SEmailIntfList : null Step 3: 查看提醒工单和短信表，有数据生成Test ResultPassTester: yangshankunDate: 2015/10/203) 后付费扣费失败提醒U2P_AR_BI_001_010帐处扣费，发送提醒业务需求Autorenew= N产品，扣费失败目标扣费失败，提醒发出Pre-requisites1.后付费stack产品：70005892.账户：104115Post-requisitesnone测试参数Step 1: 开户，查看三户信息v_SO_NBR=256487serv_id=4114acct_id=104115cust_id=20004116mdb select * from CPromCharValue where m_llObjectId = 4114;_oid, m_llObjectId m_llPromNo m_nObjectType m_nSpecCharId m_szValue m_llGroupId m_dValidDate m_dExpireDate 645, 4114, 40000256487, 0, 22, 0, 6282, 20151014203134, 20180710203134Step 2: 跑日帐查看日志，有相应打印=prodOfferNoti=product_offering_id = 7000589 ,notify_type = 5 ,notify_mode = 0 ,offset_cycle_type = 0 ,offset_cycle_unit = 0 ,cycle_count = 0 ,cycle_unit = 0 ,cycle_type = 0 ,notification_id = 0 ,mode_type = 0 ,billing_type = 1,channel_id = 42015-10-14 21:42:07.363032 0 47574347425536 -1024120965688527477 trace loaddbinfo.cpp 127=prodOfferNotifyInner=product_offering_id = 7000589 ,notify_type = 4 ,notify_mode = 1 ,offset_cycle_type = 0 ,offset_cycle_unit = 0 ,cycle_count = 0 ,cycle_unit = 0 ,cycle_type = 0 ,notification_id = 2050104 ,mode_type = 1 ,billing_type = 1,channel_id = -12015-10-14 21:42:07.363044 0 47574347425536 -1024120965688527477 trace loaddbinfo.cpp 127=prodOfferNotifyInner=product_offering_id = 7000589 ,notify_type = 5 ,notify_mode = 1 ,offset_cycle_type = 0 ,offset_cycle_unit = 0 ,cycle_count = 0 ,cycle_unit = 0 ,cycle_type = 0 ,notification_id = 2050106 ,mode_type = 1 ,billing_type = 1,channel_id = -12015-10-14 21:42:07.363380 0 47574347425536 -1024120965688527477 trace recurringnotify.cpp 928=recurring prod deducted notify in para=sNotifyIntfList notification_id = 2050106, region_code = 0, so_nbr = 0, so_date = 00000000000000+0000, cust_id = 0, acct_id = 104115, serv_id = 4114, teland_id = 1list_param param_id = 8010, param_value = 7000589, measure_id = 0 param_id = 3042, param_value = 100000, measure_id = 12903 param_id = 9010, param_value = 0, measure_id = 12903 param_id = 1081, param_value = -1, measure_id = 0 par