py_mysql.sh 752 B

1234567891011121314151617181920212223
  1. #!/bin/bash
  2. #. /opt/app/bi-app/energy/dayTask/config.sh
  3. if [ -n "$2" ] ;then
  4. echo "如果是输入的日期按照取输入日期"
  5. do_date=$2
  6. startSec=`date -d "$do_date" "+%s"`
  7. echo $startSec
  8. current_day=`date -d "@$startSec" "+%Y-%m-%d"`
  9. one_day_ago=`date -d "$current_day yesterday" +%Y%m%d`
  10. start_time=`date -d "0 day $current_day" +%Y%m%d`000000
  11. end_time=`date -d "1 day $current_day" +%Y%m%d`000000
  12. else
  13. echo "====没有输入数据的日期,取当前时间的前一天===="
  14. start_time=`date -d yesterday +"%Y%m%d"`000000
  15. end_time=`date +"%Y%m%d"`000000
  16. fi
  17. echo $start_time
  18. echo $end_time
  19. /usr/local/bin/python3 /opt/app/python_transfer/start_mysql.py --start_time $start_time --end_time $end_time