Administration

2026-04-10 20:07:41 [INFO] [berlingo] [LLM] [3/8] BERLINGO (brand=citroen, pages=auto)
2026-04-10 20:07:41 [INFO] [berlingo] [LLM] URL: https://www.leboncoin.fr/recherche?category=5&text=berlingo+xl&u_utility_brand=C...
2026-04-10 20:07:41 [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-10 20:07:42 [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-10 20:07:45 [INFO] [berlingo] [SEARCH] 35 annonces recuperees (total: 35)
2026-04-10 20:07:45 [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-10 20:07:47 [INFO] [berlingo] [SEARCH] 35 annonces recuperees (total: 70)
2026-04-10 20:07:47 [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-10 20:07:50 [INFO] [berlingo] [SEARCH] 35 annonces recuperees (total: 105)
2026-04-10 20:07:50 [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-10 20:07:52 [INFO] [berlingo] [SEARCH] 35 annonces recuperees (total: 140)
2026-04-10 20:07:52 [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-10 20:07:54 [INFO] [berlingo] [SEARCH] 35 annonces recuperees (total: 175)
2026-04-10 20:07:54 [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-10 20:07:56 [INFO] [berlingo] [SEARCH] 35 annonces recuperees (total: 210)
2026-04-10 20:07:56 [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-10 20:07:58 [INFO] [berlingo] [SEARCH] 35 annonces recuperees (total: 245)
2026-04-10 20:07:58 [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-10 20:08:01 [INFO] [berlingo] [SEARCH] 35 annonces recuperees (total: 280)
2026-04-10 20:08:01 [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-10 20:08:03 [INFO] [berlingo] [SEARCH] 35 annonces recuperees (total: 315)
2026-04-10 20:08:03 [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-10 20:08:05 [INFO] [berlingo] [SEARCH] 35 annonces recuperees (total: 350)
2026-04-10 20:08:05 [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-10 20:08:08 [INFO] [berlingo] [SEARCH] 17 annonces recuperees (total: 367)
2026-04-10 20:08:08 [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-10 20:08:09 [INFO] [berlingo] [SEARCH] Page 12 : aucune annonce, arret de la pagination.
2026-04-10 20:08:09 [INFO] [berlingo] [SEARCH] Termine : 367 annonces au total dans /home/ubuntu/app/leboncoin_ads_berlingo_20260410_200742.csv
2026-04-10 20:08:09 [INFO] [berlingo] [SEARCH] CSV : leboncoin_ads_berlingo_20260410_200742.csv
2026-04-10 20:08:09 [INFO] [berlingo] [IMPORT] $ /home/ubuntu/app/.venv/bin/python -m db.migrate_csv --input /home/ubuntu/app/leboncoin_ads_berlingo_20260410_200742.csv --db /home/ubuntu/app/db/lbc.sqlite --model berlingo
2026-04-10 20:08:09 [INFO] [berlingo] [IMPORT] Model override : berlingo
2026-04-10 20:08:09 [INFO] [berlingo] [IMPORT] MIGRATION CSV -> SQLite unifie
2026-04-10 20:08:09 [INFO] [berlingo] [IMPORT] Fichier: leboncoin_ads_berlingo_20260410_200742.csv
2026-04-10 20:08:09 [INFO] [berlingo] [IMPORT] Schéma initialisé dans /home/ubuntu/app/db/lbc.sqlite
2026-04-10 20:08:10 [INFO] [berlingo] [IMPORT] 367 lus, 367 inseres, 0 ignores, 0 erreurs
2026-04-10 20:08:10 [INFO] [berlingo] [IMPORT] TOTAL : 367 lus, 367 inseres — Base : /home/ubuntu/app/db/lbc.sqlite
2026-04-10 20:08:10 [INFO] [berlingo] [IMPORT] 11514 annonces en base
2026-04-10 20:08:10 [INFO] [berlingo] [AVAILABILITY] $ /home/ubuntu/app/.venv/bin/python /home/ubuntu/app/scripts/check_availability.py --csv /home/ubuntu/app/leboncoin_ads_berlingo_20260410_200742.csv --brand citroen --model berlingo --db /home/ubuntu/app/db/lbc.sqlite
2026-04-10 20:08:10 [INFO] [berlingo] [AVAILABILITY] CHECK DISPONIBILITE — CSV: leboncoin_ads_berlingo_20260410_200742.csv, Brand: citroen, Model: berlingo
2026-04-10 20:08:10 [INFO] [berlingo] [AVAILABILITY] 366 list_id lus dans le CSV.
2026-04-10 20:08:10 [INFO] [berlingo] [AVAILABILITY] 373 annonces actives en base pour citroen berlingo.
2026-04-10 20:08:10 [INFO] [berlingo] [AVAILABILITY] 7 annonce(s) marquées indisponibles.
2026-04-10 20:08:10 [INFO] [berlingo] [AVAILABILITY] CSV: 366, Actives DB: 373, Absentes: 7
2026-04-10 20:08:10 [INFO] [berlingo] [AVAILABILITY] Marquees indisponibles: 7
2026-04-10 20:08:10 [INFO] [berlingo] [DETAIL] $ /home/ubuntu/app/.venv/bin/python -m crawler.leboncoin_ad_detail --model berlingo --delay 0.5 --limit 200
2026-04-10 20:08:10 [INFO] [berlingo] [DETAIL] ENRICHISSEMENT AD DETAIL — Modele: berlingo — Limite: 200
2026-04-10 20:08:10 [INFO] [berlingo] [DETAIL] Schéma initialisé dans /home/ubuntu/app/db/lbc.sqlite
2026-04-10 20:08:10 [INFO] [berlingo] [DETAIL] 4 annonce(s) à enrichir (modèle: berlingo)
2026-04-10 20:08:17 [INFO] [berlingo] [DETAIL] RESULTAT : 4 traitee(s), 4 enrichies, 0 introuvables, 0 erreurs
2026-04-10 20:08:17 [INFO] [berlingo] [STATS] $ /home/ubuntu/app/.venv/bin/python -m stats.main --model berlingo --skip-plots
2026-04-10 20:08:17 [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-10 20:08:20 [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-10 20:08:20 [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-10 20:08:21 [INFO] [berlingo] [STATS] M05 — Extraction LLM des titres (GPT-5 Nano)
2026-04-10 20:08:21 [INFO] [berlingo] [STATS] Annonces sans evaluation LLM : 4
2026-04-10 20:08:22 [INFO] [berlingo] [STATS] HTTP Request: POST https://api.openai.com/v1/chat/completions "HTTP/1.1 400 Bad Request"
2026-04-10 20:08:22 [WARNING] [berlingo] [STATS] OpenAI appel échoué (modèle=gpt-5-nano, tentative=1/3): Error code: 400 - {'error': {'message': "We could not parse the JSON body of your request. (HINT: This likely means you aren't using your HTTP library correctly. The OpenAI API expects a JSON payload, but what was sent was not valid JSON. If you have trouble figuring out how to fix this, please contact us through our help center at help.openai.com.)", 'type': 'invalid_request_error', 'param': None, 'code': None}}
2026-04-10 20:09:03 [INFO] [berlingo] [STATS] HTTP Request: POST https://api.openai.com/v1/chat/completions "HTTP/1.1 200 OK"
2026-04-10 20:09:03 [INFO] [berlingo] [STATS] LLM OUTPUT batch 1/1: 4 resultats extraits (modele=gpt-5-nano)
2026-04-10 20:09:03 [INFO] [berlingo] [STATS] Resultats extraits : 4
2026-04-10 20:09:03 [INFO] [berlingo] [STATS] Evaluations inserees : 4
2026-04-10 20:09:03 [INFO] [berlingo] [STATS]   stats_descriptives : 5 lignes insérées
2026-04-10 20:09:03 [INFO] [berlingo] [STATS]   modele_regression : 2 lignes insérées
2026-04-10 20:09:03 [INFO] [berlingo] [STATS]   referentiel_prix : 60 segments insérés
2026-04-10 20:09:04 [INFO] [berlingo] [STATS]   ads.deal_columns : 690 annonces mises à jour
2026-04-10 20:09:04 [INFO] [berlingo] [STATS] ANALYSE TERMINEE en 46.2s — 690 annonces (run #457) — Modele: berlingo
2026-04-10 20:09:04 [INFO] [berlingo] [LLM] $ /home/ubuntu/app/.venv/bin/python -m stats.m05_llm_title_analysis --model berlingo
2026-04-10 20:09:04 [INFO] [berlingo] [LLM] M05 — Extraction LLM des titres (GPT-5 Nano)
2026-04-10 20:09:04 [INFO] [berlingo] [LLM] Annonces sans evaluation LLM : 0
2026-04-10 20:09:04 [INFO] [berlingo] [LLM] Toutes les annonces ont deja ete analysees.