Mercurial > hg > LGDataverses

comparison scripts/migration/migrate_dataverses.sql @ 10:a50cf11e5178

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Rewrite LGDataverse completely upgrading to dataverse4.0
author Zoe Hong <zhong@mpiwg-berlin.mpg.de>
date Tue, 08 Sep 2015 17:00:21 +0200
parents
children
comparison
equal deleted inserted replaced
9:5926d6419569 10:a50cf11e5178
1 ----------------------
2 -- subnetworks
3 -----------------------
4
5 insert into dvobject ( id, owner_id, dtype, createdate, publicationdate, modificationtime, permissionmodificationtime, creator_id, releaseuser_id)
6 select id, 1, 'Dataverse', networkcreated, networkcreated, now(), now(), creator_id, creator_id
7 from _dvn3_vdcnetwork;
8
9 insert into dataverse ( id, affiliation, alias, dataversetype, description, name, defaultcontributorrole_id,
10 facetroot, metadatablockroot, templateroot, guestbookroot, permissionroot, themeroot )
11 select vdcn.id, affiliation, urlalias, 'UNCATEGORIZED', announcements, vdcn.name, dr.id,
12 false, false, false, false, true, true
13 from _dvn3_vdcnetwork vdcn, dataverserole dr
14 where dr.alias = 'editor';
15
16 -- subnetworks use the same contact e-mails as the Dataverse 4.0 root
17 insert into dataversecontact ( contactemail, displayorder, dataverse_id)
18 select dc.contactemail, dc.displayorder, _dvn3_vdcnetwork.id from dataversecontact dc, _dvn3_vdcnetwork
19 where dc.dataverse_id=1;
20
21 -----------------------
22 -- dataverses
23 -----------------------
24
25
26 insert into dvobject ( id, owner_id, dtype, createdate, publicationdate, modificationtime, permissionmodificationtime, creator_id, releaseuser_id)
27 select id, vdcnetwork_id + 1, 'Dataverse', createddate, releasedate, now(), now(), creator_id, creator_id
28 from _dvn3_vdc;
29
30 insert into dataverse ( id, affiliation, alias, dataversetype, description, name, defaultcontributorrole_id,
31 facetroot, metadatablockroot, templateroot, guestbookroot, permissionroot, themeroot )
32 select vdc.id, affiliation, vdc.alias, 'UNCATEGORIZED', announcements, vdc.name, dr.id,
33 false, false, false, false, true, true
34 from _dvn3_vdc vdc, dataverserole dr
35 where dr.alias = 'editor';
36
37 -- this query splits the contact e-mail by , and trims both sides
38 insert into dataversecontact ( contactemail, displayorder, dataverse_id)
39 select trim(unnest(string_to_array(contactemail, ','))), 0, id from _dvn3_vdc;
40
41
42
43 -----------------------
44 -- reset sequences
45 -----------------------
46
47 SELECT setval('dvobject_id_seq', (SELECT MAX(id) FROM dvobject));