flowpool_data_update_with_level_v2.py 10 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248
  1. import datetime
  2. import random
  3. import time
  4. import os
  5. import traceback
  6. import random
  7. import json
  8. from my_config import set_config
  9. from my_utils import request_post, filter_video_status, send_msg_to_feishu, filter_video_status_app, \
  10. filter_political_videos
  11. from log import Log
  12. from db_helper import RedisHelper
  13. from odps import ODPS
  14. config_, _ = set_config()
  15. log_ = Log()
  16. def get_videos_from_flow_pool(app_type, size=1000):
  17. """
  18. 从流量池获取视频,循环获取,直到返回数据为None结束
  19. :param app_type: 产品标识 type-int
  20. :param size: 每次获取视频数量,type-int,默认1000
  21. :return: videos [{'videoId': 1111, 'flowPool': ''}, ...]
  22. """
  23. # 获取批次标识,利用首次获取数据时间戳为标记
  24. batch_flag = int(time.time())
  25. request_data = {'appType': app_type, 'batchFlag': batch_flag, 'size': size}
  26. videos = []
  27. retry = 0
  28. while True:
  29. print(config_.GET_VIDEOS_FROM_POOL_URL)
  30. result = request_post(request_url=config_.GET_VIDEOS_FROM_POOL_URL, request_data=request_data)
  31. if result is None:
  32. if retry > 2:
  33. break
  34. retry += 1
  35. continue
  36. if result['code'] != 0:
  37. log_.info('batch_flag: {}, 获取流量池视频失败'.format(batch_flag))
  38. if retry > 2:
  39. break
  40. retry += 1
  41. continue
  42. if not result['data']:
  43. if retry > 2:
  44. break
  45. retry += 1
  46. continue
  47. videos.extend(result['data'])
  48. return videos
  49. def update_remain_view_count(video_info_list):
  50. """
  51. 获取视频在流量池中的剩余可分发数,并存入对应的redis中
  52. :param app_type: 产品标识 type-int
  53. :param video_info_list: 视频信息 (视频id, 流量池标记) type-list,[(video_id, flow_pool), ...]
  54. :return: data type-list,[(video_id, flow_pool, view_count), ...]
  55. """
  56. redis_helper = RedisHelper()
  57. if not video_info_list:
  58. return []
  59. remain_videos = []
  60. # 每次请求10个
  61. for i in range(len(video_info_list)//10 + 1):
  62. remain_st_time = time.time()
  63. videos = [{'videoId': info[0], 'flowPool': info[1]} for info in video_info_list[i*10:(i+1)*10]]
  64. request_data = {'videos': videos}
  65. result = request_post(request_url=config_.GET_REMAIN_VIEW_COUNT_URL,
  66. request_data=request_data, timeout=(0.5, 3))
  67. log_.info(f"i = {i}, expend time = {(time.time()-remain_st_time)*1000}")
  68. if result is None:
  69. continue
  70. if result['code'] != 0:
  71. log_.error('获取视频在流量池中的剩余可分发数失败')
  72. continue
  73. for item in result['data']:
  74. if item['distributeCount'] is None:
  75. continue
  76. distribute_count = int(item['distributeCount'])
  77. if distribute_count > 0:
  78. remain_videos.append(item['videoId'])
  79. # 将分发数更新到本地记录
  80. key_name = f"{config_.LOCAL_DISTRIBUTE_COUNT_PREFIX}{item['videoId']}:{item['flowPool']}"
  81. redis_helper.set_data_to_redis(key_name=key_name, value=distribute_count, expire_time=25 * 60)
  82. else:
  83. # 将本地记录删除
  84. key_name = f"{config_.LOCAL_DISTRIBUTE_COUNT_PREFIX}{item['videoId']}:{item['flowPool']}"
  85. redis_helper.del_keys(key_name=key_name)
  86. log_.info(f"新增加不分发过滤前后整体数量: {len(video_info_list)}:{len(remain_videos)}")
  87. return remain_videos
  88. def get_flow_pool_recommend_config(flow_pool_id):
  89. """获取流量池推荐分发配置"""
  90. result = request_post(request_url=config_.GET_FLOW_POOL_RECOMMEND_CONFIG_URL)
  91. if result is None:
  92. return None
  93. if result['code'] != 0:
  94. return None
  95. flow_pool_distribute_config = result['data'].get('flowPoolDistributeConfig')
  96. if flow_pool_distribute_config:
  97. if int(eval(flow_pool_distribute_config).get('flowPoolId')) == flow_pool_id:
  98. return eval(eval(flow_pool_distribute_config).get('distributeRate'))
  99. else:
  100. return None
  101. else:
  102. return None
  103. def update_flow_pool(flow_pool_id_list):
  104. """
  105. 获取流量池可分发视频,并将结果上传Redis
  106. :param app_type: 产品标识 type-int
  107. :return: None
  108. """
  109. # 所有产品都从0取数据
  110. app_type = 0
  111. try:
  112. # 从流量池获取数据
  113. videos = get_videos_from_flow_pool(app_type=app_type)
  114. if len(videos) <= 0:
  115. log_.info('流量池中无需分发的视频')
  116. return
  117. # video_id 与 flow_pool, level 进行mapping
  118. video_ids = set()
  119. log_.info('流量池中视频数:{}'.format(len(videos)))
  120. mapping = {}
  121. for video in videos:
  122. flow_pool_id = video['flowPoolId'] # 召回使用的切分ID是在这里做的。流量池中的视频是不区分ID的,也不区分层。
  123. if int(flow_pool_id) not in flow_pool_id_list:
  124. continue
  125. # print(f"flow_pool_id: {flow_pool_id}")
  126. video_id = video['videoId']
  127. video_ids.add(video_id)
  128. item_info = {'flowPool': video['flowPool'], 'level': video['level']}
  129. if video_id in mapping:
  130. mapping[video_id].append(item_info)
  131. else:
  132. mapping[video_id] = [item_info]
  133. log_.info(f"需更新流量池视频数: {len(video_ids)}")
  134. # 对视频状态进行过滤
  135. filtered_videos = filter_video_status(list(video_ids))
  136. log_.info('filter videos status finished, filtered_videos nums={}'.format(len(filtered_videos)))
  137. if not filtered_videos:
  138. log_.info('流量池中视频状态不符合分发')
  139. return
  140. # 1. 更新分发数量,过滤分发数量为0的视频
  141. video_info_list = []
  142. for video_id in filtered_videos:
  143. for item in mapping.get(video_id):
  144. flow_pool = item['flowPool']
  145. video_info = (video_id, flow_pool)
  146. if video_info not in video_info_list:
  147. video_info_list.append(video_info)
  148. log_.info(f"video_info_list count = {len(video_info_list)}")
  149. remain_videos = update_remain_view_count(video_info_list)
  150. if not remain_videos:
  151. log_.info('流量池中视频状态不符合分发')
  152. return
  153. # 上传数据到redis
  154. quick_flow_pool_redis_data = set()
  155. flow_pool_redis_data = set()
  156. for video_id in remain_videos:
  157. for item in mapping.get(video_id):
  158. flow_pool = item['flowPool']
  159. # 判断是否为快速曝光流量池视频
  160. value = '{}-{}'.format(video_id, flow_pool)
  161. flow_pool_id = int(flow_pool.split('#')[0]) # flowPool: 流量池ID#分级ID#级别Level#生命周期ID
  162. if flow_pool_id == config_.QUICK_FLOW_POOL_ID:
  163. quick_flow_pool_redis_data.add(value)
  164. else:
  165. flow_pool_redis_data.add(value)
  166. # 2. quick曝光池
  167. redis_helper = RedisHelper()
  168. quick_flow_pool_key_name = f"{config_.QUICK_FLOWPOOL_KEY_NAME_PREFIX_SET}{app_type}:{config_.QUICK_FLOW_POOL_ID}"
  169. # 如果key已存在,删除key
  170. if redis_helper.key_exists(quick_flow_pool_key_name):
  171. redis_helper.del_keys(quick_flow_pool_key_name)
  172. if quick_flow_pool_redis_data:
  173. log_.info(f"quick_flow_pool_redis_data = {quick_flow_pool_redis_data}")
  174. redis_helper.add_data_with_set(key_name=quick_flow_pool_key_name, values=quick_flow_pool_redis_data,
  175. expire_time=24 * 3600)
  176. # 快速流量池分发概率存入redis
  177. distribute_rate_key_name = f"{config_.QUICK_FLOWPOOL_DISTRIBUTE_RATE_KEY_NAME_PREFIX}{config_.QUICK_FLOW_POOL_ID}"
  178. distribute_rate = get_flow_pool_recommend_config(flow_pool_id=config_.QUICK_FLOW_POOL_ID)
  179. if distribute_rate is not None:
  180. redis_helper.set_data_to_redis(key_name=distribute_rate_key_name, value=distribute_rate,
  181. expire_time=15 * 60)
  182. # 3. 普通流量池
  183. log_.info(f"videos_count: {len(flow_pool_redis_data)}")
  184. flow_pool_key_name = f"{config_.FLOWPOOL_KEY_NAME_PREFIX_SET_LEVEL}{app_type}"
  185. # 如果key已存在,删除key
  186. if redis_helper.key_exists(flow_pool_key_name):
  187. redis_helper.del_keys(flow_pool_key_name)
  188. # 写入redis
  189. if flow_pool_redis_data:
  190. redis_helper.add_data_with_set(key_name=flow_pool_key_name, values=flow_pool_redis_data, expire_time=24 * 3600)
  191. result = redis_helper.get_data_from_set(flow_pool_key_name)
  192. if not result:
  193. result = []
  194. size = len(result)
  195. log_.info(f'写入成功key={flow_pool_key_name}:{size}')
  196. log_.info('data to redis finished!')
  197. except Exception as e:
  198. log_.error('流量池更新失败, appType: {} exception: {}, traceback: {}'.format(
  199. app_type, e, traceback.format_exc()))
  200. send_msg_to_feishu(
  201. webhook=config_.FEISHU_ROBOT['server_robot'].get('webhook'),
  202. key_word=config_.FEISHU_ROBOT['server_robot'].get('key_word'),
  203. msg_text='rov-offline{} - 流量池更新失败, appType: {}, exception: {}'.format(config_.ENV_TEXT, app_type, e)
  204. )
  205. if __name__ == '__main__':
  206. st_time = time.time()
  207. # 为避免第一个app_type获取数据不全,等待1min
  208. log_.info('flow pool predict start...')
  209. # 获取对应流量池id列表
  210. redis_helper = RedisHelper()
  211. flow_pool_abtest_config = redis_helper.get_data_from_redis(key_name=config_.FLOWPOOL_ABTEST_KEY_NAME)
  212. if flow_pool_abtest_config is not None:
  213. flow_pool_abtest_config = json.loads(flow_pool_abtest_config)
  214. else:
  215. flow_pool_abtest_config = {}
  216. flow_pool_id_list = flow_pool_abtest_config.get('experimental_flow_set_level', [])
  217. log_.info('predict start...')
  218. update_flow_pool(flow_pool_id_list=flow_pool_id_list)
  219. log_.info('predict end...')
  220. log_.info(f"expend time = {(time.time() - st_time) * 1000}ms")
  221. log_.info('flow pool predict end...')
  222. # python flowpool_data_update_with_level.py 测试环境必须手动执行python 才能有数据