summaryrefslogtreecommitdiffstats
path: root/rust/migrations
diff options
context:
space:
mode:
authorBryan Newbold <bnewbold@robocracy.org>2019-05-13 18:15:43 -0700
committerBryan Newbold <bnewbold@robocracy.org>2019-05-13 18:15:43 -0700
commit9889bda4783f56a535a5d42c72628fd48c2ccc1d (patch)
treecfb7b44e7c335518dcdb426c47c41f0d20ea9cb8 /rust/migrations
parente4125f5739791032d822557511011a34f2f3edc3 (diff)
downloadfatcat-9889bda4783f56a535a5d42c72628fd48c2ccc1d.tar.gz
fatcat-9889bda4783f56a535a5d42c72628fd48c2ccc1d.zip
sql schema: more test/demo helpers in new schema
Diffstat (limited to 'rust/migrations')
-rw-r--r--rust/migrations/2019-05-09-051834_v0.3/up.sql19
1 files changed, 18 insertions, 1 deletions
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;