data.sql
1.19 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
MERGE INTO authority m
USING (
SELECT
'ROLE_ADMIN' as authority_name
) s
ON
m.authority_name = s.authority_name
WHEN NOT MATCHED THEN
INSERT (authority_name) VALUES (s.authority_name);
MERGE INTO authority m
USING (
SELECT
'ROLE_USER' as authority_name
) s
ON
m.authority_name = s.authority_name
WHEN NOT MATCHED THEN
INSERT (authority_name) VALUES (s.authority_name);
MERGE INTO users m
USING (
SELECT
true as activated,
'sangkiham' as nickname,
'$2a$10$nyHQj.Nj2tID4UzIkd1/SuMeYwlKaaHT8Gi3Wgg2x/h9K9qLQciLO' as password,
'sangkiham' as username
) s
ON
m.username = s.username
WHEN MATCHED THEN
UPDATE SET
nickname = s.nickname
, activated = s.activated
, password = s.password
WHEN NOT MATCHED THEN
INSERT (activated, nickname, password, username) VALUES (s.activated, s.nickname, s.password, s.username);
MERGE INTO user_authority m
USING (
SELECT
(SELECT user_id FROM users WHERE username = 'sangkiham') as user_id,
'ROLE_ADMIN' as authority_name
) s
ON
m.user_id = s.user_id
and m.authority_name = s.authority_name
WHEN NOT MATCHED THEN
INSERT (user_id, authority_name) VALUES (s.user_id, s.authority_name);