2025-12-08 09:46:05.083 | INFO     | __main__:train:41 - 🚀 Début de l'entraînement du modèle ML...
2025-12-08 09:46:05.089 | INFO     | feature_extractor:connect:26 - ✅ Connexion DB établie
2025-12-08 09:46:05.089 | INFO     | feature_extractor:get_training_data:53 - 🔍 Extraction des données d'entraînement...
2025-12-08 09:46:05.311 | INFO     | feature_extractor:close:33 - Connexion DB fermée
2025-12-08 09:46:05.312 | ERROR    | __main__:<module>:237 - ❌ Erreur: Execution failed on sql '
        SELECT
            e.id as entry_id,
            e.race_id,
            e.horse_id,
            e.jockey_id,
            e.trainer_id,
            e.finish_position,
            e.betting_rank,
            e.final_odds,
            e.weight_carried,
            e.draw_number,

            h.name as horse_name,
            h.age as horse_age,
            h.sex as horse_sex,
            h.total_runs,
            h.total_wins,
            h.total_places,
            h.total_earnings,

            j.name as jockey_name,
            j.total_wins as jockey_wins,
            j.win_rate as jockey_win_rate,

            t.name as trainer_name,
            t.total_wins as trainer_wins,
            t.win_rate as trainer_win_rate,

            r.race_date,
            r.race_time,
            r.distance,
            r.surface,
            r.going,
            r.race_type,
            r.race_category,
            r.prize_money,
            r.weather,
            r.temperature,
            r.wind_speed,
            r.wind_direction,
            r.num_runners,

            tr.name as track_name,
            tr.track_type

        FROM entries e
        JOIN horses h ON e.horse_id = h.id
        LEFT JOIN jockeys j ON e.jockey_id = j.id
        LEFT JOIN trainers t ON e.trainer_id = t.id
        JOIN races r ON e.race_id = r.id
        JOIN tracks tr ON r.track_id = tr.id
        WHERE e.finish_position IS NOT NULL  -- Seulement courses terminées
         AND r.race_date >= '2024-01-01' ORDER BY r.race_date DESC, r.race_time DESC': (1146, "Table 'tereeeehipp.entries' doesn't exist")
2025-12-08 09:49:27.530 | INFO     | __main__:train:41 - 🚀 Début de l'entraînement du modèle ML...
2025-12-08 09:49:27.536 | INFO     | feature_extractor:connect:26 - ✅ Connexion DB établie
2025-12-08 09:49:27.536 | INFO     | feature_extractor:get_training_data:53 - 🔍 Extraction des données d'entraînement...
2025-12-08 09:49:27.675 | INFO     | feature_extractor:close:33 - Connexion DB fermée
2025-12-08 09:49:27.676 | ERROR    | __main__:<module>:237 - ❌ Erreur: Execution failed on sql '
        SELECT
            e.id as entry_id,
            e.race_id,
            e.horse_id,
            e.jockey_id,
            e.trainer_id,
            e.finish_position,
            e.betting_rank,
            e.final_odds,
            e.weight_carried,
            e.draw_number,

            h.name as horse_name,
            h.age as horse_age,
            h.sex as horse_sex,
            h.total_runs,
            h.total_wins,
            h.total_places,
            h.total_earnings,

            j.name as jockey_name,
            j.total_wins as jockey_wins,
            j.win_rate as jockey_win_rate,

            t.name as trainer_name,
            t.total_wins as trainer_wins,
            t.win_rate as trainer_win_rate,

            r.race_date,
            r.race_time,
            r.distance,
            r.surface,
            r.going,
            r.race_type,
            r.race_category,
            r.prize_money,
            r.weather,
            r.temperature,
            r.wind_speed,
            r.wind_direction,
            r.num_runners,

            tr.name as track_name,
            tr.track_type

        FROM race_entries e
        JOIN horses h ON e.horse_id = h.id
        LEFT JOIN jockeys j ON e.jockey_id = j.id
        LEFT JOIN trainers t ON e.trainer_id = t.id
        JOIN races r ON e.race_id = r.id
        JOIN tracks tr ON r.track_id = tr.id
        WHERE e.finish_position IS NOT NULL  -- Seulement courses terminées
         AND r.race_date >= '2024-01-01' ORDER BY r.race_date DESC, r.race_time DESC': (1054, "Unknown column 'e.finish_position' in 'field list'")
2025-12-08 09:50:08.749 | INFO     | __main__:train:41 - 🚀 Début de l'entraînement du modèle ML...
2025-12-08 09:50:08.755 | INFO     | feature_extractor:connect:26 - ✅ Connexion DB établie
2025-12-08 09:50:08.756 | INFO     | feature_extractor:get_training_data:53 - 🔍 Extraction des données d'entraînement...
2025-12-08 09:50:08.902 | INFO     | feature_extractor:close:33 - Connexion DB fermée
2025-12-08 09:50:08.903 | ERROR    | __main__:<module>:237 - ❌ Erreur: Execution failed on sql '
        SELECT
            e.id as entry_id,
            e.race_id,
            e.horse_id,
            e.jockey_id,
            e.trainer_id,
            e.finish_position,
            e.betting_rank,
            e.final_odds,
            e.weight_carried,
            e.draw_number,

            h.name as horse_name,
            h.age as horse_age,
            h.sex as horse_sex,
            h.total_runs,
            h.total_wins,
            h.total_places,
            h.total_earnings,

            j.name as jockey_name,
            j.total_wins as jockey_wins,
            j.win_rate as jockey_win_rate,

            t.name as trainer_name,
            t.total_wins as trainer_wins,
            t.win_rate as trainer_win_rate,

            r.race_date,
            r.race_time,
            r.distance,
            r.surface,
            r.going,
            r.race_type,
            r.race_category,
            r.prize_money,
            r.weather,
            r.temperature,
            r.wind_speed,
            r.wind_direction,
            r.num_runners,

            tr.name as track_name,
            tr.track_type

        FROM race_entries e
        JOIN horses h ON e.horse_id = h.id
        LEFT JOIN jockeys j ON e.jockey_id = j.id
        LEFT JOIN trainers t ON e.trainer_id = t.id
        JOIN races r ON e.race_id = r.id
        JOIN tracks tr ON r.track_id = tr.id
        WHERE e.finish_position IS NOT NULL  -- Seulement courses terminées
         AND r.race_date >= '2024-01-01' ORDER BY r.race_date DESC, r.race_time DESC': (1054, "Unknown column 'e.finish_position' in 'field list'")
2025-12-08 09:59:33.499 | INFO     | __main__:train:41 - 🚀 Début de l'entraînement du modèle ML...
2025-12-08 09:59:33.505 | INFO     | feature_extractor:connect:26 - ✅ Connexion DB établie
2025-12-08 09:59:33.506 | INFO     | feature_extractor:get_training_data:53 - 🔍 Extraction des données d'entraînement...
2025-12-08 09:59:33.693 | INFO     | feature_extractor:close:33 - Connexion DB fermée
2025-12-08 09:59:33.694 | ERROR    | __main__:<module>:237 - ❌ Erreur: Execution failed on sql '
        SELECT
            e.id as entry_id,
            e.race_id,
            e.horse_id,
            e.jockey_id,
            e.trainer_id,
            e.final_position,
            e.betting_rank,
            e.final_odds,
            e.weight_carried,
            e.stall_number,

            h.name as horse_name,
            h.age as horse_age,
            h.sex as horse_sex,
            h.total_runs,
            h.total_wins,
            h.total_places,
            h.total_earnings,

            j.name as jockey_name,
            j.total_wins as jockey_wins,
            j.win_rate as jockey_win_rate,

            t.name as trainer_name,
            t.total_wins as trainer_wins,
            t.win_rate as trainer_win_rate,

            r.race_date,
            r.race_time,
            r.distance,
            r.surface,
            r.going,
            r.race_type,
            r.race_category,
            r.prize_money,
            r.weather,
            r.temperature,
            r.wind_speed,
            r.wind_direction,
            r.num_runners,

            tr.name as track_name,
            tr.track_type

        FROM race_entries e
        JOIN horses h ON e.horse_id = h.id
        LEFT JOIN jockeys j ON e.jockey_id = j.id
        LEFT JOIN trainers t ON e.trainer_id = t.id
        JOIN races r ON e.race_id = r.id
        JOIN tracks tr ON r.track_id = tr.id
        WHERE e.final_position IS NOT NULL  -- Seulement courses terminées
         AND r.race_date >= '2024-01-01' ORDER BY r.race_date DESC, r.race_time DESC': (1054, "Unknown column 'h.age' in 'field list'")