-
Notifications
You must be signed in to change notification settings - Fork 44
/
sampletask_dao.go
75 lines (62 loc) · 1.85 KB
/
sampletask_dao.go
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
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
package persistence
import (
"context"
"errors"
"github.com/singerdmx/BulletJournal/daemon/logging"
"time"
"gorm.io/gorm"
)
const LAYOUT = "2006-01-02"
type SampleTaskDao struct {
Ctx context.Context
Db *gorm.DB
}
func NewSampleTaskDao(ctx context.Context, db *gorm.DB) (*SampleTaskDao, error) {
return &SampleTaskDao{
Ctx: ctx,
Db: db, // NewDB(config),
}, nil
}
/**
* Return true if new record
*/
func (s *SampleTaskDao) Upsert(t *SampleTask) (uint64, bool) {
logger := *logging.GetLogger()
prevReport := SampleTask{}
r := s.Db.Where("uid = ?", t.Uid).Last(&prevReport)
if errors.Is(r.Error, gorm.ErrRecordNotFound) {
// If current time is more recent than due date, skip this instance
dueDate, err := time.Parse(LAYOUT, t.DueDate)
if err != nil {
logger.Errorf("due date parse to format yyyy-mm-dd failed, due date: %s, error: %v", t.DueDate, err)
return 0, false
}
if dueDate.Before(time.Now()) {
return 0, false
}
if err := s.Db.Create(&t).Error; err != nil {
logger.Errorf("Create Sample Task Error: %v", err)
return 0, false
}
return prevReport.ID, true
}
// in case controller didn't receive the call
//if t.Raw == prevReport.Raw {
// return 0, false
//}
// Update all tasks referring this sample task if they have different name
if t.Name != prevReport.Name {
s.Db.Exec("update tasks set name = ? where sample_task_id = ?", t.Name, t.ID)
}
// Update the SampleTask for only Content, DueDate, availableBefore, DueTime
s.Db.Model(&t).Where("uid = ?", t.Uid).Select("raw", "content","due_date", "due_time", "available_before", "name").
Updates(map[string]interface{}{
"raw": t.Raw,
"content": t.Content,
"due_date": t.DueDate,
"due_time": t.DueTime,
"available_before": t.AvailableBefore,
"name": t.Name,
})
return prevReport.ID, false
}