Skip to content

Instantly share code, notes, and snippets.

@ivorscott

ivorscott/products.sql

Created June 5, 2020 07:43
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ivorscott/a85f69ed2ae0a0d48472141ec5343a4f to your computer and use it in GitHub Desktop.
Save ivorscott/a85f69ed2ae0a0d48472141ec5343a4f to your computer and use it in GitHub Desktop.
Download ZIP
Raw
products.sql
-- ./api/internal/schema/seeds/products.sql
INSERT INTO products (id, name, price, description, created) VALUES
('cbef5139-323f-48b8-b911-dc9be7d0bc07','Xbox One X', 499.00, 'Eighth-generation home video game console developed by Microsoft.','2019-01-01 00:00:01.000001+00'),
('ce93a886-3a0e-456b-b7f5-8652d2de1e8f','Playstation 4', 299.00, 'Eighth-generation home video game console developed by Sony Interactive Entertainment.','2019-01-01 00:00:01.000001+00'),
('faa25b57-7031-4b37-8a89-de013418deb0','Nintendo Switch', 299.00, 'Hybrid console that can be used as a stationary and portable device developed by Nintendo.','2019-01-01 00:00:01.000001+00')
ON CONFLICT DO NOTHING;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment