# -*- coding: utf-8 -*- # !/usr/bin/env python from mongoengine import Q from base import init_env, get_logger init_env(interactive = False) logger = get_logger(__name__) from apps.web.dealer.models import UpscoreRecord from apps.web.device.models import Device,FeedBack,DeviceEvent,Comment from apps.web.report.models import DevReport from apps.web.user.models import ConsumeRecord,CardRechargeOrder,CardRechargeRecord,CardConsumeRecord,VCardConsumeRecord,RechargeRecord from apps.web.management.models import ManagerUpScoreRecord tempNo = '2ofasdvasdvne3fdadv3elsdf' devNo1 = '868575025774268' devNo2 = '868575026250201' # 删除上分记录 UpscoreRecord UpscoreRecord.get_collection().remove({'devNo':devNo1}) UpscoreRecord.get_collection().remove({'devNo':devNo2}) # 删除反馈记录 FeedBack FeedBack.get_collection().remove({'devNo':devNo1}) FeedBack.get_collection().remove({'devNo':devNo2}) # 删除DeviceEvent DeviceEvent.get_collection().remove({'devNo':devNo1}) DeviceEvent.get_collection().remove({'devNo':devNo2}) # 删除评论Comment Comment.get_collection().remove({'devNo':devNo1}) Comment.get_collection().remove({'devNo':devNo2}) # ManagerUpScoreRecord 记录删除 ManagerUpScoreRecord.get_collection().remove({'devNo':devNo1}) ManagerUpScoreRecord.get_collection().remove({'devNo':devNo2}) # CardRechargeOrder 记录删除 CardRechargeOrder.get_collection().remove({'devNo':devNo1}) CardRechargeOrder.get_collection().remove({'devNo':devNo2}) # CardRechargeRecord 记录删除 CardRechargeRecord.get_collection().remove({'devNo':devNo1}) CardRechargeRecord.get_collection().remove({'devNo':devNo2}) # CardConsumeRecord 记录删除 CardConsumeRecord.get_collection().remove({'devNo':devNo1}) CardConsumeRecord.get_collection().remove({'devNo':devNo2}) # VCardConsumeRecord 数据交换 VCardConsumeRecord.get_collection().update({'devNo':devNo1},{'$set':{'devNo':tempNo}},multi=True) VCardConsumeRecord.get_collection().update({'devNo':devNo2},{'$set':{'devNo':devNo1}},multi=True) VCardConsumeRecord.get_collection().update({'devNo':tempNo},{'$set':{'devNo':devNo2}},multi=True) # DevReport 数据交换 DevReport.get_collection().update({'devNo':devNo1},{'$set':{'devNo':tempNo}},multi=True) DevReport.get_collection().update({'devNo':devNo2},{'$set':{'devNo':devNo1}},multi=True) DevReport.get_collection().update({'devNo':tempNo},{'$set':{'devNo':devNo2}},multi=True) # RechargeRecord 数据交换 RechargeRecord.get_collection().update({'devNo':devNo1},{'$set':{'devNo':tempNo}},multi=True) RechargeRecord.get_collection().update({'devNo':devNo2},{'$set':{'devNo':devNo1}},multi=True) RechargeRecord.get_collection().update({'devNo':tempNo},{'$set':{'devNo':devNo2}},multi=True) # ConsumeRecord 数据交换 ConsumeRecord.get_collection().update({'devNo':devNo1},{'$set':{'devNo':tempNo}},multi=True) ConsumeRecord.get_collection().update({'devNo':devNo2},{'$set':{'devNo':devNo1}},multi=True) ConsumeRecord.get_collection().update({'devNo':tempNo},{'$set':{'devNo':devNo2}},multi=True) # Device 数据交换 Device.get_collection().update({'devNo':devNo1},{'$set':{'devNo':tempNo}},multi=True) Device.get_collection().update({'devNo':devNo2},{'$set':{'devNo':devNo1}},multi=True) Device.get_collection().update({'devNo':tempNo},{'$set':{'devNo':devNo2}},multi=True) # 删除缓存 Device.invalid_device_cache(devNo1) Device.invalid_device_cache(devNo2) logger.info('finish all!')