sql = "select COALESCE(max(online),0) as max_online from stat_online where date(stat_time) = '%s' and server_id = '%s'" % (date,values['server_id'])
data = cursor.fetchone(sql)
if not data and data['max_online'] is None:
values['max_online'] = 0
else:
values['max_online'] = int(data['max_online'])
except Exception,ex:
self.log(ex)
finally:
if cursor is not None:
cursor.close()
statServerData = StatServerData()
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 = []
date, values['server_id'])
data = cursor.fetchone(sql)
if not data and data['max_online'] is None:
values['max_online'] = 0
else:
values['max_online'] = int(data['max_online'])
except Exception, ex:
self.log(ex)
finally:
if cursor is not None:
cursor.close()
statServerData = StatServerData()
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 = []
