def test_a001(self): token = Zpt().cu_login() headers = { 'Content-Type': 'application/json;charset=UTF-8', 'token': token } conn = MySQL.connect_mall() cur = conn.cursor() sql = "select t.product_uuid, t.product_spec_uuid from shoping_info t where t.sp_id=" + spId + " and emp_id=" + \ cuEmpId cur.execute(sql) sql_result = cur.fetchone()[0:2] productUuid = sql_result[0] productSpecUuid = sql_result[1] url = "http://www.ejw.cn/shopingcart/" + cuComId params = { "productUuid": productUuid, "productSpecUuid": productSpecUuid, "spId": int(spId), "compId": int(cuComId), "empId": int(cuEmpId) } result = requests.post(url, data=json.dumps(params), headers=headers) result_exp = 200 # print(result_exp_pro, result_act_pro) self.assertEqual(result_exp, result.status_code, msg="请求参数异常或加入购物车失败") print("外商城商品加入购物车成功", result.text)
def test_b001_shop(self): conn = MySQL.connect_mall() cur = conn.cursor() sql = "select t.product_uuid, t.product_spec_uuid from shoping_info t where t.sp_id=" + spId + " and emp_id=" + \ cuEmpId cur.execute(sql) sql_result = cur.fetchone()[0:2] productUuid = sql_result[0] productSpecUuid = sql_result[1] url = "http://www.ejw.cn/shopingcart/" + cuComId params = {"productUuid": productUuid, "productSpecUuid": productSpecUuid, "spId": int(spId), "compId": int(cuComId), "empId": int(cuEmpId)} result = requests.post(url, data=json.dumps(params), headers=headers).text result_exp_pro = "01541123570722" # print(result_exp_pro, result_act_pro) self.assertIn(result_exp_pro, result, msg="请求参数异常或加入购物车失败") log.info("外商城商品加入购物车") log_exp.info(result_exp_pro) log_act.info(result)
adminEmpId = localReadConfig.read_admin_emp_id() spId = localReadConfig.read_sp_com_id() # # coding:utf-8 # a = [1, 3, 5, 7, 0, -1, -9, -4, -5, 8] # # # 用列表生成式,生成新的列表 # b = [i for i in a if i > 0] # print(b) # print("大于0的个数:%s" % len(b)) # # # 字符串切片 # a = "axbyczdjf" # print(a[::2]) conn = MySQL.connect_mall() cur = conn.cursor() sql = "select t.product_uuid, t.product_spec_uuid from shoping_info t where t.sp_id=" + spId + " and emp_id=" + \ cuEmpId cur.execute(sql) sql_result = cur.fetchone()[0:2] productUuid = sql_result[0] productSpecUuid = sql_result[1] url = "http://www.ejw.cn/shopingcart/" + cuComId params = {"productUuid": productUuid, "productSpecUuid": productSpecUuid, "spId": int(spId), "compId": int(cuComId), "empId": int(cuEmpId)} print(params)