From cdb87fd0880664d20ee40ce367fe6a2f3559ed7c Mon Sep 17 00:00:00 2001 From: Bryan Newbold Date: Tue, 15 May 2018 20:53:32 -0700 Subject: include dummy data by default --- .../2018-05-16-033858_dummy_data/down.sql | 1 + .../migrations/2018-05-16-033858_dummy_data/up.sql | 58 ++++++++++++++++++++++ 2 files changed, 59 insertions(+) create mode 100644 rust/migrations/2018-05-16-033858_dummy_data/down.sql create mode 100644 rust/migrations/2018-05-16-033858_dummy_data/up.sql diff --git a/rust/migrations/2018-05-16-033858_dummy_data/down.sql b/rust/migrations/2018-05-16-033858_dummy_data/down.sql new file mode 100644 index 00000000..291a97c5 --- /dev/null +++ b/rust/migrations/2018-05-16-033858_dummy_data/down.sql @@ -0,0 +1 @@ +-- This file should undo anything in `up.sql` \ No newline at end of file diff --git a/rust/migrations/2018-05-16-033858_dummy_data/up.sql b/rust/migrations/2018-05-16-033858_dummy_data/up.sql new file mode 100644 index 00000000..4775aadf --- /dev/null +++ b/rust/migrations/2018-05-16-033858_dummy_data/up.sql @@ -0,0 +1,58 @@ + +-- Fake data at the raw SQL level, for early development and testing + +BEGIN; + +INSERT INTO editor (username, is_admin) VALUES + ('admin', true), + ('claire', true), + ('doug', false); + +INSERT INTO editgroup (editor_id, description) VALUES + (1, 'first edit ever!'), + (1, 'another one!'), + (3, 'user edit'), + (2, 'uncommited edit'), + (1, 'journal edit'), + (1, 'another journal edit'); + +INSERT INTO editor (username, is_admin, active_editgroup_id) VALUES + ('bnewbold', true, 4); + +INSERT INTO changelog (editgroup_id) VALUES + (1), + (2), + (3), + (4), + (5); + +INSERT INTO creator_rev (name, orcid) VALUES + ('Grace Hopper', null), + ('Emily Noethe', null), + ('Christine Moran', '0000-0003-2088-7465'); + +INSERT INTO creator_ident (id, is_live, rev_id, redirect_id) VALUES + ('f1f046a3-45c9-4b99-adce-000000000001', true, 1, null), + ('f1f046a3-45c9-4b99-adce-000000000002', true, 2, null), + ('f1f046a3-45c9-4b99-adce-000000000003', true, 3, null), + ('f1f046a3-45c9-4b99-adce-000000000004', false, 2, null); + +INSERT INTO creator_edit (ident_id, rev_id, redirect_id, editgroup_id) VALUES + ('f1f046a3-45c9-4b99-adce-000000000001', 1, null, 1), + ('f1f046a3-45c9-4b99-adce-000000000002', 2, null, 2), + ('f1f046a3-45c9-4b99-adce-000000000003', 3, null, 3), + ('f1f046a3-45c9-4b99-adce-000000000004', 2, null, 4); + +INSERT INTO container_rev (name, issn) VALUES + ('Journal of Trivial Results', '1234-5678'), + ('MySpace Blog', null); + +INSERT INTO container_ident (id, is_live, rev_id, redirect_id) VALUES + ('f1f046a3-45c9-4b99-cccc-000000000001', true, 1, null), + ('f1f046a3-45c9-4b99-cccc-000000000002', true, 2, null); + +INSERT INTO container_edit (ident_id, rev_id, redirect_id, editgroup_id) VALUES + ('f1f046a3-45c9-4b99-cccc-000000000001', 1, null, 4), + ('f1f046a3-45c9-4b99-cccc-000000000002', 2, null, 5); + +COMMIT; -- cgit v1.2.3