-
Notifications
You must be signed in to change notification settings - Fork 0
/
user_test.sql
41 lines (36 loc) · 1.05 KB
/
user_test.sql
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
INSERT INTO "sourcing"."event" (
"uuid", "event", "type", "data"
)
VALUES (
'1e006893-bfe2-4f5c-9549-389d6ef75376', 'create', 'user', '{"username": "jsmith", "email": "john.smith@email.com", "password": "1234"}'
);
INSERT INTO "sourcing"."event" (
"uuid", "event", "type", "data"
)
VALUES (
'1e006893-bfe2-4f5c-9549-389d6ef75376', 'update', 'user', '{"password": "12345678"}'
);
INSERT INTO "sourcing"."event" (
"uuid", "event", "type", "data"
)
VALUES (
'1e006893-bfe2-4f5c-9549-389d6ef75376', 'update', 'user', '{"password": "abcd1234"}'
);
INSERT INTO "sourcing"."event" (
"uuid", "event", "type"
)
VALUES (
'1e006893-bfe2-4f5c-9549-389d6ef75376', 'delete', 'user'
);
INSERT INTO "sourcing"."event" (
"event", "type", "data", "timestamp"
)
VALUES (
'create', 'user', '{"username": "johnS", "email": "john.smith@email.com", "password": "a1b2c3d4"}', now() + INTERVAL '60 second'
);
INSERT INTO "sourcing"."event" (
"event", "data", "timestamp"
)
VALUES (
'rollback', '{"id": 3}', now() + INTerval '60 second'
);