Mercurial > hg > LGDataverses

comparison scripts/migration/migrate_users.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 -- users
3 -----------------------
4
5 insert into builtinuser( id, affiliation, email, firstname, lastname, position, username)
6 select id, institution, email, firstname, lastname, position, username
7 from _dvn3_vdcuser;
8
9 insert into authenticateduser( id, affiliation, email, firstname, lastname, position, useridentifier, superuser)
10 select id, institution, email, firstname, lastname, position, username, false
11 from _dvn3_vdcuser;
12
13 insert into authenticateduserlookup( authenticationproviderid, persistentuserid, authenticateduser_id)
14 select 'builtin', username, id
15 from _dvn3_vdcuser;
16
17 -----------------------
18 -- groups
19 -----------------------
20
21 -- only copy over groups that have users
22 insert into explicitgroup( id, description, displayname, groupalias, groupaliasinowner, owner_id)
23 select id, friendlyname, friendlyname, '1-'||name, name, 1
24 from _dvn3_usergroup
25 where id in (select usergroups_id from _dvn3_vdcuser_usergroup);
26
27 insert into explicitgroup_authenticateduser( explicitgroup_id, containedauthenticatedusers_id)
28 select usergroups_id, users_id
29 from _dvn3_vdcuser_usergroup;
30
31 -----------------------
32 -- reset sequences
33 -----------------------
34
35 SELECT setval('builtinuser_id_seq', (SELECT MAX(id) FROM builtinuser));
36 SELECT setval('authenticateduser_id_seq', (SELECT MAX(id) FROM authenticateduser));
37 SELECT setval('explicitgroup_id_seq', (SELECT MAX(id) FROM explicitgroup));