def updateMiniFeed_ToCache ( feedid, minifeed ): redis = db_cache.get_redis_minifeed() if redis == None: # error logging in db_cache return False if isinstance( minifeed, dict ) : minifeed = json.dumps(minifeed, ensure_ascii=False) key = feedid+'_mfeed' if not redis.Set( key, minifeed ) : logger.error( 'updateMiniFeed_ToCache faild, key=%s, errno=%d', key, redis.GetLastErrNo() ) return False return True
def getMiniFeeds_FromCache ( feedids ): logger.debug( 'getMiniFeeds_FromCache, ids=(%s)', string.join(feedids,',') ) if len( feedids ) <= 0 : return {} redis = db_cache.get_redis_minifeed() if redis == None: # error logging in db_cache return None keys = [ feedid+'_mfeed' for feedid in feedids] minifeeds = redis.MGet( keys ) if minifeeds == None : logger.error( 'getMiniFeeds_FromCache faild, errno=%d', redis.GetLastErrNo() ) return None result = {} index = 0 for feedid in feedids : result[feedid] = minifeeds[index] #print feedids[index] , len( minifeed ) index += 1 return result
for rd in rs : print rd[1] , rd[0] print 'Feeds of [%s]-[%s], count=%d' % (begin_time, end_time, len(rs)) print 'Make sure clear up [%s] of the feeds?' % clearup_type sure = raw_input() if sure.lower() != 'y': print 'exit' exit() # 先删除DB数据 if clearup_type.lower() == 'db': print 'Clear up db...' #先做个备份 print 'insert into feed_bak select * from feed where update_time<=\'%s\' and update_time>=\'%s\'' % (begin_time, end_time) db.execute( 'delete from feed_bak where update_time<=\'%s\' and update_time>=\'%s\'' % (begin_time, end_time) ) db.execute( 'insert into feed_bak select * from feed where update_time<=\'%s\' and update_time>=\'%s\'' % (begin_time, end_time) ) print 'delete from feed where update_time<=\'%s\' and update_time>=\'%s\'' % (begin_time, end_time) db.execute( 'delete from feed where update_time<=\'%s\' and update_time>=\'%s\'' % (begin_time, end_time) ) print 'Clear up db ok!' print 'Clear up cache...' redis = db_cache.get_redis_minifeed() for rd in rs: print 'del %s' % rd[0]+'_mfeed' redis.Del( rd[0]+'_mfeed' ) print 'Clear up cache ok!'