def testCase02(self, id=24):
"""获取个人发布内容"""
data_test = operate_excel.data(case_name=MyTest.name)[id]
expect_one = operate_excel.change(asserexpect=data_test['expect1'])
sql = operate_excel.get_palce(case_num=id)['sql']
expect_two = operate_db.Operate_db(case_num=id, sql=sql, case_name=MyTest.name).Perform()
Log().info('获取用例数据:%s' % data_test)
apijson = TestApi(url2=data_test['url'], key=data_test['key'], param=data_test['param'],
way=data_test['way']).selectway()
Log().info('请求传入数据：url:%s,key:%s,参数:%s,请求方式：%s' % (data_test['url'], data_test['key'],
data_test['param'], data_test['way']))
apijson1 = json.loads(apijson)
actual_one = apijson1["data"][0]["noteBaseInfo"]["content"]
actual_two = apijson1["data"][0]["noteBaseInfo"]["noteId"]
global note_id
note_id = actual_two
try:
self.assertEqual(expect_one['content'], actual_one, msg='预期和返回不一致')
Log().info('对【发布内容】断言,断言结果--预期值%s == 实际值%s' % (expect_one['content'], actual_one))
except:
Log().warning('对【发布内容】断言,断言结果--预期值%s != 实际值%s' % (expect_one['content'], actual_one))
raise
finally:
try:
self.assertEqual(expect_two, actual_two, msg='预期和返回不一致')
Log().info('对【发布内容id】断言,断言结果--预期值%s == 实际值%s' % (expect_two, actual_two))
except:
Log().warning('对【发布内容id】断言,断言结果--预期值%s != 实际值%s' % (expect_two, actual_two))
raise
def testCase5(self, id=39):
"""删除地址"""
data_test = operate_excel.data(case_name=MyTest.name)[id]
expect_one = operate_excel.change(asserexpect=data_test['expect1'])
expect_two = operate_excel.change(asserexpect=data_test['expect2'])
Log().info('获取用例数据:%s' % data_test)
apijson = TestApi(url2=data_test['url'], key=data_test['key'], param=data_test['param'].replace("{0}", str(address_id2)),
way=data_test['way']).selectway()
Log().info('请求传入数据：url:%s,key:%s,参数:%s,请求方式：%s' % (data_test['url'], data_test['key'],
data_test['param'], data_test['way']))
apijson1 = json.loads(apijson)
actual_one = apijson1["isSuccess"]
sleep(1)
sql = operate_excel.get_palce(case_num=id)['sql'].format(address_id2)
actual_two = operate_db.Operate_db(case_num=id, sql=sql, case_name=MyTest.name).Perform()
try:
self.assertEqual(int(expect_one['isSuccess']), actual_one, msg='预期和返回不一致')
Log().info('对【isSuccess】断言,断言结果--预期值%s == 实际值%s' % (expect_one['isSuccess'], actual_one))
except:
Log().warning('对【isSuccess】断言,断言结果--预期值%s != 实际值%s' % (expect_one['isSuccess'], actual_one))
raise
finally:
try:
self.assertEqual(int(expect_two['COUNT(*)']), actual_two, msg='预期和返回不一致')
Log().info('对【删除结果数】断言,断言结果--预期值%s == 实际值%s' % (expect_two['COUNT(*)'], actual_two))
except:
Log().warning('对【删除结果数】断言,断言结果--预期值%s != 实际值%s' % (expect_two['COUNT(*)'], actual_two))
raise
def testCase12(self, id=34):
"""删除发布内容"""
data_test = operate_excel.data(case_name=MyTest.name)[id]
expect_one = operate_excel.change(asserexpect=data_test['expect1'])
expect_two = operate_excel.change(asserexpect=data_test['expect2'])
Log().info('获取用例数据:%s' % data_test)
apijson = TestApi(url2=data_test['url'].format(note_id), key=data_test['key'], param=data_test['param'].format(note_id),
way=data_test['way']).selectway()
Log().info('请求传入数据：url:%s,key:%s,参数:%s,请求方式：%s' % (data_test['url'], data_test['key'],
data_test['param'], data_test['way']))
apijson2 = json.loads(apijson)
actual_one = apijson2["msg"]
sql = operate_excel.get_palce(case_num=id, case_name=MyTest.name)['sql'].format(note_id)
actual_two = operate_db.Operate_db(case_num=id, sql=sql, case_name=MyTest.name).Perform()
try:
self.assertEqual(expect_one['msg'], actual_one, msg='预期和返回不一致')
Log().info('删除成功，对【删除结果】断言,断言结果--预期值%s == 实际值%s' % (expect_one['msg'], actual_one))
except:
Log().warning('删除失败，对【删除结果】断言,断言结果--预期值%s != 实际值%s' % (expect_one['msg'], actual_one))
raise
finally:
try:
self.assertEqual(int(expect_two['COUNT(*)']), actual_two, msg='预期和返回不一致')
Log().info('对【删除数】断言,断言结果--预期值%s == 实际值%s' % (expect_two['COUNT(*)'], actual_two))
except:
Log().warning('对【删除数】断言,断言结果--预期值%s != 实际值%s' % (expect_two['COUNT(*)'], actual_two))
raise
def testCase11(self, id=33):
"""发表评论"""
data_test = operate_excel.data(case_name=MyTest.name)[id]
expect_one = operate_excel.change(asserexpect=data_test['expect1'])
Log().info('获取用例数据:%s' % data_test)
apijson = TestApi(url2=data_test['url'], key=data_test['key'], param=data_test['param'].replace("{0}", str(note_id)),
way=data_test['way']).selectway()
Log().info('请求传入数据：url:%s,key:%s,参数:%s,请求方式：%s' % (data_test['url'], data_test['key'],
data_test['param'], data_test['way']))
apijson2 = json.loads(apijson)
sql = operate_excel.get_palce(case_num=id, case_name=MyTest.name)['sql']
actual_one = operate_db.Operate_db(case_num=id, sql=sql, case_name=MyTest.name).Perform()
actual_two = apijson2["data"]
try:
self.assertEqual(expect_one['comment_text'], actual_one, msg='预期和返回不一致')
Log().info('对【评论内容】断言,断言结果--预期值%s == 实际值%s' % (expect_one['comment_text'], actual_one))
except:
Log().warning('对【评论内容】断言,断言结果--预期值%s != 实际值%s' % (expect_one['comment_text'], actual_one))
raise
finally:
try:
self.assertIsNotNone(actual_two, msg='实际值不存在')
Log().info('已发送【%s】条评论' % (actual_two))
except:
Log().warning('评论发送失败')
raise
def testCase4(self, id=14):
"""绑定折扣码"""
data_test = operate_excel.data(case_name=MyTest.name)[id]
expect_one = operate_excel.change(asserexpect=data_test['expect1'])
Log().info('获取用例数据:%s' % data_test)
apijson = TestApi(url2=data_test['url'],
key=data_test['key'],
param=data_test['param'],
way=data_test['way']).selectway()
Log().info('请求传入数据：url:%s,key:%s,参数:%s,请求方式：%s' %
(data_test['url'], data_test['key'], data_test['param'],
data_test['way']))
apijson1 = apijson.replace('false', '"false"')
apijson2 = apijson1.replace('true', '"true"')
apijson3 = json.loads(apijson2)
actual_one = apijson3['data']['parentId']
actual_two = apijson3['data']['name']
sql = operate_excel.get_palce(case_num=11,
case_name=MyTest.name)['sql']
expect_two = operate_db.Operate_db(case_num=11,
sql=sql,
case_name=MyTest.name).Perform()
try:
self.assertEqual(int(expect_one['parentId']),
actual_one,
msg='预期和返回不一致')
Log().info('对【parentId】断言,断言结果--预期值%s == 实际值%s' %
(expect_one['parentId'], actual_one))
except:
Log().warning('对【parentId】断言,断言结果--预期值%s != 实际值%s' %
(expect_one['parentId'], actual_one))
raise
finally:
try:
self.assertEqual(expect_two, actual_two, msg='预期和返回不一致')
Log().info('对【邀请人】断言,断言结果--预期值%s == 实际值%s' %
(expect_two, actual_two))
except:
Log().warning('对【邀请人】断言,断言结果--预期值%s != 实际值%s' %
(expect_two, actual_two))
raise
sleep(1)
sql1 = operate_excel.get_palce(case_num=8,
case_name=MyTest.name)['sql']
operate_db.Operate_db(case_num=8, sql=sql1,
case_name=MyTest.name).Perform()
def testCase07(self, id=29):
"""查看获赞和收藏数"""
data_test = operate_excel.data(case_name=MyTest.name)[id]
sql = operate_excel.get_palce(case_num=id)['sql']
expects = operate_db.Operate_db(case_num=id, sql=sql, case_name=MyTest.name).more_perform()
expect_one = expects['sum(collect_num)']
expect_two = expects['sum(like_num)']
expect_three = expects['sum(share_num)']
Log().info('获取用例数据:%s' % data_test)
apijson = TestApi(url2=data_test['url'], key=data_test['key'], param=data_test['param'],
way=data_test['way']).selectway()
Log().info('请求传入数据：url:%s,key:%s,参数:%s,请求方式：%s' % (data_test['url'], data_test['key'],
data_test['param'], data_test['way']))
apijson2 = json.loads(apijson)
actual_one = apijson2["data"]["collectedNum"]
actual_two = apijson2["data"]["likedNum"]
actual_three = apijson2["data"]["sharedNum"]
try:
self.assertEqual(int(expect_one), actual_one, msg='预期和返回不一致')
Log().info('对【收藏数】断言,断言结果--预期值%s == 实际值%s' % (expect_one, actual_one))
except :
Log().warning('对【收藏数】断言,断言结果--预期值%s != 实际值%s' % (expect_one, actual_one))
raise
else:
Log().info('第1条断言成功')
finally:
try:
self.assertEqual(int(expect_two), actual_two, msg='预期和返回不一致')
Log().info('对【点赞数】断言,断言结果--预期值%s == 实际值%s' % (expect_two, actual_two))
except:
Log().warning('对【点赞数】断言,断言结果--预期值%s != 实际值%s' % (expect_two, actual_two))
raise
finally:
try:
self.assertEqual(int(expect_three), actual_three, msg='预期和返回不一致')
Log().info('对【被分享数】断言,断言结果--预期值%s == 实际值%s' % (expect_three, actual_three))
except :
Log().warning('对【被分享数】断言,断言结果--预期值%s != 实际值%s' % (expect_three, actual_three))
raise
def testCase2(self, id=12):
"""短验注册登录成功"""
data_test = operate_excel.data(case_name=MyTest.name)[id]
expect_one = operate_excel.change(asserexpect=data_test['expect1'])
Log().info('获取用例数据:%s' % data_test)
apijson = TestApi(url2=data_test['url'],
key=data_test['key'],
param=data_test['param'],
way=data_test['way']).selectway()
Log().info('请求传入数据：url:%s,key:%s,参数:%s,请求方式：%s' %
(data_test['url'], data_test['key'], data_test['param'],
data_test['way']))
apijson1 = apijson.replace('false', '"false"')
apijson2 = json.loads(apijson1)
actual_one = apijson2['data']['mobileLoginUser'][0]["tel"]
actual_two = apijson2['data']['mobileLoginUser'][0]["userId"]
sql = operate_excel.get_palce(case_num=id,
case_name=MyTest.name)['sql']
expect_two = operate_db.Operate_db(case_num=9,
sql=sql,
case_name=MyTest.name).Perform()
try:
self.assertEqual(expect_one['tel'], actual_one, msg='预期和返回不一致')
Log().info('对【手机号】断言,断言结果--预期值%s == 实际值%s' %
(expect_one['tel'], actual_one))
except:
Log().warning('对【手机号】断言,断言结果--预期值%s != 实际值%s' %
(expect_one['tel'], actual_one))
raise
finally:
try:
self.assertEqual(int(expect_two), actual_two, msg='预期和返回不一致')
Log().info('对【userId】断言,断言结果--预期值%s == 实际值%s' %
(expect_two, actual_two))
except:
Log().warning('对【userId】断言,断言结果--预期值%s != 实际值%s' %
(expect_two, actual_two))
raise
