db_config.py 2.4 KB

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