Public scan — anyone with this URL can view this analysis. Sign up to track your own repos privately, run scheduled re-scans, and get AI fix prompts via your dashboard.
Sign up free Scan another repo

Leonekkj/Apostilas

https://github.com/Leonekkj/Apostilas · scanned 2026-06-16 04:31 UTC (2 months ago)

50 raw signals (0 security + 50 graph)

File as issue Image
UNIFIED Repobility · multi-layer engine · AI coders

Complete repo analysis

Last scanned 2 months ago · v1 · 50 actionable findings from 1 signal source. Security checks, system graph analysis, and verified AI-agent feedback are merged into one review queue.

JSON
Combined
66.4
/100
Security checks
66
0 findings
System graph
66
77.8% cov · 50 findings
Critical
0
click to filter
Agents
10
0 votes
Crowd
0
reported
Severity distribution — click a segment to filter
Active filters: excluding tests × Reset all
Severity: Critical 0 High 3 Medium 8 Low 39 9-Layer: Software Security Quality Integrity Frontend Hardware Data Network Cicd Source: Security checks 0 System graph 50 Crowd 0 Layer: Software 30 Security 2 Cicd 1 Quality 17
Corpus Intelligence Cross-corpus context (cohort percentile, top patterns, fix plan) is shown only on repositories you own. Sign up and connect your repo to view it.
Scan summary Repository scanned at 66.4/100 with 77.8% coverage. It contains 363 nodes across 30 cross-layer flows, written primarily in mixed languages. Engine surfaced 50 findings — concentrated in software (30), quality (17), security (2). Risk profile is high: 0 critical, 3 high, 8 medium. Recommended next step: open the software layer findings first — that's where the highest-impact wins live.

Showing 50 of 50 actionable findings. Click TP / FP to vote on a finding's accuracy — votes adjust the confidence weighting and improve detection across the platform.

high System graph quality Integrity conf 1.00 Blocking `time.sleep(...)` inside `async def _fix_categoria_bg` — api.py:2554
Sync I/O inside an async function blocks the event loop. While `time.sleep(...)` is running, *all* other coroutines on this loop are paused — silent throughput collapse under concurrency. Use the async equivalent (`httpx.AsyncClient`, `asyncio.sleep`, `aiofiles`) or wrap with `await asyncio.to_thre…
api.py:2554 Sync io in asyncPerformance
high System graph quality Integrity conf 1.00 Blocking `time.sleep(...)` inside `async def _fix_categoria_bg` — api.py:2571
Sync I/O inside an async function blocks the event loop. While `time.sleep(...)` is running, *all* other coroutines on this loop are paused — silent throughput collapse under concurrency. Use the async equivalent (`httpx.AsyncClient`, `asyncio.sleep`, `aiofiles`) or wrap with `await asyncio.to_thre…
api.py:2571 Sync io in asyncPerformance
high System graph security auth conf 1.00 FastAPI POST `ml_webhook` without auth dependency — api.py:2994
`@router.post` decorator with no `Depends(get_current_user)` or auth-shaped dependency in its signature. Mutating endpoints should require authentication unless explicitly public.
api.py:2994 securityAuth fastapi unauth mutation
medium System graph quality Agent instructions conf 1.00 Agent authority lacks a verifier contract: CLAUDE.md
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.
CLAUDE.md VerificationClaude instruction
medium System graph quality Agent instructions conf 1.00 Agent instructions exist but release-hardening basics are missing
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.
Repo hardeningGenerated repo pattern
medium System graph quality Production readiness conf 1.00 Composite production-readiness gap
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.
Repo hardeningGenerated repo pattern
medium System graph quality Placeholder conf 1.00 Critical user flow still appears backed by mock or placeholder data
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.
Mock dataCritical flowGenerated repo pattern
medium System graph security security conf 1.00 Insecure pattern 'cors_wildcard' in api.py:51
Found a known-risky pattern (cors_wildcard). Review and replace if possible.
api.py:51 Cors wildcard
medium System graph quality Integrity conf 1.00 Network/subprocess call without timeout or try/except — start.py:62
`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.
runtime safetyRobustness
medium System graph cicd CI/CD security conf 1.00 No CI/CD pipelines detected
No GitHub Actions, GitLab CI, or CircleCI configs found. Without CI you can't gate deploys on tests/lints.
CI/CD securityCoverage
medium System graph quality Tests conf 1.00 Very low test-to-source ratio
0 test file(s) for 13 source file(s) (ratio 0.00). Consider adding integration or unit tests for critical paths.
Coverage
low System graph quality Integrity conf 1.00 11 env vars used in code but missing from .env.example
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.
config drift
low System graph quality Debug conf 1.00 Debug logging residue appears in source files
Found 112 console/debugger/print-style debug statements in non-test source. This is a common fast-generation residue before production cleanup.
CleanupRepo hardeningGenerated repo pattern
low System graph quality Integrity conf 1.00 Near-duplicate function bodies in 2 places
Functions with the same first-5-line body hash: gerar_shopee_xlsx.py:gerar_descricao, gerar_shopee_xlsx.py:gerar This is *the* AI-coder failure mode (4× more duplication in vibe-coded repos — see https://jw.hn/ai-code-hygiene). Consolidate or document why they're separate.
duplicatesduplication
low System graph quality Integrity conf 1.00 Near-duplicate function bodies in 3 places
Functions with the same first-5-line body hash: database.py:listar_anuncios, database.py:contar_anuncios_filtrado, database.py:contar_anuncios This is *the* AI-coder failure mode (4× more duplication in vibe-coded repos — see https://jw.hn/ai-code-hygiene). Consolidate or document why they're sepa…
duplicatesduplication
low System graph quality License conf 1.00 No license file detected
No LICENSE/COPYING/NOTICE file was found. Generated repositories often omit licensing, which blocks reuse and automated intake.
Repo hardeningGenerated repo pattern
low System graph quality Docs conf 1.00 No README detected
No README file was found. Generated repos without README context are hard to operate, validate, or safely hand off.
ReadmeRepo hardeningGenerated repo pattern
low System graph quality Integrity conf 1.00 Old/deprecated-named symbol `orders_v2` in api.py:3015
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.
old markerDead code
low System graph software Dead code conf 1.00 Possibly dead Python function: buscar_shopee_tokens
No callers detected by AST scan in this repo. Could be exported for external callers or a framework handler.
database.py:996
low System graph software Dead code conf 1.00 Possibly dead Python function: buscar_topico
No callers detected by AST scan in this repo. Could be exported for external callers or a framework handler.
database.py:414
low System graph software Dead code conf 1.00 Possibly dead Python function: buscar_topico_por_id
No callers detected by AST scan in this repo. Could be exported for external callers or a framework handler.
database.py:860
low System graph software Dead code conf 1.00 Possibly dead Python function: contar_anuncios_filtrado
No callers detected by AST scan in this repo. Could be exported for external callers or a framework handler.
database.py:634
low System graph software Dead code conf 1.00 Possibly dead Python function: criar_produto
No callers detected by AST scan in this repo. Could be exported for external callers or a framework handler.
database.py:1385
low System graph software Dead code conf 1.00 Possibly dead Python function: criar_produto_caca_palavras
No callers detected by AST scan in this repo. Could be exported for external callers or a framework handler.
database.py:1397
low System graph software Dead code conf 1.00 Possibly dead Python function: dedupe_titulos
No callers detected by AST scan in this repo. Could be exported for external callers or a framework handler.
validacao.py:38
low System graph software Dead code conf 1.00 Possibly dead Python function: deletar_anuncios_por_apostila
No callers detected by AST scan in this repo. Could be exported for external callers or a framework handler.
database.py:1009
low System graph software Dead code conf 1.00 Possibly dead Python function: deletar_anuncios_por_kit
No callers detected by AST scan in this repo. Could be exported for external callers or a framework handler.
database.py:1040
low System graph software Dead code conf 1.00 Possibly dead Python function: deletar_apostila
No callers detected by AST scan in this repo. Could be exported for external callers or a framework handler.
database.py:1031
low System graph software Dead code conf 1.00 Possibly dead Python function: deletar_kit
No callers detected by AST scan in this repo. Could be exported for external callers or a framework handler.
database.py:1129
low System graph software Dead code conf 1.00 Possibly dead Python function: deletar_produto
No callers detected by AST scan in this repo. Could be exported for external callers or a framework handler.
database.py:1454
low System graph software Dead code conf 1.00 Possibly dead Python function: exportar_amazon
No callers detected by AST scan in this repo. Could be exported for external callers or a framework handler.
exportador.py:95
low System graph software Dead code conf 1.00 Possibly dead Python function: exportar_shopee
No callers detected by AST scan in this repo. Could be exported for external callers or a framework handler.
exportador.py:73
low System graph software Dead code conf 1.00 Possibly dead Python function: fix_precos_kits_db
No callers detected by AST scan in this repo. Could be exported for external callers or a framework handler.
database.py:1062
low System graph software Dead code conf 1.00 Possibly dead Python function: gerar_kits_automaticos
No callers detected by AST scan in this repo. Could be exported for external callers or a framework handler.
scheduler.py:175
low System graph software Dead code conf 1.00 Possibly dead Python function: importar_anuncio_externo
No callers detected by AST scan in this repo. Could be exported for external callers or a framework handler.
database.py:552
low System graph software Dead code conf 1.00 Possibly dead Python function: is_url
No callers detected by AST scan in this repo. Could be exported for external callers or a framework handler.
storage.py:83
low System graph software Dead code conf 1.00 Possibly dead Python function: listar_apostilas_caca_palavras_por_dificuldade
No callers detected by AST scan in this repo. Could be exported for external callers or a framework handler.
database.py:789
low System graph software Dead code conf 1.00 Possibly dead Python function: listar_apostilas_por_produto
No callers detected by AST scan in this repo. Could be exported for external callers or a framework handler.
database.py:1444
low System graph software Dead code conf 1.00 Possibly dead Python function: listar_produtos_com_apostilas
No callers detected by AST scan in this repo. Could be exported for external callers or a framework handler.
database.py:1411
low System graph software Dead code conf 1.00 Possibly dead Python function: listar_temas_caca_palavras_existentes
No callers detected by AST scan in this repo. Could be exported for external callers or a framework handler.
database.py:776
low System graph software Dead code conf 1.00 Possibly dead Python function: listar_todas_apostilas
No callers detected by AST scan in this repo. Could be exported for external callers or a framework handler.
database.py:1372
low System graph software Dead code conf 1.00 Possibly dead Python function: listar_vendas
No callers detected by AST scan in this repo. Could be exported for external callers or a framework handler.
database.py:1226
low System graph software Dead code conf 1.00 Possibly dead Python function: replacer
No callers detected by AST scan in this repo. Could be exported for external callers or a framework handler.
gerar_shopee_xlsx.py:109
low System graph software Dead code conf 1.00 Possibly dead Python function: resumo_vendas_por_apostila
No callers detected by AST scan in this repo. Could be exported for external callers or a framework handler.
database.py:1262
low System graph software Dead code conf 1.00 Possibly dead Python function: salvar_shopee_tokens
No callers detected by AST scan in this repo. Could be exported for external callers or a framework handler.
database.py:967
low System graph software Dead code conf 1.00 Possibly dead Python function: sincronizar_e_gerar_pdfs
No callers detected by AST scan in this repo. Could be exported for external callers or a framework handler.
scheduler.py:97
low System graph software Dead code conf 1.00 Possibly dead Python function: upload
No callers detected by AST scan in this repo. Could be exported for external callers or a framework handler.
storage.py:34
low System graph software Dead code conf 1.00 Possibly dead Python function: upload_video
No callers detected by AST scan in this repo. Could be exported for external callers or a framework handler.
storage.py:60
low System graph quality Complexity conf 1.00 Very large file: api.py (3688 lines)
Files with >800 lines often hide complexity hotspots and discourage tests.
low System graph quality Complexity conf 1.00 Very large file: database.py (1549 lines)
Files with >800 lines often hide complexity hotspots and discourage tests.
For AI agents: Voting guide (TP/FP) MCP manifest Stdio wrapper SARIF Integrate Findings queue Vote TP/FP on findings to calibrate the engine.
For AI agents + API integrations
Email me when this repo regresses
Free. We re-scan periodically; new criticals → your inbox. No signup required for the scan itself.
API access

This page is publicly accessible at: https://repobility.com/scan/3ed43c31-c988-4619-a35c-34487ef2287d/

To check status programmatically (no auth required): 

curl -s https://repobility.com/api/v1/public/scan/3ed43c31-c988-4619-a35c-34487ef2287d/

Important — please don't re-submit the same URL repeatedly. The submission endpoint is idempotent: re-submitting the same git URL returns this same scan_token, not a new one. To re-scan this repo, sign up free and use the dashboard.