config.py 21 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521
  1. # coding:utf-8
  2. import os
  3. # from log import Log
  4. # log_ = Log()
  5. class BaseConfig(object):
  6. # 产品标识
  7. APP_TYPE = {
  8. 'VLOG': 0, # vlog
  9. 'LOVE_LIVE': 4, # 票圈视频
  10. 'LONG_VIDEO': 5, # 内容精选
  11. 'SHORT_VIDEO': 6, # 票圈短视频
  12. 'WAN_NENG_VIDEO': 17, # 万能影视屋
  13. 'LAO_HAO_KAN_VIDEO': 18, # 老好看视频
  14. 'ZUI_JING_QI': 19, # 票圈最惊奇
  15. 'APP': 13, # 票圈视频APP
  16. }
  17. # 数据存放路径
  18. DATA_DIR_PATH = './data'
  19. # oss 目标Bucket
  20. BUCKET_NAME = 'ali-recommend'
  21. # ODPS服务配置
  22. ODPS_CONFIG = {
  23. 'ENDPOINT': 'http://service.cn.maxcompute.aliyun.com/api',
  24. 'ACCESSID': 'LTAIWYUujJAm7CbH',
  25. 'ACCESSKEY': 'RfSjdiWwED1sGFlsjXv0DlfTnZTG1P',
  26. }
  27. # 飞书机器人配置
  28. FEISHU_ROBOT = {
  29. 'server_robot': {
  30. # webhook地址
  31. 'webhook': 'https://open.feishu.cn/open-apis/bot/v2/hook/8de4de35-30ed-4692-8854-7a154e89b2f2',
  32. # 自定义关键词key_word
  33. 'key_word': '服务报警'
  34. },
  35. 'feature_monitor_robot': {
  36. 'webhook': 'https://open.feishu.cn/open-apis/bot/v2/hook/0ca66b89-5e2b-4e89-a04a-a01fda31cc89',
  37. 'key_word': 'ROV特征监控'
  38. }
  39. }
  40. # 训练数据截止时间距当前日期间隔天数
  41. TRAIN_DIFF = 7
  42. # 训练数据所需数据范围天数
  43. TRAIN_DELTA_DAYS = 30
  44. # 训练数据表名
  45. TRAIN_PROJECT = 'usercdm'
  46. TRAIN_TABLE = 'rov_feature_add_v1'
  47. # 训练数据文件存放路径
  48. TRAIN_DATA_FILENAME = 'train_data.pickle'
  49. # 预测数据截止时间距当前日期间隔天数
  50. PREDICT_DIFF = 1
  51. # 预测数据所需数据范围天数
  52. PREDICT_DELTA_DAYS = 1
  53. # 预测数据表名
  54. PREDICT_PROJECT = 'usercdm'
  55. PREDICT_TABLE = 'rov_predict_table_add_v1'
  56. # 预测数据文件存放路径
  57. PREDICT_DATA_FILENAME = 'predict_data.pickle'
  58. # 模型存放文件
  59. MODEL_FILENAME = 'model.pickle'
  60. # 运营给定App小时级更新数据表名
  61. APP_OP_PROJECT = 'loghubods'
  62. APP_OP_TABLE = 'category_video_list_test1'
  63. # 小程序小时级规则参数
  64. RULE_PARAMS = {
  65. 'rule1': {'return_count': 20, 'score_rule': 0.005},
  66. # 'rule2': {'return_count': 20, 'score_rule': 0.001}, # 下线
  67. 'rule3': {'view_type': 'pre-view', 'return_count': 20, 'score_rule': 0.005},
  68. # 'rule4': {'cal_score_func': 2, 'return_count': 20, 'score_rule': 0}, # 下线
  69. # 'rule5': {'cal_score_func': 3, 'return_count': 20, 'score_rule': 0}, # 下线
  70. 'rule6': {'view_type': 'video-show', 'return_count': 20, 'score_rule': 0.005},
  71. }
  72. # app_type: [18, 19]预测表名
  73. PREDICT_PROJECT_18_19 = {
  74. '18': 'loghubods', # 老好看
  75. '19': 'loghubods', # 最惊奇
  76. }
  77. PREDICT_TABLE_18_19 = {
  78. '18': 'haokan_video_list_each_hour_update', # 老好看
  79. '19': 'amazed_video_list_each_hour_update', # 最惊奇
  80. }
  81. # 预测数据文件存放路径
  82. PREDICT_DATA_FILENAME_18_19 = {
  83. '18': 'predict_data_18.pickle',
  84. '19': 'predict_data_19.pickle'
  85. }
  86. # 天级规则更新使用数据
  87. PROJECT_DAY = 'loghubods'
  88. TABLE_DAY = 'video_data_each_day_dataset'
  89. # 小程序天级规则参数
  90. RULE_PARAMS_DAY = {
  91. # 'rule1': {'return_count': 200},
  92. 'rule2': {'cal_score_func': 2, 'return_count': 100},
  93. }
  94. # 地域分组小时级规则更新使用数据
  95. PROJECT_REGION = 'loghubods'
  96. TABLE_REGION = 'video_each_hour_update_province'
  97. # 地域分组小时级规则参数
  98. RULE_PARAMS_REGION = {
  99. # 'rule1': {'view_type': 'pre-view', 'return_count': 20, 'score_rule': 0.005},
  100. 'rule1': {'view_type': 'pre-view'},
  101. }
  102. # 地域分组天级规则更新使用数据
  103. PROJECT_REGION_DAY = 'loghubods'
  104. TABLE_REGION_DAY = 'video_each_day_update_province'
  105. # 地域分组天级规则参数
  106. RULE_PARAMS_REGION_DAY = {
  107. 'rule1': {'view_type': 'pre-view', 'return_count': 1, 'score_rule': 0},
  108. }
  109. # 老视频更新使用数据
  110. OLD_VIDEOS_PROJECT = 'loghubods'
  111. OLD_VIDEOS_TABLE = 'xcx_test_video'
  112. # 小程序离线ROV模型结果存放 redis key前缀,完整格式:com.weiqu.video.recall.hot.item.score.{date}
  113. RECALL_KEY_NAME_PREFIX = 'com.weiqu.video.recall.hot.item.score.'
  114. # 小程序小时级更新结果存放 redis key前缀,完整格式:com.weiqu.video.recall.item.score.h.{rule_key}.{date}.{h}
  115. RECALL_KEY_NAME_PREFIX_BY_H = 'com.weiqu.video.recall.item.score.h.'
  116. # 小程序离线ROV模型结果与小程序小时级更新结果去重后 存放 redis key前缀,
  117. # 完整格式:com.weiqu.video.recall.hot.item.score.dup.h.{rule_key}.{date}.{h}
  118. RECALL_KEY_NAME_PREFIX_DUP_H = 'com.weiqu.video.recall.hot.item.score.dup.h.'
  119. # 小时级视频状态不符合推荐要求的列表 redis key,完整格式:com.weiqu.video.filter.h.item.{rule_key}
  120. H_VIDEO_FILER = 'com.weiqu.video.filter.h.item.'
  121. # 小程序天级更新结果存放 redis key前缀,完整格式:com.weiqu.video.recall.item.score.day.{rule_key}.{date}
  122. RECALL_KEY_NAME_PREFIX_BY_DAY = 'com.weiqu.video.recall.item.score.day.'
  123. # 小程序离线ROV模型结果与小程序天级更新结果去重后 存放 redis key前缀,
  124. # 完整格式:com.weiqu.video.recall.hot.item.score.dup.day.now.{rule_key}.{date}
  125. RECALL_KEY_NAME_PREFIX_DUP_DAY_NOW = 'com.weiqu.video.recall.hot.item.score.dup.day.now.'
  126. # 使用前一天小程序离线ROV模型结果与小程序天级更新结果去重后 存放 redis key前缀,
  127. # 完整格式:com.weiqu.video.recall.hot.item.score.dup.day.pre.{rule_key}.{date}
  128. RECALL_KEY_NAME_PREFIX_DUP_DAY_PRE = 'com.weiqu.video.recall.hot.item.score.dup.day.pre.'
  129. # 小程序地域分组小时级更新结果存放 redis key前缀,完整格式:com.weiqu.video.recall.item.score.region.h.{region}.{rule_key}.{date}.{h}
  130. RECALL_KEY_NAME_PREFIX_REGION_BY_H = 'com.weiqu.video.recall.item.score.region.h.'
  131. # 小程序地域分组天级更新结果与小程序地域分组小时级更新结果去重后 存放 redis key前缀,
  132. # 完整格式:com.weiqu.video.recall.hot.item.score.dup1.region.day.h.{region}.{rule_key}.{date}.{h}
  133. RECALL_KEY_NAME_PREFIX_DUP1_REGION_DAY_H = 'com.weiqu.video.recall.hot.item.score.dup1.region.day.h.'
  134. # 小程序天级更新结果与 小程序地域分组天级更新结果/小程序地域分组小时级更新结果 去重后 存放 redis key前缀,
  135. # 完整格式:com.weiqu.video.recall.hot.item.score.dup2.region.day.h.{region}.{rule_key}.{date}.{h}
  136. RECALL_KEY_NAME_PREFIX_DUP2_REGION_DAY_H = 'com.weiqu.video.recall.hot.item.score.dup2.region.day.h.'
  137. # 小程序离线ROV模型结果与 小程序天级更新结果/小程序地域分组天级更新结果/小程序地域分组小时级更新结果 去重后 存放 redis key前缀,
  138. # 完整格式:com.weiqu.video.recall.hot.item.score.dup.region.h.{region}.{rule_key}.{date}.{h}
  139. RECALL_KEY_NAME_PREFIX_DUP_REGION_H = 'com.weiqu.video.recall.hot.item.score.dup.region.h.'
  140. # 地域分组小时级视频状态不符合推荐要求的列表 redis key,完整格式:com.weiqu.video.filter.region.h.item.{region}.{rule_key}
  141. REGION_H_VIDEO_FILER = 'com.weiqu.video.filter.region.h.item.'
  142. # 小程序地域分组天级更新结果存放 redis key前缀,完整格式:com.weiqu.video.recall.item.score.region.day.{region}.{rule_key}.{date}
  143. RECALL_KEY_NAME_PREFIX_REGION_BY_DAY = 'com.weiqu.video.recall.item.score.region.day.'
  144. # 小程序老视频更新结果存放 redis key 前缀,完整格式:'com.weiqu.video.recall.old.item.{date}'
  145. RECALL_KEY_NAME_PREFIX_OLD_VIDEOS = 'com.weiqu.video.recall.old.item.'
  146. # app应用 小程序离线ROV模型结果存放 redis key前缀,完整格式:com.weiqu.video.recall.hot.item.score.app.{date}
  147. RECALL_KEY_NAME_PREFIX_APP = 'com.weiqu.video.recall.hot.item.score.app.'
  148. # app应用 运营提供的小时级数据存放 redis key前缀,完整格式:com.weiqu.video.app.op.item.score.{date}.{h}
  149. APP_OP_VIDEOS_KEY_NAME_PREFIX = 'com.weiqu.video.app.op.item.score.'
  150. # app应用 小时级数据更新最终结果存放 redis key前缀,完整格式:com.weiqu.video.recall.hot.item.score.app.{date}.{h}
  151. APP_FINAL_RECALL_KEY_NAME_PREFIX = 'com.weiqu.video.recall.hot.item.score.app.'
  152. # appType:[18, 19]小程序离线ROV模型结果存放 redis key前缀,完整格式:com.weiqu.video.recall.hot.item.score.{appType}.{date}.{h}
  153. RECALL_KEY_NAME_PREFIX_APP_TYPE = 'com.weiqu.video.recall.hot.item.score.'
  154. # appType = 6, ROV召回池redis key前缀,完整格式:com.weiqu.video.recall.hot.apptype.h.item.score.{appType}.{h}
  155. # RECALL_KEY_NAME_PREFIX_APP_TYPE = 'com.weiqu.video.recall.hot.apptype.h.item.score.'
  156. # 流量池离线模型结果存放 redis key前缀,完整格式 com.weiqu.video.flowpool.hot.item.score.{appType}
  157. FLOWPOOL_KEY_NAME_PREFIX = 'com.weiqu.video.flowpool.hot.item.score.'
  158. # 兜底视频redis存储key
  159. BOTTOM_KEY_NAME = 'com.weiqu.video.bottom'
  160. # 兜底视频数量
  161. BOTTOM_NUM = 1000
  162. # 首页兜底视频json存储 redis-key
  163. BOTTOM_JSON_KEY_NAME = 'com.weiqu.video.homepage.bottom.info.json.item'
  164. # 修改ROV的视频 redis key
  165. UPDATE_ROV_KEY_NAME = 'com.weiqu.video.update.rov.item.score'
  166. UPDATE_ROV_KEY_NAME_APP = 'com.weiqu.video.update.rov.item.score.app'
  167. # 生效中的置顶视频列表 redis key
  168. TOP_VIDEO_LIST_KEY_NAME = 'com.weiqu.video.top.item.score.area'
  169. TOP_VIDEO_LIST_KEY_NAME_APP = 'com.weiqu.video.top.item.score.area.app'
  170. # rovScore公差
  171. ROV_SCORE_D = 0.001
  172. # width : height > 1 的视频列表 redis key, zset存储,value为videoId,score为w_h_rate
  173. W_H_RATE_UP_1_VIDEO_LIST_KEY_NAME = {
  174. 'rov_recall': 'com.weiqu.video.rov.w.h.rate.1.item', # rov召回池视频
  175. 'bottom_last': 'com.weiqu.video.bottom.last.w.h.rate.1.item' # 二次兜底视频
  176. }
  177. # 头部视频对应运营强插的相关视频 redis 存储 key 前缀, 完整key格式:com.weiqu.video.relevant.videos.item.{videoId}
  178. RELEVANT_VIDEOS_WITH_OP_KEY_NAME = 'com.weiqu.video.relevant.videos.item.'
  179. # 有设置运营强插相关视频的头部视频id redis存储key
  180. RELEVANT_TOP_VIDEOS_KEY_NAME = 'com.weiqu.video.relevant.top.video_ids'
  181. # 按位置排序redis存储key
  182. RECALL_POSITION1_KEY_NAME = 'com.weiqu.video.recall.hot.apptype.h.item.score.position.1'
  183. RECALL_POSITION2_KEY_NAME = 'com.weiqu.video.recall.hot.apptype.h.item.score.position.2'
  184. class DevelopmentConfig(BaseConfig):
  185. """开发环境配置"""
  186. # 报警内容 环境区分
  187. ENV_TEXT = "开发环境"
  188. # 项目存放目录
  189. PROJECT_PATH = '/data2/rov-offline'
  190. # 测试环境redis地址
  191. REDIS_INFO = {
  192. 'host': 'r-bp1ps6my7lzg8rdhwx682.redis.rds.aliyuncs.com',
  193. 'port': 6379,
  194. 'password': 'Wqsd@2019',
  195. }
  196. # Hologres连接参数,本地使用
  197. HOLOGRES_INFO = {
  198. 'host': 'hgprecn-cn-7pp28y18c00c-cn-hangzhou.hologres.aliyuncs.com',
  199. 'port': 80,
  200. 'dbname': 'dssm',
  201. 'user': 'LTAI5tMPqPy9yboQAf1mBCCN',
  202. 'password': '4BEcOgxREOPq7t3A7EWkjciVULeQGj'
  203. }
  204. # 测试环境mysql地址
  205. MYSQL_INFO = {
  206. 'host': 'rm-bp1k5853td1r25g3n690.mysql.rds.aliyuncs.com',
  207. 'port': 3306,
  208. 'user': 'wx2016_longvideo',
  209. 'password': 'wx2016_longvideoP@assword1234',
  210. 'db': 'longvideo',
  211. 'charset': 'utf8'
  212. }
  213. # 测试环境 过滤用mysql地址
  214. FILTER_MYSQL_INFO = {
  215. 'host': 'am-bp1g3ys9u00u483uc131930.ads.aliyuncs.com',
  216. 'port': 3306,
  217. 'user': 'lv_manager',
  218. 'password': 'lv_manager@2020',
  219. 'db': 'longvideo',
  220. 'charset': 'utf8'
  221. }
  222. # 日志服务配置
  223. ALIYUN_LOG = {
  224. 'ENDPOINT': 'cn-hangzhou.log.aliyuncs.com',
  225. 'ACCESSID': 'LTAIWYUujJAm7CbH',
  226. 'ACCESSKEY': 'RfSjdiWwED1sGFlsjXv0DlfTnZTG1P',
  227. 'PROJECT': 'rov-server-test',
  228. }
  229. # Hologres视频状态存储表名
  230. VIDEO_STATUS = 'longvideo_test.dwd_mdm_item_video_stat'
  231. # 从流量池获取视频接口地址
  232. GET_VIDEOS_FROM_POOL_URL = 'http://testapi-internal.piaoquantv.com/flowpool/video/getAllVideo'
  233. # 获取视频在流量池中的剩余可分发数接口地址
  234. GET_REMAIN_VIEW_COUNT_URL = 'http://testapi-internal.piaoquantv.com/flowpool/video/remainViewCount'
  235. # 计算完ROV通知后端接口地址
  236. NOTIFY_BACKEND_UPDATE_ROV_SCORE_URL = 'http://videotest-internal.yishihui.com/longvideoapi/openapi/recommend/updateRovScore'
  237. # 获取置顶视频列表接口地址
  238. TOP_VIDEO_LIST_URL = 'http://videotest-internal.yishihui.com/longvideoapi/openapi/recommend/topVideoList'
  239. # 获取首页兜底视频json接口地址
  240. BOTTOM_JSON_URL = 'http://videotest-internal.yishihui.com/longvideoapi/openapi/video/distribute/structure/video/list'
  241. # logs 上传oss 目标Bucket指定目录
  242. OSS_FOLDER_LOGS = 'rov-offline/dev/logs/'
  243. # data 上传oss 目标Bucket指定目录
  244. OSS_FOLDER_DATA = 'rov-offline/dev/data/'
  245. class TestConfig(BaseConfig):
  246. """测试环境配置"""
  247. # 报警内容 环境区分
  248. ENV_TEXT = "测试环境"
  249. # 项目存放目录
  250. PROJECT_PATH = '/data2/rov-offline'
  251. # 测试环境redis地址
  252. REDIS_INFO = {
  253. 'host': 'r-bp1ps6my7lzg8rdhwx682.redis.rds.aliyuncs.com',
  254. 'port': 6379,
  255. 'password': 'Wqsd@2019',
  256. }
  257. # Hologres连接参数,服务器使用
  258. HOLOGRES_INFO = {
  259. 'host': 'hgprecn-cn-7pp28y18c00c-cn-hangzhou-vpc.hologres.aliyuncs.com',
  260. 'port': 80,
  261. 'dbname': 'dssm',
  262. 'user': 'LTAI5tMPqPy9yboQAf1mBCCN',
  263. 'password': '4BEcOgxREOPq7t3A7EWkjciVULeQGj'
  264. }
  265. # 测试环境mysql地址
  266. MYSQL_INFO = {
  267. 'host': 'rm-bp1k5853td1r25g3n690.mysql.rds.aliyuncs.com',
  268. 'port': 3306,
  269. 'user': 'wx2016_longvideo',
  270. 'password': 'wx2016_longvideoP@assword1234',
  271. 'db': 'longvideo',
  272. 'charset': 'utf8'
  273. }
  274. # 测试环境 过滤用mysql地址
  275. FILTER_MYSQL_INFO = {
  276. 'host': 'am-bp1g3ys9u00u483uc131930.ads.aliyuncs.com',
  277. 'port': 3306,
  278. 'user': 'lv_manager',
  279. 'password': 'lv_manager@2020',
  280. 'db': 'longvideo',
  281. 'charset': 'utf8'
  282. }
  283. # 日志服务配置
  284. ALIYUN_LOG = {
  285. 'ENDPOINT': 'cn-hangzhou.log.aliyuncs.com',
  286. 'ACCESSID': 'LTAIWYUujJAm7CbH',
  287. 'ACCESSKEY': 'RfSjdiWwED1sGFlsjXv0DlfTnZTG1P',
  288. 'PROJECT': 'rov-server-test',
  289. }
  290. # Hologres视频状态存储表名
  291. VIDEO_STATUS = 'longvideo_test.dwd_mdm_item_video_stat'
  292. # 从流量池获取视频接口地址
  293. GET_VIDEOS_FROM_POOL_URL = 'http://testapi-internal.piaoquantv.com/flowpool/video/getAllVideo'
  294. # 获取视频在流量池中的剩余可分发数接口地址
  295. GET_REMAIN_VIEW_COUNT_URL = 'http://testapi-internal.piaoquantv.com/flowpool/video/remainViewCount'
  296. # 计算完ROV通知后端接口地址
  297. NOTIFY_BACKEND_UPDATE_ROV_SCORE_URL = 'http://videotest-internal.yishihui.com/longvideoapi/openapi/recommend/updateRovScore'
  298. # 获取置顶视频列表接口地址
  299. TOP_VIDEO_LIST_URL = 'http://videotest-internal.yishihui.com/longvideoapi/openapi/recommend/topVideoList'
  300. # 获取首页兜底视频json接口地址
  301. BOTTOM_JSON_URL = 'http://videotest-internal.yishihui.com/longvideoapi/openapi/video/distribute/structure/video/list'
  302. # logs 上传oss 目标Bucket指定目录
  303. OSS_FOLDER_LOGS = 'rov-offline/test/logs/'
  304. # data 上传oss 目标Bucket指定目录
  305. OSS_FOLDER_DATA = 'rov-offline/test/data/'
  306. class PreProductionConfig(BaseConfig):
  307. """预发布环境配置"""
  308. # 报警内容 环境区分
  309. ENV_TEXT = "预发布环境"
  310. # 项目存放目录
  311. PROJECT_PATH = '/data/rov-offline'
  312. # redis地址
  313. REDIS_INFO = {
  314. 'host': 'r-bp1fogs2mflr1ybfot.redis.rds.aliyuncs.com',
  315. 'port': 6379,
  316. 'password': 'Wqsd@2019',
  317. }
  318. # Hologres连接参数,服务器使用
  319. HOLOGRES_INFO = {
  320. 'host': 'hgprecn-cn-7pp28y18c00c-cn-hangzhou-vpc.hologres.aliyuncs.com',
  321. 'port': 80,
  322. 'dbname': 'dssm',
  323. 'user': 'LTAI5tMPqPy9yboQAf1mBCCN',
  324. 'password': '4BEcOgxREOPq7t3A7EWkjciVULeQGj'
  325. }
  326. # 生产环境mysql地址
  327. MYSQL_INFO = {
  328. 'host': 'rr-bp1x9785e8h5452bi157.mysql.rds.aliyuncs.com',
  329. 'port': 3306,
  330. 'user': 'wx2016_longvideo',
  331. 'password': 'wx2016_longvideoP@assword1234',
  332. 'db': 'longvideo',
  333. 'charset': 'utf8'
  334. }
  335. # 生产环境 过滤用mysql地址
  336. FILTER_MYSQL_INFO = {
  337. 'host': 'am-bp15tqt957i3b3sgi131950.ads.aliyuncs.com',
  338. 'port': 3306,
  339. 'user': 'lv_manager',
  340. 'password': 'lv_manager@2020',
  341. 'db': 'longvideo',
  342. 'charset': 'utf8'
  343. }
  344. # 日志服务配置
  345. ALIYUN_LOG = {
  346. 'ENDPOINT': 'cn-hangzhou.log.aliyuncs.com',
  347. 'ACCESSID': 'LTAIWYUujJAm7CbH',
  348. 'ACCESSKEY': 'RfSjdiWwED1sGFlsjXv0DlfTnZTG1P',
  349. 'PROJECT': 'rov-server',
  350. }
  351. # Hologres视频状态存储表名
  352. VIDEO_STATUS = 'longvideo.dwd_mdm_item_video_stat'
  353. # 从流量池获取视频接口地址
  354. GET_VIDEOS_FROM_POOL_URL = 'http://preapi-internal.piaoquantv.com/flowpool/video/getAllVideo'
  355. # 获取视频在流量池中的剩余可分发数接口地址
  356. GET_REMAIN_VIEW_COUNT_URL = 'http://preapi-internal.piaoquantv.com/flowpool/video/remainViewCount'
  357. # 计算完ROV通知后端接口地址
  358. NOTIFY_BACKEND_UPDATE_ROV_SCORE_URL = 'http://videopre-internal.piaoquantv.com/longvideoapi/openapi/recommend/updateRovScore'
  359. # 获取置顶视频列表接口地址
  360. TOP_VIDEO_LIST_URL = 'http://speedpre.wx.com/longvideoapi/openapi/recommend/topVideoList'
  361. # 获取首页兜底视频json接口地址
  362. BOTTOM_JSON_URL = 'http://speedpre.wx.com/longvideoapi/openapi/video/distribute/structure/video/list'
  363. # logs 上传oss 目标Bucket指定目录
  364. OSS_FOLDER_LOGS = 'rov-offline/pre/logs/'
  365. # data 上传oss 目标Bucket指定目录
  366. OSS_FOLDER_DATA = 'rov-offline/pre/data/'
  367. class ProductionConfig(BaseConfig):
  368. """生产环境配置"""
  369. # 报警内容 环境区分
  370. ENV_TEXT = "生产环境"
  371. # 项目存放目录
  372. PROJECT_PATH = '/data/rov-offline'
  373. # 线上环境redis地址
  374. REDIS_INFO = {
  375. 'host': 'r-bp1fogs2mflr1ybfot.redis.rds.aliyuncs.com',
  376. 'port': 6379,
  377. 'password': 'Wqsd@2019',
  378. }
  379. # Hologres连接参数,服务器使用
  380. HOLOGRES_INFO = {
  381. 'host': 'hgprecn-cn-7pp28y18c00c-cn-hangzhou-vpc.hologres.aliyuncs.com',
  382. 'port': 80,
  383. 'dbname': 'dssm',
  384. 'user': 'LTAI5tMPqPy9yboQAf1mBCCN',
  385. 'password': '4BEcOgxREOPq7t3A7EWkjciVULeQGj'
  386. }
  387. # 生产环境mysql地址
  388. MYSQL_INFO = {
  389. 'host': 'rr-bp1x9785e8h5452bi157.mysql.rds.aliyuncs.com',
  390. 'port': 3306,
  391. 'user': 'wx2016_longvideo',
  392. 'password': 'wx2016_longvideoP@assword1234',
  393. 'db': 'longvideo',
  394. 'charset': 'utf8'
  395. }
  396. # 生产环境 过滤用mysql地址
  397. FILTER_MYSQL_INFO = {
  398. 'host': 'am-bp15tqt957i3b3sgi131950.ads.aliyuncs.com',
  399. 'port': 3306,
  400. 'user': 'lv_manager',
  401. 'password': 'lv_manager@2020',
  402. 'db': 'longvideo',
  403. 'charset': 'utf8'
  404. }
  405. # 日志服务配置
  406. ALIYUN_LOG = {
  407. 'ENDPOINT': 'cn-hangzhou.log.aliyuncs.com',
  408. 'ACCESSID': 'LTAIWYUujJAm7CbH',
  409. 'ACCESSKEY': 'RfSjdiWwED1sGFlsjXv0DlfTnZTG1P',
  410. 'PROJECT': 'rov-server',
  411. }
  412. # Hologres视频状态存储表名
  413. VIDEO_STATUS = 'longvideo.dwd_mdm_item_video_stat'
  414. # 从流量池获取视频接口地址
  415. GET_VIDEOS_FROM_POOL_URL = 'http://api-internal.piaoquantv.com/flowpool/video/getAllVideo'
  416. # 获取视频在流量池中的剩余可分发数接口地址
  417. GET_REMAIN_VIEW_COUNT_URL = 'http://api-internal.piaoquantv.com/flowpool/video/remainViewCount'
  418. # 计算完ROV通知后端接口地址
  419. NOTIFY_BACKEND_UPDATE_ROV_SCORE_URL = 'http://recommend-common-internal.piaoquantv.com/longvideoapi/openapi/recommend/updateRovScore'
  420. # 获取置顶视频列表接口地址
  421. TOP_VIDEO_LIST_URL = 'http://recommend-common-internal.piaoquantv.com/longvideoapi/openapi/recommend/topVideoList'
  422. # 获取首页兜底视频json接口地址
  423. BOTTOM_JSON_URL = 'http://recommend-common-internal.piaoquantv.com/longvideoapi/openapi/video/distribute/structure/video/list'
  424. # logs 上传oss 目标Bucket指定目录
  425. OSS_FOLDER_LOGS = 'rov-offline/pro/logs/'
  426. # data 上传oss 目标Bucket指定目录
  427. OSS_FOLDER_DATA = 'rov-offline/pro/data/'
  428. def set_config():
  429. # 获取环境变量 ROV_OFFLINE_ENV
  430. env = os.environ.get('ROV_OFFLINE_ENV')
  431. # env = 'dev'
  432. if env is None:
  433. # log_.error('ENV ERROR: is None!')
  434. return
  435. if env == 'dev':
  436. return DevelopmentConfig(), env
  437. elif env == 'test':
  438. return TestConfig(), env
  439. elif env == 'pre':
  440. return PreProductionConfig(), env
  441. elif env == 'pro':
  442. return ProductionConfig(), env
  443. else:
  444. # log_.error('ENV ERROR: is {}'.format(env))
  445. return