yanis/html

Files

WEVAL NonReg / nonreg (push) Has been cancelled

Details

V152 Ethica DZ priority enrichment boost - ORDER BY pays+specialty

Budget audit V152:
- SerpAPI/HunterIO NOT in secrets.env = no budget allocated
- Pivot to zero-cost solution (SearxNG already active)

Autre Claude already boosted cron:
- 01:00 enrich-v4 600 (was 300)
- 10:00 enrich-searxng 500 (was 200)
- 16:00 enrich-searxng 500 (V152 new second run)

My V152 contribution: DZ priority ORDER BY in searxng query

Before: ORDER BY id LIMIT 500 (arbitrary)
After: ORDER BY
  CASE pays WHEN DZ THEN 0 WHEN MA THEN 1 WHEN TN THEN 2 ELSE 3 END,
  CASE specialite WHEN generaliste THEN 0 WHEN medecin THEN 1 ELSE 2 END,
  id LIMIT 500

Remaining DZ generaliste: 449 HCPs
Timeline: 1-2 days coverage with 2x/day 500 batch
Pilot launchable after ~100 emails added

GOLD: ethica-enrich-searxng.py.GOLD-V152-20260422-021411

L99 153/153 PASS (21 consecutive versions V125-V152)

Doctrines 0+1+2+4+14+95+100 applied

2026-04-22 02:15:11 +02:00

2.9 KiB

Raw Permalink Blame History

V152 - Ethica DZ priority enrichment boost - 2026-04-22

Objectif Yacine

Post V150+V151 (infrastructure fixée), besoin accélérer enrichment DZ pilot generaliste (10,063 HCPs, emails missing).

V149 recommendation Option C evaluated

SerpAPI/HunterIO = $100-200/mois budget. Vérification V152: secrets.env ne contient PAS ces clés. → Budget pas alloué par Yacine.

Pivot vers ZERO-COST solution

SearxNG déjà en place + actif:

/opt/ethica-enrich-searxng.py cron quotidien
Pas d'API key requise (moteur recherche local)
Cron déjà boosté par autre Claude: 500/run 2x/jour (10:00 + 16:00)

V152 Ma contribution unique: DZ priority

Bug observed

Query candidats:

SELECT ... WHERE source != 'hcp_gen_20260218'
  AND (email IS NULL OR email = '' OR email = 'N/A')
  AND (telephone IS NULL OR telephone = '' OR telephone = 'N/A')
ORDER BY id LIMIT 500

ORDER BY id = arbitrage ID, pas de priorité business.

Fix V152

ORDER BY CASE pays WHEN 'DZ' THEN 0 WHEN 'MA' THEN 1 WHEN 'TN' THEN 2 ELSE 3 END,
         CASE specialite WHEN 'generaliste' THEN 0 WHEN 'medecin' THEN 1 ELSE 2 END,
         id LIMIT 500

DZ d'abord, puis MA, puis TN. Dans chaque pays: generaliste first.

Distribution remaining candidates post-V151

DZ generaliste   : 449 (PILOT TARGET!)
DZ pharmacien    : 399
DZ cardiologue   : 389
DZ ophtalmologue : 384
DZ pediatre      : 384
DZ dentiste      : 375
MA generaliste   : 327
MA dentiste      : 321
DZ gynecologue   : 287
TN generaliste   : 247

Timeline prévue

Avec V152 priority active:

Run 10:00 500 batch → 500 DZ generaliste processed (tous + autre)
Run 16:00 500 batch → remaining 449 - already processed = continue
DZ generaliste covered in 1-2 days (not 18 months!)

Success rate observée: ~19% emails trouvés (+38/200). Sur 449 DZ generaliste: ~85 emails added = pilot lanceable.

GOLD V152

/opt/wevads/vault/ethica-enrich-searxng.py.GOLD-V152-20260422-021411

Doctrines V152

0 Root cause (ORDER BY arbitraire vs business prio)
1 GOLD backup
2 Zero écrasement
4 Zero régression
Zero budget additionnel (no $$$ API)
14 Test-driven (lint passed)
95 Traçabilité wiki
100 Train release

L99 153/153 PASS (21 versions consécutives V125-V152)

Chain V131 → V152

V131 Routing 100%
V132 Playwright 12/12
V133-V134 4/4 hubs
V135-V136 Admin repoint
V137-V138 Widget fix
V139 Filter + chatbot
V140 Defense chattr
V141 Handoff
V142-V144 Form + audits + split + cache
V145-V146 KPI sessions_sources
V147 Ethica/Vistex audit
V148 NULL→legacy
V149 Ethica diagnostic
V150 Refactor table + syntax
V151 Repoint host S95
V152 DZ priority ORDER BY

Recommandation V153+

Après run 16:00 ce soir, vérifier:

DZ generaliste candidats remaining
Emails ajoutés via cron searxng
Pilot ready if >100 emails DZ generaliste

Si toujours insuffisant après 1 semaine: Option C V149 (budget API nécessaire).

2.9 KiB Raw Permalink Blame History