seed.sql

DELETE FROM TimeEntries;
DELETE FROM Projects;

INSERT INTO Projects (Id, Name, ClientName, HourlyRate, IsArchived)
VALUES
  (1, 'Frontend Revamp – Marketing Dashboard', 'BrightPixel Studio', 55.00, 0),
  (2, 'API Integration – Subscription Billing', 'Acme Finance Group', 65.00, 0),
  (3, 'Maintenance & Support – Logistics Portal', 'SkyRoute Logistics', 45.00, 0);

-- Times are ISO strings; adjust dates to "today" for your timezone.

INSERT INTO TimeEntries (ProjectId, StartTime, EndTime, Description, DurationMinutes) VALUES
  -- Project 1: Frontend Revamp – Marketing Dashboard
  (1, '2025-11-07T09:00:00', '2025-11-07T11:30:00', 'Implement campaign overview cards', 150),
  (1, '2025-11-07T13:00:00', '2025-11-07T15:00:00', 'Fix responsive issues on analytics page', 120),
  (1, '2025-11-06T10:00:00', '2025-11-06T12:15:00', 'Refactor chart components and clean up styles', 135),

  -- Project 2: API Integration – Subscription Billing
  (2, '2025-11-07T08:30:00', '2025-11-07T10:00:00', 'Connect to Stripe sandbox, verify webhooks', 90),
  (2, '2025-11-07T10:30:00', '2025-11-07T12:00:00', 'Implement retry logic for failed charge events', 90),
  (2, '2025-11-05T14:00:00', '2025-11-05T16:00:00', 'Design DTOs and mapping for billing events', 120),

  -- Project 3: Maintenance & Support – Logistics Portal
  (3, '2025-11-07T16:00:00', '2025-11-07T17:00:00', 'Investigate slow queries on shipment list', 60),
  (3, '2025-11-06T15:00:00', '2025-11-06T17:00:00', 'Add health-check endpoint and basic logging', 120);