manyi/script/exchange_dev_no.py

# -*- 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!')