def stat():
server_list = get_server_list()
file_name = "/data/apps/ldsg_admin/ldsg_admin/client/stat/stat/temp.csv"
new_file = open(file_name,"wb")
new_file.write("server_name,lodo_id\n")
server_ids = ['h1','h2','h3','h4','h5','h6','h7','h8','h9','h10','h11','h12','h13','h14','h15','h16','h17','h18','h19','h20','h21','h22']
for server in server_list:
if server.server_id not in server_ids:
continue
date_map_o = []
date_map_t = []
date_map_tt = []
try:
connection = get_conn(server_util.str_to_dbconfig(server.db_connect))
cursor = connection.cursor()
date_o = "2014-03-08"
date_t = get_date_str_by_day(date_o,1,'%Y-%m-%d')
date_tt = get_date_str_by_day(date_t,1,'%Y-%m-%d')
sql_o = "SELECT DISTINCT user_id FROM payment_log WHERE DATE_FORMAT(created_time,'%%Y-%%m-%%d') = '%s' group by user_id" % date_o
sql_t = "SELECT DISTINCT user_id FROM payment_log WHERE DATE_FORMAT(created_time,'%%Y-%%m-%%d') = '%s' group by user_id" % date_t
sql_tt = "SELECT DISTINCT user_id FROM payment_log WHERE DATE_FORMAT(created_time,'%%Y-%%m-%%d') = '%s' group by user_id" % date_tt
infos_o = cursor.fetchall(sql_o)
infos_t = cursor.fetchall(sql_t)
infos_tt = cursor.fetchall(sql_tt)
for info in infos_o:date_map_o.append(info['user_id'])
for info in infos_t:date_map_t.append(info['user_id'])
for info in infos_tt:date_map_tt.append(info['user_id'])
for k in date_map_o:
if date_map_t.count(k) > 0 and date_map_tt.count(k) > 0:
str_t = "%s,%s\n" % (server.server_name, cursor.fetchone("select lodo_id from user where user_id = '%s'" % k)["lodo_id"])
new_file.write(str_t.encode("gbk"))
except:
print traceback.format_exc()
finally:
cursor.close()
new_file.close()
finally:
if cursor is not None:
cursor.close()
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
if cursor is not None:
cursor.close()
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)
