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)