def test_playListrequestCount(self):
print("开始测试test_playListrequestCount")
# 执行接口查询
self.res_date = set_dp_interface(url=queryentry_url +
sspFinanceAnalysisPlayList,
data=FinanceAnalysisPlayList_data)
# print("接口返回结果:" + str(self.res_date))
inf_requestCount = self.res_date['data']
# 执行SQL查询
sql = "SELECT transaction_date,SUM(request_times) AS request_times FROM ssp_play_summary WHERE ssp_id = {0} AND transaction_date BETWEEN '{1}'AND '{2}' GROUP BY transaction_date;".format(
media_provider_id, startDate, endDate)
print("数据库查询使用语句：" + sql)
self.pymysqlcursor.execute(sql)
sql_request_times = self.pymysqlcursor.fetchall()
print("请求广告次数对比")
# for i in range(len(requestCount)):
# statisGroup = requestCount[i].get("statisGroup")
# inf_requestCount = requestCount[i].get("requestCount")
# sql_request_times = request_times[i].get("request_times")
# print('日期: {0}, 接口返回结果：{1} , 数据库查询结果：{2}' .format(statisGroup, inf_requestCount,sql_request_times))
# self.assertEqual(inf_requestCount,sql_request_times,"test_playListrequestCount,数据对不上" )
statisDates = 'statisGroup'
com_requestCount = 'requestCount'
com_request_times = 'request_times'
comparison_1(self, inf_requestCount, sql_request_times, statisDates,
com_requestCount, com_request_times)
def test_playListerrorScreenCount(self):
print("开始测试test_playListerrorScreenCount")
# 执行接口查询
self.res_date = set_dp_interface(url=queryentry_url +
sspFinanceAnalysisPlayList,
data=FinanceAnalysisPlayList_data)
# print("接口返回结果:" + str(self.res_date))
inf_errorScreenCount = self.res_date['data']
# 执行SQL查询
sql = "SELECT ssu.create_time, (SUM(DISTINCT ssu.screen_count) - SUM(DISTINCT spu.play_screens)) AS errorScreenCounts FROM screen_summary AS ssu LEFT JOIN ssp_play_summary AS spu ON ssu.create_time = spu.transaction_date WHERE ssu.media_provider_id = {0} AND (ssu.create_time BETWEEN '{1}' AND '{2}') GROUP BY create_time;".format(
media_provider_id, startDate, endDate)
print("数据库查询使用语句：" + sql)
self.pymysqlcursor.execute(sql)
sql_errorScreenCounts = self.pymysqlcursor.fetchall()
print("异常屏对比")
# for i in range(len(errorScreenCount)):
# statisGroup = errorScreenCount[i].get("statisGroup")
# inf_errorScreenCount = errorScreenCount[i].get("errorScreenCount")
# sql_errorScreenCount = sql_errorScreenCounts[i].get("errorScreenCounts")
# print('日期: {0}, 接口返回结果：{1} , 数据库查询结果：{2}' .format(statisGroup, inf_errorScreenCount,sql_errorScreenCount))
# self.assertEqual(inf_errorScreenCount,sql_errorScreenCount,"test_playListerrorScreenCount,数据对不上" )
statisDates = 'statisGroup'
com_errorScreenCount = 'errorScreenCount'
com_errorScreenCounts = 'errorScreenCounts'
comparison_1(self, inf_errorScreenCount, sql_errorScreenCounts,
statisDates, com_errorScreenCount, com_errorScreenCounts)
def test_analysisPlayLen(self):
print("开始测试test_analysisPlayLen")
# 执行接口查询
self.res_date = set_dp_interface(url=queryentry_url +
sspFinanceAnalysisPlayList,
data=FinanceAnalysisPlayList_data)
# print("接口返回结果:" + str(self.res_date))
dataLen = self.res_date['data']
# 执行SQL查询
sql = "SELECT * FROM ssp_play_summary WHERE ssp_id = {0} AND transaction_date BETWEEN '{1}' AND '{2}' GROUP BY transaction_date;".format(
media_provider_id, startDate, endDate)
print("数据库查询使用语句：" + sql)
self.pymysqlcursor.execute(sql)
sql_dataLen = self.pymysqlcursor.fetchall()
# 判断 接口数据与数据库查询结果
print('接口返回结果：{0} , 数据库查询结果：{1}'.format(len(dataLen),
len(sql_dataLen)))
self.assertEqual(len(dataLen), len(sql_dataLen), "test_dataLen,数据对不上")
def test_validScreenCount(self):
print("开始测试test_validscreencount")
self.res_date = set_dp_interface(url=queryentry_url +
sspFinanceAnalysisPlaySummary,
data=analysisPlaySummary_data)
# print("接口返回结果:" + str(self.res_date))
inf_validscreencount = self.res_date['data'].get("validScreenCount")
# 执行SQL查询
sql = "SELECT sum(DISTINCT play_screens) AS play_screens FROM ssp_play_summary WHERE ssp_id = '{0}' AND transaction_date BETWEEN '{1}' AND '{2}' GROUP BY transaction_date ORDER BY transaction_date DESC LIMIT {3};".format(
media_provider_id, startDate, endDate, limits)
print("数据库查询使用语句：" + sql)
self.pymysqlcursor.execute(sql)
play_screens = self.pymysqlcursor.fetchall()
slq_play_screens = play_screens[0].get("play_screens")
# 判断 接口数据与数据库查询结果
print('接口返回结果：{0} , 数据库查询结果：{1}'.format(str(inf_validscreencount),
str(slq_play_screens)))
self.assertEquals(str(inf_validscreencount), str(slq_play_screens),
"test_validScreenCount,数据对不上")
def test_planLen(self):
print("开始测试test_planLen")
# 执行接口查询
self.res_date = set_dp_interface(url=admanage_url +
admanageMaterialV2QueryPlan,
data=sspPlan_data)
# print("接口返回结果:" + str(self.res_date))
planLen = self.res_date['data']
# 执行SQL查询
sql = " SELECT * FROM material m LEFT JOIN material_review mr ON m.id = mr.id WHERE mr.media_provider_id = {0} GROUP BY order_id;".format(
media_provider_id)
print("数据库查询使用语句：" + sql)
self.pymysqlcursor.execute(sql)
sql_planLen = self.pymysqlcursor.fetchall()
# 判断 接口数据与数据库查询结果
print('接口返回结果：{0} , 数据库查询结果：{1}'.format(len(planLen),
len(sql_planLen)))
self.assertEqual(len(planLen), len(sql_planLen), "test_planLen,数据对不上")
def test_income(self):
print("开始测试test_income")
self.res_date = set_dp_interface(url=queryentry_url +
queryentrySspSummary,
data=sspSummary_data)
# print("接口返回结果:" + str(self.res_date))
inf_income = self.res_date['data'].get("income")
# 执行SQL查询
sql = "SELECT SUM(amount) as amount FROM ssp_play_summary WHERE ssp_id = {0} AND transaction_date BETWEEN '{1}' AND '{2}' GROUP BY transaction_date ORDER BY transaction_date DESC LIMIT {3};".format(
media_provider_id, startDate, endDate, limits)
print("数据库查询使用语句：" + sql)
self.pymysqlcursor.execute(sql)
amount = self.pymysqlcursor.fetchall()
sql_amount = amount[0].get("amount")
# 判断 接口数据与数据库查询结果
print('接口返回结果：{0} , 数据库查询结果：{1}'.format(str(inf_income),
str(sql_amount)))
self.assertEquals(str(inf_income), str(sql_amount), "test_income数据对不上")
def test_screenCount(self):
print("开始测试test_screenCount")
# 执行接口查询
self.res_date = set_dp_interface(url=queryentry_url +
queryentrySspSummary,
data=sspSummary_data)
# print("接口返回结果:" + str(self.res_date))
inf_screenCount = self.res_date['data'].get("screenCount")
# 执行SQL查询
sql = "SELECT SUM(screen_count) as screen_count FROM screen_summary WHERE media_provider_id = {0} AND create_time BETWEEN '{1}' AND '{2}' GROUP BY create_time ORDER BY create_time DESC LIMIT {3};".format(
media_provider_id, startDate, endDate, limits)
print("数据库查询使用语句：" + sql)
self.pymysqlcursor.execute(sql)
screen_count = self.pymysqlcursor.fetchall()
sql_screen_count = screen_count[0].get("screen_count")
# 判断 接口数据与数据库查询结果
print('接口返回结果：{0} , 数据库查询结果：{1}'.format(str(inf_screenCount),
str(sql_screen_count)))
self.assertEquals(str(inf_screenCount), str(sql_screen_count),
"test_screenCount数据对不上")
def test_allIncome(self):
print("开始测试test_allIncome")
self.res_date = set_dp_interface(url=queryentry_url +
queryentrySspSummary,
data=sspSummary_data)
# print("接口返回结果:" + str(self.res_date))
inf_allIncome = self.res_date['data'].get("allIncome")
# 执行SQL查询
sql = "SELECT SUM(amount) as allamount FROM ssp_play_summary WHERE ssp_id = {0} AND transaction_date BETWEEN '2019-01-01' and '{1}';".format(
media_provider_id, endDate)
print("数据库查询使用语句：" + sql)
self.pymysqlcursor.execute(sql)
allamount = self.pymysqlcursor.fetchall()
sql_allamount = allamount[0].get("allamount")
# 判断 接口数据与数据库查询结果
print('接口返回结果：{0} , 数据库查询结果：{1}'.format(str(inf_allIncome),
str(sql_allamount)))
self.assertEquals(str(inf_allIncome), str(sql_allamount),
"test_allIncome数据对不上")
def test_playListmaterialFailCount(self):
print("开始测试test_playListmaterialFailCount")
# 执行接口查询
self.res_date = set_dp_interface(url=queryentry_url +
sspFinanceAnalysisPlayList,
data=FinanceAnalysisPlayList_data)
# print("接口返回结果:" + str(self.res_date))
inf_materialFailCount = self.res_date['data']
# 执行SQL查询
sql = "SELECT transaction_date,SUM(play_fail_times) AS play_fail_times FROM ssp_play_summary WHERE ssp_id = {0} AND transaction_date BETWEEN '{1}'AND '{2}' GROUP BY transaction_date;".format(
media_provider_id, startDate, endDate)
print("数据库查询使用语句：" + sql)
self.pymysqlcursor.execute(sql)
sql_play_fail_times = self.pymysqlcursor.fetchall()
print("播放异常对比")
statisDates = 'statisGroup'
com_materialFailCount = 'materialFailCount'
com_play_fail_times = 'play_fail_times'
comparison_1(self, inf_materialFailCount, sql_play_fail_times,
statisDates, com_materialFailCount, com_play_fail_times)
