-
Notifications
You must be signed in to change notification settings - Fork 169
Expand file tree
/
Copy pathpopulateDB.sql
More file actions
25 lines (22 loc) · 1.03 KB
/
populateDB.sql
File metadata and controls
25 lines (22 loc) · 1.03 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
DELETE FROM user_role;
DELETE FROM meal;
DELETE FROM users;
ALTER SEQUENCE global_seq RESTART WITH 100000;
INSERT INTO users (name, email, password)
VALUES ('User', 'user@yandex.ru', 'password'),
('Admin', 'admin@gmail.com', 'admin'),
('Guest', 'guest@gmail.com', 'guest');
INSERT INTO user_role (role, user_id)
VALUES ('USER', 100000),
('ADMIN', 100001),
('USER', 100001);
INSERT INTO meal (date_time, description, calories, user_id)
VALUES ('2020-01-30 10:00:00', 'Завтрак', 500, 100000),
('2020-01-30 13:00:00', 'Обед', 1000, 100000),
('2020-01-30 20:00:00', 'Ужин', 500, 100000),
('2020-01-31 0:00:00', 'Еда на граничное значение', 100, 100000),
('2020-01-31 10:00:00', 'Завтрак', 500, 100000),
('2020-01-31 13:00:00', 'Обед', 1000, 100000),
('2020-01-31 20:00:00', 'Ужин', 510, 100000),
('2020-01-31 14:00:00', 'Админ ланч', 510, 100001),
('2020-01-31 21:00:00', 'Админ ужин', 1500, 100001);