Skip to content
GitLab
Switch branch/tag
Find file BlameHistoryPermalink
返利发放新增验证.py 2.63 KiB
Open in Web IDE
1 
# -*- encoding=utf8 -*-
2 
__author__ = "liguangyu"
3
4 
"""
5 
case_tag:cmdc_api,cmdc返利发放新增验证,2271,2271-40,sit,bs
6 
主数据平台:后台运营系统返利发放新增接口
7 
"""
8
9 
from common.common_func import commonFuc
10 
from air_case.cmdc_login.后台管理系统登录.后台管理系统登录 import CmdcDoLogin
11 
from common.db.db import mySql
12 
import requests
13 
import random
14 
import uuid
15 
import json
16
17 
module = "cmdc_rebate"
18
19 
# 第一步登录后台运营平台获取cmdc_access_token
20 
# 获取登录所需账号密码
21 
username = commonFuc().get_business_data(module, "username1")
22 
password = commonFuc().get_business_data(module, "password1")
23 
# 获取登录后Cmdc_access_token
24 
cmdc_access_token = CmdcDoLogin(username, password).get_token()
25 
headers = commonFuc().get_business_data(module, "json_headers", cmdc_access_token)
26
27 
# 生成返利发放规则主题
28 
theme = uuid.uuid4()
29 
# 生成可抵扣下单金额最高比例
30 
use_limit = random.randint(1, 99)
31 
# 第二步进行返利发放规则新增
32 
url = commonFuc().get_api_url() + commonFuc().get_business_data(module, "url43")
33 
request_body = commonFuc().get_business_data(module, "payload43", theme, use_limit)
34
35 
"""
36 
 场景: 返利发放新增验证
37 
 用例名称：返利发放新增验证
38 
 输出：{"rebateTheme":"%s"}
39 
"""
40
41 
# 发送请求
42 
result = requests.post(url, json=request_body, headers=headers)
43 
result = json.loads(result.content)
44 
# print(result)
45 
if result["success"]:
46 
    # 获取返利发放明细
47 
    rebate_trip_id = result["data"]["rebateTripId"]
48 
    rebate_theme = result["data"]["rebateTheme"]
49 
    print(rebate_trip_id)
50 
    # 数据库操作
51 
    mysql_handle = mySql()
52 
    # 获取conf.ini文件中配置的数据库信息
53 
    host, port, user, pwd = mysql_handle.getConf(db="cmdc_db")
54
55 
    # 数据库查询返利发放规则主题
56 
    sql = "SELECT t.rebateTheme FROM `cmdc-order`.tc_rebatetrip t WHERE rebateTripId = {}".format(rebate_trip_id)
57 
    result = {"rebateTheme": mysql_handle.selectSql(host, port, user, pwd, "cmdc-order", sql)[0][0]}
58 
    # print(result)
59 
    # 获取预期结果
60 
    check_dict = commonFuc().get_business_data(module, "checkDict43", rebate_theme)
61 
    # 断言实际结果中是否包含预期结果的内容
62 
    commonFuc().check_result(check_dict, result)
63 
    # 对新增的返利发放规则进行删除操作
64 
    sql = "DELETE FROM `cmdc-order`.tc_rebatetrip WHERE rebateTripId = {}".format(rebate_trip_id)
65 
    mysql_handle.executeUpdate(host, port, user, pwd, "cmdc-order", sql)
66 
else:
67 
    # 获取预期结果
68 
    check_dict = commonFuc().get_business_data(module, "checkDict43_1")
69 
    # 断言实际结果中是否包含预期结果的内容
70 
    commonFuc().check_result(check_dict, result)