{"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-9f5c678eba205901", "name": "Possibly dead Python function: replacer", "shortDescription": {"text": "Possibly dead Python function: replacer"}, "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-cb5dfebabcf93c61", "name": "Possibly dead Python function: dedupe_titulos", "shortDescription": {"text": "Possibly dead Python function: dedupe_titulos"}, "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-26bf12d60a7d85e3", "name": "Possibly dead Python function: sincronizar_e_gerar_pdfs", "shortDescription": {"text": "Possibly dead Python function: sincronizar_e_gerar_pdfs"}, "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-7320ec72626280b1", "name": "Possibly dead Python function: gerar_kits_automaticos", "shortDescription": {"text": "Possibly dead Python function: gerar_kits_automaticos"}, "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-1e54b484cd918224", "name": "Possibly dead Python function: exportar_shopee", "shortDescription": {"text": "Possibly dead Python function: exportar_shopee"}, "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-78686303828f58b6", "name": "Possibly dead Python function: exportar_amazon", "shortDescription": {"text": "Possibly dead Python function: exportar_amazon"}, "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-d6bdae6d04ea44e9", "name": "Possibly dead Python function: buscar_topico", "shortDescription": {"text": "Possibly dead Python function: buscar_topico"}, "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-d88c72d4cde45353", "name": "Possibly dead Python function: importar_anuncio_externo", "shortDescription": {"text": "Possibly dead Python function: importar_anuncio_externo"}, "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-2d38876031779137", "name": "Possibly dead Python function: contar_anuncios_filtrado", "shortDescription": {"text": "Possibly dead Python function: contar_anuncios_filtrado"}, "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-2807fce9f1268020", "name": "Possibly dead Python function: listar_temas_caca_palavras_existentes", "shortDescription": {"text": "Possibly dead Python function: listar_temas_caca_palavras_existentes"}, "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-5ddab5d071984e0a", "name": "Possibly dead Python function: listar_apostilas_caca_palavras_por_dificuldade", "shortDescription": {"text": "Possibly dead Python function: listar_apostilas_caca_palavras_por_dificuldade"}, "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-e6323d4c1b9bd32c", "name": "Possibly dead Python function: buscar_topico_por_id", "shortDescription": {"text": "Possibly dead Python function: buscar_topico_por_id"}, "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-4e5dcb6ebfbbb28d", "name": "Possibly dead Python function: salvar_shopee_tokens", "shortDescription": {"text": "Possibly dead Python function: salvar_shopee_tokens"}, "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-6fa24f2bbbf95bc0", "name": "Possibly dead Python function: buscar_shopee_tokens", "shortDescription": {"text": "Possibly dead Python function: buscar_shopee_tokens"}, "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-c60b97ab9c535a27", "name": "Possibly dead Python function: deletar_anuncios_por_apostila", "shortDescription": {"text": "Possibly dead Python function: deletar_anuncios_por_apostila"}, "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-ab47488c750990bb", "name": "Possibly dead Python function: deletar_apostila", "shortDescription": {"text": "Possibly dead Python function: deletar_apostila"}, "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-11a547cc6e42db34", "name": "Possibly dead Python function: deletar_anuncios_por_kit", "shortDescription": {"text": "Possibly dead Python function: deletar_anuncios_por_kit"}, "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-0d815f949b93aab8", "name": "Possibly dead Python function: fix_precos_kits_db", "shortDescription": {"text": "Possibly dead Python function: fix_precos_kits_db"}, "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-b8bbfe3628d2f505", "name": "Possibly dead Python function: deletar_kit", "shortDescription": {"text": "Possibly dead Python function: deletar_kit"}, "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-aaff802c7d63c777", "name": "Possibly dead Python function: listar_vendas", "shortDescription": {"text": "Possibly dead Python function: listar_vendas"}, "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-60c040b3fb87f514", "name": "Possibly dead Python function: resumo_vendas_por_apostila", "shortDescription": {"text": "Possibly dead Python function: resumo_vendas_por_apostila"}, "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-b86ec06821af0941", "name": "Possibly dead Python function: listar_todas_apostilas", "shortDescription": {"text": "Possibly dead Python function: listar_todas_apostilas"}, "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-48df5e7f3ea8962d", "name": "Possibly dead Python function: criar_produto", "shortDescription": {"text": "Possibly dead Python function: criar_produto"}, "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-992a942f7fb18f25", "name": "Possibly dead Python function: criar_produto_caca_palavras", "shortDescription": {"text": "Possibly dead Python function: criar_produto_caca_palavras"}, "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-d0884f6d17f08800", "name": "Possibly dead Python function: listar_produtos_com_apostilas", "shortDescription": {"text": "Possibly dead Python function: listar_produtos_com_apostilas"}, "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-85b13e4447851f48", "name": "Possibly dead Python function: listar_apostilas_por_produto", "shortDescription": {"text": "Possibly dead Python function: listar_apostilas_por_produto"}, "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-b795e3fbeec450ce", "name": "Possibly dead Python function: deletar_produto", "shortDescription": {"text": "Possibly dead Python function: deletar_produto"}, "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-d4bf2e8eb28e3b92", "name": "Possibly dead Python function: upload", "shortDescription": {"text": "Possibly dead Python function: upload"}, "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-b6dfa51e38f3a9d2", "name": "Possibly dead Python function: upload_video", "shortDescription": {"text": "Possibly dead Python function: upload_video"}, "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-450d4c7e80f9f584", "name": "Possibly dead Python function: is_url", "shortDescription": {"text": "Possibly dead Python function: is_url"}, "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-93514f6b7916a94f", "name": "Insecure pattern 'cors_wildcard' in api.py:51", "shortDescription": {"text": "Insecure pattern 'cors_wildcard' in api.py:51"}, "fullDescription": {"text": "Found a known-risky pattern (cors_wildcard). Review and replace if possible."}, "properties": {"scanner": "scanner-primary", "layer": "security", "severity": "medium", "confidence": 1.0}}, {"id": "scanner-4601e3ad3bb28677", "name": "No CI/CD pipelines detected", "shortDescription": {"text": "No CI/CD pipelines detected"}, "fullDescription": {"text": "No GitHub Actions, GitLab CI, or CircleCI configs found. Without CI you can't gate deploys on tests/lints."}, "properties": {"scanner": "scanner-primary", "layer": "cicd", "severity": "medium", "confidence": 1.0}}, {"id": "scanner-2501af3c46f9905a", "name": "Very large file: database.py (1549 lines)", "shortDescription": {"text": "Very large file: database.py (1549 lines)"}, "fullDescription": {"text": "Files with >800 lines often hide complexity hotspots and discourage tests."}, "properties": {"scanner": "scanner-primary", "layer": "quality", "severity": "low", "confidence": 1.0}}, {"id": "scanner-c7459d5846fdaf7e", "name": "Very large file: api.py (3688 lines)", "shortDescription": {"text": "Very large file: api.py (3688 lines)"}, "fullDescription": {"text": "Files with >800 lines often hide complexity hotspots and discourage tests."}, "properties": {"scanner": "scanner-primary", "layer": "quality", "severity": "low", "confidence": 1.0}}, {"id": "scanner-6893a6c8b0861585", "name": "Very low test-to-source ratio", "shortDescription": {"text": "Very low test-to-source ratio"}, "fullDescription": {"text": "0 test file(s) for 13 source file(s) (ratio 0.00). Consider adding integration or unit tests for critical paths."}, "properties": {"scanner": "scanner-primary", "layer": "quality", "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-faccb9061e9b52a0", "name": "No README detected", "shortDescription": {"text": "No README detected"}, "fullDescription": {"text": "No README file was found. Generated repos without README context are hard to operate, validate, or safely hand off."}, "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 112 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-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, tests, operator-readme. 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": "medium", "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, tests, operator-readme. 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-bea357a6497a2d5d", "name": "Agent authority lacks a verifier contract: CLAUDE.md", "shortDescription": {"text": "Agent authority lacks a verifier contract: CLAUDE.md"}, "fullDescription": {"text": "This agent instruction grants code or shell authority but does not state the verification gate that decides promotion. The recurring safe pattern is: LLM proposes; deterministic tests/build/security checks verify; only verified code promotes."}, "properties": {"scanner": "scanner-primary", "layer": "quality", "severity": "medium", "confidence": 1.0}}, {"id": "scanner-c75984e64d282d1e", "name": "Network/subprocess call without timeout or try/except \u2014 start.py:62", "shortDescription": {"text": "Network/subprocess call without timeout or try/except \u2014 start.py:62"}, "fullDescription": {"text": "`subprocess.Popen(...)` 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-4e4bb863cd3cf867", "name": "Legacy-named symbol `orders_v2` in api.py:3015", "shortDescription": {"text": "Legacy-named symbol `orders_v2` in api.py:3015"}, "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-af517936dcbc1a14", "name": "Blocking `time.sleep(...)` inside `async def _fix_categoria_bg` \u2014 api.py:2554", "shortDescription": {"text": "Blocking `time.sleep(...)` inside `async def _fix_categoria_bg` \u2014 api.py:2554"}, "fullDescription": {"text": "Sync I/O inside an async function blocks the event loop. While `time.sleep(...)` is running, *all* other coroutines on this loop are paused \u2014 silent throughput collapse under concurrency. Use the async equivalent (`httpx.AsyncClient`, `asyncio.sleep`, `aiofiles`) or wrap with `await asyncio.to_thread(...)`."}, "properties": {"scanner": "scanner-primary", "layer": "quality", "severity": "high", "confidence": 1.0}}, {"id": "scanner-8cec7b61a10ac704", "name": "Blocking `time.sleep(...)` inside `async def _fix_categoria_bg` \u2014 api.py:2571", "shortDescription": {"text": "Blocking `time.sleep(...)` inside `async def _fix_categoria_bg` \u2014 api.py:2571"}, "fullDescription": {"text": "Sync I/O inside an async function blocks the event loop. While `time.sleep(...)` is running, *all* other coroutines on this loop are paused \u2014 silent throughput collapse under concurrency. Use the async equivalent (`httpx.AsyncClient`, `asyncio.sleep`, `aiofiles`) or wrap with `await asyncio.to_thread(...)`."}, "properties": {"scanner": "scanner-primary", "layer": "quality", "severity": "high", "confidence": 1.0}}, {"id": "scanner-cc0f9d8e41b33b0e", "name": "11 env vars used in code but missing from .env.example", "shortDescription": {"text": "11 env vars used in code but missing from .env.example"}, "fullDescription": {"text": "Drift between code and config docs. The first few: `APP_URL`, `DATABASE_URL`, `ML_CATEGORIA_ID`, `ML_WEBHOOK_SECRET`, `PORT`, `R2_ACCESS_KEY_ID`, `R2_ACCOUNT_ID`, `R2_BUCKET_NAME` + 3 more. Add them (with a placeholder/comment) to .env.example so onboarding doesn't break."}, "properties": {"scanner": "scanner-primary", "layer": "quality", "severity": "low", "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:\ngerar_shopee_xlsx.py:gerar_descricao, gerar_shopee_xlsx.py:gerar\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:\ndatabase.py:listar_anuncios, database.py:contar_anuncios_filtrado, database.py:contar_anuncios\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-41e815b579e3c791", "name": "FastAPI POST `ml_webhook` without auth dependency \u2014 api.py:2994", "shortDescription": {"text": "FastAPI POST `ml_webhook` without auth dependency \u2014 api.py:2994"}, "fullDescription": {"text": "`@router.post` decorator with no `Depends(get_current_user)` or auth-shaped dependency in its signature. Mutating endpoints should require authentication unless explicitly public."}, "properties": {"scanner": "scanner-primary", "layer": "security", "severity": "high", "confidence": 1.0}}]}}, "automationDetails": {"id": "repobility/27395"}, "properties": {"repository": "Leonekkj/Apostilas", "repoUrl": "https://github.com/Leonekkj/Apostilas", "branch": "main"}, "results": [{"ruleId": "scanner-9f5c678eba205901", "level": "note", "message": {"text": "Possibly dead Python function: replacer"}, "properties": {"repobilityId": "4c6d041d83cc4187", "scanner": "scanner-primary", "fingerprint": "9f5c678eba205901", "layer": "software", "severity": "low", "confidence": 1.0, "tags": ["dead-code"]}, "locations": [{"physicalLocation": {"artifactLocation": {"uri": "gerar_shopee_xlsx.py:109"}, "region": {"startLine": 1}}}]}, {"ruleId": "scanner-cb5dfebabcf93c61", "level": "note", "message": {"text": "Possibly dead Python function: dedupe_titulos"}, "properties": {"repobilityId": "612b47fcbeef61a8", "scanner": "scanner-primary", "fingerprint": "cb5dfebabcf93c61", "layer": "software", "severity": "low", "confidence": 1.0, "tags": ["dead-code"]}, "locations": [{"physicalLocation": {"artifactLocation": {"uri": "validacao.py:38"}, "region": {"startLine": 1}}}]}, {"ruleId": "scanner-26bf12d60a7d85e3", "level": "note", "message": {"text": "Possibly dead Python function: sincronizar_e_gerar_pdfs"}, "properties": {"repobilityId": "c9c350877a5b78ee", "scanner": "scanner-primary", "fingerprint": "26bf12d60a7d85e3", "layer": "software", "severity": "low", "confidence": 1.0, "tags": ["dead-code"]}, "locations": [{"physicalLocation": {"artifactLocation": {"uri": "scheduler.py:97"}, "region": {"startLine": 1}}}]}, {"ruleId": "scanner-7320ec72626280b1", "level": "note", "message": {"text": "Possibly dead Python function: gerar_kits_automaticos"}, "properties": {"repobilityId": "b31973e2e60c0b7c", "scanner": "scanner-primary", "fingerprint": "7320ec72626280b1", "layer": "software", "severity": "low", "confidence": 1.0, "tags": ["dead-code"]}, "locations": [{"physicalLocation": {"artifactLocation": {"uri": "scheduler.py:175"}, "region": {"startLine": 1}}}]}, {"ruleId": "scanner-1e54b484cd918224", "level": "note", "message": {"text": "Possibly dead Python function: exportar_shopee"}, "properties": {"repobilityId": "59f8feff9db23064", "scanner": "scanner-primary", "fingerprint": "1e54b484cd918224", "layer": "software", "severity": "low", "confidence": 1.0, "tags": ["dead-code"]}, "locations": [{"physicalLocation": {"artifactLocation": {"uri": "exportador.py:73"}, "region": {"startLine": 1}}}]}, {"ruleId": "scanner-78686303828f58b6", "level": "note", "message": {"text": "Possibly dead Python function: exportar_amazon"}, "properties": {"repobilityId": "bf08b359c91d3742", "scanner": "scanner-primary", "fingerprint": "78686303828f58b6", "layer": "software", "severity": "low", "confidence": 1.0, "tags": ["dead-code"]}, "locations": [{"physicalLocation": {"artifactLocation": {"uri": "exportador.py:95"}, "region": {"startLine": 1}}}]}, {"ruleId": "scanner-d6bdae6d04ea44e9", "level": "note", "message": {"text": "Possibly dead Python function: buscar_topico"}, "properties": {"repobilityId": "812b188153a545bd", "scanner": "scanner-primary", "fingerprint": "d6bdae6d04ea44e9", "layer": "software", "severity": "low", "confidence": 1.0, "tags": ["dead-code"]}, "locations": [{"physicalLocation": {"artifactLocation": {"uri": "database.py:414"}, "region": {"startLine": 1}}}]}, {"ruleId": "scanner-d88c72d4cde45353", "level": "note", "message": {"text": "Possibly dead Python function: importar_anuncio_externo"}, "properties": {"repobilityId": "a4bf209d1492ecf1", "scanner": "scanner-primary", "fingerprint": "d88c72d4cde45353", "layer": "software", "severity": "low", "confidence": 1.0, "tags": ["dead-code"]}, "locations": [{"physicalLocation": {"artifactLocation": {"uri": "database.py:552"}, "region": {"startLine": 1}}}]}, {"ruleId": "scanner-2d38876031779137", "level": "note", "message": {"text": "Possibly dead Python function: contar_anuncios_filtrado"}, "properties": {"repobilityId": "ae0da90cb96562e7", "scanner": "scanner-primary", "fingerprint": "2d38876031779137", "layer": "software", "severity": "low", "confidence": 1.0, "tags": ["dead-code"]}, "locations": [{"physicalLocation": {"artifactLocation": {"uri": "database.py:634"}, "region": {"startLine": 1}}}]}, {"ruleId": "scanner-2807fce9f1268020", "level": "note", "message": {"text": "Possibly dead Python function: listar_temas_caca_palavras_existentes"}, "properties": {"repobilityId": "c7bd92fbb17e8486", "scanner": "scanner-primary", "fingerprint": "2807fce9f1268020", "layer": "software", "severity": "low", "confidence": 1.0, "tags": ["dead-code"]}, "locations": [{"physicalLocation": {"artifactLocation": {"uri": "database.py:776"}, "region": {"startLine": 1}}}]}, {"ruleId": "scanner-5ddab5d071984e0a", "level": "note", "message": {"text": "Possibly dead Python function: listar_apostilas_caca_palavras_por_dificuldade"}, "properties": {"repobilityId": "edb65f545146de0c", "scanner": "scanner-primary", "fingerprint": "5ddab5d071984e0a", "layer": "software", "severity": "low", "confidence": 1.0, "tags": ["dead-code"]}, "locations": [{"physicalLocation": {"artifactLocation": {"uri": "database.py:789"}, "region": {"startLine": 1}}}]}, {"ruleId": "scanner-e6323d4c1b9bd32c", "level": "note", "message": {"text": "Possibly dead Python function: buscar_topico_por_id"}, "properties": {"repobilityId": "d52ce8c24772b7d3", "scanner": "scanner-primary", "fingerprint": "e6323d4c1b9bd32c", "layer": "software", "severity": "low", "confidence": 1.0, "tags": ["dead-code"]}, "locations": [{"physicalLocation": {"artifactLocation": {"uri": "database.py:860"}, "region": {"startLine": 1}}}]}, {"ruleId": "scanner-4e5dcb6ebfbbb28d", "level": "note", "message": {"text": "Possibly dead Python function: salvar_shopee_tokens"}, "properties": {"repobilityId": "d36a89d0f621bfa1", "scanner": "scanner-primary", "fingerprint": "4e5dcb6ebfbbb28d", "layer": "software", "severity": "low", "confidence": 1.0, "tags": ["dead-code"]}, "locations": [{"physicalLocation": {"artifactLocation": {"uri": "database.py:967"}, "region": {"startLine": 1}}}]}, {"ruleId": "scanner-6fa24f2bbbf95bc0", "level": "note", "message": {"text": "Possibly dead Python function: buscar_shopee_tokens"}, "properties": {"repobilityId": "ebd07c1b9e7c091c", "scanner": "scanner-primary", "fingerprint": "6fa24f2bbbf95bc0", "layer": "software", "severity": "low", "confidence": 1.0, "tags": ["dead-code"]}, "locations": [{"physicalLocation": {"artifactLocation": {"uri": "database.py:996"}, "region": {"startLine": 1}}}]}, {"ruleId": "scanner-c60b97ab9c535a27", "level": "note", "message": {"text": "Possibly dead Python function: deletar_anuncios_por_apostila"}, "properties": {"repobilityId": "e8d4af8f5b7d5a33", "scanner": "scanner-primary", "fingerprint": "c60b97ab9c535a27", "layer": "software", "severity": "low", "confidence": 1.0, "tags": ["dead-code"]}, "locations": [{"physicalLocation": {"artifactLocation": {"uri": "database.py:1009"}, "region": {"startLine": 1}}}]}, {"ruleId": "scanner-ab47488c750990bb", "level": "note", "message": {"text": "Possibly dead Python function: deletar_apostila"}, "properties": {"repobilityId": "edd579f706323a5b", "scanner": "scanner-primary", "fingerprint": "ab47488c750990bb", "layer": "software", "severity": "low", "confidence": 1.0, "tags": ["dead-code"]}, "locations": [{"physicalLocation": {"artifactLocation": {"uri": "database.py:1031"}, "region": {"startLine": 1}}}]}, {"ruleId": "scanner-11a547cc6e42db34", "level": "note", "message": {"text": "Possibly dead Python function: deletar_anuncios_por_kit"}, "properties": {"repobilityId": "b12305d8e80e921f", "scanner": "scanner-primary", "fingerprint": "11a547cc6e42db34", "layer": "software", "severity": "low", "confidence": 1.0, "tags": ["dead-code"]}, "locations": [{"physicalLocation": {"artifactLocation": {"uri": "database.py:1040"}, "region": {"startLine": 1}}}]}, {"ruleId": "scanner-0d815f949b93aab8", "level": "note", "message": {"text": "Possibly dead Python function: fix_precos_kits_db"}, "properties": {"repobilityId": "d798e80dec6a244d", "scanner": "scanner-primary", "fingerprint": "0d815f949b93aab8", "layer": "software", "severity": "low", "confidence": 1.0, "tags": ["dead-code"]}, "locations": [{"physicalLocation": {"artifactLocation": {"uri": "database.py:1062"}, "region": {"startLine": 1}}}]}, {"ruleId": "scanner-b8bbfe3628d2f505", "level": "note", "message": {"text": "Possibly dead Python function: deletar_kit"}, "properties": {"repobilityId": "5fd2d3cdbb501927", "scanner": "scanner-primary", "fingerprint": "b8bbfe3628d2f505", "layer": "software", "severity": "low", "confidence": 1.0, "tags": ["dead-code"]}, "locations": [{"physicalLocation": {"artifactLocation": {"uri": "database.py:1129"}, "region": {"startLine": 1}}}]}, {"ruleId": "scanner-aaff802c7d63c777", "level": "note", "message": {"text": "Possibly dead Python function: listar_vendas"}, "properties": {"repobilityId": "66699fec7c6a2ac4", "scanner": "scanner-primary", "fingerprint": "aaff802c7d63c777", "layer": "software", "severity": "low", "confidence": 1.0, "tags": ["dead-code"]}, "locations": [{"physicalLocation": {"artifactLocation": {"uri": "database.py:1226"}, "region": {"startLine": 1}}}]}, {"ruleId": "scanner-60c040b3fb87f514", "level": "note", "message": {"text": "Possibly dead Python function: resumo_vendas_por_apostila"}, "properties": {"repobilityId": "36b44ccc8b7bd497", "scanner": "scanner-primary", "fingerprint": "60c040b3fb87f514", "layer": "software", "severity": "low", "confidence": 1.0, "tags": ["dead-code"]}, "locations": [{"physicalLocation": {"artifactLocation": {"uri": "database.py:1262"}, "region": {"startLine": 1}}}]}, {"ruleId": "scanner-b86ec06821af0941", "level": "note", "message": {"text": "Possibly dead Python function: listar_todas_apostilas"}, "properties": {"repobilityId": "c4a5a8ab7dcca69d", "scanner": "scanner-primary", "fingerprint": "b86ec06821af0941", "layer": "software", "severity": "low", "confidence": 1.0, "tags": ["dead-code"]}, "locations": [{"physicalLocation": {"artifactLocation": {"uri": "database.py:1372"}, "region": {"startLine": 1}}}]}, {"ruleId": "scanner-48df5e7f3ea8962d", "level": "note", "message": {"text": "Possibly dead Python function: criar_produto"}, "properties": {"repobilityId": "a40a5b749cb03583", "scanner": "scanner-primary", "fingerprint": "48df5e7f3ea8962d", "layer": "software", "severity": "low", "confidence": 1.0, "tags": ["dead-code"]}, "locations": [{"physicalLocation": {"artifactLocation": {"uri": "database.py:1385"}, "region": {"startLine": 1}}}]}, {"ruleId": "scanner-992a942f7fb18f25", "level": "note", "message": {"text": "Possibly dead Python function: criar_produto_caca_palavras"}, "properties": {"repobilityId": "cd1f2d5c3bc9800e", "scanner": "scanner-primary", "fingerprint": "992a942f7fb18f25", "layer": "software", "severity": "low", "confidence": 1.0, "tags": ["dead-code"]}, "locations": [{"physicalLocation": {"artifactLocation": {"uri": "database.py:1397"}, "region": {"startLine": 1}}}]}, {"ruleId": "scanner-d0884f6d17f08800", "level": "note", "message": {"text": "Possibly dead Python function: listar_produtos_com_apostilas"}, "properties": {"repobilityId": "da10eecf98561b18", "scanner": "scanner-primary", "fingerprint": "d0884f6d17f08800", "layer": "software", "severity": "low", "confidence": 1.0, "tags": ["dead-code"]}, "locations": [{"physicalLocation": {"artifactLocation": {"uri": "database.py:1411"}, "region": {"startLine": 1}}}]}, {"ruleId": "scanner-85b13e4447851f48", "level": "note", "message": {"text": "Possibly dead Python function: listar_apostilas_por_produto"}, "properties": {"repobilityId": "11150f2a186f8b53", "scanner": "scanner-primary", "fingerprint": "85b13e4447851f48", "layer": "software", "severity": "low", "confidence": 1.0, "tags": ["dead-code"]}, "locations": [{"physicalLocation": {"artifactLocation": {"uri": "database.py:1444"}, "region": {"startLine": 1}}}]}, {"ruleId": "scanner-b795e3fbeec450ce", "level": "note", "message": {"text": "Possibly dead Python function: deletar_produto"}, "properties": {"repobilityId": "6994d39a64b5f486", "scanner": "scanner-primary", "fingerprint": "b795e3fbeec450ce", "layer": "software", "severity": "low", "confidence": 1.0, "tags": ["dead-code"]}, "locations": [{"physicalLocation": {"artifactLocation": {"uri": "database.py:1454"}, "region": {"startLine": 1}}}]}, {"ruleId": "scanner-d4bf2e8eb28e3b92", "level": "note", "message": {"text": "Possibly dead Python function: upload"}, "properties": {"repobilityId": "7f7222445cb54387", "scanner": "scanner-primary", "fingerprint": "d4bf2e8eb28e3b92", "layer": "software", "severity": "low", "confidence": 1.0, "tags": ["dead-code"]}, "locations": [{"physicalLocation": {"artifactLocation": {"uri": "storage.py:34"}, "region": {"startLine": 1}}}]}, {"ruleId": "scanner-b6dfa51e38f3a9d2", "level": "note", "message": {"text": "Possibly dead Python function: upload_video"}, "properties": {"repobilityId": "52cd40f3b5d2c1aa", "scanner": "scanner-primary", "fingerprint": "b6dfa51e38f3a9d2", "layer": "software", "severity": "low", "confidence": 1.0, "tags": ["dead-code"]}, "locations": [{"physicalLocation": {"artifactLocation": {"uri": "storage.py:60"}, "region": {"startLine": 1}}}]}, {"ruleId": "scanner-450d4c7e80f9f584", "level": "note", "message": {"text": "Possibly dead Python function: is_url"}, "properties": {"repobilityId": "a3015874fdcada69", "scanner": "scanner-primary", "fingerprint": "450d4c7e80f9f584", "layer": "software", "severity": "low", "confidence": 1.0, "tags": ["dead-code"]}, "locations": [{"physicalLocation": {"artifactLocation": {"uri": "storage.py:83"}, "region": {"startLine": 1}}}]}, {"ruleId": "scanner-93514f6b7916a94f", "level": "warning", "message": {"text": "Insecure pattern 'cors_wildcard' in api.py:51"}, "properties": {"repobilityId": "fdae122c19e8aace", "scanner": "scanner-primary", "fingerprint": "93514f6b7916a94f", "layer": "security", "severity": "medium", "confidence": 1.0, "tags": ["owasp", "cors_wildcard"]}, "locations": [{"physicalLocation": {"artifactLocation": {"uri": "api.py"}, "region": {"startLine": 51}}}]}, {"ruleId": "scanner-4601e3ad3bb28677", "level": "warning", "message": {"text": "No CI/CD pipelines detected"}, "properties": {"repobilityId": "c3ee439bce2bc51e", "scanner": "scanner-primary", "fingerprint": "4601e3ad3bb28677", "layer": "cicd", "severity": "medium", "confidence": 1.0, "tags": ["coverage"]}}, {"ruleId": "scanner-2501af3c46f9905a", "level": "note", "message": {"text": "Very large file: database.py (1549 lines)"}, "properties": {"repobilityId": "29692af050e0a876", "scanner": "scanner-primary", "fingerprint": "2501af3c46f9905a", "layer": "quality", "severity": "low", "confidence": 1.0, "tags": ["complexity"]}}, {"ruleId": "scanner-c7459d5846fdaf7e", "level": "note", "message": {"text": "Very large file: api.py (3688 lines)"}, "properties": {"repobilityId": "ad3b8140270f67c4", "scanner": "scanner-primary", "fingerprint": "c7459d5846fdaf7e", "layer": "quality", "severity": "low", "confidence": 1.0, "tags": ["complexity"]}}, {"ruleId": "scanner-6893a6c8b0861585", "level": "warning", "message": {"text": "Very low test-to-source ratio"}, "properties": {"repobilityId": "54a7de3f06314bf0", "scanner": "scanner-primary", "fingerprint": "6893a6c8b0861585", "layer": "quality", "severity": "medium", "confidence": 1.0, "tags": ["tests", "coverage"]}}, {"ruleId": "scanner-141b30a41e03817b", "level": "note", "message": {"text": "No license file detected"}, "properties": {"repobilityId": "0ee64502550bc2f7", "scanner": "scanner-primary", "fingerprint": "141b30a41e03817b", "layer": "quality", "severity": "low", "confidence": 1.0, "tags": ["license", "repo-hardening", "generated-repo-pattern"]}}, {"ruleId": "scanner-faccb9061e9b52a0", "level": "note", "message": {"text": "No README detected"}, "properties": {"repobilityId": "a6cfc99e3b537f24", "scanner": "scanner-primary", "fingerprint": "faccb9061e9b52a0", "layer": "quality", "severity": "low", "confidence": 1.0, "tags": ["docs", "readme", "repo-hardening", "generated-repo-pattern"]}}, {"ruleId": "scanner-3ab5d313dda8e5f9", "level": "note", "message": {"text": "Debug logging residue appears in source files"}, "properties": {"repobilityId": "9424f5d41be14300", "scanner": "scanner-primary", "fingerprint": "3ab5d313dda8e5f9", "layer": "quality", "severity": "low", "confidence": 1.0, "tags": ["debug", "cleanup", "repo-hardening", "generated-repo-pattern"]}}, {"ruleId": "scanner-2d0c7b7ab8f8aacf", "level": "warning", "message": {"text": "Critical user flow still appears backed by mock or placeholder data"}, "properties": {"repobilityId": "7cffa0448fd7f878", "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": "warning", "message": {"text": "Composite production-readiness gap"}, "properties": {"repobilityId": "7cf4cce9f846b36d", "scanner": "scanner-primary", "fingerprint": "b9088664ace7f748", "layer": "quality", "severity": "medium", "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": "eed530c540ddd715", "scanner": "scanner-primary", "fingerprint": "749d4bc1bd66df5f", "layer": "quality", "severity": "medium", "confidence": 1.0, "tags": ["agent-instructions", "repo-hardening", "generated-repo-pattern"]}}, {"ruleId": "scanner-bea357a6497a2d5d", "level": "warning", "message": {"text": "Agent authority lacks a verifier contract: CLAUDE.md"}, "properties": {"repobilityId": "aae72df3934829ac", "scanner": "scanner-primary", "fingerprint": "bea357a6497a2d5d", "layer": "quality", "severity": "medium", "confidence": 1.0, "tags": ["agent-instructions", "verification", "claude_instruction"]}, "locations": [{"physicalLocation": {"artifactLocation": {"uri": "CLAUDE.md"}, "region": {"startLine": 1}}}]}, {"ruleId": "scanner-c75984e64d282d1e", "level": "warning", "message": {"text": "Network/subprocess call without timeout or try/except \u2014 start.py:62"}, "properties": {"repobilityId": "d0c4d33957ff3fbd", "scanner": "scanner-primary", "fingerprint": "c75984e64d282d1e", "layer": "quality", "severity": "medium", "confidence": 1.0, "tags": ["integrity", "fragile-runtime", "robustness"]}}, {"ruleId": "scanner-4e4bb863cd3cf867", "level": "note", "message": {"text": "Legacy-named symbol `orders_v2` in api.py:3015"}, "properties": {"repobilityId": "0bf7b054f2fd2129", "scanner": "scanner-primary", "fingerprint": "4e4bb863cd3cf867", "layer": "quality", "severity": "low", "confidence": 1.0, "tags": ["integrity", "legacy-marker", "dead-code"]}}, {"ruleId": "scanner-af517936dcbc1a14", "level": "error", "message": {"text": "Blocking `time.sleep(...)` inside `async def _fix_categoria_bg` \u2014 api.py:2554"}, "properties": {"repobilityId": "370a326265f809e8", "scanner": "scanner-primary", "fingerprint": "af517936dcbc1a14", "layer": "quality", "severity": "high", "confidence": 1.0, "tags": ["integrity", "sync-io-in-async", "performance"]}, "locations": [{"physicalLocation": {"artifactLocation": {"uri": "api.py"}, "region": {"startLine": 2554}}}]}, {"ruleId": "scanner-8cec7b61a10ac704", "level": "error", "message": {"text": "Blocking `time.sleep(...)` inside `async def _fix_categoria_bg` \u2014 api.py:2571"}, "properties": {"repobilityId": "a9c39e9f7faf0db9", "scanner": "scanner-primary", "fingerprint": "8cec7b61a10ac704", "layer": "quality", "severity": "high", "confidence": 1.0, "tags": ["integrity", "sync-io-in-async", "performance"]}, "locations": [{"physicalLocation": {"artifactLocation": {"uri": "api.py"}, "region": {"startLine": 2571}}}]}, {"ruleId": "scanner-cc0f9d8e41b33b0e", "level": "note", "message": {"text": "11 env vars used in code but missing from .env.example"}, "properties": {"repobilityId": "c82cd8cd626c3599", "scanner": "scanner-primary", "fingerprint": "cc0f9d8e41b33b0e", "layer": "quality", "severity": "low", "confidence": 1.0, "tags": ["integrity", "config-drift"]}}, {"ruleId": "scanner-2c04133e54348533", "level": "note", "message": {"text": "Near-duplicate function bodies in 2 places"}, "properties": {"repobilityId": "1b0a74e26319ca53", "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": "80754a4453b2e9d2", "scanner": "scanner-primary", "fingerprint": "be46ea126aa5d8dc", "layer": "quality", "severity": "low", "confidence": 1.0, "tags": ["integrity", "duplicate", "dry"]}}, {"ruleId": "scanner-41e815b579e3c791", "level": "error", "message": {"text": "FastAPI POST `ml_webhook` without auth dependency \u2014 api.py:2994"}, "properties": {"repobilityId": "123b73b884adcd3e", "scanner": "scanner-primary", "fingerprint": "41e815b579e3c791", "layer": "security", "severity": "high", "confidence": 1.0, "tags": ["auth", "owasp", "auth.fastapi.unauth_mutation"]}, "locations": [{"physicalLocation": {"artifactLocation": {"uri": "api.py"}, "region": {"startLine": 2994}}}]}]}]}