clean_mysql.sh 1.6 KB

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