url_and_db.py 2.1 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758
  1. import uuid
  2. import yaml
  3. from utils.commonFunc import get_db_engine
  4. headers = {'Content-Type': 'application/json'}
  5. with open('/data/pythonProject/ai_target/config/config.yaml', mode='r', encoding='utf-8') as f:
  6. config = yaml.load(f.read(), Loader=yaml.FullLoader)
  7. mac_ip_config = config['mac_ip_config']
  8. # 数据库连接引擎,依据开发环境/测试环境/生产环境 进行切换
  9. mac = uuid.UUID(int=uuid.getnode()).hex[-12:]
  10. if mac in ['5254003fa716', '00163e9162d9']:
  11. jeecg_db = get_db_engine(config['jeecg_dev_db'])
  12. application_inner_db = get_db_engine(config['application_inner_db_inner_ip'])
  13. db_config_info = config['jeecg_dev_db']
  14. else:
  15. jeecg_db = get_db_engine(config['jeecg_product_db'])
  16. application_inner_db = get_db_engine(config['application_inner_db_outer_ip'])
  17. db_config_info = config['jeecg_product_db']
  18. jeecg_product_db = get_db_engine(config['jeecg_product_db'])
  19. application_product_db = get_db_engine(config['application_product_db'])
  20. # 创建计划url
  21. create_campaign_url = mac_ip_config[mac]['yourong_url'] + 'kuaishou/create/campaignCreate'
  22. # 修改广告计划状态url
  23. # 入参:accountId 账户id Long
  24. # putStatus 状态 1-投放、2-暂停、3-删除 int
  25. # userId 操作人id string
  26. # campaignIds 计划id集合 array
  27. # 返回结果
  28. # {
  29. # "success": true,
  30. # "message": "操作成功!",
  31. # "code": 0,
  32. # "result": {
  33. # "failCount": 1,
  34. # "failInfo": [
  35. # {
  36. # "message": "access token错误"
  37. # }
  38. # ],
  39. # "totalCount": 1
  40. # },
  41. # "timestamp": 1630030314462
  42. # }
  43. update_campaign_status_url = mac_ip_config[mac]['yourong_url'] + 'kuaishou/batch/batchUpdateStatus'
  44. # 创建组和创意url
  45. create_group_and_creative_url = mac_ip_config[mac]['yourong_url'] + 'kuaishou/create/createUnitAndCreative'
  46. # ai_target_combine 服务的接口
  47. # target_combine_url = mac_ip_config[mac]['ai_target_url'] + 'ai_target_combine'
  48. # 定向人群预估查询
  49. estimate_people_number_url = mac_ip_config[mac]['yourong_url'] + 'estimatePeopleNumber/getCount'