data_stat_daily.py 724 B

12345678910111213141516171819202122232425262728293031323334353637383940414243
  1. from model.DateUtils import DateUtils
  2. from data_stat_task import *
  3. from sync_to_ck_task import *
  4. du = DateUtils()
  5. from model.DingTalkUtils import DingTalkUtils
  6. yestoday = du.get_n_days(-1)
  7. today = du.get_n_days(0)
  8. def run(ymd):
  9. try:
  10. # 公众号元数据
  11. channel_by_account_daily(ymd)
  12. channel_info_daily(ymd)
  13. # 清洗订单表-同步到ck
  14. ods_order(ymd)
  15. order_sync_ck(ymd)
  16. # 公众号维度数据-同步到ck
  17. dw_daily_channel_cost(ymd)
  18. dw_order_channel_cost_sync_ck(ymd)
  19. except Exception as e:
  20. DingTalkUtils.send("数据ETL出错:",'18860455786')
  21. if __name__ == '__main__':
  22. run(yestoday)
  23. dw_daily_channel()