def test_ProjectUpdateName(self,data):
projectname = str(data["projectname"])
department = str(data["department"])
case_describe = str(data["case_describe"])
expected_code = int(data["expected_code"])
readconfig=ReadConfig.ReadConfig()
readdb = ReadDB.Pyodbc()
if department == 'investment':
projectid = readconfig.get_project('projectinvestmentid')
elif department == 'factoring':
projectid = readconfig.get_project('projectfactoringid')
url = readconfig.get_basedata('crm_url')+api.format(projectid)
session = readconfig.get_basedata('member_session')
requestid = str(uuid.uuid1())
headers = {'Content-Type': "application/json",'Authorization':session,"x-requestid":requestid}
payload ={
"projectName":projectname
}
r = requests.post(url=url,data = json.dumps(payload),headers = headers)
#处理请求数据到excl用例文件
excel.set_cell(sheet_name,int(data["case_id"]),excel.get_sheet_colname(sheet_name)["result_code"],r.status_code,excel.set_color(r.status_code))
excel.set_cell(sheet_name,int(data["case_id"]),excel.get_sheet_colname(sheet_name)["result_msg"],r.text,excel.set_color())
excel.save()
#数据对比
if r.status_code==expected_code:
projectdetails = readdb.GetProjectDetailsinfo(projectid)
self.assertEqual(projectdetails['projectname'],projectname,case_describe + ",接口：{0}".format(api))
else:
self.assertEqual(r.status_code,expected_code,case_describe + ",接口：{0}".format(api))
def test_CustomerUpdateType(self,data):
Type = int(data["type"])
customertab = str(data["customertab"])
case_describe = str(data["case_describe"])
readconfig=ReadConfig.ReadConfig()
readdb = ReadDB.Pyodbc()
correlationid = readconfig.get_customer(customertab)
url = readconfig.get_basedata('crm_url')+api.format(correlationid)
session = readconfig.get_basedata('member_session')
requestid = str(uuid.uuid1())
headers = {'Content-Type': "application/json",'Authorization':session,"x-requestid":requestid}
payload ={
"customerTypeId":Type
}
r = requests.post(url=url,data = json.dumps(payload),headers = headers)
#处理请求数据到excl用例文件
excel.set_cell(sheet_name,int(data["case_id"]),excel.get_sheet_colname(sheet_name)["result_code"],r.status_code,excel.set_color(r.status_code))
excel.set_cell(sheet_name,int(data["case_id"]),excel.get_sheet_colname(sheet_name)["result_msg"],r.text,excel.set_color())
excel.save()
#数据对比
if r.status_code==200:
customerdetails = readdb.GetCustomerDetailsinfo(correlationid)
self.assertEqual(int(customerdetails['customerTypeId']),Type,case_describe + ",接口：{0}".format(api))
else:
self.assertEqual(r.status_code,200,case_describe + ",接口：{0}".format(api))
def test_ClientOne(self):
readconfig = ReadConfig.ReadConfig()
readdb = ReadDB.Pymssql()
url = readconfig.get_url('url') + api
session = readconfig.get_member('session')
origin = readconfig.get_url('origin')
headers = {
'Content-Type': "application/json",
'Authorization': session,
"Origin": origin
}
r = requests.get(url=url, headers=headers)
if r.status_code == 200:
clientinfo = readdb.GetClientinfo(
readconfig.get_client('clientid1'))
self.assertEqual(r.json()[0]['display'], clientinfo['display'],
case_describe)
self.assertEqual(r.json()[0]['level'], clientinfo['level'],
case_describe)
self.assertEqual(r.json()[0]['status'], clientinfo['status'],
case_describe)
else:
self.assertEqual(r.status_code, 200, case_describe)
def test_CodeSend(self, data):
excel = ReadExcl.Xlrd()
readconfig = ReadConfig.ReadConfig()
#填写求求参数h
url = readconfig.get_url('url') + api
payload = {
"Phone": str(data["phone"]),
"CodeType": int(data["type"]),
"Domain": 'sss'
}
headers = {"Content-Type": "application/json"}
r = requests.post(url=url, data=json.dumps(payload), headers=headers)
#处理请求数据到excl用例文件
excel.set_cell(sheet_name, int(data["case_id"]),
excel.get_sheet_colname(sheet_name)["result_code"],
r.status_code, excel.set_color(r.status_code))
excel.set_cell(sheet_name, int(data["case_id"]),
excel.get_sheet_colname(sheet_name)["result_msg"],
r.text, excel.set_color())
excel.save()
#存储数据到本地config数据文件
if r.status_code == 200 or r.status_code == 204:
readconfig.set_member('phone', str(data['phone']))
readconfig.save()
self.assertEqual(r.status_code, data['expected_code'],
data["case_describe"])
def test_ProjectAll(self, data):
peojecttype = str(data["peojecttype"])
case_describe = str(data["case_describe"])
expected_code = int(data["expected_code"])
readconfig = ReadConfig.ReadConfig()
readdb = ReadDB.Pyodbc()
customerid = readconfig.get_customer(peojecttype)
url = readconfig.get_basedata('crm_url') + api.format(customerid)
session = readconfig.get_basedata('member_session')
requestid = str(uuid.uuid1())
headers = {
'Content-Type': "application/json",
'Authorization': session,
"x-requestid": requestid
}
r = requests.get(url=url, headers=headers)
if r.status_code == 200:
projectincustomerid = readdb.GetProjectInCustomerinfo(customerid)
responeprojectincustomerid = []
for i in range(len(r.json())):
responeprojectincustomerid.append(r.json()[i]['id'])
self.assertIn(r.json()[i]['id'].upper(), projectincustomerid,
case_describe + ",接口：{0}".format(api))
self.assertEqual(len(responeprojectincustomerid),
len(projectincustomerid),
case_describe + ",接口：{0}".format(api))
else:
self.assertEqual(r.status_code, 200,
case_describe + ",接口：{0}".format(api))
def test_Token(self, data):
excel = ReadExcl.Xlrd()
readconfig = ReadConfig.ReadConfig()
#填写求求参数
url = readconfig.get_url('url') + api
payload = {
"grant_type": str(data["grant_type"]),
"phone": str(data["phone"]),
"code": str(data["code"])
}
r = requests.post(url=url, data=payload)
#处理请求数据到excl用例文件
excel.set_cell(sheet_name, int(data["case_id"]),
excel.get_sheet_colname(sheet_name)["result_code"],
r.status_code, excel.set_color(r.status_code))
excel.set_cell(sheet_name, int(data["case_id"]),
excel.get_sheet_colname(sheet_name)["result_msg"],
r.text, excel.set_color())
excel.save()
#存储数据到本地config数据文件
if r.status_code == 200 or r.status_code == 204:
session = r.json()["token_type"] + " " + r.json()["access_token"]
readconfig.set_member('session', session)
readconfig.save()
self.assertEqual(r.status_code, data['expected_code'],
data["case_describe"])
def test_Blog(self):
readconfig = ReadConfig.ReadConfig()
readdb = ReadDB.Pymssql()
url = readconfig.get_url('url') + api
session = readconfig.get_member('session')
origin = readconfig.get_url('origin')
headers = {
'Content-Type': "application/json",
'Authorization': session,
"Origin": origin
}
r = requests.get(url=url, headers=headers)
if r.status_code == 200:
self.assertIn('id', r.json(), case_describe)
customerinfo = readdb.GetBlog(readconfig.get_member('phone'))
self.assertEqual(r.json()['id'], customerinfo['blogid'],
case_describe)
self.assertEqual(r.json()['phone'], customerinfo['phone'],
case_describe)
self.assertEqual(r.json()['companyName'],
customerinfo['companyName'], case_describe)
self.assertEqual(r.json()['nickname'], customerinfo['nickname'],
case_describe)
readconfig.set_member('blogid', customerinfo['blogid'])
else:
self.assertEqual(200, r.status_code, case_describe)
def test_CustomerProperty(self):
readconfig=ReadConfig.ReadConfig()
readdb = ReadDB.Pyodbc()
url = readconfig.get_basedata('crm_url')+api2
session = readconfig.get_basedata('member_session')
headers = {'Content-Type': "application/json",'Authorization':session}
r = requests.get(url=url, headers = headers)
if r.status_code==200:
customerpropertylabel = readdb.PropertyLabel(readconfig.get_labelmodule('customermodule'))
for i in range(len(r.json()['customerLabel'])):
for ii in range(len(customerpropertylabel)):
if r.json()['customerLabel'][i]['id'] == customerpropertylabel[ii]['id']:
self.assertEqual(r.json()['customerLabel'][i]['groupName'],customerpropertylabel[ii]['groupname'],case_describe + ",接口：{0}".format(api))
self.assertEqual(r.json()['customerLabel'][i]['departmentId'],customerpropertylabel[ii]['departmentid'],case_describe + ",接口：{0}".format(api))
# self.assertEqual(r.json()['customerLabel'][i]['functionModule'],contactpropertylabel[ii]['functionmodule'],case_describe + ",接口：{0}".format(api))
self.assertEqual(r.json()['customerLabel'][i]['isMultiple'],customerpropertylabel[ii]['ismultiple'],case_describe + ",接口：{0}".format(api))
self.assertEqual(r.json()['customerLabel'][i]['backgroundColor'],customerpropertylabel[ii]['backgroundcolor'],case_describe + ",接口：{0}".format(api))
self.assertEqual(r.json()['customerLabel'][i]['foregroundColor'],customerpropertylabel[ii]['foregroundcolor'],case_describe + ",接口：{0}".format(api))
for iii in range(len(r.json()['customerLabel'][i]['labels'])):
for iiii in range(len(customerpropertylabel[ii]['labels'])):
if r.json()['customerLabel'][i]['labels'][iii]['id'] == customerpropertylabel[ii]['labels'][iiii]['id']:
self.assertEqual(r.json()['customerLabel'][i]['labels'][iii]['name'],r.json()['customerLabel'][i]['labels'][iii]['name'],case_describe + ",接口：{0}".format(api))
self.assertEqual(len(r.json()['customerLabel'][i]['labels']),len(customerpropertylabel[ii]['labels']),case_describe + ",接口：{0}".format(api))
myDepartments = readdb.GetMyDepartments(readconfig.get_basedata('employeeid'))
for a in range(len(r.json()['myDepartments'])):
for aa in range(len(myDepartments)):
if r.json()['myDepartments'][a]['id'] == myDepartments[aa]['id']:
self.assertEqual(r.json()['myDepartments'][a]['name'],myDepartments[aa]['name'],case_describe + ",接口：{0}".format(api))
self.assertEqual(r.json()['myDepartments'][a]['queryLabelDepartmentId'],myDepartments[aa]['querylabeldepartmentid'],case_describe + ",接口：{0}".format(api))
self.assertEqual(len(r.json()['myDepartments']),len(myDepartments),case_describe + ",接口：{0}".format(api))
else:
self.assertEqual(r.status_code,200,case_describe + ",接口：{0}".format(api))
def ExtractField():
"""This function will read fields information"""
_config_dict = ReadConfig.ReadConfig()
_fr = None
_field_list = []
with open(_config_dict['fieldFile'],'r') as _fr:
_field_descriptor = _fr.readline().split() #read the first line of the field_config.txt
#print _field_descriptor
for line in _fr:
_field_content = line.split() #read each field and its infomation
#fill every field into a list
i = 0
_field_dict = {}
while(i < len(_field_content)):
# replace str "1" with True and "0" with False
if("1" == _field_content[i]):
_field_content[i] = True
elif("0" == _field_content[i]):
_field_content[i] = False
else:
#print "Error!",__file__,inspect.currentframe().f_back.f_lineno
pass
_field_dict[_field_descriptor[i]] = _field_content[i]
i += 1
_field_list.append(_field_dict)
#print _field_list
return _field_list
def test_ContactUpdateLabels(self,data):
labels = list(map(int,str(data["labels"]).split(',')))
case_describe = str(data["case_describe"])
expected_code = int(data["expected_code"])
readconfig=ReadConfig.ReadConfig()
readdb = ReadDB.Pyodbc()
contactid = readconfig.get_contact('contact'+str(data["case_id"]))
url = readconfig.get_basedata('crm_url')+api.format(contactid)
session = readconfig.get_basedata('member_session')
requestid = str(uuid.uuid1())
headers = {'Content-Type': "application/json",'Authorization':session,"x-requestid":requestid}
payload ={
"labels":labels
}
r = requests.post(url=url,data = json.dumps(payload),headers = headers)
#处理请求数据到excl用例文件
excel.set_cell(sheet_name,int(data["case_id"]),excel.get_sheet_colname(sheet_name)["result_code"],r.status_code,excel.set_color(r.status_code))
excel.set_cell(sheet_name,int(data["case_id"]),excel.get_sheet_colname(sheet_name)["result_msg"],r.text,excel.set_color())
excel.save()
#数据对比
if r.status_code == expected_code:
contactdetails = readdb.GetContactDetailsinfo(contactid)
for i in range(len(contactdetails['labels'])):
self.assertIn(contactdetails['labels'][i],labels,case_describe + ",接口：{0}".format(api))
self.assertEqual(len(contactdetails['labels']),len(labels),case_describe + ",接口：{0}".format(api))
else:
self.assertEqual(r.status_code,expected_code,case_describe + ",接口：{0}".format(api))
def test_ScheduleAdd(self, data):
customertype = str(data['customertype'])
time = int(data["time"])
summary = str(data['summary']) + str(data['case_id'])
minutes = str(data['minutes'])
cc = str(data['cc'])
expected_code = int(data["expected_code"])
case_describe = str(data["case_describe"])
excel = ReadExcl.Xlrd()
readconfig = ReadConfig.ReadConfig()
readdb = ReadDB.Pyodbc()
customerid = readconfig.get_customer(customertype)
url = readconfig.get_basedata('crm_url') + api
session = readconfig.get_basedata('member_session')
requestid = str(uuid.uuid1())
headers = {
'Content-Type': "application/json",
'Authorization': session,
"x-requestid": requestid
}
payload = {
"beginTime": "2018-12-28 02:13:06.178",
"endTime": "2018-12-28 02:13:06.178",
"summary": "string",
"minutes": 0,
"cc": "string",
"customerId": "string"
}
def __init__(self, ):
readconfig = ReadConfig.ReadConfig()
DBIp = readconfig.get_db('ip')
DBUserName = readconfig.get_db('username')
DBPassWord = readconfig.get_db('password')
DBName = readconfig.get_db('dbname')
self.conn = pymssql.connect(DBIp, DBUserName, DBPassWord, DBName)
self.cursor = self.conn.cursor()
def __init__(self, init_window_name):
self.init_window_name = init_window_name
self.menu()
# 读配置文件
self.config = ReadConfig.ReadConfig()
# 初始化服务
self.service = Service.Service()
self.utiltools = UtilTools.UtilTools()
def __init__(self, ):
proDir = ReadConfig.proDir
readconfig = ReadConfig.ReadConfig()
xls_name = readconfig.get_basedata('testcase_xls_name')
self.xlsPath = os.path.join(proDir, 'testfile', xls_name)
self.openfile = xlrd.open_workbook(self.xlsPath,
'w',
formatting_info=True)
self.newfile = copy(self.openfile)
def test_CustomerDetails(self, data):
customertab = str(data["customertab"])
case_describe = str(data["case_describe"])
readconfig = ReadConfig.ReadConfig()
readdb = ReadDB.Pyodbc()
correlationid = readconfig.get_customer(customertab)
url = readconfig.get_basedata('crm_url') + api.format(correlationid)
session = readconfig.get_basedata('member_session')
headers = {
'Content-Type': "application/json",
'Authorization': session
}
r = requests.get(url=url, headers=headers)
#处理请求数据到excl用例文件
excel.set_cell(sheet_name, int(data["case_id"]),
excel.get_sheet_colname(sheet_name)["result_code"],
r.status_code, excel.set_color(r.status_code))
excel.set_cell(sheet_name, int(data["case_id"]),
excel.get_sheet_colname(sheet_name)["result_msg"],
r.text, excel.set_color())
excel.save()
#数据对比
if r.status_code == 200:
customerdetails = readdb.GetCustomerDetailsinfo(correlationid)
self.assertEqual(customerdetails['name'],
r.json()['name'],
case_describe + ",接口：{0}".format(api))
self.assertEqual(customerdetails['shortName'],
r.json()['shortName'],
case_describe + ",接口：{0}".format(api))
self.assertEqual(customerdetails['city'],
r.json()['city'],
case_describe + ",接口：{0}".format(api))
self.assertEqual(customerdetails['state'],
r.json()['state'],
case_describe + ",接口：{0}".format(api))
self.assertEqual(int(customerdetails['customerProspectId']),
r.json()['customerProspectId'],
case_describe + ",接口：{0}".format(api))
self.assertEqual(int(customerdetails['customerTypeId']),
r.json()['customerTypeId'],
case_describe + ",接口：{0}".format(api))
self.assertEqual(int(customerdetails['customerKind']),
r.json()['customerKind'],
case_describe + ",接口：{0}".format(api))
else:
self.assertEqual(r.status_code, 200,
case_describe + ",接口：{0}".format(api))
def __init__(self, ):
driver = 'SQL Server Native Client 11.0' # 因版本不同而异
readconfig = ReadConfig.ReadConfig()
DBIp = readconfig.get_basedata('db_ip')
DBUserName = readconfig.get_basedata('db_username')
DBPassWord = readconfig.get_basedata('db_password')
DBName = readconfig.get_basedata('db_dbname')
self.conn = pyodbc.connect(driver=driver,
server=DBIp,
user=DBUserName,
password=DBPassWord,
database=DBName)
self.cursor = self.conn.cursor()
def test_ClientAdd(self, data):
excel = ReadExcl.Xlrd()
readconfig = ReadConfig.ReadConfig()
readdb = ReadDB.Pymssql()
#填写求求参数
url = readconfig.get_url('url') + api
session = readconfig.get_member('session')
origin = readconfig.get_url('origin')
headers = {
'Content-Type': "application/json",
'Authorization': session,
"Origin": origin
}
payload = {
"display": str(data["display"]),
"phone": str(data["phone"]),
"level": str(data["level"])
}
r = requests.post(url=url, headers=headers, data=json.dumps(payload))
#处理请求数据到excl用例文件
excel.set_cell(sheet_name, int(data["case_id"]),
excel.get_sheet_colname(sheet_name)["result_code"],
r.status_code, excel.set_color(r.status_code))
excel.set_cell(sheet_name, int(data["case_id"]),
excel.get_sheet_colname(sheet_name)["result_msg"],
r.text, excel.set_color())
excel.save()
if r.status_code == 200 or r.status_code == 204:
self.assertIn('id', r.json(), data["case_describe"])
clientinfo = readdb.GetClientinfo(r.json()['id'])
self.assertEqual(clientinfo['display'], str(data["display"]),
data["case_describe"])
self.assertEqual(clientinfo['level'], data['level'],
data["case_describe"])
self.assertEqual(clientinfo['phone'], str(data["phone"]),
data["case_describe"])
self.assertEqual(clientinfo['companyId'],
readconfig.get_member('companyId'),
data["case_describe"])
self.assertEqual(clientinfo['customerId'],
readconfig.get_member('customerId'),
data["case_describe"])
readconfig.set_client('clientid' + str(data['level']),
r.json()['id'])
self.assertEqual(r.status_code, data['expected_code'],
data["case_describe"])
def test_ProjectDetail(self,data):
peojecttype = str(data["peojecttype"])
case_describe = str(data["case_describe"])
expected_code = int(data["expected_code"])
readconfig=ReadConfig.ReadConfig()
readdb = ReadDB.Pyodbc()
projectid = readconfig.get_project(peojecttype)
url = readconfig.get_basedata('crm_url')+api.format(projectid)
session = readconfig.get_basedata('member_session')
requestid = str(uuid.uuid1())
headers = {'Content-Type': "application/json",'Authorization':session,"x-requestid":requestid}
r = requests.get(url=url,headers = headers)
#处理请求数据到excl用例文件
excel.set_cell(sheet_name,int(data["case_id"]),excel.get_sheet_colname(sheet_name)["result_code"],r.status_code,excel.set_color(r.status_code))
excel.set_cell(sheet_name,int(data["case_id"]),excel.get_sheet_colname(sheet_name)["result_msg"],r.text,excel.set_color())
excel.save()
#数据对比
if r.status_code==200 or r.status_code ==204:
projectinfo = readdb.GetProjectDetailsinfo(projectid)
if peojecttype =='projectinvestmentid':
self.assertEqual(projectinfo['projectname'],r.json()['projectName'],case_describe + ",接口：{0}".format(api))
self.assertEqual(projectinfo['departmentid'],r.json()['departmentId'],case_describe + ",接口：{0}".format(api))
self.assertEqual(int(projectinfo['amount']),int(r.json()['investment']['amount']),case_describe + ",接口：{0}".format(api))
self.assertEqual(int(projectinfo['estimate']),int(r.json()['investment']['estimate']),case_describe + ",接口：{0}".format(api))
self.assertEqual(projectinfo['conditions'],r.json()['investment']['conditions'],case_describe + ",接口：{0}".format(api))
self.assertEqual(projectinfo['commitment'],r.json()['investment']['commitment'],case_describe + ",接口：{0}".format(api))
self.assertEqual(projectinfo['newsituation'],r.json()['investment']['newSituation'],case_describe + ",接口：{0}".format(api))
readconfig.set_project('projectinvestmentid',requestid)
elif peojecttype =='projectfactoringid':
self.assertEqual(projectinfo['projectname'],r.json()['projectName'],case_describe + ",接口：{0}".format(api))
self.assertEqual(projectinfo['departmentid'],r.json()['departmentId'],case_describe + ",接口：{0}".format(api))
self.assertEqual(projectinfo['sellername'],r.json()['factoring']['sellerName'],case_describe + ",接口：{0}".format(api))
self.assertEqual(projectinfo['buyername'],r.json()['factoring']['buyerName'],case_describe + ",接口：{0}".format(api))
self.assertEqual(projectinfo['businesstarget'],r.json()['factoring']['businessTarget'],case_describe + ",接口：{0}".format(api))
self.assertEqual(projectinfo['businesstype'],r.json()['factoring']['businessType'],case_describe + ",接口：{0}".format(api))
self.assertEqual(projectinfo['guarantee'],r.json()['factoring']['guarantee'],case_describe + ",接口：{0}".format(api))
self.assertEqual(projectinfo['quota'],r.json()['factoring']['quota'],case_describe + ",接口：{0}".format(api))
self.assertEqual(projectinfo['period'],r.json()['factoring']['period'],case_describe + ",接口：{0}".format(api))
self.assertEqual(int(projectinfo['interestrate1']),r.json()['factoring']['interestRate1'],case_describe + ",接口：{0}".format(api))
self.assertEqual(int(projectinfo['interestrate2']),r.json()['factoring']['interestRate2'],case_describe + ",接口：{0}".format(api))
self.assertEqual(int(projectinfo['interestrate3']),r.json()['factoring']['interestRate3'],case_describe + ",接口：{0}".format(api))
readconfig.set_project('projectfactoringid',requestid)
self.assertEqual(r.status_code,expected_code,case_describe + ",接口：{0}".format(api))
def test_CodeVerify(self, data):
readconfig=ReadConfig.ReadConfig()
excel = ReadExcl.Xlrd()
#填写求求参数
url = readconfig.get_url('url')+api
payload = {"phone":str(data["phone"]),"codeType":int(data["type"]),"code":str(data["code"])}
r = requests.get(url=url,params = payload)
# 处理请求数据到excl用例文件
excel.set_cell(sheet_name,int(data["case_id"]),excel.get_sheet_colname(sheet_name)["result_code"],r.status_code,excel.set_color(r.status_code))
excel.set_cell(sheet_name,int(data["case_id"]),excel.get_sheet_colname(sheet_name)["result_msg"],r.text,excel.set_color(r.status_code))
excel.save()
self.assertEqual(r.status_code,data['expected_code'],data["case_describe"])
def test_ClientMaintain(self, data):
readdb = ReadDB.Pymssql()
excel = ReadExcl.Xlrd()
readconfig = ReadConfig.ReadConfig()
#填写求求参数
url = readconfig.get_url('url') + api
session = readconfig.get_member('session')
origin = readconfig.get_url('origin')
headers = {
'Content-Type': "application/json",
'Authorization': session,
"Origin": origin
}
readdb.SetCustomerMoney(str(data["money"]),
readconfig.get_member('userid'))
if data['isone']:
payload = [{
"id": readconfig.get_client('clientid2'),
"display": "qqq"
}]
else:
payload = [{
"id": readconfig.get_client('clientid3'),
"display": "qqq"
}, {
"id": readconfig.get_client('clientid4'),
"display": "qqq"
}]
r = requests.post(url=url, headers=headers, data=json.dumps(payload))
#处理请求数据到excl用例文件
excel.set_cell(sheet_name, int(data["case_id"]),
excel.get_sheet_colname(sheet_name)["result_code"],
r.status_code, excel.set_color(r.status_code))
excel.set_cell(sheet_name, int(data["case_id"]),
excel.get_sheet_colname(sheet_name)["result_msg"],
r.text, excel.set_color())
excel.save()
if r.status_code == 200 or r.status_code == 204:
orderprice = readdb.GetClientMaintainOrder(r.json()['orderId'])
usermoney = readdb.GetUserMoney(readconfig.get_member('userid'))
self.assertEqual(orderprice, usermoney, data["case_describe"])
self.assertEqual(r.status_code, data['expected_code'],
data["case_describe"])
def __init__(self):
self.headers = {
'Referer': 'https://jxjyxb.bucm.edu.cn/stu.html',
'User-Agent':
'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.90 Safari/537.36',
'Host': 'jxjyxb.bucm.edu.cn'
}
self.login_url = 'https://jxjyxb.bucm.edu.cn/stu.html#/login'
self.post_url = 'https://jxjyxb.bucm.edu.cn/api/v1/student/main/login'
self.logined_url = 'https://jxjyxb.bucm.edu.cn/stu.html#/xuexi/benxueqi'
self.session = requests.Session()
# 读配置文件
self.config = ReadConfig.ReadConfig()
# 初始化学生选做作业信息
self.selectworkService = SelectWorkService.SelectWorkService()
self.selectworkService.utiltools = self.utiltools
self.selectCourseService = SelectCourse.SelectCourseService()
self.selectCourseService.utiltools = self.utiltools
def test_CustomerSubordinate(self):
readconfig=ReadConfig.ReadConfig()
readdb = ReadDB.Pyodbc()
url = readconfig.get_basedata('crm_url')+api
session = readconfig.get_basedata('member_session')
headers = {'Content-Type': "application/json",'Authorization':session}
r = requests.get(url=url, headers = headers)
if r.status_code==200:
customersubordinateid = readdb.GetCustomerSubordinateinfo(readconfig.get_basedata('employeeid'))
responecustomersubordinateid = []
for i in range(len(r.json()['list'])):
responecustomersubordinateid.append(r.json()['list'][i]['id'])
self.assertIn(r.json()['list'][i]['id'].upper(),customersubordinateid,case_describe + ",接口：{0}".format(api))
self.assertEqual(len(responecustomersubordinateid),len(customersubordinateid),case_describe + ",接口：{0}".format(api))
self.assertEqual(r.json()['count'],len(customersubordinateid),case_describe + ",接口：{0}".format(api))
else:
self.assertEqual(r.status_code,200,case_describe + ",接口：{0}".format(api))
def test_CustomerAll(self, data):
key = str(data["key"])
departmentId = str(data["departmentId"])
case_describe = str(data["case_describe"])
readconfig = ReadConfig.ReadConfig()
readdb = ReadDB.Pyodbc()
url = readconfig.get_basedata('crm_url') + api.format(
key, departmentId)
session = readconfig.get_basedata('member_session')
headers = {
'Content-Type': "application/json",
'Authorization': session
}
r = requests.get(url=url, headers=headers)
#处理请求数据到excl用例文件
excel.set_cell(sheet_name, int(data["case_id"]),
excel.get_sheet_colname(sheet_name)["result_code"],
r.status_code, excel.set_color(r.status_code))
excel.set_cell(sheet_name, int(data["case_id"]),
excel.get_sheet_colname(sheet_name)["result_msg"],
r.text, excel.set_color())
excel.save()
if r.status_code == 200:
customerindepartmentid = readdb.GetCustomerInDepartmentinfo(
key, departmentId)
responecustomerindepartmentid = []
for i in range(len(r.json()['list'])):
responecustomerindepartmentid.append(r.json()['list'][i]['id'])
self.assertIn(r.json()['list'][i]['id'].upper(),
customerindepartmentid,
case_describe + ",接口：{0}".format(api))
self.assertEqual(len(responecustomerindepartmentid),
len(customerindepartmentid),
case_describe + ",接口：{0}".format(api))
self.assertEqual(r.json()['count'], len(customerindepartmentid),
case_describe + ",接口：{0}".format(api))
else:
self.assertEqual(r.status_code, 200,
case_describe + ",接口：{0}".format(api))
def test_ClientMaintainNumber(self):
readconfig = ReadConfig.ReadConfig()
readdb = ReadDB.Pymssql()
url = readconfig.get_url('url') + api
session = readconfig.get_member('session')
origin = readconfig.get_url('origin')
headers = {
'Content-Type': "application/json",
'Authorization': session,
"Origin": origin
}
r = requests.get(url=url, headers=headers)
if r.status_code == 200 or r.status_code == 204:
maintainnumber = readdb.GetClientMaintainNumber(
readconfig.get_member('customerid'))
self.assertEqual(r.json()['maintainNumber'], maintainnumber,
case_describe)
else:
self.assertEqual(r.status_code, 200, case_describe)
def FormatSql(bDisplay = False,bUserInput = False):
"""bDisplay is used to control whether to show sql query or not.
bUserInput is used to let user to input sql query."""
if(bUserInput is not False):
sql = raw_input("Please input your sql query:")
return sql
else:
_field_list = ExtractField.ExtractField()
_config_dict = ReadConfig.ReadConfig()
sql = 'select '
i = 0
while i < len(_field_list) - 1:
sql = sql + _field_list[i]['FieldName'] + ','
i += 1
sql += _field_list[i]['FieldName']
sql += " from " + _config_dict['table']
if(bDisplay is not False):
print sql
return sql
else:
return sql
def test_ClientRemarks(self, data):
excel = ReadExcl.Xlrd()
readconfig=ReadConfig.ReadConfig()
readdb = ReadDB.Pymssql()
#填写求求参数
url = readconfig.get_url('url')+api.format(readconfig.get_client('clientid1'))
session = readconfig.get_member('session')
origin = readconfig.get_url('origin')
headers = {'Content-Type': "application/json",'Authorization':session,"Origin":origin}
payload = {"remarks": str(data["remarks"])}
r = requests.post(url=url, headers = headers,data = json.dumps(payload))
#处理请求数据到excl用例文件
excel.set_cell(sheet_name,int(data["case_id"]),excel.get_sheet_colname(sheet_name)["result_code"],r.status_code,excel.set_color(r.status_code))
excel.set_cell(sheet_name,int(data["case_id"]),excel.get_sheet_colname(sheet_name)["result_msg"],r.text,excel.set_color())
excel.save()
if r.status_code==200 or r.status_code==204:
clientinfo = readdb.GetClientinfo(readconfig.get_client('clientid1'))
self.assertEqual(clientinfo['remarks'],str(data['remarks']),data["case_describe"])
self.assertEqual(r.status_code,data['expected_code'],data["case_describe"])
def test_ContactUpdateBirthday(self, data):
birthday = data["birthday"]
case_describe = str(data["case_describe"])
expected_code = int(data["expected_code"])
readconfig = ReadConfig.ReadConfig()
readdb = ReadDB.Pyodbc()
contactid = readconfig.get_contact('contact1')
url = readconfig.get_basedata('crm_url') + api.format(contactid)
session = readconfig.get_basedata('member_session')
requestid = str(uuid.uuid1())
headers = {
'Content-Type': "application/json",
'Authorization': session,
"x-requestid": requestid
}
payload = {"birthday": birthday}
r = requests.post(url=url, data=json.dumps(payload), headers=headers)
#处理请求数据到excl用例文件
excel.set_cell(sheet_name, int(data["case_id"]),
excel.get_sheet_colname(sheet_name)["result_code"],
r.status_code, excel.set_color(r.status_code))
excel.set_cell(sheet_name, int(data["case_id"]),
excel.get_sheet_colname(sheet_name)["result_msg"],
r.text, excel.set_color())
excel.save()
#数据对比
if r.status_code == expected_code:
contactdetails = readdb.GetContactDetailsinfo(contactid)
self.assertEqual(contactdetails['birthday'].strftime('%Y-%m-%d'),
birthday, case_describe + ",接口：{0}".format(api))
else:
self.assertEqual(r.status_code, expected_code,
case_describe + ",接口：{0}".format(api))
def test_ClientAll(self):
readconfig = ReadConfig.ReadConfig()
readdb = ReadDB.Pymssql()
url = readconfig.get_url('url') + api
session = readconfig.get_member('session')
origin = readconfig.get_url('origin')
headers = {
'Content-Type': "application/json",
'Authorization': session,
"Origin": origin
}
r = requests.get(url=url, headers=headers)
if r.status_code == 200:
clientallid = readdb.GetClientAllinfo(
readconfig.get_member('customerid'))
responeclientallid = []
for i in range(len(r.json())):
responeclientallid.append(r.json()[i]['id'])
self.assertIn(r.json()[i]['id'], clientallid, case_describe)
self.assertEqual(len(responeclientallid), len(clientallid),
case_describe)
else:
self.assertEqual(r.status_code, 200, case_describe)
def setUpClass(self):
self.readdb = ReadDB.Pyodbc()
self.readconfig = ReadConfig.ReadConfig()
def __init__(self):
_dict = ReadConfig.ReadConfig()
self.host = _dict['host']
self.user = _dict['user']
self.passwd = _dict['passwd']
self.db = _dict['db']
