-- Ajout de trajets de test simples en utilisant les données existantes

-- D'abord, vérifions les routes existantes
-- Route 1: Cotonou -> Porto-Novo (company_id=1, distance=35km)
-- Route 2: Porto-Novo -> Cotonou (company_id=1, distance=35km)

-- Ajoutons des trajets pour aujourd'hui et les prochains jours
INSERT INTO trips (route_id, vehicle_id, departure_datetime, arrival_datetime, price, available_seats, status, created_at, updated_at) VALUES
-- Trajets Cotonou -> Porto-Novo pour le 15 août 2025
(1, 1, '2025-08-15 06:00:00', '2025-08-15 07:00:00', 2500, 45, 'scheduled', datetime('now'), datetime('now')),
(1, 1, '2025-08-15 08:00:00', '2025-08-15 09:00:00', 2500, 45, 'scheduled', datetime('now'), datetime('now')),
(1, 1, '2025-08-15 10:00:00', '2025-08-15 11:00:00', 2500, 45, 'scheduled', datetime('now'), datetime('now')),
(1, 1, '2025-08-15 12:00:00', '2025-08-15 13:00:00', 2500, 45, 'scheduled', datetime('now'), datetime('now')),
(1, 1, '2025-08-15 14:00:00', '2025-08-15 15:00:00', 2500, 45, 'scheduled', datetime('now'), datetime('now')),
(1, 1, '2025-08-15 16:00:00', '2025-08-15 17:00:00', 2500, 45, 'scheduled', datetime('now'), datetime('now')),
(1, 1, '2025-08-15 18:00:00', '2025-08-15 19:00:00', 2500, 45, 'scheduled', datetime('now'), datetime('now')),
(1, 1, '2025-08-15 20:00:00', '2025-08-15 21:00:00', 2500, 45, 'scheduled', datetime('now'), datetime('now')),

-- Trajets Porto-Novo -> Cotonou pour le 15 août 2025
(2, 2, '2025-08-15 07:00:00', '2025-08-15 08:00:00', 2500, 30, 'scheduled', datetime('now'), datetime('now')),
(2, 2, '2025-08-15 09:00:00', '2025-08-15 10:00:00', 2500, 30, 'scheduled', datetime('now'), datetime('now')),
(2, 2, '2025-08-15 11:00:00', '2025-08-15 12:00:00', 2500, 30, 'scheduled', datetime('now'), datetime('now')),
(2, 2, '2025-08-15 13:00:00', '2025-08-15 14:00:00', 2500, 30, 'scheduled', datetime('now'), datetime('now')),
(2, 2, '2025-08-15 15:00:00', '2025-08-15 16:00:00', 2500, 30, 'scheduled', datetime('now'), datetime('now')),
(2, 2, '2025-08-15 17:00:00', '2025-08-15 18:00:00', 2500, 30, 'scheduled', datetime('now'), datetime('now')),
(2, 2, '2025-08-15 19:00:00', '2025-08-15 20:00:00', 2500, 30, 'scheduled', datetime('now'), datetime('now')),

-- Trajets pour le 16 août 2025
(1, 1, '2025-08-16 06:00:00', '2025-08-16 07:00:00', 2500, 45, 'scheduled', datetime('now'), datetime('now')),
(1, 1, '2025-08-16 10:00:00', '2025-08-16 11:00:00', 2500, 45, 'scheduled', datetime('now'), datetime('now')),
(1, 1, '2025-08-16 14:00:00', '2025-08-16 15:00:00', 2500, 45, 'scheduled', datetime('now'), datetime('now')),
(1, 1, '2025-08-16 18:00:00', '2025-08-16 19:00:00', 2500, 45, 'scheduled', datetime('now'), datetime('now')),

(2, 2, '2025-08-16 07:00:00', '2025-08-16 08:00:00', 2500, 30, 'scheduled', datetime('now'), datetime('now')),
(2, 2, '2025-08-16 11:00:00', '2025-08-16 12:00:00', 2500, 30, 'scheduled', datetime('now'), datetime('now')),
(2, 2, '2025-08-16 15:00:00', '2025-08-16 16:00:00', 2500, 30, 'scheduled', datetime('now'), datetime('now')),
(2, 2, '2025-08-16 19:00:00', '2025-08-16 20:00:00', 2500, 30, 'scheduled', datetime('now'), datetime('now')),

-- Trajets pour le 17 août 2025
(1, 1, '2025-08-17 08:00:00', '2025-08-17 09:00:00', 2500, 45, 'scheduled', datetime('now'), datetime('now')),
(1, 1, '2025-08-17 12:00:00', '2025-08-17 13:00:00', 2500, 45, 'scheduled', datetime('now'), datetime('now')),
(1, 1, '2025-08-17 16:00:00', '2025-08-17 17:00:00', 2500, 45, 'scheduled', datetime('now'), datetime('now')),

(2, 2, '2025-08-17 09:00:00', '2025-08-17 10:00:00', 2500, 30, 'scheduled', datetime('now'), datetime('now')),
(2, 2, '2025-08-17 13:00:00', '2025-08-17 14:00:00', 2500, 30, 'scheduled', datetime('now'), datetime('now')),
(2, 2, '2025-08-17 17:00:00', '2025-08-17 18:00:00', 2500, 30, 'scheduled', datetime('now'), datetime('now'));