statServerData = StatServerDataCountry()
statServerData.country_code=country
for k, v in values.iteritems():
setattr(statServerData, k, v)
statServerData.stat_date = date
if self.isInsert:
statServerData.persist()
#print ''
else:
self.statServerDatass.append(statServerData)
date = get_date_str_by_day(date,1,'%Y-%m-%d')
# if self.is_input:
# break
if string_to_datetime(date,'%Y-%m-%d') >= string_to_datetime(get_date(),'%Y-%m-%d') :
break;
def get_server_list(self):
servers = []
# servers = []
# s1 = Server()
# s1.db_connect = "server=118.244.198.81,3306;database=ldsg_h10;user=ldsg_h10_op;pwd=3e454ss3kd40e24;"
# s1.server_id = 1
# s2 = Server()
# s2.db_connect = "server=118.244.198.86,3306;database=ldsg_h11;user=ldsg_h11_rd;pwd=e727484b3251bc;"
# s2.server_id = 2
# servers.append(s1)
# servers.append(s2)
if self.server_id is not None:
server = Server.load(server_id = self.server_id)
statServerData = StatServerDataCountry()
statServerData.country_code = country
for k, v in values.iteritems():
setattr(statServerData, k, v)
statServerData.stat_date = date
if self.isInsert:
statServerData.persist()
#print ''
else:
self.statServerDatass.append(statServerData)
date = get_date_str_by_day(date, 1, '%Y-%m-%d')
# if self.is_input:
# break
if string_to_datetime(date, '%Y-%m-%d') >= string_to_datetime(
get_date(), '%Y-%m-%d'):
break
def get_server_list(self):
servers = []
# servers = []
# s1 = Server()
# s1.db_connect = "server=118.244.198.81,3306;database=ldsg_h10;user=ldsg_h10_op;pwd=3e454ss3kd40e24;"
# s1.server_id = 1
# s2 = Server()
# s2.db_connect = "server=118.244.198.86,3306;database=ldsg_h11;user=ldsg_h11_rd;pwd=e727484b3251bc;"
# s2.server_id = 2
# servers.append(s1)
# servers.append(s2)
if self.server_id is not None:
curr_cursor = connection.cursor()
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 = {}
