seed_postgres.sql

-- Run inside the Postgres container/database to create test data.
CREATE TABLE IF NOT EXISTS sales (
  id SERIAL PRIMARY KEY,
  month DATE NOT NULL,
  region TEXT NOT NULL,
  product TEXT NOT NULL,
  revenue NUMERIC NOT NULL,
  units_sold INTEGER NOT NULL
);

INSERT INTO sales (month, region, product, revenue, units_sold) VALUES
('2025-01-01','East','Widget',12500,420),
('2025-02-01','East','Widget',13800,460),
('2025-03-01','East','Widget',15200,505),
('2025-04-01','East','Widget',14100,470),
('2025-05-01','East','Widget',16800,560),
('2025-06-01','East','Widget',18200,605),
('2025-01-01','West','Gadget',9200,310),
('2025-02-01','West','Gadget',9700,325),
('2025-03-01','West','Gadget',11100,370),
('2025-04-01','West','Gadget',10500,350),
('2025-05-01','West','Gadget',12300,410),
('2025-06-01','West','Gadget',13900,460),
('2025-01-01','North','Gizmo',7600,255),
('2025-02-01','North','Gizmo',8100,270),
('2025-03-01','North','Gizmo',7900,265),
('2025-04-01','North','Gizmo',8800,295),
('2025-05-01','North','Gizmo',9400,315),
('2025-06-01','North','Gizmo',10100,335);