sql = "update stat_liucun_data set is_hostory = 1" curr_cursor.execute(sql) except Exception,e: self.log(e) finally: if curr_cursor is not None: curr_cursor.close() server_list = self.get_server_list() now_time = datetime.datetime.now() for server in server_list: try: if server.server_status==100: continue begin_date = server.open_time while(datetime_to_string(now_time,"%Y-%m-%d") != datetime_to_string(begin_date,"%Y-%m-%d") and now_time < string_to_datetime(get_datetime_str_by_day(begin_date,30))): statLiucunData = StatLiucunDataDate.query(condition="server_id='%s' and data_date='%s'" % (server.server_id,datetime_to_string(begin_date,"%Y-%m-%d"))) if statLiucunData: statLiucunData[0].is_hostory = 1 statLiucunData[0].persist() self.stat(server,begin_date) begin_date = string_to_datetime(get_datetime_str_by_day(begin_date,1)); statLiucunData = StatLiucunDataDate() statLiucunData.delete_mul(is_hostory=1) except Exception,ex: self.log(ex) def stat(self,server,open_time): self.log("LiuCunServerData start %s,server:[%s]" % (get_time(),server.server_name)) values = {} days = {'one_user':0,'two_user':1,'three_user':3,'four_user':4,'five_user':5,'six_user':6,'seven_user':7,'fivteen_user':15,'thirty_user':30}
def get_stat_liucun_server(server_id): return StatLiucunDataDate.query(condition="server_id='%s'" % server_id)