clean_mysql.sh 1.3 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859
  1. #! /bin/bash
  2. . ./config.sh
  3. host=$MYSQL_HOST
  4. username=$MYSQL_USER
  5. password=$MYSQL_PASSWORD
  6. database=saga_dw
  7. del_energy_15_min="truncate table energy_15_min;"
  8. del_energy_5_min="truncate table energy_5_min;"
  9. del_energy_15_min_fjd="truncate table energy_15_min_fjd;"
  10. del_energy_5_min_fjd="truncate table energy_5_min_fjd;"
  11. ## 历史数据一次性导入后,需要删除 mysql 中的冗余数据
  12. clean_energy_15(){
  13. mysql -h${host} -P3306 -u${username} -p${password} ${database} -e "${del_energy_15_min}"
  14. }
  15. clean_energy_5(){
  16. mysql -h${host} -P3306 -u${username} -p${password} ${database} -e "${del_energy_15_min_fjd}"
  17. }
  18. clean_energy_15_fjd(){
  19. mysql -h${host} -P3306 -u${username} -p${password} ${database} -e "${del_energy_5_min}"
  20. }
  21. clean_energy_5_fjd(){
  22. mysql -h${host} -P3306 -u${username} -p${password} ${database} -e "${del_energy_5_min_fjd}"
  23. }
  24. case $1 in
  25. "all")
  26. clean_energy_15
  27. clean_energy_15_fjd
  28. clean_energy_5
  29. clean_energy_5_fjd
  30. ;;
  31. "clean_15")
  32. clean_energy_15
  33. clean_energy_15_fjd
  34. ;;
  35. "clean_5")
  36. clean_energy_5
  37. clean_energy_5_fjd
  38. ;;
  39. "clean_energy_15")
  40. clean_energy_15
  41. ;;
  42. "clean_energy_15_fjd")
  43. clean_energy_15_fjd
  44. ;;
  45. "clean_energy_5")
  46. clean_energy_5
  47. ;;
  48. "clean_energy_5_fjd")
  49. clean_energy_5_fjd
  50. ;;
  51. esac