Function servers

web/pgadmin/tools/schema_diff/__init__.py:274–318

This function will return the list of servers for the specified server id.

()

)
@pga_login_required
def servers():
    """
    This function will return the list of servers for the specified
    server id.
    """
    res = {}
    auto_detected_server = None
    try:
        """Return a JSON document listing the server groups for the user"""
        driver = get_driver(PG_DEFAULT_DRIVER)

        from pgadmin.browser.server_groups.servers import\
            server_icon_and_background

        for server in get_user_server_query().filter(
                Server.is_adhoc == 0):

            shared_server = SharedServer.query.filter_by(
                user_id=current_user.id,
                osid=server.id).first()

            if server.discovery_id and shared_server:
                continue

            manager = driver.connection_manager(server.id)
            conn = manager.connection()
            connected = conn.connected()
            server_info = {
                "value": server.id,
                "label": server.name,
                "image": server_icon_and_background(connected, manager,
                                                    server),
                "_id": server.id,
                "connected": connected
            }

            if server.servergroup.name in res:
                res[server.servergroup.name].append(server_info)
            else:
                res[server.servergroup.name] = [server_info]

    except Exception as e:
        app.logger.exception(e)

    return make_json_response(data=res)


@blueprint.route(