def get_server(server_id): """ 获取服务器 """ cur_ser = mysql_connection.get_game_manager_mysql_connection().query("SELECT * FROM server_list WHERE id = %s" % server_id) if cur_ser: return cur_ser[0] else: return None
def get_all_server_dict(refresh=False): """ 获取当前所有服务器的ID与网络地址的字典 """ if ServerListDat.is_need_refresh() or refresh: connect = mysql_connection.get_game_manager_mysql_connection() result_dict = {} server_dict = connect.query("SELECT id,url FROM server_list") for res in server_dict: result_dict[int(res['id'])] = res['url'] return result_dict
def get_all_server(refresh=False): """ 获取当前服务器列表 """ if ServerListDat.is_need_refresh() or refresh: connect = mysql_connection.get_game_manager_mysql_connection() ServerListDat.cur_all_server_dat = connect.query("SELECT * FROM server_list") ServerListDat.cur_refresh_time = datetime.datetime.now() return ServerListDat.cur_all_server_dat else: return ServerListDat.cur_all_server_dat
def update_server(server_id, url, name, state, hidden, version,open_server_time): """ 更新新服务器 """ sql = "SELECT * FROM server_list WHERE id = %s " %server_id dat = mysql_connection.get_game_manager_mysql_connection().query(sql) # print("dat: "+str(dat)+"notice: "+str(notice)+"version: "+str(version)) if dat: sql = "UPDATE server_list SET " \ "id = %s, " \ "url = '%s', " \ "name = '%s', " \ "state = %s, " \ "hidden = %s, " \ "version = '%s', " \ "open_server_time = '%s' " \ "WHERE id = %s" %\ (server_id, url, name, state, hidden, version, open_server_time, server_id) mysql_connection.get_game_manager_mysql_connection().execute(sql) else: sql = "INSERT INTO server_list (id,url,name,state,hidden,version,open_server_time) VALUES (%s,'%s','%s',%s,%s,'%s','%s')" % (server_id, url, name, state, hidden,version,open_server_time) mysql_connection.get_game_manager_mysql_connection().execute(sql)
def delete_server(server_id): """ 移除表格 """ sql = "DELETE FROM server_list WHERE id=%s" % server_id mysql_connection.get_game_manager_mysql_connection().execute(sql)