def set_server_list(request): server_id = request.REQUEST.get('server_id', None) if server_id: request.COOKIES['sid'] = server_id server_id = request.COOKIES.get('sid', server_id) server_list = server_business.get_all_server_list() partner_list = partner_business.get_all_partner_list() user = user_roles.get_userinfo(request) server_list_map = {} for server in server_list: server_zone = server.server_zone server_zone_server_list = server_list_map.get(server_zone, []) server_zone_server_list.append(server) server_list_map[server_zone] = server_zone_server_list for k, values in server_list_map.iteritems(): values = sorted( values, cmp=lambda x, y: cmp(int(x.server_id[1:]), int(y.server_id[1:]))) server_list_map[k] = values return { 'server_list': server_list, 'server_id': server_id, 'partner_list': partner_list, "user": user, "server_list_map": server_list_map, "server_zone_map": server_zone_map }
def get_server_list(self): servers = [] if self.server_id is not None: server = Server.load(server_id = self.server_id) servers.append(server) return servers else: return server_business.get_all_server_list()
def get_server_list(self): servers = [] if self.server_id is not None: server = Server.load(server_id=self.server_id) servers.append(server) return servers else: return server_business.get_all_server_list()
def get_server_list(server_id): 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 server_id != "all": server = Server.load(server_id = server_id) servers.append(server) return servers else: return server_business.get_all_server_list()
def get_server_list(server_id): 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 server_id != "all": server = Server.load(server_id=server_id) servers.append(server) return servers else: return server_business.get_all_server_list()
def main(): """main""" servers = server_business.get_all_server_list() date = get_time() for server in servers: if not server: continue redis_cfg = str_to_redisconfig(server.redis_connect) logging.debug("host[%s], port[%s]" % (redis_cfg['host'], redis_cfg['port'])) client = redis.Redis(host=redis_cfg['host'], port=redis_cfg['port']) s = client.get("ldsg_local_system_status_key") if s: info = json.loads(s) online = info["connCount"] cursor = connection.cursor() try: cursor.execute( "INSERT INTO stat_online(online, stat_time,server_id) VALUES(%d, '%s','%s')" % (online, date, server.server_id)) finally: connection.close()
def set_server_list(request): server_id = request.REQUEST.get('server_id', None) if server_id: request.COOKIES['sid'] = server_id server_id = request.COOKIES.get('sid', server_id) server_list = server_business.get_all_server_list() partner_list = partner_business.get_all_partner_list() user = user_roles.get_userinfo(request) server_list_map = {} for server in server_list: server_zone = server.server_zone server_zone_server_list = server_list_map.get(server_zone, []) server_zone_server_list.append(server) server_list_map[server_zone] = server_zone_server_list for k, values in server_list_map.iteritems(): values = sorted(values, cmp=lambda x, y : cmp(int(x.server_id[1:]), int(y.server_id[1:]))) server_list_map[k] = values return {'server_list': server_list, 'server_id': server_id, 'partner_list': partner_list, "user": user, "server_list_map": server_list_map, "server_zone_map": server_zone_map}
def get_server_list(): return server_business.get_all_server_list()