url_and_db.py 2.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354
  1. from urllib import parse
  2. import uuid
  3. import yaml
  4. from sqlalchemy import create_engine
  5. # 创建数据库连接引擎
  6. def get_db_engine(db_info):
  7. db_con_str = 'mysql+pymysql://%s:%s@%s:%d/%s' % \
  8. (db_info['user'],
  9. parse.quote_plus(db_info['password']),
  10. db_info['host'],
  11. db_info['port'],
  12. db_info['database'])
  13. engine = create_engine(db_con_str, connect_args={'charset': 'utf8mb4'}, poolclass=None)
  14. return engine
  15. with open('/data/pythonProject/video_to_word/config/config.yaml', mode='r', encoding='utf-8') as f:
  16. config = yaml.load(f.read(), Loader=yaml.FullLoader)
  17. mac_ip_config = config['mac_ip_config']
  18. mac = uuid.UUID(int=uuid.getnode()).hex[-12:]
  19. if mac in ['5254003fa716', '00163e9162d9']:
  20. ai_word_engine = get_db_engine(config['ai_word_dev_db'])
  21. jeecg_engine = get_db_engine(config['jeecg_boot_dev_db'])
  22. else:
  23. ai_word_engine = get_db_engine(config['ai_word_product_db'])
  24. jeecg_engine = get_db_engine(config['jeecg_boot_product_db'])
  25. jeecg_product_engine = get_db_engine(config['jeecg_boot_product_db'])
  26. ai_word_product_engine = get_db_engine(config['ai_word_product_db'])
  27. # 向腾讯云发送语音转脚本的任务请求url
  28. voice_to_script_task_submit_url = mac_ip_config[mac]['url'] + 'asr/task/submit'
  29. # 依据task_id,向腾讯云获取脚本
  30. voice_to_script_task_result_url = mac_ip_config[mac]['url'] + 'asr/task/result'
  31. # 巨量引擎获取优质素材信息
  32. get_material_info_from_ocean_engine_url = "https://cc.oceanengine.com/creative_radar_api/v1/material/list"
  33. # 依据 vid, 从巨量引擎获取视频信息
  34. get_video_info_from_ocean_engine_url = "https://cc.oceanengine.com/creative_content_server/api/video/info"
  35. # 快手开眼快创获取优质素材信息
  36. get_video_info_from_kuaishou_kaiyan = "https://cc.e.kuaishou.com/rest/creativeCentor/inspired/list"
  37. # 头条无水印链接
  38. get_none_water_mark_url = "http://i.snssdk.com/video/urls/1/toutiao/mp4/"
  39. # 头条素材永久链接
  40. toutiao_static_video_url = "http://i.snssdk.com/video/code/1/toutiao/"