Administration

2026-04-02 14:07:35 [INFO] [berlingo] [LLM] [3/8] BERLINGO (brand=citroen, pages=auto)
2026-04-02 14:07:35 [INFO] [berlingo] [LLM] URL: https://www.leboncoin.fr/recherche?category=5&text=berlingo+xl&u_utility_brand=C...
2026-04-02 14:07:35 [INFO] [berlingo] [SEARCH] $ /home/ubuntu/app/.venv/bin/python /home/ubuntu/app/crawler/leboncoin_search_export.py --output-file /home/ubuntu/app/leboncoin_ads.csv --model berlingo
2026-04-02 14:07:36 [INFO] [berlingo] [SEARCH] Recuperation de la page 1 avec l'URL: https://www.leboncoin.fr/recherche?category=5&text=berlingo+xl&u_utility_brand=CITROEN&u_utility_model=CITROEN_Berlingo&page=1
2026-04-02 14:07:40 [INFO] [berlingo] [SEARCH] 35 annonces recuperees (total: 35)
2026-04-02 14:07:40 [INFO] [berlingo] [SEARCH] Recuperation de la page 2 avec l'URL: https://www.leboncoin.fr/recherche?category=5&text=berlingo+xl&u_utility_brand=CITROEN&u_utility_model=CITROEN_Berlingo&page=2
2026-04-02 14:07:50 [INFO] [berlingo] [SEARCH] 35 annonces recuperees (total: 70)
2026-04-02 14:07:50 [INFO] [berlingo] [SEARCH] Recuperation de la page 3 avec l'URL: https://www.leboncoin.fr/recherche?category=5&text=berlingo+xl&u_utility_brand=CITROEN&u_utility_model=CITROEN_Berlingo&page=3
2026-04-02 14:07:52 [INFO] [berlingo] [SEARCH] 35 annonces recuperees (total: 105)
2026-04-02 14:07:52 [INFO] [berlingo] [SEARCH] Recuperation de la page 4 avec l'URL: https://www.leboncoin.fr/recherche?category=5&text=berlingo+xl&u_utility_brand=CITROEN&u_utility_model=CITROEN_Berlingo&page=4
2026-04-02 14:07:55 [INFO] [berlingo] [SEARCH] 35 annonces recuperees (total: 140)
2026-04-02 14:07:55 [INFO] [berlingo] [SEARCH] Recuperation de la page 5 avec l'URL: https://www.leboncoin.fr/recherche?category=5&text=berlingo+xl&u_utility_brand=CITROEN&u_utility_model=CITROEN_Berlingo&page=5
2026-04-02 14:07:59 [INFO] [berlingo] [SEARCH] 35 annonces recuperees (total: 175)
2026-04-02 14:07:59 [INFO] [berlingo] [SEARCH] Recuperation de la page 6 avec l'URL: https://www.leboncoin.fr/recherche?category=5&text=berlingo+xl&u_utility_brand=CITROEN&u_utility_model=CITROEN_Berlingo&page=6
2026-04-02 14:08:03 [INFO] [berlingo] [SEARCH] 35 annonces recuperees (total: 210)
2026-04-02 14:08:03 [INFO] [berlingo] [SEARCH] Recuperation de la page 7 avec l'URL: https://www.leboncoin.fr/recherche?category=5&text=berlingo+xl&u_utility_brand=CITROEN&u_utility_model=CITROEN_Berlingo&page=7
2026-04-02 14:08:07 [INFO] [berlingo] [SEARCH] 35 annonces recuperees (total: 245)
2026-04-02 14:08:07 [INFO] [berlingo] [SEARCH] Recuperation de la page 8 avec l'URL: https://www.leboncoin.fr/recherche?category=5&text=berlingo+xl&u_utility_brand=CITROEN&u_utility_model=CITROEN_Berlingo&page=8
2026-04-02 14:08:11 [INFO] [berlingo] [SEARCH] 35 annonces recuperees (total: 280)
2026-04-02 14:08:11 [INFO] [berlingo] [SEARCH] Recuperation de la page 9 avec l'URL: https://www.leboncoin.fr/recherche?category=5&text=berlingo+xl&u_utility_brand=CITROEN&u_utility_model=CITROEN_Berlingo&page=9
2026-04-02 14:08:16 [INFO] [berlingo] [SEARCH] 35 annonces recuperees (total: 315)
2026-04-02 14:08:16 [INFO] [berlingo] [SEARCH] Recuperation de la page 10 avec l'URL: https://www.leboncoin.fr/recherche?category=5&text=berlingo+xl&u_utility_brand=CITROEN&u_utility_model=CITROEN_Berlingo&page=10
2026-04-02 14:08:19 [INFO] [berlingo] [SEARCH] 35 annonces recuperees (total: 350)
2026-04-02 14:08:19 [INFO] [berlingo] [SEARCH] Recuperation de la page 11 avec l'URL: https://www.leboncoin.fr/recherche?category=5&text=berlingo+xl&u_utility_brand=CITROEN&u_utility_model=CITROEN_Berlingo&page=11
2026-04-02 14:08:22 [INFO] [berlingo] [SEARCH] 1 annonces recuperees (total: 351)
2026-04-02 14:08:22 [INFO] [berlingo] [SEARCH] Recuperation de la page 12 avec l'URL: https://www.leboncoin.fr/recherche?category=5&text=berlingo+xl&u_utility_brand=CITROEN&u_utility_model=CITROEN_Berlingo&page=12
2026-04-02 14:08:31 [INFO] [berlingo] [SEARCH] Page 12 : aucune annonce, arret de la pagination.
2026-04-02 14:08:31 [INFO] [berlingo] [SEARCH] Termine : 351 annonces au total dans /home/ubuntu/app/leboncoin_ads_berlingo_20260402_140736.csv
2026-04-02 14:08:31 [INFO] [berlingo] [SEARCH] CSV : leboncoin_ads_berlingo_20260402_140736.csv
2026-04-02 14:08:31 [INFO] [berlingo] [IMPORT] $ /home/ubuntu/app/.venv/bin/python -m db.migrate_csv --input /home/ubuntu/app/leboncoin_ads_berlingo_20260402_140736.csv --db /home/ubuntu/app/db/lbc.sqlite --model berlingo
2026-04-02 14:08:31 [INFO] [berlingo] [IMPORT] Model override : berlingo
2026-04-02 14:08:31 [INFO] [berlingo] [IMPORT] MIGRATION CSV -> SQLite unifie
2026-04-02 14:08:31 [INFO] [berlingo] [IMPORT] Fichier: leboncoin_ads_berlingo_20260402_140736.csv
2026-04-02 14:08:31 [INFO] [berlingo] [IMPORT] Schéma initialisé dans /home/ubuntu/app/db/lbc.sqlite
2026-04-02 14:08:31 [INFO] [berlingo] [IMPORT] 351 lus, 351 inseres, 0 ignores, 0 erreurs
2026-04-02 14:08:31 [INFO] [berlingo] [IMPORT] TOTAL : 351 lus, 351 inseres — Base : /home/ubuntu/app/db/lbc.sqlite
2026-04-02 14:08:31 [INFO] [berlingo] [IMPORT] 9775 annonces en base
2026-04-02 14:08:31 [INFO] [berlingo] [AVAILABILITY] $ /home/ubuntu/app/.venv/bin/python /home/ubuntu/app/scripts/check_availability.py --csv /home/ubuntu/app/leboncoin_ads_berlingo_20260402_140736.csv --brand citroen --model berlingo --db /home/ubuntu/app/db/lbc.sqlite
2026-04-02 14:08:31 [INFO] [berlingo] [AVAILABILITY] CHECK DISPONIBILITE — CSV: leboncoin_ads_berlingo_20260402_140736.csv, Brand: citroen, Model: berlingo
2026-04-02 14:08:31 [INFO] [berlingo] [AVAILABILITY] 351 list_id lus dans le CSV.
2026-04-02 14:08:31 [INFO] [berlingo] [AVAILABILITY] 358 annonces actives en base pour citroen berlingo.
2026-04-02 14:08:31 [INFO] [berlingo] [AVAILABILITY] 7 annonce(s) marquées indisponibles.
2026-04-02 14:08:31 [INFO] [berlingo] [AVAILABILITY] CSV: 351, Actives DB: 358, Absentes: 7
2026-04-02 14:08:31 [INFO] [berlingo] [AVAILABILITY] Marquees indisponibles: 7
2026-04-02 14:08:31 [INFO] [berlingo] [DETAIL] $ /home/ubuntu/app/.venv/bin/python -m crawler.leboncoin_ad_detail --model berlingo --delay 0.5 --limit 200
2026-04-02 14:08:32 [INFO] [berlingo] [DETAIL] ENRICHISSEMENT AD DETAIL — Modele: berlingo — Limite: 200
2026-04-02 14:08:32 [INFO] [berlingo] [DETAIL] Schéma initialisé dans /home/ubuntu/app/db/lbc.sqlite
2026-04-02 14:08:32 [INFO] [berlingo] [DETAIL] 2 annonce(s) à enrichir (modèle: berlingo)
2026-04-02 14:08:38 [INFO] [berlingo] [DETAIL] RESULTAT : 2 traitee(s), 2 enrichies, 0 introuvables, 0 erreurs
2026-04-02 14:08:38 [INFO] [berlingo] [STATS] $ /home/ubuntu/app/.venv/bin/python -m stats.main --model berlingo --skip-plots
2026-04-02 14:08:38 [INFO] [berlingo] [STATS] ANALYSEUR LEBONCOIN — Base: /home/ubuntu/app/db/lbc.sqlite, Figures: /home/ubuntu/app/stats/berlingo/figures, Modele: berlingo, Graphiques: Non
2026-04-02 14:08:41 [INFO] [berlingo] [STATS] Using categorical units to plot a list of strings that are all parsable as floats or dates. If these strings should be plotted as numbers, cast to the appropriate data type before plotting.
2026-04-02 14:08:41 [INFO] [berlingo] [STATS] Using categorical units to plot a list of strings that are all parsable as floats or dates. If these strings should be plotted as numbers, cast to the appropriate data type before plotting.
2026-04-02 14:08:42 [INFO] [berlingo] [STATS] M05 — Extraction LLM des titres (GPT-5 Nano)
2026-04-02 14:08:42 [INFO] [berlingo] [STATS] Annonces sans evaluation LLM : 2
2026-04-02 14:09:04 [INFO] [berlingo] [STATS] HTTP Request: POST https://api.openai.com/v1/chat/completions "HTTP/1.1 200 OK"
2026-04-02 14:09:04 [INFO] [berlingo] [STATS] LLM OUTPUT batch 1/1: 2 resultats extraits (modele=gpt-5-nano)
2026-04-02 14:09:04 [INFO] [berlingo] [STATS] Resultats extraits : 2
2026-04-02 14:09:04 [INFO] [berlingo] [STATS] Evaluations inserees : 2
2026-04-02 14:09:04 [INFO] [berlingo] [STATS]   stats_descriptives : 5 lignes insérées
2026-04-02 14:09:04 [INFO] [berlingo] [STATS]   modele_regression : 2 lignes insérées
2026-04-02 14:09:04 [INFO] [berlingo] [STATS]   referentiel_prix : 59 segments insérés
2026-04-02 14:09:05 [INFO] [berlingo] [STATS]   ads.deal_columns : 613 annonces mises à jour
2026-04-02 14:09:05 [INFO] [berlingo] [STATS] ANALYSE TERMINEE en 26.1s — 613 annonces (run #272) — Modele: berlingo
2026-04-02 14:09:05 [INFO] [berlingo] [LLM] $ /home/ubuntu/app/.venv/bin/python -m stats.m05_llm_title_analysis --model berlingo
2026-04-02 14:09:05 [INFO] [berlingo] [LLM] M05 — Extraction LLM des titres (GPT-5 Nano)
2026-04-02 14:09:06 [INFO] [berlingo] [LLM] Annonces sans evaluation LLM : 0
2026-04-02 14:09:06 [INFO] [berlingo] [LLM] Toutes les annonces ont deja ete analysees.