Method children

web/pgadmin/browser/utils.py:417–462

Build a list of treeview nodes from the child nodes.

(self, **kwargs)

        return nodes

    def children(self, **kwargs):
        """Build a list of treeview nodes from the child nodes."""

        if 'sid' not in kwargs:
            return precondition_required(
                gettext('Required properties are missing.')
            )

        from pgadmin.utils.driver import get_driver
        manager = get_driver(PG_DEFAULT_DRIVER).connection_manager(
            sid=kwargs['sid']
        )

        did = None
        if 'did' in kwargs:
            did = kwargs['did']

        try:
            conn = manager.connection(did=did)
            # Use ping() instead of connected() to detect stale /
            # half-open TCP connections that were silently dropped while
            # pgAdmin was idle.  connected() only checks local state and
            # would miss these, causing the subsequent SQL queries to
            # hang indefinitely.
            if not conn.ping():
                status, msg = conn.connect()
                if not status:
                    return service_unavailable(
                        msg, info="CONNECTION_LOST"
                    )
        except (ConnectionLost, SSHTunnelConnectionLost, CryptKeyMissing):
            raise
        except Exception:
            return precondition_required(
                gettext(
                    "Connection to the server has been lost."
                )
            )

        # Return sorted nodes based on label
        return make_json_response(
            data=sorted(
                self.get_children_nodes(manager, **kwargs),
                key=lambda c: c['label']
            )
        )

    def get_dependencies(self, conn, object_id, where=None,
                         show_system_objects=None, is_schema_diff=False):