Function generate_schema_security_report

web/pgadmin/llm/__init__.py:1430–1502

Generate a security report for the specified schema. Uses the multi-stage pipeline to analyze schema security.

(sid, did, scid)

)
@pga_login_required
def generate_schema_security_report(sid, did, scid):
    """
    Generate a security report for the specified schema.
    Uses the multi-stage pipeline to analyze schema security.
    """
    from pgadmin.llm.utils import is_llm_enabled
    from pgadmin.llm.reports.generator import generate_report_sync
    from pgadmin.utils.driver import get_driver

    # Check if LLM is configured
    if not is_llm_enabled():
        return make_json_response(
            success=0,
            errormsg=gettext(
                'LLM is not configured. Please configure an LLM provider '
                'in Preferences > AI.'
            )
        )

    # Get database connection
    try:
        driver = get_driver(config.PG_DEFAULT_DRIVER)
        manager = driver.connection_manager(sid)
        conn = manager.connection(did=did)

        if not conn.connected():
            return make_json_response(
                success=0,
                errormsg=gettext('Database is not connected.')
            )

        # Get schema name from scid
        schema_query = (
            "SELECT nspname FROM pg_catalog.pg_namespace WHERE oid = %s"
        )
        status, result = conn.execute_dict(schema_query, [scid])
        if not status or not result.get('rows'):
            return make_json_response(
                success=0,
                errormsg=gettext('Schema not found.')
            )
        schema_name = result['rows'][0]['nspname']

        # Generate report using pipeline
        context = {
            'database_name': conn.db,
            'schema_name': schema_name,
            'schema_oid': scid
        }
        success, result = generate_report_sync(
            report_type='security',
            scope='schema',
            conn=conn,
            manager=manager,
            context=context
        )

        if success: