forked from OpenShock/API
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathtestData.sql
More file actions
23 lines (19 loc) · 1.04 KB
/
testData.sql
File metadata and controls
23 lines (19 loc) · 1.04 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
-- Insert test user with password OpenShock123!
INSERT INTO public.users (id, name, email, password_hash, email_activated, roles)
VALUES ('50e14f43-dd4e-412f-864d-78943ea28d91',
'OpenShock-Test',
'test@openshock.org',
'bcrypt:$2a$11$bCkcqpsNgFt1.DB33OuLhOsqVbDUp.BIvKVOIYvEO8Hyf26fV6B4y', --- OpenShock123!
true,
ARRAY['admin']::role_type[]);
INSERT INTO public.devices (id, owner, name, token)
VALUES ('7472cba2-6037-488f-b5aa-53b1c39fe450',
'50e14f43-dd4e-412f-864d-78943ea28d91',
'Test Hub',
'ro6DglfhzM@hH1*P5&TOBsY4ipLMSEI4CbY!yNit4V%W&nO*Z9N@H$JzO$mh3D2PvpKL7Sde#6azOs7lBCQq0CovcCg#pX*m&Gt^4S$gCDP@f8eBPB8*q^q*dgdECXKRro6DglfhzM@hH1*P5&TOBsY4ipLMSEI4CbY!yNit4V%W&nO*Z9N@H$JzO$mh3D2PvpKL7Sde#6azOs7lBCQq0CovcCg#pX*m&Gt^4S$gCDP@f8eBPB8*q^q*dgdECXKR');
INSERT INTO public.shockers (id, name, rf_id, device, model)
VALUES ('f73b3d99-44f4-4fbc-9e23-17a310202b07',
'Test Shocker',
'12345',
'7472cba2-6037-488f-b5aa-53b1c39fe450',
'caiXianlin'::shocker_model_type);