data_stat_run.py 1.2 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455
  1. from model.DateUtils import DateUtils
  2. from model.log import logger
  3. from model.DingTalkUtils import DingTalkUtils
  4. from data_stat_task import *
  5. from sync_to_ck_task import *
  6. from app.etl.dm.dm_pitcher_daily_overview import dm_pitcher_daily_overview
  7. from app.etl.dw.dw_channel_daily import dw_daily_channel
  8. from app.etl.dw.dw_pitcher_daily import dw_pitcher_daily,dw_pitcher_trend
  9. log=logger()
  10. du = DateUtils()
  11. import sys
  12. def do_order(st,et):
  13. for i in du.getDateLists(st,et):
  14. ods_order(i)
  15. order_sync_ck(i)
  16. def do_cost(st,et):
  17. for i in du.getDateLists(st,et):
  18. channel_by_account_daily(i)
  19. channel_info_daily(i)
  20. dw_daily_channel_cost(i)
  21. dw_order_channel_cost_sync_ck(i)
  22. def main(st,et):
  23. do_order(st,et)
  24. do_cost(st,et)
  25. dw_daily_channel()
  26. dw_pitcher_daily()
  27. dm_pitcher_daily_overview()
  28. dw_pitcher_trend()
  29. def hourly():
  30. thedate=du.getTodayOrYestoday()
  31. main(thedate, thedate)
  32. def daily():
  33. "往前跑10天"
  34. st=du.get_n_days(-10)
  35. et=du.get_n_days(-1)
  36. do_order(st, et)
  37. do_cost(st, et)
  38. if __name__ == '__main__':
  39. do_cost('2021-01-20','2021-01-28')
  40. dw_daily_channel()
  41. dw_pitcher_daily()
  42. dm_pitcher_daily_overview()
  43. dw_pitcher_trend()