def test_getCategoryList_beer(self): ws = webservice() ws.login(self.UserShop.username, self.UserShop.password) pijiuList = ws.getCategoryList(merchCategoryCode='C01L0104') self.assertEqual(pijiuList.model['success'], '0') self.assertEqual(pijiuList.model['categoryCode'], 'C01L0104') # 校验品牌数量 numPijiuBrand = select_int( 'select count(*) from dlcategroy.dl_brand where brand_id in (select brand_id from dlcategroy.dl_brand_ref_category where category_id = \'C01L0104\' and brand_status = \'01\') and brand_status != \'99\'' ) self.assertEqual( len(pijiuList.model['categoryItem']['brandTupleList']), numPijiuBrand) # 校验分类数量 numPijiuClassify = select_int( 'select count(*) from dlcategroy.dl_property_value where property_id = \'PL20401\'' ) self.assertEqual( len(pijiuList.model['categoryItem']['classifyTupleList']), numPijiuClassify) # 校验国家数量 numPijiuCountry = select_int( 'select count(*) from dlcategroy.dl_property_value where property_id = \'PL20402\'' ) self.assertEqual( len(pijiuList.model['categoryItem']['countryTupleList']), numPijiuCountry)
def test_getMerchList_filterTea(self): ws = webservice() ws.login(self.UserShop.username, self.UserShop.password) # 筛选茶 MerchList = ws.getMerchList(merchCategoryCode='C01T01',rows='999') self.assertEqual(MerchList.model['success'], '0') flag = False for i in range(0,len(MerchList.model['merchList'])): if MerchList.model['merchList'][i]['merchName'].encode('utf-8') == self.Merch2.fullName: flag = True self.assertEqual(flag, True, self.Merch2.fullName + ' is not found') # 筛选绿茶——merch为红茶,故判断找不到 MerchList = ws.getMerchList(merchCategoryCode='C01T0101',rows='999') self.assertEqual(MerchList.model['success'], '0') for i in range(0,len(MerchList.model['merchList'])): if MerchList.model['merchList'][i]['merchName'].encode('utf-8') == self.Merch2.fullName: flag = False self.assertEqual(flag, True, self.Merch2.fullName + ' is red tea, but can find it in green tea.') # 筛选红茶 MerchList = ws.getMerchList(merchCategoryCode='C01T0102',rows='999') self.assertEqual(MerchList.model['success'], '0') flag = False for i in range(0,len(MerchList.model['merchList'])): if MerchList.model['merchList'][i]['merchName'].encode('utf-8') == self.Merch2.fullName: flag = True self.assertEqual(flag, True, self.Merch2.fullName + ' is not found.')
def test_getRecdMerchList_page(self): ws = webservice() ws.login(self.UserShop.username, self.UserShop.password) allMerchList = ws.getRecommendList(rows='999') numMerch = len(allMerchList.model['recommendListModel']) page = numMerch / 4 time = 0 for p in range(1, page + 2): MerchListPage = ws.getRecommendList(page=p) # 判断商品1是否存在,如果存在time +1 for i in range(0, len(MerchListPage.model['recommendListModel'])): if MerchListPage.model['recommendListModel'][i][ 'merchName'].encode('utf-8') == self.Merch1.fullName: time += 1 if p == page + 1: self.assertEqual( len(MerchListPage.model['recommendListModel']), numMerch % 4, "The last page is wrong") else: self.assertEqual( len(MerchListPage.model['recommendListModel']), 4, "Every page is wrong") self.assertEqual(time, 1, self.Merch1.fullName + " is not once.")
def test_getMerchList_null(self): # 修改终端店2的采购区域为香港CHNP032C342D2995 update('update dlcompany.dl_biz_purchase set purchase_area_code = ? where company_id = ?', 'CHNP032C342D2995', self.UserShop2.companyId) ws = webservice() ws.login(self.UserShop2.username, self.UserShop2.password) MerchList = ws.getPromotionList(rows='999') self.assertEqual(MerchList.model['promotionListModel'],[])
def test_getMerchDetail_stockout(self): ws = webservice() ws.login(self.UserShop.username, self.UserShop.password) update( 'update dlmerchandise.dl_goods set on_hand_inventory = 0 where goods_id = ?', self.Merch1.goodsId) merchDetail = ws.getMerchDetail(merchId=self.Merch1.goodsId) self.assertEqual(merchDetail.model['merchDetail']['merchStatus'], '1')
def test_getMerchDetail_lock(self): ws = webservice() ws.login(self.UserShop.username, self.UserShop.password) update( 'update dlmerchandise.dl_goods set goods_status = \'03\' where goods_id = ?', self.Merch1.goodsId) merchDetail = ws.getMerchDetail(merchId=self.Merch1.goodsId) self.assertEqual(merchDetail.model['merchDetail']['merchStatus'], '2')
def test_modifyPwd_mod(self): ws = webservice() ws.login(self.UserShop.username, self.UserShop.password) modifyPwd = ws.modiyfPassword(self.UserShop.password, 'ModifyPwd') self.assertEqual(modifyPwd.model['success'], '0') modifyPwdOld = ws.login(self.UserShop.username, self.UserShop.password, 'null') self.assertEqual(modifyPwdOld.model['success'], '4') modifyPwdNew = ws.login(self.UserShop.username, 'ModifyPwd') self.assertEqual(modifyPwdNew.model['success'], '0')
def test_getMerchList_sellerId(self): ws = webservice() ws.login(self.UserShop.username, self.UserShop.password) MerchList = ws.getMerchList(sellerId=self.DealMgr.companyId,rows='999') flag = False for i in range(0,len(MerchList.model['merchList'])): if MerchList.model['merchList'][i]['merchName'].encode('utf-8') == self.Merch2.fullName: flag = True self.assertEqual(flag, True, self.Merch2.fullName + ' is not found')
def test_getMerchList_all(self): ws = webservice() ws.login(self.UserShop.username, self.UserShop.password) merchList = ws.getPromotionList(rows="999") # 商品1存在 self.assertGetMerchList(merchList, self.Merch1) # 商品4不在列表 for i in range(0, len(merchList.model['promotionListModel'])): if merchList.model['promotionListModel'][i] == self.Merch4.goodsId: self.assertEqual(False,True,self.fullName + 'is found in PromotionList')
def test_getMerchList_searchName(self): ws = webservice() ws.login(self.UserShop.username, self.UserShop.password) MerchList = ws.getMerchList(merchName=self.Merch1.fullName.encode('utf-8'),rows='999') self.assertEqual(MerchList.model['success'], '0') flag = False for i in range(0,len(MerchList.model['merchList'])): if MerchList.model['merchList'][i]['merchName'].encode('utf-8') == self.Merch1.fullName: flag = True self.assertEqual(flag, True, self.Merch1.fullName + ' is not found')
def test_getCategoryList_tea(self): ws = webservice() ws.login(self.UserShop.username, self.UserShop.password) teaList = ws.getCategoryList(merchCategoryCode='C01T01') self.assertEqual(teaList.model['success'], '0') self.assertEqual(teaList.model['categoryCode'], 'C01T01') # 校验茶类数量 numTeaClassify = select_int( 'select count(*) from dlcategroy.dl_category where parent_category_id = \'C01T01\'' ) self.assertEqual(len(teaList.model['categoryItem']), numTeaClassify)
def test_getMerchList_all(self): ws = webservice() ws.login(self.UserShop.username, self.UserShop.password) allMerchList = ws.getMerchList(rows='99999') self.assertEqual(allMerchList.model['success'], '0') #numMerchList = select_int('select count(*) from dl_goods.dl_goods_area_buyer_type where area_code = \'CHNP035C345D2998\' and buyer_type = \'S011\'') #self.assertEqual(len(allMerchList.model['merchList']), numMerchList) flag = False for i in range(0,len(allMerchList.model['merchList'])): if allMerchList.model['merchList'][i]['merchName'].encode('utf-8') == self.Merch1.fullName: flag = True self.assertEqual(flag, True, self.Merch1.fullName + ' is not found')
def test_getCategoryList_drink(self): ws = webservice() ws.login(self.UserShop.username, self.UserShop.password) drinkList = ws.getCategoryList(merchCategoryCode='C01X0101') self.assertEqual(drinkList.model['success'], '0') self.assertEqual(drinkList.model['categoryCode'], 'C01X0101') # 校验茶类数量 numDrinkBrand = select_int( 'select count(*) from dlcategroy.dl_brand where brand_id in (select brand_id from dlcategroy.dl_brand_ref_category where category_id = \'C01X0101\' and brand_status = \'01\') and brand_status != \'99\'' ) self.assertEqual( len(drinkList.model['categoryItem']['brandTupleList']), numDrinkBrand)
def test_getMerchList_priceLimitLower(self): ws = webservice() ws.login(self.UserShop.username, self.UserShop.password) MerchList = ws.getMerchList(lowPrice="99900",rows='999') flag = False # 商品2在价格区间 for i in range(0,len(MerchList.model['merchList'])): if MerchList.model['merchList'][i]['merchName'].encode('utf-8') == self.Merch2.fullName: flag = True self.assertEqual(flag, True, self.Merch2.fullName + ' is not found') # 商品1不在价格区间 for i in range(0,len(MerchList.model['merchList'])): if MerchList.model['merchList'][i]['merchName'].encode('utf-8') == self.Merch1.fullName: flag = False self.assertEqual(flag, True, self.Merch1.fullName + ' is not found')
def test_getMerchList_filterCategory(self): ws = webservice() ws.login(self.UserShop.username, self.UserShop.password) # 筛选白酒 MerchList1 = ws.getMerchList(merchCategoryCode='C01L0101',rows='999') self.assertEqual(MerchList1.model['success'], '0') flag = False for i in range(0,len(MerchList1.model['merchList'])): if MerchList1.model['merchList'][i]['merchName'].encode('utf-8') == self.Merch1.fullName: flag = True self.assertEqual(flag, True, self.Merch1.fullName + ' is not found') # 筛选葡萄酒 MerchList2 = ws.getMerchList(merchCategoryCode='C01L0102',rows='999') self.assertEqual(MerchList2.model['success'], '0') for i in range(0,len(MerchList2.model['merchList'])): if MerchList2.model['merchList'][i]['merchName'].encode('utf-8') == self.Merch1.fullName: flag = False self.assertEqual(flag, True, self.Merch1.fullName + ' is not wine, but can find it.') # 筛选洋酒 MerchList3 = ws.getMerchList(merchCategoryCode='C01L0103',rows='999') self.assertEqual(MerchList3.model['success'], '0') for i in range(0,len(MerchList3.model['merchList'])): if MerchList3.model['merchList'][i]['merchName'].encode('utf-8') == self.Merch1.fullName: flag = False self.assertEqual(flag, True, self.Merch1.fullName + ' is not foreign wine, but can find it.') # 筛选啤酒 MerchList4 = ws.getMerchList(merchCategoryCode='C01L0104',rows='999') self.assertEqual(MerchList4.model['success'], '0') for i in range(0,len(MerchList4.model['merchList'])): if MerchList4.model['merchList'][i]['merchName'].encode('utf-8') == self.Merch1.fullName: flag = False self.assertEqual(flag, True, self.Merch1.fullName + ' is not beer, but can find it.') # 筛选其他饮品 MerchList = ws.getMerchList(merchCategoryCode='C01X0101',rows='999') self.assertEqual(MerchList.model['success'], '0') for i in range(0,len(MerchList.model['merchList'])): if MerchList.model['merchList'][i]['merchName'].encode('utf-8') == self.Merch1.fullName: flag = False self.assertEqual(flag, True, self.Merch1.fullName + ' is not drink, but can find it.')
def test_getCategoryList_wine(self): ws = webservice() ws.login(self.UserShop.username, self.UserShop.password) putaojiuList = ws.getCategoryList(merchCategoryCode='C01L0102') self.assertEqual(putaojiuList.model['success'], '0') self.assertEqual(putaojiuList.model['categoryCode'], 'C01L0102') # 校验品牌数量 numPutaojiuBrand = select_int( 'select count(*) from dlcategroy.dl_brand where brand_id in (select brand_id from dlcategroy.dl_brand_ref_category where category_id = \'C01L0102\' and brand_status = \'01\') and brand_status != \'99\'' ) self.assertEqual( len(putaojiuList.model['categoryItem']['brandTupleList']), numPutaojiuBrand) # 校验产地 numPutaojiuProperty = select_int( 'select count(*) from dlcategroy.dl_property_value where property_id = \'PL20202\'' ) self.assertEqual( len(putaojiuList.model['categoryItem']['productionTupleList']), numPutaojiuProperty)
def test_getNewMerchList_page(self): ws = webservice() ws.login(self.UserShop.username, self.UserShop.password) allMerchList = ws.getNewMerchList(rows='999') numMerch = len(allMerchList.model['newMerchListModel']) rows = numMerch/15 time = 0 for r in range(1,numMerch/15+2): MerchListPage = ws.getNewMerchList(page=r) # 判断商品1是否存在,如果存在time +1 for i in range(0,len(MerchListPage.model['newMerchListModel'])): if MerchListPage.model['newMerchListModel'][i]['merchName'].encode('utf-8') == self.Merch1.fullName: time+=1 if r == numMerch/15+1: self.assertEqual(len(MerchListPage.model['newMerchListModel']),numMerch%15,"The last page is wrong") else: self.assertEqual(len(MerchListPage.model['newMerchListModel']),15,"Every page is wrong") self.assertEqual(time,1,self.Merch1.fullName+" is not once.")
def test_getCategoryList_sprit(self): ws = webservice() ws.login(self.UserShop.username, self.UserShop.password) baijiuList = ws.getCategoryList() self.assertEqual(baijiuList.model['success'], '0') self.assertEqual(baijiuList.model['categoryCode'], 'C01L0101') # 校验品牌数量dlcategroy numBaijiuBrand = select_int( 'select count(*) from dlcategroy.dl_brand where brand_id in (select brand_id from dlcategroy.dl_brand_ref_category where category_id = \'C01L0101\' and brand_status = \'01\') and brand_status != \'99\'' ) self.assertEqual( len(baijiuList.model['categoryItem']['brandTupleList']), numBaijiuBrand) # 校验香型数量 numBaijiuProperty = select_int( 'select count(*) from dlcategroy.dl_property_value where property_id = \'PL20103\'' ) self.assertEqual( len(baijiuList.model['categoryItem']['odorTupleList']), numBaijiuProperty)
def test_getOftenMerchList_soldOut(self): ws = webservice() ws.login(self.UserShop.username, self.UserShop.password) update( 'update dlmerchandise.dl_goods set goods_status = ? where goods_id = ?', '02', self.Merch1.goodsId) # 获取下架商品,商品1存在 merchList = ws.getOftenBuyList(saleFlag="1", rows="999") # 下架后商品无促销无推荐 self.assertGetMerchList(merchList, self.Merch1, isPromotion='1', isRecommended='1') # 获取上架商品,商品1不在列表 merchList = ws.getOftenBuyList(saleFlag="1", rows="999") for i in range(0, len(merchList.model['oftenBuyListModel'])): if merchList.model['oftenBuyListModel'][i] == self.Merch1.goodsId: self.assertEqual( False, True, self.Merch1.fullName + 'is found in oftenBuyList')
def test_getMerchList_filterProperty(self): ws = webservice() ws.login(self.UserShop.username, self.UserShop.password) # 筛选白酒香型 MerchList = ws.getMerchList(merchPropertyValueCodeList=["PL20103_split_PL20103V01_split_酱香型"],rows='999') self.assertEqual(MerchList.model['success'], '0') flag = False for i in range(0,len(MerchList.model['merchList'])): if MerchList.model['merchList'][i]['merchName'].encode('utf-8') == self.Merch1.fullName: flag = True self.assertEqual(flag, True, self.Merch1.fullName + ' is not found') # 筛选茶种——祁门红茶 MerchList = ws.getMerchList(merchCategoryCode="C01T0102",merchPropertyValueCodeList=["PT20201_split_PT20201V01_split_祁门红茶"],rows='999') self.assertEqual(MerchList.model['success'], '0') flag = False for i in range(0,len(MerchList.model['merchList'])): if MerchList.model['merchList'][i]['merchName'].encode('utf-8') == self.Merch2.fullName: flag = True self.assertEqual(flag, True, self.Merch2.fullName + ' is not found')
def test_getMerchList_sort(self): ws = webservice() ws.login(self.UserShop.username, self.UserShop.password) # 名称升序排列 MerchListNameAsc = ws.getMerchList(sellerId=self.DealMgr.companyId,sortField="0",sortType="0",rows='999') self.assertEqual(MerchListNameAsc.model['merchList'][0]['merchName'].encode('utf-8'),self.Merch1.fullName) self.assertEqual(MerchListNameAsc.model['merchList'][1]['merchName'].encode('utf-8'),self.Merch2.fullName) # 名称降序排列 MerchListNameDesc = ws.getMerchList(sellerId=self.DealMgr.companyId,sortField="0",sortType="1",rows='999') self.assertEqual(MerchListNameDesc.model['merchList'][0]['merchName'].encode('utf-8'),self.Merch2.fullName) self.assertEqual(MerchListNameDesc.model['merchList'][1]['merchName'].encode('utf-8'),self.Merch1.fullName) # 价格升序排列 MerchListPriceAsc = ws.getMerchList(sellerId=self.DealMgr.companyId,sortField="1",sortType="0",rows='999') self.assertEqual(MerchListPriceAsc.model['merchList'][0]['merchName'].encode('utf-8'),self.Merch1.fullName) self.assertEqual(MerchListPriceAsc.model['merchList'][1]['merchName'].encode('utf-8'),self.Merch2.fullName) # 价格降序排列 MerchListPriceDesc = ws.getMerchList(sellerId=self.DealMgr.companyId,sortField="1",sortType="1",rows='999') self.assertEqual(MerchListPriceDesc.model['merchList'][0]['merchName'].encode('utf-8'),self.Merch2.fullName) self.assertEqual(MerchListPriceDesc.model['merchList'][1]['merchName'].encode('utf-8'),self.Merch1.fullName)
def test_getMerchList_brand(self): ws = webservice() ws.login(self.UserShop.username, self.UserShop.password) # 筛选白酒品牌 MerchList = ws.getMerchList(merchBrandId="B00003",rows='999') flag = False for i in range(0,len(MerchList.model['merchList'])): if MerchList.model['merchList'][i]['merchName'].encode('utf-8') == self.Merch1.fullName: flag = True if MerchList.model['merchList'][i]['merchName'].encode('utf-8') == self.Merch2.fullName: flag = False break self.assertEqual(flag, True, self.Merch1.fullName + ' is not found') # 筛选茶品牌 MerchList = ws.getMerchList(merchBrandId=self.Merch2.brandId,rows='999') flag = False for i in range(0,len(MerchList.model['merchList'])): if MerchList.model['merchList'][i]['merchName'].encode('utf-8') == self.Merch2.fullName: flag = True if MerchList.model['merchList'][i]['merchName'].encode('utf-8') == self.Merch1.fullName: flag = False break self.assertEqual(flag, True, self.Merch2.fullName.encode('utf-8') + ' is not found')
def test_modifyPwd_tokenWrong(self): ws = webservice() ws.login(self.UserShop.username, self.UserShop.password) modifyPwd = ws.modiyfPassword(self.UserShop.password, 'ModifyPwd', 'WrongToken') self.assertEqual(modifyPwd.code, 100)
def test_modifyPwd_pwdSame(self): ws = webservice() ws.login(self.UserShop.username, self.UserShop.password) modifyPwd = ws.modiyfPassword(self.UserShop.password, self.UserShop.password) self.assertEqual(modifyPwd.model['success'], '0')
def test_modifyPwd_pwdWrong(self): ws = webservice() ws.login(self.UserShop.username, self.UserShop.password) modifyPwd = ws.modiyfPassword('WorngPwd', 'ModifyPwd') self.assertEqual(modifyPwd.model['success'], '1')
def test_getNewMerchDetail_noPrice(self): ws = webservice() ws.login(self.UserShop.username, self.UserShop.password) merchDetail = ws.getNewMerchDetail(merchId=self.Merch3.goodsId) self.assertEqual( merchDetail.model['newMerchDetailModel']['merchStatus'], '3')
def test_getMerchDetail_NotExist(self): ws = webservice() ws.login(self.UserShop.username, self.UserShop.password) merchDetail = ws.getMerchDetail(merchId='NotExist') self.assertEqual(merchDetail.model['merchDetail']['merchStatus'], '4')
def test_getMerchDetail_all(self): ws = webservice() ws.login(self.UserShop.username, self.UserShop.password) merchDetail = ws.getMerchDetail(merchId=self.Merch1.goodsId) self.assertGetMerchDetail(merchDetail, self.Merch1)
def test_getMerchDetail_noSalesRight(self): ws = webservice() ws.login(self.UserShop2.username, self.UserShop2.password) merchDetail = ws.getMerchDetail(merchId=self.Merch2.goodsId) self.assertEqual(merchDetail.model['merchDetail']['merchStatus'], '3')
def test_getMerchList_null(self): ws = webservice() ws.login(self.UserShop.username, self.UserShop.password) MerchList = ws.getMerchList(merchName="NotExist") self.assertEqual(MerchList.model['merchList'],[],"The merch list is not null.")