def flush_reward_cache(self):
cache = CacheManager().cache
now = datetime.now()
for delta in xrange(1, 5):
month = now.month - 1 + delta
year = now.year + month / 12
month = month % 12 + 1
max_day = calendar.monthrange(year, month)[1]
end_day = (datetime(year=year, month=month, day=max_day) + timedelta(days=1)).strftime('%Y-%m-%d')
user_cache_key = USER_DATE_REWARD_CACHE % (self.room_id, end_day)
cache.delete(user_cache_key)
def delete(self):
db = DbManager().db
content_id = self.id
db.execute('begin;')
try:
sql = 'delete from {table} where id=%s'.format(table=self.table)
db.execute(sql, content_id)
db.execute('commit;')
except:
db.execute('rollback;')
raise
cache = CacheManager().cache
posts_cache_key = POSTS_CACHE_KEY % content_id
cache.delete(posts_cache_key)
def flush_comment_cache(self):
cache = CacheManager().cache
cache_obj_key = COMMENT_CACHE_KEY % self.id
cache_list_key = CONTENT_COMMENT_CACHE_KEY % self.content_id
cache.delete(cache_obj_key)
cache.lrem(cache_list_key, 0, self.id)
def flush_redis_room_info(self):
cache = CacheManager().cache
key = ROOM_CACHE_KEY % self.id
cache.delete(key)
def flush_device_info(self):
cache = CacheManager().cache
key = USER_DEVICE_CACHE_KEY % self.user_id
cache.delete(key)
def flush_redis_user_info(self):
cache = CacheManager().cache
key = USER_CACHE_KEY % self.id
cache.delete(key)
parser.add_option('-p', '--profile', dest='profile', default='develop')
options, args = parser.parse_args()
if not options.profile:
profile = 'product'
else:
profile = options.profile
settings.init(profile)
now = datetime.now()
yesterday = now - timedelta(days=1)
db = DbManager().db
cache = CacheManager().cache
messages = GroupMessage.get_messages_by_time(yesterday)
for message in messages:
message_id = message.id
group_id = message.group_id
# 删除群组聊天点赞记录的缓存
group_message_liked_key = GROUP_MESSAGE_LIKED_KEY % (group_id,
message_id)
cache.delete(group_message_liked_key)
# 删除群组消息列表的缓存
group_message_liked_list = GROUP_MESSAGE_LIKED_LIST % group_id
cache.zrem(group_message_liked_list, message_id)
sql = 'delete from {table} where message_id=%s and group_id=%s'.format(
table=GroupMessageLiked.table)
db.execute(sql, message_id, group_id)
sql = 'delete from {table} where id=%s'.format(
table=GroupMessage.table)
db.execute(sql, message_id)