From 9889bda4783f56a535a5d42c72628fd48c2ccc1d Mon Sep 17 00:00:00 2001 From: Bryan Newbold Date: Mon, 13 May 2019 18:15:43 -0700 Subject: sql schema: more test/demo helpers in new schema --- rust/migrations/2019-05-09-051834_v0.3/up.sql | 19 ++++++++++++++++++- 1 file changed, 18 insertions(+), 1 deletion(-) (limited to 'rust') diff --git a/rust/migrations/2019-05-09-051834_v0.3/up.sql b/rust/migrations/2019-05-09-051834_v0.3/up.sql index aca02c85..6b8fc2e2 100644 --- a/rust/migrations/2019-05-09-051834_v0.3/up.sql +++ b/rust/migrations/2019-05-09-051834_v0.3/up.sql @@ -72,9 +72,26 @@ CREATE INDEX IF NOT EXISTS work_edit_ident_idx ON work_edit(ident_id); -- IMPORTANT: don't create new entities here, only mutate existing +BEGIN; + +UPDATE release_rev SET + subtitle = 'and here a reasonable-length subtitle', + withdrawn_status = 'withdrawn', + withdrawn_date = '2018-06-07', + withdrawn_year = '2018', + number = 'RN9594', + version = 'v12' +WHERE id = '00000000-0000-0000-4444-FFF000000002'; + INSERT INTO release_rev_extid (release_rev, extid_type, value) VALUES ('00000000-0000-0000-4444-FFF000000002', 'isbn13', '978-3-16-148410-0'), ('00000000-0000-0000-4444-FFF000000002', 'arxiv', '1905.03769v1'), ('00000000-0000-0000-4444-FFF000000002', 'jstor', '1819117828'), - ('00000000-0000-0000-4444-FFF000000002', 'ark', 'ark:/asdf/924'), + ('00000000-0000-0000-4444-FFF000000002', 'ark', 'ark:/13030/m53r5pzm'), ('00000000-0000-0000-4444-FFF000000002', 'mag', '992489213'); + +UPDATE release_contrib SET given_name = 'John', surname = 'Ioannidis' WHERE release_rev = '00000000-0000-0000-4444-FFF000000003'; + +UPDATE webcapture_rev_cdx SET size_bytes = 12345 WHERE webcapture_rev = '00000000-0000-0000-7777-FFF000000003'; + +commit; -- cgit v1.2.3