delTestEnterpriseById.sh 1.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960
  1. #!/bin/sh
  2. #@数据库、elasticsearch、redis服务的IP
  3. IP='127.0.0.1'
  4. #@执行mongodb命令的路径
  5. MongoPath='/opt/mongodb/bin/mongo'
  6. #@执行redis命令的路径
  7. RedisPath='/opt/soft/redis-2.6.17/src/redis-cli'
  8. #@传递企业的ID数据
  9. ID=$1
  10. if [ -z "$ID" ]
  11. then
  12. echo "请输入企业id,再执行"
  13. exit
  14. else
  15. echo "开始执行操作"
  16. fi
  17. #1.删除mongodb库中数据
  18. sql="db.enterprise.remove({\"_id\":ObjectId(\"$ID\")})"
  19. sql2=`echo "$sql" | $MongoPath $IP:27080/qfw --shell`
  20. sqlLen=`echo $sql2 | grep '"nRemoved" : 1'`
  21. s1=`expr length "$sqlLen"`
  22. if [ $s1 -gt 0 ]
  23. then
  24. echo "删除mogodb数据成功"
  25. else
  26. echo "mogodb未找到企业数据"
  27. fi
  28. #2.删除elasticsearch数据
  29. elastic=`curl -XDELETE http://$IP:9800/enterprise/enterprise/$ID`
  30. sqlLen=`echo $elastic | grep '"found":true'`
  31. s1=`expr length "$sqlLen"`
  32. if [ $s1 -gt 0 ]
  33. then
  34. echo "删除elastic数据成功"
  35. else
  36. echo "elastic未找到企业数据"
  37. fi
  38. #3.删除缓存
  39. redis=`echo enterpriseInfo_$ID |xargs $RedisPath -h $IP -p 8379 -n 0 del`
  40. if [ $redis -gt 0 ]
  41. then
  42. echo "删除redis数据成功"
  43. else
  44. echo "redis未找到企业数据"
  45. fi
  46. #4.清除用户表的认证字段
  47. usql="db.user.update({\"s_enterpriseid\" : \"$ID\"},{\"\$unset\":{\"i_identificationtype\":1,\"s_audit_record_id\":1,\"s_enterprisename\":1,\"s_enterpriseid\":1}})"
  48. usql2=`echo "$usql" | $MongoPath $IP:27080/qfw --shell`
  49. sqlLen=`echo $usql2 | grep '"nMatched" : 1'`
  50. s1=`expr length "$sqlLen"`
  51. if [ $s1 -gt 0 ]
  52. then
  53. echo "更新mogodb用户成功"
  54. else
  55. echo "mogodb未找到此用户"
  56. fi