clean_mysql.sh 1.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172
  1. #! /bin/bash
  2. . /opt/app/bi-app/energy/dayTask/config.sh
  3. if [ -n "$2" ] ;then
  4. echo "如果是输入的日期按照取输入日期"
  5. do_date=$2
  6. else
  7. echo "====没有输入数据的日期,取当前时间的前一天===="
  8. do_date=`date -d yesterday +"%Y-%m-%d"`
  9. fi
  10. echo $do_date
  11. host=$MYSQL_HOST
  12. username=$MYSQL_USER
  13. password=$MYSQL_PASSWORD
  14. database=saga_dev
  15. del_energy_15_min="delete from energy_15_min where dt = '$do_date';"
  16. del_energy_15_min_fjd="delete from energy_15_min_fjd where dt = '$do_date';"
  17. #del_energy_15_min="truncate table energy_15_min;"
  18. #del_energy_5_min="truncate table energy_5_min;"
  19. #del_energy_15_min_fjd="truncate table energy_15_min_fjd;"
  20. #del_energy_5_min_fjd="truncate table energy_5_min_fjd;"
  21. ## 历史数据一次性导入后,需要删除 mysql 中的冗余数据
  22. clean_energy_15(){
  23. mysql -h${host} -P3306 -u${username} -p${password} ${database} -e "${del_energy_15_min}"
  24. }
  25. clean_energy_5(){
  26. mysql -h${host} -P3306 -u${username} -p${password} ${database} -e "${del_energy_5_min}"
  27. }
  28. clean_energy_15_fjd(){
  29. mysql -h${host} -P3306 -u${username} -p${password} ${database} -e "${del_energy_15_min_fjd}"
  30. }
  31. clean_energy_5_fjd(){
  32. mysql -h${host} -P3306 -u${username} -p${password} ${database} -e "${del_energy_5_min_fjd}"
  33. }
  34. case $1 in
  35. "all")
  36. clean_energy_15
  37. clean_energy_15_fjd
  38. clean_energy_5
  39. clean_energy_5_fjd
  40. ;;
  41. "clean_15")
  42. clean_energy_15
  43. clean_energy_15_fjd
  44. ;;
  45. "clean_5")
  46. clean_energy_5
  47. clean_energy_5_fjd
  48. ;;
  49. "clean_energy_15")
  50. clean_energy_15
  51. ;;
  52. "clean_energy_15_fjd")
  53. clean_energy_15_fjd
  54. ;;
  55. "clean_energy_5")
  56. clean_energy_5
  57. ;;
  58. "clean_energy_5_fjd")
  59. clean_energy_5_fjd
  60. ;;
  61. esac