{"version": "2.1.0", "$schema": "https://json.schemastore.org/sarif-2.1.0.json", "runs": [{"tool": {"driver": {"name": "Repobility", "informationUri": "https://repobility.com", "rules": [{"id": "scanner-da0f8b31eb69bdd7", "name": "Possibly dead Python function: emit", "shortDescription": {"text": "Possibly dead Python function: emit"}, "fullDescription": {"text": "No callers detected by AST scan in this repo. Could be exported for external callers or a framework handler."}, "properties": {"scanner": "scanner-primary", "layer": "software", "severity": "low", "confidence": 1.0}}, {"id": "scanner-916f076f45e5ee58", "name": "Possibly dead Python function: listar_migraciones_pendientes", "shortDescription": {"text": "Possibly dead Python function: listar_migraciones_pendientes"}, "fullDescription": {"text": "No callers detected by AST scan in this repo. Could be exported for external callers or a framework handler."}, "properties": {"scanner": "scanner-primary", "layer": "software", "severity": "low", "confidence": 1.0}}, {"id": "scanner-41ac366ff3a1a3b0", "name": "Possibly dead Python function: normalize_historical_phones", "shortDescription": {"text": "Possibly dead Python function: normalize_historical_phones"}, "fullDescription": {"text": "No callers detected by AST scan in this repo. Could be exported for external callers or a framework handler."}, "properties": {"scanner": "scanner-primary", "layer": "software", "severity": "low", "confidence": 1.0}}, {"id": "scanner-9d6879d36b5d056d", "name": "File has no detected symbols: enable_debug_temp.py", "shortDescription": {"text": "File has no detected symbols: enable_debug_temp.py"}, "fullDescription": {"text": "Source file with no class/function declarations \u2014 possible config, dead code, or scratch file."}, "properties": {"scanner": "scanner-primary", "layer": "software", "severity": "low", "confidence": 1.0}}, {"id": "scanner-bead75b0f9233e05", "name": "No API endpoints detected", "shortDescription": {"text": "No API endpoints detected"}, "fullDescription": {"text": "The scanner did not find FastAPI/Flask/Express/NestJS/GraphQL/gRPC routes. If this repo exposes APIs, the framework may be unsupported."}, "properties": {"scanner": "scanner-primary", "layer": "api", "severity": "info", "confidence": 1.0}}, {"id": "scanner-d63da3583b14afc0", "name": "Dockerfile runs as root: Dockerfile", "shortDescription": {"text": "Dockerfile runs as root: Dockerfile"}, "fullDescription": {"text": "No non-root USER set. Containers running as root expand the blast radius of any vulnerability inside the image."}, "properties": {"scanner": "scanner-primary", "layer": "hardware", "severity": "medium", "confidence": 1.0}}, {"id": "scanner-3643c99338a4ff7a", "name": "Docker base image is tag-pinned but not digest-pinned: python:3.9-slim", "shortDescription": {"text": "Docker base image is tag-pinned but not digest-pinned: python:3.9-slim"}, "fullDescription": {"text": "Container tags can be retagged upstream. Pin production base images to a reviewed digest (`image@sha256:...`) when reproducibility and supply-chain integrity matter."}, "properties": {"scanner": "scanner-primary", "layer": "hardware", "severity": "low", "confidence": 1.0}}, {"id": "scanner-6deccfc12283c7ba", "name": "Possible secret in import_clientes_standalone.py", "shortDescription": {"text": "Possible secret in import_clientes_standalone.py"}, "fullDescription": {"text": "Detected pattern matching password_literal. Rotate the credential and move to a secret manager."}, "properties": {"scanner": "scanner-primary", "layer": "security", "severity": "critical", "confidence": 1.0}}, {"id": "scanner-db18b7677f50c824", "name": "Possible secret in .env.backup.example", "shortDescription": {"text": "Possible secret in .env.backup.example"}, "fullDescription": {"text": "Detected pattern matching generic_api_key. Rotate the credential and move to a secret manager."}, "properties": {"scanner": "scanner-primary", "layer": "security", "severity": "critical", "confidence": 1.0}}, {"id": "scanner-0f211dac08ba0021", "name": "Insecure pattern 'exec_used' in fix_serviciobloqueo_completo.py:86", "shortDescription": {"text": "Insecure pattern 'exec_used' in fix_serviciobloqueo_completo.py:86"}, "fullDescription": {"text": "Found a known-risky pattern (exec_used). Review and replace if possible."}, "properties": {"scanner": "scanner-primary", "layer": "security", "severity": "high", "confidence": 1.0}}, {"id": "scanner-8852b23a8f5c9a71", "name": "Insecure pattern 'exec_used' in encontrar_error_admin.py:32", "shortDescription": {"text": "Insecure pattern 'exec_used' in encontrar_error_admin.py:32"}, "fullDescription": {"text": "Found a known-risky pattern (exec_used). Review and replace if possible."}, "properties": {"scanner": "scanner-primary", "layer": "security", "severity": "high", "confidence": 1.0}}, {"id": "scanner-6372cebde0220094", "name": "No auth library detected", "shortDescription": {"text": "No auth library detected"}, "fullDescription": {"text": "The scanner did not find any standard auth library (JWT, OAuth, NextAuth, Auth0, etc.). The repo has auth/admin/session surface indicators, so auth may live in custom code, in a separate service, or be missing."}, "properties": {"scanner": "scanner-primary", "layer": "security", "severity": "medium", "confidence": 1.0}}, {"id": "scanner-141b30a41e03817b", "name": "No license file detected", "shortDescription": {"text": "No license file detected"}, "fullDescription": {"text": "No LICENSE/COPYING/NOTICE file was found. Generated repositories often omit licensing, which blocks reuse and automated intake."}, "properties": {"scanner": "scanner-primary", "layer": "quality", "severity": "low", "confidence": 1.0}}, {"id": "scanner-3ab5d313dda8e5f9", "name": "Debug logging residue appears in source files", "shortDescription": {"text": "Debug logging residue appears in source files"}, "fullDescription": {"text": "Found 3984 console/debugger/print-style debug statements in non-test source. This is a common fast-generation residue before production cleanup."}, "properties": {"scanner": "scanner-primary", "layer": "quality", "severity": "low", "confidence": 1.0}}, {"id": "scanner-72b2a6250083a784", "name": "Placeholder or mock-heavy implementation detected", "shortDescription": {"text": "Placeholder or mock-heavy implementation detected"}, "fullDescription": {"text": "Found 24 placeholder/mock markers across 8 source files. This often means the repo looks complete while core flows still use generated scaffolding or fake data."}, "properties": {"scanner": "scanner-primary", "layer": "quality", "severity": "medium", "confidence": 1.0}}, {"id": "scanner-2d0c7b7ab8f8aacf", "name": "Critical user flow still appears backed by mock or placeholder data", "shortDescription": {"text": "Critical user flow still appears backed by mock or placeholder data"}, "fullDescription": {"text": "A payment/auth/admin/order/billing-style flow contains mock, fake, TODO, dummy, or placeholder markers in runtime source. In the Fable corpus this is a high-leverage completeness smell: the app can look finished while the money, identity, or tenant flow is still scaffolded."}, "properties": {"scanner": "scanner-primary", "layer": "quality", "severity": "medium", "confidence": 1.0}}, {"id": "scanner-b9088664ace7f748", "name": "Composite production-readiness gap", "shortDescription": {"text": "Composite production-readiness gap"}, "fullDescription": {"text": "Multiple low-cost hardening controls are missing together: license, ci. Opus verification showed these co-occurring gaps are a better readiness signal than reading each flag in isolation."}, "properties": {"scanner": "scanner-primary", "layer": "quality", "severity": "low", "confidence": 1.0}}, {"id": "scanner-749d4bc1bd66df5f", "name": "Agent instructions exist but release-hardening basics are missing", "shortDescription": {"text": "Agent instructions exist but release-hardening basics are missing"}, "fullDescription": {"text": "AI-coder instruction files were found, but the repo is missing license, ci. Treat this as a contract gap: the agent is guided, but the generated output is not yet guarded by the controls that make it repeatable."}, "properties": {"scanner": "scanner-primary", "layer": "quality", "severity": "medium", "confidence": 1.0}}, {"id": "scanner-17d866d91a7c451e", "name": "Agent instruction/config may expose a secret: CLAUDE.md", "shortDescription": {"text": "Agent instruction/config may expose a secret: CLAUDE.md"}, "fullDescription": {"text": "Agent-facing files are routinely pasted into LLM/tool contexts. Move literal tokens, keys, and passwords into a secret manager or document them as placeholders only."}, "properties": {"scanner": "scanner-primary", "layer": "security", "severity": "high", "confidence": 1.0}}, {"id": "scanner-a497c6bf8f0a73f8", "name": "Likely N+1 query: `for servicio in \u2026` triggers a query per row \u2014 fix_tipo_servicio.py:42", "shortDescription": {"text": "Likely N+1 query: `for servicio in \u2026` triggers a query per row \u2014 fix_tipo_servicio.py:42"}, "fullDescription": {"text": "The loop iterates a Django queryset and accesses `servicio.nombre.lower` per row, which fires an additional database query each iteration. Add `.select_related('<fk_field>')` for FK / O2O relations or `.prefetch_related('<m2m_or_reverse>')` for many-related lookups, to load everything in 1-2 queries instead of N."}, "properties": {"scanner": "scanner-primary", "layer": "quality", "severity": "medium", "confidence": 1.0}}, {"id": "scanner-20544642978de71b", "name": "Stub function `clean_minimo` (body is just `pass`/`return`) \u2014 fix_save_method_serviciobloqueo.py:40", "shortDescription": {"text": "Stub function `clean_minimo` (body is just `pass`/`return`) \u2014 fix_save_method_serviciobloqueo.py:40"}, "fullDescription": {"text": "Likely an AI scaffold that was never filled in. Remove or implement."}, "properties": {"scanner": "scanner-primary", "layer": "quality", "severity": "low", "confidence": 1.0}}, {"id": "scanner-ed7acbe103d696eb", "name": "Likely N+1 query: `for detalle in \u2026` triggers a query per row \u2014 fix_comanda_validacion_estricta.py:143", "shortDescription": {"text": "Likely N+1 query: `for detalle in \u2026` triggers a query per row \u2014 fix_comanda_validacion_estricta.py:143"}, "fullDescription": {"text": "The loop iterates a Django queryset and accesses `detalle.producto.nombre` per row, which fires an additional database query each iteration. Add `.select_related('<fk_field>')` for FK / O2O relations or `.prefetch_related('<m2m_or_reverse>')` for many-related lookups, to load everything in 1-2 queries instead of N."}, "properties": {"scanner": "scanner-primary", "layer": "quality", "severity": "medium", "confidence": 1.0}}, {"id": "scanner-d2c64932afe07fa8", "name": "Likely N+1 query: `for pago in \u2026` triggers a query per row \u2014 diagnostico_giftcards.py:65", "shortDescription": {"text": "Likely N+1 query: `for pago in \u2026` triggers a query per row \u2014 diagnostico_giftcards.py:65"}, "fullDescription": {"text": "The loop iterates a Django queryset and accesses `pago.giftcard.codigo` per row, which fires an additional database query each iteration. Add `.select_related('<fk_field>')` for FK / O2O relations or `.prefetch_related('<m2m_or_reverse>')` for many-related lookups, to load everything in 1-2 queries instead of N."}, "properties": {"scanner": "scanner-primary", "layer": "quality", "severity": "medium", "confidence": 1.0}}, {"id": "scanner-10bb13982b2b6b08", "name": "Likely N+1 query: `for detalle in \u2026` triggers a query per row \u2014 capturar_error_comanda.py:189", "shortDescription": {"text": "Likely N+1 query: `for detalle in \u2026` triggers a query per row \u2014 capturar_error_comanda.py:189"}, "fullDescription": {"text": "The loop iterates a Django queryset and accesses `detalle.producto.nombre` per row, which fires an additional database query each iteration. Add `.select_related('<fk_field>')` for FK / O2O relations or `.prefetch_related('<m2m_or_reverse>')` for many-related lookups, to load everything in 1-2 queries instead of N."}, "properties": {"scanner": "scanner-primary", "layer": "quality", "severity": "medium", "confidence": 1.0}}, {"id": "scanner-025143a84523088b", "name": "Likely N+1 query: `for rs in \u2026` triggers a query per row \u2014 diagnostico_gastos.py:57", "shortDescription": {"text": "Likely N+1 query: `for rs in \u2026` triggers a query per row \u2014 diagnostico_gastos.py:57"}, "fullDescription": {"text": "The loop iterates a Django queryset and accesses `rs.venta_reserva.fecha_reserva` per row, which fires an additional database query each iteration. Add `.select_related('<fk_field>')` for FK / O2O relations or `.prefetch_related('<m2m_or_reverse>')` for many-related lookups, to load everything in 1-2 queries instead of N."}, "properties": {"scanner": "scanner-primary", "layer": "quality", "severity": "medium", "confidence": 1.0}}, {"id": "scanner-fbcdbfbc7380fd85", "name": "Likely N+1 query: `for rs in \u2026` triggers a query per row \u2014 diagnostico_gastos.py:74", "shortDescription": {"text": "Likely N+1 query: `for rs in \u2026` triggers a query per row \u2014 diagnostico_gastos.py:74"}, "fullDescription": {"text": "The loop iterates a Django queryset and accesses `rs.venta_reserva.fecha_reserva` per row, which fires an additional database query each iteration. Add `.select_related('<fk_field>')` for FK / O2O relations or `.prefetch_related('<m2m_or_reverse>')` for many-related lookups, to load everything in 1-2 queries instead of N."}, "properties": {"scanner": "scanner-primary", "layer": "quality", "severity": "medium", "confidence": 1.0}}, {"id": "scanner-474f11ccd7146a01", "name": "Likely N+1 query: `for servicio in \u2026` triggers a query per row \u2014 diagnostico_servicios_web.py:38", "shortDescription": {"text": "Likely N+1 query: `for servicio in \u2026` triggers a query per row \u2014 diagnostico_servicios_web.py:38"}, "fullDescription": {"text": "The loop iterates a Django queryset and accesses `servicio.nombre.lower` per row, which fires an additional database query each iteration. Add `.select_related('<fk_field>')` for FK / O2O relations or `.prefetch_related('<m2m_or_reverse>')` for many-related lookups, to load everything in 1-2 queries instead of N."}, "properties": {"scanner": "scanner-primary", "layer": "quality", "severity": "medium", "confidence": 1.0}}, {"id": "scanner-ae3f01f6111c49b2", "name": "Likely N+1 query: `for cliente in \u2026` triggers a query per row \u2014 fix_all_duplicates.py:31", "shortDescription": {"text": "Likely N+1 query: `for cliente in \u2026` triggers a query per row \u2014 fix_all_duplicates.py:31"}, "fullDescription": {"text": "The loop iterates a Django queryset and accesses `cliente.telefono.replace` per row, which fires an additional database query each iteration. Add `.select_related('<fk_field>')` for FK / O2O relations or `.prefetch_related('<m2m_or_reverse>')` for many-related lookups, to load everything in 1-2 queries instead of N."}, "properties": {"scanner": "scanner-primary", "layer": "quality", "severity": "medium", "confidence": 1.0}}, {"id": "scanner-2132df42cf6029ea", "name": "Network/subprocess call without timeout or try/except \u2014 verificar_sendgrid.py:32", "shortDescription": {"text": "Network/subprocess call without timeout or try/except \u2014 verificar_sendgrid.py:32"}, "fullDescription": {"text": "`requests.get(...)` here lacks both a `timeout=` arg and an enclosing try/except. This is exactly the class of bug that took down our git-clone earlier (HTTP/2 stream cancel surfaced as a fatal). Add a `timeout=` and wrap in try/except, or use a wrapper that retries."}, "properties": {"scanner": "scanner-primary", "layer": "quality", "severity": "medium", "confidence": 1.0}}, {"id": "scanner-cbe0ad60b4fcb877", "name": "Likely N+1 query: `for cliente in \u2026` triggers a query per row \u2014 merge_historical_to_current.py:208", "shortDescription": {"text": "Likely N+1 query: `for cliente in \u2026` triggers a query per row \u2014 merge_historical_to_current.py:208"}, "fullDescription": {"text": "The loop iterates a Django queryset and accesses `cliente.telefono.replace` per row, which fires an additional database query each iteration. Add `.select_related('<fk_field>')` for FK / O2O relations or `.prefetch_related('<m2m_or_reverse>')` for many-related lookups, to load everything in 1-2 queries instead of N."}, "properties": {"scanner": "scanner-primary", "layer": "quality", "severity": "medium", "confidence": 1.0}}, {"id": "scanner-5eadd0730ad926f7", "name": "Likely N+1 query: `for srv in \u2026` triggers a query per row \u2014 check_agenda_status.py:41", "shortDescription": {"text": "Likely N+1 query: `for srv in \u2026` triggers a query per row \u2014 check_agenda_status.py:41"}, "fullDescription": {"text": "The loop iterates a Django queryset and accesses `srv.venta_reserva.estado_reserva` per row, which fires an additional database query each iteration. Add `.select_related('<fk_field>')` for FK / O2O relations or `.prefetch_related('<m2m_or_reverse>')` for many-related lookups, to load everything in 1-2 queries instead of N."}, "properties": {"scanner": "scanner-primary", "layer": "quality", "severity": "medium", "confidence": 1.0}}, {"id": "scanner-fafa6d6b9d1eb7c1", "name": "Likely N+1 query: `for srv in \u2026` triggers a query per row \u2014 check_agenda_status.py:59", "shortDescription": {"text": "Likely N+1 query: `for srv in \u2026` triggers a query per row \u2014 check_agenda_status.py:59"}, "fullDescription": {"text": "The loop iterates a Django queryset and accesses `srv.servicio.duracion` per row, which fires an additional database query each iteration. Add `.select_related('<fk_field>')` for FK / O2O relations or `.prefetch_related('<m2m_or_reverse>')` for many-related lookups, to load everything in 1-2 queries instead of N."}, "properties": {"scanner": "scanner-primary", "layer": "quality", "severity": "medium", "confidence": 1.0}}, {"id": "scanner-3adeef54535e70c0", "name": "Likely N+1 query: `for servicio in \u2026` triggers a query per row \u2014 diagnose_agenda.py:66", "shortDescription": {"text": "Likely N+1 query: `for servicio in \u2026` triggers a query per row \u2014 diagnose_agenda.py:66"}, "fullDescription": {"text": "The loop iterates a Django queryset and accesses `servicio.servicio.duracion` per row, which fires an additional database query each iteration. Add `.select_related('<fk_field>')` for FK / O2O relations or `.prefetch_related('<m2m_or_reverse>')` for many-related lookups, to load everything in 1-2 queries instead of N."}, "properties": {"scanner": "scanner-primary", "layer": "quality", "severity": "medium", "confidence": 1.0}}, {"id": "scanner-5bd6e879a7cafc18", "name": "Likely N+1 query: `for producto in \u2026` triggers a query per row \u2014 diagnose_agenda.py:118", "shortDescription": {"text": "Likely N+1 query: `for producto in \u2026` triggers a query per row \u2014 diagnose_agenda.py:118"}, "fullDescription": {"text": "The loop iterates a Django queryset and accesses `producto.producto.nombre` per row, which fires an additional database query each iteration. Add `.select_related('<fk_field>')` for FK / O2O relations or `.prefetch_related('<m2m_or_reverse>')` for many-related lookups, to load everything in 1-2 queries instead of N."}, "properties": {"scanner": "scanner-primary", "layer": "quality", "severity": "medium", "confidence": 1.0}}, {"id": "scanner-5cff007509325f18", "name": "Likely N+1 query: `for producto in \u2026` triggers a query per row \u2014 diagnose_agenda.py:155", "shortDescription": {"text": "Likely N+1 query: `for producto in \u2026` triggers a query per row \u2014 diagnose_agenda.py:155"}, "fullDescription": {"text": "The loop iterates a Django queryset and accesses `producto.producto.nombre` per row, which fires an additional database query each iteration. Add `.select_related('<fk_field>')` for FK / O2O relations or `.prefetch_related('<m2m_or_reverse>')` for many-related lookups, to load everything in 1-2 queries instead of N."}, "properties": {"scanner": "scanner-primary", "layer": "quality", "severity": "medium", "confidence": 1.0}}, {"id": "scanner-2b7af99d8327424a", "name": "Likely N+1 query: `for p in \u2026` triggers a query per row \u2014 diagnose_agenda.py:173", "shortDescription": {"text": "Likely N+1 query: `for p in \u2026` triggers a query per row \u2014 diagnose_agenda.py:173"}, "fullDescription": {"text": "The loop iterates a Django queryset and accesses `p.producto.nombre` per row, which fires an additional database query each iteration. Add `.select_related('<fk_field>')` for FK / O2O relations or `.prefetch_related('<m2m_or_reverse>')` for many-related lookups, to load everything in 1-2 queries instead of N."}, "properties": {"scanner": "scanner-primary", "layer": "quality", "severity": "medium", "confidence": 1.0}}, {"id": "scanner-62058c75e456cbf8", "name": "Likely N+1 query: `for srv in \u2026` triggers a query per row \u2014 diagnose_agenda.py:194", "shortDescription": {"text": "Likely N+1 query: `for srv in \u2026` triggers a query per row \u2014 diagnose_agenda.py:194"}, "fullDescription": {"text": "The loop iterates a Django queryset and accesses `srv.servicio.nombre` per row, which fires an additional database query each iteration. Add `.select_related('<fk_field>')` for FK / O2O relations or `.prefetch_related('<m2m_or_reverse>')` for many-related lookups, to load everything in 1-2 queries instead of N."}, "properties": {"scanner": "scanner-primary", "layer": "quality", "severity": "medium", "confidence": 1.0}}, {"id": "scanner-a890bb0eca321eb2", "name": "Likely N+1 query: `for instance in \u2026` triggers a query per row \u2014 revertir_admin_comanda.py:33", "shortDescription": {"text": "Likely N+1 query: `for instance in \u2026` triggers a query per row \u2014 revertir_admin_comanda.py:33"}, "fullDescription": {"text": "The loop iterates a Django queryset and accesses `instance.producto.cantidad_disponible` per row, which fires an additional database query each iteration. Add `.select_related('<fk_field>')` for FK / O2O relations or `.prefetch_related('<m2m_or_reverse>')` for many-related lookups, to load everything in 1-2 queries instead of N."}, "properties": {"scanner": "scanner-primary", "layer": "quality", "severity": "medium", "confidence": 1.0}}, {"id": "scanner-9475184d9d596e32", "name": "Likely N+1 query: `for detalle in \u2026` triggers a query per row \u2014 revertir_admin_comanda.py:72", "shortDescription": {"text": "Likely N+1 query: `for detalle in \u2026` triggers a query per row \u2014 revertir_admin_comanda.py:72"}, "fullDescription": {"text": "The loop iterates a Django queryset and accesses `detalle.producto.cantidad_disponible` per row, which fires an additional database query each iteration. Add `.select_related('<fk_field>')` for FK / O2O relations or `.prefetch_related('<m2m_or_reverse>')` for many-related lookups, to load everything in 1-2 queries instead of N."}, "properties": {"scanner": "scanner-primary", "layer": "quality", "severity": "medium", "confidence": 1.0}}, {"id": "scanner-4c4fbab5476aaff4", "name": "Likely N+1 query: `for r in \u2026` triggers a query per row \u2014 diagnosticar_comandas.py:60", "shortDescription": {"text": "Likely N+1 query: `for r in \u2026` triggers a query per row \u2014 diagnosticar_comandas.py:60"}, "fullDescription": {"text": "The loop iterates a Django queryset and accesses `r.cliente.nombre` per row, which fires an additional database query each iteration. Add `.select_related('<fk_field>')` for FK / O2O relations or `.prefetch_related('<m2m_or_reverse>')` for many-related lookups, to load everything in 1-2 queries instead of N."}, "properties": {"scanner": "scanner-primary", "layer": "quality", "severity": "medium", "confidence": 1.0}}, {"id": "scanner-2cf84c80b2b94b82", "name": "Likely N+1 query: `for c in \u2026` triggers a query per row \u2014 diagnosticar_comandas.py:74", "shortDescription": {"text": "Likely N+1 query: `for c in \u2026` triggers a query per row \u2014 diagnosticar_comandas.py:74"}, "fullDescription": {"text": "The loop iterates a Django queryset and accesses `c.detalles.count` per row, which fires an additional database query each iteration. Add `.select_related('<fk_field>')` for FK / O2O relations or `.prefetch_related('<m2m_or_reverse>')` for many-related lookups, to load everything in 1-2 queries instead of N."}, "properties": {"scanner": "scanner-primary", "layer": "quality", "severity": "medium", "confidence": 1.0}}, {"id": "scanner-7605aa7c6e151085", "name": "Legacy-named symbol `hacer_backup` in fix_serviciobloqueo_seguro.py:22", "shortDescription": {"text": "Legacy-named symbol `hacer_backup` in fix_serviciobloqueo_seguro.py:22"}, "fullDescription": {"text": "Names with suffixes like `_old`, `_v1`, `_deprecated` usually indicate replaced-but-not-removed code (typical AI-coder leftover). Confirm and delete, or rename if it's the active version."}, "properties": {"scanner": "scanner-primary", "layer": "quality", "severity": "low", "confidence": 1.0}}, {"id": "scanner-780efb965b0c2610", "name": "Likely N+1 query: `for cliente in \u2026` triggers a query per row \u2014 analyze_remaining_duplicates.py:29", "shortDescription": {"text": "Likely N+1 query: `for cliente in \u2026` triggers a query per row \u2014 analyze_remaining_duplicates.py:29"}, "fullDescription": {"text": "The loop iterates a Django queryset and accesses `cliente.telefono.replace` per row, which fires an additional database query each iteration. Add `.select_related('<fk_field>')` for FK / O2O relations or `.prefetch_related('<m2m_or_reverse>')` for many-related lookups, to load everything in 1-2 queries instead of N."}, "properties": {"scanner": "scanner-primary", "layer": "quality", "severity": "medium", "confidence": 1.0}}, {"id": "scanner-319e66a630e14977", "name": "2 env vars used in code but missing from .env.example", "shortDescription": {"text": "2 env vars used in code but missing from .env.example"}, "fullDescription": {"text": "Drift between code and config docs. The first few: `AREMKO_DATABASE_URL`, `SENDGRID_API_KEY`. Add them (with a placeholder/comment) to .env.example so onboarding doesn't break."}, "properties": {"scanner": "scanner-primary", "layer": "quality", "severity": "info", "confidence": 1.0}}, {"id": "scanner-2c04133e54348533", "name": "Near-duplicate function bodies in 2 places", "shortDescription": {"text": "Near-duplicate function bodies in 2 places"}, "fullDescription": {"text": "Functions with the same first-5-line body hash:\ntest_phone_simple.py:test_phone_normalization, test_phone_normalization.py:test_phone_normalization\n\nThis is *the* AI-coder failure mode (4\u00d7 more duplication in vibe-coded repos \u2014 see https://jw.hn/ai-code-hygiene). Consolidate or document why they're separate."}, "properties": {"scanner": "scanner-primary", "layer": "quality", "severity": "low", "confidence": 1.0}}, {"id": "scanner-be46ea126aa5d8dc", "name": "Near-duplicate function bodies in 3 places", "shortDescription": {"text": "Near-duplicate function bodies in 3 places"}, "fullDescription": {"text": "Functions with the same first-5-line body hash:\naplicar_migracion_0071.py:packages_distributions, marcar_servicios_pagados.py:packages_distributions, manage.py:packages_distributions\n\nThis is *the* AI-coder failure mode (4\u00d7 more duplication in vibe-coded repos \u2014 see https://jw.hn/ai-code-hygiene). Consolidate or document why they're separate."}, "properties": {"scanner": "scanner-primary", "layer": "quality", "severity": "low", "confidence": 1.0}}]}}, "automationDetails": {"id": "repobility/28295"}, "properties": {"repository": "nomad3/booking-system-aremko", "repoUrl": "https://github.com/nomad3/booking-system-aremko", "branch": "main"}, "results": [{"ruleId": "scanner-da0f8b31eb69bdd7", "level": "note", "message": {"text": "Possibly dead Python function: emit"}, "properties": {"repobilityId": "fecc700ec874b669", "scanner": "scanner-primary", "fingerprint": "da0f8b31eb69bdd7", "layer": "software", "severity": "low", "confidence": 1.0, "tags": ["dead-code"]}, "locations": [{"physicalLocation": {"artifactLocation": {"uri": "capturar_error_comanda.py:34"}, "region": {"startLine": 1}}}]}, {"ruleId": "scanner-916f076f45e5ee58", "level": "note", "message": {"text": "Possibly dead Python function: listar_migraciones_pendientes"}, "properties": {"repobilityId": "4018256c9414738e", "scanner": "scanner-primary", "fingerprint": "916f076f45e5ee58", "layer": "software", "severity": "low", "confidence": 1.0, "tags": ["dead-code"]}, "locations": [{"physicalLocation": {"artifactLocation": {"uri": "migrar_sin_validacion.py:28"}, "region": {"startLine": 1}}}]}, {"ruleId": "scanner-41ac366ff3a1a3b0", "level": "note", "message": {"text": "Possibly dead Python function: normalize_historical_phones"}, "properties": {"repobilityId": "e9da4d26f667e2c8", "scanner": "scanner-primary", "fingerprint": "41ac366ff3a1a3b0", "layer": "software", "severity": "low", "confidence": 1.0, "tags": ["dead-code"]}, "locations": [{"physicalLocation": {"artifactLocation": {"uri": "merge_historical_to_current.py:191"}, "region": {"startLine": 1}}}]}, {"ruleId": "scanner-9d6879d36b5d056d", "level": "note", "message": {"text": "File has no detected symbols: enable_debug_temp.py"}, "properties": {"repobilityId": "4fc968b8e10d4b44", "scanner": "scanner-primary", "fingerprint": "9d6879d36b5d056d", "layer": "software", "severity": "low", "confidence": 1.0, "tags": ["dead-code-candidate"]}}, {"ruleId": "scanner-bead75b0f9233e05", "level": "none", "message": {"text": "No API endpoints detected"}, "properties": {"repobilityId": "0f8bb852027c38f8", "scanner": "scanner-primary", "fingerprint": "bead75b0f9233e05", "layer": "api", "severity": "info", "confidence": 1.0, "tags": ["coverage"]}}, {"ruleId": "scanner-d63da3583b14afc0", "level": "warning", "message": {"text": "Dockerfile runs as root: Dockerfile"}, "properties": {"repobilityId": "a2ed1bd120e507db", "scanner": "scanner-primary", "fingerprint": "d63da3583b14afc0", "layer": "hardware", "severity": "medium", "confidence": 1.0, "tags": ["security", "container"]}}, {"ruleId": "scanner-3643c99338a4ff7a", "level": "note", "message": {"text": "Docker base image is tag-pinned but not digest-pinned: python:3.9-slim"}, "properties": {"repobilityId": "77594a75071e510e", "scanner": "scanner-primary", "fingerprint": "3643c99338a4ff7a", "layer": "hardware", "severity": "low", "confidence": 1.0, "tags": ["supply-chain", "docker", "pinned-dependencies"]}, "locations": [{"physicalLocation": {"artifactLocation": {"uri": "Dockerfile"}, "region": {"startLine": 2}}}]}, {"ruleId": "scanner-6deccfc12283c7ba", "level": "error", "message": {"text": "Possible secret in import_clientes_standalone.py"}, "properties": {"repobilityId": "a60fbedc9634f7bb", "scanner": "scanner-primary", "fingerprint": "6deccfc12283c7ba", "layer": "security", "severity": "critical", "confidence": 1.0, "tags": ["secrets"]}, "locations": [{"physicalLocation": {"artifactLocation": {"uri": "import_clientes_standalone.py"}, "region": {"startLine": 67}}}]}, {"ruleId": "scanner-db18b7677f50c824", "level": "error", "message": {"text": "Possible secret in .env.backup.example"}, "properties": {"repobilityId": "0c3d11e38a65a334", "scanner": "scanner-primary", "fingerprint": "db18b7677f50c824", "layer": "security", "severity": "critical", "confidence": 1.0, "tags": ["secrets"]}, "locations": [{"physicalLocation": {"artifactLocation": {"uri": ".env.backup.example"}, "region": {"startLine": 38}}}]}, {"ruleId": "scanner-0f211dac08ba0021", "level": "error", "message": {"text": "Insecure pattern 'exec_used' in fix_serviciobloqueo_completo.py:86"}, "properties": {"repobilityId": "31912ada47b755d9", "scanner": "scanner-primary", "fingerprint": "0f211dac08ba0021", "layer": "security", "severity": "high", "confidence": 1.0, "tags": ["owasp", "exec_used"]}, "locations": [{"physicalLocation": {"artifactLocation": {"uri": "fix_serviciobloqueo_completo.py"}, "region": {"startLine": 86}}}]}, {"ruleId": "scanner-8852b23a8f5c9a71", "level": "error", "message": {"text": "Insecure pattern 'exec_used' in encontrar_error_admin.py:32"}, "properties": {"repobilityId": "fdae2660acf81eba", "scanner": "scanner-primary", "fingerprint": "8852b23a8f5c9a71", "layer": "security", "severity": "high", "confidence": 1.0, "tags": ["owasp", "exec_used"]}, "locations": [{"physicalLocation": {"artifactLocation": {"uri": "encontrar_error_admin.py"}, "region": {"startLine": 32}}}]}, {"ruleId": "scanner-6372cebde0220094", "level": "warning", "message": {"text": "No auth library detected"}, "properties": {"repobilityId": "a5b6035a5bbf8054", "scanner": "scanner-primary", "fingerprint": "6372cebde0220094", "layer": "security", "severity": "medium", "confidence": 1.0, "tags": ["coverage", "auth"]}}, {"ruleId": "scanner-141b30a41e03817b", "level": "note", "message": {"text": "No license file detected"}, "properties": {"repobilityId": "b794777d190f91bd", "scanner": "scanner-primary", "fingerprint": "141b30a41e03817b", "layer": "quality", "severity": "low", "confidence": 1.0, "tags": ["license", "repo-hardening", "generated-repo-pattern"]}}, {"ruleId": "scanner-3ab5d313dda8e5f9", "level": "note", "message": {"text": "Debug logging residue appears in source files"}, "properties": {"repobilityId": "5956317b95d43b72", "scanner": "scanner-primary", "fingerprint": "3ab5d313dda8e5f9", "layer": "quality", "severity": "low", "confidence": 1.0, "tags": ["debug", "cleanup", "repo-hardening", "generated-repo-pattern"]}}, {"ruleId": "scanner-72b2a6250083a784", "level": "warning", "message": {"text": "Placeholder or mock-heavy implementation detected"}, "properties": {"repobilityId": "e2a36676c5ab8bd4", "scanner": "scanner-primary", "fingerprint": "72b2a6250083a784", "layer": "quality", "severity": "medium", "confidence": 1.0, "tags": ["placeholder", "mock-data", "incomplete", "generated-repo-pattern"]}}, {"ruleId": "scanner-2d0c7b7ab8f8aacf", "level": "warning", "message": {"text": "Critical user flow still appears backed by mock or placeholder data"}, "properties": {"repobilityId": "9341070960ba7795", "scanner": "scanner-primary", "fingerprint": "2d0c7b7ab8f8aacf", "layer": "quality", "severity": "medium", "confidence": 1.0, "tags": ["placeholder", "mock-data", "critical-flow", "generated-repo-pattern"]}}, {"ruleId": "scanner-b9088664ace7f748", "level": "note", "message": {"text": "Composite production-readiness gap"}, "properties": {"repobilityId": "ae5c3dee9be02b26", "scanner": "scanner-primary", "fingerprint": "b9088664ace7f748", "layer": "quality", "severity": "low", "confidence": 1.0, "tags": ["production-readiness", "repo-hardening", "generated-repo-pattern"]}}, {"ruleId": "scanner-749d4bc1bd66df5f", "level": "warning", "message": {"text": "Agent instructions exist but release-hardening basics are missing"}, "properties": {"repobilityId": "a27bccfe6073b145", "scanner": "scanner-primary", "fingerprint": "749d4bc1bd66df5f", "layer": "quality", "severity": "medium", "confidence": 1.0, "tags": ["agent-instructions", "repo-hardening", "generated-repo-pattern"]}}, {"ruleId": "scanner-17d866d91a7c451e", "level": "error", "message": {"text": "Agent instruction/config may expose a secret: CLAUDE.md"}, "properties": {"repobilityId": "ccce5984e58a48f0", "scanner": "scanner-primary", "fingerprint": "17d866d91a7c451e", "layer": "security", "severity": "high", "confidence": 1.0, "tags": ["agent-instructions", "secrets", "claude_instruction"]}, "locations": [{"physicalLocation": {"artifactLocation": {"uri": "CLAUDE.md"}, "region": {"startLine": 193}}}]}, {"ruleId": "scanner-a497c6bf8f0a73f8", "level": "warning", "message": {"text": "Likely N+1 query: `for servicio in \u2026` triggers a query per row \u2014 fix_tipo_servicio.py:42"}, "properties": {"repobilityId": "0f69a24a39b3f8f2", "scanner": "scanner-primary", "fingerprint": "a497c6bf8f0a73f8", "layer": "quality", "severity": "medium", "confidence": 1.0, "tags": ["integrity", "n-plus-one", "performance"]}, "locations": [{"physicalLocation": {"artifactLocation": {"uri": "fix_tipo_servicio.py"}, "region": {"startLine": 42}}}]}, {"ruleId": "scanner-20544642978de71b", "level": "note", "message": {"text": "Stub function `clean_minimo` (body is just `pass`/`return`) \u2014 fix_save_method_serviciobloqueo.py:40"}, "properties": {"repobilityId": "a439e0f47d8df84a", "scanner": "scanner-primary", "fingerprint": "20544642978de71b", "layer": "quality", "severity": "low", "confidence": 1.0, "tags": ["integrity", "empty-handler", "dead-code"]}}, {"ruleId": "scanner-ed7acbe103d696eb", "level": "warning", "message": {"text": "Likely N+1 query: `for detalle in \u2026` triggers a query per row \u2014 fix_comanda_validacion_estricta.py:143"}, "properties": {"repobilityId": "7c5e323d68e36173", "scanner": "scanner-primary", "fingerprint": "ed7acbe103d696eb", "layer": "quality", "severity": "medium", "confidence": 1.0, "tags": ["integrity", "n-plus-one", "performance"]}, "locations": [{"physicalLocation": {"artifactLocation": {"uri": "fix_comanda_validacion_estricta.py"}, "region": {"startLine": 143}}}]}, {"ruleId": "scanner-d2c64932afe07fa8", "level": "warning", "message": {"text": "Likely N+1 query: `for pago in \u2026` triggers a query per row \u2014 diagnostico_giftcards.py:65"}, "properties": {"repobilityId": "2e3abe6ed0120ed3", "scanner": "scanner-primary", "fingerprint": "d2c64932afe07fa8", "layer": "quality", "severity": "medium", "confidence": 1.0, "tags": ["integrity", "n-plus-one", "performance"]}, "locations": [{"physicalLocation": {"artifactLocation": {"uri": "diagnostico_giftcards.py"}, "region": {"startLine": 65}}}]}, {"ruleId": "scanner-10bb13982b2b6b08", "level": "warning", "message": {"text": "Likely N+1 query: `for detalle in \u2026` triggers a query per row \u2014 capturar_error_comanda.py:189"}, "properties": {"repobilityId": "63656affd4ebb45e", "scanner": "scanner-primary", "fingerprint": "10bb13982b2b6b08", "layer": "quality", "severity": "medium", "confidence": 1.0, "tags": ["integrity", "n-plus-one", "performance"]}, "locations": [{"physicalLocation": {"artifactLocation": {"uri": "capturar_error_comanda.py"}, "region": {"startLine": 189}}}]}, {"ruleId": "scanner-025143a84523088b", "level": "warning", "message": {"text": "Likely N+1 query: `for rs in \u2026` triggers a query per row \u2014 diagnostico_gastos.py:57"}, "properties": {"repobilityId": "051d581f842a3874", "scanner": "scanner-primary", "fingerprint": "025143a84523088b", "layer": "quality", "severity": "medium", "confidence": 1.0, "tags": ["integrity", "n-plus-one", "performance"]}, "locations": [{"physicalLocation": {"artifactLocation": {"uri": "diagnostico_gastos.py"}, "region": {"startLine": 57}}}]}, {"ruleId": "scanner-fbcdbfbc7380fd85", "level": "warning", "message": {"text": "Likely N+1 query: `for rs in \u2026` triggers a query per row \u2014 diagnostico_gastos.py:74"}, "properties": {"repobilityId": "c17be5087f34a8a5", "scanner": "scanner-primary", "fingerprint": "fbcdbfbc7380fd85", "layer": "quality", "severity": "medium", "confidence": 1.0, "tags": ["integrity", "n-plus-one", "performance"]}, "locations": [{"physicalLocation": {"artifactLocation": {"uri": "diagnostico_gastos.py"}, "region": {"startLine": 74}}}]}, {"ruleId": "scanner-474f11ccd7146a01", "level": "warning", "message": {"text": "Likely N+1 query: `for servicio in \u2026` triggers a query per row \u2014 diagnostico_servicios_web.py:38"}, "properties": {"repobilityId": "ba2f050ec215eaee", "scanner": "scanner-primary", "fingerprint": "474f11ccd7146a01", "layer": "quality", "severity": "medium", "confidence": 1.0, "tags": ["integrity", "n-plus-one", "performance"]}, "locations": [{"physicalLocation": {"artifactLocation": {"uri": "diagnostico_servicios_web.py"}, "region": {"startLine": 38}}}]}, {"ruleId": "scanner-ae3f01f6111c49b2", "level": "warning", "message": {"text": "Likely N+1 query: `for cliente in \u2026` triggers a query per row \u2014 fix_all_duplicates.py:31"}, "properties": {"repobilityId": "0e1f8670f7d6af63", "scanner": "scanner-primary", "fingerprint": "ae3f01f6111c49b2", "layer": "quality", "severity": "medium", "confidence": 1.0, "tags": ["integrity", "n-plus-one", "performance"]}, "locations": [{"physicalLocation": {"artifactLocation": {"uri": "fix_all_duplicates.py"}, "region": {"startLine": 31}}}]}, {"ruleId": "scanner-2132df42cf6029ea", "level": "warning", "message": {"text": "Network/subprocess call without timeout or try/except \u2014 verificar_sendgrid.py:32"}, "properties": {"repobilityId": "066c6ad475b29110", "scanner": "scanner-primary", "fingerprint": "2132df42cf6029ea", "layer": "quality", "severity": "medium", "confidence": 1.0, "tags": ["integrity", "fragile-runtime", "robustness"]}}, {"ruleId": "scanner-cbe0ad60b4fcb877", "level": "warning", "message": {"text": "Likely N+1 query: `for cliente in \u2026` triggers a query per row \u2014 merge_historical_to_current.py:208"}, "properties": {"repobilityId": "28f3f2af926acde0", "scanner": "scanner-primary", "fingerprint": "cbe0ad60b4fcb877", "layer": "quality", "severity": "medium", "confidence": 1.0, "tags": ["integrity", "n-plus-one", "performance"]}, "locations": [{"physicalLocation": {"artifactLocation": {"uri": "merge_historical_to_current.py"}, "region": {"startLine": 208}}}]}, {"ruleId": "scanner-5eadd0730ad926f7", "level": "warning", "message": {"text": "Likely N+1 query: `for srv in \u2026` triggers a query per row \u2014 check_agenda_status.py:41"}, "properties": {"repobilityId": "2e0c8da3f25bbd04", "scanner": "scanner-primary", "fingerprint": "5eadd0730ad926f7", "layer": "quality", "severity": "medium", "confidence": 1.0, "tags": ["integrity", "n-plus-one", "performance"]}, "locations": [{"physicalLocation": {"artifactLocation": {"uri": "check_agenda_status.py"}, "region": {"startLine": 41}}}]}, {"ruleId": "scanner-fafa6d6b9d1eb7c1", "level": "warning", "message": {"text": "Likely N+1 query: `for srv in \u2026` triggers a query per row \u2014 check_agenda_status.py:59"}, "properties": {"repobilityId": "e104d71f638477d0", "scanner": "scanner-primary", "fingerprint": "fafa6d6b9d1eb7c1", "layer": "quality", "severity": "medium", "confidence": 1.0, "tags": ["integrity", "n-plus-one", "performance"]}, "locations": [{"physicalLocation": {"artifactLocation": {"uri": "check_agenda_status.py"}, "region": {"startLine": 59}}}]}, {"ruleId": "scanner-3adeef54535e70c0", "level": "warning", "message": {"text": "Likely N+1 query: `for servicio in \u2026` triggers a query per row \u2014 diagnose_agenda.py:66"}, "properties": {"repobilityId": "a6e95ab426d3dd0c", "scanner": "scanner-primary", "fingerprint": "3adeef54535e70c0", "layer": "quality", "severity": "medium", "confidence": 1.0, "tags": ["integrity", "n-plus-one", "performance"]}, "locations": [{"physicalLocation": {"artifactLocation": {"uri": "diagnose_agenda.py"}, "region": {"startLine": 66}}}]}, {"ruleId": "scanner-5bd6e879a7cafc18", "level": "warning", "message": {"text": "Likely N+1 query: `for producto in \u2026` triggers a query per row \u2014 diagnose_agenda.py:118"}, "properties": {"repobilityId": "6da7b6f452395670", "scanner": "scanner-primary", "fingerprint": "5bd6e879a7cafc18", "layer": "quality", "severity": "medium", "confidence": 1.0, "tags": ["integrity", "n-plus-one", "performance"]}, "locations": [{"physicalLocation": {"artifactLocation": {"uri": "diagnose_agenda.py"}, "region": {"startLine": 118}}}]}, {"ruleId": "scanner-5cff007509325f18", "level": "warning", "message": {"text": "Likely N+1 query: `for producto in \u2026` triggers a query per row \u2014 diagnose_agenda.py:155"}, "properties": {"repobilityId": "c329e04eae290d04", "scanner": "scanner-primary", "fingerprint": "5cff007509325f18", "layer": "quality", "severity": "medium", "confidence": 1.0, "tags": ["integrity", "n-plus-one", "performance"]}, "locations": [{"physicalLocation": {"artifactLocation": {"uri": "diagnose_agenda.py"}, "region": {"startLine": 155}}}]}, {"ruleId": "scanner-2b7af99d8327424a", "level": "warning", "message": {"text": "Likely N+1 query: `for p in \u2026` triggers a query per row \u2014 diagnose_agenda.py:173"}, "properties": {"repobilityId": "5740bbf5d5ce92aa", "scanner": "scanner-primary", "fingerprint": "2b7af99d8327424a", "layer": "quality", "severity": "medium", "confidence": 1.0, "tags": ["integrity", "n-plus-one", "performance"]}, "locations": [{"physicalLocation": {"artifactLocation": {"uri": "diagnose_agenda.py"}, "region": {"startLine": 173}}}]}, {"ruleId": "scanner-62058c75e456cbf8", "level": "warning", "message": {"text": "Likely N+1 query: `for srv in \u2026` triggers a query per row \u2014 diagnose_agenda.py:194"}, "properties": {"repobilityId": "2650ef673ed34ee2", "scanner": "scanner-primary", "fingerprint": "62058c75e456cbf8", "layer": "quality", "severity": "medium", "confidence": 1.0, "tags": ["integrity", "n-plus-one", "performance"]}, "locations": [{"physicalLocation": {"artifactLocation": {"uri": "diagnose_agenda.py"}, "region": {"startLine": 194}}}]}, {"ruleId": "scanner-a890bb0eca321eb2", "level": "warning", "message": {"text": "Likely N+1 query: `for instance in \u2026` triggers a query per row \u2014 revertir_admin_comanda.py:33"}, "properties": {"repobilityId": "3b4b08e0b52339d7", "scanner": "scanner-primary", "fingerprint": "a890bb0eca321eb2", "layer": "quality", "severity": "medium", "confidence": 1.0, "tags": ["integrity", "n-plus-one", "performance"]}, "locations": [{"physicalLocation": {"artifactLocation": {"uri": "revertir_admin_comanda.py"}, "region": {"startLine": 33}}}]}, {"ruleId": "scanner-9475184d9d596e32", "level": "warning", "message": {"text": "Likely N+1 query: `for detalle in \u2026` triggers a query per row \u2014 revertir_admin_comanda.py:72"}, "properties": {"repobilityId": "fbc1a1f7b5226724", "scanner": "scanner-primary", "fingerprint": "9475184d9d596e32", "layer": "quality", "severity": "medium", "confidence": 1.0, "tags": ["integrity", "n-plus-one", "performance"]}, "locations": [{"physicalLocation": {"artifactLocation": {"uri": "revertir_admin_comanda.py"}, "region": {"startLine": 72}}}]}, {"ruleId": "scanner-4c4fbab5476aaff4", "level": "warning", "message": {"text": "Likely N+1 query: `for r in \u2026` triggers a query per row \u2014 diagnosticar_comandas.py:60"}, "properties": {"repobilityId": "395e7ba07164e1a9", "scanner": "scanner-primary", "fingerprint": "4c4fbab5476aaff4", "layer": "quality", "severity": "medium", "confidence": 1.0, "tags": ["integrity", "n-plus-one", "performance"]}, "locations": [{"physicalLocation": {"artifactLocation": {"uri": "diagnosticar_comandas.py"}, "region": {"startLine": 60}}}]}, {"ruleId": "scanner-2cf84c80b2b94b82", "level": "warning", "message": {"text": "Likely N+1 query: `for c in \u2026` triggers a query per row \u2014 diagnosticar_comandas.py:74"}, "properties": {"repobilityId": "4d48fbb9bd21ac5f", "scanner": "scanner-primary", "fingerprint": "2cf84c80b2b94b82", "layer": "quality", "severity": "medium", "confidence": 1.0, "tags": ["integrity", "n-plus-one", "performance"]}, "locations": [{"physicalLocation": {"artifactLocation": {"uri": "diagnosticar_comandas.py"}, "region": {"startLine": 74}}}]}, {"ruleId": "scanner-7605aa7c6e151085", "level": "note", "message": {"text": "Legacy-named symbol `hacer_backup` in fix_serviciobloqueo_seguro.py:22"}, "properties": {"repobilityId": "c1a95c4103e12c02", "scanner": "scanner-primary", "fingerprint": "7605aa7c6e151085", "layer": "quality", "severity": "low", "confidence": 1.0, "tags": ["integrity", "legacy-marker", "dead-code"]}}, {"ruleId": "scanner-780efb965b0c2610", "level": "warning", "message": {"text": "Likely N+1 query: `for cliente in \u2026` triggers a query per row \u2014 analyze_remaining_duplicates.py:29"}, "properties": {"repobilityId": "22240dbd3e3a85f0", "scanner": "scanner-primary", "fingerprint": "780efb965b0c2610", "layer": "quality", "severity": "medium", "confidence": 1.0, "tags": ["integrity", "n-plus-one", "performance"]}, "locations": [{"physicalLocation": {"artifactLocation": {"uri": "analyze_remaining_duplicates.py"}, "region": {"startLine": 29}}}]}, {"ruleId": "scanner-319e66a630e14977", "level": "none", "message": {"text": "2 env vars used in code but missing from .env.example"}, "properties": {"repobilityId": "d838d1fc5d8231c9", "scanner": "scanner-primary", "fingerprint": "319e66a630e14977", "layer": "quality", "severity": "info", "confidence": 1.0, "tags": ["integrity", "config-drift"]}}, {"ruleId": "scanner-2c04133e54348533", "level": "note", "message": {"text": "Near-duplicate function bodies in 2 places"}, "properties": {"repobilityId": "c2a8758fab5318d6", "scanner": "scanner-primary", "fingerprint": "2c04133e54348533", "layer": "quality", "severity": "low", "confidence": 1.0, "tags": ["integrity", "duplicate", "dry"]}}, {"ruleId": "scanner-2c04133e54348533", "level": "note", "message": {"text": "Near-duplicate function bodies in 2 places"}, "properties": {"repobilityId": "535dce8611140604", "scanner": "scanner-primary", "fingerprint": "2c04133e54348533", "layer": "quality", "severity": "low", "confidence": 1.0, "tags": ["integrity", "duplicate", "dry"]}}, {"ruleId": "scanner-2c04133e54348533", "level": "note", "message": {"text": "Near-duplicate function bodies in 2 places"}, "properties": {"repobilityId": "b39dc10ec8086452", "scanner": "scanner-primary", "fingerprint": "2c04133e54348533", "layer": "quality", "severity": "low", "confidence": 1.0, "tags": ["integrity", "duplicate", "dry"]}}, {"ruleId": "scanner-be46ea126aa5d8dc", "level": "note", "message": {"text": "Near-duplicate function bodies in 3 places"}, "properties": {"repobilityId": "9478db9ab623aab8", "scanner": "scanner-primary", "fingerprint": "be46ea126aa5d8dc", "layer": "quality", "severity": "low", "confidence": 1.0, "tags": ["integrity", "duplicate", "dry"]}}]}]}