db_config.py 2.4 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970
  1. from sqlalchemy import create_engine
  2. # 线上数据库连接字符串
  3. # host = "139.186.151.174"
  4. # port = 3306
  5. # user = "hcst"
  6. # passwd = "hcst@2020"
  7. # db = 'jeecg-boot'
  8. # charset = 'utf8'
  9. # db_con_str = "mysql+pymysql://%s:%s@%s:%d/%s" % ("readonly", "hcst@2021", "139.186.27.96", 4000, "jeecg-boot")
  10. # 测试数据库连接字符串
  11. host = "139.186.151.174"
  12. port = 3306
  13. user = "hcst"
  14. passwd = "hcst@2020"
  15. db = 'jeecg-boot'
  16. charset = 'utf8'
  17. db_con_str = "mysql+pymysql://%s:%s@%s:%d/%s" % ("hcst", "hcst@2020", "139.186.151.174", 3306, "jeecg-boot")
  18. engine = create_engine(db_con_str, connect_args={'charset': 'utf8'})
  19. headers = {'Content-Type': 'application/json'}
  20. # 创建计划url
  21. create_campaign_url = "http://192.168.1.8:8080/jeecg-boot/kuaishou/create/campaignCreate"
  22. # 获取上新视频url
  23. get_new_video_url = "http://192.168.1.8:8080/jeecg-boot/kuaishou/material/getNewVideoList"
  24. # 获取历史视频url
  25. get_history_video_url = "http://192.168.1.8:8080/jeecg-boot/kuaishou/material/getHistoryVideoList"
  26. # 创建组和创意url
  27. create_group_and_creative_url = "http://192.168.1.8:8080/jeecg-boot/kuaishou/create/createUnitAndCreative"
  28. # 获取历史遗漏视频url
  29. get_historical_missing_video_url = "http://192.168.1.8:8080/jeecg-boot/kuaishou/material/getHistoryVideoList"
  30. # 获取历史高质量视频url
  31. get_historical_high_quality_video_url = "http://192.168.1.8:8080/jeecg-boot/kuaishou/material/getHistoryVideoList"
  32. # ai 策略请求url
  33. ai_strategy_request_url = 'http://127.0.0.1:31012/ai_strategy_request'
  34. # 账户列表
  35. account_id_list = [9556344, 9743738, 9743727]
  36. # 补充历史遗落素材的个数
  37. historical_missing_video_cnt = 100
  38. # 近多少天的爆量视频
  39. high_quality_video_days = 14
  40. # 创意层级基本信息
  41. creative_info = {'creative_name': '自定义创意',
  42. 'creative_category': 20101,
  43. 'creative_tag': ['起量', '搞笑'],
  44. 'action_bar_text': '一键下载',
  45. 'description': '不买亏大了!众多商品低至一元!看看你多花了多少冤枉钱!'}
  46. # 每个素材最多搭配的封面个数
  47. image_cnt = 5
  48. # 计划名称 和 组名称 的头部
  49. account_id_to_name = {9556344: '户14', 9743738: '户8', 9743727: '户9'}
  50. campaign_name = '-上下滑&信息流-自定义-剪辑-低价-低价包邮-活动-年龄18岁以上-单出价-'
  51. unit_name = '-上下滑&信息流-剪辑-低价-低价包邮-活动-年龄18岁以上-单出价-'