fixed tests in dao
@@ -13,10 +13,11 @@ INSERT INTO users (id,
language_id)
VALUES (1, current_date, 'foo@bar.com', 1, 'foo', current_date, 1, 1, 'quux',1),
(2, current_date, 'foot@bar.com', 1, 'doo', current_date, 1, 1, 'asdasd',2);
-INSERT INTO custom_shopping_list_items(id, text, user_id, status, date_completed)
-VALUES (1, 'Buy a bamboo brush', 1, 'DONE', '2020-09-10 20:00:001'),
- (2, 'Buy composter', 1, 'DONE', '2020-09-10 20:00:001'),
- (3, 'Buy composter 2', 1, 'DONE', '2020-09-10 20:00:001'),
- (4, 'Start sorting trash', 1, 'ACTIVE', null),
- (5, 'Start recycling batteries', 1, 'ACTIVE', null),
- (6, 'Finish book about vegans', 2, 'ACTIVE', null);
+INSERT INTO habits(id, image, default_duration) VALUES (1, 'image1', 14);
+INSERT INTO custom_shopping_list_items(id, text, user_id, status, habit_id, date_completed)
+VALUES (1, 'Buy a bamboo brush', 1, 'DONE', 1, '2020-09-10 20:00:001'),
+ (2, 'Buy composter', 1, 'DONE', 1, '2020-09-10 20:00:001'),
+ (3, 'Buy composter 2', 1, 'DONE', 1, '2020-09-10 20:00:001'),
+ (4, 'Start sorting trash', 1, 'ACTIVE', 1, null),
+ (5, 'Start recycling batteries', 1, 'ACTIVE', 1, null),
+ (6, 'Finish book about vegans', 2, 'ACTIVE', 1, null);
