def test_createOrderByShoppingcart_twoDealer(self): update('update dlcompany.dl_store_base_info set isCOD = ? where store_id = ?', 1,self.Merch4.storeId) ws = webservice() ws.login(self.UserShop.username, self.UserShop.password) ws.addShoppingcar(merchId=self.Merch1.goodsId, merchCount='1', sellerId=self.Merch1.seller_store_id, sellerName=self.Merch1.sellerName) shopcart1 = Shoppingcart.find_first('where user_id = ? and goods_id = ?', self.UserShop.userId, self.Merch1.goodsId) ws.addShoppingcar(merchId=self.Merch4.goodsId, merchCount='1', sellerId=self.Merch4.seller_store_id, sellerName=self.Merch4.sellerName) shopcart2 = Shoppingcart.find_first('where user_id = ? and goods_id = ?', self.UserShop.userId, self.Merch4.goodsId) invoice = {"invoiceId":self.UserShop.invoiceId, "invoiceType":"N011","needInvoice":"0","invoiceHeader":self.UserShop.invoiceHeader} deliverAddress = {"deliverAddress":self.UserShop.deliverAddress, "deliverMobile":self.UserShop.deliverMobile, "deliverPerson":self.UserShop.deliverPerson} sellerList = [] sellerList.append({"sellerId":self.Merch1.shopcartSellerId,"sellerName":self.Merch1.sellerName,"isYijipayAccount":self.Merch1.isYijipayAccount,"codFlag":self.Merch1.codFlag, "supportVatInvoice":self.Merch1.supportVatInvoice,"comment":"createOrderByShoppingcart comment.","merchList": [{"id":shopcart1.id,"merchId":self.Merch1.goodsId,"merchBarCode":self.Merch1.productBarCode}]}) sellerList.append({"sellerId":self.Merch4.shopcartSellerId,"sellerName":self.Merch4.sellerName,"isYijipayAccount":self.Merch4.isYijipayAccount,"codFlag":"0_split_0", "supportVatInvoice":self.Merch4.supportVatInvoice,"comment":"createOrderByShoppingcart comment.","merchList": [{"id":shopcart2.id,"merchId":self.Merch4.goodsId,"merchBarCode":self.Merch4.productBarCode}]}) order = ws.createOrderByShoppingcart(payWay='2',invoice=invoice, deliverAddress=deliverAddress, sellerList=sellerList) self.assertEqual(order.model['success'], '0') # 校验订单号和交易号是否匹配 orderInfoDb = select_one('select * from dlorder.dl_order_orderinfo where pay_no = ?', order.model['createOrderInfoModel']['cashOnDeliveryModelList'][0]['paymentNo']) # 支付方式为货到付款 self.assertEqual(orderInfoDb.pay_type, '2') self.assertEqual(orderInfoDb.order_no, order.model['createOrderInfoModel']['cashOnDeliveryModelList'][0]['orderNo']) self.assertEqual(orderInfoDb.order_amount, int(order.model['createOrderInfoModel']['cashOnDeliveryModelList'][0]['price'])) # 校验订单号和交易号是否匹配 orderInfoDb = select_one('select * from dlorder.dl_order_orderinfo where pay_no = ?', order.model['createOrderInfoModel']['cashOnDeliveryModelList'][1]['paymentNo']) # 支付方式为货到付款 self.assertEqual(orderInfoDb.pay_type, '2') self.assertEqual(orderInfoDb.order_no, order.model['createOrderInfoModel']['cashOnDeliveryModelList'][1]['orderNo']) self.assertEqual(orderInfoDb.order_amount, int(order.model['createOrderInfoModel']['cashOnDeliveryModelList'][1]['price']))
def tearDown(self): update( 'update dlorder.dl_order_orderinfo set order_status = ? where order_no = ?', 'C020', self.UserShop.orderNo) update( 'update dlorder.dl_order_orderinfo set order_status = ? where order_no = ?', 'C011', self.UserShop2.orderNo)
def tearDown(self): update( 'update dlmerchandise.dl_goods set on_hand_inventory = ? where goods_id = ?', self.Merch1.onHandInventory, self.Merch1.goodsId) update( 'update dlmerchandise.dl_goods set goods_status = \'01\' where goods_id = ?', self.Merch1.goodsId)
def test_AddChangeOrderPrice_Onlinepayment(self): ws = webservice() ws.login(self.UserShop2.username, self.UserShop2.password) update( 'update dlorder.dl_order_orderinfo set order_status = ? where order_no = ?', 'C011', self.UserShop2.orderNo) RstDb = select_one( 'select * from dlorder.dl_order_orderinfo where order_no = ?', self.UserShop2.orderNo) # 在线支付订单加价调用接口 ChangePriceRst = ws.changeOrderPrice( orderNo=self.UserShop2.orderNo, orderDiscountAmount='-100', orderChangeAmount=str(int(RstDb.order_retail_amount) + 100), orderStatus=RstDb.order_status) self.assertEquals(ChangePriceRst.code, 200) self.assertEquals(ChangePriceRst.model['success'], '0') # 检验订单加价后是否修改成功 RstDb1 = select_one( 'select * from dlorder.dl_order_orderinfo where order_no = ?', self.UserShop2.orderNo) self.assertEquals(RstDb1.order_amount, RstDb.order_retail_amount + 100) update( 'update dlorder.dl_order_orderinfo set order_amount = ? where order_no = ?', RstDb.order_retail_amount, self.UserShop2.orderNo)
def setUp(self): update( 'delete from danlu_cd_database.dl_shoppingcart where user_id = ?', self.UserShop.userId) update( 'update dlmerchandise.dl_goods set on_hand_inventory = ? where goods_id = ?', self.Merch1.onHandInventory, self.Merch1.goodsId)
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_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_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_checkSwitch_modify(self): update('update dlpromotionx.dl_promotionx_rule set rule_desc = ?,coupon_amount = ? where id = ?', '0', '5', '9') ws = webservice() ws.login(self.UserShop.username, self.UserShop.password) checkSwitch = ws.checkSwitch() self.assertEqual(checkSwitch.model['success'], '0') self.assertEqual(checkSwitch.model['bigCouponFlag'], '0') self.assertEqual(checkSwitch.model['amount'], '500')
def tearDown(self): # 还原终端店2的采购区域 update( 'update dlcompany.dl_biz_purchase set purchase_area_code = ? where company_id = ?', self.UserShop2.areaCode, self.UserShop2.companyId) # 还原商品1为上架状态 update( 'update dlmerchandise.dl_goods set goods_status = ? where goods_id = ?', '01', self.Merch1.goodsId)
def test_addShoppingcart_addMerchNoSold(self): ws = webservice() ws.login(self.UserShop.username, self.UserShop.password) update( 'update dlmerchandise.dl_goods set on_hand_inventory = ? where goods_id = ?', '0', self.Merch1.goodsId) addMerch = ws.addShoppingcar(merchId=self.Merch1.goodsId, merchCount='1', sellerId=self.Merch1.seller_store_id, sellerName=self.Merch1.sellerName) self.assertEqual(addMerch.model['success'], '2')
def test_getCouponList_All(self): ws = webservice() ws.login(self.UserShop.username, self.UserShop.password) merchList = [self.Merch1.goodsId] couponList = ws.getCouponList(companyId=self.UserShop.companyId, merchList=merchList) self.assertEquals(couponList.code, 200) self.assertEquals(couponList.model['success'], '0') self.assertEquals(len(couponList.model['useablecouponList']), 10) self.assertEquals(len(couponList.model['unUseablecouponList']), 2) update( 'update dlpromotionx.dl_promotionx_coupon_issue_record set issue_person = ? where issue_person = ? ', self.UserShop.companyId, 'testapp')
def setUp(self): update('update dlsms.dl_message set read_status = ? where id = ? ', '01', '00DCEE2C6A5942BBA097C3ACFFC47A8A') update('update dlsms.dl_message set read_status = ? where id = ? ', '01', '1FAFB941460847F0B96A9FFEA182A28F') update('update dlsms.dl_message set read_status = ? where id = ? ', '01', '0001486CC5724CD7A9B1B4AA085B3B69') update('update dlsms.dl_message set read_status = ? where id = ? ', '01', '09CCB8DBF42E41E583C9B76423941271')
def test_createOrderByShoppingcart_outStock(self): ws = webservice() ws.login(self.UserShop.username, self.UserShop.password) ws.addShoppingcar(merchId=self.Merch1.goodsId, merchCount='1', sellerId=self.Merch1.seller_store_id, sellerName=self.Merch1.sellerName) shopcart = Shoppingcart.find_first('where user_id = ? and goods_id = ?', self.UserShop.userId, self.Merch1.goodsId) # 设置库存为空 update('update dlmerchandise.dl_goods set on_hand_inventory = ? where goods_id = ?', 0, self.Merch1.goodsId) invoice = {"invoiceId":self.UserShop.invoiceId, "invoiceType":"N011","needInvoice":"0","invoiceHeader":self.UserShop.invoiceHeader} deliverAddress = {"deliverAddress":self.UserShop.deliverAddress, "deliverMobile":self.UserShop.deliverMobile, "deliverPerson":self.UserShop.deliverPerson} sellerList = [] sellerList.append({"sellerId":self.Merch1.shopcartSellerId,"sellerName":self.Merch1.sellerName,"isYijipayAccount":self.Merch1.isYijipayAccount,"codFlag":self.Merch1.codFlag, "supportVatInvoice":self.Merch1.supportVatInvoice,"comment":"createOrderByShoppingcart comment.","merchList": [{"id":shopcart.id,"merchId":self.Merch1.goodsId,"merchBarCode":self.Merch1.productBarCode}]}) order = ws.createOrderByShoppingcart(payWay='2',invoice=invoice, deliverAddress=deliverAddress, sellerList=sellerList) self.assertEqual(order.model['success'], '2') self.assertEqual(order.model['failedReasons']['noInventoryList'][0],self.Merch1.fullName)
def test_createOrderByShoppingcart_noSalerright(self): ws = webservice() ws.login(self.UserShop.username, self.UserShop.password) ws.addShoppingcar(merchId=self.Merch1.goodsId, merchCount='1', sellerId=self.Merch1.seller_store_id, sellerName=self.Merch1.sellerName) shopcart = Shoppingcart.find_first('where user_id = ? and goods_id = ?', self.UserShop.userId, self.Merch1.goodsId) # 设置为无售卖权 update('update dlsaleright.dl_one2many_salesright set buyer_type = ? where firstTier_salesRight_code = ? and buyer_type = ?', 'S016',self.Merch1.SalesrightCode, 'S011') #update('update dlsaleright.dl_firsttier_salesright set firstTier_salesRight_status = ? where seller_id = ? and product_barCode = ?', 99, self.Merch1.sellerId, self.Merch1.productBarCode) invoice = {"invoiceId":self.UserShop.invoiceId, "invoiceType":"N011","needInvoice":"0","invoiceHeader":self.UserShop.invoiceHeader} deliverAddress = {"deliverAddress":self.UserShop.deliverAddress, "deliverMobile":self.UserShop.deliverMobile, "deliverPerson":self.UserShop.deliverPerson} sellerList = [] sellerList.append({"sellerId":self.Merch1.shopcartSellerId,"sellerName":self.Merch1.sellerName,"isYijipayAccount":self.Merch1.isYijipayAccount,"codFlag":self.Merch1.codFlag, "supportVatInvoice":self.Merch1.supportVatInvoice,"comment":"createOrderByShoppingcart comment.","merchList": [{"id":shopcart.id,"merchId":self.Merch1.goodsId,"merchBarCode":self.Merch1.productBarCode}]}) time.sleep(2) order = ws.createOrderByShoppingcart(payWay='2',invoice=invoice, deliverAddress=deliverAddress, sellerList=sellerList) self.assertEqual(order.model['success'], '2') # 无售卖权invalidList,但实际是shelvesOffList self.assertEqual(order.model['failedReasons']['但实际是shelvesOffList'][0],self.Merch1.fullName)
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_AlreadypaidChangeOrderPrice_Onlinepayment(self): ws = webservice() ws.login(self.UserShop2.username, self.UserShop2.password) update( 'update dlorder.dl_order_orderinfo set order_status = ? where order_no = ?', 'C011', self.UserShop2.orderNo) RstDb = select_one( 'select * from dlorder.dl_order_orderinfo where order_no = ?', self.UserShop2.orderNo) # 从数据库中修改订单状态为已付款(C019) update( 'update dlorder.dl_order_orderinfo set order_status = ? where order_no = ?', 'C019', self.UserShop2.orderNo) ChangePriceRst = ws.changeOrderPrice( orderNo=self.UserShop2.orderNo, orderDiscountAmount='100', orderChangeAmount=str(int(RstDb.order_retail_amount) - 100), orderStatus=RstDb.order_status) # 校验已完成的订单改价失败 self.assertEquals(ChangePriceRst.model['success'], '1') update( 'update dlorder.dl_order_orderinfo set order_status = ? where order_no = ?', 'C011', self.UserShop2.orderNo)
def test_changeOrderPrice_cashondelivery(self): ws = webservice() ws.login(self.UserShop.username, self.UserShop.password) RstDb = select_one( 'select * from dlorder.dl_order_orderinfo where order_no = ?', self.UserShop.orderNo) # 货到付款订单减价调用接口 ChangePriceRst = ws.changeOrderPrice( orderNo=self.UserShop.orderNo, orderDiscountAmount='100', orderChangeAmount=str(int(RstDb.order_retail_amount) - 100), orderStatus=RstDb.order_status) self.assertEquals(ChangePriceRst.code, 200) self.assertEquals(ChangePriceRst.model['success'], '0') # 检验订单减价后是否修改成功 RstDb1 = select_one( 'select * from dlorder.dl_order_orderinfo where order_no = ?', self.UserShop.orderNo) self.assertEquals(RstDb1.order_amount, RstDb.order_retail_amount - 100) #货到付款订单加价 ChangePriceRst1 = ws.changeOrderPrice( orderNo=self.UserShop.orderNo, orderDiscountAmount='-200', orderChangeAmount=str(RstDb1.order_retail_amount + 200), orderStatus=RstDb1.order_status) self.assertEquals(ChangePriceRst1.code, 200) self.assertEquals(ChangePriceRst1.model['success'], '0') #检验订单加价 RstDb2 = select_one( 'select * from dlorder.dl_order_orderinfo where order_no = ?', self.UserShop.orderNo) self.assertEquals(RstDb2.order_amount, RstDb.order_amount + 200) update( 'update dlorder.dl_order_orderinfo set order_amount = ? where order_no = ?', RstDb.order_retail_amount, self.UserShop.orderNo)
def test_AlreadCancelChangeOrderPrice_cashondelivery(self): ws = webservice() ws.login(self.UserShop.username, self.UserShop.password) RstDb = select_one( 'select * from dlorder.dl_order_orderinfo where order_no = ?', self.UserShop.orderNo) # 从数据库中修改订单状态为已取消(C012) update( 'update dlorder.dl_order_orderinfo set order_status = ? where order_no = ?', 'C012', self.UserShop.orderNo) ChangePriceRst = ws.changeOrderPrice( orderNo=self.UserShop.orderNo, orderDiscountAmount='100', orderChangeAmount=str(int(RstDb.order_retail_amount) - 100), orderStatus=RstDb.order_status) #校验已取消的订单改价失败 self.assertEquals(ChangePriceRst.model['success'], '1') update( 'update dlorder.dl_order_orderinfo set order_status = ? where order_no = ?', 'C020', self.UserShop.orderNo)
def tearDown(self): # 清空购物车、恢复库存 update('delete from danlu_cd_database.dl_shoppingcart where user_id = ?', self.UserShop.userId) update('update dlmerchandise.dl_goods set on_hand_inventory = ? where goods_id = ?', self.Merch1.onHandInventory, self.Merch1.goodsId) update('update dlmerchandise.dl_goods set on_hand_inventory = ? where goods_id = ?', self.Merch2.onHandInventory, self.Merch2.goodsId) update('update dlmerchandise.dl_goods set on_hand_inventory = ? where goods_id = ?', self.Merch4.onHandInventory, self.Merch4.goodsId) # 恢复经销商2为不支持货到付款 update('update dlcompany.dl_store_base_info set isCOD = ? where store_id = ?', 0,self.Merch4.storeId) # 恢复商品1的售卖权 #update('update dlsaleright.dl_firsttier_salesright set firstTier_salesRight_status = ? where seller_id = ? and product_barCode = ?', 0, self.Merch1.sellerId, self.Merch1.productBarCode) update('update dlsaleright.dl_one2many_salesright set buyer_type = ? where firstTier_salesRight_code = ? and buyer_type = ?', 'S011',self.Merch1.SalesrightCode, 'S016')
def tearDown(self): # 还原终端店2的采购区域 update( 'update dlcompany.dl_biz_purchase set purchase_area_code = ? where company_id = ?', self.UserShop2.areaCode, self.UserShop2.companyId)
def tearDown(self): update('update dlpromotionx.dl_promotionx_rule set rule_desc = ?,coupon_amount = ? where id = ?', self.Param.bigCouponFlag, str(int(self.Param.amount)/100), '9')
def setUp(self): update( 'delete from danlu_cd_database.dl_shoppingcart where user_id = ?', self.UserShop.userId)
def initOrder(): UserShop = eData('TmlShop') Merch = eData('Merch1') #Merch4 = eData('Merch4') DealMgr = eData('DealMager') ws = webservice() ws.login(DealMgr.username, DealMgr.password) #在线支付待付款订单(C011) orderOnlineWaitPay = createOrder(UserShop, Merch, payWay='1') orderOnlineWaitPay.pop('ws') write_excel(sheetname='TmlShop', rowkey='orderOnlineWaitPay', rowvalue=str(orderOnlineWaitPay)) import datetime update( 'update dlorder.dl_order_orderinfo SET gmt_created = ? WHERE order_no = ?', datetime.datetime.strptime('2099-01-01 00:00:00', "%Y-%m-%d %H:%M:%S"), orderOnlineWaitPay.orderNo) #在线支付待发货订单 #在线支付待收货订单 #在线支付交易完成订单 #在线支付已取消订单(C012) orderOnlienCancel = createOrder(UserShop, Merch, payWay='1') orderOnlienCancelWS = orderOnlienCancel.pop('ws') write_excel(sheetname='TmlShop', rowkey='orderOnlienCancel', rowvalue=str(orderOnlienCancel)) orderOnlienCancelWS.cancel(paymentNo=orderOnlienCancel.paymentNo, payType='1', cancelType='1') #货到付款待发货订单(C020) orderCodWaitDeliver = createOrder(UserShop, Merch) orderCodWaitDeliver.pop('ws') write_excel(sheetname='TmlShop', rowkey='orderCodWaitDeliver', rowvalue=str(orderCodWaitDeliver)) #货到付款待收货订单(C017) orderCodWaitReceive = createOrder(UserShop, Merch) orderCodWaitReceive.pop('ws') write_excel(sheetname='TmlShop', rowkey='orderCodWaitReceive', rowvalue=str(orderCodWaitReceive)) ws.deliver(orderNo=orderCodWaitReceive.orderNo) #货到付款已完成订单(C019) orderCodComplete = createOrder(UserShop, Merch) orderCodComplete.pop('ws') write_excel(sheetname='TmlShop', rowkey='orderCodComplete', rowvalue=str(orderCodComplete)) ws.deliver(orderNo=orderCodComplete.orderNo) codPay(orderNo=orderCodComplete.orderNo) #货到付款已取消订单(C012) orderCodCancel = createOrder(UserShop, Merch) orderCodCancelWS = orderCodCancel.pop('ws') write_excel(sheetname='TmlShop', rowkey='orderCodCancel', rowvalue=str(orderCodCancel)) orderCodCancelWS.cancel(paymentNo=orderCodCancel.paymentNo)
def tearDown(self): update( 'update dlpromotionx.dl_promotionx_coupon_issue_record set issue_person = ? where issue_person = ? ', self.UserShop.companyId, 'testapp')
def tearDown(self): update('update dluser.dl_user set user_passwd= ? where user_id = ?', hashlib.md5(self.UserShop.password).hexdigest(), self.UserShop.userId)
def tearDown(self): update( 'delete from danlu_cd_database.dl_shoppingcart where user_id = ?', self.UserShop2.userId)