def get_server_online(redis_connect): try: redis_cfg = server_util.str_to_redisconfig(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'], socket_timeout=1) s = client.get("ldsg_local_system_status_key") if s: info = json.loads(s) online = info["connCount"] return online except: logging.debug(traceback.format_exc()) pass return 0
def get_online(server_id): servers = get_server_list(server_id) data = {} for server in servers: if not server: continue try: redis_cfg = str_to_redisconfig(server.redis_connect) 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"] data[server.server_id] = online except: pass return data
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()