123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960 |
- #!/bin/sh
- #@数据库、elasticsearch、redis服务的IP
- IP='127.0.0.1'
- #@执行mongodb命令的路径
- MongoPath='/opt/mongodb/bin/mongo'
- #@执行redis命令的路径
- RedisPath='/opt/soft/redis-2.6.17/src/redis-cli'
- #@传递企业的ID数据
- ID=$1
- if [ -z "$ID" ]
- then
- echo "请输入企业id,再执行"
- exit
- else
- echo "开始执行操作"
- fi
- #1.删除mongodb库中数据
- sql="db.enterprise.remove({\"_id\":ObjectId(\"$ID\")})"
- sql2=`echo "$sql" | $MongoPath $IP:27080/qfw --shell`
- sqlLen=`echo $sql2 | grep '"nRemoved" : 1'`
- s1=`expr length "$sqlLen"`
- if [ $s1 -gt 0 ]
- then
- echo "删除mogodb数据成功"
- else
- echo "mogodb未找到企业数据"
- fi
- #2.删除elasticsearch数据
- elastic=`curl -XDELETE http://$IP:9800/enterprise/enterprise/$ID`
- sqlLen=`echo $elastic | grep '"found":true'`
- s1=`expr length "$sqlLen"`
- if [ $s1 -gt 0 ]
- then
- echo "删除elastic数据成功"
- else
- echo "elastic未找到企业数据"
- fi
- #3.删除缓存
- redis=`echo enterpriseInfo_$ID |xargs $RedisPath -h $IP -p 8379 -n 0 del`
- if [ $redis -gt 0 ]
- then
- echo "删除redis数据成功"
- else
- echo "redis未找到企业数据"
- fi
- #4.清除用户表的认证字段
- usql="db.user.update({\"s_enterpriseid\" : \"$ID\"},{\"\$unset\":{\"i_identificationtype\":1,\"s_audit_record_id\":1,\"s_enterprisename\":1,\"s_enterpriseid\":1}})"
- usql2=`echo "$usql" | $MongoPath $IP:27080/qfw --shell`
- sqlLen=`echo $usql2 | grep '"nMatched" : 1'`
- s1=`expr length "$sqlLen"`
- if [ $s1 -gt 0 ]
- then
- echo "更新mogodb用户成功"
- else
- echo "mogodb未找到此用户"
- fi
|