Rebasely Beta: data may be purged

examples/storefront Public

SQL · 12 lines · 1.3 KiB · at 80dbc76

-- A small catalog for local development: npm run db:seed (after npm run db:migrate).-- Re-running it resets these products' prices and stock.INSERT INTO products (id, name, description, price_cents, stock, active, created_at, updated_at) VALUES  ('wool-socks', 'Merino wool socks', 'Midweight crew socks in undyed merino. Sold as a pair.', 1800, 40, 1, 1759276800000, 1759276800000),  ('canvas-tote', 'Waxed canvas tote', 'A 20 litre tote in waxed cotton canvas with leather handles.', 4800, 12, 1, 1759276800000, 1759276800000),  ('enamel-mug', 'Enamel camp mug', 'A 350 ml steel mug with a rolled rim. Goes on a stove.', 1600, 60, 1, 1759276800000, 1759276800000),  ('linen-apron', 'Linen work apron', 'Heavy linen with two front pockets and cross-back straps.', 5200, 8, 1, 1759276800000, 1759276800000),  ('beeswax-candle', 'Beeswax pillar candle', 'Hand-poured, about 40 hours of burn time.', 2200, 0, 1, 1759276800000, 1759276800000),  ('field-notebook', 'Field notebook, 3 pack', 'Pocket notebooks with dot grid pages and a kraft cover.', 1400, 100, 1, 1759276800000, 1759276800000)ON CONFLICT (id) DO UPDATE SET  name = excluded.name, description = excluded.description, price_cents = excluded.price_cents,  stock = excluded.stock, active = excluded.active, updated_at = excluded.updated_at;